[Hiring] Senior Database Administrator @Leviton Manufacturing

Role Description

This position manages focused initiatives set forth by the Group Leader and the Information Management department. Supports all critical enterprise database management systems (DBMS) for Oracle E-Business Suite, Peoplesoft, Hyperion, Kronos, Data Warehouse, and custom applications using Oracle database, Microsoft SQL Server, MongoDB, MySQL, and technologies running in OCI (Oracle Cloud Infrastructure).

• Performs or directs to be performed all aspects of database administration for the assigned Database Management Systems, including:
  • Space management
  • Backup and recovery
  • Real-time and historical performance monitoring
  • Disaster recovery planning
  • Security planning
  • Proactive and reactive tuning
  • Capacity planning
  • Problem troubleshooting and resolution
• Performs or directs to be performed all application administration functions related to the enterprise application being supported, including:
  • Installation and upgrade
  • Performance monitoring and tuning
  • Capacity planning
  • Problem troubleshooting and resolution
• Proactively innovates and implements tailored database solutions, leads data modeling efforts, and actively contributes to all stages of database development.
• Acts as “go-to” for issues regarding the enterprise application and the underlying DBMS, consults and advises on all matters, including database requirements for ongoing and future projects; recommends hardware and software solutions.
• Works with vendor support to resolve issues in an effective and timely manner.
• Enhances own knowledge of the enterprise application and underlying DBMS platform through formal training and professional reading.
• Adheres to Leviton change control standards and policies.
• Proactive and reactive administration of the associated enterprise application as demonstrated by prevention and/or timely resolution of user issues.
• Continuous improvement in service and processes.
• Demonstrable increase in knowledge and understanding of the enterprise application and the DBMS platform.

Qualifications

• Oracle ERP e-Business Suite (EBS) - must have knowledge of Internet and Web technologies to enable databases to participate in Web-based applications.
• In-depth knowledge of:
  • Oracle database
  • Microsoft SQL Server
  • MongoDB
  • MySQL
  • Postgres
  • PL/SQL
  • Web Services – Tomcat, WebLogic
  • Microsoft Office
  • Autosys
  • Linux shell scripting
  • SVN – Version control software
  • Oracle ODI
  • OICS
  • OCI
  • Toad
• Data modeling and database design – must possess the ability to create an efficient physical database design from a logical data model.
• Backup and recovery – must be able to implement an appropriate database backup and recovery strategy.
• Performance management and tuning - must be able to proactively monitor the database environment.
• Ensuring availability - must be able to ensure applications and data to be up and available 24x7.
• Data security - ensure that only authorized users have access to data.
• Capacity planning - must be prepared to support more data, more users, and more connections.
• Extensible data type administration - must understand how these user-defined data types are implemented by the DBMS vendor.
• Storage management techniques - must understand the storage hardware and software.
• SQL code reviews and walk-thru – must possess in-depth SQL knowledge.
• Procedural skills - must possess procedural skills to help design, debug, implement, and maintain stored procedures, triggers, and user-defined functions.
• Behavioral skills - demonstrates a people-oriented personality with proactive and collaborative traits.
• Ability to work on projects and meet deadlines with little or no supervision.
• Detail oriented and thorough and follow up on issues until resolved satisfactorily.

Requirements

• BS Computer Science or equivalent; MS Computer Science preferred.
• 5 to 8 years’ experience in most aspects of DBMS Information Management.

Travel

• 10% overall; may be significantly higher during the duration of a project.

Benefits

• Comprehensive benefits include:
  • Medical, dental, and vision insurance programs
  • 401K plans with employer-matching contributions
  • Tuition reimbursement
  • PTO
  • Paid holidays
  • Volunteer time off

Company Description

Leviton is an EEO/AA Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, or protected veteran status.

Reasonable accommodations may be made to enable individuals with disabilities to perform essential job functions.

Leviton is committed to transparency and security in the recruitment process and will never ask for financial information, payment, or government identification numbers during the application process.

For any questions, or to ensure the legitimacy of a job posting, visit the Leviton career site, or contact us at 631.812.6544.

The future looks brighter than ever. Join our team now!