Healthedge Pune , IN 46615
Posted 1 week ago
Overview
HealthEdge is a cutting-edge software company focused on providing next-generation core administration and care coordination for transformative health plans. Within our Operations group, the Database Administration team is responsible for maintaining and administering the relational database components of HealthEdge's award winning SaaS solution hosted in our private cloud. The Performance DBA will work closely with our Engineering team to optimize the 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 and optimize SQL statement execution plans
Optimize use of database resources and features
Analyze the effects of application changes on database performance, and make tuning recommendations
Ensure successful application and database implementations
Provide database expertise to project teams to maximize system availability, efficiency, and security
Monitor performance testing systems and perform in-depth diagnosis and troubleshooting of performance
Advise as to optimal OS and storage configuration 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, exports and imports, and DBA tools (e.g. Oracle Enterprise Manager)
Work with Principal and Senior DBAs to understand integration requirements and customer needs, perform operational support and 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 version 19c
Experience administering SQL Server databases a plus
Proficiency in methodically troubleshooting complex issues
In-depth understanding of Oracle internals -- memory pools, wait events, locks, latches, enqueues, etc.
Proficiency in analyzing execution plans and tuning queries
Proficiency with Oracle Enterprise Manager, running and analyzing AWR, ADDM, and ASH reports
Skilled in the process of data modeling designed for high throughput and low latency
Experience analyzing and optimizing database solutions for multi-terabyte databases
Experience in Unix/Linux operating systems and understanding of optimal OS 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 in Oracle version 19c
Experience in shell scripting
Thorough knowledge of database tools and solutions, operational processes, and compliance mandates
Knowledge of database trends and products
Open to working in 24x7 on-call support model, if needed.
Behaviors:
Individual leadership
High level of 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
Healthedge