Technical Expert, Database Administrator(PostgreSQL)

Landis+Gyr is a leading global provider of integrated energy management solutions. We measure and analyze energy utilization to generate empowering analytics for smart grid and infrastructure management, enabling utilities and consumers to reduce energy consumption. Our innovative and proven portfolio of software, services and intelligent sensor technology is a key driver to decarbonize the grid and helped to avoid around 9 million tons of CO2 in FY 2023. With sales of USD 2.0 billion in FY 2023, Landis+Gyr employs around 6,900 talented people across five continents. 

For more than a century, we've been pioneers in energy innovation, and we continue to lead the way toward a more sustainable and efficient energy landscape. 

Join us at Landis+Gyr, where we manage energy better! 

Job Description: 

Excellent comunication skills and collaborative approach 

Strong proficiency in PostgreSQL database adminstration and management. 

Proficient in  End- to end database migrations from on-prem to public cloud preferably GCP. Should be able to lead the migrations and share the knoweldge to the team members. 

Proficient in Postgres database performance tunning. 

Perform hetrogenous migrations ( from oracle to posgres/ sql to postgres) 

Develop Stored procedures, load balancing and High Availability. 

Proficient in backup and recovery in Community and edb postgres 

Primary core competency is PostgreSQL database with mix of other Oracle and SQL as secondary. 

Through understanding of database design, performance tuning and optimization techniques. 

Proficient in troublshooting and solving complex performance problems. 

Experience managing operationson core and cloud- based infra environments. 

Investigate and troubleshoot database- related issues, including connectivity problems, performance degradation and data inconsistencies. 

Provide timely resolution and root cause analysis for the Incidents. 

Generate comprehensive documentation support database issues arising from customer queries. 

Good knowlege of EDB database tools like Barman, EFM etc. 

Technical Skills 

Significant background in creating complex stored procedures and SQL scripts in PostgreSQL. 

Understanding of database normalization concepts. 

Proven SQL and PostgreSQL experience. 

Experience in designing and automating repetitive processes. 

Experience with cloud- based database services (Google Cloud SQL, Azure database, AWS RDS). 

Good hands-on scripting language. 

Excellent problem- solving and analytical skills. 

Effective communication and collaboration abilities. 

Experience working with or in an automated operations environment (like Ansible). 

Good to have hands on various PostgreSQL tools like EFM, MTK( Migration Tool Kit) and BARMAN. 

Job Description: 

Excellent comunication skills and collaborative approach 

Strong proficiency in PostgreSQL database adminstration and management. 

Proficient in  End- to end database migrations from on-prem to public cloud preferably GCP. Should be able to lead the migrations and share the knoweldge to the team members. 

Proficient in Postgres database performance tunning. 

Perform hetrogenous migrations ( from oracle to posgres/ sql to postgres) 

Develop Stored procedures, load balancing and High Availability. 

Proficient in backup and recovery in Community and edb postgres 

Primary core competency is PostgreSQL database with mix of other Oracle and SQL as secondary. 

Through understanding of database design, performance tuning and optimization techniques. 

Proficient in troublshooting and solving complex performance problems. 

Experience managing operationson core and cloud- based infra environments. 

Investigate and troubleshoot database- related issues, including connectivity problems, performance degradation and data inconsistencies. 

Provide timely resolution and root cause analysis for the Incidents. 

Generate comprehensive documentation support database issues arising from customer queries. 

Good knowlege of EDB database tools like Barman, EFM etc. 

Technical Skills 

Significant background in creating complex stored procedures and SQL scripts in PostgreSQL. 

Understanding of database normalization concepts. 

Proven SQL and PostgreSQL experience. 

Experience in designing and automating repetitive processes. 

Experience with cloud- based database services (Google Cloud SQL, Azure database, AWS RDS). 

Good hands-on scripting language. 

Excellent problem- solving and analytical skills. 

Effective communication and collaboration abilities. 

Experience working with or in an automated operations environment (like Ansible). 

Good to have hands on various PostgreSQL tools like EFM, MTK( Migration Tool Kit) and BARMAN. 

We're committed to shaping a better future for everyone. #EnergizeYourCareer and join us on our journey towards a greener tomorrow.