Database Administrator

Xylem Inc. Morrisville , NC 27560

Posted 8 months ago

Xylem |zlm|

  1. The tissue in plants that brings water upward from the roots;
  2. a leading global water technology company.

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!


Essential Duties/Principal

Responsibilities:
  • 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

Minimum Qualifications:
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.

Physical Demands:

(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.)

  • Regularly required to sit or stand, reach, bend and move about the facility

Work Environment:

(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


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Senior Database Administrator

Intellitrans

Posted 3 weeks ago

VIEW JOBS 10/21/2019 12:00:00 AM 2020-01-19T00:00 TransCore (TRN), a subsidiary of Roper Technologies, Inc. (NYSE: ROP) is seeking a full-time Senior Database Administrator to join our team in Raleigh, NC. Job Summary: The Senior Database Administrator provides day-to-day and on-call first line technical support for our Infinity production installations. Troubleshoots and follows through-to-resolution issues concerning the application and the database. This position will involve ensuring the database systems are configured and deployed properly with the correct parameters, configurations, SW versions and performance settings, will develop and optimize stored procedures, and will analyze the flow of the data throughout the system to validate it is functioning properly. Will analyze and assure proper database performance. Essential Duties and Responsibilities include the following. Other duties may be assigned. * Provide first line of software support for our Infinity installations during normal business and off hours. * Develop and optimizing SQL queries, stored procedures and functions to support system operations and customer requirements. * Support SQL Server databases from a DBA perspective in high availability environments. * Troubleshoot and resolve database integrity issues, performance issues, blocking and deadlocking issues, replication issues, connectivity issues, and security issues. * Create required database indexes, index management, and maintain statistics. * Develop software utilizing the .NET framework (C#, RDL.NET, ADO.NET). * Troubleshooting and debug .NET service oriented (SOA) Windows applications using WCF/WPF frameworks. * Monitor current system installations for performance degradation and perform preventative and corrective cleanup activities to assure proper functioning of the database systems. * Continued performance improvement of the Infinity system including the database. * Support Production, Development and QA Environments. * Analyze Transaction Data Reports and reconcile data differences Education: Bachelor's degree from a four year college or university or equivalent combination of education and work experience. Required Skills & Experience: * 3+ years of professional experience in SQL Server Database Administration with strong SQL Development. * Experience with using SQL Server tools and system stored procedures. * Experience with Performance Tuning and Optimization. * Highly motivated team player who can establish excellent working relationships with peers and other teams. * Ability to understand business requirements and estimate for delivery commitments. * Excellent verbal, phone, and written communication skills. Desired Skills: * Experience as a .NET Software Engineer developing and maintaining solutions in C#, RDL.NET ADO.NET and ASP.NET utilizing Visual Studio (2005, 2008, 2013, and 2015). * Previous experience within the Tolling Industry Intellitrans Morrisville NC

Database Administrator

Xylem Inc.