Database Administrator (DBA) - III

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

Microsoft Windows
IBM AIX
Unix
Configuration Management
Software Documentation
Databases
System Configuration
Data Infrastructure
Data Loss
Data Recovery
Database Design
Database Security
Database Storage Structures
Linux
Disaster Recovery
Network Protocols
Oracle Applications
Performance Tuning
Ansible
Standard Sql
Recovery Manager (RMAN)
Shell Script
PL-SQL
Oracle Enterprise Manager
System Availability
Database Performance
Data Management
Database Monitoring

Job description

We are seeking a seasoned Senior Database Administrator (DBA) - III to provide high-level technical support, architecture design, and problem management for critical, complex enterprise databases. In this role, you will be responsible for the end-to-end lifecycle of our data infrastructure-including complex installations, customizations, proactive tuning, and strict security administration. You will collaborate on strategic infrastructure planning, formulate requirements for new database systems, and leverage automation to optimize system delivery. The ideal candidate is an expert in Oracle high-availability environments who applies a disciplined risk-management approach to system changes., Database Infrastructure & High Availability Installation & Configuration: Lead complex installation, configuration, patching, and customization of the Oracle Relational Database Management System (RDBMS). Cluster Management: Administer and troubleshoot Oracle Clusterware (CRS) concepts, configurations, and complex multi-node environments. Disaster Recovery: Configure and maintain Data Guard environments; execute seamless switchovers and failovers to ensure maximum uptime and zero data loss. Strategic Architecture: Assist in long-term strategic planning, database design, and structure optimization; provide expert recommendations on functional and business requirements.

Operations, Performance & Security Performance Tuning: Perform advanced problem analysis for complex configurations, executing proactive database monitoring and deep-dive tuning to optimize critical workloads. Backup & Recovery: Own the backup and recovery mechanisms using RMAN, ensuring strict adherence to enterprise data protection policies. Security & Patching: Support Patch Set Update/Release Update (PSU/RU) patching; implement robust database security controls and manage access permissions. System Automation: Script and automate core Oracle functions using shell scripting and Ansible playbook deployment.

Project Delivery & Governance System Migration: Analyze existing database structures, formulate transition/implementation plans, and guide users through the adoption of upgraded systems. Risk Management: Apply a disciplined risk-management framework to all database decisions and system modifications to minimize organizational vulnerability. Collaborative Support: Partner with infrastructure teams (Linux/AIX, Unix, Storage, and Windows) to align database performance with hardware and network capacity.

Requirements

Experience: Seasoned professional with deep, hands-on enterprise DBA experience and a comprehensive understanding of core database principles. Technical Mastery: oExpert-level knowledge of SQL and PL/SQL, database packages, and relational structures. oIn-depth experience with Oracle Enterprise Manager (OEM) administration. oPractical knowledge of Linux/AIX systems administration, network protocols, and enterprise storage arrays. oIntermediate-level proficiency with Ansible for configuration management and automation. Soft Skills: oExceptional interpersonal, negotiation, and communication skills tailored for technical and business audiences. oMeticulous attention to detail regarding database compliance, change management, and system documentation. oAbility to work effectively under direction while confidently making independent decisions within widely accepted industry standards.

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