We're a global team unified in a common purpose: creating advanced technology solutions to the world's water challenges. Developing new technologies that will improve the way water is used, conserved, and re-used in the future is central to our work. Our products and services move, treat, analyze, monitor and return water to the environment, in public utility, industrial, residential and commercial building services settings. Xylem also provides a leading portfolio of smart metering, network technologies and advanced analytics solutions for water, electric and gas utilities. In more than 150 countries, we have strong, long-standing relationships with customers who know us for our powerful combination of leading product brands and applications expertise with a strong focus on developing comprehensive, sustainable solutions. For more information, please visit us at www.xylem.com
If you are excited and passionate about helping us solve water, we want to hear from you!
Sensus, a Xylem brand, helps a wide range of public service providers from utilities to cities to industrial complexes and campuses do more with their infrastructure to improve quality of life in their communities. We enable our customers to reach farther through the application of technology and data-driven insights that deliver efficiency and responsiveness. We partner with them to anticipate and respond to evolving business needs with innovation in sensing and communications technologies, data analytics and services. Learn more at sensus.com and follow @SensusGlobal on Facebook, LinkedIn and Twitter.
The Role: Sensus, a Xylem brand, seeks to hire a technically skilled Database Administrator. This position will manage all databases currently used for our applications. The main databases are Oracle, MSQL and Postgres. This potion requires maintaining integrity, availability security and performance of the application databases. Can you envision yourself in a startup-like environment growing its smart infrastructure solutions portfolio? Join our team and bring your great ideas and energy to this critical role which impacts our business objectives while helping the world!
Conducts in depth database monitoring and performance analysis
Troubleshoots highly complex system level issues that encompass system configuration, and software.
Provide feedback to design and development engineering for database requirements as well as performance analyses
Develops migration tools to support table to table migration from one version to the next of our proprietary application.
Help to troubleshoot when upgrades from previous version of our application fails to upgrade to the newer version. This means willing to learn some components of our applications
Able to design Database backups plans and processes
Able to configure and provide feedback to configure and monitor SQL clusters
Configure SQL Server Always on clusters
Oracle database migrations from 11g to latest
Education, Experience, Skills, Abilities, License/Certification:
Experience with MSQL 2008 , 2014 and 2016
Experience with SQL Server Always on Failover Clustering
Highly knowledgeable on Oracle 12G
Oracle database migrations from 11g to latest
Troubleshoot and resolve security issues, connectivity issues, blocking & deadlock issues and performance issues.
Detect and troubleshoot CPU, memory, I/O, disk space and other resource contention.
Work experience in Oracle and SQL Server partitioning.
Work experience with SQL Profiler and Oracle trace methods.
Ability to develop plans for future storage requirements.
Automation of MS SQL Server maintenance and alerting. Monitoring failed and long running MS SQL Server jobs.
Ability to write automated shell scripts and complex queries.
Exposure to Data Collection & linked server setup in SQL server.
Be willing to work off-hours and weekends, as needed, and participate in an On-call rotation.
Willing to travel at short notice if required.
(The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.)
(The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.)
Office: Standard office equipment; work usually performed in an office setting free from any disagreeable elements.
Standard weekly job hours: 40 hours
EOE including disability and veteran