Database Administrator (DBA) - AWS/PostgreSQL

About Our Client

Work with a leading Employee Experience Company that helps companies connect and engage employees across enterprises.

The platform enables employees to communicate with coworkers, find information, and transfer knowledge. It further enhances employee expereince by insipiring a digital workspace while reinforcing a unique work culture.

Job Description

Responsibilities

Database Management:

• Administer, maintain, and implement policies and procedures for ensuring the security and integrity of databases and regular testing.
• Build and design database systems of high availability and quality depending on product needs.
• Minimize database downtime and manage parameters to provide fast query responses
• Provide proactive and reactive data management support and training to users

Performance Tuning:

• Monitor database performance, implement changes and apply new patches and versions when required, to ensure optimal performance.

Failover and Recovery:

• Design and execute database backup and recovery strategies, including failover planning and testing
• Perform tests and evaluations regularly to ensure data failover, restore, recovery are within RPO and RTO.
• Use high-speed transaction recovery techniques and backup data

Security and Compliance:

• Ensure database security measures are in place, including access controls and audit logging.
• Comply with all applicable data privacy laws and regulations.

Monitoring:

• Utilize AWS CloudWatch and other monitoring tools to ensure database health, performance, and to automate scaling and notifications.

Troubleshooting and Support:

• Provide high-level support for complex database issues, including troubleshooting.
• Resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, slow query logs, etc.
• Determine, enforce and document, database policies, procedures and standards
• Required a deep understanding PostgreSQL roles and permissions
• Manage the PostgreSQL autovacuum tasks on Amazon RDS for PostgreSQL
• Use pgBadger for log analysis with PostgreSQL
• Work with parameters on your RDS for PostgreSQL DB instance
• Must have excellent problem solving skills and the ability to think algorithmically

• 8+ years of relevant work experience

Communication Skills:

• Excellent verbal and written communication skills

• Proven experience as a DBA with expertise in ElasticSearch and AWS managed RDS (PostgreSQL and MySQL) with multi region setup
• Hands-on experience with database standards, user management, security restrictions and best practices.
• Familiarity with database design, documentation and coding, specially for multi tenant architecture.

Failover and Recovery:

• Solid experience in database backup, failover, recovery procedures, and disaster recovery planning, security, integrity and SQL.

Others:

• Good to have a basic understanding of Mongo, Redis and Snowflake.
• Open to learn new technologies and skills.

Desired Skills and Experience:

Monitoring Tools: Deep familiarity with database monitoring tools, especially AWS CloudWatch, for performance monitoring and alerting

What's on Offer

We believe that when work is good, life is better and that belief guides all we do. Including how we approach our flexible work model. We operate with a Hub-Hybrid-Remote model. This model is role-based with exceptions and provides employees with the flexibility that many have told us they want.

• Hybrid - Hybrid work from home and office. Role dictates the ability to work from home, plus benefit from in-person collaboration on a regular basis.
• Remote - 100% remote. Role can be done anywhere within your country of hire, as long as the requirements of the role are met.