Pradeep Sathi
Senior SQL Server DBA
High Point,NC
Summary
- Results-oriented Database Administrator with 15+ years of extensive experience in
Planning, designing, coding, testing and Implementing database solutions in Dev,
UAT and Production environments.
SQL Server DBA experience in Healthcare, Finance, Banking, Insurance, Mortgage
and telecom domains. Areas of expertise include Database migrations from On-Prem
to On-Prem and On-prem to Azure, Automation of SQL Builds, Post builds, creating DB
Health Check Reports, Applying SQL Patches using PowerShell. Expertise in Designing
and Implementing solutions for AlwaysOn High Availability and Disaster Recovery.
Experience in Configuring and troubleshooting Replication. Extensive technical skills
and advanced understanding of SQL Server and Azure administration. Proactive in
establishing backup and recovery processes and protocols to protect and retain
valuable company data. Hands-On experience in Performance Tuning and
Automation. Strengths in troubleshooting and maintaining servers and systems to
support smooth business operations.
Motivated to stay informed of latest industry innovations to provide users with most
up-to-date solutions. Excellent communicator with advanced presentation creation
and delivery skills. Quickly and effectively identifies and resolves technical problems.
Strong collaborator and team player with excellent communication skills and
expertise in analytical problem-solving. - Microsoft Certified Azure Database Administrator Associate
https://www.youracclaim.com/badges/2d5f2462-ca5a-49bda367-
ca91a739ce1a/public_url
2020-06 Microsoft Certified Azure Administrator Associate
https://www.youracclaim.com/badges
/fda8cc98-0621-44a8-9483-2d5f7cafa37d/public_url
2020-03 Microsoft Certified Azure Fundamentals https://www.youracclaim.com
/badges/1dce29c9-2eb9-4339-b1dc-3ae7eadbdaef/public_url
Overview
15
15
years of professional experience
5
5
years of post-secondary education
3
3
Certifications
Work History
Senior SQL Server and Azure SQL DBA
Arch Capital Services Inc
Greensboro, NC
04.2019 - Current
- Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
- Created Automation scripts for SQL Server builds and Post-build tasks.
- Created Automation reports for backups, disk space, SQL Agent Job failures, users with elevated permissions etc..
- Create a lot of Azure SQL databases for modernize cloud ready applications.
- Produced high-standard database solutions to meet stability, reliability and performance metrics.
- Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
- Managed systems and infrastructures by defining hardware requirements and planning storage capacity for Mission critical servers and databases.
- Planned and implemented security measures to safeguard vital business data.
- Coordinated with project management staff on database development timelines and project scope.
- Eliminated downtime by accurately implementing HA and DR Solutions.
- Followed standard practices for migrating changes to test and production environments and provided technology support to meet business requirements.
SQL Server Database Administrator
LabCorp
Burlington, NC
11.2016 - 03.2019
- Migrated 1200+ Database backups from EMC Networker to Symantec NetBackup client. Installed Symantec NetBackup Client on 130+ SQL Servers.
- Reviewed, corrected and documented AlwaysOn Implementation issues on Myla and Agile applications.
- Installed SQL Server 2012/2014/2016/2017 versions through Automated Slipstreamed Installation on new servers.
- Applied SQL Server service packs through automation scripts.
- Automated email notification of Backup Audit reports for Full, Differential and T-Log backups thus by eliminating huge number of emails.
- Automated email notification Report for database health issues if exists any(Database files Auto Growth settings left at default values, Databases with large number of VLFs, Users that are having high level Privileges etc..)
Senior SQL Server Database Administrator
Cognizant Technology Solutions
Charlotte, NC
08.2015 - 11.2016
- Given solid capacity planning to LOBs for their future Data growth.
- Designed and Implemented AlwaysOn Technology for a mission critical application.
- Applied certified latest SQL Patches on SQL 2005,SQL2008, SQL2008R2,SQL2012.
- Applied MS Security patches relevant to SQL Server like MS14-044 etc.
- Troubleshooted database performance issues for applications like McAfee Endpoint, IT Security Data Warehouse
- Participated in the POC for Microsoft System Center Operations Manager (SCOM)
- Improved Backup performance for the IBM TDP for SQL Server.
- Participated and successfully completed DR Exercises for critical applications.
- Automating Database Health Check for across the servers.
Senior SQL Server DBA
TIAA
Charlotte, NC
10.2014 - 08.2015
- Documented and analyzed business reports for prompt communication, follow-up and ongoing support.
- Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
- Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
- Produced high-standard database solutions to meet stability, reliability and performance metrics.
- Periodically conducting health check on all the database servers that I am responsible for and ensure the stabilization of the servers all the time.
- Installing and Supporting SQL Servers in Multi Node Cluster Environments.
- Rolling out approved latest SQL Server service packs starting from Lower environments to higher environments.
SQL Server DBA
Bank Of America
Greensboro, NC
04.2013 - 09.2014
- Installed SQL Patches on all SharePoint Database servers including standalone, Active/Passive or Active/Active or n+1 clusters.
- Participated in Database Monitoring POC Tests for different products like Quest Foglight, IBM ITM, IPSoft, and Valkyrie.
- Installed 2nd Cluster SQL Instance on multiple Windows clusters to support migration of SharePoint 2007 farms to SharePoint 2010.
- Troubleshooting SQL Server production issues handed over by the offshore team.
- Validating daily/weekly/monthly checklist against all business critical database servers.
- Automating database refreshes to lower environments.
- Configuring and troubleshooting and management of Log Shipping, DB Mirroring, Clustering and Replication on database servers.
- Installing Oracle, Sybase, DB2, Teradata client software on SQL Servers and setting up DSNs and setting up Linked servers.
- Coordinating with BTG/LOB teams and educating them importance of upgrading servers/applying service packs etc..
SQL Server DBA
Barclays Capital
Jersey City, NJ
10.2012 - 03.2013
- Assisting Co-DBAs on their migration projects.
- Worked on SQL2012 AlwaysOn Projects with different flavors like FCI+AG and Standalone+AG on multi subnet environments.
- Troubleshooting performance issues using bank internal tools like precise, native SQL Server tools like profiler, DMVs and Database Tuning Wizard and perfmon.
- Controlling changes by implementing them first in Lower environments followed by Production by following the change approval process.
- Emediation of Security issues in database servers reported by Enterprise Security Management tools.
- Actively participated in implementing Change Requests.
- Managing SQL Server security by granting required access to Active directory groups wherever possible.
- Ensure all production jobs are running successfully.
SQL Server DBA
Bank Of America
Jersey City, NJ
04.2011 - 10.2012
- Troubleshooting performance issues using bank internal tools like precise, DNT and native SQL Server tools like profiler, DMVs and Database Tuning Wizard and perfmon.
- Validated daily/weekly/monthly checklist against all business critical database servers.
- Actively participating in Disaster Recovery Exercises.
- Code review and making sure code comply with current company standards.
- Testing the patches before deploying on production.
- Installing/upgrading tools like Litespeed and Foglight and precise on database servers.
- Installing, upgrading/migrating, Configuring database servers applying Service Packs and Cumulative Updates.
- Interacting with Security Audit team and working towards remediation of security vulnerabilities like removing elevated access in Database for the users.
SQL Server DBA
Prospect Mortgage
Sherman Oaks, CA
12.2010 - 03.2011
- Actively participated in gathering of User Requirement and System Specification, coordinating closely with managers and business users.
- Worked extensively on database space management, performance monitoring and alert management.
- Tuned SQL statements and stored procedures.
- Experience in Migrating from SQL Server 2005 to SQL Server 2008.
- Implemented Log Shipping to move the database to another server at regular intervals.
Senior Analyst
Bank Of America
Hyderabad, India
05.2009 - 08.2010
- Administering SQL Server Production Databases/Database servers.
- Backup and Restore and Refreshes.
- Ensure all production jobs are running successfully.
- Actively participating in Disaster Recovery Exercises.
- Monitoring and troubleshooting SQL Server Jobs (SQL Server Agent and Maintenance Plans Jobs).
- Installing, upgrading/migrating, Configuring database servers applying Service Packs and Cumulative Updates.
- Installing Litespeed and Foglight.
- Troubleshooting SQL Server production issues handed over from the L3 Team.
- Configuring and troubleshooting and management of Log Shipping, DB Mirroring, Clustering and Replication servers.
- Managing SQL Server security and logins.
- Importing Exporting data using DTS, SSIS packages.
- SSIS and SSRS Administration.
- Actively participated in implementing RFCs.
- Building rebuilding indexes to improve performance.
Dealing with performance issues on production servers. Search
performance bottlenecks or perform other monitoring tasks using SQLServer Profiler. - Moving objects from QA to Production databases.
Security of Data and Database System. - Ensuring all the RFCs closed as per the SLAs.
Provided 24x7 supports, Supported systems beyond regular hours/weekends/ holidays. - Code review and making sure code comply with current company
standards. - Testing the patches before deploying on production.
Working with application developers to know how front-end application work and testing results. - Indexing database and making sure required indexes are present on all objects.
Senior Analyst
Verizon Data Service India Pvt.Ltd
Hyderbad, India
02.2007 - 04.2009
- Designed and implemented SQL Server 2000/2005 databases for mission critical business applications by using Microsoft .NET N-tier Enterprise Application Architecture.
- Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.
- Provided support to business operational models, including off-hour support.
- Modeled and forecasted database and platform resource utilization to meet user needs and respond to anticipate technological innovations.
- Created logical and physical database design, data structures, and implemented large databases using Erwin.
- Created and developed the stored procedures, triggers, views, and user-defined functions to handle complex business rules, activity log, error log, and audit analysis.
- Developed and created data dictionary, tables, views, indexes, and functions advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager.
- Developed, modified, and optimized very complex queries to data retrieval and modification.
Developed scripts to migrate data from multiple sources. - Scheduled and monitored all maintenance activities of SQL Server 2000 including database consistency check, and index defragmentation.
- Monitored database status including CPU, memory, I/O, space, and dead lock using SQL Server Utilities.
- Worked closely with IT project managers, programmers, and testers.
SQL Server Database Administrator
Wipro Infotech
Hyderabad, India
07.2006 - 01.2007
- Developed custom database objects, stored procedures and delivered application support.
- Produced high-standard database solutions to meet stability, reliability and performance metrics.
- Followed standard practices for migrating changes to test and production environments and provided technology support to meet business requirements.
- Documented and analyzed business reports for prompt communication, follow-up and ongoing support.
Consultant - Database
Proquest Syncata India Pvt.Ltd
Noida, India
12.2005 - 06.2006
- Supported clients with business analysis, documentation and data modeling.
- Planned and implemented security measures to safeguard vital business data.
- Created scripts and processes for data integration and maintenance.
- Authored and coded logical and physical database descriptions.
- Created optimal technical solutions to user needs through research and in-depth system analysis.
- Supported multiple concurrent projects enabling delivery efficiencies and technical resolution.
Education
Master of Science - Information Systems
Andhra University
INDIA 06.2002 - 04.2004
Bachelor's - Computer Science
Andhra University
INDIA 06.1999 - 04.2002
Skills
Microsoft Azure Database Administration
Microsoft Azure Administration
SQL Server On-Prem to Azure Migration
SQL Server Automation (Installs/Patches/post builds/Reports)
SQL Server 2019/2017/2016/2014/2012/2008
Windows Server 2019/2016/2012R2/2012
SSIS/SSRS/SSAS
Microsoft SCOM, Quest Foglight, Quest Spotlight, Idera SQL Diagnostic Manager, IBM ITMS, IBM Guardium, Precise, BMC Remedy ITSM, Solarwinds Orion and DPA
Quest Litespeed, IBM TSM, EMC DDBoost, EMC Networker, Symantec NetBackup
T-SQL, PowerShell
ServiceNow, Maximo, FrontRange Heat
BMC BladeLogic Automation Suite, CA Autosys, ASG Rochade
Azure SQL Database, Azure SQL Managed Instance, Database Administration, Performance Tuning, High Availability & Disaster recovery
Microsoft Azure Synapse Analytics or Azure SQL DW Administration
Accomplishments
- Recovered 100+ SQL Servers when LabCorp was attacked by Ransomware on July 2018.
Certification
Microsoft Certified Azure Database Administrator Associate https://www.youracclaim.com/badges/2d5f2462-ca5a-49bda367- ca91a739ce1a/public_url
Timeline
Microsoft Certified Azure Database Administrator Associate https://www.youracclaim.com/badges/2d5f2462-ca5a-49bda367- ca91a739ce1a/public_url
11-2020
Microsoft Certified Azure Administrator Associate https://www.youracclaim.com/badges /fda8cc98-0621-44a8-9483-2d5f7cafa37d/public_url
06-2020
Microsoft Certified Azure Fundamentals https://www.youracclaim.com /badges/1dce29c9-2eb9-4339-b1dc-3ae7eadbdaef/public_url
03-2020
Senior SQL Server and Azure SQL DBA
Arch Capital Services Inc
04.2019 - Current
SQL Server Database Administrator
LabCorp
11.2016 - 03.2019
Senior SQL Server Database Administrator
Cognizant Technology Solutions
08.2015 - 11.2016
Senior SQL Server DBA
TIAA
10.2014 - 08.2015
SQL Server DBA
Bank Of America
04.2013 - 09.2014
SQL Server DBA
Barclays Capital
10.2012 - 03.2013
SQL Server DBA
Bank Of America
04.2011 - 10.2012
SQL Server DBA
Prospect Mortgage
12.2010 - 03.2011
Senior Analyst
Bank Of America
05.2009 - 08.2010
Senior Analyst
Verizon Data Service India Pvt.Ltd
02.2007 - 04.2009
SQL Server Database Administrator
Wipro Infotech
07.2006 - 01.2007
Consultant - Database
Proquest Syncata India Pvt.Ltd
12.2005 - 06.2006
Master of Science - Information Systems
Andhra University
06.2002 - 04.2004
Bachelor's - Computer Science
Andhra University
06.1999 - 04.2002