Database Administrator/Developer

Kapili Services, LLC; Terrell Hills (TX); On-site; USD 110,000 - 140,000; Full time

Benefits offered by this job

401K plan with company match

Medical insurance

Dental insurance

Disability insurance

Life insurance

Tuition reimbursement

Paid time off

11 paid holidays

Job summary

Bering-Alaka`ina Holdings, LLC is seeking a Database Developer/Administrator to support a government customer at Fort Sam Houston, San Antonio, TX. On-site work with possible telework on case-by-case basis.

Responsibilities include Oracle/UNIX/Linux database administration, security, backups, recovery, and data integration across multiple systems. Requires DoD-related certifications and a SECRET clearance eligibility.

Qualifications

• Five to seven plus years of DBA experience in Oracle/UNIX/Linux environments.
• Experience with Oracle 19c on Linux and related toolsets.
• Strong knowledge of database security, backups, and recovery.
• Experience with data mining queries using PL/SQL, Java, TOAD.

Responsibilities

• Provide database administration for Oracle/UNIX/Linux environments.
• Install, configure, and maintain Oracle and SQL Server in enterprise environments.
• Coordinate complex queries for research datasets using PL/SQL and TOAD.
• Support data mining, integration with COLLECTOR, JTTR, ICDB, IRDB.
• Ensure security patches, backups, recovery, and access control.

Skills

Oracle DBA

UNIX/Linux

MongoDB

PL/SQL

Java

TOAD

Oracle Discoverer

Education

Bachelor of Science in Computer Science or related field

Security+ certification

DoD 8140.03 / DoD Cyber Workforce compliance training

Oracle certification

Tools

Oracle RDBMS

Interbase

MySQL

MS SQL Server

TOAD

Portals

Oracle Discoverer

Job description

Bering-Alaka`ina Holdings, LLC is looking for a Database Developer/Administrator 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.
• Related to MongoDB, perform embedded document modeling for hierarchical datasets. Analyze query patterns, embedding and referencing aggregation pipelines for nested data.
• 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.
• Able to perform STIG Checklist - NISP
• 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.
• MongoDB skills and experience, particularly in embedded document modeling for hierarchical datasets. Must be able to analyze query patterns, embedding and referencing aggregation pipelines for nested data.

REQUIRED CITIZENSHIP AND CLEARANCE:

• Must be U.S. Citizen.
• Must have or be able to obtain a SECRET clearance.

Bering-Alaka`ina Holdings, LLC 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 not illegally discriminate in employment decisions on the basis of any protected categories. We E-Verify all employees.

As a part of BSNC, Bering- Alakaina Holdings gives hiring, promotion, training, and retention preference to BSNC shareholders, descendants and shareholder spouses who meet the minimum qualifications for the job. Qualified job candidates will generally be considered in the following order: BSNC shareholders, descendants, shareholder spouses, current employees, and outside candidates. The BSNC Shareholder Development department tracks and monitors the implementation of the Shareholder Hire Preference across its operations.

Bering-Alaka`ina Holdings, LLC is comprised of industry-recognized government service firms designated as Alaska Native Corporation (ACN)-owned and 8(a) certified businesses and includes Ke`aki Technologies, LLC; Laulima Government Solutions, LLC; Kpono Government Services, LLC; Kapili Services, LLC; Po`okela Solutions, LLC; Kkaha Solutions, LLC; and Pololei Solutions, LLC.

For additional information, please visit www.beringalakaina.com