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.
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.
Seniority level
Entry level
Employment type
Full-time
Job function
Information Technology
Industries
Information Technology & Services
Referrals increase your chances of interviewing at PMC by 2x
