Oracle Database Administrator 1.19 at Focused HR Solutions Madison, WI

Focused HR Solutions; Madison (WI); Hybrid; USD 100,000 - 130,000; Full time

Job summary

Focused HR Solutions is seeking an Oracle Database Administrator for a hybrid position in Madison, WI. This role involves database security administration, design, and maintenance within the Oracle 12.x and 18.x environments. The ideal candidate will have prior experience as an Oracle Application DBA and strong skills in SQL Developer and PL/SQL. The position requires two days onsite per week and offers a contract duration of 12+ months, with an option for extension. Excellent communication and analytical skills are a plus.

Qualifications

• Prior experience as an Oracle Application DBA.
• Technically competent, a high producer, and team player.

Responsibilities

• Database security administration, research, implementation, maintenance, tuning, and troubleshooting.
• Work with application development staff on logical database design.
• Design and implement physical databases including multi-agency OLTP and data warehouse.
• Collaborate on the design and installation of maintenance and upgrades to database software.
• Monitor performance and make tuning recommendations.
• Estimate database growth for capacity planning; determine and resolve problems.

Skills

Oracle 12.x & 18.x OLTP/Warehouse databases

Oracle Enterprise Manager (OEM) 13

SQLNavigator

SQL Developer

PL/SQL

ERWin

Business Objects

Informatica PowerCenter

Excellent oral & written communication

Analytical/problem-solving skills

Job description

Oracle Database Administrator (1.19) – Madison, WI

Hybrid schedule: 2 days onsite per week in Madison, WI. Candidates must relocate if not local and be located in Madison, WI from day one.

Duration: 12+ months with option of extension.

Desired Skills

• Oracle 12.x & 18.x OLTP/Warehouse databases
• Oracle Enterprise Manager (OEM) 13
• SQLNavigator
• SQL Developer, PL/SQL, ERWin
• Business Objects, Informatica PowerCenter (optional)

Nice to have

• Excellent oral & written communication
• Analytical/problem-solving skills

Project Description

Advanced Oracle Application Database Administrator. Best-qualified candidates will have strong Oracle application, OEM, and Erwin experience using Oracle 12.x to 18.x environments.

This position provides advanced-level technical expertise and support within the Technical Services Section for DWD's Oracle database environment.

Responsibilities

• Database security administration, research, implementation, maintenance, tuning, and troubleshooting of database architectures and data management software for various platforms.
• Work with application development staff on logical database design.
• Design and implement physical databases including multi-agency OLTP and data warehouse.
• Collaborate on the design and installation of maintenance and upgrades to database software.
• Monitor performance and make tuning recommendations.
• Estimate database growth for capacity planning; determine and resolve problems.

Hardware/Software Environment

• Oracle 12.x & 18.x OLTP/Warehouse databases.
• Oracle Enterprise Manager (OEM) 13.
• SQLNavigator.
• SQL Developer.
• PL/SQL.
• ERWin.
• Business Objects.
• Informatica PowerCenter.

Qualifications

Qualified candidates must have prior experience as an Oracle Application DBA and be technically competent, a high producer, and team player.