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.