Think Beyond The Label Jobs

Overview

HealthEdge is acutting-edgesoftware company focused on providing next-generation core administration and care coordination for transformative health plans. Within our Operations group, the Database Administration teamis responsible formaintainingand administering the relational database components ofHealthEdge'saward winningSaaS solution hosted in our private cloud. The Performance DBA will work closely with our Engineering team tooptimizethe performance of our software.

Responsibilities:

• Throughout the development life cycle, collaborate with our product engineering teams to:

• Advise as to data models that allow for efficient query execution

• Analyze andoptimizeSQL statement execution plans

• Optimizeuse of database resources and features

• Analyzethe effects of application changes on database performance, and maketuning recommendations

• Ensure successful application and database implementations

• Providedatabaseexpertiseto project teams to maximize system availability, efficiency, and security

• Monitor performance testing systems and perform in-depth diagnosis and troubleshootingof performance

• Advise as tooptimalOS and storageconfiguration of Linux servers to support Oracle databases

• Analyze database system and query performance, and perform triage and resolution,in response to performance-related product incidents

• Support DBA utilities, reorgs, index builds, exportsandimports,and DBA tools (e.g.Oracle Enterprise Manager)

• Work with Principal and Senior DBAs to understand integration requirementsand customer needs,performoperational supportand maintenance activities.

• Interact with key stakeholders including Cloud Operations, Information Security, Professional Services, and support teams for service request fulfilment, implementations, and operational support related to database services.

Required Experience, Skills, and Behaviors:

• 10+ years of experience administering Oracle databases, including version19c

• Experience administering SQL Server databasesa plus

• Proficiencyin methodically troubleshooting complex issues

• In-depth understanding of Oracle internals -- memory pools, wait events, locks, latches, enqueues, etc.

• Proficiencyin analyzing execution plans and tuning queries

• Proficiencywith Oracle Enterprise Manager, running and analyzing AWR, ADDM, and ASH reports

• Skilledintheprocess of datamodeling designed for high throughput and low latency

• Experience analyzing andoptimizingdatabase solutions for multi-terabyte databases

• Experience in Unix/Linux operating systems and understanding ofoptimalOS configuration (e.g.kernel parameters, IO subsystem) as relates to Oracle Database

• Hands-on experience in terms of planning, installing, configuring,maintaining,and troubleshooting issues inOracleversion19c

• Experience in shellscripting

• Thoroughknowledge of database tools and solutions, operational processes, and compliance mandates

• Knowledgeof database trends and products

• Open to working in 24x7 on-call support model, if needed.

• Behaviors:

• Individual leadership

• High levelof collaboration

• Team mentor

• Ownership of work

• Focus on detail and quality

• Adherence to standard operating procedures

• Highly analytic thinking

• Clear and respectful communication

• Continuing motivation to expand skill set

• Nice to have

• PostgreSQL

Job Locations IN-Pune

ID 2024-4307

Position Type Full-Time

HealthEdge provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.