(Summarize in one statement why the job exists; and how it contributes to the overall objective of the company)
We are looking for Database Administrator (DBA) specializing in MySQL and PostgreSQL who is responsible for the health, security, and performance of an organization’s open-source database systems. This role blends high-level architectural planning with day-to-day maintenance to ensure data remains accessible and protected.
2.PRINCIPAL ACCOUNTABILITIES
(Accountabilities associated with the job)
Administration & Maintenance: Installing, configuring, and upgrading database instances on Linux or cloud platforms like AWS RDS or Google Cloud SQL.
Performance Tuning: Monitoring database health and optimizing queries, indexing, and configurations using tools like EXPLAIN and slow query logs.
Data Security: Implementing user access controls, authentication, and encryption to protect sensitive data.
High Availability & Disaster Recovery: Designing and testing backup/restore procedures and managing replication or clustering to ensure maximum uptime.
Capacity Planning: Forecasting storage and resource needs to ensure the database can scale as data volumes grow.
3.MAJOR CHALLENGES
(Challenges faced on an on-going basis in carrying out the job)
- Performance Bottlenecks: Fixing poorly written queries and managing complex schema updates on live production systems without causing downtime is a daily hurdle.
- Massive Scaling: Handling rapid data growth requires constantly managing complex sharding, partitioning, and resource allocation.
- Balancing the distinct internal behaviors of both MySQL and PostgreSQL requiring deep, specialized knowledge for each system.
- Data Loss Risks: The role carries extreme accountability for protecting data security and ensuring multi-terabyte backups actually work.