MigOps is looking for a PostgreSQL database administrator with the following responsibilities.
- Manage PostgreSQL databases and collaborate with our customers on their in-house projects.
- Perform Architectural health checks and suggest optimizations and design changes through a detailed summary.
- Optimize the performance of postgres databases using your knowledge in PostgreSQL Internals.
- Tune SQL’s and write complex scripts for day-to-day administrative tasks.
- Flexible in managing PostgreSQL databases on Cloud such as – AWS RDS & Aurora, GCP, Azure, etc.
- Publish blog posts and write knowledge base articles used by our customers.
- Upgrade and Migrate PostgreSQL databases to Cloud and between Cloud platforms.
- Must have the mindset of helping customers to implement Community PostgreSQL and Open Source solutions for regular activities.
- Must have expertise on managing PostgreSQL for at least 5 years.
- If you have been an Oracle DBA for more than 5 years, at least 2 years of experience in PostgreSQL is preferred.
- Must have a deeper understanding of the PostgreSQL architecture and internals.
- Should have an understanding of the limitations and the work-arounds for managing PostgreSQL deployed on DBaaS platforms.
- Must have knowledge on implementing Automatic failover, Parallel backups and Connection Pooling using Open Source tools.
- Must be able to handle Catalog Corruptions, Database Corruptions and Point in time recovery.
- Must be able to analyze the logs and optimize the time consuming SQL’s.
- Must have knowledge on the most widely used extensions in PostgreSQL for monitoring, analyzing and maintaining the databases.
- Must be able to perform PostgreSQL Upgrades from legacy to latest versions with least possible downtime.
- Skills in scripting using Python or Golang.
- Migrating schema and data from any other database to PostgreSQL.
Job Responsibilities:
Technical Skills required:
Good to have skills :
Regards,
Avinash Vallarapu
Avinash Vallarapu
+1-902-221-5976