PostGres Technical Lead

About Sopra Steria
Sopra Steria, a European tech leader recognised for its consulting, digital services and software development, helps its clients drive their digital transformation to obtain tangible and sustainable benefits. It 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 fully 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. With 50,000 employees in nearly 30 countries, the Group generated revenue of €5.1 billion in 2022.  The world is how we shape it.

Sopra Steria (SOP) is listed on Euronext Paris (Compartment A) – ISIN: FR0000050809  For more information, visit us at www.soprasteria.com

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: 06-08 years

Any Graduate, Any engineering graduate

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.