Current and Active Top Secret SCI with Polygraph required; no clearance sponsorship available.
Bachelor's degree in Computer Science, IT, or related field, or equivalent experience.
5+ years in database administration, engineering, or architecture.
Hands-on experience with PostgreSQL databases.
Proficient in relational database design, SQL, and query optimization.
Experience in troubleshooting database issues and managing user permissions.
Knowledge of database high availability and disaster recovery concepts.
Responsibilities
Manage database configuration, user accounts, and permissions.
Develop and refine data models and indexing strategies.
Analyze SQL queries to identify and resolve performance bottlenecks.
Collaborate with teams for PostgreSQL deployment and integration.
Implement and maintain backup and restore procedures.
Configure database monitoring and alerting systems.
Advise on schema design and transaction management.
Benefits
Comprehensive medical, dental, and vision insurance.
401(k) plan with company match.
Generous paid time off policy.
Company-paid life and disability insurance.
Tuition reimbursement for further education.
Professional development opportunities available.
Employee recognition programs and wellness benefits.
Full Job Description
Job Description
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.
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.
