Sql Server Dba

Name: RAVIKUMAR

Phone: 615-***-****

Email: ******.***@*****.***

linkedin.com/in/ravikumar-r-67418356

Location: Dallas, TX

EXPERIENCE SUMMARY

SQL Server DBA professional with 14 years of experience in supporting Production, Staging, Development & QA database servers in 24*7 model.

Administration skills include SQL Installation, Configuration, Security management, Audit SQL server with PBM, Patch management, Performance tuning, Query optimization and Storage management.

Experience in designing Disaster recovery, High availability, and reporting solutions with the help of windows cluster, Always-On, Replication (Snapshot & Transactional) and log shipping technologies.

Extensive experience in Upgrade and migration of SQL server 2000/2005/08/12/14/16/17/19/22 versions both on Cluster & standalone environments.

Monitor & troubleshoot performance bottlenecks such as CPU, Memory, blockings & long running queries.

Administer maintenance jobs (Index Rebuild/Reorg, Statistics & CheckDB) to ensure optimal performance and consistency.

Manage SQL Server security (create & manage logins, users, and grant permissions)

Implement database backup strategies based on size, RPO & RTO

Supported 8 TB of VLDBs and complex environment hosting 500+ SQL Server instances.

Good knowledge in writing power shell scripts to automate basic SQL administrative tasks.

Import and export data using SSIS packages & native SQL wizard.

Resolve space issues in advance by projecting periodic database growth reports.

Extensive knowledge and experience in Database architecture, administration, system analysis, design, development, and support of SQL Server.

Extensive knowledge of designing cost effective database infrastructure solutions (Physical to Virtual) and providing hardware/software requirements.

Good hands-on VERITAS and MICROSOFT Cluster services.

Keen to learn new technologies and methodologies to support business.

Highly motivated, organized, innovative and result driven individual committed to excellence & continuous improvement.

EDUCATION

Master of Computer Applications, Osmania University, Telangana

Master of Science in Mathematics, Osmania University, Telangana

Bachelor of Computer Science, Osmania University, Telangana

CERTIFICATIONS

DP-300 – Azure Database Administrator Associate

MCSA (70-462) - Certified in Administering Microsoft SQL Server 2012

ITIL V3 Certified

Online trained certificate for M102: MongoDB

TECHNICAL SKILLS

Databases

MS SQL Server 2000/ 2005/08/12/14/16/17/19/22

Operating Systems

Windows 2000/2003/XP/7/2012 R2/2016 Datacenter, Windows 10

Performance Tool

SQL Profiler, Windows Perfmon, Extended Events

Development

T-SQL, Power shell

Monitoring tools

Fog Light, PRTG, Spectrum, Nagios, PA Server Monitor, SCOM

Supporting Tools

LiteSpeed, Red Gate, SQL Sentry, Visual Studio -2013/2017, TFS, FULL Convert

Languages

Pascal, C, C++, COBOL, SQL, PL/SQL

ETL Tools

DataStage, SSIS, Informatica

PROJECT EXPERIENCE

Project: Data and Analytics Nov’18 – till date

Client: National Veterinary Associates

Role: Sr. Database Administrator

Location: Remote

NVA develops a community of animal hospitals and pet resorts that share knowledge to achieve sustainable growth and to improve the comfort and well-being of pets by providing progressive and compassionate care.

Responsibilities:

Support & maintain SQL Servers in multiple data centers including Production, Development, and Test Environments

Install & configure SQL Server 2016/2017/2022 Enterprise Editions

Perform In-place & side by side Upgrade of SQL Server databases to 2022.

Design DR, HA, and reporting solutions with Log Shipping, Transactional Replication & Always-on technologies.

Plan, design and implement database capacity, physical & logical modeling, and security practice for every phase of application development.

Implement Security standards based on application and business user requirements.

Configure & implement database backup strategies.

Performed masking to safeguard confidential data.

Performed DB refresh requests.

Configured TDE encryption.

Manage and grant user permissions on databases, SSIS packages & SSRS reports.

Perform Resumable Online Index Rebuild

Administer various categories of jobs like SSIS & SSRS. Proactively monitor and resolve data replication/ETL issues.

Scrutinize & perform cleanup activities like purging data, dropping unwanted databases, changing recovery models, and restricting production access to users.

Configure SQL Server alerts & setup monitoring using T-SQL & Power shell scripts.

Develop and maintain scripts to automate SQL administration tasks.

Fix queries that have recently regressed in performance due to the change in execution plan through Query Store

Analyze & resolve SQL Server Reporting time out issues by running profiler trace.

Deploy SSIS projects and configure ETL jobs to load the data on a daily/weekly/monthly basis.

Create proxy accounts and provide necessary permissions to monitor/run SSIS jobs.

Deploy SSRS reports and grant access to corresponding business users.

Good hands-on experience with Full convert tool which converts SQL tables to SQLite (DB3/DBF)

Work during non-business hours for system emergencies, production database releases, patches and data migrations ensuring minimal or no impact on business operations.

Perform failovers & apply patches regularly.

Environment: MS SQL Server 2014/2016/2017/2019/2022, Windows 2016 Datacenter

Project: ACA-TDI Jun’16 – Oct’18

Client: Ernst & Young, USA

Role: SQL Server Database Administrator

Location: Dallas, TX

Ernst & Young (trading as EY) is a multinational professional services firm headquartered in London, United Kingdom. It is one of the "Big Four" audit firms and is the third largest professional services firm in the world by aggregated revenue in 2014, after PwC and Deloitte. The organization operates as a network of member firms which are separate legal entities in individual countries. It has 212,000 employees in over 700 offices around 150 countries in the world. It provides assurance (including financial audit), tax, consulting, and advisory services to companies.

Responsibilities:

Design SQL Server hardware & software requirement specifications.

Plan and perform SQL Server 2014/2016 installations.

Upgraded 300+ client specific databases to higher versions as per the business requirements.

Requirements gathering, planning and implementation for the new project builds.

Design DR, HA, and reporting solutions with Log Shipping, Transactional Replication & Always-on technologies.

Configured and supported Always-On for tier 1 servers.

Configure & maintain log-shipping between the servers.

Define backup strategy and create maintenance plans for Indexes, Stats updates, and database consistency checks.

Monitor & resolve critical alerts, incidents and troubleshoot performance issues.

Used SQL Profiler traces and extended events to monitor database performance metrics.

Fix Dead lock issues with proper solutions either by tuning the code or creating necessary indexes.

Implement security standards and provide appropriate privileges to users.

Developed Power shell scripts to automate administrative tasks such as Change password, reboot servers, monitor space issues and read event logs.

Resolve user requests received in the form of tickets via SharePoint site, TFS & Service-Now

Perform database schema comparisons and deploy the changes to production.

Deploy SSIS packages using ispac & Visual Studio tools.

Perform UI deployments.

Supported migration project, where applications & database servers were moved to Azure cloud, per business requirements.

Good hands on VEEAM Backup tool, performing Backups & Restores for SQL databases.

Plan and implement migration of production servers to a different Datacenter with proper fallback plans.

Perform regular SQL patching activities during IW.

Environment: MS SQL Server 2014 SP2-CU6, Windows 2012 R2

Project: IT Operations DBA Oct’11 to May’ 16

Client: ASURION, USA

Role: Senior SQL Server DBA

Location: Pune, India (Oct 2011 – Sep 2014) & Nashville, TN (Sep 2014 – May 2016)

Description: ASURION is one of the major mobile insurance providers in the USA. From lost, stolen, and damaged mobile phones to malfunctioning computers or TVs, Asurion offers best-in-class, next day device replacement and experienced, and hassle-free support to millions of consumers daily. It provides insurance for various clients such as Verizon, AT&T, T-Mobile, Wal-Mart, and Sprint and provided global support for the production servers in USA, Europe, China, Japan, and Korea under 24*7 basis.

Responsibilities:

Performed migration of SQL servers from VCS to MCS cluster.

Requirements gathering, planning and implementation for the new environment builds, database migration and upgrade projects.

Design database infrastructure and provide hardware & software requirement specifications.

Plan and execute SQL Server installations (2008/2008 R2/2012), upgrades and migrations.

Design DR, HA and reporting solutions with Log Shipping, Transactional Replication and Always-on technologies.

Setup maintenance plans for backup, Index and Stats updates.

Resolve critical alerts, incident and troubleshoot performance issues.

Used SQL Profiler traces and extended events to monitor database performance metrics.

Define SOP/Run books for routine change activities. Capacity planning of database servers using trends in growth and volume.

Performed SQL Cluster failovers and applied service packs during IW activities.

Perform data Encryption using TDE on database and Column Level

Design and implement SQL Standards with the help of Policy based management (PBM).

Resolved replication issues like Row not found & Primary key violation errors and reduce latency issues.

Automated replication activities to permanently fix the issues.

Deployed RFCs as a part to add/modify the functionalities to the application/databases.

Processed user requests received through tickets using CA Service desk & Service Now tools.

Configured & managed log-shipping between the servers and resolved latency issues.

Well versed with fog-light, Nagios & Spectrum monitoring tools.

Implemented CDC on production databases.

Performed L1 tasks on Oracle database.

Good knowledge on MongoDB which is based on JSON-like documents.

Environment: MS SQL Server 2005/ 2008/2008 R2/2012, Windows XP /Windows 7

Project: IMPAC Dec’10 to Sep’11

Client: IMPAC, USA

Role: Associate Software Engineer –DBA

Location: Pune, India

Description: IMPAC is one of the mortgage banking companies in the USA. Impac Mortgage Holdings Inc., a publicly traded firm offering consumer and wholesale lending, title, escrow, and REO services. This deals with high-margin residential and commercial mortgage loans.

Responsibilities:

Identify and resolve incidents by working closely with application teams.

Perform RCA to permanently resolve the performance bottlenecks.

Developed the scripts for production servers, which collect the metadata of all the databases and stores in the history tables.

Monitor failed jobs daily and resolve permanently.

Monitor and resolve alerts including log file growth, blocking, long running queries & mount point space issues.

Documented the SSIS packages, which update& load the databases on daily basis.

Defined backup strategies as per the size and criticality of databases.

Design custom scripts for database backups, index rebuild and update statistics.

Troubleshoot database performance issues by tuning indexes, updating stats & recompiling procedures.

Performance tuning with the help of SQL Server Profiler and query execution plan.

Created & implemented plan guides to avoid performance issues due to parameter sniffing.

Created stored procedures to fix the orphaned users.

Performed SQL server auditing & security Management.

Developed triggers for auditing SA Logins

Create logins, users and provide appropriate permissions.

Standardized the recovery models as per the need to prevent log file space issues.

Worked on user Ad-hoc requests like configure replication/log-shipping.

Perform code review & deploy the scripts given by developers.

Implemented partition techniques to standardize purge process across the board.

Resolve transactional replication latency issues by adjusting the thresholds.

Monitor SQL Servers for space, memory & CPU issues using Nagios monitoring tool.

Performed SQL failovers to balance the load during IW.

Environment: MS SQL Server 2008/2008 R2, Windows Server 2003/ XP

Contact this candidate