Job Description
Database Administration & Operations:
Take charge of installing, configuring, upgrading, and maintaining PostgreSQL and Oracle database environments across all systems, including development, testing, staging, and production.
Manage database instances, schemas, users, and storage structures to ensure top-notch performance and reliability.
Continuously monitor and fine-tune database performance, identifying bottlenecks and implementing solutions to enhance throughput and response times.
High Availability, Backup & Recovery:
Design and oversee high-availability and disaster recovery solutions, such as replication, clustering, Data Guard, streaming replication, and failover strategies.
Establish and manage effective backup, recovery, and retention policies utilizing tools like RMAN for Oracle and pgBackRest or similar for PostgreSQL.
Conduct regular disaster recovery tests and meticulously document procedures.
Security & Compliance:
Implement robust database security policies, manage access controls, and ensure compliance with both organizational and regulatory standards.
Proactively apply patches, perform vulnerability assessments, and support audits by providing necessary database evidence and documentation.
Development & Optimization:
Collaborate closely with developers, architects, and application teams to design efficient database schemas, queries, indexes, and stored procedures.
Perform code reviews, conduct performance tuning, and optimize queries to elevate application performance.
Automate administrative tasks using scripting languages (such as Bash and Python) and leverage infrastructure-as-code tools.
Monitoring & Troubleshooting:
Implement and maintain comprehensive database monitoring and alerting solutions to proactively identify and resolve issues.
Provide advanced troubleshooting and root cause analysis for database incidents, including performance degradation and outages.
Participate in a 24/7 on-call support rotation and planned maintenance activities.
Responsibilities Required: Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience).
7+ years
of hands-on experience as a production DBA managing large-scale
PostgreSQL and Oracle
environments.
Proven experience with database installation, configuration, patching, backup/recovery, and performance tuning.
Expertise in replication, clustering, high availability, and disaster recovery solutions.
Strong skills in SQL and PL/pgSQL/PL/SQL, focusing on query optimization and indexing strategies.
Proficient in database monitoring and automation tools (e.g., Oracle Enterprise Manager).
Exceptional scripting skills (e.g., Bash, Python) for automation and operational tasks.
COMPTIA Security + CE or equivalent.
US DoD TS/SCI security clearance.
Preferred: Experience with database migrations, cloud platforms (AWS RDS, Azure Database, Oracle Cloud), or hybrid environments.
Familiarity with DevOps practices, CI/CD pipelines, and infrastructure-as-code tools (e.g., Ansible, Terraform).
Certifications such as
Oracle Certified Professional (OCP)
or
PostgreSQL Professional Certification
are highly desirable.
Soft Skills Excellent analytical and problem-solving abilities.
Strong communication and documentation skills, with a proven ability to collaborate effectively with cross-functional teams.
Ability to manage multiple priorities in a fast-paced, mission-critical environment.
Leadership mindset with mentoring capabilities and strategic thinking.
Disclaimer: Certain US customer or client-facing roles may be required to comply with applicable requirements, such as immunization and occupational health mandates. Range and benefit information provided in this posting are specific to the stated locations only. US: Hiring Range in USD from: $97,500 to $199,500 per annum. May be eligible for bonus and equity. Oracle maintains broad salary ranges for its roles in order to account for variations in knowledge, skills, experience, market conditions and locations, as well as reflect Oracle's differing products, industries and lines of business. Candidates are typically placed into the range based on the preceding factors as well as internal peer equity. Oracle US offers a comprehensive benefits package which includes the following: Medical, dental, and vision insurance, including expert medical opinion.
Short term disability and long term disability.
Life insurance and AD&D.
Supplemental life insurance (Employee/Spouse/Child).
Health care and dependent care Flexible Spending Accounts.
Pre-tax commuter and parking benefits.
401(k) Savings and Investment Plan with company match.
Paid time off: Flexible Vacation is provided to all eligible employees assigned to a salaried (non-overtime eligible) position. Accrued Vacation is provided to all other employees eligible for vacation benefits. For employees working at least 35 hours per week, the vacation accrual rate is 13 days annually for the first three years of employment and 18 days annually for subsequent years of employment. Vacation accrual is prorated for employees working between 20 and 34 hours per week. Employees working fewer than 20 hours per week are not eligible for vacation.
11 paid holidays.
Paid sick leave: 72 hours of paid sick leave upon date of hire. Refreshes each calendar year. Unused balance will carry over each year up to a maximum cap of 112 hours.
Paid parental leave.
Adoption assistance.
Employee Stock Purchase Plan.
Financial planning and group legal.
Voluntary benefits including auto, homeowner and pet insurance.
The role will generally accept applications for at least three calendar days from the posting date or as long as the job remains posted. Career Level - IC4 About Us As a world leader in cloud solutions, Oracle uses tomorrow's technology to tackle today's challenges. We've partnered with industry leaders in almost every sector and continue to thrive after 40+ years of change by operating with integrity. We know that true innovation starts when everyone is empowered to contribute. That's why we're committed to growing an inclusive workforce that promotes opportunities for all. Oracle careers open the door to global opportunities where work-life balance flourishes. We offer competitive benefits based on parity and consistency and support our people with flexible medical, life insurance, and retirement options. We also encourage employees to give back to their communities through our volunteer programs. We're committed to including people with disabilities at all stages of the employment process. If you require accessibility assistance or accommodation for a disability at any point, let us know. Oracle is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans' status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.
Take charge of installing, configuring, upgrading, and maintaining PostgreSQL and Oracle database environments across all systems, including development, testing, staging, and production.
Manage database instances, schemas, users, and storage structures to ensure top-notch performance and reliability.
Continuously monitor and fine-tune database performance, identifying bottlenecks and implementing solutions to enhance throughput and response times.
High Availability, Backup & Recovery:
Design and oversee high-availability and disaster recovery solutions, such as replication, clustering, Data Guard, streaming replication, and failover strategies.
Establish and manage effective backup, recovery, and retention policies utilizing tools like RMAN for Oracle and pgBackRest or similar for PostgreSQL.
Conduct regular disaster recovery tests and meticulously document procedures.
Security & Compliance:
Implement robust database security policies, manage access controls, and ensure compliance with both organizational and regulatory standards.
Proactively apply patches, perform vulnerability assessments, and support audits by providing necessary database evidence and documentation.
Development & Optimization:
Collaborate closely with developers, architects, and application teams to design efficient database schemas, queries, indexes, and stored procedures.
Perform code reviews, conduct performance tuning, and optimize queries to elevate application performance.
Automate administrative tasks using scripting languages (such as Bash and Python) and leverage infrastructure-as-code tools.
Monitoring & Troubleshooting:
Implement and maintain comprehensive database monitoring and alerting solutions to proactively identify and resolve issues.
Provide advanced troubleshooting and root cause analysis for database incidents, including performance degradation and outages.
Participate in a 24/7 on-call support rotation and planned maintenance activities.
Responsibilities Required: Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience).
7+ years
of hands-on experience as a production DBA managing large-scale
PostgreSQL and Oracle
environments.
Proven experience with database installation, configuration, patching, backup/recovery, and performance tuning.
Expertise in replication, clustering, high availability, and disaster recovery solutions.
Strong skills in SQL and PL/pgSQL/PL/SQL, focusing on query optimization and indexing strategies.
Proficient in database monitoring and automation tools (e.g., Oracle Enterprise Manager).
Exceptional scripting skills (e.g., Bash, Python) for automation and operational tasks.
COMPTIA Security + CE or equivalent.
US DoD TS/SCI security clearance.
Preferred: Experience with database migrations, cloud platforms (AWS RDS, Azure Database, Oracle Cloud), or hybrid environments.
Familiarity with DevOps practices, CI/CD pipelines, and infrastructure-as-code tools (e.g., Ansible, Terraform).
Certifications such as
Oracle Certified Professional (OCP)
or
PostgreSQL Professional Certification
are highly desirable.
Soft Skills Excellent analytical and problem-solving abilities.
Strong communication and documentation skills, with a proven ability to collaborate effectively with cross-functional teams.
Ability to manage multiple priorities in a fast-paced, mission-critical environment.
Leadership mindset with mentoring capabilities and strategic thinking.
Disclaimer: Certain US customer or client-facing roles may be required to comply with applicable requirements, such as immunization and occupational health mandates. Range and benefit information provided in this posting are specific to the stated locations only. US: Hiring Range in USD from: $97,500 to $199,500 per annum. May be eligible for bonus and equity. Oracle maintains broad salary ranges for its roles in order to account for variations in knowledge, skills, experience, market conditions and locations, as well as reflect Oracle's differing products, industries and lines of business. Candidates are typically placed into the range based on the preceding factors as well as internal peer equity. Oracle US offers a comprehensive benefits package which includes the following: Medical, dental, and vision insurance, including expert medical opinion.
Short term disability and long term disability.
Life insurance and AD&D.
Supplemental life insurance (Employee/Spouse/Child).
Health care and dependent care Flexible Spending Accounts.
Pre-tax commuter and parking benefits.
401(k) Savings and Investment Plan with company match.
Paid time off: Flexible Vacation is provided to all eligible employees assigned to a salaried (non-overtime eligible) position. Accrued Vacation is provided to all other employees eligible for vacation benefits. For employees working at least 35 hours per week, the vacation accrual rate is 13 days annually for the first three years of employment and 18 days annually for subsequent years of employment. Vacation accrual is prorated for employees working between 20 and 34 hours per week. Employees working fewer than 20 hours per week are not eligible for vacation.
11 paid holidays.
Paid sick leave: 72 hours of paid sick leave upon date of hire. Refreshes each calendar year. Unused balance will carry over each year up to a maximum cap of 112 hours.
Paid parental leave.
Adoption assistance.
Employee Stock Purchase Plan.
Financial planning and group legal.
Voluntary benefits including auto, homeowner and pet insurance.
The role will generally accept applications for at least three calendar days from the posting date or as long as the job remains posted. Career Level - IC4 About Us As a world leader in cloud solutions, Oracle uses tomorrow's technology to tackle today's challenges. We've partnered with industry leaders in almost every sector and continue to thrive after 40+ years of change by operating with integrity. We know that true innovation starts when everyone is empowered to contribute. That's why we're committed to growing an inclusive workforce that promotes opportunities for all. Oracle careers open the door to global opportunities where work-life balance flourishes. We offer competitive benefits based on parity and consistency and support our people with flexible medical, life insurance, and retirement options. We also encourage employees to give back to their communities through our volunteer programs. We're committed to including people with disabilities at all stages of the employment process. If you require accessibility assistance or accommodation for a disability at any point, let us know. Oracle is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans' status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.