Job ID: NC-580743 (97090802)
Curam Oracle DBA with PL/SQL, Unix/Linux, shell scripting, SharePoint, SQL replication and monitoring/tuning/backup/restore experience
Location: Raleigh NC (DHHS)
Duration: 12+ months
Interview Type: In Person
SkillRequired / DesiredAmountof Experience
Demonstrable skills with Cúram Software and database schemaRequired7Years
Demonstrable skills with Oracle or DB2 database softwareRequired7Years
Experience configuring, monitoring, tuning, and performing backup and restore for Oracle database serversRequired7Years
Experience authoring code in SQL, PL/SQL and Unix/LinuxRequired7Years
Proficiency in one or more shell scripting languagesRequired7Years
Experience in a Cúram software development environment in a Cúram DBA roleRequired7Years
Ability to work cooperatively in a team environment to establish and maintain effective working relationshipsRequired
Experience planning and coordinating the work of othersRequired7Years
Experience with advanced security and SQL replicationRequired7Years
Oracle 11g and SharePoint knowledgeHighly desired3Years
Description:
The Department of Health and Human Services (DHHS) requires an Applications DBA on the Oracle Database Platform to support the development and implementation of North Carolina Families Accessing Services through Technology (NC FAST).
Primary responsibilities include:
• Managing the Cúram application schema, design, and extensions within the database, in development, test and production environments
• Providing database technical support, tuning, and application administration and consulting.
• Providing support for Oracle, Oracle Dataguard, and Oracle Enterprise suite in an AIX environment
• Serving in a primary role in the creation of database migration plans
• Involvement in the development of procedures for effective database use and ensuring standards are met.
Other duties will include:
• Working with developers to identify and refine data requirements, database design, database migration planning, and configuration.
• Performing backup and recovery, monitoring database performance, and reorganizing database structures as needed.
• Creation and modification of test and production data, base schemas