MigOps - PostgreSQL Database Administrator !

MigOps is looking for a PostgreSQL database administrator with the
following responsibilities.
Visit : https://www.migops.com/careers/ to apply or send an email to :
careers(at)migops(dot)com

Job Responsibilities:
1. Manage PostgreSQL databases and collaborate with our customers on
their in-house projects.
2. Perform Architectural health checks and suggest optimizations and
design changes through a detailed summary.
3. Optimize the performance of postgres databases using your
knowledge in PostgreSQL Internals.
4. Tune SQL’s and write complex scripts for day-to-day administrative
tasks.
5. Flexible in managing PostgreSQL databases on Cloud such as – AWS
RDS & Aurora, GCP, Azure, etc.
6. Publish blog posts and write knowledge base articles used by our
customers.
7. Upgrade and Migrate PostgreSQL databases to Cloud and between
Cloud platforms.

Technical Skills required:
1. Must have the mindset of helping customers to implement Community
PostgreSQL and Open Source solutions for regular activities.
2. Must have expertise on managing PostgreSQL for at least 5 years.
3. If you have been an Oracle DBA for more than 5 years, at least 2
years of experience in PostgreSQL is preferred.
4. Must have a deeper understanding of the PostgreSQL architecture
and internals.
5. Should have an understanding of the limitations and the
work-arounds for managing PostgreSQL deployed on DBaaS platforms.
6. Must have knowledge on implementing Automatic failover, Parallel
backups and Connection Pooling using Open Source tools.
7. Must be able to handle Catalog Corruptions, Database Corruptions
and Point in time recovery.
8. Must be able to analyze the logs and optimize the time consuming
SQL’s.
9. Must have knowledge on the most widely used extensions in
PostgreSQL for monitoring, analyzing and maintaining the databases.
10. Must be able to perform PostgreSQL Upgrades from legacy to latest
versions with least possible downtime.

Good to have skills :
1. Skills in scripting using Python or Golang.
2. Migrating schema and data from any other database to PostgreSQL.

--
Regards,
Avinash Vallarapu
+1-902-221-5976