Summary: Highly skilled and dedicated SQL Server Database Administrator with over 5 years of experience in installation, configuration, administration, and performance tuning of Microsoft SQL Server databases. Proven track record in implementing high availability and disaster recovery solutions, database security, data migration, and troubleshooting. Adept at utilizing SQL Server native tools and third-party applications for monitoring, optimizing, and maintaining database performance. Experienced in working with Azure for database migration and management. Excellent analytical, communication, and interpersonal skills.

Work Experience:

SQL DBA Harris Health

Houston, TX July 2021 to Present

• Install, administer, and maintain MS SQL databases.

• Provide 24x7 production support, including backup and recovery of large databases.

• Manage user security privileges and access levels.

• Monitor and assess database storage spaces, capacity, and growth requirements.

• Collaborate with developers to test and accommodate new functionality.

• Create and manage database objects, such as tables, indexes, procedures, and

triggers.

• Migrate scripts in a production environment and modify stored procedures based

on business requirements.

• Implement SQL Server security through user permissions and roles.

• Perform data migration between different versions.

• Create and schedule database maintenance tasks, backup jobs, and alerts.

• Optimize database performance by tuning indexes, using tools like Database Engine

Tuning Advisor.

• Resolve database issues, such as space management, deadlocks, and blocking.

• Monitor and optimize database performance using native and third-party tools.

• Ensure timely completion of database refreshes to maintain reporting environment sync.

• Upgrade SQL Server versions and apply patches and service packs.

• Provide 24x7 on-call support on production databases.

• Utilize virtualization technologies like VMware and Hyper-V.

• Work with ticketing services like Service Now and Solution Center.

MS SQL DBA Bank of Texas –

Houston, TX May 2020 to June 2021

• Install, upgrade, configure, and migrate Microsoft SQL Server in clustered and nanocluster production environments.

• Plan and implement high availability and disaster recovery solutions such as

Replication, Log shipping, Always On, and Clustering.

• Perform performance tuning and optimization using SQL Profiler, Query Analyzer,

and Database Engine Tuning Advisor.

• Monitor server performance using System Monitor and SQL Server Profiler.

• Evaluate execution plans, query plans, and transaction isolation levels.

• Create maintenance plans and jobs to improve performance.

• Support ETL processes and deploy SSIS projects.

• Work with Azure VM for migration and on-demand resources.

• Troubleshoot database-related issues and work with third-party tools like Red Gate

and SolarWinds.

• Utilize ticketing services like Service Now and Solution Center.

MS SQL DBA Direct Energy

Houston, TX February 2017 to April 2020

• Migrate SQL Server 2005 databases to SQL Server 2014.

• Design and implement database objects like stored procedures, views, tables, and

constraints.

• Monitor server availability and optimize performance.

• Design and implement security policies for SQL Servers.

• Troubleshoot client connections and application issues.

• Perform daily tasks, backup and restore databases using SQL Server Management

Studio.

• Design and optimize database structures, stored procedures, and functions.

• Implement log shipping for database synchronization.

• Conduct daily, weekly, and monthly database maintenance tasks.

• Manage SQL Server security by creating roles and groups.

• Maintain data integrity and perform data migration.

• Troubleshoot and resolve database-related issues.

• Utilize SQL Server native tools and DMVs for performance analysis.

• Work with SQL Server 2012 Reporting Services.

• Collaborate with teams for new releases and implementation.

Skills:

• Microsoft SQL Server 2019/2017/2016/2014/2012

• SQL

• Data Warehouse

• Disaster Recovery

• Server Management

• T-SQL

• SSIS

• SQL Server Reporting Services (SSRS)

• Database Security

• Data Modeling

• Query Optimization

• Performance Tuning

• Backup and Restore

• High Availability (Always-On, Clustering)

• Replication

• Log Shipping

• Azure (Virtual Machines, SQL Database)

Certifications:

• Microsoft Certified: Azure Database Administrator Associate

• Microsoft Certified: Data Analyst Associate

Contact this candidate