Community

Home >

Jobs >

SQL Lead Developer

Tamil Nadu, India (On-site)

SQL Lead Developer

2 Months ago • 10 Years + • Administrative • Undisclosed

About the job

9 skills required for this role

Add these skills to join the top 1% applicants for this job

confluence

jira

ci-cd

azure

nosql

aws

sql

powershell

scalability

Job Description

The SQL Server Database Lead Developer will oversee the architecture, development, and management of SQL Server databases. Collaborating with various teams, you'll ensure databases meet technical and business needs. Responsibilities include database design and development, performance tuning, data modeling, team leadership, stored procedure creation, security implementation, backup/recovery planning, monitoring and maintenance, troubleshooting, and technology evaluation. This role demands hands-on technical skills, leadership abilities, and strategic planning to maintain database performance and availability.

Must have:

10+ years SQL Server experience
T-SQL expertise (queries, stored procedures)
Performance tuning & optimization
Data modeling & schema design
SSIS, SSRS, SSAS knowledge
Backup/recovery & security
ETL processes & data warehousing
Leadership & collaboration skills

Good to have:

NoSQL experience
PowerShell scripting
DevOps & CI/CD
Azure Data Factory
Data governance & privacy

Project description

The SQL Server Database Lead Developer will be responsible for overseeing the architecture, development, and management of our SQL Server databases. You will collaborate with development teams, architects, and business stakeholders to ensure the database meets both technical and business requirements. The role requires a mix of hands-on technical development, leadership, and strategic planning to ensure the continued performance and availability of the databases.

Responsibilities

Database Design & Development: Lead the design, development, and implementation of SQL Server databases to support business applications and ensure efficient data storage and retrieval.

Optimization & Performance Tuning: Perform database performance analysis and tuning, optimizing queries, indexes, and schema to ensure high performance and scalability.

Data Modeling: Develop and maintain logical and physical data models, ensuring data consistency, accuracy, and security.

Leadership & Collaboration: Lead a team of database developers, providing guidance, mentorship, and technical expertise while collaborating with software engineers, business analysts, and other stakeholders.

Stored Procedures & Queries: Design and optimize complex stored procedures, triggers, functions, and views.

Database Security: Implement and maintain database security best practices, including data encryption, user access controls, and audit trails.

Backup & Recovery: Develop and manage robust backup, recovery, and disaster recovery plans to ensure data integrity and availability in case of system failures.

Monitoring & Maintenance: Implement and monitor automated jobs, alerts, and maintenance plans to ensure continuous database availability and performance.

Documentation: Maintain detailed documentation of database design, configurations, processes, and procedures.

Troubleshooting & Support: Provide ongoing support for production databases, diagnosing and resolving database-related issues promptly.

Technology Evaluation: Stay up-to-date with emerging database technologies and SQL Server advancements, making recommendations for enhancements and improvements.

Skills

Must have

Bachelor's degree in Computer Science, Information Systems, or related field (or equivalent experience).

10+ years of experience in SQL Server Database Development and administration.

Strong experience with SQL Server 2016/2019 and above.

Expertise in T-SQL, including writing complex queries, stored procedures, functions, triggers, and views.

Proficiency in performance tuning and optimization techniques (indexes, query execution plans, and caching).

Experience with data modeling, normalization, and database schema design.

Knowledge of SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), and SSAS (SQL Server Analysis Services).

Proficient in implementing and maintaining backup/recovery strategies and disaster recovery plans.

Strong understanding of database security best practices, including encryption, authentication, and access controls.

Familiarity with ETL processes, data warehousing, and BI reporting systems.

Experience with cloud-based databases (Azure SQL Database, AWS RDS for SQL Server) is a plus.

Experience with Agile methodologies and collaboration tools (JIRA, Confluence, etc.).

Excellent problem-solving, debugging, and analytical skills.

Strong communication and leadership skills, with the ability to manage multiple projects simultaneously.

Nice to have

Experience with NoSQL databases and hybrid environments (SQL + NoSQL).

Knowledge of PowerShell scripting for automation.

Familiarity with DevOps practices and database CI/CD pipeline automation.

Experience with Azure Data Factory or similar cloud-based data integration tools.

Understanding of data governance, data privacy regulations (GDPR, CCPA), and best practices for managing sensitive data.

Other

Languages

English: B2 Upper Intermediate

Seniority

Lead

View Full Job Description

Upload your resume, increase your shortlisting chances by 80%

About The Company

Luxoft

894 Active Jobs

Luxoft, a DXC Technology Company (NYSE: DXC), is a digital strategy and software engineering firm providing bespoke technology solutions that drive business change for customers the world over. Acquired by U.S. company DXC Technology in 2019, Luxoft is a global operation in 44 cities and 21 countries with an international, agile workforce of nearly 18,000 people. It combines a unique blend of engineering excellence and deep industry expertise, helping over 425 global clients innovate in the areas of automotive, financial services, travel and hospitality, healthcare, life sciences, media and telecommunications.

DXC Technology is a leading Fortune 500 IT services company which helps global companies run their mission critical systems. Together, DXC and Luxoft offer a differentiated customer-value proposition for digital transformation by combining Luxoft’s front-end digital capabilities with DXC’s expertise in IT modernization and integration. Follow our profile for regular updates and insights into technology and business needs.