Apply on Employer Site

Alaka`ina Foundation Family of Companies · 2 weeks ago

Oracle Database Developer/Administrator

Houston, TX

Full-time

Onsite

Senior Level

5+ years exp

The Alaka`ina Foundation Family of Companies is looking for an Oracle Database Developer/Administrator to support their government customer in San Antonio, Texas. The role involves providing database and computer administrator support, maintaining database information security and integrity, and developing database applications for clinical and research requirements.

CharityCommunitiesGovernment

No H1B

Security Clearance Required

U.S. Citizen Only

Responsibilities

Provide database and computer administrator support of JTS databases and associated database interfaces capabilities, to include installing and maintaining all network connectivity clients for workstations requiring Oracle or other database access

Provide technical database support for a multitude of database and operating environments to include, but not limited to: Oracle RDBMS, Application Server, Portals, and Oracle InterMedia; Interbase; MYSQL, Microsoft SQL Server, and TOAD

Maintains database information security and integrity, including applying security patches, verifying, and managing storage, maintaining database accounts, and performing database backups and recovery in case of problems

Resolve Oracle database performance issues, database capacity issues, replication, and other distributed data issues. Develop performance tuning techniques to ensure the Oracle Database Server operates efficiently and accurately

Design new database tables, procedures, and techniques to ensure database grows in a scalable manner

Install and configure Oracle and SQL Server in hosted and enterprise environments

Coordinate complex queries with the researchers and data extractors/miners utilizing PL/SQL, Java, TOAD, Oracle Discoverer, and other query tools to provide complex datasets for research analysis

Develop database applications in concert with the database processing needs for clinical and research requirements utilizing complex query and other programming toolsets

Support data mining and integration requirements with a number of COTS and in-house developed systems including COLLECTOR, DoDTR, JTTR, ICDB, and IRDB, as well as legacy applications such as Mercury and Pre-Hospital Trauma Registry

Run multiple monitors and systems to check their accuracy and workability, as well as troubleshoot any errors found

Manage backup and recovery routines

Trouble shoot individual patient database records and recover data as needed

Add validated new users, delete departed users, and ensure all users have current HIPAA and Cyber Awareness training documentation (Deliverable 11) on file. Assist with password resets as needed

Other duties as assigned by Supervisor

Qualification

Oracle DatabasePL/SQLDatabase SecuritySQL ServerLinuxDatabase DesignJavaTOADVisual BasicOracle DiscovererMySQL

Required

A Bachelor of Science Degree in Computer Science (or related degree) or equivalent work-related experience

Security+ certification

Maintain the certification as required by DoWM 8140.03, DoD Cyber Workforce Framework, and comply with all applicable DHA training regulations while working on a DHA server

Five to seven plus (5-7+) successful years of experience as a DBA in an Oracle/UNIX/LINUX environment

Oracle 19c (or latest version) in a LINUX environment, the Oracle 19c tool sets, Visual Basic, Microsoft SQL, SQL Loader, SQL Query, Oracle Discoverer, Portals, and Oracle InterMedia; Interbase; and MYSQL (or the latest version of these)

Database organization and design, table structures and data schema, logical and physical design, reports and forms development, naming conventions and other issues related to systems planning and data migration

Database information security and integrity, including applying security patches, verifying, and managing storage, maintaining database accounts, and performing database backups and recovery in case of problems

Complex queries for database structures in the research/medical community and data extractors/miners utilizing PL/SQL, Java, TOAD, and other query tools to provide complex datasets for medical/clinical research analysis

Must be U.S. Citizen

Must have a SECRET clearance