SQL Lead Developer
Job Summary
Job Description
- 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
- NoSQL experience
- PowerShell scripting
- DevOps & CI/CD
- Azure Data Factory
- Data governance & privacy
9 skills required
Job Details
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
Similar Jobs
Ness Digital
The Walt Disney Company
The Walt Disney Company
Keywords Studios (Player Support)
Get notifed when new similar jobs are uploaded
Similar Skill Jobs
Xsolla
The Walt Disney Company
The Walt Disney Company
Get notifed when new similar jobs are uploaded
Jobs in Chennai, Tamil Nadu, India
PwC
PwC
Get notifed when new similar jobs are uploaded
Administrative Jobs
Extreme Network
Intel Corporation
PwC
Universal Music
CloudLinux
Get notifed when new similar jobs are uploaded
About The Company
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.
Get notified when new jobs are added by Luxoft
