or email this job to apply later

The State of Wisconsin is looking for ONE (1) Database Architect- V

The Database Administrator will focus on database design and the ongoing support in the administration of Oracle and SQL databases for DCF development work for Agency programs and COTS software. The DBA will be required to lead initiatives regarding upgrades or project work for Oracle and SQL environments. The DBA should be an expert at Oracle Database management and must be able to design, develop and manipulate OLTP and OLAP databases running in a multitenant Oracle Exadata platform. The candidate will have support responsibilities for SQL databases and should have knowledge of SQL functions and tools.

This role requires interaction with a cross-functional team of technology and business professionals including infrastructure, application development, business partners, and 3rd party subject matter experts to ensure that solutions are planned, developed, deployed, and maintained in accordance with the Department of Children and Family's security, policies, and business requirements.

Experience required for tasks and responsibilities:

The ability to maintain a collaborative team and assist with managing high priority operational work and setting expectations for projects and initiatives for the Bureau.

This role will work with partners and stakeholders to maintain a stable database platform and requires expert knowledge and experience with Oracle 19c multitenant environments on Exadata.

Expert level knowledge and experience in the use Oracle Management tools like OEM, SQL Developer, PLSQL scripting, Erwin model mart.

Expert level knowledge and experience in data migrations for Oracle and SQL platforms.

Knowledge and understanding of SQL Server 2016 and higher including a familiarity and knowledge of SQL tools and functions like SSRS and SSIS is a plus.

The candidate will analyze and model data requirements, application and processing architectures, data dictionaries, and database schema(s), and then design, develop, amend, optimize, and certify database schema design to meet system(s) requirements.

Understand Oracle Star Schema and understand Oracle data Warehouse environments. And can implement and maintain the database designs, Create database objects (tables, indexes, etc.)

The applicant must be capable of creating Shell scripts and packages, provide recommendations for performance monitoring and tuning, understand the complexities with change management in Software Development Life Cycles, and should understand the overall DBMS implementation and knowledge that will help with formal design of new and existing databases.

The applicant should be familiar with a variety of the field's concepts, practices, and procedures and provide insight into strategic data manipulation.

Develop database level monitoring for application related issues and tune database queries to find efficiencies.

Proactively diagnose and work with application developers to resolve application SQL or Oracle performance issues using available tools.

Additional recommended knowledge, abilities, or certifications that a preferred candidate will have:

A working knowledge of data management tools including Erwin Model Mart, Business Objects, Informatica, and TOAD.
Having experience with applications used by the state of Wisconsin, such as eWiSACWIS, KIDS, and CARES is beneficial.
15+ or more years DBA work experience (required)
BS in computer science or related engineering field (preferred)
Rotating 24x7 on call will be required.

Top Desired Skills Required:

10+ years of Oracle DBA experience working with application development teams with current experience in a multitenant environment running Oracle 19c.
Expert level of knowledge and experience in data modeling and processing architectures, data dictionaries, and database schema(s), including design, develop, amend, optimize, and certify database schema design to meet system(s) requirements.
Expert level experience in creating and modifying Shell scripts and packages, for performance monitoring and tuning.
Experience with enterprise class applications with mission critical functionality which contain sensitive and or regulatory information such as IRS Pub 1075 and PII is highly recommended.

Interview Process:

Phone and web-based interviews will be acceptable.
However, an in--person interview may be required.
Interviews will be set up shortly after the posting close date.
MUST provide three (3) business references for the interview. (One reference must be a supervisory level.)

Important Notes:

Candidate MUST be physically located in the United States. International candidates/phone numbers will not be accepted.
Candidate must follow ALL DCF work rules
Candidate must be available to perform all work during the Central Standard Time (CST) business hours 9:00 am 3 pm (or CST hours as defined by the hiring manager

Duration:

06/30/2024, with the potential to extend for an additional term(s)

Remote, Hybrid, or In Person?

Local candidates or willing to relocate at the candidate's expense. No designated workspace will be assigned however, selected candidate must be available to work at our location as needed. DCF work location is 201 W. Washington Ave., Madison, WI 53703. DCF does not pay for travel time or reimburse for travel expenses.

Will this position have access to FTI (Federal Tax Information)?

On Call Hours Required?

Yes-3000 for full Fiscal Year
Rotating 24x7 on call will be required.

THE SELECTED CANDIDATE WILL BE REQUIRED TO PROVIDE THEIR OWN EQUIPMENT FOR THIS POSITION.

Other Notes to Suppliers

Selected candidate will be required to provide personal equipment for remote work.

Technical specifications of hardware are:

Home Internet Service: Minimum 20 Mbit down and 5 Mbit up. Capability to plug in

network (cat 5a or better) cable to the computer.

Windows Computers

Operating System: Windows 10
Memory: Minimum 4 GB, Preferred 8 GB+
Processor (CPU): Any 32-bit or 64-bit running 2 Gigahertz (GHz) or faster
Graphics card that supports Direct3D 11 Video
Installation of the latest VMware Horizon Client

Apple Computers

Operating System: MacOS: 10.14, 10.15, or 11
Memory: Minimum 4GB, preferred 8 GB+
Processor (CPU): Any 64-bit Intel-based Mac or ARM M1-based Mac running

in emulation with Rosetta 2

Installation of the latest VMware Horizon Client

It is required to have full audio/video conferencing capabilities (camera and headset).

Selected candidate will not be assigned specific workspace, however, may be required to report in person as needed with minimal notice.
An in-person interview may be required before a final hire is made. The hiring manager has discretion to allow phone or video interviews at any point during the process.
Please provide three (3) business references for the interview.
The selected candidate will be required to sign all onboarding documents as part of the onboarding process. Candidate will also be required to complete any security training as directed by the division, department, or agency.
The selected candidate will be required to complete a criminal background check and any fingerprinting as required by the position.
This position is budgeted for 1960 hours annually. Hours will be prorated the first year based on start date.
DCF does not sponsor work visas, either at the time of hire or at any later date
Suppliers must disclose any/all levels of sub-contracting and their respective supplier's name(s).
Selected candidate must provide copies of any/all certifications as part of the hiring process.

Qualifications

RICEFW Technologies Inc

Apply Online

or email this job to apply later

Report this job