Address
Form of workThis is a temporary role through Magnit Global with one of the world's leading health insurance companies. Schedule Notes 2nd shift position (6pm - 2am EST) with need for flexibility to work some weekends. BA required or must have at least 5-7 years experience in IT or the equivalent in education and work experience 1 year contract with the opportunity to go full time/perm 100% remote Responsibilities: Responsible for supporting business funded and all other portfolio funded work efforts based on project requirements; delivered to customer expectations.
Work with engineers to determine end solutions for each project by comparing hardware/infrastructure alternatives in conjunction with cost, use, growth, supportability, etc. Collaborate with application architects, scrum masters, product managers, business analysts and technical management team to design, develop and document databases, schemas, tables, functions, triggers, procedures, relationships and other necessary aspects of the database. Configure and implement monitoring tools to report and alert on significant application and system level events in Oracle using OEM.
Work with senior engineers to document standards for where new rules apply or ad hoc changes are driven by project requirements. Requirements: Experience with database standard concepts, practices and procedures are required. Experience tracking these items within a large scale environment and communicate to diverse groups accordingly.
Self-directed and able to work with minimal supervision as well as provide direction and oversight to application team. Must have hands-on Oracle 12c & 19c experience with latest tuning and optimization techniques. Hands-on Oracle DB upgrade experience, Oracle 12c to 19c is required.
Strong relational and dimensional data-modeling is required in addition to experience designing and developing new databases and schemas. Required experience with tools such as: Monitoring tools: Splunk, Dynatrace Scheduling tools: ESP DBA tools: TOAD, Putty Solid Database Administration skills on 12c & 19c, 12c/19c RAC, and ASM in Linux is required. Experience in database performance monitoring and tuning skills, SQL and Stored-Procedure tuning OEM AWR/ADDM/GRID.
Excellent PL/SQL and SQL PLUS development and tuning skills are a must. Skilled at both logical and system levels desired. Automation/development in Ansible, Splunk, Python or other like tools is highly desirable.
Bachelor's degree in Computer Science/related discipline, or at least 5-7 years of diverse work experience in IT, or the equivalent in education and work experience Hourly Pay Rate Range (dependent on location, experience, expectation) The pay range that Magnit reasonably expects to pay for this position is: $43.00/hour-$63.45/hour Benefits: Medical, Dental, Vision, 401K
