Database Administrator 683

Job description

Freedom Technology Solutions Group is seeking a 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 infrastructure, monitor system 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 mission objectives. **Responsibilities:** Database Administration & Operations - Install, configure, administer, and maintain enterprise 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 to optimize throughput 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:** - Microsoft Word, PowerPoint and 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)