Key Roles & Responsibilities:

In this role, you will create and implement cutting-edge database solutions tailored to our organizational needs using AWS technologies like Amazon RDS, DynamoDB, and Aurora. Given that our database infrastructure is currently on-premises, you will also play a crucial role in migrating our databases from on-premises environments to AWS cloud solutions. You'll collaborate closely with our software developers and system architects to ensure your designs perfectly align with application requirements, directly impacting our technology stack.

Your responsibilities will include monitoring and maintaining our database systems to ensure peak performance, performing routine tasks such as backups and data integrity checks, and implementing performance tuning strategies. You will also establish and enforce robust database security policies, utilizing AWS security features to safeguard sensitive data and protect against unauthorized access.

Diagnosing and resolving database-related issues, from performance bottlenecks to system failures, will be a key part of your role. You'll employ proactive monitoring and alerting strategies to mitigate risks and ensure continuous data availability. Additionally, you'll create comprehensive documentation of database configurations, procedures, and troubleshooting guidelines, and share your expertise by mentoring junior DBAs and other team members.

Skills and Competencies:

- Strong knowledge of relational database management systems (RDBMS) such as PostgreSQL or AWS RDS etc

- Familiarity with database administration tools and utilities for monitoring, performance tuning, and automation (e.g., pgAdmin).

- Understanding of backup and recovery strategies, high availability (HA), and disaster recovery (DR) solutions (e.g., clustering, replication, log shipping).

- Proficient in SQL programming and scripting languages or automation and data manipulation tasks.