Job Description Honorable purpose serving patients and pets: Join Midmark's IT Team, where we improve the lives of patients - human and fury - in the areas of medical, dental, and veterinary.
We are looking for a talented Senior Oracle Applications DBA. This position will be a hands-on teammate contributing to an Oracle Platform Team. Perks include continuous training opportunities, flexible work hours, and amazing team culture. This is an onsite position at our Ohio location.
Oracle EBS environment has strong executive support to stay current, implement new module, implement pro-active monitoring, cloud-based infrastructure, and leverage Agile methodologies to automate and improve reliability and performance.
Midmark will only employ those who are legally authorized to work in the United States. Midmark does provide sponsorship for select positions.
JOB SUMMARY: Designs, specifies, and configures the Oracle database, to ensure it is up and running well by performing activities related to day-to-day administration, monitoring, and maintenance of Midmark's Oracle R12.2 E-Business Suite (applications tier, middle-tier, and database tier). Administers, installs, maintains, develops and implements policies and procedures for ensuring the security, availability and integrity of these environments. The ideal candidate would have familiarity with scripting langues and certificate management.
ESSENTIAL/PRIMARY DUTIES: - Determines database structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients; evaluating current systems;
- Develops database solutions by designing proposed system; defining database physical structure and functional capabilities, security, back-up, and recovery specifications.
- Installs database systems by developing flowcharts; applying optimum access techniques; coordinating installation actions; documents actions.
- Perform day-to-day database administration and performance monitoring tasks
- Resolves database performance issues, database capacity issues, replication, and other distributed data issues.
- Ensure availability, performance, security, and operational efficiency.
- Ensure the recoverability of all production data for operational and business continuity needs
- Participate in Oracle ERP applications databases systems design and operations
- Manage and monitor SLAs for uptime and performance of the Oracle production environment.
- Perform root cause analysis, and resolution, for Oracle incidents
- Under limited supervision executes the responsibilities of the job and ensures that commitments and deliverables are met.
- Creates, develops, and reviews the physical data model created from the logical data model. Creates and implements the physical database design and structures.
- Actively participates in supporting test plans, test environments, benchmarks and statistics.
- Assist with the development of the technical architectures. Ensures the database management systems and tools support the defined architectures and business needs.
- Designs logical and physical databases or reviews description of changes to database design to understand how changes to be made affect physical database (how data is stored in terms of physical characteristics such as location, amount of space, and access method).
- Establishes physical database parameters.
- Calculates optimum values for database parameters.
- Specifies user access level for each segment of one or more data items such as insert, replace, retrieve, or delete data.
- Specifies which users can access databases and what data can be accessed by user.
- Confers with co-workers to determine impact of database changes on other systems and staff cost for making changes to database.
- Modifies database programs to increase processing performance, referred to as performance tuning.
SECONDARY DUTIES: - A completed task, not how that task is completed
- Responsibilities that are needed or desirable for better fulfilment of primary responsibilities
- Assist in the resolution of complex problems in support of production; including on call support.
- Perform core database management tasks including software installation, database creation and configuration, upgrades and patching, backup and recovery, space management, partition maintenance, and object reorganization.
- Communicates clearly, and effectively, with local and remote users.
- Manage and monitor SLAs for uptime and performance of Oracle Databases
- Documentation of, and adherence to, all critical processes
EDUCATION and/or EXPERIENCE: - Bachelor's degree (B. A.) from four-year college or university; or three to five years related experience and/or training; or equivalent combination of education and experience.
- Experience in Oracle R12 or higher
COMPETENCY/SKILL REQUIREMENTS: - Ability to work with limited supervision
- Ability to work remotely to resolve issues
- Ability to document and follow procedures
- Ability to be on Call 24x7 on a rotational basis
- Knowledge and understanding of Networking and Troubleshooting
SUPERVISORY RESPONSIBILITIES: - Mentoring of Teammates in similar responsibility.