Oracle DBA with DB expertise//On-Site role
Minneapolis MN
Duration : 12+ Months
Descriptions:
"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"
Oracle DBA with DB expertise
Essential Skills: Oracle DBA with DB expertise
Desirable Skills:
Keyword:
Skills: Database Administration (DBMS)~Oracle DBA
Experience Required: 10 & Above
Never miss an opportunity! Create an alert based on the job you applied for.
