Database Engineer
VetsEZ
full-time
Posted on:
Location Type: Remote
Location: Florida • United States
Visit company websiteExplore more
About the role
- Analyze, maintain, and optimize PostgreSQL and Microsoft SQL database environments to ensure high availability, performance, and data integrity.
- Identify and resolve performance bottlenecks, optimize SQL queries, and improve data retrieval efficiency.
- Design and maintain database architecture, including schemas, tables, indexes, stored procedures, and security permissions.
- Manage and support legacy databases and Platform as a Service (PaaS) database solutions.
- Monitor systems for availability and oversee database replication, mirroring, failover, and disaster recovery processes.
- Implement backup, restore, and recovery strategies, including point-in-time recovery and WAL archiving.
- Support advanced PostgreSQL features such as JSON, full-text search, and PostGIS for geospatial queries.
- Generate queries and reports using tools such as pgAdmin, psql, and third-party database clients.
- Collaborate with developers, analysts, and infrastructure teams to design, implement, and troubleshoot database solutions.
- Assess future storage and performance needs and maintain accurate technical documentation.
- Provide recommendations on database policies, procedures, and emerging technologies.
- Communicate effectively with customers, stakeholders, and technical specialists.
- Contribute to team objectives and take on additional responsibilities as needed.
Requirements
- Education: Bachelor’s degree in Information Technology, Computer Science, Engineering, or a related field, or equivalent experience.
- Experience: Minimum of five years of experience in database administration supporting enterprise or cloud-based environments.
- Technical Skills: Strong proficiency in PostgreSQL and Microsoft SQL Server administration, performance tuning, and optimization.
- Cloud Platforms: Hands-on experience with AWS and Azure, including database deployment and management.
- Automation & Scripting: Experience with tools such as Terraform, CloudFormation, Ansible, and scripting in Python or similar languages.
- DevOps: Familiarity with CI/CD pipelines and DevOps practices.
- Soft Skills: Strong communication, documentation, problem-solving, and collaboration skills in cross-functional environments.
- Additional Qualifications: Experience supporting Department of Veterans Affairs or other federal government systems.
- Experience working in SAFe or Agile development environments.
- Knowledge of DevSecOps practices and secure data management.
- Experience supporting both legacy systems and Platform as a Service (PaaS) databases.
- Relevant certifications such as AWS, Azure, or MongoDB are a plus.
- Ability to obtain and maintain a government background clearance.
Benefits
- 📊 Check your resume score for this job Improve your chances of getting an interview by checking your resume score before you apply. Check Resume Score
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
PostgreSQLMicrosoft SQL Serverperformance tuningdatabase architectureSQL queriesbackup and recovery strategiesJSONfull-text searchPostGISscripting in Python
Soft Skills
communicationdocumentationproblem-solvingcollaboration
Certifications
AWSAzureMongoDB