Postgres DBA

Role: Postgres DBA
Location: Remote
Duration: Long term

Description:
We are seeking a highly skilled and experienced Senior Database Administrator with a strong background in PostgreSQL and SQL Database. The ideal candidate should have hands-on experience with PostgreSQL and SQL Database, demonstrating a deep understanding of database architecture, performance tuning, backup and recovery, and security management.

Key Responsibilities:
Database Management:
Install, configure, and maintain Aurora PostgreSQL databases.
Implement and manage database backup and recovery strategies.
Oracle installation, upgrade, ASM administration
Performance Tuning:
Monitor database performance and identify performance bottlenecks.
Optimize database queries and indexes for maximum efficiency.
Conduct regular performance reviews and provide recommendations for improvements.
Security and Compliance:
Implement and maintain database security policies and procedures.
Ensure compliance with data protection regulations and company policies.
Conduct regular security audits and vulnerability assessments.
Database Development:
Collaborate with development teams to design and implement database schemas, stored procedures, and functions.
Provide guidance on best practices for database development and optimization.
Participate in code reviews and provide feedback to developers.
Troubleshooting and Support:
Provide expert-level support for database-related issues.
Troubleshoot and resolve complex database problems in a timely manner.
Maintain detailed documentation of issues and resolutions.

Requirements:
10+ years of experience in Database Administration.
Proven experience as a Database Administrator.
In-depth knowledge of database management systems, primarily AWS PostgreSQL, SQL Database and MySQL
Familiarity with database design principles, data normalization, and indexing techniques.
Understanding of data security and access control principles.
Extensive experience in AWS RDS.
Knowledge of cloud-based database services (e.g., AWS RDS, SCT, and DMS).
Strong knowledge of PostgreSQL replication, high availability, and disaster recovery mechanisms in AWS Cloud environment.
Experience with PostgreSQL monitoring and performance tuning tools.
Proficiency in SQL and experience with writing complex queries and stored procedures.
Automate database tasks using AWS services like AWS Lambda, AWS CloudFormation, and AWS RDS/Aurora.
Strong analytical and problem-solving skills with an ability to troubleshoot database-related issues.
Familiarity with Linux/Unix operating systems and shell scripting.