Estimated Duration: 12 months with possible extension

Description: Our Client, a government agency, is looking to hire an Oracle Architect in Tallahassee, FL.

Responsibilities:

• Database administration in a large Oracle UNIX-based production environment including assisting staff with the following:
   - All stages of database implementation and deployment;
   - Analysis, review, coordination and implementation of new database requests;
   - Monitoring, troubleshooting, and resolving database performance issues or related problem resolution;
• Provide direct support for Oracle databases as assigned by the Contract Manager;
• Ensure that the logical data model design adheres to the Department’s standards based upon best practices and guidelines;
• Coordinate and deploy application changes, including Procedural Language / Structured Query Language (PL/SQL) object and data model changes, to production databases following industry best practices and Department policies and procedures;
• Write Structured Query Language (SQL), PL/SQL, Oracle Stored Procedures, Functions, Packages and Database Triggers, as required, to augment security and performance requirements of application development;
• Write and use custom scripts and processes to handle data loads, data cleansing, and data migration to include migrations to and from multiple data sources and types such as Access, SQL Server, Excel, flat files, and different Oracle database versions;
• Run diagnostic tools to identify database performance issues and take appropriate corrective actions to improve database performance;
• Work with development teams to tune SQL queries;
• Ensure that the associated hardware resources allocated to the databases result in high availability and optimum performance as defined by the Department;
• Design, implement, and maintain database maintenance scripts, including replication and monitoring;
• Perform daily operational duties, including monitoring, statistical analysis, and troubleshooting of performance issues using appropriate and Department-approved tools and scripts;
• Design and maintain automated processes including DBA jobs, DBA scheduler, and CRON scripts Design and maintain automated processes including DBA jobs, DBA scheduler, and CRON scripts;
• Design processes / procedures related to Informatica seed mapping translations;
• Review existing Informatica mappings and build procedures for translating seed mappings into SQL;
• Provide other Informatica support as needed;
• Attend and participate in all assigned meetings and training.

Requirements:

• Experience in Oracle database administration;
• Experience with large and complex database management systems;
• Experience designing and constructing data architectures and data marts;
• Experience working in UNIX operating system;
• Ability to effectively diagnose, isolate, and resolve complex problems pertaining to data infrastructure;
• Experience writing SQL, PL/SQL, Oracle Stored Procedures, Functions, Packages and Database Triggers;
• Experience tuning Oracle SQL and PL/SQL performance;
• Experience in logical database design and data models;
• Experience monitoring and tuning a database to provide a high availability service;
• Experience with Informatica (preferred);
• Ability to work independently and to resolve complex Oracle issues;
• Understanding of the software development lifecycle process;
• Knowledge of data privacy and protection initiatives;
• Excellent verbal and written communication skills;
• Take charge, can-do attitude;
• Facilitation skills.

If this job is not for you, earn a $2,100.00 referral bonus in cash by referring a Candidate or a Client to us. Vitaver Referral Program is one of the most generous on the market!

Please feel free to apply directly and contact me with your questions at [email protected]