Database Administrator

Freedom Technology Solutions Groupisseekinga skilled and detail-oriented Database Administrator (DBA) to support the design implementation administration maintenance and optimization of enterprise database environments. The Database Administrator will ensure the availability performance integrity and security of mission-critical data systems while supporting application development data analytics and operational requirements across multiple programs and customer environments.

The successful candidate will manage database infrastructuremonitorsystem performance implement backup and recovery strategies and ensure compliance with security and accreditation requirements. This individual will work closely with software developers system administrators cloud engineers cybersecurity personnel and customer stakeholders to deliver reliable and scalable database solutions that support missionobjectives.

Responsibilities:

Database Administration & Operations

• Install configure administer andmaintainenterprise database environments.
• Ensure database availability reliability integrity and performance across development testing and production environments.
• Monitor database health and proactively identify troubleshoot and resolve performance bottlenecks and operational issues.
• Develop and maintain database standards procedures and operational documentation.
• Perform database patching upgrades migrations and lifecycle management activities.
• Implement and maintain backup recovery and disaster recovery solutions to ensure continuity of operations.
• Conduct regular database capacity planning and performance tuning activities.
• Support containerized and Kubernetes-based database deployments using platforms such as OpenShift Kubernetes and cloud-managed database services.
• Implement Infrastructure as Code (IaC) solutions using tools such as Terraform CloudFormation Helm and Ansible.
• Automate database provisioning monitoring scaling and maintenance activities through CI/CD pipelines and DevSecOps practices.
• Support database modernization efforts including migration of legacy systems to cloud-native architectures.

GEOINT Data Management & Analytics Support

• Support databases that store process and manage GEOINT geospatial imagery and intelligence-related datasets.
• Design and optimize database schemas to support large-scale geospatial data storage indexing retrieval and analytics.
• Implement and manage geospatial database capabilities using technologies such as PostgreSQL/PostGIS and other spatial extensions.
• Support ingestion transformation and management of structured semi-structured and unstructured GEOINT data.
• Collaborate with analysts data scientists and software engineers to improve data accessibility performance and usability.
• Optimize database performance for geospatial queries imagery metadata retrieval and mission analytics workloads.
• Support management of metadata catalogs geospatial feature repositories and data discovery services.

Data Architecture & Engineering Support

• Collaborate with software development teams to design efficient database architectures that support mission applications and analytical workflows.
• Review database designs and recommend improvements for scalability performance and maintainability.
• Develop and maintain data models schemas indexing strategies and partitioning approaches.
• Support API-driven data access architectures and integration with enterprise data services.
• Assist in developing data governance standards data quality controls and lifecycle management processes.

Security & Compliance

• Implement database security controls role-based access controls encryption auditing and monitoring capabilities.
• Ensure compliance with organizational security requirements RMF controls and applicable government cybersecurity standards.
• Support vulnerability remediation efforts and security audits.
• Maintain database accreditation artifacts and documentation as required.
• Collaborate with cybersecurity teams to ensure databases meet operational and compliance requirements.

Performance Optimization & Monitoring

• Analyze database performance metrics and implement tuning strategies tooptimizethroughput and responsiveness.
• Develop monitoring dashboards alerts and automated reporting capabilities.
• Conduct root cause analysis of database incidents and implement corrective actions.
• Optimize query performance indexing strategies storage allocation and resource utilization.
• Support high-availability architectures clustering solutions and replication technologies.

Collaboration & Technical Leadership

• Work closely with system administrators cloud engineers software developers data engineers and mission stakeholders.
• Provide technical guidance and recommendations on database technologies architectures and best practices.
• Participate in Agile development activities sprint planning technical reviews and architecture discussions.
• Support customer meetings technical exchanges and project reviews as required.

Key Technologies:

• MicrosoftWordPowerPointand Excel
• Knowledge of supervised learning (classification regression) unsupervised learning (clustering dimensionality reduction) model evaluation (precision recall F1 ROC-AUC) feature engineering and overfitting vs underfitting.
• Knowledge of probability & distributions hypothesis testing (A/B testing) regression (linear logistic) Bayesian thinking and experimental design.
• Experience with different database distributions (e.g. Postgres Oracle)
• Data Wrangling and Feature Engineering
• Data Visualization and storytelling (Tableau Matplotlib Power BI
• Knowledge of ETL processes data pipelines and APIs/data integration
• Cloud platforms (AWS Azure Google Cloud)
• Understanding services (e.g. EC2 Lambda S3 Kubernetes Services)
• DevSecOps & Automation
• Understanding of GitLab CI/CD Databases (joins aggregations performance tuning) Big data tools (Spark Hadoop) Data manipulation (Pandas NumPy) and programming.
• Agile DevSecOps & Development Lifecycle Tools

Required Qualifications:

• Active TS/SCI security clearance (eligible for CI Poly).
• Bachelors degree in Computer Science Information Systems Information Technology Engineering Mathematics or a related technical discipline. Equivalent experience may be substituted for formal education.
• 3-8 years of experience administering enterprise database environments.
• Demonstrated experience administering and maintaining PostgreSQL databases in production environments.
• Strong knowledge of relational database concepts data modeling normalization indexing and query optimization.
• Experience implementing backup recovery replication and high-availability solutions.
• Experience monitoring and tuning database performance in mission-critical environments.
• Experience supporting databases in cloud and hybrid cloud environments.
• Proficiency with SQL scripting stored procedures database maintenance and automation.
• Experience supporting Linux and/or Windows server environments hosting database services.
• Familiarity with DevSecOps practices CI/CD pipelines and Infrastructure as Code (IaC) methodologies.
• Experience using version control systems such as Git.
• Strong analytical troubleshooting and problem-solving skills.
• Ability to communicate technical concepts effectively to both technical and non-technical stakeholders.
• Ability to work independently and collaboratively in a fast-paced Agile environment.
• Self-starter with the ability to learn research and solve problems on their own accord.
• Works mostly independent

Desired Qualifications:

• Knowledge of secure coding best practices and compliance standards (NIST FedRAMP etc.)
• Knowledge of Cloud Platforms (AWS Azure)
• Experience with modern software development practices
• Experience with navigating organizational security processes.
• Experience developing and delivering contract deliverables