Ms Sql Dba

Database Administration Houston, Texas, United States

Profile
Contacts

Summary

Core Competencies
More than 6 years of experience as a SQL Server Database Administrator.
Efficiently provided database support & technical expertise for multiple applications in development, testing, QA, and production. (SQL Server, 2008, & 2012, 2014,2016,2017.2019 environments)
Successfully installed and configured SQL in standalone & Clustered environment.
Proficiently managed the migration of SQL Server 2012 databases to SQL Server 2016 & 2019.
Strong expertise in Installing, Upgrading, Configuring, and Migration of MSSQL servers in clustered & non-clustered production environments.
Efficiently improved performance for slow-running SQL queries.
Profoundly administered, managed, developed, and configured SQL Server database design following best practices.
Successfully performs Transparent Data Encryption (TDE) on MS SQL Servers.
Expertise in setting Always-On Availability Groups (AOAG), Replication, and Log Shipping as HA/DR solutions

PROFESSIONAL EXPERIENCE
MS SQL Server DBA Apr 19 Present
Texas Department of Criminal Justice, Richmond, TX

Managed 24/7 Production Database Administration.
Supported and Monitored to ensure a proactive problem recognition and resolution of database issues.
Installed and configured SQL in standalone & Clustered environment.
Performed Backups, DBCC utilities, updated index statistics, monitored database & disk space
Provided DBA support and technical expertise for multiple applications in development, test, QA & production - SQL Server, 2008, & 2012, 2014,2016,2017.2019 environments.
Configured High Availability Solution- Always on Cluster, Traditional Failover Clustering, and Log Shipping
Upgraded Databases from lower versions of SQL to a higher version
Administered, Managed, Developed, and configured SQL Server database design following best practices
Rebuilt the indexes at regular intervals for better performance
Developed and Implemented a Disaster Recovery (DR) Plan.
Tested, Implemented different Physical and Logical Backup & Recovery methods - Point-in Time, Media Recovery, Full/Partial, Export/Import.
Implemented maintenance jobs
Involved with Database Design/Data Modeling.
Provided Support on Performance Issues during Project Development, resulting in improved response times and reduced contention.
Deployed Database Security Policy and Installation, using Passwords, Privileges & User Profiles.
Worked with SQL Server Profiler, Extended Events, Query Store
Documented processes step by step manner which is part of knowledge sharing policy within our team, which works quite effectively

Expectations

Provision of a safe and healthy working environment
Respectful and courteous treatment of employees
Provision of paychecks, bonuses and commissions on expected pay dates
Appropriate training to ensure employees can meet their job position requirements
Provision of clear explanation/description of company rules, policies and procedures at the start of employment (written and verbal)