Senior System Administrator/SQL Server DBA

Caelum Research Corporation
Aberdeen Proving Ground, United States of America
14 days ago

Role details

Contract type
Contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Aberdeen Proving Ground, United States of America

Tech stack

Active Directory Federation Services
Azure
Backup Devices
Information Systems
Databases
Computer Forensics
Data Integrity
Data Loss
Database Design
Database Development
Database Servers
Database Storage Structures
PostgreSQL
MariaDB
Microsoft SQL Server
SQL Azure
Network administration
Open Source Technology
SharePoint
Software Engineering
SQL Databases
Sql Server Database Administration
Database Performance
Information Technology

Job description

SCOPE: Serves as a Senior Systems Administrator with technical expertise in SQL Server Database Administration and implementation for the US Army Test and Evaluation Command (ATEC) Information Systems Directorate (G6). Responsible for assessing, evaluating, installing, managing, maintaining, and securing databases to ensure optimal performance and data integrity, within a defined physical, virtual and/or Azure cloud environment., * Oversee the technical assessment, evaluation, installation, configuration, and upgrading of database servers/instances and applications dependent on database services, such as SharePoint and ADFS. Ensure databases are functional, efficient and secure.

  • Implement robust security measures (both STIG and best practices) to protect databases from unauthorized access and threats.
  • Develop and manage backup procedures to safeguard against data loss, above and beyond enterprise backup implementation.
  • Continuously monitor database performance and optimize operations by tuning SQL queries, adjusting indexes, and configuring virtual or cloud hardware resources.
  • Manage required local users of databases and maintain system security by controlling database access.
  • Collaborate with developers and data analysts to design databases that support applications and ATEC reporting requirements.
  • Generate various reports by querying the database as per organizational needs.

Requirements

  • Master's Degree in a directly related field and at least 5 years' experience; Lower-level degrees in relevant fields will be considered with additional experience.
  • 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 Security Certification:
  • Must possess current Security+ (or equivalent DOD Directive 8570.1 IAT II).
  • Computing Environment Certification (can be achieved within 6 months of hire).
  • Certifications such as Microsoft Certified Database Administrator (MCDBA) or Azure Database Administrator Associate or similar legacy certification.
  • Skills and Experience:
  • Proven experience with database engineering tasks such as database consolidation/migration, redesign, new platform transition (e.g. SQL Server to alternative database solution).
  • Understanding of application specific alternative database solutions, particularly open-source databases (such as PostgreSQL or MariaDB) deployed in the ATEC environment is required.
  • Strong understanding of database structures, theories, principles, and practices. Familiarity with database design, effective documentation, and coding is vital.
  • Additional preferred skills and experience:
  • Azure Cloud Database Administration experience is a plus.

Apply for this position