PostgreSQL Database Analyst
Role details
Job location
Tech stack
Job description
As a PostgreSQL Database Analyst at INflow Federal, 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.
Working alongside database administrators, software developers, systems engineers, and infrastructure teams, you'll optimize database performance, implement high-availability solutions, support migration projects, and help maintain secure, scalable database environments that directly support national security operations.
At INflow Federal, you'll have the opportunity to work with enterprise-scale data platforms, emerging technologies, and modernization initiatives while continuing to grow your expertise in database administration, automation, cloud technologies, and performance engineering.
What You'll Work On
You'll support enterprise PostgreSQL database environments responsible for processing mission-critical data across secure government systems. Your work will include database administration, performance tuning, backup and recovery planning, high-availability implementation, database migrations, security administration, and collaboration with development teams to optimize application performance.
You'll also contribute to modernization initiatives involving PostgreSQL, Oracle, and cloud-ready database architectures while supporting highly available enterprise infrastructure., * 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., * 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, * Some travel may be required: Must have valid driver's license and transportation. This is subject to change at the direction of the customer.
- If accommodation is needed with your application or the interview process for applicants with disabilities, please contact Human Resources at 703-594-8601.
- Candidate must have the ability to lift up to 50 lbs.
- Must have willingness to perform duties not listed in the job description as required by INflow and our customer.
Citizenship Requirements
- Please note that INflow Federal is a defense contractor. Pursuant to our government contracts, candidates must be US Citizens to be considered for employment.
Requirements
Do you have a valid Driver's License license?, Do you have experience in System tuning?, Do you have a Bachelor's degree?, * Bachelor's degree in Computer Science, Information Technology, or a related technical 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., * Active DoD TS/SCI
- Ability to obtain a Counterintelligence (CI) Polygraph