Responsibilities:
- Proactively monitoring database performance and troubleshooting issues.
- Collaborating with engineers and analytics professionals to optimize queries, resolve performance bottlenecks, enhance existing schemas, and design new ones.
- Creating and maintaining change control and testing processes, reviewing and approving database modifications.
- Conducting research and providing recommendations on data-related products, services, protocols, and standards while planning for the future growth of our data assets.
- Reviewing database development and deployment processes to identify and implement improvements, such as enabling online schema changes.
- Creating and maintaining documentation, troubleshooting playbooks, testing failover, and recovery plans.
- Improving database expertise company-wide.
- Ensure data security and integrity, including implementation of access controls,
backups, and recovery plans.
Implement disaster recovery plans and procedures to ensure database availability and functionality during system outages or disruptions.