Database Architect/Administrator

Role Description

Maintain responsibility for implementing and maintaining one or more complex databases. Analyze the design, development, and delivery or implementation of data solutions, including:

• Architecture design
• Prototyping of concepts to proof of concept
• Analysis of the development of standards
• Design and test plans
• Code and module design development and testing
• Data solution debugging
• Design and implementation of a solution that follows efficient design techniques
• Development that meets and exceeds the intent of the design of the data solution

Assist with the planning and engineering of the organization's databases. Monitor performance, scalability, and security and evaluate existing database design to determine:

• The necessary updates and integration requirements of a new design
• Ensure final solutions meet organizational needs

Operates with substantial latitude for unreviewed action or decision; mentors team members regarding technical competencies.

Qualifications

• 5+ years of experience with supporting engineering efforts in system design and evaluation, solution engineering, software development, or system administration
• 3+ years of experience with a complex build system
• Experience with leading and mentoring other DBAs on an Oracle based system
• Experience with Database Schema as Code tools
• Experience with designing large enterprise solutions
• Experience with database partitioning and microservices
• Experience with code reviews on SQL change sets and work with developers to create and enforce best practices
• Hands-on or working knowledge of Process Playbook desired but not required
• Prior experience with federal or VA.gov digital services are highly desirable
• Must be able to pass a US Government Public Trust Security Clearance

Requirements

• Experience analyzing and tuning queries to improve performance
• Experience with Liquibase source control tools
• Exposure to security scanning tools, configuring their use and working with teams to fix vulnerabilities
• Experience with ETL and Data Warehousing methods
• Experience with installation, maintenance, and administration of PostgreSQL, MySQL, SQL Server, or other (non-Oracle) RDBMS variants
• Experience with security scanning tools, configuring their use, and working with teams to fix vulnerabilities

Benefits

• Fully remote, full-time role with meaningful mission impact for the Veteran community
• Opportunity to shape standards and practices at the program level
• Medical, Dental & Vision Insurance — J-Mack covers 80% of employee premiums and 50% of dependent premiums
• Basic Life, Short-Term Disability & Long-Term Disability — J-Mack covers 100% of the costs
• 401(k) Safe Harbor Plan with full vesting and 4% company match
• Paid Time Off: 120 hours annually, increasing to 160 hours after 5 years
• 11 Paid Holidays
• Charity Matching: J-Mack matches employee donations up to $250 annually, plus donates a percentage of profits to various charities each year