Postgres Module Lead Job at Sopra Steria (Chennai)

Job Description

PostgreSQL DBA Job Description

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
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

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
Must have the mindset of helping customers to implement Community PostgreSQL and Open-Source solutions for regular activities
Any Graduate, Any engineering graduate
Total Experience Expected: 04-06 years