Job ID: TX-52909025 (911890107)
Oracle DBA with Normalization, SQL, PL/SQL, DML, DDL, DCL, tuning, indexing, Archival, Job Scheduler, Schema Compression, GoldenGate, Agile/Scrum, JIRA, RAC, SQL Server and No-SQL/MongoDB experience
Location: Austin TX (HHSC)
Duration: 21 months
Interview: In-person
Minimum Requirements:
Years Skills/Experience
10 Oracle DBA Experience
10 Oracle Relational DB Design and Normalization
10 SQL, PL/SQL, DML, DDL and DCL Experience
10 Performance tuning including indexing,
10 Oracle Archival, Job Scheduler, Schema Compression
5 Oracle GoldenGate
3 Agile Scrum Experience
Preferences:
Years Skills/Experience
2 JIRA
2 Oracle Stretch RAC Cluster Design
2 Microsoft SQL Server DB Design and Management
No-SQL (MongoDB or Similar) Experience
Job Description – Develop a Data Repository in Oracle and/or a No-SQL database such as MongoDB. Must have experience with Oracle GoldenGate. Must have experience creating a database repository from the ground up including install, configuration and delivery of required DML, DCL and DDL Must have experience performance tuning the datastore including setting proper indexes, partitions, constraints and triggers. Must have experience with Materialized Views, DB-Links, Schema Compression, PL/SQL and the Job Scheduler. Must have experience working in an Agile environment. Support the application in dev, test, uat and production and troubleshoot as required. Available for on-call support as needed. Other job duties as required.