Sql server
Jefferson Lourthusamy J
DBA Manager
Chennai,TN
Summary
- 15+ years of experience in enterprise database administration across on-prem and cloud environments
- Expert in SQL Server (on-premises, Azure VM, Azure SQL, AWS RDS) with deep HA/DR expertise
- Hands-on experience managing AWS RDS (SQL Server / PostgreSQL / MySQL) environments
- Strong experience in on-prem to cloud database migration and modernization (Azure & AWS)
- Hands-on with automation using PowerShell, T-SQL, and SQL Agent
- Working knowledge of PostgreSQL, Oracle, and MySQL administration
- Experience supporting mission-critical, high-availability systems (24x7 production)
- Proven track record in performance tuning, incident resolution, and capacity planning
Overview
17
17
years of professional experience
3
3
Certifications
Work History
DBA Manager
Prophoenix Consultancy
Chennai, Tamil Nadu
06.2024 - Current
- Managing enterprise-scale SQL Server environments across on-premises, Azure, and AWS RDS setups
- Administering databases with focus on performance, availability, and stability
- Managing AWS RDS instances including:
Creating and managing snapshots (manual & automated backups)
Configuring and tuning parameter groups
Monitoring using Performance Insights and CloudWatch
Handling Multi-AZ deployments and failover scenarios
Performing restore operations from snapshots - Implemented automated database health checks using PowerShell and T-SQL
- Established proactive monitoring to detect:
Performance bottlenecks
Blocking and deadlocks
Resource contention issues - Improved database performance through:
Index tuning
Query optimization
Execution plan analysis - Managed backup and recovery strategies, including validation and restore testing
- Supported multi-server and multi-cloud environments, ensuring consistency and reliability
- Automated routine DBA tasks such as:
Maintenance jobs
Backup verification
Performance reporting - Innovation Tournament Winner for database automation improvements
Datastore Admin -2
IQVIA India Pvt Ltd
Coimbatore, Tamil Nadu
04.2023 - 04.2024
- Supported large-scale healthcare database systems hosted on hybrid environments including AWS RDS
- Managed high-availability SQL Server and RDS environments with minimal downtime
- Performed RDS administration including:
Monitoring database performance using Performance Insights
Managing snapshots and backup retention
Supporting failover testing in Multi-AZ environments - Performed advanced performance tuning and query optimization
- Conducted detailed analysis of:
Execution plans
Index usage
Query performance issues - Handled production incidents and root cause analysis (RCA)
- Improved system performance through:
Index optimization
Statistics maintenance - Coordinated with application teams for database performance improvements
- Best Employee (Bronze Award) for consistent delivery and excellence
Assistant Consultant
Tata Consultancy Services
Chennai, Tamil Nadu
05.2019 - 04.2023
- Managed multiple enterprise SQL Server environments across global clients
- Designed and implemented High Availability and Disaster Recovery (HA/DR) solutions:
Always On Availability Groups
Log Shipping
Disaster Recovery planning and testing - Led database migration and upgrade projects, including cloud readiness initiatives
- Automated DBA operations using:
PowerShell scripts
SQL Server Agent jobs - Performed deep troubleshooting of:
Blocking and deadlocks
CPU bottlenecks
Disk IO issues - Tuned database performance by:
Query optimization
Index tuning - Managed backup and recovery processes ensuring data integrity
Mentored junior DBAs and supported knowledge sharing - Long Service Award for dedication and performance
Senior Systems Executive
Cognizant Technology Solutions
Chennai, Tamil Nadu
03.2009 - 04.2015
- Started career as SQL Server DBA supporting production and non-production systems
- Managed core DBA activities:
Backup and recovery
Maintenance plans
Security and access control - Monitored and resolved database issues including:
Blocking
Deadlocks
Performance degradation - Developed strong foundation in:
SQL Server architecture
Query tuning
Troubleshooting techniques - Supported development teams with:
Database deployments
Performance tuning
Education
Bachelor of Science - Physics
Loyola College
Chennai, India 04.2001 -
Skills
Database monitoring
Database management
Database administration
Backup and recovery
Relational databases
Running backups
Performance tuning
Database design
Database development
Database troubleshooting
Query optimization
Disaster recovery
Data migration
Data security
Patch management
SQL proficiency
Database normalization
Index management
Relational database management
Stored procedures
Process automation
Cloud database services
Software
Postgresql
Oracle
Mysql
Azure VM
Azure managed instance
Azure sql
Rds
Snapshots
Parameter groups
Option groups
Performance insights
Monitoring
Multi az deployment
Certification
AWS Certified Cloud Practitioner (CLF-C01)
Awards
- Prophoenix – Innovation Tournament Submission
- IQVIA – Bronze Award for Best Employee
- TCS – Long Service Award
Timeline
DBA Manager
Prophoenix Consultancy
06.2024 - Current
Datastore Admin -2
IQVIA India Pvt Ltd
04.2023 - 04.2024
Assistant Consultant
Tata Consultancy Services
05.2019 - 04.2023
Senior Systems Executive
Cognizant Technology Solutions
03.2009 - 04.2015
Bachelor of Science - Physics
Loyola College
04.2001 -