JANANI R
Summary
Senior SQL DBA with strengths in designing scalable transactional and analytical database architectures. Implements advanced HA/DR solutions with SQL Server Always On and Failover Cluster Instances, ensuring robust data protection. Manages backups and disaster recovery plans to mitigate data loss.
Overview
7
7
years of professional experience
Work History
Senior SQL DBA
HDB Financial Services Ltd
01.2024 - 02.2026
- Designing highly scalable transactional (OLTP) and analytical (OLAP) database architectures from scratch.
- Advanced deployment of enterprise HA/DR solutions, specifically SQL Server Always On Availability Groups and Failover Cluster Instances (FCI).
- Managed backups, restoration, and disaster recovery plans to prevent data loss.
- Performed backups and procedures for quick data recovery.
- Designed database architecture, data structures and tables to project specifications.
MS SQL Server Developer
CAMS (Computer Age Management Service Ltd)
10.2022 - 12.2023
- Advanced T-SQL coding including complex stored procedures, user-defined functions, and dynamic SQL.
- Heavy performance tuning using SQL Server Profiler, Database Engine Tuning Advisor, and analyzing Execution Plans.
- Building production-grade ETL processes via SQL Server Integration Services (SSIS) and reporting systems via SSRS or Power BI.
- Implementing administrative routines like index maintenance, database consistency checks (DBCC), and partition strategies.
Junior SQL Developer
Altruist Technologies Pvt Ltd
10.2018 - 09.2022
- Collaborated with cross-functional teams to gather requirements and deliver custom database solutions.
- Developed data models and database designs to plan projects.
- Writing foundational relational database queries using basic T-SQL commands.
- Understanding database constraints, primary/foreign keys, joins, and database normalization.
- Basic familiarity with SQL Server Management Studio (SSMS).
Education
B.E - computer science of Engineering
S A ENGINEERING COLLEGE
Chennai01-2018
Skills
- T-SQL, Stored Procedures, Indexing, SSIS
- Data auditing, Database migrations
- Performance tuning
- ETL development
- Backups, Security, High Availability, Tuning
- SQL Server
- Disaster recovery
KEY ACHIEVEMENTS
- Intelligent Query Process
Features like Adaptive Query Processing and Automatic Tuning adjust query execution plans dynamically to accelerate performance without code changes.
- In-Memory Database Technology
Achieved massive transaction throughput by allowing memory-optimized tables and indexes (In-Memory OLTP) and persistent memory (PMEM) support.
- High Availability & Scalability
Features Always On Availability Groups and Accelerated Database Recovery (ADR) to ensure instant, reliable failover and reduced recovery times in mission-critical environments.
Timeline
Senior SQL DBA
HDB Financial Services Ltd
01.2024 - 02.2026
MS SQL Server Developer
CAMS (Computer Age Management Service Ltd)
10.2022 - 12.2023
Junior SQL Developer
Altruist Technologies Pvt Ltd
10.2018 - 09.2022
B.E - computer science of Engineering
S A ENGINEERING COLLEGE