UIC Commercial Services · 3 months ago
Sr. PostgreSQL Database Architect
UIC Commercial Services is seeking a Sr. PostgreSQL Database Architect to support the AR/PA IT Program at Naval Surface Warfare Center - Corona. The role involves analyzing technical support assignments, optimizing database performance, and collaborating with various teams within an agile environment.
ConstructionShipping
Responsibilities
Maintain and optimize PostgreSQL databases for performance, stability, and security
Perform database tuning, query optimization, and schema design
Implement and maintain database monitoring and alerting solutions
Coordinate and perform database backups, recovery, and archival
Conduct regular database maintenance tasks to ensure top performance
Collaborate with development teams to design and review database schemas and queries
Create and maintain documentation related to database environments and processes
Stay current with industry trends and best practices in database management
Qualification
Required
Active DoD Security Clearance (Secret or higher required)
Must hold CompTIA Security+ (CE) certification
Seven (7+) years of hands-on experience designing, implementing, and managing PostgreSQL databases in enterprise or government environments
Expert knowledge of database architecture, data modeling, indexing, and query optimization
Experience with database security controls, backup and disaster recovery planning
Proficient in PostgreSQL replication, partitioning, and performance tuning
Experience with cloud-based PostgreSQL (e.g., AWS RDS, Azure Database for PostgreSQL)
Familiarity with STIGs and DoD security hardening requirements
Ability to lead architecture reviews, data governance discussions, and integration with other platforms
Strong documentation and communication skills
Strong skills in data cleaning, refinement, and preparation for analysis and modeling
Proven experience in building and implementing predictive analytics models
Strong problem-solving skills and the ability to innovate and implement creative solutions
Excellent communication skills to collaborate effectively with cross-functional teams
Attention to detail and a commitment to producing high-quality results
Company
UIC Commercial Services
UIC Commercial Services is a division of Ukpeaġvik Inupiat Corporation, the Alaska Native Village Corporation for Utqiaġvik, Alaska.