Senior Oracle Database / E-Business Suite Engineer

The Sherwin-Williams Company; Cleveland (OH); On-site; USD 120,000 - 170,000; Full time

Job summary

The Senior Database Engineer role designs and develops robust, secure database systems that meet the organization's needs. They build technical platforms with modern tooling and create operations and maintenance processes to speed development and production support.

The role collaborates with developers, data analysts, data scientists, and business analysts to ensure reliable data platforms across the enterprise.

Qualifications

• Bachelor's degree in Computer Science, Statistics, or Information Systems, or equivalent DB experience.
• 4+ years of database engineering and administration experience.
• Experience with Oracle relational databases and data security practices.
• Ability to translate business data needs into technical language.
• Experience handling large, unstructured data from disparate sources.

Responsibilities

• Design and develop database systems, standards, guidelines and QA for deliverables.
• Patch and maintain database systems for security and supportability.
• Document and communicate designs to stakeholders and analyze data architecture impact.
• Code complex programs and develop logical processes on platforms.
• Participate in QA by testing database code in client-server environments.
• Adapt requirements to develop data specifications and table attributes.
• Develop understanding of data storage mechanisms and assist capacity planning.
• Determine data storage suitability and optimal organization.
• Model table relations and field interactions in a relational model.
• Define disaster recovery, backup, recovery and archiving strategy.

Skills

Oracle relational databases

SQL/PLSQL

Data security practices

Backup and recovery strategies

Database design & administration

Handling large data sets

Education

Bachelor's degree in Computer Science, Statistics, or Information Systems

Tools

Jenkins

Ansible

Python

GitHub

CyberArk PAM

ServiceNow ITSM

Job description

The Senior Database Engineer role designs and develops robust and reliable database management systems that are secure, reliable, and meet the organization's needs. They will develop technical platforms using modern tooling, build systems and processes for operations and maintenance that facilitate production needs and speed application development. By doing so, they bring significant value to the organization by ensuring that business operations run smoothly and efficiently, and change can be efficiently performed and managed. The incumbent works collaboratively with cross-functional teams that include developers, data analysts, data scientists, business analysts, and other relevant stakeholders within the organization.

What the role will do:

• Design and develop database management systems, standards, guidelines and quality assurance for database deliverables.
• Patch and maintain database systems for optimal security and supportability
• Document and communicate database designs to relevant stakeholders and analyze the impact of the data architecture
• Code complex programs and develop logical processes on technical platforms.
• Participate in quality assurance by developing and testing database code in client server environments.
• Adapt business requirements and develop data, database specifications, and table and element attributes for applications.
• Develop an understanding of the organization's data and storage mechanisms and assist with capacity planning.
• Determine appropriateness of data for storage and optimum storage organization.
• Determine how tables relate to each other and how fields interact within the tables for a relational model.
• Work with stakeholder to define the database Disaster Recover plan, database back-up, recovery and archiving strategy.

This role is not remote/ hybrid and will report to Sherwin-Williams Global Headquarters located at 1 Sherwin Way, Cleveland, OH 44113.

This position is not eligible for sponsorship for work authorization now or in the future, including conversion to H1-B visa. Must be legally authorized to work in the country of employment without needing sponsorship for employment work visa status now or in the future.

Job duties include contact with other employees and access confidential and proprietary information and/or other items of value, and such access may be supervised or unsupervised. The Company therefore has determined that a review of criminal history is necessary to protect the business and its operations and reputation and is necessary to protect the safety of the Company's staff, employees, and business relationships.

Must be eighteen years or older.

Required Qualifications

• Bachelor's degree in Computer Science, Statistics, or Information Systems or in lieu of a degree, at least 7 years of experience in the field of database engineering and administration
• 4+ years of experience in database engineering and administration
• Knowledge and experience with database design, implementation, documentation, and management
• In-depth understanding of database management systems and data structures
• Experience translating business data needs into technical language
• Ability to deal with large pool of data often unstructured coming from disparate sources
• Experience with Oracle relational databases
• Experience with query and coding languages [such as SQL, PL/SQL]
• Knowledge and experience in database performance tuning, backup and recovery strategies, and data security practices
• Must be legally authorized to work in the Untied States without sponsorship now or in the future for employment
• Must be at least eighteen (18) years of age

Preferred Qualifications

• Experience with Oracle Database 19c multitenant architecture and administration.
• Experience with Oracle E-Business Suite R12 administration that includes cloning, patching, upgrades, and general maintenance.
• Experience with autonomous databases on Oracle Cloud Infrastructure (OCI).
• Experience with Oracle Enterprise Manager (OEM) 13.5 for database monitoring.
• Experience with database performance tuning and SQL query optimization.
• DevOps experience with tools such as Jenkins and Ansible, Python, and GitHub.
• Privileged Access Management (PAM) experience with tools such as CyberArk is a plus.
• Experience with ITIL/ITSM tools such as ServiceNow is a plus.
• Experience with Emerging Technologies (OEL9, Oracle DB 26ai, Oracle OEM 24ai) is a plus.
• Experience driving Operational Efficiency (Automation, Process Improvement) and Technical Debt Remediation is a plus.