PostgreSQL Database Analyst

Job Overview

As a PostgreSQL Database Analyst, you will help design, administer, and modernize enterprise database environments supporting critical Intelligence Community missions. You’ll play a key role in ensuring the performance, availability, integrity, and security of mission‑essential PostgreSQL databases while supporting modernization initiatives, cloud migration efforts, and enterprise infrastructure improvements.

• Administer and maintain enterprise PostgreSQL database environments supporting classified mission systems.
• Design, implement, and maintain highly available PostgreSQL database solutions.
• Monitor database health, availability, capacity, and performance while proactively identifying opportunities for optimization.
• Configure and maintain role‑based access control (RBAC), database security, and administrative accounts.
• Develop and maintain database configuration standards, operational procedures, and technical documentation.
• Collaborate with software developers to optimize database schemas, stored procedures, indexing strategies, and SQL query performance.
• Plan and execute database upgrades, patching, migrations, and modernization initiatives.
• Perform database backup, recovery, replication, and disaster recovery planning.
• Support database migration efforts involving PostgreSQL, Oracle, and MySQL platforms.
• Analyze transactional and data‑warehouse workloads to improve scalability and performance.
• Evaluate emerging database technologies, open‑source tools, and commercial solutions supporting enterprise modernization.
• Implement database monitoring, alerting, and performance reporting solutions.
• Troubleshoot database availability, replication, storage, and performance issues.
• Ensure database environments comply with security policies, operational standards, and customer requirements.
• Provide technical guidance to engineering teams regarding database architecture and best practices.
• Participate in after‑hours on‑call support rotations as required.

• Bachelor’s degree in Computer Science, Information Technology, or a related discipline, or an equivalent combination of education, certifications, and experience.
• 5+ years of database administration, database engineering, or database analysis experience.
• Active Top Secret/SCI security clearance.
• Demonstrated experience administering PostgreSQL database environments.
• Experience implementing PostgreSQL performance tuning and optimization strategies.
• Experience designing or supporting high‑availability PostgreSQL environments.
• Experience performing database backup, restoration, replication, migration, and disaster recovery activities.
• Experience configuring PostgreSQL monitoring, alerting, and performance analysis tools.
• Knowledge of transactional database design and data‑warehouse architectures.
• Experience working with SQL and relational database concepts.
• Strong troubleshooting, analytical, and problem‑solving skills.
• Ability to collaborate effectively across engineering, infrastructure, and software development teams.

• Oracle 19c Administration
• Oracle Performance Tuning
• MySQL Administration
• PostgreSQL Replication
• PostgreSQL Clustering
• Database High Availability
• Database Automation
• SQL Performance Optimization
• Database Security
• Linux Administration
• Shell or Python scripting
• Cloud Database Technologies
• Enterprise Monitoring Solutions
• Data Migration Projects
• Database Modernization Initiatives
• CompTIA Security+ or equivalent DoD 8570 certification
• Active DoD TS/SCI
• Ability to obtain a Counterintelligence (CI) Polygraph

• Some travel may be required; must have a valid driver’s license and transportation.
• Candidate must be able to lift up to 50 lbs.

INflow Federal is a defense contractor. Pursuant to our government contracts, candidates must be U.S. citizens to be considered for employment.

INflow provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. This commitment applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, leaves of absence, compensation, and training.

Job applicants and employees are evaluated solely on job‑related qualifications and experience.