Oracle DBA

14 Feb 2025

Vacancy expired!

One of our clients is looking

Database Administrator on the following skills:

Top Skills:
  • -Experience with supporting Oracle Data Warehouse database schemas including reverse and forward engineering the data structures.
  • -Experience creating and editing PLSQL statements in supporting an application development team.
  • -Experience with supporting application databases hosted on Exadata Oracle version 19c in a multitenant architecture.
  • -Experience writing and supporting Linux & Windows CMD Shell Scripts.

INTERVIEW NOTES:
  • Phone and web based interviews will be acceptable.
  • However, an inperson 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 CLIENT 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.)
This position is currently remote. (On site work is available if the candidate would like to be "on site".) However, position status is subject to change. Hybrid/On Site positions: Local candidates or willing to relocate at the candidate's expense. No designated work-space will be assigned however, selected candidate must be available to work at our location as needed. Location will be Madison, WI. Client does not pay for travel time or reimburse for travel expenses.

On Call hours required? Yes

Will the position require any weekend coverage? (IE: weekend maintenance) Yes there is on call off hours and weekend work.

Is this position Remote, Hybrid, or In Person? Remote (or if desired on site work is available)

Detailed Job Description:
  • CLIENT 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 CLIENT 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 PII 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 skillsCertified as an Oracle DBA is preferred – equivalent years of experience will be considered or .BS in computer science in the related field8 more years DBA work experience requiredRotating 24x7 on call will be required.

List any special qualifications & years of experience:

Qualification

ExperienceDatabase Tuning and Maintenance to assure highest level of system availability and performance8 YearsAbility to navigate and query relational database (Oracle) to develop reports8 YearsCreate database objects8 YearsDatabase design4 YearsDatabase links and multiple database instances8 YearsDatabase monitoring tools5 YearsDatabase security8 YearsLogical database design3 YearsOracle; Knowledge of Oracle including stored procedures and SQL Tuning8 YearsOracle 12c4 YearsOracle 19c1 YearOracle database security, synonyms, roles, privileges8 YearsOracle data dictionary views5 YearsOracle PL/SQL unit testing5 YearsOracle SQL tuning4 YearsMicrosoft SQL Server 2014, 2016, 20192 YearPL/SQL development4 YearsSQL SSIS1 YearInformatica3 YearWorking knowledge of SQL Server T-SQL2 YearBusiness Objects3 YearErwin Model Mart3 YearMicrosoft SQL Server Reporting Services1 Year

It is required to have full audio/video conferencing capabilities (camera and headset).
  • ALL candidates must be located within the United States. ALL contact information must also be domestic. Absolutely no work outside of the US is allowed.
  • 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.
  • CLIENT 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.
The successful candidate may have to undergo a drug test and background check. Sincerely,

SwatiDigitek Software, Inc.650 Radio DriveLewis Center, OH 43035Work: 6145263135Fax: 6147925840swati@digiteksoftware.comwww.digiteksoftware.com

  • ID: #49208962
  • State: Wisconsin Madison 53701 Madison USA
  • City: Madison
  • Salary: Depends on Experience
  • Job type: Contract
  • Showed: 2023-02-14
  • Deadline: 2023-04-14
  • Category: Et cetera