About this opportunity
Meridian Systematics lists this PostgreSQL Database Architect opportunity in springfield, Virginia. Review the employer’s description below for duties, qualifications and application requirements.
Job description
Benefits
401(k)
Dental insurance
Flexible schedule
Health insurance
Paid time off
Parental leave
Vision insurance
PostgreSQL Database Architect
Location: Springfield, VA
Clearance: Active TS/SCI Required
Citizenship: U.S. Citizenship Required
Position Overview
We are seeking an experienced PostgreSQL Database Architect to support a mission-critical Intelligence Community customer. This position will be responsible for designing, implementing, administering, and optimizing PostgreSQL database environments while ensuring database availability, performance, integrity, and security.
The ideal candidate has strong hands-on PostgreSQL administration and performance-tuning experience, including high-availability solutions, database migrations, backup and recovery strategies, and database modernization initiatives.
Key Responsibilities
Design, implement, administer, and support PostgreSQL database environments.
Maintain database availability, integrity, security, and performance.
Configure role-based access control (RBAC), administrator accounts, and service accounts.
Monitor database environments and configure PostgreSQL server alerts.
Perform database performance tuning and troubleshoot database-related issues.
Plan and execute database upgrades, patching, backups, restores, and migrations.
Implement and support database high-availability and recovery solutions.
Collaborate with developers on schema design, query optimization, and stored procedures.
Design and maintain efficient database structures for transactional and data warehouse environments.
Develop testing strategies, execute testing, and document results.
Evaluate open-source and vendor database tools and technologies.
Support database migration and modernization initiatives involving PostgreSQL, Oracle, and MySQL.
Maintain technical documentation, configurations, standards, and procedures.
Ensure database environments comply with applicable security, industry, and regulatory requirements.
Provide technical guidance and database support to users and project teams.
Required Qualifications
Active TS/SCI clearance
5+ years of database administration and/or database analysis experience
Hands-on PostgreSQL administration and performance-tuning experience
Experience implementing and supporting database high-availability solutions.
Experience with database backup, restore, migration, and snapshot technologies and strategies.
Experience monitoring and managing PostgreSQL database environments and alerts.
Knowledge of database architecture and table structures for transactional and warehouse data.
Bachelor’s degree in Computer Science or a related technical discipline, or an equivalent combination of education, technical training, military experience, and/or relevant work experience.
U.S. Citizenship required.
Preferred Qualifications
Oracle database administration experience.
Database migration experience involving Oracle, MySQL, and PostgreSQL .
CompTIA Security+ or equivalent certification.
Experience supporting database modernization initiatives within government or Intelligence Community environments.
#J-18808-Ljbffr
Worksite address
springfield, VA, 22161, US
Who can apply
Review the original listing for work authorization, qualifications and employer requirements.