SQL Server Database Administrator

CHIBUZO BENEDICT AGOHA

********.******@*****.*** (281) 854 - 9793 https://www.linkedin.com/in/chibuzo-benedict-agoha-b6581b188/

SUMMARY

Client-focused Database Administrator with about 8 years proactively of working toward achieving high client satisfaction. As an IT professional I am very committed to maintain cutting edge technical skills and up-to-date industry knowledge. Deadline-focused with broad skill range including, Database Design Development and Support of MS SQL Server 2019/2017/2016/2014/2012/2008R2/ in Production, UAT, Test, Development and Cluster Server Environments. Strong Skill set in Database Administration using Windows platform. Always eager to acquire knowledge and share with colleagues. I am part of multiple IT Professional groups and participate in blogging like PASS, SQL Saturday, and SQL Server Central.

I Have a keen eye for job details and a growing passion for acquiring new knowledge especially in the areas of Microsoft SQL Server and other Applications. I also possess a strong leadership, collaboration, teamwork and problem-solving skills. Core experience: Data Migration Disaster Recovery Integration Services Performance Tuning Reporting Services Database Upgrades patches Backup and Recovery Database Security High Availability Solutions Database Monitoring Data Manipulation SQL Installation DevOps/Agility Automations SQL Azure/Cloud

Areas of Strength:

● Performed Windows Software installs/upgrades, monitoring/alert configuration

● Experience in troubleshooting performance issues (Query Optimization, I/O bottleneck, Blocking, Deadlock, Memory, CPU) to maintain uptime for SQL Server.

● Manage the production and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity on SQL Server 2008 R2, 2012 and SQL Server 2014.

● Table partitioning, file and file-group management, Knowledge of High Availability of database servers using Database mirroring, replications, and Log Shipping

● Design and implement 2005, 2008 R2, 2012 and MS SQL 2014, 2016, 2019,2022 databases for mission-critical business.

● Experienced on Disk and Server configuration through Raid for SQL Server.

● Use SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and SQL code.

● Troubleshoot databases and custom application issues for 2005, SQL Server 2008 R2, 2012, 2014, 2016, 2019 and 2022. ● Experienced in working with end users to define, implement, and maintain their reporting requirements.

● Experienced in the design, coding, testing and implementation of high volume transactional (OLTP) SQL databases instances.

● Managing SQL Azure Databases and Replicating data from onsite Databases to Cloud.

● Collaborating with developers to make sure new environments meet requirements and conform to best practices.

● Automating deployment of T-SQL, PowerShell and respective scripts, system configurations and security settings.

● Experienced in Deployment of SSIS packages and SSRS Report.

● Generate the weekly, monthly, and quarterly report by using SQL Standard Report.

● Create reports that run daily for jobs running in SQL Server Agent.

● Experienced with monitoring and troubleshooting in 24x7 operations.

● Strong experience in Database Administration in SQL Server.

● Installation, configuration, and upgrade of Microsoft SQL Server 2008r2 and 2012,2014, 2016, 2019, 2022.

● Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.

● Configuring and setting up Windows Server Failover Clustering Environment Strong.

● Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.

● Strong knowledge of backups, restores, recovery models, DBCC commands, Clustering, Log Shipping, Transactional Replication.

● Execution of scripts on db2 servers using dB Beaver application.

EXPERIENCE

National General Insurance An All States Company Remote

SQL Server DBA March 2020- Till Date

Installed and configured SQL Server 2012/ 2014/ 2016/2017/2019 on production and non-production Servers both on Standalone and Clustered servers

Migrated over 200+ databases from SQL Server 2008 and 2012 to SQL Server 2017/ 2019 as part of Data Center migration project and troubleshoot related issues that were reported post migration.

Experienced in installing and configuring Always-On Availability Groups (AAG) and DR Troubleshooting.

Administering SQL Server High Availability and Disaster Recovery strategies such as log shipping, mirroring and replication.

Configured and implemented Always-On Availability Groups with one primary and two secondary replicas for HA/DR.

Manage logins and users, assign roles, auditing, applied least privileges and TDE to ensure data security.

Experience and knowledge in designing critical production database backup and recovery strategies following Customer SLA’s Contracts to satisfy their RTO’s and RPO’s.

Experience in setting up full, diff, trans logs backups by scheduling jobs and alerts. Also monitoring these jobs and troubleshooting them in case of any failure.

Experience in successfully restoring and recovering a corrupted database using different backup and recovery techniques.

Experience in capacity planning of the SQL server databases by managing and monitoring disk space usage, datafile and log file usage using native tools and third-party tools like SolarWinds and what sup gold.

As part of a team of DBA, I was tasked with a project to effective design a SQL server database following best practice and successful come out with plan to patch and upgrade/migrated over 200+ database running on multiple instances.

Implemented and monitored transactional replication for DR and reporting purposes.

Created database objects such as tables, Stored Procedures, Views and Triggers.

Setup and configured Always-On Availability Groups on multiple databases.

Working on Database backup strategies, scheduling the jobs and working on failures.

Re-designed a database maintenance plan which freed about 30% disk space by avoiding frequent running of DBCC checks, adjusting fill factor and rebuilding indexes based on fragmentation level.

Implemented User-Defined server roles in SQL Server 2012, default schemas for groups.

Created Jobs and maintenance plans for better performance of the server some of the jobs include index rebuild/reorgs, DBCC check, update database stats, database cleanup and other SSIS packages to help with data migration.

Created alerts with database mail Simple Mail Transfer Protocol (SMTP).

Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.

Setup and maintained Linked Servers.

Implemented Transparent Data Encryption (TDE) to protect sensitive data and backups.

Used Database Consistency Checks – DBCC Commands for database maintenance.

Created maintenance plans for integrity checks and resolved issues related to it.

Modified Stored Procedures and complex T-SQL Queries to improve query execution process.

Used SQL Profiler, Server-side trace to identify performance issues on the server.

Management and Implementation of Resources planning, operations and cooperation on application of projects for continual environment and procedure improvement.

● Designed backup and restore strategies and Disaster Recovery solutions to prevent data loss.

● Database maintenance, Manipulation and Cleanup.

● MS-SQL 2008/2012/2014/2016/2019/2022 administration including installation, migration, configuration, upgrades, capacity planning, performance tuning, backup and recovery.

● Configuring and setting up of Database Replication, Mirroring and Log Shipping and AlwaysOn.

● Extensive Monitoring of SQL Server with Third Party Tools like IDERA, REDGATE, SolarWinds.

● I have successfully engaged in various DR (Disaster Recover) efforts for clients.

● I have remediated various SQL Vulnerabilities in my environment to secure our SQL infrastructure.

● Comparing and deploying SQL Server database schemas quickly and accurately using Redgate tool.

Environment: SQL Server 2008/2012/2016/2017,2019 Windows server 2008/2012/2016, SSIS, Solar Winds, VMware, SAN, SQL profiler, SSMS, DMA, AZURE, oracle, Veeam, Always ON, Log shipping, replication, mirroring etc.

LYTX REMOTE

SENIOR SQL Server DBA September 2021 – FEBRUARY 2022

Tasked with Mongo Atlas Setup running in AWS Cloud and producing documentation in each step of the Setup to educate other SQL DBA Team members.

Improved query performance by analyzing the stats, Query Execution Plans, system performance by system Performance Analysis, and used SQL Profiler for optimizing stored procedures.

Monitored all the SQL Server databases using Solar Winds and created custom statistics reports to users in Tableau.

Supported a 24/7 mission critical infrastructure and was involved in an on call rotation process to support the business databases and application.

● Configuring and setting up of Disaster Recovery (DR) and High Availability (HA) using Alwayson High Availability solutions for customers of a Merchandised Organization.

● Responsible for all aspects of database Maintenance; Installation, Patching, Migrations, Upgrades, Tuning and other sql related Projects.

● Worked with a team of 15 staff in the development, design, and implementation of new applications and changes to existing hardware systems and software packages, resulting in an increase in efficiency and return on investments for clients.

● Implementation of Database Encryption (TDE) and Experience with Windows environment, VM.

● Monitored performance and allocated resources to achieve optimum database performance.

● Rebuilt the indexes at regular intervals for better performance.

● Installed, configured, and administered SQL Server Reporting Services (SSRS) and SQL SERVER Integration Services (SSIS). and deployment of packages.

● Designing backup and restore strategies and Disaster Recovery solutions.

● Ensuring definition and development of database documentation and standards for easy continuity.

● Ensuring Database performance monitoring and tuning is regularly accomplished to prevent downtime.

BMC Houston, TX

SQL Server DBA April 2016 – March 2020

SQL Server installation and database setup/configuration (2012, 2014 & 2016) in on premise locations with different trust levels and Domains.

Planning and implementing SQL Server patching on quarterly basis on all non-Prod and Prod environments.

Configuring and Managing SQL AlwaysOn High availability environment in Local clusters & GeoCLusters and troubleshooting the availability Groups and other issues.

Monitoring SQL server/Database health checks and performance related issues using BMC Patrol and Database Mail Alerts.

Identify the usage of Old SQL servers (SQL 2000, SQL 2005), Migrate/Upgrade the databases to higher versions based on Application compatibility and planning to Decommission.

Implement and support High Availability: Mirroring, Log shipping and transactional Replication.

Managing the over 200+ database instance with multiple databases running on them both on VM’s and physical machines.

Maintain the integrity, availability, and recoverability of all production data systems. Planning for overall data deployment and operational health.

Troubleshooting, Debugging and Performance Optimization for SQL Server Database and Application Related issues.

Conducting Database Refresh once a week from PROD to UAT, DEV, and Test Environments.

Monitoring SQL server Error logs, Disk Space growth, Clustering Environment.

Planning and applying latest Service Packs and CU to different versions of SQL Server.

Worked on performance and tuning, identifying locking and blocking for long running queries.

Works on Yearly password renewal activities for all SQL server service accounts through Password Vault.

Monitor server capacity and make recommendations for hardware upgrades or add-ons (E.g., processors, disk space and memory) to accommodate current and planned server usage.

Monitoring, Configuring Database Backups using third party tools NetBackup tool and Native SQL Backup Maintenance jobs.

Create Linked servers between SQL server and Oracle server databases.

Refreshing the development databases with production data as per Application team's request.

Deploy SSIS packages in SQL servers and configured the jobs using those SSIS packages based on user requirements using dedicated Proxy accounts.

Migrating databases and DB Objects between DEV, QA and Prod environments using Export/Import wizard and/or Generate Scripts, back and restore methods.

Managing SQL Server and Database level security, like creating and managing logins, database users and user permissions.

Review performance stats and recommend changes for Database Tuning, Query Optimization, Diagnosing & fixing SQL performance issues.

Works on performance tuning, identifying locking and blocking for long running queries.

Monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index modification, code optimization and adding scheduled jobs to re-index and update statistics in databases.

Using SQL Compliance tool to compare and migrate the database objects Schema from one server to another.

Maintain and update SQL Inventory and Database Growth Report on regular basis.

Communicating with clients to ensure end-user discrepancies are resolved.

Supported a 24/7 mission critical infrastructure and was involved in and on call rotation process to support the business databases and application.

Environment: MS SQL Server 2016/2014/2008R2/2005, T-SQL, SSIS, SQL Profiler, Log Shipping, always on, Mirroring, Clustering Windows Server 2012R2 and Windows Server 2008R2, PowerShell, MS DOS, SharePoint 2010, Oracle 10g, VMware, SolarWinds, apache, SAN etc.

EDUCATION

Imo State University Owerri Nigeria

Bachelor of Science in Computer Science March 2004

PERSONAL

Skills: MS SQL Server 2019,2017,2016/2014/2012/2008R2/2005, T-SQL, SSIS, SQL Profiler, Log Shipping, AlwaysOn, Mirroring, Clustering Windows Server 2012R2 and Windows Server 2008R2, PowerShell, MS DOS, SharePoint 2010, Oracle 10g, VMware, SolarWinds, apache, SAN etc.

Interests: I love to watch Soccer, play Video Game and watch Basketball and a disaster relief volunteer

Contact this candidate