PitchMeAI
PitchMeAI
Home›Jobs›Senior Oracle DBA
insightsoftware

Senior Oracle DBA

insightsoftware · United States

  • Hybrid
  • Full-time
  • $124,000 / year
  • United States

Job highlights

  • Manage Oracle, MS SQL, and PostgreSQL databases.
  • Ensure database infrastructure reliability and scalability.
  • Lead security, backup, and disaster recovery efforts.
  • Mentor junior DBAs and guide development teams.
  • Provide 24/7 on-call support for critical systems.

About the role

About Us

insightsoftware is a global provider of reporting, analytics, and performance management solutions that unlock the potential of business data and transform the way finance and data teams operate. We empower leaders from over 32,000 organizations to make timely and intelligent decisions. Our comprehensive solutions span Financial Planning and Analysis (FP&A), Controllership, and Data and Analytics. We deliver finance teams the insights required to navigate any economic climate and drive greater financial intelligence, while increasing productivity, visibility, accuracy, and compliance. Learn more at insightsoftware.com.

Job Description

We are seeking an experienced Senior Database Administrator (DBA) to join our team. This role requires 10+ years of hands-on experience as an Oracle Administrator and at least 3+ years of experience with MS SQL and PostgreSQL to maintain a reliable, scalable, and fault-tolerant database infrastructure for our growing customer base.

Key Responsibilities

Database Administration & Support:
  • Install, maintain, and troubleshoot RHEL/OEL OS supporting Oracle databases in physical and virtualized environments.
  • Provide DBA services to application development, professional services, and support teams, including database design, query validation/execution, and performance tuning.
  • Troubleshoot database alerts, logs, jobs, disk groups, tablespaces, and resolve performance-related issues.
  • Automate database tasks and develop scripts to improve efficiency and reduce manual intervention.
Infrastructure & Security
  • Lead the design and implementation of database infrastructure solutions to meet business requirements.
  • Manage the implementation of technical controls to enforce security policies.
  • Ensure compliance with SOC2/ISO27001 audits and adhere to all audited controls.
Backup & Disaster Recovery (DR)
  • Design, implement, and maintain DR methodologies, ensuring documentation is up to date.
  • Periodically validate Oracle 19c backup/recovery operations using RMAN.
  • Assume responsibility for documenting and maintaining disaster recovery plans for each supported system.
Technical Leadership & Mentorship
  • Research, evaluate, design, test, and recommend new database software versions and related tools.
  • Act as a mentor for junior DBAs and provide technical guidance.
  • Assist development teams in improving database design and PL/SQL best practices.
On-Call & Availability
  • Provide 24/7 on-call rotational support, including occasional weekend coverage.
  • Familiarity with monitoring tools like DataDog, Solarwinds, site24/7 or OEM.

Qualifications

  • 10+ years of experience with Oracle 19c+ administration.
  • 3+ years of experience with MS SQL 2012+ and PostgreSQL.
  • Hands-on experience using Solarwinds as a monitoring tool is essential.
  • Strong expertise in PL/SQL coding, debugging, and query optimization.
  • Proficiency in Linux system administration and bash scripting.
  • Experience with Microsoft Azure Cloud, Azure SQL, and PowerShell scripting.
  • Strong knowledge of infrastructure design, security best practices, and compliance.
  • Experience with high-availability database solutions (clustering, replication, failover strategies).
  • Excellent problem-solving and troubleshooting skills.
  • Strong communication and collaboration abilities.
  • Ability to work independently and as part of a cross-functional team.

Salary Range

The salary range in United States of America for this position is 99,000.00 to 124,000.00 USD Annual. Your specific offer within this range will be determined by your skills, experience, and qualifications. For non-sales roles, you may be eligible for a bonus. For sales roles, this range includes a commission target. We are committed to pay transparency and fair compensation practices. If you have questions about our compensation approach, please don't hesitate to ask during the interview process.

Additional Information

All your information will be kept confidential according to EEO guidelines. Learn more about our high-energy, high-performance global team: Work With Us insightsoftware About Us: Hear From Our Team. Background checks are required for employment with insightsoftware, where permitted by country, state/province. At insightsoftware, we are committed to equal employment opportunity regardless of race, color, ethnicity, ancestry, religion, national origin, gender, sex, gender identity or expression, sexual orientation, age, citizenship, marital or parental status, disability, veteran status, or other class protected by applicable law. We are proud to be an equal opportunity workplace.

Key skills/competency

  • Senior Oracle DBA
  • Database Administration
  • SQL Server
  • PostgreSQL
  • PL/SQL
  • Linux System Administration
  • Bash Scripting
  • Azure Cloud
  • Backup and Disaster Recovery
  • Database Security

Skills & topics

  • Oracle DBA
  • Database Administration
  • SQL Server
  • PostgreSQL
  • PL/SQL
  • Linux
  • Bash Scripting
  • Azure
  • Disaster Recovery
  • Security
  • Performance Tuning
  • DBA

How to get hired

  • Tailor your resume: Highlight your 10+ years of Oracle DBA experience and 3+ years with MS SQL/PostgreSQL, emphasizing Oracle 19c+, PL/SQL, and Linux skills.
  • Showcase expertise: Quantify achievements in database administration, performance tuning, security, and disaster recovery, aligning with SOC2/ISO27001 compliance.
  • Demonstrate technical skills: Mention proficiency in RHEL/OEL OS, bash scripting, Solarwinds monitoring, and Azure Cloud experience.
  • Prepare for interviews: Be ready to discuss complex troubleshooting scenarios, database design, PL/SQL best practices, and mentorship experience.
  • Understand the role: Research insightsoftware's solutions and how your DBA expertise contributes to their customer-facing data infrastructure.

Technical preparation

Master Oracle 19c+ administration and RMAN.,Practice PL/SQL coding and query optimization.,Scripting: enhance bash and learn PowerShell.,Study Azure SQL and high-availability solutions.

Behavioral questions

Describe a complex database performance issue.,How do you mentor junior team members?,Share an experience with disaster recovery planning.,How do you handle critical alerts 24/7?

Frequently asked questions

What are the core database technologies for the Senior Oracle DBA role at insightsoftware?
The Senior Oracle DBA role at insightsoftware primarily focuses on Oracle 19c+ administration. Additionally, you will need at least 3 years of experience with MS SQL (2012+) and PostgreSQL. Proficiency in PL/SQL is crucial for coding, debugging, and query optimization.
What operating system and scripting skills are required for this Senior Oracle DBA position?
This role requires proficiency in RHEL/OEL OS administration to support Oracle databases. Strong bash scripting skills are essential for automating database tasks. Experience with PowerShell scripting is also beneficial, especially with Microsoft Azure Cloud integration.
Does the Senior Oracle DBA role at insightsoftware involve on-call responsibilities and monitoring tools?
Yes, the Senior Oracle DBA role includes providing 24/7 on-call rotational support, which may involve occasional weekend coverage. Familiarity with monitoring tools such as DataDog, Solarwinds, site24/7, or OEM is required, with hands-on experience using Solarwinds being essential.
What are the key responsibilities regarding infrastructure and security for this DBA role?
As a Senior Oracle DBA at insightsoftware, you will lead the design and implementation of database infrastructure, manage technical controls for security policies, and ensure compliance with SOC2/ISO27001 audits. This includes documenting and maintaining disaster recovery plans.
What level of experience is expected for the Senior Oracle DBA position at insightsoftware?
The ideal candidate for the Senior Oracle DBA position should have over 10 years of hands-on experience as an Oracle Administrator, specifically with Oracle 19c+. Additionally, at least 3 years of experience with MS SQL and PostgreSQL is required.
Are there opportunities for technical leadership and mentorship in this Senior Oracle DBA role?
Yes, this role offers technical leadership and mentorship opportunities. You will act as a mentor for junior DBAs, provide technical guidance, and assist development teams in improving database design and PL/SQL best practices.
What cloud experience is relevant for the Senior Oracle DBA at insightsoftware?
Experience with Microsoft Azure Cloud, including Azure SQL, is a significant asset for this Senior Oracle DBA role. This aligns with the company's need for cloud-based database solutions and integrations.