01Overview
Role description
Job Title: Database Administrator (DBA) & SQL Developer
Hiring Location
Chennai
Experience Range
8+ Years
Job Summary
We are seeking an experienced Database Administrator (DBA) & SQL Developer with solid expertise in database administration, SQL development, data modeling, performance optimization, and large-scale data migration initiatives. The ideal candidate will be responsible for managing enterprise database environments, ensuring high availability and performance, supporting application development teams, and driving data migration and transformation activities across legacy and modern platforms.
This role requires a deep understanding of database architecture, relational data models, data integrity, database security, performance tuning, and migration methodologies. The candidate will collaborate closely with application architects, business analysts, infrastructure teams, and project stakeholders to design, implement, and support scalable database solutions across on-premises and cloud environments.
Must-Have Skills
Database Administration & Operations
- 8+ years of hands-on experience in Database Administration and SQL Development.
- Strong experience installing, configuring, upgrading, patching, and maintaining enterprise database platforms.
- Experience managing databases across Development, Testing, UAT, Production, Disaster Recovery, and Cloud environments.
- Expertise in:
- Database Monitoring and Health Checks
- Capacity Planning
- Performance Tuning
- Incident and Problem Management
- Hands-on experience with:
- Backup and Recovery
- Replication
- Clustering
- High Availability (HA)
- Disaster Recovery (DR)
- Ability to troubleshoot:
- Deadlocks
- Blocking Issues
- Long-running Queries
- Resource Bottlenecks
- Production Database Incidents
- Strong understanding of database operational processes including release support, deployment activities, CAB approvals, and production releases.
- Willingness to participate in on-call production support.
Database Platforms
Strong hands-on experience with one or more of the following:
- Microsoft SQL Server (2016/2019/2022)
- MySQL
- Experience with the following databases is an added advantage:
- PostgreSQL
- Oracle Database
- IBM DB2
- MongoDB
SQL Development & Database Engineering
- Advanced expertise in T-SQL and/or PL-SQL development.
- Hands-on experience developing and maintaining:
- Stored Procedures
- Functions
- Views
- Triggers
- Database Objects
- Strong expertise in:
- Query Optimization
- Execution Plan Analysis
- Database Performance Tuning
- Index Optimization
- Experience designing and maintaining:
- Schemas
- Constraints
- Foreign Keys
- Indexes
- Partitioning Strategies
- Ability to develop data validation, auditing, and reconciliation processes.
- Experience supporting application teams to optimize database interactions.
Data Modeling & Database Design
- Strong understanding of:
- Relational Database Concepts
- Normalization and Denormalization
- Database Design Principles
- Logical and Physical Data Modeling
- Ability to translate business requirements into scalable database designs.
- Experience maintaining:
- Enterprise Data Models
- Metadata Repositories
- Data Dictionaries
- Database Documentation
- Understanding of application data flows, dependencies, and cross-system relationships.
Data Migration & Transformation
- Proven experience leading and supporting large-scale data migration initiatives.
- Hands-on expertise in:
- Source-to-Target Mapping
- Data Profiling
- Data Quality Assessment
- Data Transformation
- Data Conversion
- Migration Planning
- Cutover Management
- Experience developing:
- Migration Scripts
- ETL Processes
- Validation Frameworks
- Strong experience in:
- Data Reconciliation
- Data Cleansing
- Deduplication
- Post-Migration Validation
- Experience supporting:
- Legacy System Modernization
- Application Migration Programs
- Cloud Migration Projects
- Platform Consolidations
Cloud & Modern Data Platforms
- Experience supporting database deployments in AWS Cloud environments.
- Understanding of cloud-native database concepts and managed database services.
- Ability to implement best practices related to:
- Scalability
- Resiliency
- Automation
- Operational Excellence
Security & Compliance
- Strong experience implementing database security standards, including:
- User Provisioning
- Role-Based Access Control (RBAC)
- Encryption
- Auditing
- Compliance Requirements
- Understanding of security best practices for mission-critical production environments.
Application Integration
- Experience supporting database integration with enterprise applications.
- Hands-on experience with:
- Entity Framework 6.4
- ADO.NET
- .NET Application Integration
- Ability to collaborate with development teams and recommend database best practices.
Tools & Technologies
Hands-on experience with:
- SQL Server Management Studio (SSMS)
- Azure Data .
