Database Developer

Roles and Responsibilities

• Design, develop, test, and maintain database objects including tables, views, stored procedures, functions, and triggers.
• Develop and optimize T-SQL queries to support enterprise applications and business requirements.
• Design efficient database structures following database normalization and data modelling practices.
• Perform database performance tuning through query optimization, indexing, and execution plan analysis.
• Develop and maintain SSIS packages, ETL processes, and data migration solutions.
• Develop reusable, secure, and maintainable database components following coding standards and best practices.
• Support application integration by developing database interfaces and data exchange processes.
• Participate in database deployment, version control, and change management activities.
• Troubleshoot database performance and production issues and provide timely resolutions.
• Collaborate with application developers, QA teams, business analysts, and other stakeholders to deliver database solutions.
• Participate in code reviews and Agile development activities.
• Contribute to database design discussions and recommend performance improvements.
  

Desired Candidate Profile

• 4-7 years of experience in Database Development with expertise in T-SQL programming language.
  
• Strong understanding of MySQL or similar relational databases; knowledge of other DBMS systems an asset.
  
• Bachelor's degree in Any Specialization (B.Tech / B.E.).
  
• Proficiency in creating complex queries using various SQL commands such as joins, aggregations, subqueries etc.