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). The 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. Responsibilities 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 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 5+ years of experience as a 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 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. #J-18808-Ljbffr KAIHONUA LLC