What are the responsibilities and job description for the Senior Database Administrator position at Motion Recruitment?
Sr. Database Administrator
LOCATION : Aberdeen Proving Ground, MD
MODALITY : Hybrid, 2-days / week onsite.
SCOPE : Serves as a Senior Database Administrator for the Army Test and Evaluation Command (ATEC) and will build, administer, manage, upgrade and migrate, as necessary, database environments in Oracle and MS SQL technologies.
RESPONSIBILITIES :
- Perform enterprise database administration and system administration on all designated systems, including MS-SQL, My-SQL Database Management, Oracle, etc. This includes assigned enterprise network and test mission support systems.
- Manage the storage of data on storage devices and monitor usage of devices using various Government-approved software utilities.
- Use database management tools to ensure data integrity
- Implement measures to maintain and improve system performance
- Support the achievement of all pertinent Acceptable Quality Levels (e.g., issue notification timeliness)
- Support cybersecurity in the creation and maintenance all relevant required policies, procedures, diagrams, hardware / software listings, and all other necessary artifacts required to obtain and maintain ATOs.
- Support compliance activities for all relevant systems to include, but not limited to : Incident Response, Vulnerability Scanning / Audits, STIG compliance checking, Configuration Management, Host Based Security Solution / Endpoint Security Solution, Network Access Control, and POA&M creation
QUALIFICATIONS : Education :
o High School / GED AND ? 13 years - or-
o Associates in directly related field ? 11 years -or-
o Bachelors in directly related field ? 9 years - or -
o Masters in directly related field ? 7 years
o Education or certification must be in an IT discipline related to the assigned program area (e.g., Network Engineering, Network Management, Computer Science, Information Systems, Computer or Software Engineering, Management Information Systems, Computer Forensics / Security, etc.)
Baseline Certification :
o Must possess current Security (or equivalent DOD Directive 8570.1 IAT II)
o Oracle Database Administration Certified Professional or similar - AND / OR -
o Azure Database Administrator Associate or similar legacy certification
Skills and Experience :
o Experience management of Oracle databases including 11g and 12c
o Experience in Microsoft (MS) database technologies including Structured Query Language (SQL) AND Access
o Experience in performing in-place upgrades to include SQL DB migrations from one vendor solution to another (i.e., Oracle to MS SQL)
o Oracle expertise, including installing and configuring multi-node server-side load balancing RAC (Real Application Clusters) databases on Red Hat Linux, ASM on NETAPPS storage. Experience with planning, design, implementation, and support of large Oracle database environments. Experience setting up backup and recovery strategies, performance tuning, query optimization instances, and troubleshooting performance issues
o Microsoft expertise, including physical database architecture as well as design, database backup, recovery and disaster recovery procedures, installation, performance tuning, query optimization, client / server connectivity, database consistency checks using DBCC utilities, capacity planning, SQL clusters, SQL DR, HA options as well as contingency planning and log shipping
o General DBA expertise, including
o Designing database tables and dictionaries.
o Developing scripts, procedures, and triggers for application development.
o Developing, implementing, and optimizing stored procedures and functions using T-SQL.
o Maintaining data quality and backups and overseeing database security.
o Developing high-quality database solutions.
o Developing procedures and scripts for data migration.
o Reviewing and interpreting ongoing business report requirements.
o Understanding of relational and dimensional data modeling.
o Experience in Powershell / CMD scripting
o Azure Cloud Database Administration experience is a plus
SECURITY CLEARANCE : DoD Secret Clearance
LI-VG1
Posted by : Virginia Guenno
Specialization : Database Engineer
