Database Administrator

Role: Database Administrator

Location: Carlisle Barracks, PA

Education/Certifications: Assoc-Tech degree preferred (not required); Minimum HS Diploma or GED; Relevant Database Certifications

Years of Experience: At least 4 years of relevant work experience

Clearance Level & Investigation: Interim Secret (requires U.S. citizenship)

IA Cert Level (DoD 8570.01): IAT 2

Computing Environment Certifications: Relevant Database Certifications

Job Description:

  • Perform Database Administration including, but not limited to, install/set up Database Management Systems and configure database settings, storage parameters, and security measures.
  • Perform database services, including, but not limited to, Data Backup-Recovery.
  • Develop and implement backup-recovery strategies to protect the database from data loss and ensure business continuity.
  • Schedule backups.
  • Perform restores.

Additional Responsibilities:

  • Provide database Installation and Configuration and install and set up Database Management Systems (DBMS) according to Customer requirements; configure database settings, storage parameters, and security measures.
  • Develop and implement backup and recovery strategies to protect database from data loss and ensure business continuity; regularly schedule backups and perform restores when needed.
  • Implement security measures to safeguard database from unauthorized access, data breaches, and malicious activities; define user roles and permissions, enforce authentication and encryption, and monitor for suspicious activities.
  • Monitor performance of database system, identify bottlenecks, and optimize efficiency; analyze query execution plans, fine-tune indexing strategies, and configure database parameters to enhance performance.
  • Collaborate with software developers and system analysts to design and develop database schemas and structures; ensure data integrity, normalization, and appropriate indexing for efficient data retrieval.
  • Perform version upgrades of DBMS software and apply necessary patches and updates to keep database system secure and up to date.
  • Assess database growth trends, storage requirements, and performance demands to plan for future capacity needs; allocate disk space, monitor resource utilization, and recommend hardware upgrades if necessary.
  • Diagnose and resolve database related issues such as performance bottlenecks, connectivity problems, and data corruption; investigate error messages, analyze logs, and apply appropriate solutions.
  • Maintain documentation on database configurations, processes, and procedures; generate reports on database performance, availability, and security for management and compliance purposes.
  • Develop and implement disaster recovery plans to minimize downtime and ensure data availability in event of natural disaster, system failure, or other emergencies.
  • Perform local and cloud-based database administration for standard database software for Customer and Mission-owned systems and perform hourly and daily full system backup to include (but not limited to) ASW / RDS management.
  • Provision new database instances in AWS RDS, select appropriate database engine, specify instance size, storage, and other configuration parameters.
  • Monitor performance and health of RDS instances using AWS CloudWatch; set up custom metrics and alarms to track CPU utilization, storage usage, I/O latency, and other critical database metrics.
  • Configure automated backups for RDS instances to ensure data durability; define backup retention periods, schedule backup windows, and restore databases from snapshots when needed.
  • Implement high availability features for RDS instances to ensure business continuity; configure Multi-AZ (Availability Zone) deployments for automatic failover and replication, improving fault tolerance and minimizing downtime.
  • Monitor memory capacity, cache hit ratio, resource usage, and other database metrics.
  • Manage and maintain databases for optimal performance and availability.
  • Ensure data accuracy, consistency, and reliability in all databases.
  • Perform database security audits and implement security measures.
  • Develop and maintain documentation for all database systems and processes.
  • Keep up to date with latest database technology trends.
  • Collaborate with developers to optimize database design.
  • Collaborate with stakeholders to understand and meet data needs.
  • Maintain database configurations according to standards and specifications.
  • Provide technical support for database-related issues.
  • Maintain policies and procedures related to database administration.
  • Provide support for database-related issues during off-hours as needed.
  • Evaluate and recommend cloud-based database solutions to optimize resource utilization and reduce costs.
  • Perform security functions for all DBMSs controlled and owned by Customer to include managing passwords and access control for all standard and local databases.
  • Ensure measures and procedures are used to monitor DBMSs IAW applicable regulations.
  • Conduct reviews of threats and vulnerabilities in DBMS and immediately report any system anomaly that could result in an unauthorized access to sensitive information within 1 hour of identification.
  • Ensure all databases are always STIG compliant and are inspection ready.
  • Perform data normalization for new and legacy, approved, local databases.
  • Perform database builds to include data modeling, data dictionary build, analysis of space requirements, size limitations, and establishment of purge criteria.
  • Maintain and tune relational databases and coordinate with vendors, Customer, and resident activities when tuning changes may affect user systems.
  • Monitor databases for performance, growth, and usage.
  • Perform maintenance to DBMS’ ensuring all processing adheres to technical constraints of server and DBMS.
  • Perform all associated tuning of related database files, including operating system memory configuration, DBMS server configuration variables, database configuration variables, and configurable database options.
  • Analyze queries being executed and identify frequently accessed columns or join conditions that could benefit from indexing; create, modify, or drop indexes to optimize query execution.
  • Analyze query execution plans and identify inefficient queries; consider rewriting or restructuring queries to minimize number of operations performed, reduce unnecessary data retrieval, and utilize indexes effectively; use database-specific tools and techniques to analyze and optimize query performance.
  • Ensure database schema is properly designed to support application’s data access patterns; normalize or denormalize schema as needed to strike balance between data consistency and query performance; avoid excessive joins, redundant data, or unnecessary complex structures.
  • Recommend vertical scaling by upgrading hardware resources or horizontal scaling by distributing workload across multiple database instances.
  • Perform configuration management for all database management systems and oversee all local and standard databases.
  • Control all approved DBMS changes, additions, or deletions to database management environment and update data dictionary and database tables.
  • Ensure configuration management includes instructions to programmers regarding database development as well as modifying existing configurations.
  • Document and control maintenance and modifications to hardware and software related to sustainment, enhancement, or establishment of application programs and databases.

Job Category: Database IT
Job Type: Full Time
Job Location: Carlisle Barracks
Clearance Level: Interim Secret U.S. Citizenship
Education-Certifications: Associates or Technical Degree (preferred) Database Certifications HS Diploma or GED
Years of Experience: 4+ years

Apply for this position

Your Passport must be valid for two years.

Maximum allowed file size is 1 MB. Allowed Type(s): .pdf, .doc, .docx