Systems / Database Administrator

Systems / Database Administrator

Location TX - Fort Sam Houston Job Code 13591 # of openings 1

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.

Required Degree / Education / Certification :

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.

Preferred Degree / Education / Certification :

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

Required Skills And Experience :

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.

Required Citizenship And Clearance :

Must be U.S. Citizen.

Must have a SECRET clearance.

The Alaka`ina Foundation Family of Companies (FOCs) is a fast-growing government service provider. 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. We are an Equal Opportunity / Affirmative Action Employer of individuals with disabilities and veterans. We are proud to state that we do not illegally discriminate in employment decisions on the basis of any protected categories. If you are a person with a disability and you need an accommodation during the application process, please click here (recruiter@alakaina.com) to request accommodation. We E-Verify all employees.

The Alaka`ina Foundation Family of Companies (FOCs) is comprised of industry-recognized government service firms designated as Native Hawaiian Organization (NHO)-owned and 8(a) certified businesses. The Family of Companies (FOCs) includes Ke`aki Technologies, Laulima Government Solutions, K?pono Government Services, and Kapili Services, Po`okela Solutions, K?kaha Solutions, LLC, and Pololei Solutions, LLC. Alaka`ina Foundation activities principally benefit the youth of Hawaii through charitable efforts which includes providing innovative educational programs that combine leadership, science & technology, and environmental stewardship. For additional information, please visit www.alakainafoundation.com.