What are the responsibilities and job description for the Oracle DBA - Sr. position at AllSTEM Connections?
Job Title: Senior Database Administrator (Oracle & AWS Cloud)
Role Overview
We are seeking an expert-level Senior Database Administrator to oversee the end-to-end administration of complex Oracle, PostgreSQL, and SQL Server environments. This is a high-impact role responsible for ensuring high availability, security, and optimal performance across both on-premises and AWS cloud infrastructures. The ideal candidate is a technical leader who can bridge the gap between traditional database management and modern cloud automation.
Key Responsibilities
Multi-Platform Administration: Lead the installation, configuration, patching, and migration of Oracle and PostgreSQL systems, with supporting knowledge of SQL Server.
Cloud Architecture & Migration: Manage and support AWS RDS (Oracle, PostgreSQL, SQL Server) and Aurora instances. Implement automation using CloudWatch, Lambda, IAM, and
Terraform/CloudFormation.
Performance Tuning: Diagnose and resolve complex performance issues involving SQL tuning, indexing strategies, AWR, OEM, and cloud-native monitoring tools.
High Availability & DR: Architect and maintain robust HA/DR solutions, including Oracle RAC, Data Guard, and multi-AZ replication. Develop and test comprehensive failover procedures.
Security & Compliance: Enforce strict database security standards, including encryption, auditing, and vulnerability remediation, ensuring alignment with corporate data retention policies.
Automation & Scripting: Reduce operational overhead by automating repetitive tasks using Python, Shell scripting, or PL/SQL.
Production Support: Provide advanced troubleshooting for critical production incidents and participate in a 24x7 on-call rotation for mission-critical systems.
Mentorship: Provide technical guidance to junior DBAs and partner with DevOps teams to design scalable, cloud-ready data solutions.
Qualifications & Requirements
Experience: Minimum 8 years of Senior DBA experience across Oracle and PostgreSQL.
Technical Mastery: Proven expertise in RMAN, pgBackRest, and AWS Backup strategies.
Cloud Proficiency: Deep experience in AWS ecosystems (RDS, Aurora, Systems Manager, KMS).
Education: Bachelor's Degree in Computer Science, Information Systems, or a related technical field.
Communication: Ability to translate complex technical root-cause analysis into actionable documentation for stakeholders.
Availability: Must be able to work on-site in the East Bay 2-3 days per week, starting with an on-site presence on Day 1. Equal Opportunity Employer / Disabled / Protected Veterans
The Know Your Rights poster is available here:
_EEOC_KnowYourRights6.12.pdf
The pay transparency policy is available here:
_ English_formattedESQA508c.pdf
For temporary assignments lasting 13 weeks or longer, AllSTEM Connections is pleased to offer major medical, dental, vision, 401k and any statutory sick pay where required.
We are committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation for any part of the employment process, please contact your staffing representative who will reach out to our HR team.
AllSTEM Connections participates in the E-Verify program in certain locations as required by law. Learn more about the E-Verify program.
_Participation_Poster_ES.pdf
We also consider for employment qualified applicants regardless of criminal histories, consistent with legal requirements, including, if applicable, the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance. Pursuant to applicable state and municipal Fair Chance Laws and Ordinances, we will consider for employment-qualified applicants with arrest and conviction records, including, if applicable, the San Francisco Fair Chance Ordinance. For Los Angeles, CA applicants: Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.
Additional Skills
(none specified)
AllSTEM Representative Contact Info
Account Executive:
Nichols
Branch Phone:
Location:
Ontario, CA
Role Overview
We are seeking an expert-level Senior Database Administrator to oversee the end-to-end administration of complex Oracle, PostgreSQL, and SQL Server environments. This is a high-impact role responsible for ensuring high availability, security, and optimal performance across both on-premises and AWS cloud infrastructures. The ideal candidate is a technical leader who can bridge the gap between traditional database management and modern cloud automation.
Key Responsibilities
Multi-Platform Administration: Lead the installation, configuration, patching, and migration of Oracle and PostgreSQL systems, with supporting knowledge of SQL Server.
Cloud Architecture & Migration: Manage and support AWS RDS (Oracle, PostgreSQL, SQL Server) and Aurora instances. Implement automation using CloudWatch, Lambda, IAM, and
Terraform/CloudFormation.
Performance Tuning: Diagnose and resolve complex performance issues involving SQL tuning, indexing strategies, AWR, OEM, and cloud-native monitoring tools.
High Availability & DR: Architect and maintain robust HA/DR solutions, including Oracle RAC, Data Guard, and multi-AZ replication. Develop and test comprehensive failover procedures.
Security & Compliance: Enforce strict database security standards, including encryption, auditing, and vulnerability remediation, ensuring alignment with corporate data retention policies.
Automation & Scripting: Reduce operational overhead by automating repetitive tasks using Python, Shell scripting, or PL/SQL.
Production Support: Provide advanced troubleshooting for critical production incidents and participate in a 24x7 on-call rotation for mission-critical systems.
Mentorship: Provide technical guidance to junior DBAs and partner with DevOps teams to design scalable, cloud-ready data solutions.
Qualifications & Requirements
Experience: Minimum 8 years of Senior DBA experience across Oracle and PostgreSQL.
Technical Mastery: Proven expertise in RMAN, pgBackRest, and AWS Backup strategies.
Cloud Proficiency: Deep experience in AWS ecosystems (RDS, Aurora, Systems Manager, KMS).
Education: Bachelor's Degree in Computer Science, Information Systems, or a related technical field.
Communication: Ability to translate complex technical root-cause analysis into actionable documentation for stakeholders.
Availability: Must be able to work on-site in the East Bay 2-3 days per week, starting with an on-site presence on Day 1. Equal Opportunity Employer / Disabled / Protected Veterans
The Know Your Rights poster is available here:
_EEOC_KnowYourRights6.12.pdf
The pay transparency policy is available here:
_ English_formattedESQA508c.pdf
For temporary assignments lasting 13 weeks or longer, AllSTEM Connections is pleased to offer major medical, dental, vision, 401k and any statutory sick pay where required.
We are committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation for any part of the employment process, please contact your staffing representative who will reach out to our HR team.
AllSTEM Connections participates in the E-Verify program in certain locations as required by law. Learn more about the E-Verify program.
_Participation_Poster_ES.pdf
We also consider for employment qualified applicants regardless of criminal histories, consistent with legal requirements, including, if applicable, the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance. Pursuant to applicable state and municipal Fair Chance Laws and Ordinances, we will consider for employment-qualified applicants with arrest and conviction records, including, if applicable, the San Francisco Fair Chance Ordinance. For Los Angeles, CA applicants: Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.
Additional Skills
(none specified)
AllSTEM Representative Contact Info
Account Executive:
Nichols
Branch Phone:
Location:
Ontario, CA
Salary : $187,200