What 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 Skills

Must 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 Skills

Nice 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 Details

Compensation & 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.

Crimson Phoenix is an Equal Opportunity Employer. We make employment decisions without regard to race, color, religion, sex, national origin, age, disability, veteran status, or any other status protected by applicable law. Crimson Phoenix participates in E-Verify.