Description

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

Qualifications

Any Graduate, Any engineering graduate

Additional Information

At our organization, we are committed to fighting against all forms of discrimination. We foster a work environment that is inclusive and respectful of all differences.

All of our positions are open to people with disabilities.

Company Description

About Sopra Steria
Sopra Steria, a major Tech player in Europe with 50,000 employees in nearly 30 countries, is recognised for its consulting, digital services and solutions. It helps its clients drive their digital transformation and obtain tangible and sustainable benefits. The Group provides end-to-end solutions to make large companies and organisations more competitive by combining in-depth knowledge of a wide range of business sectors and innovative technologies with a collaborative approach. Sopra Steria places people at the heart of everything it does and is committed to putting digital to work for its clients in order to build a positive future for all. In 2024, the Group generated revenues of €5.8 billion.
The world is how we shape it.