Systems / Database Administrator

Alaka `Ina • San Antonio, TX

2d • Onsite

About The Position

The Alaka`ina Foundation Family of Companies (FOCs) is looking for a Systems Administrator/Data Base Administration Support to provide support for our government customer in San Antonio, Texas at Fort Sam Houston . (Work conducted onsite, telework may be available on case-by-case basis.) DESCRIPTION OF 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.

Requirements

• 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.
• Willing to work some non-daytime hours to run queries and updates during periods of decreased usage of DoDTR.
• Must be U.S. Citizen.
• Must have a SECRET clearance

Nice To Haves

• ORACLE or higher certification OR proof of formal education in ORACLE or higher, and Oracle SQL certification

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.

Benefits

• Employees enjoy competitive salaries.
• Eligible employees enjoy a 401K plan with company match; medical, dental, disability, and life insurance coverage; tuition reimbursement; paid time off; and 11 paid holidays.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level