| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name , DBA
Charlotte, NC Street Address
EMAIL AVAILABLEPHONE NUMBER AVAILABLEProfessional Summary Successful Database Administrator with more than 6 years of experience in database administration in production environments. Proactive in establishing backup and recovery processes and protocols to protect and retain valuable company data. Experienced in Performance Tuning, Maintenance, High Availability and Disaster Recovery (HADR) Solutions Hands on in setting up and troubleshooting Always On, Clustering, Database Mirroring, Log Shipping, including Replication models Transactional/Snapshot Experience in Database Backup and Restore/Recovery, Query Optimization, Security, SQL Server Installation and configuration of Stand-alone and Clustered environments Experienced in database security through configuring transparent database encryption (TDE) and dynamic data masking. Experienced in using Query Store, Extended Events, Database Engine Tuning Advisor (DTA), SQL Profiler, Scripts, and other third-party tools to resolve bottlenecks, deadlocks, and slow running queries Experienced working with ticketing system for task completion Hands on experience administering windows server, including Active Directory, DNS and clustering WFC. Support of MS SQL Server 2005 through 2019 in production, test, development and cluster environments.
Professional ExperienceSQL Server Database AdministratorHoneywell Charlotte NC May 2019 - Present Planned and installed upgrades of database management system software to enhance database performance. Managed over 900 databases and VLDB across multiple data centers. Migrated SQL Data from on premises to Azure SQL Database. Responsible for providing 24x7 DBA & Production support for over 180 SQL Server databases in Production on Clustered Servers. Responsible for setting up and maintaining High Availability and Disaster Recovery Solutions and large-scale database migrations from SQL Server 2005 to SQL Server 2012R2 and 2014/2016 Involved in assisting SQL Server prime customers with Configuration, Administration, Implementation and Troubleshooting for Business workflow with Log Shipping mechanism Configured DR solution with Transaction Replication from Distribution Server with multiple Updatable subscriptions Performed Database Refresh tasks from production to Development and Staging Servers Performed Scheduled backups and restore operations. Created (with respect to standards) Logins, Users, groups, Roles, Jobs, Alerts, Mails confirmation upon tasks. Performed security tasks like Grant, Revoke permissions for security tasks Maintained two different databases: Read-only reporting database and Disaster recovery database Resolved SQL Server problems in conformance with SLAs, which involves in-depth knowledge of SQL Server architecture, connectivity, replication, backup/restore, security and continuous improvement. Provided On-Call support to Mission critical Environments and expertise with Disaster Recovery mechanisms. Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs Junior, SQL Server Database AdministratorAmazon Seattle WA, July 2017 May 2019 Monitoring SQL health check and identifying issues and fixing them. Good experience in User Management and maintaining of databases. Implemented Installation, Configuration and Upgrading of SQL Server. Used SQL Indexes for improving query performance, lower storage and maintenance cost Used Optimization tools such as SQL Profiler, Dynamic Management Views (DMVs) and Windows Performance Monitor for monitoring and tuning SQL Server performance. Automation of administrative tasks like creating jobs and schedules, alerts using SQL Server Agent monitoring and troubleshooting jobs, event notifications using Database Mail. Maintained server security by assigning logins, server and database roles and server permissions. Implemented disaster prevention and recovery strategies and supported High Availability features like Clustering, Always On, Log Shipping, Database Mirroring and Replication. Maintained database response times in 24X7 production environment and proactively generated reports Used tools like SQL Profiler, Fog Light, Red Gate for monitoring my environment Responsible for installing and maintaining SSIS, SSRS Created and maintained SQL objects like Tables, Views, Stored Procedure, Constraints and User defined functions Implemented Log Shipping from Primary to Standby servers Planned and Implemented database backup/restore and disaster recovery Maintained database response times in 24X7 production environment and proactively generated reportsJunior, SQL Database Administrator
Sterling Bank Plc, Lagos, Nigeria, October 2015 January 2017
Monitoring SQL health checks and identifying issues and fixing them. Used SQL Indexes for improving query performance, lower storage and maintenance cost Good experience in User Management and maintaining databases. Automation of administrative tasks like creating jobs and schedules, alerts using SQL Server Agent monitoring and troubleshooting jobs, event notifications using Database Mail. Maintained server security by assigning logins, server and database roles and server permissions. Implemented disaster prevention and recovery strategies and supported High Availability features like Clustering, Always On, Log Shipping, Database Mirroring and Replication. Planned and Implemented database backup/restore and disaster recovery Created and maintained SQL objects like Tables, Views, Stored Procedure, Constraints and User defined functions Used tools like SQL Profiler for monitoring my environment
Education
Bachelor of Science (B.S.) in Chemical Engineering
University of Benin, Edo State, Nigeria Nov 2007SQL Database Administration Training at Verizon Training CenterOwerri Nigeria Nov 2011 |
