Database Administrator (Oracle & AWS Cloud)

AllSTEM Connections
Ontario, United States of America
2 days ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Ontario, United States of America

Tech stack

Amazon Web Services (AWS)
Cloud Computing
Cloud Engineering
Information Systems
Databases
Data Systems
Database Security
Oracle Data Guard
DevOps
Monitoring of Systems
Identity and Access Management
Python
PostgreSQL
Microsoft SQL Server
Oracle Applications
Oracle Rac
Performance Tuning
Recovery Manager (RMAN)
Shell Script
PL-SQL
Software Vulnerability Management
Enterprise Data Management
System Availability
Database Optimization
Cloudformation
Amazon Web Services (AWS)
Information Technology
Functional Programming
Cloudwatch
Terraform
Multiplatform
Sql Tuning

Job description

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., 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.

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

About the company

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.

Apply for this position