Database Administrator(AWS/Postgres)

DBAJob Description

Simpplr is seeking a highly skilled and experienced  Database Administrator (DBA) to join our team. The ideal candidate will have a strong background in managing and optimizing ElasticSearch and Postgres databases, as well as extensive experience with AWS managed databases including RDS, Aurora and MySQL. This role requires a deep understanding of database failover and recovery, backups, and proficiency in optimizing query, index and overall database performance . The successful candidate will be passionate about ensuring database performance, availability, security, and best practices to keep the database up and running smoothly 24/7. 

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

Requirements and skills

Communication Skills:  

• Excellent verbal and written communication skills

Database Expertise: AWS Managed Databases and ElasticSearch

• 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:

Certifications: AWS or relevant database certifications (e.g., Oracle Certified Professional, PostgreSQL Professional).
Scripting Skills:  Experience with scripting languages (e.g., Python, Bash) for automation of database tasks.
Monitoring Tools:  Deep familiarity with database monitoring tools, especially AWS CloudWatch, for performance monitoring and alerting