Overview
Develop, optimize, maintain, and support Microsoft SQL Server database solutions in a production environment, using T-SQL, performance tuning, query optimization, and Python automation.
What you'll do
- Design, develop, maintain, and optimize database solutions using Microsoft SQL Server.
- Develop and support complex T-SQL queries, stored procedures, functions, views, triggers, and Dynamic SQL.
- Perform SQL Server performance tuning and query optimization to improve database and application performance.
- Analyze execution plans, indexing strategies, statistics, and database workloads to identify and resolve performance bottlenecks.
- Create, schedule, monitor, and maintain SQL Server Agent Jobs.
- Troubleshoot and resolve database-related issues across development, testing, and production environments.
- Develop automation and support scripts using Python.
- Perform root cause analysis and implement permanent solutions for recurring database issues.
- Collaborate with application teams and business stakeholders to understand requirements and deliver scalable database solutions.
- Support database deployments, maintenance activities, and production releases.
- Participate in weekend support activities when required.
What you'll need
- 4 to 6 Years of relevant experience in MS SQL Server, T-SQL Development, Performance Tuning & Query Optimization, Dynamic SQL, Python Automation, and Production Support.
- Bachelor’s Degree in Computer Science, Information Technology, Engineering, or a related field.
- Strong hands-on experience with Microsoft SQL Server.
- Expert-level proficiency in T-SQL Programming.
- Strong experience in SQL Server Performance Tuning and Query Optimization.
- Extensive experience working with complex queries, stored procedures, functions, triggers, and Dynamic SQL.
- Good knowledge of creating, scheduling, monitoring, and maintaining SQL Server Agent Jobs.
- Experience with Python scripting for automation, data processing, and support activities.
- Strong debugging, troubleshooting, and problem-solving skills.
- Good understanding of database design principles, indexing, and SQL Server best practices.
- Experience supporting production environments and critical business applications.
- Strong analytical and problem-solving abilities.
- Excellent verbal and written communication skills.
- Ability to work independently and collaboratively within a team.
- Strong ownership, accountability, and commitment to delivery.
- Willingness to work on weekends as required.
Nice to have
- Experience in SQL Server Database Administration (DBA) activities.
- Knowledge of database backup and recovery strategies.
- Experience with PowerShell scripting for automation and administrative tasks.
- Experience with database monitoring, health checks, and capacity planning.
- Understanding of database security, permissions, and user management.
- Exposure to Log Shipping.
- Experience with cloud database platforms such as Azure SQL or AWS RDS.
- Microsoft SQL Server Certifications are an added advantage.
Details
- Location: Kochi, India.
- Weekend support activities and work on weekends may be required.
Read the full description and apply on the company’s own careers page.