We are looking for a SQL Database Developer with strong expertise in Microsoft SQL Server, SQL/PL-SQL, database performance tuning, and backend database development . The ideal candidate should be passionate about building scalable database solutions, optimizing complex SQL queries, and ensuring high database performance and security.
Key Responsibilities
- Design, develop, and maintain SQL Server database objects including Tables, Views, Stored Procedures, Functions, Triggers, and Indexes .
- Develop efficient SQL and PL/SQL code to support business applications.
- Optimize complex SQL queries, stored procedures, and indexing strategies for maximum performance.
- Monitor database health and troubleshoot performance issues using SQL Profiler, Redgate, SentryOne, SSMS , and related monitoring tools.
- Perform database migrations and support deployment activities.
- Ensure data integrity through constraints, schema design, and best database practices.
- Identify and resolve blocking, deadlocks, long-running queries, and other database bottlenecks.
- Implement secure coding practices to prevent SQL Injection and other database vulnerabilities.
- Develop complex reports and support reporting requirements.
- Participate in application design discussions and provide database architecture recommendations.
- Perform routine database maintenance, backup, recovery, and operational support.
- Maintain database documentation, standards, and best practices.
- Mentor junior developers and conduct database code reviews.
- Evaluate new database technologies and recommend improvements.
Required Skills
- Strong experience with Microsoft SQL Server (2016/2019/2022) .
- Expertise in T-SQL, SQL, and PL/SQL programming.
- Hands-on experience developing Stored Procedures, Functions, Views, Triggers, Packages, and Indexes .
- Strong knowledge of Database Performance Tuning , Query Optimization, Execution Plans, and Index Management.
- Experience with SSMS, SQL Profiler, Redgate SQL Monitor, SentryOne, Toad, and SSIS .
- Good understanding of database migration, backup & recovery, security, permissions, and database administration fundamentals.
- Experience troubleshooting production database issues.
- Knowledge of relational database concepts and data integrity.
- Excellent analytical, problem-solving, and communication skills.
Good to Have
- Experience with other RDBMS platforms (Oracle, PostgreSQL, MySQL, etc.).
- Exposure to Azure SQL or AWS RDS.
- Database Administration (DBA) experience.
- Microsoft SQL Server or Database-related certifications.
What We're Looking For
- Strong ownership and problem-solving mindset.
- Ability to work in a fast-paced Agile environment.
- Excellent stakeholder communication skills.
- Passion for writing clean, optimized, and secure SQL code.
- Ability to mentor team members and promote database development best practices.
Must-Have Skills
MS SQL Server, T-SQL, Stored Procedures, Performance Tuning, Query Optimization, Indexing, SSMS, SQL Profiler, Redgate, SentryOne, Database Migration, SQL Security, SSIS, Database Monitoring, Backup & Recovery.