SUMMARY

• 7+ years of professional experience in SQL Server Database Administration, Support and Upgrade in Production & Development Environments
• Experienced in MS SQL Server installation, configuration, performance tuning, client/server connectivity and query optimization
• Extensive experience with MS SQL Server 2016, 2014, 2012, 2008 R2, 2008 and 2005 Versions.
• Extensive Knowledge of Relational Database Management Systems.
• Experienced in Database Backup, Restore and Disaster Recovery procedures.
• Strong experience working on environments which includes Windows 2012 Server, Windows 2008 Advanced Server, Windows 2003 Server
• Highly experienced in Database Maintenance plans, scheduling of jobs and alerts and notifications using Database Mail.
• Expert in providing high availability support for SQL Server such as Failover clustering, Database mirroring, log shipping, replication and AlwaysOn Availability group
• Worked on migrating SQL server 2008 R2 to SQL server 2012
• Experienced in creating Database objects like Tables, Stored procedures, Views, Functions and Triggers
• Hands on experience in system security, managing user logins, granting access roles and setting up appropriate permissions to users.
• Solid experience in troubleshooting and performance tuning by using activity monitor, performance monitor, DBCC, DMVs, DMFs and third party tools such as Spotlight, Redgate, Idera monitoring
• Strong in monitoring Event viewer and SQL Error logs for Software and hardware related errors.
• Knowledge of SQL Server Integration Services and Reporting Services
• Transformed data between servers using tools like Import / Export wizard, Bulk Copy Program (BCP), Copy database wizard, SQL Server Integration Services (SSIS) and Generate Script tool
• Experience in updating service packs and installing hot fixes in production and lower region servers
• Experience with Azure Sql DB
• Experienced in Capacity Planning for SQL server Database based on database growth rate
• Worked on code deployment in Staging environment for testing and on Production environment for final release
• Experience in providing 24 x 7 Production Support and On - Call rotation.
• Excellent communication skills, self-managing, self-motivated and teamwork spirits in multicultural environment

TECHNICAL SKILLS

Operating Systems: Windows Server 2012 R2 |2008 R2| 2008| 2003, Windows XP 7 | 10, VMware

Database Tools: SQL Server Management Studio, Query Analyzer, SQL Profiler, SSIS, SSRS, DTS, BCP, Business Intelligence Studio (BIDS), SQL Server Data Tool (SSDT)

Architecture: Relational DBMS, Client-Server Architecture, Clustering, Replication, OLAP, OLTP.

Languages: T-SQL, C# & PowerShell

Other Tools / Software: MS Visio, Microsoft Visual Studio 2012, Source Control, TFS, Redgate, Litspeed, Spotlight, IDERA, ServiceNow, Remedy, MS Office Suite

Data modeling Tools: MS Visio and Erwin

PROFESSIONAL EXPERIENCE

Confidential, Plano, Tx

SQL Server DBA

Responsibilities:

• Created SQL Server Agent jobs and maintenance plans to automate tasks such as index maintenance, backup jobs and Update Statistics, Database consistency checker
• Worked on SQL 2016/2017/2019 AlwaysOn Availability Group as a High availability solution
• Created and managed table spaces, data files, resizing and adding new data files.
• Performed Index Data Management to determine Defragmentation level; whether to reorganize indexes or Rebuild Indexes.
• Performed Periodic Production and Non-Production code deployments as needed
• Troubleshooting issues in Production, Development, QA, and Testing environments
• Performed routine and customary operational and monitoring activities to ensure the database environment is stable and capable of meeting ongoing business needs.
• Performed data loading Procedures using SSIS packages
• Managed Capacity planning for the primary assigned servers to ensure adequate CPU, Disk space and Memory.
• Experienced with SSIS packages, SSRS package creating and deployment
• Responsible for patching and hot-fixes are uniformly applied to all environments
• Performed data refresh to lower region using Net-backup and backup restore based on developers request
• Implementing SQL Server Security and managing permission to the Database through Database roles, Creating Users and Logins
• Involved in performance monitoring and tuning using SQL Profiler, DBCC commands, DMVs and Windows viewer and Performance monitor

Environment: MS SQL Server 2019/ 2016/2014/2012/2008 R2, Windows Server 2012 R2 / 2012/ 2008, SSMS, SQL Server profiler, Database Tuning Advisor, SSRS, SSIS, Skype for Business, Foglight monitoring, ART (Application recovery tool), Net-backup, Remedy IT Service management

Confidential, Plano, TX

SQL Server DBA

Responsibilities:

• Installing, configuring, managing, monitoring and troubleshooting SQL Server 2019/2017/2016/ 2014/2012 versions in a clustered and standalone environment
• Performing High Availability (HA) and Disaster Recovery (DR) support using Backup and Restore
• Worked on SQL 2016/2017/2019 AlwaysOn Availability Group as a High availability solution.
• Support and maintenance of Transactional and Snapshot replication and troubleshooting replication problems
• Created SQL Server Agent jobs and maintenance plans to automate tasks such as index maintenance, backup jobs and Update Statistics, Database consistency checker
• Tuned long running queries by utilizing DMVs and Query Tuning Adviser wizard
• Configured Database mail, operators and alerts to monitor server health and jobs
• Created SQL Server Agent jobs and maintenance plans to automate tasks such as index maintenance, backup jobs and Update Statistics, Database consistency checker
• Implementing SQL Server Security and managing permission to the Database through Database roles, Creating Users and Logins
• Worked on production migrating from SQL 20019 SQL 2019 for DR purpose by installing new SQL 2019 I new Data center
• Regular monitoring of SQL Server Agent jobs, checking event logs and error logs of any issues.
• Create database primary objects (tables, views, indexes, etc.), login and users in Azure Sql DB
• Worked on Deployment of codes in Staging and Production environment
• Worked on various Redgate tools such as Sql Data masker, Sql clone, Sql Data compare etc

Confidential, Allen, TX

SQL Server DBA

Responsibilities:

• Installing, configuring, managing, monitoring and troubleshooting SQL Server 2016/2014/2012/2008 R2 versions in a clustered and standalone environment
• Performing High Availability (HA) and Disaster Recovery (DR) support using Backup and Restore
• Designed, reviewed, and created primary objects (tables, views, indexes, etc.) based on logical design models, user requirements and constraints.
• Configured Database mail, operators and alerts to monitor server health and jobs
• Created SQL Server Agent jobs and maintenance plans to automate tasks such as index maintenance, backup jobs and Update Statistics, Database consistency checker
• Tuned long running queries by utilizing DMVs and Query Tuning Adviser wizard
• Involved in performance monitoring and tuning using SQL Profiler, DBCC commands, DMVs and Windows viewer and Performance monitor.
• Worked on SQL 2012 AlwaysOn Availability Group as a High availability solution.
• Support and maintenance of Transactional and Snapshot replication and troubleshooting replication problems.
• Worked on configuring and monitoring Database Mirroring, Log shipping for DR and Reporting purpose
• Implementing SQL Server Security and managing permission to the Database through Database roles, Creating Users and Logins.
• Worked on production migrating from SQL 2008 to SQL 2014.
• Created SSIS packages with which data resources such as Excel, Flat file, and SQL data were imported daily
• Handling Disk space issues and Capacity Planning requests on Production and Semi-Production Servers
• Regular monitoring of SQL Server Agent jobs, checking event logs and error logs of any issues.
• Responsible for patching and hot-fixes are uniformly applied to all environments
• Worked on Deployment of codes in Staging and Production environment

Environment: MS SQL Server 2016/2012/2008 R2, Windows Server 2012 R2 / 2012/ 2008, SSMS, SQL Server profiler, Database Tuning Advisor, SSRS, SSIS, Skype for Business, Spotlight monitoring

Confidential, Lewisville, TX

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2012 and 2014 in production, test and development environments in Clustered and stand-alone instances
• Configured and maintained high availability options such as AlwaysOn Availability groups and replication
• Reviewed and tune up SQL queries, stored procedures, views, triggers for better performance
• Created user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Created SQL Server Agent jobs and maintenance plans to automate tasks such as index maintenance, backup jobs and Update Statistics, Database consistency checker
• Performed SQL Server service pack and Windows Service pack upgrades.
• Created and scheduled backup jobs for user databases based on RPO and RTO
• Worked closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization
• Monitored and troubleshoot the environment using third party tool called Spotlight
• Worked on query optimization and index maintenance (rebuilding and reorganizing indexes)
• Migrating SQL Server 2008 R2 into SQL Server 2012.
• Recovering the databases from backup in disasters, performed Point-In-Time Recovery
• Performed data refresh to lower region using Red gate and backup restore based on developers request
• Handled Disk space issues and Capacity Planning requests on Production and non-Production Servers
• Responsible for pushing the changed from Dev environment to QA and from QA to Prod
• Worked 24 x 7 Production support with on-call rotation

Environment: MS SQL Server | 2008 R2, Windows Server 2012 R2| 2008, SQL Server Management Studio, Profiler, Database Tuning Advisor, Spotlight, Red Gate

Confidential, Plano, TX

SQL Server DBA

Responsibilities:

• Excellent experience on configuring and maintaining replication like transactional snapshot
• Installed, configured and maintained Microsoft SQL server on clustered and stand-alone instance for critical production servers and lower region servers
• We are using HIPPA (Health Insurance Portability and Accountability Act) to protect patient's privacy expectations under the policies and procedures.
• Worked with the application teams to identify the feasibility of migrating legacy databases (2005) to consolidated SQL Server 2012 environment.
• Performed SQL instance version upgrades from SQL Server .
• Implemented High Availability and Disaster Recovery solutions with SQL Server DB AlwaysOn AG, Log Shipping and Failover Clustering (Active-Passive).
• Experience in SQL joins, sub queries, stored procedure and function coding
• Created Database and Server level Audit specification using the SQL Server Audit Feature and analyzed the audit results.
• Configured and monitored SQL jobs for different purposes like backup, maintenance, data loading tasks
• Used new features like row and page compression mechanism to reclaim space on database drives
• Worked closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization
• Managed Capacity planning for the primary assigned servers to ensure adequate CPU, Disk space and Memory.
• Experienced with SSIS packages, SSRS package creating and deployment

Environment: SQL Server 2005, 2012, TSQL, SSDT, TFS (Team Foundation Server), Profiler, Database Engine Adviser wizard, Import | Export tool, Idera monitoring

Confidential, Addison, TX

SQL DBA

Responsibilities:

• 24x7 Production DBA support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Installed new SQL instances, applied latest service packs side-by-side upgrades based on the build requests.
• Maintained the table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans, SQL Server Profiler and Database engine tuning Advisor.
• Created and managed table spaces, data files, resizing and adding new data files.
• Performed Index Data Management to determine Defragmentation level; whether to reorganize indexes or Rebuild Indexes.
• Performed Periodic Production and Non-Production code deployments as needed
• Troubleshooting issues in Production, Development, QA, and Testing environments
• Performed routine and customary operational and monitoring activities to ensure the database environment is stable and capable of meeting ongoing business needs.
• Performed data loading Procedures using SSIS packages

Environment: SQL Server R2, SSIS, Windows 2003, 2008 Advance Server, SSMS, Profiler, Database tuning Adviser wizard, Source Control