Database Developer

Responsibilities

• Analyze, maintain, and optimize PostgreSQL database environment to ensure 99.9% availability and data integrity.
• Identify and resolve bottlenecks, optimize SQL queries, and enhance data retrieval efficiency for PostgreSQL.
• Update database architecture, build schemas, tables, stored procedures, and manage permissions.
• Provide recommendations on policies, procedures, and emerging technologies.
• Monitor systems for availability, oversee database mirroring, replication, and failover.
• Support advanced PostgreSQL features like JSON, full-text search, and PostGIS for geospatial queries.
• Generate queries and reports using PostgreSQL tools like pgAdmin, psql, and third-party tools such as DataGrip.
• Create, populate, and maintain PostgreSQL databases, materialized views, and indexes for analysis and reporting.
• Restore PostgreSQL databases from backups and support disaster recovery activities using WAL archiving and point-in-time recovery.
• Collaborate with developers, analysts, and IT teams to design, implement, and troubleshoot PostgreSQL database issues.
• Assess future storage and performance needs, and create and maintain comprehensive PostgreSQL documentation.

Qualifications

• The ideal candidate needs to have experience and knowledge in database design, coding, testing, debugging and documentation of software in a variety of programming languages.
• The candidate must reside within the continental US.
• Bachelor’s degree in Information Technology, Computer Science or Engineering.
• A minimum of 5 years of experience is required.
• Strong proficiency in database administration and performance tuning.
• Extensive hands-on experience with cloud platforms such as AWS and Azure, including infrastructure design, deployment, and management.
• Experience with automation tools and scripting languages for infrastructure and database management (e.g., CloudFormation, Terraform, Ansible, Python).
• Experience developing strategies for data migration, backup, and disaster recovery in cloud environments.
• Familiarity with DevOps practices and tools for continuous integration and delivery (CI/CD).
• Effective communication and collaboration skills, with the ability to work across teams and departments.
• Experience working with Department of Veterans Affairs (VA) / federal agencies.
• Certifications are a plus: MongoDB certification, AWS certification, Azure certification.
• Experience in SAFe/Agile Software Development.
• Ability to work effectively in a multi-stakeholder and DevSecOps environment.
• Ability to obtain government clearance.

Benefits

• 🌟 Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability, or protected veteran status.