Job Description
- NoSQL experience
- PowerShell scripting
- DevOps & CI/CD
- Azure Data Factory
- Data governance & privacy
- 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
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
