Applications Database Administrator

Overview

Mano Lani LLC is looking for an enthusiastic, well-qualified individual to fill the Application Database Administrator (DBA) position. This role offers the opportunity to work with a diverse and talented group of individuals committed to driving success. Mano Lani is an exceptional industry partner to the Department of Defense (DoD) and a leader in physical and cyber security, IT management, logistics, supply chain management, process improvement and development.

The Applications Database Administrator provides comprehensive database administration support for the DTMO Enterprise Infrastructure operating environments, including Oracle (version 19c or higher) and Microsoft SQL (version 2014 or higher). This position is responsible for developing technical specifications, designing, developing, modifying, testing, and managing databases within DTMO's multi-tier architecture. The Applications Database Administrator monitors and optimizes database performance, tunes database operations, and ensures data processing and monitoring is performed during core business hours (0600 to 2200 Eastern Time, Monday through Friday) and on an on-call basis for mission-critical incidents at all other times. The position supports database tools such as Structured Query Language Server Integration Services (SSIS), database clustering, database mirroring, and replication. The Applications Database Administrator coordinates with DMDC to analyze and recommend data security standards, perform analyses on

scalability of data storage, and support Data Backup and Disaster Recovery activities including Information System Contingency Plans (ISCP) and Business Impact Analyses (BIA). This position also supports annual Continuity of Operations (COOP) exercises to ensure availability of the DTMO Passport website.

Essential Duties and Responsibilities: (Not listed in order of importance; other duties may be assigned) and must be able to perform the following with minimal guidance or supervision:

Provide database administration support for Oracle (version 19c or higher) and Microsoft SQL (version 2014 or higher) environments

Develop technical specifications, design, develop, modify, test, and manage databases in DTMO's multi-tier architecture

Monitor and optimize database performance and tune database operations

Ensure data processing and monitoring is performed during core hours (0600 to 2200 Eastern Time, Monday through Friday) and on an on-call basis for mission-critical incidents at all other times

Maintain and fine-tune databases through utilities and software packages aimed at monitoring the state of the database

Support database tools such as Structured Query Language Server Integration Services (SSIS) or any other tools DTMO may procure

Support database clustering, database mirroring, and replication

Execute application implementation and upgrades of DTMO Enterprise systems

Support data purging activities according to appropriate DoW policy and DTMO guidelines

Conduct semi-annual SOP reviews

Test and validate backups coordinating with DMDC once a quarter and document in the Monthly Status Report

Facilitate connections to external data sources so that data can be ingested into DTMO databases

Perform SQL tuning and re-write code as necessary

Setup and maintain documentation and standards

Administer (create/update/delete/reorganize) all database objects (tables/views/indexes/sequences/clusters/packages/procedures/triggers)

Perform data scrubs and refresh data in requested regions

Plan and implement data security (database object access and management)

Enforce database constraints to ensure integrity of the DTMO databases

Coordinate with DMDC to analyze and recommend data security standards and maintain storage data security

Coordinate with DMDC to perform analyses on scalability of data storage

Monitor current disk usage statistics and storage capacity

Coordinate with DMDC to support Data Backup and Disaster Recovery reports including Information System Contingency Plan (ISCP) and system-focused Business Impact Analysis (BIA) for each IT services supported system

Coordinate with DMDC to support annual Continuity of Operations (COOP) exercises to ensure availability of DTMO Passport website

Responsibilities

Qualifications: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill and ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Education:

Required

Bachelor's degree in Computer Science, Information Technology, Information Systems, or a related field.(Oracle 19c or above certification AND Microsoft Certified Solutions Associate (MCSA) SQL Server Administrator certification in lieu of Bachelor's degree)

Relevant experience in database administration may substitute for formal education in some cases

Preferred

Oracle 19c or above certification

Microsoft Certified Solutions Associate (MCSA) SQL Server Administrator certification

CompTIA Security+

ITIL Foundation Certification

Experience / Certifications:

5+ years of experience of Database Administrator

Experience administering enterprise database systems in government or enterprise environments

Experience with Oracle Enterprise Database

Experience with Microsoft Structured Query Language (SQL)

Experience with Structured Query Language Server Integration Services (SSIS)

Experience with database clustering, mirroring, and replication

Experience with SaaS, PaaS, and cloud platforms

Experience with database performance tuning, query optimization, and capacity planning

Familiarity with backup and recovery processes, high availability configurations, and disaster recovery planning

Experience implementing database security controls and access management

Knowledge of database integration with enterprise applications and system architectures

Experience supporting change management, patch management, and system upgrades

Ability to troubleshoot complex database issues and support system availability

Strong analytical, organizational, and problem-solving skills

Ability to work collaboratively with application developers, system administrators, and cybersecurity teams

Strong written and verbal communication skills

Please note: Mano Lani LLC reserves the right to change or modify job duties and assignments at any time. The above job description is not all encompassing. Positions functions and qualifications may vary depending on business needs.

Mano Lani LLC is an equal opportunity employer and does not discriminate against applicants based on race, color, creed, religion, medical condition, legally protected genetic information, national origin, sex (including pregnancy, childbirth or related medical condition), sexual orientation, gender identity and expression, age, disability, or Vietnam era, or other eligible veteran status or legally protected characteristics.

Posted Salary Range

USD $120,000.00 - USD $145,000.00 /Yr.