Senior DBA

Q1 Technologies, Inc.
Aurora, IL, United States
6 days ago
Apply on www.thejobnetwork.com
Prepare application

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
8 years minimum
Compensation
$124,800
Working hours
Regular working hours

Tech stack

Computer Networks Databases Extract Transform Load (ETL) Database Security Oracle Data Guard Disaster Recovery Failover Oracle Databases Oracle (Applications) Oracle Rac Query Optimization Recovery Manager (RMAN)
+12 more
Shell Script PL-SQL SQL Databases Backup and Restore Enterprise Software Applications System Availability Database Performance Indexer Database Migration Oracle Cloud Infrastructure Sql Tuning User Accounts

Job description

Responsible for administration, reliability, and optimization of Oracle database environments supporting enterprise applications. Core Responsibilities

  • Administer Oracle databases (11g/12c/19c/OCI, etc.)
  • Manage patching, upgrades, and lifecycle operations
  • Ensure availability and resiliency (e.g., RAC, Data Guard where applicable)
  • Perform backup and recovery operations
  • Monitor and optimize database performance and resource utilization
  • Support production releases and deployments
  • Implement security, access controls, and compliance requirements
  • Troubleshoot database issues and support incident response
  • Collaborate with application teams on schema and query optimization”, Responsible for administration, reliability, and optimization of Oracle database environments supporting enterprise applications. Core Responsibilities

  • Administer Oracle databases (11g/12c/19c/OCI, etc.)
  • Manage patching, upgrades, and lifecycle operations
  • Ensure availability and resiliency (e.g., RAC, Data Guard where applicable)
  • Perform backup and recovery operations
  • Monitor and optimize database performance and resource utilization
  • Support production releases and deployments
  • Implement security, access controls, and compliance requirements
  • Troubleshoot database issues and support incident response
  • Collaborate with application teams on schema and query optimization”

Role Descriptions: Install| configure| upgrade| and patch Oracle Database environments.Create and manage Oracle databases| tablespaces| schemas| tables| indexes| and views.Monitor and optimize database performance through SQL tuning| indexing| and resource management.Implement backup and recovery strategies using RMAN and recovery procedures.Ensure high availability and disaster recovery through Oracle Data Guard| RAC| and failover solutions.Manage database security| user accounts| roles| privileges| and auditing.Monitor database health| storage utilization| and capacity planning.Troubleshoot database errors| performance bottlenecks| and production issues.Configure and maintain Oracle networking components such as Oracle Net Listener and TNS.Perform database migration| cloning| refreshes| and data movement activities.Automate routine administration tasks using Shell Scripts| SQL| and PL/SQL.Support application teams during deployments and release activities.Manage Oracle RAC| ASM| Data Guard| and Multitenant databases (CDB/PDB).Ensure compliance with security| audit| and organizational standards.Prepare and maintain database documentation| SOPs| and operational procedures.Provide 24x7 production support and participate in on-call rotations.Work with infrastructure| application| and cloud teams for database reliability and scalability. Essential Skills: Install| configure| upgrade| and patch Oracle Database environments.Create and manage Oracle databases| tablespaces| schemas| tables| indexes| and views.Monitor and optimize database performance through SQL tuning| indexing| and resource management.Implement backup and recovery strategies using RMAN and recovery procedures.Ensure high availability and disaster recovery through Oracle Data Guard| RAC| and failover solutions.Manage database security| user accounts| roles| privileges| and auditing.Monitor database health| storage utilization| and capacity planning.Troubleshoot database errors| performance bottlenecks| and production issues.Configure and maintain Oracle networking components such as Oracle Net Listener and TNS.Perform database migration| cloning| refreshes| and data movement activities.Automate routine administration tasks using Shell Scripts| SQL| and PL/SQL.Support application teams during deployments and release activities.Manage Oracle RAC| ASM| Data Guard| and Multitenant databases (CDB/PDB).Ensure compliance with security| audit| and organizational standards.Prepare and maintain database documentation| SOPs| and operational procedures.Provide 24x7 production support and participate in on-call rotations.Work with infrastructure| application| and cloud teams for database reliability and scalability. Desirable Skills: Keyword

Requirements

”* Oracle RDBMS (on-prem OCI/cloud exposure)

  • PL/SQL, query optimization
  • Oracle HA/DR (RAC, Data Guard)
  • Performance diagnostics and tuning”

ESSENTIAL_SKILLS β€œ* At least 10 years of experience, including work with 30 TB databases handling 80,000 transactions per second.”

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.thejobnetwork.com
Prepare application

Good distractions

Loading talks and stories from around this role…