PostGres Technical Lead

Company Description

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

Job 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: 06-08 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.