PostgreSQL Database Analyst

Responsibilities

• Analyze, design, develop, implement, and support database infrastructure deployment and management
• Manage the functionality and efficiency of a group of servers running on one or more operating systems
• Maintain database integrity and security, configure role‑based access control (RBAC), and set up administrative accounts
• Maintain documentation for configurations, standards, and procedures
• Interact with users and evaluate vendor products
• Develop and monitor policies and standards for allocation related to the use of computing resources
• Develop and implement testing strategies and document results
• Provide advice on performance tuning and training to end‑users
• Maintain current knowledge of relevant technologies as assigned
• Evaluate open‑source or vendor tools and participate in database migration/special modernization projects
• Collaborate with developers on schema design, query optimization, and stored procedures
• Plan and execute database upgrades, patching, and migrations
• Ensure compliance with industry standards and regulatory requirements
• Participate in on‑call rotations for after‑hours support

• Bachelor’s Degree in a Computer Science or related technical discipline, or the equivalent combination of education, technical certifications or training, or work experience
• 5+ years of related database analysis and/or administration experience
• PostgreSQL experience required
• Oracle database administration a plus
• CompTIA Security+ or equivalent recommended
• Experience in PostgreSQL administration/tuning, including knowledge and implementation of database high‑availability solutions
• Experience in monitoring, creating, and managing PostgreSQL server agent alerts
• Experience with database backup, restore, migration, and database snapshot technologies/strategies
• Knowledge on how to build/maintain efficient database table structures for both transactional and warehouse data
• Knowledge of Oracle 19c administration and performance tuning
• Migration experience with Oracle, MySQL, and PostgreSQL
• CANDIDATES must hold a TS/SCI