PostGres Technical Lead

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.

Job highlights

1. Minimum 6 years of experience in database support, proficiency in PostgreSQL, strong SQL and Linux scripting skills
2. Manage and optimize PostgreSQL databases, ensure uptime and performance, lead automation efforts.
3. Location: Noida and Chennai
4. Total Experience: 6-8 years

Job Requirements

1. Candidate must possess a solid background with a minimum of 6 years of experience in providing both technical and operational support activities for Database Servers. This includes logical and physical database design, troubleshooting, performance monitoring, tuning, and optimization.
2. Should be proficient in PostgreSQL database cloning using Pg_dump and Pg_Restore. They will be responsible for reviewing all PostgreSQL logs and addressing any problems that arise. Experience with Postgres Connection Pooling, specifically PgBouncer, is essential.
3. Hands-on operational DBA expertise is required in the areas of Replication, High Availability, and Backup/Recovery. Advanced performance-tuning skills are needed to review performance data and prepare comprehensive reports. Moreover, SQL and Linux scripting skills are a must for this position.
4. Strong communication skills are imperative, as the candidate will need to manage escalation calls effectively. Experience working on an Application/Development team or as an Application DBA is highly valuable.
5. The role involves managing Development, QA, Staging, and Production databases and applications, ensuring future enhancements meet the business needs of end users. Monitoring database health in terms of availability, reliability, performance, and capacity planning is a critical responsibility.
6. The candidate will be tasked with upgrading PostgreSQL Databases and ensuring the monitoring and uptime of all production databases. They must estimate PostgreSQL database capacities and develop methods for monitoring database capacity and usage efficiently.
7. Leading efforts to develop and improve procedures for automated monitoring and proactive intervention to minimize downtime is expected. Additionally, they will be responsible for reviewing developer SQL code to ensure queries are optimized and tuned to perform efficiently before production release.
8. Regular maintenance on databases is part of the job and should be capable of supporting complex web-based applications and handling Automatic Switchover and Failover processes.

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