Database Lead

We are looking for Software Dev Lead/Database-SQL for one of our internal projects.

Role: Software Dev Lead/Database-SQL

Location: Hyderabad

Work Mode: Office

Shift timings: Overlapping US hours

Years of experience: 10+ Years of experience

Technologies: SQL, T-SQL, Stored Procedures, Triggers

Skills:

Proficient in SQL and relational database management systems (RDBMS).

Strong experience in writing and maintaining stored procedures, triggers, and complex SQL queries.

Expertise in unit testing database code using T-SQL, with a focus on high test coverage for stored procedures and triggers.

Familiarity with database design, normalization, indexing, and query optimization.

Experience in debugging and optimizing SQL code to ensure high performance.

Knowledge of version control systems and integrating database tests into continuous integration pipelines.

Experience with Scrum & Agile methodologies.

Experience leading teams of at least five engineers.

Experience with coaching and mentoring less-experienced engineers.

Role & Responsibilities:

Design, implement, and maintain SQL databases with a focus on stored procedures, triggers, and complex business logic.

Write and maintain unit tests for database code using T-SQL, ensuring high coverage for stored procedures and triggers.

Collaborate with application developers to ensure efficient interaction between the application and the database layer.

Assess existing database code to identify high-risk areas and implement unit tests to mitigate risks and improve stability.

Optimize database performance by tuning stored procedures, triggers, and SQL queries.

Troubleshoot and resolve database-related issues, ensuring data integrity and high availability.

Implement and maintain CI/CD pipelines for database changes, integrating T-SQL tests into the workflow to support continuous testing and deployment.