Senior SQL Server Developer & Database Administrator

Kefa Technology Solutions; Chengalpattu; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Kefa Technology Solutions seeks a Senior SQL Server Developer & Database Administrator to manage enterprise DB environments, optimize performance, and ensure security and reliability across production systems. The role covers database development, performance tuning, cloud integrations, and CI/CD automation, collaborating with development and infrastructure teams to deliver scalable data solutions.

You will mentor junior DBAs, implement DR strategies, and lead initiatives for data integrity and

Qualifications

• 3+ years of hands-on experience in Microsoft SQL Server Development and Administration.
• Extensive experience with T-SQL, stored procedures, functions, triggers, views, and advanced query development.
• Experience with SQL Server High Availability technologies (Always On, Replication, Log Shipping, Clustering).
• Strong knowledge of backup, recovery, security, and disaster recovery best practices.
• Experience with cloud deployments (Azure/AWS) and DevOps automation for databases.

Responsibilities

• Administer, maintain, and support multiple mission-critical SQL Server production environments with high availability.
• Monitor health, performance, storage, backups, replication, and system availability across applications.
• Design and maintain backup, recovery, and disaster recovery strategies.
• Design, develop, and optimize complex SQL scripts, procedures, and data models.
• Develop ETL processes and data migrations; support developers with DB design and tuning.
• Create robust CI/CD pipelines for database deployments and automation.

Skills

SQL Server Development

T-SQL & Procs

High Availability

DevOps / CI/CD

Cloud DB

Performance Tuning

SSIS/SSRS/OLAP

Tools

Azure SQL Database

Azure Managed Instance

AWS RDS

SSIS

SSRS

OLAP Cubes

Power BI

Job description

Senior SQL Server Developer & Database Administrator

Position Overview

We are seeking an experienced and highly motivated Senior SQL Server Developer & Database Administrator to manage, optimize, and support multiple business-critical production database environments. The ideal candidate will possess deep expertise in SQL Server administration, database development, performance tuning, and production support, while partnering closely with business stakeholders and development teams to deliver scalable, secure, and high-performing database solutions.

This role requires ownership of enterprise database platforms, proactive monitoring of production environments, rapid troubleshooting capabilities, and the ability to design and develop robust SQL solutions for complex business requirements across multiple projects.

Key Responsibilities

Database Administration & Production Support

• Administer, maintain, and support multiple mission-critical SQL Server production environments with high availability and minimal downtime.
• Monitor database health, performance, storage growth, backup status, replication, and system availability across all business applications.
• Perform capacity planning, database maintenance, patch management, upgrades, and disaster recovery testing.
• Design, implement, and maintain backup, recovery, failover, and business continuity strategies.
• Ensure database security, compliance, auditing, and adherence to organizational standards and best practices.
• Investigate and resolve production incidents, performance bottlenecks, blocking issues, deadlocks, and database-related outages.

Database Development

• Design, develop, review, and optimize complex SQL scripts, stored procedures, functions, triggers, views, and database objects for enterprise applications.
• Translate business requirements into efficient database solutions and scalable data models.
• Develop high-performance ETL processes, data migration scripts, and integration solutions.
• Support development teams by providing database design guidance, code reviews, and query optimization recommendations.
• Create reusable database frameworks and standards to improve development efficiency across projects.

Performance Optimization

• Perform advanced query tuning and execution plan analysis.
• Design and maintain indexing strategies to maximize application performance.
• Analyze workload patterns and implement database optimization initiatives.
• Continuously identify opportunities to improve database throughput, response times, and resource utilization.
• Conduct root-cause analysis for performance-related issues and implement long-term corrective actions.

Cloud & DevOps

• Manage SQL Server deployments across on-premises and cloud environments (Azure SQL, Azure Managed Instance, AWS RDS, etc.).
• Implement database CI/CD pipelines and automation using DevOps tools.
• Automate database deployments, schema changes, monitoring, and maintenance tasks.
• Collaborate with infrastructure and cloud teams to optimize database architecture and operational efficiency.

Reporting & Data Analytics

• Support Business Intelligence and reporting initiatives using SSRS, Power BI, SSIS, and OLAP technologies.
• Design and optimize reporting databases, data marts, and analytical data structures.
• Work closely with business teams to provide reliable and accurate data solutions for operational and strategic reporting.

Integration & Business Support

• Develop and maintain integrations with ERP, CRM, PIM, eCommerce, and third-party business platforms.
• Provide database expertise during project planning, solution design, and implementation phases.
• Act as the primary database SME (Subject Matter Expert) for business-critical initiatives.
• Mentor junior developers and establish database development standards and best practices.

Required Skills & Qualifications

Technical Skills

• 3+ years of hands-on experience in Microsoft SQL Server Development and Administration.
• Strong expertise in T-SQL, stored procedures, functions, triggers, views, and advanced query development.
• Extensive experience supporting high-volume production database environments.
• Advanced knowledge of SQL Server Performance Tuning and Optimization.
• Experience with SQL Server High Availability technologies including Always On Availability Groups, Replication, Log Shipping, and Clustering.
• Strong understanding of database architecture, normalization, indexing, partitioning, and security.
• Experience with SSIS, SSRS, and OLAP Cubes.
• Experience with Azure SQL Database, Azure Managed Instance, AWS RDS, or other cloud database platforms.
• Experience implementing database CI/CD pipelines and DevOps automation.
• Strong knowledge of backup, recovery, disaster recovery, and database security best practices.
• Experience integrating databases with ERP, CRM, eCommerce, PIM, and third-party enterprise systems.

Preferred Skills

• Experience with Power BI and enterprise reporting platforms.
• Knowledge of data warehousing and ETL architecture.
• Exposure MS SQL Server [MUST] or other database technologies.
• Familiarity with Infrastructure as Code (IaC) and cloud automation tools.
• Experience working in Agile/Scrum environments.

Soft Skills

• Excellent analytical and troubleshooting abilities.
• Strong stakeholder management and communication skills.
• Ability to manage multiple priorities and business-critical projects simultaneously.
• Self-driven, proactive, and capable of working independently with minimal supervision.
• Strong documentation and process management skills.