Sql Server Database Administrator

Andrew O. Ukpabi

Dallas-Tx *****, USA

Cell: +1-972-***-**** Email: ********@*****.***

PROFESSIONAL SUMMARY

A result-driven Database Administrator with 6+ years of hands-on experience in Database administration in both on-premises and cloud (Azure) environments. My expertise includes database maintenance, performance tuning and optimization, security, high availability disaster recovery (HADR), and backup processes. I have implimented my skills and expertise to provision, configure and maintain Always On, Clustering, Replication, and query optimization. I have extensive experience in routine DBA tasks like migration, upgrades, and security management. I am skilled with diagnostic tools such as SQL Profiler and Query store to evaluate and tune performance issues, in addition to evaluating index statistics/fragmentation for database queries. I am expertise in database security measures like Transparent Data Encryption (TDE) and Dynamic Data Masking, and proficient with monitoring tools. Demonstrated expertise in ETL processes, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS). My responsibilities have included securing SQL Server environments, managing users, permissions and roles. I collaborate with cross-functional teams to deliver exceptional results in compliance with client and company requirements considering industry’s best practices.

SKILLS HIGHLIGHTS

TECHNICAL SKILLS

• Extensive experience with MS SQL server, MS Azure and database deployment in the cloud.

• Experience in creating and supporting ETL processes, and analysis with tools like SSRS, SSIS, and SSAS.

• Proficiency in database backup and restore, performance tuning and optimization, database migration and HADR.

• Proficiency in PowerShell, T-SQL and SQL server.

• Experience with VMware, SQL profiler, Linked Servers, Jira, Perfmon, and Agile methodologies.

• Proficiency in utilizing SQL commands – DDL, DML, DCL, DQL and TCL, and writing complex queries.

• Working knowledge of MongoDB.

• Advanced Microsoft Office Suite (Word, Excel, Outlook, and PowerPoint)

CORE SKILLS

• Strong problem-solving and troubleshooting skills.

• Positive interpersonal skills.

• Detail oriented.

• Analytical and critical thinking.

• Ability to handle multiple projects efficiently.

• Research and Development.

PROFESSIONAL EXPERIENCE

SKYLINE TECH CONSULT MS SQL DATABASE ADMINISTRATOR

JANUARY 2023 – PRESENT REMOTE California-USA

Managed Microsoft SQL Server environments, focusing on installing, configuring and maintaining SQL Server.

Conduct SQL Server installations, operating systems upgrades, migration, and patching, to maintain system security and performance

Developed DBA-level project specifications from inception to completion, ensuring alignment with stakeholder expectations.

Collaborate with technical teams on capacity planning, SQL Server upgrades, constructing and optimizing queries, thereby improving data retrieval and optimizing infrastructure.

Utilized SSIS to build high-performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.

Support in database design, query enhancement, and database migration initiatives in collaboration with development and application teams.

.

Work closely with cross-functional teams to define and implement CI/CD pipelines for automating changes and managing control processes.

Provided expert-level support for SQL Server configurations, troubleshooting, and administration for key clients.

Implemented Windows Server Failover Clustering (WSFC) to improve system resilience.

Successfully migrated on-premises databases to Microsoft Azure, and large-scale migrations from SQL Server 2012 to more recent versions ( 2019, 2022), ensuring seamless transitions.

Provided strong DBA support, including change management, code deployment, break fixes and 24/7 on-call support.

Monitored and optimized database performance, proactively resolving potential issues to minimize downtime.

Established physical database parameters and utilized SQL commands to define and manage database objects using DDL, while controlling access through DCL.

Provided technical support across various environments (Production, Development, QA, UAT), collaborating within a highly cross-functional team.

Performed performance tuning and optimization techniques, resulting in improved database efficiency and performance.

Supported the staging and deployment of database modifications, meticulously documenting operational procedures and ensuring seamless transitions to production.

Managed 11000 databases across multiple data centers, ensuring high availability and performance at scale.

Led initiatives for high availability and disaster recovery (HADR) solutions, improving system resilience and reliability.

Managed index fragmentation and I/O bottlenecks, conducting DBCC checks to ensure data integrity.

Managed Active Directory (AD) objects, users, assigning permissions and roles.

Administration of database architecture, user authentication, access permissions, tablespaces, buffer/cache management, storage solutions, and related components.

Configured and troubleshot Always On availability groups, replication models, and database mirroring to guarantee data availability.

Leveraged tools such as ServiceNow, SolarWinds, SQL Sentry, and Red Gate SQL Monitor to maintain system health and resolve performance issues.

Spearheaded the automation of repetitive database maintenance tasks and performance optimization, resulting in a 20% reduction in administrative time, using T-SQL and PowerShell script.

Secured SQL Server environments through the implementation of Transparent Data Encryption (TDE), dynamic data masking, and stringent user management protocols.

JCPENNEY MS SQL DATABASE ADMINISTRATOR (Contract)

June 2018 – Dec 2022 Texas, USA

Supported all aspects of the production database infrastructure, including high availability, database replication, and disaster recovery strategies.

Managed, monitored, and maintained the integrity, security, and availability of more than 900 databases distributed across various data centers.

Optimized queries to improve execution times and overall system responsiveness.

Managed and maintained database indexing strategies for faster data retrieval.

Configured and maintained High Availability and Disaster Recovery Solutions such as Always On, Clustering, Database Mirroring, Log Shipping, including Replication models (Snapshot, Transactional/Merge)

Led SQL data migrations from on-premises environments to Azure SQL Database, and migrations from SQL Server 2008 to SQL Server versions 2012R2, 2014, 2016, 2017, and 2019.

Created and maintained SQL objects like Tables, Views, Stored Procedure, Constraints and User defined functions.

Monitored and analyzed database performance to identify and address bottlenecks, ensuring optimal efficiency.

Applied performance tuning techniques to enhance database performance and resource utilization.

Troubleshot and resolved slow-running queries, improving database query performance.

Upgraded SQL Servers from legacy versions, utilizing SSRS to develop insightful reports.

Performed Physical and Logical Data Modeling for databases of varied sizes, including very large databases (VLDBs).

Installed database management systems, managed the creation of databases, tables, indexes, stored procedures, reports and views for maximum operational efficiency.

Provided 24x7 technical support for over 900 SQL Server databases.

Configured high availability and disaster recovery solutions using MS SQL Server and Transaction Replication from Distribution Server with multiple updatable subscriptions.

Ensured data integrity through routine audits, checks, and maintenance activities, effectively preventing database corruption.

Provided on-call support for mission-critical environments, and expert support in disaster recovery mechanisms.

Performed database consistency checks using DBCC, defragmentation, index tuning, and monitored error logs.

Conducted security tasks, including granting and revoking permissions.

Performed database systems updates and patches to maintain security and enhance performance.

Managed the creation, development, and deployment of SSRS reports and SSIS packages across SQL Server versions 2008-2019.

Conducted Database Refresh tasks, scheduled backups, and restored operations.

Implemented and managed Logins, Users, Groups, Roles, Jobs, Alerts, and mail confirmations in compliance with standards.

EDUCATION

LAGOS STATE UNIVERSITY

Bachelor of Science

Lagos State, Nigeria

TRAINING AND CERTIFICATION

Microsoft Certified Azure Database Administrator Associate.

REFERENCES

Available upon request.

Contact this candidate