Job Title: Database Administrator (DBA) & SQL Developer
Chennai
8+ Years
Job Summary
We are seeking an experienced Database Administrator (DBA) & SQL Developer with strong 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
- 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.
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
- 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.
- 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.
- 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
- 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
- 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.
- 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.
Hands-on experience with:
- SQL Server Management Studio (SSMS)
- Azure Data Studio
- Git / Bitbucket
- Jira / ServiceNow
- CI/CD Pipelines
- PowerShell or Shell Scripting
- Database Monitoring and Performance Analysis Tools
- Extensive experience supporting mission-critical production database environments.
- Strong troubleshooting and analytical skills.
- Experience working within ITIL-based operational environments.
- Excellent communication and stakeholder management skills.
Good-to-Have Skills
- Experience with AWS Database Services.
- Exposure to PostgreSQL, Oracle, IBM DB2, or MongoDB administration.
- Familiarity with enterprise application technologies such as:
- ASP.NET
- Angular
- React
- JavaScript
- Experience with:
- DevOps practices
- Infrastructure as Code (IaC)
- Database Automation
- Exposure to cloud modernization and transformation initiatives.
- Experience working on large-scale enterprise transformation programs.
- Relevant certifications such as:
- Microsoft SQL Server Certifications
- Oracle Certifications
- PostgreSQL Certifications
- AWS Certifications
- Azure Certifications
Key Responsibilities
- Administer and maintain enterprise database environments across multiple platforms.
- Monitor database health, performance, availability, and capacity.
- Configure backup, recovery, replication, HA, and DR solutions.
- Design, develop, and optimize SQL objects and database code.
- Analyze execution plans and improve database performance.
- Develop and maintain enterprise data models and database documentation.
- Lead data migration, transformation, and modernization initiatives.
- Perform data validation, reconciliation, and quality assurance activities.
- Support cloud database deployments and modernization programs.
- Collaborate with application teams to optimize database integrations.
- Participate in production releases, incident management, and on-call support.
- Ensure database security, compliance, and operational excellence.
Database Administration, SQL Server, SQL Development, T-SQL, Database Design, Data Migration, Data Modeling, Database Performance Tuning, Relational Databases, Database Security
AWS Cloud Databases, PostgreSQL, Oracle, MySQL, MongoDB, ETL, Entity Framework 6.4, ADO.NET, PowerShell, CI/CD, DevOps, ITIL, Database Modernization
