Advisor Database Architect - Remote
Quincy, MA, US, 02171-1745
Be part of a team that unleashes the power of leading-edge technologies to help improve the health and well-being of those most vulnerable in our country and communities. Working at Gainwell carries its rewards. You’ll have an incredible opportunity to grow your career in a company that values work flexibility, learning, and career development. You’ll add to your technical credentials and certifications while enjoying a generous, flexible vacation policy and educational assistance. We also have comprehensive leadership and technical development academies to help build your skills and capabilities.
Summary
As an Advisor Database Administrator at Gainwell, you will play a key role in designing, building, and maintaining databases for both in-house and third-party applications. You will lead efforts in database backup, recovery, performance tuning, and disaster recovery planning. Additionally, you will collaborate with application teams to optimize performance and provide technical leadership for migrations, database upgrades, and ongoing support. This is a remote role with on-call responsibilities, including after-hours support.
Your role in our mission
- Design and build databases for in-house and third-party applications, managing disk layout and database creation.
- Plan, set up, test, and troubleshoot database backup and restore processes, ensuring data protection and availability.
- Lead disaster recovery efforts by setting up, testing, and executing database recovery plans.
- Refresh test environments by extracting and loading data from production databases.
- Manage technical refreshes, DBMS software updates, and hardware migrations to new locations.
- Implement data archiving and purging processes for partitioned and non-partitioned tables.
- Work with application developers to design data models and manage database object changes from test to production environments.
What we're looking for
- Bachelor's degree in Computer Science or related field (or equivalent combination of education and experience).
- Nine or more years of experience in data/database architecture.
- Strong knowledge of database structure differences (e.g., transaction-based vs. data warehouse).
- Familiarity with relevant software packages or classes of packages within technical expertise.
- Strong project planning, communication, and leadership skills with the ability to mentor junior staff.
- Requires availability for on-call support, including after-hours and weekend work.
What you should expect in this role
- Lead database performance tuning efforts and manage capacity planning and security.
- Participate in on-call responsibilities for production support, including after-hours work.
- Apply Oracle upgrades, release patches, and manage database replication with tools like Golden Gate or Data Guard (preferred).
- Collaborate with the application team to optimize SQL statements and participate in code walkthroughs.
- Fully remote position with the flexibility to work from home.
- Develop and maintain detailed documentation for database support processes and activities.
#LI-REMOTE
#LI-KR1
#LI-JT1
#LI-MF1
The pay range for this position is $90,900.00 - $129,900.00 per year, however, the base pay offered may vary depending on geographic region, internal equity, job-related knowledge, skills, and experience among other factors. Put your passion to work at Gainwell. You’ll have the opportunity to grow your career in a company that values work flexibility, learning, and career development. All salaried, full-time candidates are eligible for our generous, flexible vacation policy, a 401(k) employer match, comprehensive health benefits, and educational assistance. We also have a variety of leadership and technical development academies to help build your skills and capabilities.
We believe nothing is impossible when you bring together people who care deeply about making healthcare work better for everyone. Build your career with Gainwell, an industry leader. You’ll be joining a company where collaboration, innovation, and inclusion fuel our growth. Learn more about Gainwell at our company website and visit our Careers site for all available job role openings.
Gainwell Technologies is committed to a diverse, equitable, and inclusive workplace. We are proud to be an Equal Opportunity Employer, where all qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical condition), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics. We celebrate diversity and are dedicated to creating an inclusive environment for all employees.
ApplyJob Profile
After hours support Fully remote Fully remote position On-call responsibilities Orientation Remote position
Benefits/Perks401(k) employer match Career development Comprehensive health benefits Comprehensive leadership and technical development academies Development academies Educational Assistance Flexibility Flexible Vacation Flexible vacation policy Fully remote Generous, flexible vacation policy Health benefits Inclusive workplace Leadership and technical development Leadership and technical development academies Leadership development academies Medical Technical development Technical development academies Vacation policy Work flexibility Work From Home
Tasks- Code
- Collaborate with application teams
- Design
- Design and build databases
- Disaster recovery planning
- Documentation
- Implement
- Lead disaster recovery efforts
- Leadership
- Manage backup and restore processes
- Optimize performance
- Planning
- Project planning
- Provide technical leadership
- Test
Capacity planning Collaboration Communication Computer Database Architecture Database Backup Data Guard Data Modeling Data Warehouse Design Development Disaster Recovery Documentation Edge Flexibility GoldenGate Hardware Healthcare Innovation Leadership Medical Oracle Performance Tuning Processes Project Planning Software SQL Teams Technical Technical Leadership Testing Tools
Experience9 years
EducationBachelor's Bachelor's degree Bachelor's degree in Computer Science Computer Science Equivalent Equivalent combination of education and experience Healthcare Related Field
TimezonesAmerica/Anchorage America/Chicago America/Denver America/Los_Angeles America/New_York Pacific/Honolulu UTC-10 UTC-5 UTC-6 UTC-7 UTC-8 UTC-9