Summary of the position:
The SQL Developer will be based in our PMC India Office in Vadodara and will work closely with Database Administrators, Application Developers, and Solution Architects to design, develop, optimize, and maintain database solutions primarily on Microsoft SQL Server.
The role focuses on database development, performance optimization, and supporting database administration activities for enterprise and mission-critical systems. The candidate will be responsible for developing stored procedures, database objects, ETL processes, and supporting production environments by troubleshooting database-related issues. And will assist the DBA team with core database administration activities such as monitoring, backup verification, performance tuning, and deployment support.
Key Accountabilities:
Database Development
- Design, develop, and maintain SQL Server database objects including: Stored Procedures, Functions, Views, Triggers, Tables and indexes
- Write efficient and optimized T-SQL queries for application functionality.
- Support application teams in implementing database logic and schema changes.
- Develop and maintain data integration and ETL processes using SQL Server Integration Services (SSIS).
- Assist with report dataset optimization for SSRS reports.
- Perform code reviews for SQL scripts developed by other developers.
Performance Optimization
- Identify and resolve performance bottlenecks in SQL queries.
- Analyse execution plans and optimize indexes and queries.
- Monitor database performance metrics and recommend improvements.
- Assist in resolving blocking, deadlocks, and long-running queries.
Database Administration Support
- Provide support to the DBA team in the following areas:
- Database deployments and schema changes.
- Monitoring SQL Server health and performance.
- Assisting in backup and restore activities.
- Supporting High Availability environments such as: Always On Availability Groups, Replication, Log Shipping, Verifying database backup and recovery procedures, Supporting DR testing and database recovery processes.
Change Management & Release Support
- Support database releases during deployment windows.
- Execute database scripts during application releases.
- Maintain version control for database objects.
- Perform rollback procedures if deployment issues occur.
Production Support
- Troubleshoot database-related incidents.
- Support root cause analysis (RCA) for database performance issues.
- Assist in resolving production issues impacting applications.
- Work closely with development and infrastructure teams.
Documentation & Standards
- Maintain database documentation including: Database schema, Stored procedure documentation, Deployment scripts
- Follow database development standards and best practices
- Assist in defining database coding standards and guidelines
Skills and Experience | Essential:
- Strong experience with Microsoft SQL Server (2012 and above).
- Advanced knowledge of T-SQL programming
- Experience writing and optimizing: Stored procedures, Complex joins, Window functions, CTEs
- Experience with SQL Server Management Studio (SSMS)
- Good understanding of: Indexing strategies, Query optimization, Execution plans
- Experience working with SSIS or ETL processes
- Understanding of database backup and recovery concepts
- Familiarity with database security and permissions
- Experience supporting production databases
- Basic knowledge of database monitoring and troubleshooting
Skills and Experience | Desirable:
- Experience with SSRS reporting
- Exposure to database administration tasks
- Experience with Azure SQL / Cloud database services
- Familiarity with: Git or source control for database code, CI/CD pipelines for database deployments, Experience working in 24x7 production environments, Knowledge of other databases such as: PostgreSQL, MySQL
- Experience with database monitoring tools
Qualifications:
- Bachelor's Degree in Computer Science , IT, or related field (or equivalent experience).
- Microsoft SQL related certification is desirable:
- Microsoft SQL Server Certification
- Azure Database certification.
