Database Engineer (Remote Opportunity)

VetsEZ is seeking a  Database Engineer to be a part of a remote team supporting the Department of Veterans Affairs. The ideal candidate needs to have experience and knowledge in database design, coding, testing, optimization, debugging and documentation of software in a variety of programming languages, including PostgresSQL, and Microsoft SQL.

The candidate must reside within the continental US.

Responsibilities :

• Create and update database architecture, build schemas, tables, stored procedures, and manage permissions.
• Generate queries and reports using PostgreSQL tools like pgAdmin, psql, and third-party tools such as DataGrip. Create queries usable by development.
• Analyze, maintain, and optimize PostgreSQL / Microsoft SQL database environment to ensure 99.9% availability and data integrity.
• Identify and resolve bottlenecks, optimize SQL queries, and enhance data retrieval efficiency for PostgreSQL and Microsoft SQL.
• Manage, improve, and work with Legacy databases and Platform as a Service databases.
• 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.
• 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.
• Work with Platform as a Service pre-built database to optimize and manage as needed for growing solutions.
• Communicate effectively with customers, stakeholders, and technical specialists.

Requirements :

Additional Qualifications :

Benefits :

Note : Selected candidates will be required to complete fingerprinting at a government facility and undergo a background check as part of the hiring process.

Equal Opportunity Disclaimer

VetsEZ is an equal opportunity employer. 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.

Sorry, we are unable to offer sponsorship at this time.