Technical Expert, Database Administrator (PostgreSQL)

As a part of the Landis+Gyr team, you will have the opportunity to work with a leading global provider of integrated energy management solutions. Your role will involve the following key responsibilities and qualifications: Role Overview: - Excellent communication skills and collaborative approach. - Strong proficiency in PostgreSQL database administration and management. - Proficient in end-to-end database migrations from on-prem to public cloud, preferably GCP. You should be able to lead the migrations and share knowledge with team members. - Proficient in Postgres database performance tuning. - Ability to perform heterogeneous migrations (from Oracle to PostgreSQL/SQL to PostgreSQL). - Develop stored procedures, load balancing, and ensure high availability. - Proficient in backup and recovery in Community and EDB PostgreSQL. - Primary core competency in PostgreSQL database with a mix of other Oracle and SQL as secondary. - Thorough understanding of database design, performance tuning, and optimization techniques. - Proficient in troubleshooting and solving complex performance problems. - Experience managing operations on 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 incidents. - Generate comprehensive documentation to support database issues arising from customer queries. - Good knowledge of EDB database tools like Barman, EFM, etc. Qualification Required: - 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 experience with various PostgreSQL tools like EFM, MTK (Migration Tool Kit), and BARMAN. Join Landis+Gyr in their commitment to shaping a better future for everyone. #EnergizeYourCareer and be a part of the journey towards a greener tomorrow.,