What are the responsibilities and job description for the Database Administrator III Need to Relocate position at Prospect Infosystem Inc.?
Database Administrator III
Location: Madison, WI
Need to Relocate
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)
Required Skills
Skill Type
Skill Name
Certification Education License Other Skill
Experience with supporting Oracle Data Warehouse database schemas including reverse and forward engineering the data structures. (8 years)
Certification Education License Other Skill
Experience creating and editing PLSQL statements in supporting an application development team. (4 years)
Certification Education License Other Skill
Experience with supporting application databases hosted on Exadata Oracle version 19c in a multitenant architecture. (1 year)
Certification Education License Other Skill
Experience writing and supporting Linux & Windows CMD Shell Scripts. (4 years)
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
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
