Remote Senior DBA
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)
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
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to [email protected] learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.
Required Skills & Experience
- 10+ years of experience administering Oracle databases
- Proficiency in methodically troubleshooting complex issues
- In-depth understanding of Oracle internals -- memory pools, wait events, locks, latches, enqueues, etc.
- Experience with AWS and working in enterprise level cloud environments
- Proficiency in analyzing execution plans and tuning queries
- Proficiency with Oracle Enterprise Manager, running and analyzing AWR, ADDM, and ASH reports - plus
- 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 is a plus
- Experience administering SQL Server Databases
Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.
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)
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
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to [email protected] learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.
Required Skills & Experience
- 10+ years of experience administering Oracle databases
- Proficiency in methodically troubleshooting complex issues
- In-depth understanding of Oracle internals -- memory pools, wait events, locks, latches, enqueues, etc.
- Experience with AWS and working in enterprise level cloud environments
- Proficiency in analyzing execution plans and tuning queries
- Proficiency with Oracle Enterprise Manager, running and analyzing AWR, ADDM, and ASH reports - plus
- 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 is a plus
- Experience administering SQL Server Databases
Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.