Sql Server Database
Resume:
OBIAGELI J OKAFOR
******.********@*****.***
A dynamic SQL Server DBA who learns quickly and can adapt to any aspect of technology. Over 5 years invested in the management of complex SQL Database Servers from 2005 through 2014 with core experiences in the area of:
Disaster Recovery Performance Tuning Database Security
Backups & Recovery Index Maintenance Integration Services
Data Upgrades/Migrations Always On Cluster/AAG High Availability Solutions
SKILLS SUMMARY:
Experience with production support, development, and managing multiple MS SQL Server environments from SQL Server 2005, 2008, 2008R2, 2012, and 2014, on Windows Server 2008, 2008R2, 2012, and 2012R2.
Strong knowledge of backups, restores, recovery models, DBCC commands, clustering, and mirroring.
Configuring new clusters to handle mission-critical databases.
Experience troubleshooting and resolving performance issues related to locking, blocking, deadlocking, database integrity, security, connectivity, log shipping, and SQL Database Servers.
Ability to ensure the technical integrity of corporate databases by protecting against the loss or misuse of information and designing backup/recovery strategies.
Installation and configuration of virtual machines using VMware Workstation.
Accountable for problem solving and troubleshooting SQL Server.
Installation, Tuning, Maintenance, and Upgrades of SQL Server 2005, 2008, 2008R2, 2012, 2014.
Development of database support (T-SQL tuning, Application tuning, SQL).
Proficient in SQL Server 2005, 2008, and 2008R2 database cloning.
Experience with monitoring and performance tools (Spotlight, SQL Sentry, SolarWinds, & sp_WhoIsActive).
Proficient in use of tools like SQL Server Profiler and Windows Performance Monitor.
Experience with Disk and Server configurations for SQL Server.
Experience with setup and administration of SQL Server Database Security environments using Profiles, Database Privileges, and Roles.
Proficient in writing and optimizing T-SQL codes and stored procedures.
Experience with SAN from the workgroup servers to the enterprise servers, providing the computer applications and database resources necessary to drive the data.
Proficient in performance of SQL Server software new installation and upgrades.
Management of multi-terabyte production clustered systems using both ACTIVE-PASSIVE and ACTIVE-ACTIVE Clustering.
Table partitioning, file and file-group management.
Knowledge of High Availability on database servers using log shipping, and SQL Server 2012 AlwaysOn.
Working knowledge of Red Gate SQL Backup Pro and SQL Monitor.
Working knowledge of Idera SQL Safe and Diagnostic Manager.
Developed and modified stored procedures, queries, triggers, views, indexes, and functions.
Experience with monitoring and trouble shooting in 24x7 operations.
Experience using PowerShell (Windows and SQL server).
TECHNICAL SKILLS:
RDBMS: SQL 2005, 2008, 2008R2, 2012, 2014 Database Administration, Clustering, SQL Server Integration Services, Data Modeling, Tuning SQL Profiler in Enterprise Environments.
Operating systems: Windows XP, Windows7, Windows 8, Windows 10, Windows Server 2008, 2008R2, 2012, & 2012R2.
EXPERIENCE:
SQL Server DBA (August 2014 - Present)
The Tech-Edge Group
Part of a team of 7 DBA’s supporting client and in-house SQL Server database systems on various infrastructure projects improving service level agreements by reducing time to deliver database solutions to business.
Interfacing with developers and clients to help them understand their needs based on budget and licensing cost.
Proactively monitoring all instances and databases for any abnormalities.
Managing and monitoring SLAs for uptime and performance of SQL Server databases.
Monitoring and modifying performance using execution plans and index tuning.
Monitoring and maintaining appropriate disk storage requirements for the database.
Installation and configuration of virtual machines utilizing VMware Workstation.
Conducting daily health checks each morning to ensure the completion of overnight maintenance jobs.
Enhancing security control by creating user defined server roles in SQL server 2012 for clients.
Mentoring less experienced team mates on changes and the technology in general.
Performing DBA duties (backups, restores, performance tuning, and capacity analysis of databases).
Set up and administer SQL Server database security environments using database privileges and roles.
Assisting in establishing standards and schedules for database backups by making sure that the backup schedules meet the recovery requirements on a daily, weekly, and monthly basis.
Performing various data migration tasks for mission critical databases.
Experience using PowerShell (Windows and SQL server).
Rebuilding the indexes at regular intervals for better performance.
Analyzing and tuning long running slow queries to optimize system performance.
Experienced with use of performance tools SQL Server Profiler and Windows Performance Monitor.
Proficient with database snapshots, using DMV’s, and performance dash board.
Revised current DR and implemented HA strategies (database mirroring, Always On, and clustering) thereby reducing downtime in the event of any failure.
Managing multi-terabyte clustered production systems using both ACTIVE-PASSIVE and ACTIVE-ACTIVE Clustering.
Setting up, managing, and monitoring log shipping across different secondary servers.
Lead the efforts of the database team in improving CPU consumption for all critical production database servers by tuning queries, databases, instances, etc.
Responsible for setting up and scheduling various tasks by creating maintenance plans.
Monitoring performance and allocated resources to achieve optimum database performance.
Ensuring the technical integrity of databases by protecting against the loss or misuse of information and designing backup/recovery strategies.
Participating in on-call rotation with the team.
SQL Server DBA (January 2012 – July 2014)
Pacific System Inc.
Designed, implemented and upgraded SQL Server 2005, 2008 and 2008R2 databases for mission-critical business.
Experience ensuring the availability of instance and databases via Clustering, Mirroring, and AlwaysOn.
Conducted regular system backups, restores, database performance checks, implemented recovery procedures, and handled performance tuning.
Ensured all server related trouble tickets were resolved with accuracy and in a timely manner.
Created and/or maintained detailed documentation regarding all components of database administration.
Designed the backup and recovery strategies for SQL Server databases to meet our client SLA requirements.
Performed proactive maintenance by creating and analyzing daily reports of all mission critical databases.
Worked with end users to define, implement, and maintain their reporting requirements.
Analyzed and tuned slow and long running queries to optimize system performance.
Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and SQL code.
Experience in database creation & administration tasks such as backups & recovery, table creation, inserting, and updating databases by using T-SQL, creating clustered and non-clustered indexes, and setting up user roles.
Performed DBA duties including: database backups, restores, performance tuning, and capacity analysis.
Ensured availability of instance and databases via Clustering and Mirroring.
Performed various data migration tasks for mission critical databases.
Troubleshoot Disk, Network, Memory, and CPU related performance issues on high volume OLTP servers.
Managed Mirroring and Log Shipping.
Created new database logins and users as required.
Tested the data backup by restoring as test database in a test server.
Performed health checks on a daily basis to ensure the completion of overnight maintenance jobs.
Maintained the proper use of storage space requirements as well as adding new storage space (disk drives) when necessary.
Planned and implemented security measures to safeguard information in computer files against accidental or unauthorized damage, modifications or disclosure.
Developed, tested, and maintained a backup and recovery process to ensure proper system continuity in the case of an unforeseen event.
Proactively monitored, identified, isolated and resolved server problems to avoid impact on the business.
Contact this candidate