Database Developer - Inperson Interview

Job Description

We are looking for an experienced Database Developer with strong expertise in SQL, database design, development, and performance optimization. The ideal candidate will be responsible for developing and maintaining database solutions, writing complex queries, optimizing stored procedures, and ensuring data accuracy and reliability.

Key Responsibilities

• Design, develop, and maintain database objects, including tables, views, stored procedures, functions, and triggers.
• Write and optimize complex SQL queries for performance and scalability.
• Perform database performance tuning, query optimization, and troubleshooting.
• Develop and maintain data integration and data processing solutions.
• Ensure data integrity, consistency, security, and availability.
• Collaborate with application developers, business analysts, and other technical teams.
• Support database testing, deployment, documentation, and production issue resolution.

Required Skills

• 8–10 years of experience in database development and SQL programming.
• Strong proficiency in complex SQL queries, joins, subqueries, CTEs, and window functions.
• Hands-on experience with stored procedures, functions, triggers, and database optimization.
• Experience with relational databases such as SQL Server, Oracle, or PostgreSQL.
• Strong understanding of database design, indexing, execution plans, and performance tuning.
• Knowledge of data modeling, ETL processes, and data integrity.
• Excellent analytical, troubleshooting, and problem-solving skills.