PostgreSQL DBA Job Description
Roles and 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.
Job 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 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.
Technical Skills required:
· 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.
Good to have skills:
· Skills in scripting using Python or Golang.
· Migrating schema and data from any other database to PostgreSQL.
Total Experience Expected: 04-06 years