Database Administrator

Role : Database Administrator

Rate : $70 / hr. C2C

Location : (Remote, candidate must reside in Texas)

Visa : USC / GC / EAD / H4 / TN

Client : HHSC

Duration : 12+ months

Must public sector (state client) exp. Min. 6 month

JOB DESCRIPTION / MINIMUM REQUIREMENTS :

This Database Administrator contractor position is part of the Administrative Applications Production Data Services team and will be working on the development and implementation of modifications and enhancements to the Financial Data Warehouse. This position will perform the duties of database development will perform advanced database development tasks for databases used by an application with complex data models, workflows, and reports. May be required to create new logical and physical data models. The role will involve working with Oracle databases . The candidate will optimize database performance during and after migration, identify and resolve performance bottlenecks, and implement monitoring solutions to track database health and performance metrics. This position will develop new views, tables and PL / SQL code to be used by the customer of the Financial Data Warehouse application. Will work on activities including, but not limited to the design, development, and testing of new tables, views, PL / SQL stored procedures and functions, and necessary loaders to support the project news. Will develop and test Linux shell scripts to invoke database calls. Will develop and test scheduled jobs and shell scripts. May perform performance tuning of new and existing tables, views, PL / SQL code. The role will involve working closely with the team to create and maintain logical and physical data models, with a primary focus on Oracle. This role will require knowledge of Oracle Stored Procedures and Functions.

Minimum Requirements :

Candidates that do not meet or exceed the minimum stated requirements (skills / experience) will be displayed to customers but may not be chosen for this opportunity. Years Required / Preferred Experience 6 Required Experience in Oracle database design, analysis, and performance tuning 6 Required Experience in Oracle database structures and data analysis 6 Required Experience designing enterprise applications and / or services 6 Required Experience creating technical and functional design documentation 6 Required Experience within software development lifecycle using Agile methodology - (Scrum, for example) 6 Required Experience with multi-tier system / application development - (SOA, Microservices, 3-Tier applications, for example)