Requisition ID: 25533
As a Oracle Database Administrator 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 of this position.
- Handles and leads the most complex or critical data/database management initiatives that typically involve multiple disciplines and multiple business groups, including responsibility for database architecture, design, integration, and/or data modeling.
-
Design database environments and create databases
-
Design, develop, test, deploy and maintain database objects
-
Design, develop, test, deploy and maintain database security and audit solutions
-
Design, develop, test, deploy and maintain database recovery solutions
-
Execute data recovery
-
Manage database performance, capacity, and availability
-
DBMS SW implementation, upgrade, patching
- Diagnoses and resolves performance issues. Provides expertise in database tuning including table partitioning strategies
- Works with the application team to identify and tune long running SQL statements
- Consults extensively with multiple client groups to provide strategic solutions, influencing long-range internal and enterprise-level data/ database architecture and management strategies
- Provide advice to business and technical personnel on data analysis principles, methods and trends using excellent written and verbal communications
- Design complex Data Transformation Strategies for Business Intelligence or Data Migration
- Lead complex Model Conversion (Data Mapping) to produce a Data Dictionary and data mapping matrix between the external software and the internal database for business function replacement
- Develop and maintain database support documentation
- Serves as a consultant on technological advancements. Provides oversight, mentoring and leadership to less experienced staff
- Responsible for providing hands-on experience technical support for assessing, architecting, and migrating Oracle databases from client-hosted environments to AWS
- Work with external AWS consultants and AWS AMS services to request services and support
- Work with on premises DBA staff
- Develops customer technology solutions using various industry products and technologies.
- Engages in technical problem solving across multiple technologies; often needs to develop new methods to apply to the situation
- Oracle 12c, 19c, with OEM and RAC experience on Linux required
- Native AWS Services(CloudEndure, DataSync, CloudWatch,S3, EC2, RDS, AMI) Experience
- Oracle Replication experience using Golden Gate or Data Guard with VLDB databases including partitioning required
- Scripting in Linux shell required
- 5+ years of professional DBA experience.
All US locations including remote are being considered.
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 July 29, 2024.
#LI-KR1 #LI-REMOTE
DIVERSITY COMMITMENT
To harness the power of innovation, we invest in the development of diverse employees. We aspire to leverage the qualities and appreciate the unique competencies that each person brings to our company.
Our company is committed to the principles of Equal Employment Opportunity and to providing reasonable accommodations to applicants with physical and/or mental disabilities. If you are interested in applying for employment with us and are in need of accommodation or special assistance to navigate our website or to complete your application, please contact us. Requests for reasonable accommodation will be considered on a case-by-case basis.
EOE AA M/F/Vet/Disability:
Qualified applicants will receive consideration for employment without regard to their age, race, religion, national origin, gender, sexual orientation, gender identity, protected veteran status or disability.