Key Responsibilities:
Design, develop, and maintain relational databases to meet business requirements.
Write complex SQL queries, stored procedures, functions, and triggers to support application features and processes.
Optimize database performance, including tuning queries, indexing, and data modeling.
Ensure data consistency, integrity, and security in database systems.
Collaborate with application developers to integrate databases with applications and troubleshoot issues.
Perform database migrations and upgrades.
Monitor and troubleshoot database performance issues, including identifying bottlenecks and recommending solutions.
Ensure regular database backups and disaster recovery plans are in place.
Work with business analysts to understand and translate business requirements into effective database designs.
Maintain database documentation, including schema, queries, and stored procedures.
Adhere to best practices and maintain high standards of code quality and consistency.
Keyskills: Database development SQL queries disaster recovery relational databases stored procedures