Database Administrator

Key Responsibilities

● Database Administration & Operations

○ Administer and support Snowflake and PostgreSQL databases (core requirement).

○ Manage users, security policies, roles, and connectivity.

○ Perform proactive monitoring, capacity planning, and health checks.

● Backup, Recovery & Disaster Preparedness

○ Design and implement backup/restore strategies.

○ Define and meet RTO (Recovery Time Objective) and RPO (Recovery Point Objective).

○ Conduct periodic disaster recovery testing.

● Performance Tuning & Optimization

○ Optimize queries, indexes, and schema design.

○ Troubleshoot bottlenecks and improve workload performance.

○ Implement cost and storage optimization strategies.

● Best Practices & Data Management

○ Enforce database security, auditing, and compliance standards.

○ Apply data compression and storage optimization techniques.

○ Automate recurring DBA tasks for efficiency and consistency.

Required Skills & Qualifications

● Mandatory:

○ Proven expertise in Snowflake and PostgreSQL administration.

○ Strong knowledge of backup/recovery, RTO/RPO, and disaster recovery.

○ Hands-on experience with performance tuning, indexing, and query optimization.

○ Solid understanding of data compression and storage optimization.

● Added Advantage:

○ Experience with Amazon Aurora (PostgreSQL/MySQL).

○ Experience with Azure Database (SQL, PostgreSQL, or MySQL).

● Good to Have:

○ Familiarity with Infrastructure as Code (Terraform/CloudFormation/ARM) for DB provisioning.

○ Python or Shell scripting for automation, backups, and monitoring.