Database Administrator Sql Server
Resume:
TELVIN NWANKWO
Database administrator
251-***-**** *************@*****.*** Mobile, Alabama.United States SUMMARY
Highly analytical and results-driven SQL Database Administrator with over 6 years of expertise and extensive knowledge of managing SQL Server databases in production environments. Maintained servers and systems to ensure smooth business operations; an ardent contributor to team success with a track record of empowering teams. Strong business and technical vision, ability to manage multiple complex projects, problem solver, results-oriented, have an aptitude for learning, and can maximize resources while possessing a sense of urgency.
Excellent attention to detail, cross-functional communication, and ability to learn and adapt to change. Skilled in building complex environments using functions such as AlwaysOn, Windows Failover Clustering,Logshippingg. Comprehensive knowledge of SQL Server installation, migration using SAP, patching, troubleshooting, optimization, maintenance (modeling, High-Availability (HA) and Disaster Recovery (DR).
SKILLS
Database designs Backup/Restore Relational Database Management Hyper-V Change Management Interpersonal/leadership Automation, MS SQL Team Installed SQL in Standalone /Clustered environment Transparent Data Encryption (TDE) Dynamic masking Always Encrypted HADR (High Availability & Disaster Recovery) Performance Monitoring & Tuning Data Migration Assistant SSIS/SSRS Migration & upgrade (SAP) Permissions Database Management Documentation Root cause analysis sqlserver Performance Analysis
EDUCATION
2009 - 2013 BSc Computer Science
National Open University - Lagos, Nigeria
E
EXPERIENCE
01/2022 - Present
Mississipi
Database Administrator
Huntington Ingalls-Pascagoula
Support for onsite and offshore - On Call 24/7 environment. High Availability Solution- Clustering, Always On and Log Shipping. Advanced skills in Monitoring Tools.
Query store, Import/Export Wizard, SSMS, SQL Server Profiler/performance monitor, Extended Events and Tuning Advisor tools.
Interacts with clients, application team and project managers to design, implement and support solutions to meet client needs.
Configured and Managed High Availability (HA) and Disaster Recovery (DR) Solutions (Log Shipping, Always On, Clustering, and Replication. Increased efficiency 25% by providing optimum database performance with efficient backup and restore processes. Worked on different projects(migration projects and upgrade of servers using SAP-system application product). Strong Experience with SQL Server 2016 through 2019 Administration standalone and cluster environments
Configured and supported replication (Snapshot/Transactional/Merge/Peers to Peers) and log shipping in both SQL 2016 through 2019 SQL server. TDE (Transparent Data Encryption), Always encrypted, Dynamic data masking,deployed database security policy using passwords user profiles and privileges(password reset for users and server). Used Execution Plan, SQL Profiler, and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
Experience with VM, Hyper-V,involved in daily schedule meetings by different IT team members. Experience with partitioned schemas and tables, creating File groups using SQL Server. Experience in SQL Server Performance Tuning, Query Optimization, Client Connectivity and Database Consistency Checks Using DBCC.perform patches and install ODBC on different servers.
Documents all processes for future use by any other administrator or for audit purposes Experience in Administering SQL Server security by Creating User Logins with appropriate roles, monitoring user accounts, granting privileges to users and groups. 10/2019 - 12/2021
Dallas-TX
Database Administrator
Viapath Technologies
Administering, Managing, Developing, and configuring SQL Server. Database design following best practice. Rebuilding indexes at regular intervals for better performance. Technical support and customer service representative. Responsible for performance tuning & index tuning, DBMS Used performance monitor and SQL profiler to optimize queries and enhance the performance of database servers.
Developed and Implemented a Disaster Recovery (DR) Plan. Tested, and implemented different physical and logical backup and recovery methods Point-in- Time, Recovery.
Involved in different migration and upgrade of SQL server projects. Supervised end-to-end security operations involving setting up logins, users, and permission to database objects in line with the company's security policy. Deployed Database Security Policy and Installation, using Passwords, Privileges, and User Profiles Used Transparent Data Encryption to Encrypt Columns, Tables, and Tables paces. Implemented maintenance jobs to ensure there’s a proper cleanup daily to maintain daily backups of databases and daily space check on servers. Oversee data design, recovery, integrity, maintenance, and space requirements for physical databases efficiently.
Troubleshoot and resolve SQL Server performance issues using both SQL Server inbuilt and 3rd party tools.
Provided daily 24hrs support at the level of installing and configuring SSIS, building simple packages, and deploy packages to the production environment. Used SSIS packages to schedule jobs.
Provided SQL Databases support and technical expertise for multiple applications in development, test, and production SQL Server in multiple environments.
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
EXPERIENCE
07/2017 - 09/2019
Dallas TX
Database Administrator
Reconext
Directed various day-to-day operations such as SQL server daily checks, installation, configuration, upgrades, and structure modifications.
SQL Standalone and cluster environments setup and installation database management system Expertise in Always-On Availability Groups (AAG), Log Shipping, and HA/DR Troubleshooting. Implemented and maintained new databases, backup/recovery, and configuration management. Acted as subject-matter expert while facilitating programmers and engineers to use efficiently database systems.
Created and integrated DB backup/restore and disaster recovery strategies on the company's SLA leveraging proven methodologies. Cybersecurity
Removed local admin rights from all users, and performed several monitoring tasks. Mitigated databases with minimum downtime, fixed overall database access and performance issues, and uncovered anomalies while patching and upgrading database Servers and Windows servers.
Generated prompt responses to tickets, resolved user requests based on a priority, and ensured database configuration maintenance in the configuration repository. Worked closely with development and engineering teams during product releases. Was responsible for end-to-end database change management process and automated database deployments.
ACHIEVEMENTS
Constantly received positive feedback from
Senior Management for taking additional
responsibilities and appreciated it multiple
times.
Advise management on SQL Server licensing
which minimized cost and achieved business
results.
Mentored & Trained Junior DBA resources and
saved a huge amount of cost to the company
for hiring.
Automated various manual tasks and saved a
lot of time and money and achieved business
results.
•
•
•
•
•
•
•
•
•
•
Contact this candidate