SQL Server DBA
Send a job offer directly to this candidate
Accomplished and result-driven Microsoft SQL Server Database Administrator with 8 years of experience overseeing mission-critical database infrastructures. Proficient in all aspects of SQL Server database management from installation to optimization, with a focus on delivering high availability, performance optimization, automation, and compliance with database governance and auditing standards.
World Kinect | Jan 2024 - Present | Woodland, TX
▪ Installed, upgraded and configured SQL server 2022, ensuring proper setup and optimization throughout the process.
▪ Patching SQL Server Instances with new Released Service Packs from Microsoft, maintaining system reliability and security.
▪ Successfully migrated a large production database from SQL Server 2016 to SQL Server 2022, ensuring data integrity and minimal downtime.
▪ Supported and executed SQL Server migrations from on-premises environments to Azure Virtual
Machines, leading end-to-end transition activities and enforcing Azure best-practice configurations to ensure performance, security, and high availability.
▪ Configured and maintained Disaster Recovery solutions including Replication, Database Mirroring, and
Log Shipping to secure critical data.
▪ Implemented and configured AlwaysOn Availability Group.
▪ Conducted query optimization and performance tuning using tools like SQL Profiler and Extended
Events.
▪ Extensive experience managing extra-large databases with high availability and real-time replication.
▪ Automated routine database administration tasks using PowerShell script.
▪ Created SSIS packages to export and import data from various sources, facilitating data movement and integration across systems.
▪ Configured and managed Transparent Data Encryption (TDE) on SQL Server databases to ensure data at rest was encrypted per security and compliance requirements.
▪ Configured SMTP-based email notifications and alerts to monitor performance counters and proactively diagnose issues.
▪ Performed database integrity checks using DBCC utilities to verify database consistency and detect potential corruption.
▪ Monitored SQL Server jobs, database sizes, disk-space utilization, and performed capacity planning and storage forecasting to support database growth.
▪ Created and maintained documentation for SQL Server configurations, backup and restore procedures, high availability setups, and disaster recovery processes to support operational standards and audits.
▪ Utilized tools such as Redgate (e.g., SQL Toolbelt, Monitor), Oracle GoldenGate for data replication, PowerShell automation including dbatools, Jira for ticket management, MySQL (Oracle), and BI technologies including SSIS, and SSRS.
▪ Collaborated with a cross-functional team to design and develop databases, enhancing data availability and support across departments.
▪ Supported 24x7 mission-critical production SQL Server environments with on-call rotation and rapid incident response.
JPMorgan Chase & Co. | June 2021 – December 2023 | Houston, TX
▪ Managed migration projects including side-by-side and in-place upgrades of SQL Server from lower version to higher version.
▪ Executed backup and recovery strategies aligned with SLAs to ensure data integrity and accessibility.
▪ Executed patching operations on production SQL Server environments, installing service packs and patches to maintain supportability and stability.
▪ Implemented and maintained SQL Server high-availability and disaster-recovery solutions including
AlwaysOn, Log Shipping, Database Mirroring and Replication.
▪ Administered transactional replication and monitored replication latency
▪ Utilized database mail notification for proactive error monitoring, swiftly addressing failures for uninterrupted operations.
▪ Created maintenance plan jobs for automated backups, index management, statistics updates, and database consistency checks.
▪ Managed index performance by rebuilding or reorganizing indexes according to fragmentation thresholds to optimize query efficiency.
▪ Created and maintained a comprehensive SQL Server inventory across the organization.
▪ Collaborated with DevOps teams to support database deployments through CI/CD pipelines, ensuring controlled and versioned database releases.
▪ Implemented Transparent Data Encryption (TDE), including creation of database encryption keys and certificates, and maintained encryption states across production and DR environments.
▪ Employed error logs and trace flags to promptly diagnose and resolve critical issues, including connectivity problems, query failures, deadlock, resource contention, and database corruption.
▪ Developed and maintained Linked Servers between Microsoft SQL Server 2016 and SQL Server 2019.
▪ Created data movement workflows using SQL Server Integration Services (SSIS) packages to transfer data between systems.
▪ Implemented scalable ETL solutions to extract, transform, and load high-volume data while ensuring data quality, consistency, and performance optimization.
▪ Managed and supported SQL Server workloads hosted on Amazon EC2 and Amazon RDS, ensuring high availability, performance optimization, and secure configurations.
▪ Executed database migrations from on-premises SQL Server environments to AWS (EC2 and RDS), performing backup/restore, log shipping, and data validation to ensure seamless transitions.
▪ Prioritized and addressed tickets using the Jira ticketing system to resolve issues.
▪ Facilitated successful data migrations from diverse sources like flat files, excel, oracle, MySQL. MS Access and OLE DB into SQL Server using BULK INSERT and BCP utilities for efficient data transfer.
▪ Developed and deployed SSIS packages for scheduling data import/export between databases.
▪ Executed detailed health assessments of SQL Server by evaluating configuration, backups,
performance metrics and integrity to maintain optimum database.
McKesson | February 2018 - May 2021 | Irving, TX
▪ Collaborated with senior DBAs in installing and configuring SQL Server instances across versions 2012 to 2016.
▪ Performed performance tuning of long running SQL queries and stored procedures using SQL
Profiler/Extended Events and analyzing execution plans.
▪ Patching SQL Server Instances with new Released Service Packs from Microsoft.
▪ Worked on refreshing development and test databases using production backups, ensuring environments were aligned with live data for realistic testing and analysis.
▪ Encrypted sensitive production databases with TDE, improving data protection and compliance with internal security policies.
▪ Managed SQL Server logins, users, roles, and permissions while supporting auditing and compliance requirements across development and production environments.
▪ Performed routine maintenance tasks, including indexing defragmentation, backups, restores, and consistency checks, enhancing database reliability for seamless operations.
▪ Configured Database Mail alerts for proactive error monitoring and rapid response.
▪ Performed ETL tasks using SSIS to extract, transform, and load data from diverse sources.
▪ Automated common tasks using SQL Server Agent jobs, maintenance plans and PowerShell scripts.
▪ Performed database health checks, and maintaining consistency and integrity of production databases using DBCC utilities.
▪ Working with T-SQL in creating new objects or altering the existing ones.
▪ Created data movement workflows using SQL Server Integration Services (SSIS) packages to transfer data between systems.
▪ Performed troubleshooting SQL Server and AlwaysOn.
▪ Supported mixed RDBMS environments including PostgreSQL and MySQL, assisting with performance monitoring and cross-platform troubleshooting
Bachelor’s Degree, University of Arkansas, Fayetteville, AR
