Database Development Manager Jobs in Collinsville, IL

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)
• 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).
• Bachelor's 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