Job description

ROLE DESCRIPTION: • Data dictionary analysis and design and data model analysis design • Central data repository • Data dictionary backup and recovery as well as environment refreshes • Definition of standards of data dictionaries • Program dictionary analysis and maintenance software • Performance tuning • Database performance and space requirements • Business systems analysis and design experience • Logical data modeling techniques • Production environment tools / utilities • Knowledgeable in data analysis and database management techniques • Execution of all responsibilities with little direct supervision of Team Lead • Administration and scripting experience in relevant platform • Highly skilled at database design, installation conversions • Responsible for database backup and recovery procedures, access security and database integrity, physical data storage design and data storage management. • Participates in Database Management System selection and maintains database performance • May supervise other contractors. • Providing On Call support as needed. Specific Skills Required (Programming languages, databases, operating systems, etc.) • Experience administering Oracle Real Application Clusters • Experience laying out ASM storage • Experience using a combination of OEM, ASH and AWR reports to troubleshoot performance • Good understanding of Oracle DataGuard • Experience using various methods to tune SQL statements • Good understanding of Oracle's Exadata product • Good understanding of Oracle's GoldenGate product • What we are looking for is a strong technical contributor who can quickly come up to speed on our existing system functionality, application infrastructure, both from a hardware and software perspective. • The candidate filling this position must able to work in a fast-paced, agile environment. • Working knowledge of a modern welfare eligibility case management system and preferably hands-on experience with Idaho's Medicaid Eligibility automation. • Experience working with government agencies would be advantageous, but is not required. • Education: 4 year degree or equivalent technical study. • Experience: 6+ years • Good comm skills are a big priority • Duration: 6+ Months

Requirements

Must-haves

ROLE DESCRIPTION: • Data dictionary analysis and design and data model analysis design
Central data repository
Data dictionary backup and recovery as well as environment refreshes
Definition of standards of data dictionaries
Program dictionary analysis and maintenance software
Performance tuning
Database performance and space requirements
Business systems analysis and design experience
Logical data modeling techniques
Production environment tools / utilities
Knowledgeable in data analysis and database management techniques
Execution of all responsibilities with little direct supervision of Team Lead
Administration and scripting experience in relevant platform
Highly skilled at database design, installation conversions
Responsible for database backup and recovery procedures, access security and database integrity, physical data storage design and data storage management.
Participates in Database Management System selection and maintains database performance
May supervise other contractors.
Providing On Call support as needed.
Specific Skills Required (Programming languages, databases, operating systems, etc.)
Experience administering Oracle Real Application Clusters
Experience laying out ASM storage
Experience using a combination of OEM, ASH and AWR reports to troubleshoot performance
Good understanding of Oracle DataGuard
Experience using various methods to tune SQL statements

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlagile

Platform: smartrecruiters
Effort: medium

Benefits

Benefits detected in the listing.

Vision