SQL Database Administrator (PostgreSQL Focus)
Experience Level: 1 – 4 years
Employment Type: Full-time
Job Summary
We are looking for a database administrator with 1 to 4 years of experience to support, maintain, and optimize our production database environment. The primary focus of this role will be managing relational databases (such as MS SQL Server, MySQL, or Oracle) with PostgreSQL serving as a secondary engine. You will assist with query optimization, routine maintenance, backups, and user access management under senior DBA guidance.
Key Responsibilities
- Database Operations \& Maintenance:
- Perform day-to-day database administration across primary SQL engines and secondary PostgreSQL instances.
- Execute schema updates, data migrations, and routine maintenance (vacuuming, indexing, integrity checks).
- Manage user access, roles, permissions, and basic security compliance.
- Performance \& Monitoring:
- Monitor database availability, resource utilization (CPU, memory, storage), and query performance.
- Identify slow-running queries and assist in basic index creation and SQL query tuning.
- Maintain database connection management and basic pooling setups.
- Backups \& Recovery:
- Execute daily physical and logical backups using standard database utilities and tools (e.g., pg_dump, pg_basebackup).
- Participate in backup restoration drills and point-in-time recovery testing.
- Support \& Automation:
- Assist in setting up basic database replication (streaming/logical replication).
- Write basic Shell/Bash or Python scripts to automate daily operational tasks.
- Provide operational support for incident response, troubleshooting errors, and resolving database locks/blocking.
Required Skills \& Qualifications
- Experience: 1 to 4 years of hands-on experience in Database Administration in a production environment.
Pay: From ﷼10,000.00 per month
Work Location: In person