Database Developer

Database Developer

Key Responsibilities:

• Develop high-quality SQL queries, stored procedures, and functions based on business requirements.
• Analyze and review existing SQL queries, procedures, and functions; recommend and implement performance improvements.
• Design, implement, and maintain database objects including:

Tables, Views, Stored Procedures, FunctionsTriggers, CursorsTemporary Tables, Table VariablesCommon Table Expressions (CTEs)

• Apply appropriate indexing strategies and database keys to enhance performance and data integrity.
• Analyze execution plans, query statistics, plan cache, and leverage query hints where necessary.
• Perform query optimization, performance monitoring, and database tuning.
• Ensure proper handling of database transactions to maintain data consistency and reliability.
• Collaborate with application developers and stakeholders to understand requirements and provide efficient database solutions.

Key Requirements:

• Bachelors Degree or equivalent graduation qualification.4 to 8 years of hands-on experience in SQL Database Development.
• Strong expertise in SQL query writing, performance tuning, and optimization.Proven experience with indexing strategies and database key design.
• In-depth understanding of database execution plans and performance diagnostics.

Preferred Skills:

• Strong analytical and problem-solving skills.Ability to work independently and review peer code effectively.
• Excellent communication and documentation skills.