Mind Computing ยท 1 month ago
Database Administrator (Remote Opportunity)
Mind Computing is seeking a Database Administrator to be a part of a remote team supporting the Department of Veterans Affairs. The role involves analyzing, maintaining, and optimizing database environments, ensuring high availability and data integrity while collaborating with various teams to troubleshoot issues.
ConsultingInformation TechnologyProject Management
Responsibilities
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
Qualification
Required
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
Preferred
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