Job DescriptionWhat You'll Be Doing:- Managing database configuration, user accounts, roles, permissions, routine maintenance, patching, upgrades, and operational troubleshooting.
- Developing and refining schemas, data models, indexing strategies, and data access patterns to support application functionality, performance, and evolving system requirements.
- Analyzing SQL queries and execution plans, identifying performance bottlenecks, and implementing improvements to queries, indexes, database configuration, and resource utilization.
- Collaborating with platform and application teams to support PostgreSQL deployment, connectivity, configuration, monitoring, and operational integration with OpenShift-based systems.
- Implementing and maintaining backup and restore procedures, validating recovery processes, and supporting existing high-availability, replication, and disaster recovery capabilities.
- Configuring and maintaining database monitoring, logging, alerting, capacity tracking, and operational reporting to identify and resolve issues proactively.
- Advising on schema design, SQL development, transaction management, data access patterns, and database integration to ensure efficient and reliable application behavior.
- Identifying database performance, reliability, scalability, and maintainability improvements; evaluating appropriate tools and approaches; and implementing practical solutions.
- Planning and executing database upgrades, migrations, configuration changes, and modernization efforts while minimizing operational risk and service disruption.
- Documenting database architecture, configurations, security controls, operational procedures, and recommended engineering practices.
- Applying appropriate access controls, least-privilege permissions, auditing, and security practices in accordance with applicable customer and system requirements.
- Serving as the primary database technical resource for the engineering team, helping troubleshoot issues and making informed decisions about database design and operational practices.
Required SkillsMust Have:- MUST HAVE a Current and Active Top Secret SCI with Polygraph, as the customer is NOT sponsoring clearances.
- Bachelor's degree in Computer Science, Information Technology, or a related technical discipline, or equivalent education, training, certifications, and experience.
- Five or more years of experience in database administration, database engineering, database architecture, or a related technical discipline.
- Hands-on experience administering and supporting PostgreSQL databases.
- Experience with relational database design, data modeling, SQL, schema development, indexing, and query optimization.
- Experience troubleshooting database issues and managing database users, roles, permissions, and configurations.
- Experience with database backups, restores, upgrades, and routine maintenance.
- Working knowledge of database high availability, replication, and disaster recovery concepts.
- Ability to collaborate with developers and infrastructure engineers to resolve technical issues and improve system performance.
- Strong analytical, troubleshooting, documentation, and communication skills.
Desired SkillsNice to Have:- Experience supporting PostgreSQL in OpenShift, Kubernetes, containerized, or Linux-based environments.
- Experience with PostgreSQL replication, failover, connection pooling, or high-availability technologies.
- Experience with database monitoring, logging, alerting, and performance diagnostics.
- Experience supporting both transactional and analytical data workloads.
- Experience with database automation, scripting, infrastructure as code, or repeatable deployment practices.
- Experience planning and executing database migrations, upgrades, and modernization initiatives.
- Familiarity with database security practices in regulated or classified environments.
- Experience with Oracle database administration or Oracle-to-PostgreSQL migration.
- CompTIA Security+ certification or equivalent, as required by the applicable customer environment.
Additional DetailsCompensation & Benefits: This position has an anticipated salary range of $115,000-$145,000 per year. Actual compensation will be determined based on factors including experience, qualifications, skills, education, certifications, and business needs. Crimson Phoenix offers a comprehensive benefits package, including medical, dental, and vision insurance, a 401(k) with company match, generous paid time off, company-paid life and disability insurance, tuition reimbursement, professional development opportunities, employee recognition programs, and additional wellness and work-life benefits.
U.S. citizenship and the ability to obtain or maintain a security clearance may be required for certain positions.