Responsibilities
- Create the objects in the database, such as triggers, indexes, etc.
- Monitor the performance of the database and ensure optimum performance.
- Identify potential issues in the database to solve them early.
- Maintain backups and perform disaster recovery in case a disaster destroys the database.
- Monitor security and prevent any unauthorized access to the database.
- Schedule consistent maintenance on the server
- Maintain database schema.a
- Manage database availability.
- Give best practice guidance to the development team.
- Resolve any production data issues.
- Tablespace management
- Role management
- Develop automation technologies to accelerate the process of data loading.
- Develop relational databases.
- Ensure data integrity.
- Manage user access and permissions by adding and removing users as required.
- Maintain the database using different utilities. This includes using like pg_ctl and psql.
- 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 PostgreSQL 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.
Requirements
- 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 understand the limitations and the workarounds 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.
Nice to Have
- Skills in scripting using Python or Golang.
- Migrating schema and data from any other database to PostgreSQL.
Additional Information
- Total Experience Expected: 04-06 years
