SQL Database Application Administrator (DBA)
Any city, TX, US, 99999
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 SQL Database Application Administrator (DBA) at Gainwell, you can contribute your skills as we harness the power of technology to help our clients improve the health and well-being of the members they serve — a community’s most vulnerable. Connect your passion with purpose, teaming with people who thrive on finding innovative solutions to some of healthcare’s biggest challenges. Here are the details on this position.
Your role in our mission
- Prepare, package, coordinate and implement production release and fixes. Identify and advise on issues and necessary remediations as appropriate.
- DDL/DML expertise, optimizing and performance tuning using execution plans, SQL Profile and Database Tuning advisor. Application development or PowerShell automation experience a plus.
- Troubleshoot application database connectivity, SQL Server issues, query performance, disaster recovery and other issues.
- Ability to work independently and as part of a team, under close deadlines and potentially stressful situations.
- Ability to manage multiple priorities, deliverables, and responsibilities.
- Develops and utilizes best practices, checklists and defined processes.
- Support during non-regular hours, nights, weekends, may be required.
- Agile/Kanban, HIPAA, Health Care (Medicaid) familiarity a plus.
- Demonstrated desire and capacity to learn new technical skills
- Assists in the design of basic technical programs for projects or enhancement to existing programs.
- Monitors database activity and files usage, and ensures necessary resources are available. Determines data to collect and analyzes information Investigates and resolves technical database issues of significance.
- Oversees the analysis and determination of database performance characteristics, informational needs and elements, data relationships and attributes, proposed manipulation, data flow and storage requirements, and data output and reporting capabilities for more complex databases.
- Recommends and implements tuning opportunities to improve system response and run times.
- Defines logical attributes and data inter-relationships and designs complex data structures to accommodate database production implementation, storage, maintenance and accessibility to enhance performance.
- Optimizes database accessibility by developing load balancing architectures and processes to eliminate down time for backup processes.
- Implements and supports database security regulations, policies, and guidelines. Monitors security bulletins to obtain information of potential threats; is aware of and verifies the installation of necessary security patches to ensure ongoing database security.
- Plans and installs upgrades of database management systems (DBMS) software as necessary to enhance database performance. Research various hardware and software products; recommends the best solution and implements approved products.
- Functions as a technical project leader and provides work leadership to less experienced personnel on a portfolio of databases, including installation and upgrades of DBMS software and backup/recovery strategies. Reviews and approves application and database design decisions to ensure that the application solutions exhibit high levels of performance, security, scalability, maintainability, and reliability upon deployment.
- Assists project managers in the development of project plans including detailed project estimates and task required for database activities. Utilizes standard corporate tools to record change and problem activities for tracking purposes.
- Integrates databases and commercial off the shelf software; resolves conflicts between databases and off the shelf software, operating systems, and open source applications.
- Designs and tests database installation, implementation, and recovery scenarios. Determines tests to use and collects appropriate data according to established guidelines. Participates in analysis, development and implementation of unique database recover plans in response to database outages.
What we're looking for
- 7+ years of data management experience.
- Strong expertise as a SQL Server Application DBA working closely with application developers.
- Strong expertise in DDL/DML
- Knowledge of Microsoft Azure Cloud, Amazon Web Services, SQL Server IaaS (infrastructure as a Service).
- Good oral and written communication skills and the ability to work with minimal direction.
What you should expect in this role
- Fully Remote Opportunity
Note
- Video cameras must be used during all interviews, as well as during the initial week of orientation.
- The deadline to submit applications for this posting is 10/31/2024.
The pay range for this position is $71,100.00 - $101,600.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
Fully remote Fully remote opportunity Initial week of orientation Orientation Video cameras must be used Video cameras must be used during all interviews
Benefits/PerksCareer development Career development opportunities Comprehensive health benefits Comprehensive leadership and technical development academies Development academies Educational Assistance Flexible Vacation Flexible vacation policy Fully remote Fully remote opportunity Generous, flexible vacation policy Health benefits Inclusive workplace Leadership and technical development Leadership and technical development academies Medical Technical development Technical development academies Vacation policy Work flexibility
Tasks- Analysis
- Application development
- Design
- Implement
- Leadership
- Optimize database performance
- Prepare and implement production releases
- Troubleshoot database connectivity issues
Accessibility Agile Analysis Application Development Automation Azure Best Practices Collaboration Communication Database Administration Database design Database Management Database Security DDL Design Development DML Edge Functions Healthcare HIPAA Innovation Kanban Leadership Medicaid Medical Microsoft Azure Operating Systems Performance Tuning PowerShell Reporting Research Software SQL SQL Server Technology Web Services Written communication
Education Certifications 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