Job Locations IN-Pune

ID 2024-4307

Position Type

Full-Time

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

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.

Share on your newsfeed