SQL Developer / Database Developer

Job Title: SQL Developer / Database Developer

Experience: 1 to 5 Years

Employment: Full Time, Permanent

Work Mode: In Office

Education: Bachelor's Degree

Industry: IT Services & Consulting / Software

Department: Engineering Software & QA

Role: Database Developer

Key Skills: SQL, T-SQL, SQL Server, Stored Procedures, Query Optimization, Database Development

Required Skills

• Strong hands-on experience in SQL.
• Good knowledge of Microsoft SQL Server / T-SQL.
• Experience with Stored Procedures, Functions, Views, Triggers, CTEs, Joins, Subqueries, and Temporary Tables.
• Strong understanding of database design and normalization.
• Experience in query optimization and performance tuning.
• Knowledge of indexes and execution plans.
• Experience in data migration and data validation.
• Good troubleshooting and problem-solving skills.
• Experience working with application development and support teams.
• Good understanding of database backup and recovery concepts.
• Strong analytical and communication skills.

Preferred Skills

• MS SQL Server
• T-SQL
• SQL Query Optimization
• Stored Procedures
• Database Performance Tuning
• Database Design
• Data Migration
• SSIS / ETL
• SSRS / Reporting
• ERP / Business Applications
• Production Support
• Database Backup & Recovery
• Microsoft Dynamics 365 / ERP integration experience added advantage

Key Responsibilities

• Develop and maintain SQL queries, stored procedures, functions, views, and database scripts.
• Design and maintain database tables, relationships, indexes, and other database objects.
• Develop efficient and optimized SQL queries for application and reporting requirements.
• Analyze and improve query and database performance.
• Perform data extraction, transformation, validation, and migration activities.
• Troubleshoot and resolve database-related application and production issues.
• Identify and correct data inconsistencies and integrity issues.
• Support application development teams with database-related requirements.
• Perform database changes, testing, validation, and deployment activities.
• Support database backup, recovery, and maintenance activities.
• Monitor database performance and ensure data accuracy and integrity.
• Work closely with developers, QA teams, business users, and project teams.
• Prepare technical documentation for database objects, changes, and processes.
• Provide production support and resolve SQL/database-related incidents within agreed timelines.
• Follow database security, coding, development, and deployment standards.