- Experience: 8+ years of Database Administration, with DoD IT system development expertise.
- Clearance Requirement: Secret (TS Preferred).
- Location: Govt Site in Annapolis, MD and/or Fort Meade, ME
- Advanced knowledge of DoD cybersecurity requirements, including DISA STIGs and RMF compliance.
- Proven ability to lead development teams, mentor engineers, and drive technical innovation.
Role Summary: (a) Have in-depth hands on experience with Oracle and SQL Server
(b) Demonstrated experience with database management systems design and system analysis, current operating systems software internals and data manipulation languages, incorporation of component and object-oriented concepts, building and/or maintaining data/information repositories for organizations that use information engineering concepts, and enterprise data and process modeling in the identification and development of standardized objects.
(c) Manages the development of database projects and provides all activities related to the administration of computerized databases
(d) Evaluates and analyzes functional business requirements, workflow, and existing processes and interfaces and applies business process improvement practices to re-engineer methodologies and practices consistent with sound DBMS principles and existing customer standards and planning documents
(e) Applies activity and data modeling, transaction flow analysis, internal control and risk analysis, and performance measurement techniques to develop functional specifications and logical and physical database designs
(f) Projects long-range requirements for database administration and design in conjunction with other managers in the information systems function
(g) Plans and budgets staff and data resources to support application developers in planning preparation, load analysis, and backup and recovery of data
(h) Prepares and delivers presentations on database management system concepts and applicable tradeoffs.
(i) Ensures that proposed object definitions are clear, concise, technically correct, and represent singular concepts.
Ensures that the proposed objects are consistent with data and process models
Contract-Specific Responsibilities: (a) Comfortable working in virtualized environments such as VMware vSphere, vCloud Director, and KVM
(b) Comfortable working in commercial cloud environments such as AWS commercial, GovCloud and IL6 regions, Azure Commercial and Government regions
(c) Experienced in database recovery operations for Oracle, Microsoft SQL, and MySQL Community Edition - activities such as patch roll-back, restore database from backup, etc.
(d) Knowledge of best practices for installing Oracle and Microsoft SQL databases to include use of tiered storage for optical performance of various data sets
(e) Experienced with database backup operations in virtual and commercial cloud environments as well as the use of VM/instance snapshots and database archives
(f) Experience with database security hardening and vendor-specific security best practices - knowledge of security settings per CIS Benchmarks and DISA STIGS - knowledge and experience with how these security configurations affect database operations and performance
(g) Experience with the setup, operation, stop/start, monitoring, maintenance, troubleshooting, and problem resolution of Oracle GoldenGate database replication software - how to recover from replication and synchronization failures and how to best configure the service for intermittent connectivity and low-bandwidth situations
(h) Experience with proper startup and shutdown sequence of databases and any add-on component services for Microsoft SQL and Oracle running on both Microsoft and Linux operating systems
(i) Experience with Microsoft SQL to Oracle two-way synchronization, to include initial setup, configuration, monitoring, and maintenance.
(j) Proficient in writing operation procedures, process tress, and workflows for junior DBAs to follow, and to document various system security posture artifacts
(k) Proficient in coordinating database operations with system administrators, software developers, engineers, and application end-users to schedule routine maintenance and recovery actions during authorized and emergency system outage windows
(l) Provide verbal and written description of recommendations for future actions needed and explanation of actions taken to inform peers, system leaders, stakeholders, decision-makers, and government customers
(m) Experience with maintaining, operating, and performing database management actions in VDI and remote desktop console environments such as SSH, RDP, VNC, VMware HorizonView, AWS SSM, etc.
(n) Comfortable communicating and collaborating with system developers to recommend data storage and retrieval best practices and recommendations to achieve optimal application performance
(o) Comfortable to perform database operations using command line interface when web service and desktop GUI methods are not available
(p) Knowledge of applicable IP ports and protocols required for network communication of Oracle and SQL Server components
(q) Experience with administering database user accounts such as configuring password complexity requirements, password resets, account recovery and expiration
(r) Experience configuring Oracle and Microsoft SQL service components for PKI authentication for machine-to-machine interface authentication and authorization operations - integration with Active Directory/LDAP, OpenID, OAuth2, SAML authentication mechanisms
(s) Experience configuring database security protocols, cryptography, FIPS 140-2, SSL/TLS for Oracle, Microsoft SQL Server and MySQL databases
(t) Knowledge of database synchronization, primary/backup replication failover and failback operations and the recovery of sync/replication failures for both Oracle and Microsoft SQL databases
(u) Assist application developers with recommendations for the use of specific database features or add-on components towards providing best performance for application end-users
(v) Proficient in performing major/minor version upgrades and patches while ensuring data integrity
(w) Assist the application development team in achieving overall system availability, scalability, resilency, and redundancy goals