Design, implement, and maintain complex SQL databases, including schema design and optimization. Develop and optimize SQL queries, stored procedures, triggers, and functions to meet application requirements. Ensure database design aligns with business needs and application performance requirements. Performance Optimization:
Analyze and optimize database performance, including query optimization, indexing, and resource management. Identify and resolve performance bottlenecks and ensure high availability and reliability of database systems. Conduct regular performance tuning and capacity planning. Data Management:
Develop and manage data integration processes, including ETL (Extract, Transform, Load) procedures and data migration. Ensure data integrity, consistency, and accuracy across databases. Implement data backup, recovery, and disaster recovery strategies. Technical Leadership:
Provide technical guidance and support to junior developers and database administrators. Review and approve database designs and code developed by team members. Lead database-related projects and initiatives, ensuring timely delivery and adherence to best practices. Collaboration:
Work closely with application developers, business analysts, and other stakeholders to understand data requirements and provide solutions. Participate in project planning, design discussions, and code reviews. Communicate effectively with stakeholders to address database-related issues and provide updates. Documentation:
Maintain comprehensive documentation of database designs, processes, and procedures. Document and track changes to database schemas, queries, and configurations.