Database Administrator III

Job Description

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)

Top 3-4 required skills for the position :

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.

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 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 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

Database Tuning and Maintenance to assure highest level

of system availability and performance

Ability to navigate and query relational database (Oracle) to

develop reports

Create database objects

Database design

Database links and multiple database instances

Database monitoring tools

Database security

Logical database design

Oracle; Knowledge of Oracle including stored procedures

and SQL Tuning

Oracle 12c

Oracle 19c

Oracle database security, synonyms, roles, privileges

Oracle data dictionary views

Oracle PL / SQL unit testing

Oracle SQL tuning

Microsoft SQL Server 2014, 2016, 2019

PL / SQL development

SQL SSIS

Informatica

Working knowledge of SQL Server T-SQL

Business Objects

Erwin Model Mart

Desired Experience

8 Years

8 Years

8 Years

4 Years

8 Years

5 Years

8 Years

3 Years

8 Years

4 Years

1 Year

8 Years

5 Years

5 Years

4 Years

2 Year

4 Years

1 Year

3 Year

2 Year

3 Year

3 Year

Requirements

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.