SUMMARY

• Motivated Microsoft Certified Professional with 7+yearsofextensive experienceon managing over 500 MS SQL Servers on premises and Azure servers.
• Areas of expertise include administration, migration, security, maintenance, implementing high availability and disaster recovery strategies. Also, performance tuning and optimization with strong problem solving, interpersonal and team playing skills.

TECHNICAL SKILLS

RDBMS: SQL Server 2019/2017/2016/2014/2012/2008 - R2/2005/2000; MS Access 2000/2003/2007.

Operating Systems: Windows Server 2008, 2008-R2, 2012R2.

Database tools: SSMS, SSIS, SSRS, SSAS, SQL Server Profiler, Performance Monitor, SSMS, SQLDeployer

Third party tools: IDERA, SENTRYONE, SolarWinds/DPA and Ola Hallengren scripts

Ticketing Systems: Isupport, SCSM (Cireson), JIRA

Compliances: HIPPA, PHI and SOX

PROFESSIONAL EXPERIENCE

Confidential

SQL Server Database Administrator/Azure

Responsibilities:

• Identified, resolved, and provided recommendations to resolve performance issues ranging from database performance to I/O hardware performance.
• Installed, configured and deployed new SQL Server 2016, 2017 and documented processes for installations.
• Experienced on Prem to Cloud Migration and Managed Azure SQL Servers and Databases.
• Implemented side by side upgrade (migration) of MS Sql Server from \2017. Applied patches.
• Implemented permissions, logins, roles and authentication modes as a part of security policies for various categories of users on windows server including Active Directory.
• Managed SQL Server databases through multiple product life cycle environments, from development to mission-critical production systems.
• Performed scheduled maintenance and support release deployment activities after hours.
• Independently analyze, solve, and correct issues in real time, providing problem resolutions.
• Supported and created SSIS packages to Extract and Load data from diverse source (flat file, excel, etc.
• Sharing domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
• Provided support during vendor and custom application upgrades. Work closely with developers to resolve sql server issues.
• Configured and maintained database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Supported database administration tasks including configuration management, backup/recovery, performance optimization, space management and capacity planning. Implemented backup and Recovery Model based on RTO and RPO (SLA) and implemented a database maintenance plan, created Index rebuild and reorganize, DBCC CHECK DB and schedule backups.
• Configured and implemented high availability (HA) and disaster recovery (DR) strategies like, AlwaysOn high availability, transactional replication and log-shipping.
• Configured Transparent Data Encryption (TDE) and Always Encrypted.
• Work closely with Development and QA teams to optimize code and efficiency.
• Refined and automated regular processes, tracking issues, and documenting changes
• Performed performance tuning and optimization (PTO), troubleshooting and monitoring using Performance Dashboard reports, Database Tuning Advisor, SQL Profiler, DMVs and DMFs and performance monitor.
• Providing 24/7 Support for Production, Development & Test Servers of MS SQL Servers.

Confidential

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2012 and 2014 instances hosted on Physical and virtual environments in standalone and clustered set up. And configured AlwaysOn high availability.
• Managed logins, servers and database roles, maintaining database permissions, troubleshooting SQL server security and auditing SQL service instance based on the companies SLA.
• Responsible for Designing and implementing the backup strategy required as per the requirement.
• Checked each database availability and accessibility by both logging in via user application as well as running query on daily base. Maintained and verified backup to check its validity and recoverability
• Designed, reviewed, and created primary objects like views, indexes, stored procedures, functions, and triggers based on logical design models, user requirements and physical constraints.
• Documented installation, monitoring procedures, logins, security policies, configuration changes, migration procedures, deployment procedures, maintenance jobs and other best practices.
• Used the SQL Server profiler and extent event to capture and store the execution plan.
• Supported the BI team on creating SSIS packages to import and export data from data source to destination servers.
• Created, deployment and maintenance of SQL Server databases in both development and live service environments.
• Implemented performance monitoring and alert messages via native tools and third-party tools.

Confidential, Arlington

SQL Server Database Administrator

Responsibilities:

• Installed SQL Server 2012 SP2, 64bit enterprise edition instance (Database engine, SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)) on windows server 2012.
• Created & administered database objects, tables, views, indexes, procedures for implementing some application functionality at the database side for performance improvement.
• Administered the MS SQL Server security by enforcing security policy, creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Install Database Management Software for SQL Server on the server and client machines, provide connections and manage databases.
• Performed Backup and recovery and Automation of Backups. Implemented transaction log backups every 15 or 30 minutes to help minimize the loss of data if a database crash.
• Responsible for Designing and implementing the backup strategy required as per the requirement.
• Performed Data Transfer/Migration using Export/Import and SSIS.
• Implemented a database maintenance plan (DBCC, updating statistics, rebuilding & reorganizing indexes).