W2 - Database Administrator III (Supporting Oracle Data Warehouse database schemas, Linux, Windows CMD Shell Scripts) - Hybrid Job at Tanson Corp, Madison, WI

RTdhWUN3U0VKMm9VeVdMMHhvdTdmSGRtRFE9PQ==
  • Tanson Corp
  • Madison, WI

Job Description

Description:

WISCONSIN ONLY POSTING:
POSTING IS FOR WISCONSIN BASED CANDIDATES ONLY (OR THOSE WILLING TO RELOCATE TO WISCONSIN WITHIN 30 DAYS OF THE START DATE). Candidates that are NOT located IN WISCONSIN or NOT willing TO RELOCATE within that timeframe will NOT be considered and should not be submitted. ALL WORK MUST BE DONE IN WISCONSIN

NOTICE - Candidates that are submitted to this posting and do not meet the required qualifications, restrictions, or requirements will NOT be allowed to be resubmitted to future re-postings of the position. False or inaccurate submissions will be reported.


The client is looking for ONE (1) Database Administrator III

Will close to submissions on 2/13 at 4:00PM CST.

Top Skills:

  • Experience with supporting Oracle Data Warehouse database schemas including reverse and forward engineering the data structures. (8+ years)
  • Experience creating and editing PLSQL statements in supporting an application development team. (4+ years)
  • Experience with supporting application databases hosted on Exadata Oracle version 19c in a multitenant architecture. (1+ year)
  • Experience writing and supporting Linux & Windows CMD Shell Scripts. (4+ years)

INTERVIEW NOTES:
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 Wisconsin (or willing to relocate within 30 days of the start date .
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)
Candidate will be required to provide their own equipment for this position (See job description for required specifications.)

Duration : 6/30/2025, with the potential to extend for an additional term(s)

Hybrid/On Site positions: Candidate must be a WI resident or willing to relocate to WI prior to starting the role. This position is currently hybrid. (95% remote ~5% onsite) However, position status is subject to change. No designated work-space 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.

Project details:
As a member of Database Administrator team and part of modernization and upgrade projects, the selected candidate will play a pivotal role in designing, implementing, managing databases to ensure optimal performances & data integrity, security, and availability in accordance with the Department of Children and Family's security policies and business requirements. Work with, database administrators, architects, developers, WebApp support, Operations support, Business Intelligence Infrastructure, and analysts.

Soft skills needed: Contribute to a positive and productive work environment, problem solving abilities, effective communication skills and collaborative mindset. Adaptability and a proactive approach to learning and staying updated with the latest database technologies are also essentials.



Detailed Job Description:


DCF is looking for an experienced Database Administrator who has a passion for working with application and business intelligence developers. This person should have expert level knowledge of database structures and different schemas to support a variety of services and applications.
This DCF Database Administrator's primary responsibility will be for the Oracle administration and support of our existing Data Warehouse environment. The candidate will need to be well versed in the reverse and forward engineering of data structures. They will be required to write new PLSQL code as well as edit existing scripts. They will be tasked with creating scripts to automate core DBA functions and asked to perform numerous security functions.


The candidate will be responsible 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. A strong communication with different stakeholders both verbally and written are necessary for success.


The DBA will collaborate with development architects, developers, and analysts to implement and validate changes to database schemas and support the Software Development Life Cycles for numerous applications. The DBA must have experience with Oracle Database management tools such as TOAD, OEM, SQL Plus, Data Pump Import/Export, and SQL developer.


A variety of tasks are performed daily, including the database administration for SQL application databases and security assignments. Some knowledge of Microsoft SQL Server management tools such as Management Studio would be a plus in consideration for this position. This position does require a degree of creativity with some latitude provided to produce solutions where needed.


Experience with enterprise class applications with mission critical functionality which contain sensitive and or regulatory information such as IRS Pub 1075 and Pll is highly recommended.


Experience with meeting government regulations on security, data encryption as defined by the regulations is recommended. Candidates that have knowledge in the use of TOAD, Erwin Model Mart, and the Informatica Source and Target management are a plus in considering the candidate for placement.

Required skills, abilities, and certifications:

  • Enhanced level PLSQL development skills
  • Certified as an Oracle DBA is preferred - equivalent years of experience will be considered or .
  • BS in computer science in the related field
  • 8 more years DBA work experience required
  • Rotating 24x7 on call will be required.

List any special qualifications & years of experience:

Qualification

Desired Experience

Database Tuning and Maintenance to assure highest level of system availability and performance

8 Years

Ability to navigate and query relational database (Oracle) to develop reports

8 Years

Create database objects

8 Years

Database design

4 Years

Database links and multiple database instances

8 Years

Database monitoring tools

5 Years

Database security

8 Years

Logical database design

3 Years

Oracle; Knowledge of Oracle including stored procedures and SQL Tuning

8 Years

Oracle 12c

4 Years

Oracle 19c

1 Year

Oracle database security, synonyms, roles, privileges

8 Years

Oracle data dictionary views

5 Years

Oracle PL/SQL unit testing

5 Years

Oracle SQL tuning

4 Years

Microsoft SQL Server 2014, 2016, 2019

2 Year

PL/SQL development

4 Years

SQL SSIS

1 Year

Informatica

3 Year

Working knowledge of SQL Server T-SQL

2 Year

Business Objects

3 Year

Erwin Model Mart

3 Year

Microsoft SQL Server Reporting Services

1 Year

Pay range: $41 to $46 per hour on W2.

Job Tags

Hourly pay, Work experience placement, Remote job, Relocation,

Similar Jobs

The Shores Resort and Spa

Pool Attendant Job at The Shores Resort and Spa

 .... Overview: The cleanliness and enjoyment of a hotel/resort pool is one of the main reasons that keep our guests returning to and...  ..., great attention to detail to join our team as a Pool Attendant. The ideal candidate creates a memorable experience for our guests... 

Music Service

FT/PT Servers/ Bussers Job at Music Service

Job Description Looking for dependable customer service oriented servers and bussers for busy sports bar/restaurant in eastern Sioux Falls. Must be able to be on your feet for long periods of time, in a fast paced sportsbar environment. Hours vary from 10am to 10pm...

Harsco

CDL B Driver Job at Harsco

 ...strong working knowledge of Environmental/Regulatory/DOT rules and regulations. \ Demonstrates the ability to read a map. \ May require forklift driver certification and six or more months of relevant experience.\ Demonstrates excellent knowledge of various computer... 

Nothing Bundt Cakes

Baker Job at Nothing Bundt Cakes

 ...labeling and storage of baked cakes as well as product rotation standards, and maintains baking and refrigeration logs. Assists Bakery Manager in the development of cake production plan, monitors inventory of baking supplies and notifies management when supply replenishment... 

Aspire 2 Inspire Now Pty Ltd

Scrum Master Job at Aspire 2 Inspire Now Pty Ltd

 ...Work From Anywhere | Agile & Scrum Methodologies | Digital Strategy Are you a passionate Agile & Scrum expert eager to take...  ...cultures. Ideal Candidate: Experienced Agile Coach, Scrum Master, or Project Manager with expertise in Scrum, Kanban, Lean, or...