Oracle Data warehouse

Top 3-4 desired skills required for the position:Experience with Oracle Data Warehouse environments.Experience writing PLSQL in supporting an application development team.Experience with Oracle 12.2 and higher with multitenant architecture experience.Experience writing Linux Shell Scripting.

Detailed Job Description:DCF is looking for a Database Architect who excels in the database application support for data warehouses. This DCF Database Architect’s primary responsibility will be for the Oracle administration and support of our existing Data Warehouse and OLTP environments for our diverse application development sections. 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 OEM, SQL Plus, and SQL developer.This role requires interaction with a cross-functional team. These teams may be comprised of people from other State Departments with various levels of Oracle knowledge and experience. The teams may include Technical Administrators or business professionals from program areas, infrastructure, application development, or 3rd party Vendors. 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. Varieties 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 may be needed. 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. Recommended skills, abilities, and certifications:PLSQL development skillsCertified as an Oracle DBA is preferred.BS in computer science or related engineering field(preferred) 8 more years DBA work experience (preferred)Rotating 24x7 on call will be required.

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

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.

Please note the qualifications for this position per the contract:Designs and builds relational databases. Develops strategies for data acquisitions, archive recovery, and implementation of a database. Cleans and maintains the database by removing and deleting old data. Must be able to design, develop and manipulate database management systems, data warehouses and multidimensional databases. Requires a depth and breadth of database knowledge that will help with formal design of relational databases and provides insight into strategic data manipulation.Database Architect capabilities with 6 years of experience, independently designs and builds relational databases. Develops strategies for data acquisitions, archive recovery, and implementation of a database. Cleans and maintains the database by removing and deleting old data. Familiar with a variety of the field's concepts, practices, and procedures. Relies on extensive experience and judgment to plan and accomplish goals. Performs a variety of tasks. A wide degree of creativity and latitude is expected.