Senior Database Administrator at Leviton Manufacturing | NY | Rezi

Senior Database Administrator at Leviton Manufacturing

Senior Database Administrator

Leviton Manufacturing · NY

Yesterday

Senior Database Administrator

Leviton Manufacturing · NY

a day ago
Resume preview

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

This position manages focused initiatives set forth by the Group Leader and the Information Management department. It supports critical enterprise database management systems (DBMS) for various applications using Oracle database, Microsoft SQL Server, MongoDB, MySQL, and technologies running in OCI.

Responsibilities

  • Performs or directs all aspects of database administration for assigned DBMS, including space management, backup and recovery, performance monitoring, disaster recovery planning, security planning, tuning, capacity planning, and troubleshooting.
  • Performs or directs all application administration functions for the supported enterprise application, including installation, upgrade, performance monitoring, capacity planning, and troubleshooting.
  • Proactively innovates and implements tailored database solutions, leads data modeling efforts, and contributes to all stages of database development.
  • Acts as the primary contact for issues regarding the enterprise application and underlying DBMS, consulting on database requirements for current and future projects, and recommending hardware and software solutions.
  • Works with vendor support to resolve issues effectively and in a timely manner.
  • Enhances knowledge of the enterprise application and DBMS platform through formal training and professional reading.
  • Adheres to Leviton change control standards and policies.
  • Provides proactive and reactive administration of the associated enterprise application, preventing or resolving user issues.
  • Continuously improves service and processes.
  • Demonstrates increased knowledge and understanding of the enterprise application and the DBMS platform.

Requirements

  • Knowledge of Oracle ERP e-Business Suite (EBS), including Internet and Web technologies (XML, Java, TCP/IP, Web servers, Web Services – Tomcat, WebLogic OA Core, firewalls, SSL).
  • 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, Oracle ODI, OICS, OCI, Toad.
  • Ability to perform data modeling and database design, creating efficient physical database designs from logical models, and managing database schema and application specifications.
  • Ability to implement appropriate database backup and recovery strategies based on data volatility and application availability requirements.
  • Ability to proactively monitor the database environment and optimize performance by making changes to data structures, SQL, application logic, or the DBMS subsystem.
  • Ability to ensure applications and data are available 24x7.
  • Ability to ensure data security by implementing a rigorous security infrastructure for production and test databases.
  • Ability to perform capacity planning, predict growth based on usage patterns, and implement necessary database changes.
  • Understanding of how extensible data types are implemented by the DBMS vendor and ability to implement and administer them.
  • Understanding of storage hardware and software and how it interacts with the DBMS.
  • Ability to review and optimize SQL and host language programs.
  • Ability to design, debug, implement, and maintain stored procedures, triggers, and user-defined functions.
  • Demonstrates organizational and communication skills.
  • Possesses 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, with a commitment to follow up on issues until resolved satisfactorily.

Skills

  • Oracle ERP e-Business Suite (EBS)
  • Internet and Web technologies
  • XML
  • Java
  • TCP/IP
  • Web servers
  • Web Services
  • Tomcat
  • WebLogic OA Core
  • Firewalls
  • SSL
  • Oracle database
  • Microsoft SQL Server
  • MongoDB
  • MySQL
  • Postgres
  • PL/SQL
  • Microsoft Office
  • Autosys
  • Linux shell scripting
  • SVN
  • Oracle ODI
  • OICS
  • OCI
  • Toad
  • Data modeling
  • Database design
  • Backup and recovery strategies
  • Performance management and tuning
  • Data security
  • Capacity planning
  • Extensible data type administration
  • Storage management techniques
  • SQL code reviews
  • Procedural skills
  • Stored procedures
  • Triggers
  • User-defined functions
  • Organizational skills
  • Communication skills
  • Project management

Location

  • Remote

Work Type

  • Full-time

Experience Level

  • 5 to 8 years’ experience in most aspects of DBMS Information Management

Education Level

  • BS Computer Science or equivalent; MS Computer Science preferred

Salary/Compensations

  • $140,000.00 - $150,000.00 per year

Benefits

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

About the Company

  • Leviton builds solutions that light, power, and connect everyday spaces, from electrical to lighting, to data networks, and energy management.
  • With over 115 years of history, Leviton develops thoughtful solutions that help make its customers' lives easier, safer, more efficient, and more productive.
  • Leviton values employees who ask questions, embrace challenges, seek new perspectives, and anticipate what comes next.

Equal Opportunity

  • 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.