Job Title: Oracle DBA with DB expertise
Location: Minneapolis, MN
FTE Only
We are seeking an experienced Oracle Database Administrator to manage and optimize our enterprise database infrastructure. The ideal candidate will have deep expertise in Oracle database administration, complemented by working knowledge of IBM DB2, MongoDB, and Sybase to support our heterogeneous database environment. This role requires strong technical skills, performance tuning expertise, and a proactive approach to database management.
Experience
• 7+ years of hands-on Oracle DBA experience in enterprise production environments
• 2+ years of experience with at least two of: DB2, MongoDB, Sybase
• Experience managing mission-critical databases supporting 24/7 operations
• Experience with database migrations and consolidation projects
Technical Skills
Oracle Database (Expert Level):
• Versions: Oracle 11g, 12c, 19c, 21c (11g/12c legacy support, 19c/21c primary)
• High Availability: RAC (11g/12c/19c), Data Guard (Physical/Logical), Active Data Guard, GoldenGate
• Backup & Recovery: RMAN (expert), Flashback technologies, PITR, Incremental backups
• Performance Tuning: AWR, ADDM, ASH, SQL Tuning Advisor, SQL Plan Management, Execution Plans
• PL/SQL: Advanced PL/SQL programming, stored procedures, packages, triggers
• Architecture: Multitenant (CDB/PDB), ASM, Grid Infrastructure, Oracle Net Services
• Security: TDE, Database Vault, Label Security, Advanced Security, Audit Vault
• Partitioning: Range, List, Hash, Composite partitioning strategies
• Enterprise Manager: OEM Cloud Control 13c, monitoring, patching, provisioning
• Exadata: Experience with Oracle Exadata Database Machine (preferred)
• Cloud: Oracle Cloud Infrastructure (OCI), Oracle Autonomous Database (preferred)
IBM DB2 (Intermediate Level):
• DB2 for Linux/Unix/Windows (v10.5, v11.x)
• DB2 HADR configuration and management
• DB2 backup and recovery (BACKUP, RESTORE, ROLLFORWARD)
• DB2 performance monitoring (db2top, db2pd, snapshot monitoring)
• DB2 RUNSTATS, REORG, and maintenance
• DB2 SQL optimization and explain plans
• DB2 connection management and troubleshooting
• DB2 BLU Acceleration (columnar storage) awareness
• DB2 pureScale (basic knowledge)
MongoDB (Working Knowledge):
• MongoDB 4.x, 5.x, 6.x, 7.x deployment and configuration
• Replica sets and sharding architecture
• MongoDB backup strategies (mongodump, Ops Manager, Atlas Backup)
• MongoDB performance monitoring and optimization
• MongoDB indexing strategies
• Document-oriented data modeling
• MongoDB aggregation framework
• MongoDB security (authentication, authorization, encryption at rest/in transit)
• MongoDB Compass and monitoring tools
• MongoDB Atlas (cloud) basic knowledge
Sybase ASE (Basic Level):
• Sybase ASE 15.x, 16.x administration
• Sybase dump and load procedures
• Sybase device and segment management
• Sybase threshold monitoring
• Sybase sp_configure and configuration
• Sybase Replication Server (basic)
• isql command-line interface
• Sybase Central administration tool
Operating Systems:
• Linux: RHEL 7/8/9, Oracle Linux, CentOS, Ubuntu (advanced)
• Unix: Solaris, AIX, HP-UX (intermediate)
• Windows Server: 2016/2019/2022 (intermediate)
Backup & Recovery Tools:
• RMAN (Oracle Recovery Manager) - Expert
• Oracle Data Pump (expdp/impdp)
• Oracle Flashback technologies
• Veeam for Oracle (preferred)
• Commvault, NetBackup (preferred)
• DB2 backup utilities
• MongoDB backup tools
Monitoring & Management Tools:
• Oracle Enterprise Manager (OEM) Cloud Control
• SQL Developer, SQL*Plus, TOAD
• Grid Control, Database Control
• Toad for Oracle, Toad for DB2
• MongoDB Compass, Robo 3T
• Nagios, Zabbix, Prometheus, Grafana
• Splunk, ELK stack for log analysis
• AppDynamics, Dynatrace (application performance monitoring)
Additional Technical Skills:
• Oracle Data Integrator (ODI) - basic
• Oracle GoldenGate for replication
• Oracle Streams (legacy)
• RAC One Node
• Oracle Sharding
Preferred Qualifications
Certifications:
• Oracle (Highly Preferred):
o Oracle Certified Professional (OCP) - Database Administrator
o Oracle Certified Master (OCM) - Database Administrator (highly valued)
o Oracle RAC and Performance Management Certified Expert
o Oracle Database Cloud Administrator Certified Professional
• IBM DB2:
o IBM Certified Database Administrator - DB2
o IBM Certified Advanced Database Administrator - DB2
• MongoDB:
o MongoDB Certified DBA Associate
o MongoDB Certified Developer