Sql Server Database Administrator

Rajesh Chennupati

Senior SQL Server & PostgreSQL Database Administrator

****************.****@*****.*** www.linkedin.com/in/rajeshchennupati +1-279-***-**** Folsom, CA.

Professional Summary

Results-driven SQL Server Database Administrator with 13.6 years of experience in database administration, performance tuning, backup and recovery, and high availability solutions. Adept at managing large-scale SQL Server environments, ensuring database integrity, and optimizing performance for mission-critical applications. Proven expertise in implementing security best practices and disaster recovery strategies.

Technical Skills

●Databases: SQL Server 2012/2014/2016/2019/2022, Azure SQL, AWS RDS SQL,Postgres 11..17 & Redshift.

●High Availability & DR: Always On Availability Groups, Database Mirroring, Log Shipping, Replication, Active Geo-Replication,Azure Failover groups,Postgres Streaming replication, Streaming replication with replication slot.

●Performance Tuning: Query Optimization, Indexing, Execution Plans, Partitioning, Profiler,Perfmon

●Security & Compliance: TDE, Alway Encrypted, Dynamic Data masking, SQL Auditing, User Permissions, SOX, GDPR, HIPAA Compliance

●Scripting & Automation: T-SQL,PL/pgSQL, PowerShell, Shell Script, SSIS, SSRS, SQL Agent Jobs.

●Cloud & Virtualization: Microsoft Azure, AWS RDS, VMware, Hyper-V.

●Tools & Utilities: SSMS, Idera,Redgate, DTA, Profiler, Extended Events,pgAdmin,dbeaver.

●BI Tools: SSDT, Visual Studio 2005/2008/2012/2015,2017/2019, SSIS,SSAS,SSRS, POWER BI.

●Backup Tools or S/W’s: Veritas Net backups, Commvault, BARMAN, PG_BACKREST.

●Ticketing Tools: BMC remedy, Service Now.

Professional Experience

Senior Database Administrator

Client: California Department of Corrections and Rehabilitation Jan 2025 – Present

●Administer and maintain SQL Server databases, ensuring high availability and optimal performance.

●Implement and manage Always On Availability Groups (AOAG) and database replication(Transactional & Snapshot) strategies.

●Optimize complex queries, indexes, and database structures to improve performance.

●Perform database backup and recovery planning to ensure business continuity.

●Monitor database health and security, enforcing best practices for data integrity.

●Implemented encryption methodologies such as TDE, Always Encrypted, and Dynamic Data Masking to safeguard PII and PHI data, ensuring compliance with security standards.

●Managed and supported SQL databases in both IaaS and PaaS models within the Azure Cloud, ensuring performance, security, and availability.

●Effectively coordinate and implement patches for SQL Server instances, ensuring minimal downtime while maintaining compliance with security policies and industry standards.

●Managed SQL databases on AWS Cloud, including RDS and EC2 instances, ensuring high availability and performance.

●Adhere to ITIL processes, including incident, change, and problem management, to ensure efficient service delivery and enhanced customer satisfaction

●Automate database maintenance tasks using PowerShell and SQL Agent Jobs.

●Design, implement, and manage Change Data Capture (CDC) processes for real-time data replication and synchronization.

●Installed and configured PostgreSQL on Linux systems from source and package distributions, ensuring optimal performance and reliability.

●Automated database tasks (backups, bloat checks, alerting using shell scripts and cron jobs.

●Optimized PostgreSQL performance by tuning autovacuum parameters to maintain up-to-date table statistics and efficiently reclaim space from dead tuples.

●Proficient in enabling Transparent Data Encryption (TDE) in EnterpriseDB & implementing column-level encryption in PostgreSQL using the pgcrypto extension.

Environment: SQL Server 2012-2019, Windows Server 2012/2016, VMware, SSMS, ServiceNow

Team Lead – SQL Database Administrator

Clients: AFLAC, Dun & Bradstreet Feb 2020 – Jan 2025

●Administer and maintain SQL Server databases, ensuring high availability and optimal performance.

●Managed database migration projects, including on-prem to cloud transitions.

●Successfully migrated on-premises SQL Server databases to Azure SQL Database and Azure SQL Managed Instance, ensuring minimal downtime and data integrity throughout the process.

●Designed and implemented disaster recovery plans and high availability solutions.

●Managed SQL databases on AWS Cloud, including RDS and EC2 instances, ensuring high availability and performance.

●Tuned queries, indexes, and stored procedures to improve application performance.

●Managed and supported SQL databases in both IaaS and PaaS models within the Azure Cloud, ensuring performance, security, and availability.

●Provided database support for developers and troubleshooting application performance issues.

●Optimized SQL Enterprise licensing costs by strategically downgrading SQL database editions while maintaining performance and compliance..

●Automate database maintenance tasks using PowerShell and SQL Agent Jobs.

●Perform database backup and recovery planning to ensure business continuity.

●Implemented encryption methodologies such as TDE, Always Encrypted, and Dynamic Data Masking to safeguard PII and PHI data, ensuring compliance with security standards.

●Conducted regular disaster recovery drills to ensure seamless database service recovery in the event of actual disasters.

●Monitor database health and security, enforcing best practices for data integrity.

●Installed and configured PostgreSQL on Linux systems from source and package distributions, ensuring optimal performance and reliability.

●Responsible for granting permissions and monitoring the performance, security, and availability of Amazon Redshift databases.

●Design, implement, and manage Change Data Capture (CDC) processes for real-time data replication and synchronization.

●Optimized PostgreSQL performance by tuning autovacuum parameters to maintain up-to-date table statistics and efficiently reclaim space from dead tuples.

●Established and maintained robust security and integrity controls for PostgreSQL databases, ensuring data protection and compliance with industry standards.

●Proactively managed standby replication methodologies, including Streaming Replication, Cascade and replication slot, to ensure disaster recovery readiness and high availability.

●Proficient in enabling Transparent Data Encryption (TDE) in EnterpriseDB & implementing column-level encryption in PostgreSQL using the pgcrypto extension.

●Configured SSL/TLS protocols to enforce secure client connections, ensuring data security during transmission.

●Monitored query performance using pg_stat_statements and EXPLAIN ANALYZE.

●Automated database tasks (backups, bloat checks, alerting using shell scripts and cron jobs.

●Administered PostgreSQL role-based access controls (RBAC), managing user roles, privileges, and authentication mechanisms to enforce database security, least-privilege access, and compliance with industry standards.

●Deployed and monitored failover solutions using a tool called repmgr.

●Migrated on-prem PostgreSQL databases to AWS RDS and Aurora PostgreSQL using AWS DMS and Schema Conversion Tool (SCT).

●Managed PostgreSQL tablespaces to optimize disk utilization, improve query performance, and support high-availability database architectures.

●Developed and automated PostgreSQL administrative tasks using Shell scripting to streamline database maintenance, optimize performance, and enhance system reliability.

●Successfully performed both minor and major PostgreSQL version upgrades, ensuring system stability and data integrity throughout the process

●Monitored and optimized database performance by identifying bottlenecks and fine-tuning queries and indexes, ensuring efficient data retrieval and system responsiveness.

Environment: SQL Server 2016, 2019, 2022, Azure IaaS/PaaS, AWS RDS, PostgreSQL 14-16, SSIS, Power BI

Lead Database Administrator

Client: Philip Morris International (PMI) Jul 2019 – Feb 2020

●Administer and maintain SQL Server databases, ensuring high availability and optimal performance.

●Deployed DTSX packages and RDL files across SSIS and SSRS servers to support data extraction and reporting functions efficiently.

●Perform database backup and recovery planning to ensure business continuity.

●Managed and maintained consistent development, testing, staging, and production environments across physical servers and VMware virtual machines

●Tuned queries, indexes, and stored procedures to improve application performance.

●Upgraded SQL Server 2012 cluster instances to SQL Server 2016 across development and production environments, ensuring minimal downtime and optimal performances.

●Automate database maintenance tasks using PowerShell and SQL Agent Jobs.

●Monitor database health and security, enforcing best practices for data integrity & security.

●Experience with optimizing and supporting large multi-terabyte production databases.

●Administer and troubleshoot SQL Server databases including security patching, SQL tuning, Instance tuning, memory utilization, highly skilled in identifying and resolving complex query bottlenecks.

●Responsible for gathering and generating SOX-compliant audit reports to ensure database security, regulatory adherence, and risk management.

●Implemented system updates that improved functionality and aligned with organizational objectives, adhering to best practices and change management protocols.

●Implemented problem management strategies to identify root causes and apply permanent solutions, enhancing system reliability and performance.

●Implemented data partitioning using partition functions and schemas to manage tables exceeding 2TB, enhancing performance and maintainability.

●Integrated heterogeneous data sources into data warehouse solutions, ensuring seamless data collection and consolidation.

●Installed and configured PostgreSQL database clusters on Linux (RHEL/CentOS) & Windows server.

●Performed point-in-time recovery (PITR) for PostgreSQL using WAL files and tested restore strategies regularly.

●Implemented automated backup strategies using pg_basebackup, pg_dump & WAL archiving.

●Configured pg_hba.conf and SSL/TLS for secure connections and enforced role-based access control (RBAC).

Environment: SQL Server 2012-2016, SSMS, PowerShell, Windows Server 2012R2, RHEL, Postgres 11

Tech Lead

Client: Xerox International Jul 2015 – Jul 2019

●Administer and maintain SQL Server databases, ensuring high availability and optimal performance.

●Extensively worked on Installation,configuration of different version SQL Servers in both Cluster &; Standalone servers.

●Perform database backup and recovery planning to ensure business continuity.

●Designed and implemented a Windows Server Failover Cluster (WSFC) to establish a high-availability and disaster recovery solution using Always On Availability Groups (AOAG).

●Managed database inventory updates and documented Standard Operating Procedures (SOPs) to ensure accurate records and streamlined processes.

●Tuned queries, indexes, and stored procedures to improve application performance.

●Optimized failover cluster network thresholds to enhance stability and ensure sustained database performance at optimal levels.

●Monitor database health and security, enforcing best practices for data integrity.

●Implemented database mirroring and transaction log shipping to enhance disaster recovery capabilities and ensure high availability.

●Applied and maintained service packs and cumulative update patches to enforce security policies and ensure system integrity.

●Scaled database systems to accommodate organizational growth, ensuring optimal performance and seamless data management.

●Implemented and maintained database monitoring tools to proactively identify and resolve issues, ensuring optimal system performance and reliability.

●Monitored database growth and ensured resource allocation met future capacity requirements, maintaining optimal performance and scalability.

●Collaborated with the security team to monitor and address potential database vulnerabilities and security incidents, ensuring robust data protection and compliance with organizational policies.

Environment: SQL Server 2010-2015, VMware, SSRS, SSIS, DTS

Technical Specialist

Clients: Lantiq, GAIC (Great American Insurance Company) Jun 2011 – Jul 2015

●Administer and maintain SQL Server databases, ensuring high availability and optimal performance.

●Managed database inventory updates and documented Standard Operating Procedures (SOPs) to ensure accurate records and streamlined processes.

●Executed regular database refresh requests from Production to Development and QA environments, ensuring accurate and up-to-date data for testing and development.

●Responsible for creating server logins, database users, and roles, and granting necessary permissions based on customer requirements.

●Successfully implemented Database Mirroring and Transaction Log Shipping as key components of a disaster recovery solution, ensuring high availability and data protection.

●Diagnosed and resolved database-related issues, including performance problems, deadlocks, and data corruption, ensuring optimal system functionality and reliability.

●Transformed and migrated data between various formats, such as Excel to SQL, Oracle to SQL ensuring accurate and efficient data integration.

Environment: SQL Server 2000-2012, Windows Server 2003/2008, SSIS, PowerShell

Education & Certifications

●Master of Computer Applications (MCA) – Acharya Nagarjuna University, India, 2007

●Bachelor of Science (BSc) – Acharya Nagarjuna University, India, 2003

●Microsoft Certifications:

DP-300: Microsoft Certified Azure Database Administrator Associate

MCSA (70-765: Provisioning SQL Databases)

MCPS (70-764: Administering a SQL Database Infrastructure)

MCTS (70-432: SQL 2008 Implementation & Maintenance)

●ITIL Foundation v3.0

Achievements

●Implemented AlwaysOn HA/DR solution, ensuring 99.8% uptime for business-critical applications.

●Led a database migration project that resulted in a 35% reduction in enterprise license costs, optimizing resource allocation and budget efficiency.

●Successfully reduced query execution time by 25% through query optimization.

Additional Information

●Availability: Notice period 14 days

●Work Authorization: H1B

●Willing to relocate

Contact this candidate