Oracle DBA with DB expertise//On-Site role
Jobs via Dice, Minneapolis, Minnesota, United States, 55400
Location
Minneapolis, MN
Duration 12+ Months (On-site)
Oracle DBA with DB expertise Oracle DBA with DB expertise
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
Essential Skills Oracle DBA with DB expertise
Desirable Skills No additional specific items listed.
Keyword Skills: Database Administration (DBMS)~Oracle DBA
Experience Required 10 & Above
#J-18808-Ljbffr
Duration 12+ Months (On-site)
Oracle DBA with DB expertise Oracle DBA with DB expertise
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
Essential Skills Oracle DBA with DB expertise
Desirable Skills No additional specific items listed.
Keyword Skills: Database Administration (DBMS)~Oracle DBA
Experience Required 10 & Above
#J-18808-Ljbffr