Database Specialist
Database Specialist
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Job description
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 indepth 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 objectoriented 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 reengineer 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 longrange 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
ContractSpecific 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 rollback 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 vendorspecific 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 lowbandwidth situations
(h) Experience with proper startup and shutdown sequence of databases and any addon component services for Microsoft SQL and Oracle running on both Microsoft and Linux operating systems
(i) Experience with Microsoft SQL to Oracle twoway 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 endusers 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 decisionmakers 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 machinetomachine interface authentication and authorization operations integration with Active Directory/LDAP OpenID OAuth2 SAML authentication mechanisms
(s) Experience configuring database security protocols cryptography FIPS 1402 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 addon components towards providing best performance for application endusers
(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
All done!
Your application has been successfully submitted!
Required Experience:
Unclear Seniority
Employment Type
Full-Time
