PostgreSQL Database Analyst

**About INflow Federal** - founded in 2013, INflow Federal is a mission-driven small business delivering cutting-edge solutions to the Department of War (DoW) and Joint Force operations across 20+ states. Our strength comes from our people - especially the Veterans who make up over 50% of our workforce. Through our Veteran Outreach Program and employee-first culture, we invest deeply in professional growth, well-being, and innovation. Known for our agility, transparency, and integrity, INflow combines real-world experience with emerging technologies like AI/ML to help our customers lead in a rapidly evolving defense landscape. We empower both our employees and mission partners to stay ahead - driving smarter, faster, and more secure outcomes. 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. ### Duties & Responsibilities - 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…