Database Administrator

Responsibilities

• Proactively monitoring database performance and troubleshooting issues.
• Working cross-functionally with our engineers and analytics professionals to optimize queries, fix performance bottlenecks, improve existing schemas and design new ones.
• Creating and maintaining change control and testing processes, reviewing and approving database modifications.
• Designing, installing, configuring, managing, monitoring, maintaining, tuning, backing up, securing, and troubleshooting Oracle and PostgreSQL databases based on Solaris/Linux.
• SQL query performance tuning.
• Conducting research and making recommendations on data-related products, services, protocols, and standards; planning for future growth of our data asset.
• Reviewing development and deployment processes related to databases and identifying areas of improvement (such as online schema changes).
• Creating and maintaining documentation, troubleshooting playbooks, testing failover, and recovery plans.
• Improving database expertise company-wide.
• Ensuring data security and integrity, including implementation of access controls, backups, and recovery plans.
• Executing disaster recovery plans and procedures to ensure database availability during system outages or dysfunction.