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 Summary

This position is a hands-on PostgreSQL Database Administrator III role that is responsible for the support and administration of Software and Services Database Infrastructure. Qualified Database Administrator is responsible for independently analyzing database performance characteristics and collaboratively changing the database design to improve performance and resource utilization. Requires the ability to understand Internal customer requirements and provide solutions that meet those requirements. An in-depth knowledge of Database technologies is required and a familiarity of other technology platforms is essential for the success of the Database team.

Primary Responsibilities:

• Administers, manages, and monitors all systems, including databases, in development, test, stage, and production environments.
• Design and implementation of Postgres databases, high-availability solutions, replication, encryption, and disaster recovery solutions.
• Manage secure access to DB inclusive of DBA.
• Data sharing/Partitioning, Purging, and Archiving solutions in the PostgreSQL GCP ecosystem.
• Able to port/upgrade across versions.
• Query analysis and troubleshooting responsibilities.
• Provide technical leadership through example, and develop innovation, strategies, processes, and best practices.
• Monitor database performance, implement changes, and apply new patches and versions when required.
• Manage PostgreSQL databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
• Independently analyze, solve, and correct issues in real-time, providing problem resolution end-to-end
• Perform scheduled maintenance and support release deployment activities after hours.
• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
• Own and manage uptime and performance SLAs.
• Work with the Development and QA team, and guide developers on following best coding practices to write optimal & efficient code.
• Guide on analyzing and fine-tuning queries to be optimal and efficient.
• Perform regular maintenance and archival activities complementing in managed databases
• Essure availability/ recovery with minimal downtime.
• Writing PostgreSQL, including stored procedures, functions, views, and triggers is good to have.

Education and Experience:

• Any PostgreSQL certifications a plus
• Advanced level of technical experience and the ability to understand overall database  architecture and design, the interactions of software, hardware, and user activity to be able to troubleshoot problems across all subsystems

Knowledge, Skills and Abilities:

• Bachelor’s Degree is preferred.
• PostgreSQL Professional Certifications
• 5+ years in database tuning and project support, database server upgrades and migrations, and writing and troubleshooting database stored procedures.
• In-depth knowledge of security best practices including database encryption, column-level encryption, SSL/TLS connection encryption, and service-specific account permissions.
• Experience with databases specifically EDB/Open source Postgres.
• Good understanding of DevOps and the role of database administration teams in DevOps.
• Experience performing database deployments 
• Advanced knowledge of performance tuning and administration, query analysis, performance monitoring and tuning, and maintenance routines
• Experience with data warehouse and reporting technologies (specifically Power Bi) a plus.
• Background in automating processes
• Experience with creating and maintaining database infrastructure.
• Personal Computer knowledge
• Familiarity with Microsoft Office Suite
• Keyboard/typing skills
• Ability to effectively communicate both verbally and in writing.

Accountabilities/Measures:

• Manages others:  No   Headcount of:  4 to 7
• Resp. for operating expense budget:  No  
• Revenue (direct resp):  No 
• P&L responsibility:  No 
• Decision-making:  Ltd decision-making; low impact

Business Relationships (Internal and External Customers):

• This position will require communications with Internal customers and contacts, as well as external partners, vendors, and customers.

Working Conditions/Physical Requirements/Safety/PPE:

• While performing the duties of this job, the employee is occasionally required to stand; walk; sit; use hands to finger, handle, or feel objects, tools or controls; reach with hands and arms; climb stairs; balance; stoop, kneel, crouch or crawl; talk or hear; taste or smell.

• The employee must occasionally lift and/or move up to 20 pounds.

• Specific vision abilities required by the job include close vision, distance vision, color vision, peripheral vision, depth perception, and the ability to adjust focus.

• Personal Protection Equipment/Other OHSAS-Safety Requirements:  None required

Landis+Gyr is a global leader in energy management solutions, operating in over 30 countries and headquartered in Switzerland. We are thrilled that you’ve considered Landis+Gyr to be a part of your professional journey. As a part of the L+G family, employees are offered a comprehensive and competitive package of benefits including medical, dental and vision coverage, life insurance, and a 401(k)-retirement plan featuring a generous company match incentive. Additionally, we offer three (3) weeks of Paid Time Off (PTO) as well as eleven (11) paid holidays. We also offer a tuition reimbursement program, optional pet insurance, supplemental medical coverage and a host of other perks to ensure the health, wellness, and enrichment of our team members.
 

Pay is in the range of $81,400 - $126,800 per year. The position is eligible for a 401(k) match and consideration for an annual bonus. The actual base salary offered depends on a variety of factors, which may include, as applicable, the qualifications of the individual applicant for the position, years of relevant experience, specific and unique skills, level of education attained, and certifications or other professional licenses held. All candidates are encouraged to apply.
 
 
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

We stand for a workplace that nurtures growth, fosters connection, and embraces authenticity. We believe that fostering a community that values diversity isn't just a goal; it's a way of life. The real magic? That happens when a group of unique minds comes together – bring yours and #EnergizeYourCareer!