Sql Server Ms

Jayapal Cholleti

SQL Server\Cloud Database Administrator

Phone: +1-562-***-**** Email: ********.***********@*****.*** PROFESSIONAL SUMMARY:

• Over 13+ Years of IT experience in Development, Management, Support of MS SQL Servers 2022,2019,2016,2017,2014,2012,2008,2005,2000 in Production, QA\Development Environments.

• Microsoft Certified Professional in Administering SQL Server.

• Domain knowledge in Health care, Health Insurance, Financial Domains

• Implemented High Availability & Disaster Recovery techniques like Always ON High Availability Groups, SQL Clustering (Both Active-Active and Active--Passive) on windows failover cluster.

• Upgrading database servers from SQL Server 2008 and 2012 to SQL Server 2016\2017\2019\2022 Always high availability environment.

• Planning and Implementing the Replication of MS SQL Server Databases

• Good Knowledge on VMWare and Snap Center (Adding resources and extending disk etc.)

• Extensive Experience in MS SQL Server Database Administration including planning, Installation, Deployment and configuration.

• Creating Maintenance plans to automate daily maintenance activities

• Hands on experience in Database Support, Data analysis and fixing.

• Played a key role in business requirements analysis, physical and logical Data modeling, application development, testing, training, production support and Project review with client.

• Experience in Full, Differential and Transaction Log Backup strategies and configuring backups using third party tools like Lite speed, Commvault

• Good Knowledge of SSIS, SSAS, SSRS, OLTP,OLAP.

• Scheduled and monitored all maintenance activities including database consistency check

• Experience in Installation, Configuration and Upgrading of MS SQL Server, Client Software and related products for Production, Development and Test Environment.

• Experience in writing stored procedures as well analyzing and debugging existing complex stored procedures.

• Experience in data integration and data migration.

• Experience in Creating jobs, alerts, log to monitor the database errors

• Experience in Backups, Clustering, Capacity planning, Performance Tuning and troubleshooting.

• Experience in Native Tools for Performance Monitoring as well as third party tools

(SQLDM\Redgate) and Tuning of MS SQL Server

TECHNICAL SKILLS:

Operating Systems Windows XP/2012/12008/2003/ NT/98, DOS Databases MS SQL Server 2022,2019,2016,2012, 2008,2005, 2000, MS- Access

Languages T-SQL, PowerShell, VB6.0,.Net, VBScript, XML Other Tools SQLDM, SQLCM, SSMA, Lite speed backup, Delphix, Vormetric, Splunk,

Ticketing Tools Service Now, ConnectWise, JIRA, and BMC Remedy

PROFESSIONAL EXPERIENCE:

Lumen21 INC Aug 2016 –Till date

Client: City of Long beach, California

Dec 2018 –Present

Senior SQL Database Administrator

Responsibilities:

• Creating and maintaining SQL Server database standards and policies

• Supporting SQL database design, creation, and testing activities

• Managing the database availability and performance, including incident and problem management

• Designing database backup, archiving, and storage strategy

• Migrated the databases from standalone and WSFC to Always on high availability nodes.

• Defining and implementing event triggers that will alert on potential database performance or integrity issues

• Performing database housekeeping, such as update stats, indexing, etc.

• Identifying reporting, and managing database security issues, audit trails, and forensics

• Prepare Status decks and Present in Management\client status calls

• Installation\Up gradation of SQL Servers and Service Packs.

• Configure Disaster Recovery and Participate in yearly DR Tests

• Maintenance, conversion and improvement of all existing jobs in SQL Agent

• Automation of Database Restores using SQL Agent jobs from PROD to Non PROD

• Disk space allocation\Database Restores using Snap Center tool

• Promoting\Scheduling and maintaining SSSIS packages from Non Prod and PROD

• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

• Maintained production database, along with supporting development and testing environment.

• Troubleshoot production database server, user administration, configure SQL Server, creating databases for development and testing environments, capacity planning, performance tuning and database monitoring.

• Migrated the databases from sql server 2008 and 2014 to 2016\2019\2022

• Managing SQL Servers in development and production.

• Creating and managing schema objects such as tables, views, indexes, procedures, triggers. Client: United Health group

Feb 2021 – Dec 2023

Senior SQL Database Administrator

Responsibilities:

• Handling daily Management Status calls and Client\Team calls

• Preparing and presenting governance decks for Monthly and Bi weekly client calls

• Preparing and implementing migration plans for SQL databases from On-prem to GCP cloud

• Preparing Automation scripts where ever required

• Finding opportunities and implementing the themes as part of CSI

• Upgrading database servers from SQL Server 2012 to SQL Server 2016\2017\2019.

• Create and maintain Technical documentations and SOPs.

• Support for ongoing databases/applications.

• Setup and automate internal processing tasks and backup tasks as well as setting up alerts to monitor the server and database health

• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.

• Security Implementation. Administering the MS SQL server by creating users logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of Groups, Granting the Privileges to Users and Groups.

• Managing the use of Power Shell scripts for disk space, memory and connections Client: Molina Health Care, California

08/2016 – November 2018

Team Lead\ Senior SQL Server DBA

Responsibilities:

• Manage 10+ DBA’s team and point of contact for any technical issues

• Installing, configuring, and managing SQL Server on Client sites as well as on in-house servers.

• Installing, configuring, managing Windows Severs (Windows Server 2008 R2), Virtual Server, DPM (Data Protection Manager), SCOM (System Center Operation Manager), Windows Clustering along with SQL Clustering.

• Migrated the instances to Always on Availability.

• Extensive hands on experience on multiple third-party tools such as Delphix for very large database restore, Vormetric Encryption for Data Security at file level, Lite Speed and Idera for Database backups.

• Experience on troubleshooting critical production issues by using Solar Winds Database Performance Analyzer (DPA) such as database slowness issues, worst performance queries, blocking, deadlocks and resource Utilization in database servers.

• Knowledge on Splunk monitoring tool to set up alerts such as long running queries and Disk space monitoring for critical application related servers to avoid space issues for production databases.

• Configured Replication through third party Replication tool i.e. Attunity Replicate to refresh data between Production and Reporting environments which uses production backups to read the Transactions and apply changes on the Target.

• Doing DB Refresh from Productions servers to Dev, UAT, Test and Reporting Servers using San Cloning or Delphix or SQL Agent Jobs or Manually through T-SQL.

• Managing/ maintaining / updating proper indexes at all customer/In-House servers.

• Monitoring Database performance and optimizing performance using tools like Profiler, DPA, SQL logs and Event logs.

• Taking Backups, Restoring Backups, and Scheduling backup jobs.

• Checking for drive space issues and shrinking the SQL Server database files as necessary.

• Configuring SQL Server Memory settings, service packs, deploying databases, mapping user accounts to logins and assigning permissions and roles.

• Remotely handling more than 300 Servers having an average of 15 databases in each server at various places in US.

• Server reboot checks and analysis about server settings and cause of reboots and make sure SQL server related Services are running fine in Auto Start mode.

• Implementing Log shipping in various client servers.

• Configuring and implementing Replication and HA options (Mirroring and Log Shipping) in various client servers.

• Monitoring Event Logs and SQL Server Logs of Servers in a scheduled manner.

• Assisting customer / in-house users / developers for any SQL / Windows issues.

• Planning suitable backup and recovery strategies for all databases to ensure better recoverability.

• Creating and scheduling SQL Job.

• Creating, managing users and their permissions as per the requirement.

• Managing tables, indexes, and other database objects.

• Creating & maintaining Database files, Transaction log files, DTS, Views, Triggers and Stored Procedures.

Lumen21 Infoserv India Pvt. Ltd.

April 2011 – 08/2016

SQL Server DBA Team Lead

Responsibilities:

Client: March Vision Care

• Act as Database Team lead for SQL Server DBA Team

• Prepare Status decks and Present in Management\client status calls

• Upgrade database servers from SQL Server 2005\2008\2012\2014.

• Responsible for maintaining production, testing, and training databases, supporting development and testing environment

• Database code review and approve

• Responsible from implementation and maintenance for transactional replication.

• Responsible for database promotions from dev and sys environments to production environments.

• Write database scripts to automate the database activities.

• Create and maintain technical documentation.

• Created jobs, alerts, log to monitor the database errors.

• Involved in various stages like development, Testing and Support.

• Created Functions, Triggers, Stored Procedures, Databases, and views

• Support for ongoing databases.

• Using SQL Agent to setup and automate internal processing tasks and backup tasks as well as setting up alerts to monitor the server and database health

• Resource (Disk, CPU) addition\Modification in VM Ware

• Make sure no backlogs in ticketing system and bring the tickets to closure

• Install and configure high availability like replication, Clusters and Mirroring

• Prepare project plans for Migrations\Up gradations

• SQL Server health check automation

Client: Cathay Bank

Responsibilities:

• Install\Configure SQL Servers and post installs

• Upgrade database servers from SQL Server 2008\2012\2014 .

• Responsible for maintaining production, testing, and training databases, supporting development and testing environment

• Database code review and approve

• Work on EOL project and Security project

• Review and approve\schedule Change requests

• Work on Incident\Change\Problem and Service requests

• Write database scripts to automate the database activities.

• Create and maintain technical documentation.

• Make sure no backlogs in ticketing system and bring the tickets to closure

• Experience in tuning SQL queries & improving the performance of the Database and Applications.

• Experience in providing Production support for Database and Applications.

• Extensive experience with Monitor, tune and analyze database performance and allocate server resources to achieve optimum database performance.

• Outstanding knowledge of high availability SQL Server solutions, including Log shipping, Mirroring, Replication.

• Creating jobs and sending alerts using SQL Mail. Prepare project plans for Migrations\Up gradations

• SQL Server health check automation

• Implementation of Commvault backups to replace Net backups Client: Silverman Acampora

SQL Server DBA

Responsibilities:

• Install\Configure SQL Servers and post installs

• Migrate Sybase databases to SQL Server

• Secondary support for Sybase database servers

• Work on inter developed replication between Sybase and SQL Server

• Upgrade database servers from SQL Server 2008\2012 to SQL Server 2014.

• Responsible for maintaining production, testing and training databases, supporting development and testing environment

• Database code review and approve

• Review and approve\schedule Change requests

• Work on Incident\Change\Problem and Service requests

• Write database scripts to automate the database activities.

• Create and maintain technical documentation.

• Make sure no backlogs in ticketing system and bring the tickets to closure

• Prepare project plans for Migrations\Up gradations

• SQL Server Mirroring and Replication automation

• Implementation of Commvault backups to replace Net backups Client: COG Water and Power

Responsibilities:

• Providing 24/7 On-Call support critical production databases

• Work on incidents and Service task through Service Now and on Change management, Capacity management, Release Management

• Installing SQL Servers and upgrading\migrating SQL databases

• Configuring High Availability features (Mirroring Log shipping, Replication) and Reporting and resolving critical SQL Server alerts.

• Testing and setting up new features in SQL Servers and Setting up best practices in the environments

• Refreshes from Production backup to Stage and Development environments

• Doing performance tuning at database and query level to improve user experience

• Ensure backup strategies meets business requirements (RPO/RTO).

• Work on designing scripts for the maintenance activities of the Database

• Follow change control procedures to migrate code into production servers EDUCATION:

Bachelor of Engineering, Osmania University, India 2004

Contact this candidate