Database Administrator
Mind Computing
full-time
Posted on:
Location Type: Remote
Location: Remote • 🇺🇸 United States
Visit company websiteSalary
💰 $105,000 - $115,000 per year
Job Level
Mid-LevelSenior
Tech Stack
AnsibleAWSAzureCloudMongoDBPostGISPostgresPythonSQLTerraform
About the role
- Analyze, maintain, and optimize PostgreSQL database environment to ensure 99.9% availability and data integrity.
- Analyze, maintain, and optimize 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.
- Update database architecture, build schemas, tables, stored procedures, and manage permissions.
- 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.
- 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.
- 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
- Bachelor’s degree in Information Technology, Computer Science, Engineering, or an equivalent discipline.
- A minimum of 5 years of experience.
- 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.
- Additional Qualifications: Experience working with the Department of Veterans Affairs or other federal agencies.
- The following certifications are a plus: MongoDB certification, AWS certification, Azure certification, etc.
- Experience in SAFe/Agile Software Development.
- Ability to work effectively in a multi-stakeholder and DevSecOps environment.
- Ability to obtain government clearance.
- Experience with database support for legacy and Platform as a Service applications.
Benefits
- Medical/Dental/Vision
- PTO + Federal Holidays
- Corporate Laptop
- Training opportunities
- Remote work options
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
PostgreSQLMicrosoft SQLdatabase administrationperformance tuningdata migrationbackupdisaster recoveryautomationscriptingDevOps
Soft skills
effective communicationcollaborationtroubleshootingrecommendationsproblem-solvinginterpersonal skillsorganizational skillsstakeholder engagementteamworkadaptability
Certifications
MongoDB certificationAWS certificationAzure certification