Database Administrator(Remote Opportunity)

Veterans EZ Info Inc; Tampa (FL); Remote; USD 80,000 - 110,000; Full time

Job summary

An innovative company is seeking a skilled Database Administrator to join a remote team dedicated to supporting the Department of Veterans Affairs. In this role, you will leverage your expertise in PostgreSQL to ensure optimal database performance and integrity. You will analyze, maintain, and optimize the database environment while collaborating with cross-functional teams to tackle challenges and enhance data retrieval efficiency. This is a fantastic opportunity to work in a dynamic environment, contribute to meaningful projects, and grow your career in database administration and cloud technologies.

Qualifications

• 5+ years of experience in database administration and performance tuning.
• Strong proficiency in PostgreSQL and cloud platforms like AWS and Azure.
• Experience with automation tools for infrastructure management.

Responsibilities

• Analyze and optimize PostgreSQL database environment for availability and integrity.
• Collaborate with teams to troubleshoot database issues and enhance performance.
• Manage database architecture, including schemas, tables, and stored procedures.

Skills

PostgreSQL Administration

SQL Query Optimization

Database Design

AWS

Azure

Python

DevOps Practices

Education

Bachelor’s Degree in Information Technology

Bachelor’s Degree in Computer Science

Bachelor’s Degree in Engineering

Tools

pgAdmin

DataGrip

CloudFormation

Terraform

Ansible

Job description

VetsEZ is seeking a Database Administrator 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, debugging, and documentation of software in a variety of programming languages.

The candidate must reside within the continental US.

Responsibilities

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

Requirements

1. Bachelor’s degree in Information Technology, Computer Science, or Engineering.
2. A minimum of 5 years of experience is required.
3. Strong proficiency in database administration and performance tuning.
4. Extensive hands-on experience with cloud platforms such as AWS and Azure, including infrastructure design, deployment, and management.
5. Experience with automation tools and scripting languages for infrastructure and database management (e.g., CloudFormation, Terraform, Ansible, Python).
6. Experience developing strategies for data migration, backup, and disaster recovery in cloud environments.
7. Familiarity with DevOps practices and tools for continuous integration and delivery (CI/CD).
8. Effective communication and collaboration skills, with the ability to work across teams and departments.

Additional Qualifications

• 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.