Database Administrator

• Design, implement, and sustain EIM application workflow databases
• Ensure database performance, reporting capability, availability, and security
• Provide database administration, SQL programming, database structure and schema design, table configuration, problem solving, and database communications
• Perform routine and preventive database maintenance during planned downtime
• Conduct performance tuning, index rebuilds, and data and log cleanup
• Lead large data migrations and ETL efforts, including HAIMS, DMACS Archive, and STR records migrations
• Consolidate structured and unstructured data and metadata into shared SQL Server and Content Server instances
• Maintain metadata values according to MHS data standards and map legacy values to new values
• Sustain and update reporting databases and tools, including BOXi and OpenText Web Reports
• Support timely and accurate canned and ad hoc reporting
• Apply database IAVA patches and STIGs
• Support backup, failover, and continuity of operations testing
• Maintain data dictionaries and data models for each release
• Support the DHA CBIS Program Management Office and modernization of the DHA EIM platform hosted in AWS GovCloud

Senior Database Architect

• Configure and administer managed PostgreSQL instances in the AWS environment
• Maintain database security policies, including role-based access control and data encryption
• Analyze and optimize SQL queries, particularly on large tables
• Work with development teams to review and enhance database-related code
• Set up and monitor Dynatrace alerts to ensure database reliability and availability
• Investigate and resolve performance issues identified through monitoring tools or reported by users
• Develop and implement database automation scripts for deployments, scaling, and maintenance
• Assist in CI/CD processes for database updates
• Proactively monitor database health and resolve capacity or connectivity issues
• Conduct root-cause analysis for database incidents and implement preventive measures
• Provide input on data modeling and schema design
• Collaborate with developers and data engineers to ensure efficient data access patterns
• Create and maintain documentation of database environments, procedures, and standards
• Enforce database best practices and policies
• Mentor junior team members
• Train application developers and other stakeholders on database-related topics

PostgreSQL Database Administrator

• Administer, maintain, and support Oracle ERP databases
• Ensure database security, integrity, availability, and performance
• Support Oracle 19c and Oracle 26ai database environments
• Support Oracle databases hosted in OCI and on-premises environments
• Perform and support Oracle database migrations to OCI
• Support Oracle RAC and ASM environments on Linux
• Manage and troubleshoot Data Guard Physical Standby environments
• Perform RMAN backup and recovery operations
• Use Oracle Data Pump export and import utilities
• Support Oracle Enterprise Manager and database monitoring activities
• Perform database performance tuning and capacity management
• Support database security, patching, maintenance, and upgrades
• Troubleshoot replication and distributed database issues
• Develop and maintain database documentation, procedures, and technical standards
• Troubleshoot complex database issues and provide timely resolutions
• Communicate technical information clearly with technical teams, management, and stakeholders
• Support Linux/Unix database administration activities as needed
• Implement database models and designs
• Support data access and table maintenance
• Work under general supervision using extensive experience and judgment to plan and accomplish database administration goals

Database Administrator 4

• Support and maintain multiple Oracle RAC clusters, RDBMS, EBS, and FMW environment instances for the GCSS-MC ERP
• Support the Solutions Development Environment (SDE)
• Ensure the environment is documented, patched, secured, and available
• Provide database administration in a large, dynamic, highly available Oracle EBS/ERP environment
• Improve Marine Corps combat effectiveness by supporting business information systems for asset visibility, supply, maintenance, readiness, task organization, repairs, request tracking, and financial information

Application Database Administrator

• Administer, maintain, develop, and implement policies and procedures to ensure the security and integrity of the company’s ERP database
• Implement data models and database designs, data access, and table maintenance code
• Resolve ERP database performance, capacity, replication, and other distributed data issues
• Support Oracle databases in OCI and on premise
• Migrate Oracle databases, including COV Agency Oracle databases, to OCI
• Perform RMAN backup and recovery
• Use Data Pump export and import utilities and Oracle Enterprise Manager
• Perform performance tuning, security, patching, and documentation
• Work under general supervision and typically report to a manager