Summary
Overview
Work History
Education
Skills
Software
Certification
Awards
Timeline
Generic

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

Sql server

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 -
Jefferson Lourthusamy JDBA Manager