17 Oct
landis+gyr ltd (noida)
Greater Noida
Job Description
# Technical Expert, Database Administrator
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!
## :
- 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. Should be able to lead the migrations and share the knowledge with team members.
- Proficient in Postgres database performance tuning.
- Perform heterogeneous migrations (from Oracle to Postgres/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 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 infrastructure 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 to support database issues arising from customer queries.
- Good knowledge 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 skills.
- 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.
We're committed to shaping a better future for everyone. #EnergizeYourCareer and join us on our journey towards a greener tomorrow.
**Job Title:** Technical Expert, Database Administrator
**Requisition ID:** 20401
**Location:** Noida, UP, IN
**Workplace Type:** Hybrid
**Career Level:** Experienced
**Date Posted:** Oct 15, 2024
▶️ Technical Expert, Database Administrator Job Details | Landis Gyr
🖊️ landis+gyr ltd (noida)
📍 Greater Noida