FIND PERSONALIZED JOBS
Sign up to Zippia and discover your career options with your personalized career search.
Sorry, we can't find that. Please try a different city or state.

Senior Oracle Database Administrator

This job has expired and is no longer available.
APPLY NOW
Apply Now
×
FIND
PERSONALIZED JOBS

Sorry, we can't find that. Please try a different city or state.

CONTENT HAS
BEEN UNLOCKED
Close this window to view unlocked content
or
find interesting jobs in

Log In

Log In to Save

Sign Up to Save

Sign Up to Dismiss

Sign Up

SIGN UP TO UNLOCK CONTENT

or

The email and password you specified are invalid. Please, try again.

Email and password are mandatory

Forgot Password?

Don't have an account? Sign Up

reset password

Enter your email address and we will send you a link to reset your password.

Back to Log In

Log In

Log In to Save

Sign Up to Save

Sign Up to Dismiss

Sign up to save the job and get personalized job recommendations.

Sign up to dismiss the job and get personalized job recommendations.

or

The email and password you specified are invalid. Please, try again.

Email and password are mandatory

Already have an account? Log in

reset password

Enter your email address and we will send you a link to reset your password.

Back to Log In

Company Saved

Answer a few questions and view jobs at that match your preferences.

Where do you want to work?

Job Saved

See your Saved Jobs now

or

find more interesting jobs in

Job Dismissed

Find better matching jobs in

Your search has been saved!

Top 50 Senior Oracle Database Administrator Skills

Below we've compiled a list of the most important skills for a Senior Oracle Database Administrator. We ranked the top skills based on the percentage of Senior Oracle Database Administrator resumes they appeared on. For example, 16.0% of Senior Oracle Database Administrator resumes contained Database as a skill. Let's find out what skills a Senior Oracle Database Administrator actually needs in order to be successful in the workplace.

These are the most important skills for a Senior Oracle Database Administrator:

1. Database

demand arrow
high Demand
Here's how Database is used in Senior Oracle Database Administrator jobs:
  • Create Database maintenance plans, including updating statistics, re-indexing, structure modification, index.
  • Worked on configuring online change synchronization between the source and target database.
  • Worked in implementing Access request process across Devon for Oracle databases.
  • Installed 11.2.0.4 software along with SBP Patch for SAP databases.
  • Upgrade lower environment databases from 11.2.0.4 to 12.1.0.1 on RAC.
  • Disable and decommission DR databases from production when needed.
  • Worked on implementing patching for 11.2.0.4 databases.
  • Convert RAC databases to Single-Instance databases.
  • Developed and implemented processes and scripts to generate and save database metadata before database deployments.
  • Migrated databases from Windows to Linux using transportable tablespaces.
  • Developed periodic AD refreshes of relevant user information from the AD server to oracle databases for database users' auditing.
  • Worked with development team to work out complete database design and capacity planning for new database projects and enhancements.
  • Worked on moving Oracle 10g database of a Specialty company which Cardinal bought into Oracle 11g Exadata.
  • Installed and configured multiple Oracle 9i/10g/11g/12c standalone databases on RedHat Linux and Windows environment.
  • Generate health check report on rac databases and troubleshoot them on monthly basis.
  • Perform databases upgrades using dbua utility from 11.2.0.3 to 11.2.0.4.
  • Involved in configuring container and pluggable database in Oracle 12c.
  • Configured Oracle Database Appliance (X5-2) 12c (12.1.2.2) Clusterware.
  • Worked on databases consolidation into a single database in Exadata.
  • Worked on patching of RAC Clusterware and Database to latest patchsets.

Show More

187 Database Jobs

No jobs at selected location

2. Recovery Procedures

demand arrow
high Demand
Here's how Recovery Procedures is used in Senior Oracle Database Administrator jobs:
  • Optimize and ensure practicality of (hot/cold/export/export) backup and recovery procedures.
  • Assisted in configuring disaster recovery procedures using Standby Data Guard setup.
  • Tested Disaster Recovery procedures on Oracle Application Servers and Databases.
  • Developed, tested, and documented Oracle disaster recovery procedures.
  • Created backup/recovery procedures for Oracle Database.
  • Implemented Backup & Recovery procedures.
  • Performed large size Database Backup including Physical backup through Hot Backup/Cold Backup of DEVELOP/TEST/PRDOCTION Databases and Recovery Procedures by using RMAN.
  • Implement backup and recovery procedures using (RMAN) for Oracle databases and test regularly in conjunction with Operations.
  • Designed, documented, implemented and maintained all disaster recovery procedures which result in no data loss.
  • Develop tests and maintain disaster recovery procedures and documentation for area(s) of responsibility.
  • Design, document, implement, and maintain all backup, recovery including disaster recovery procedures.
  • Implemented backup and recovery procedures (Cold/Hot backups, RMAN Incremental backups & Import/Export).
  • Implemented backup and recovery procedures using RMAN on Oracle 10g/11g to tape drives, disks.
  • Design and test Backup and Recovery procedures for Oracle databases and application servers.
  • Involved in database designs, creating backup and recovery procedures, cloning database.
  • Implemented and tested Oracle RMAN back up and recovery procedures.
  • Experience working on RMAN Backups and recovery procedures.
  • Installed and Implemented Backup & Recovery procedures.
  • Developed disaster recovery procedures for Lawson Financials and Oracle 11g database.
  • Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups.

Show More

3. Rman

demand arrow
high Demand
Here's how Rman is used in Senior Oracle Database Administrator jobs:
  • Prepared test environments for backup/recovery using RMAN and Recovering Databases when there is any physical or Logical Corruption.
  • Collected performance statistics memory usage, data storage.
  • Configured OEM 12c Grid control to monitor database performance, SQL query tuning, create monitor block, and deployed plugins.
  • Restored database on different server with same or different file system using RMAN technology.
  • Performed Table, Index Partitions for increased performance and for better storage management.
  • Monitored Performance of databases and Administrated user security of MS SQL 2005.
  • Involved in active cloning a database through RMAN for testing database patches.
  • Monitored the GoldenGate processes, checking the performance using the GoldenGate Director.
  • Identified performance bottlenecks and performed performance tuning of SQL SERVER.
  • Migrate databases from Windows to Linux 64 bit via RMAN.
  • Cloned databases using RMAN as per the requirement.
  • Restore and recover databases through RMAN when needed.
  • Used RMAN to cloned and duplicated databases.
  • Perform Oracle RMAN test and recovery.
  • Refreshed the databases from PROD to UAT, QA, and DEV using RMAN.
  • Performed database Migration from Windows platform to Linux using RMAN (Convert) and Datapump.
  • Monitor, troubleshoot rman level 0, incremental backups, archive log backups via OEM.
  • Performed refreshes, cloning using RMAN & moving out DBs across different servers.
  • Refresh lower environments from production backups using rman backups.
  • Build RMAN scripts for Backup , Database monitor & performance tuning Setup scripts for Database cloning by using RMAN.

Show More

35 Rman Jobs

No jobs at selected location

4. Pl/Sql

demand arrow
high Demand
Here's how Pl/Sql is used in Senior Oracle Database Administrator jobs:
  • Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.
  • Developed major new modules for the existing RxHome enterprise system using Oracle Forms, Oracle Reports, and PL/SQL.
  • Experience working with SQL, PL/SQL coding, stored procedures, functions, packages, triggers.
  • Worked extensively with packages, SQL and Pl/SQL codes in test and development environments.
  • Involved in the optimization of various SQL and PL/SQL using EXPLAIN PLAN and TKPROF.
  • Work also involved DSA UI modification that required PL/SQL and Java Code development.
  • Involved in writing and modifying PL/SQL procedures and functions used in Java scripts.
  • Converted PL/SQL Procedures, Functions and Packages to SQL Server Stored Procedures.
  • Shell Scripting and PL/SQL Programming to resolve business problems of various nature.
  • Implemented changes to database including triggers, PL/SQL procedures and packages.
  • Worked with application developers to debug PL/SQL procedures, tune queries.
  • Experience on SQL, PL/SQL in writing queries and procedures.
  • Developed scripts and reports using SQL, PL/SQL and Perl.
  • Maintain Oracle SQL and PL/SQL scripts, Unix Shell Scripts, debugging and tuning.
  • Write PL/SQL programs (Procedures / Functions / Triggers / Packages).
  • Developed shell scripts and PL/SQL procedures and scheduled Cron jobs and DBMS_JOBS to monitor the database performance and for user management.
  • Developed SQL, PL/SQL, Unix shell script codes to automate data exchange from one system to another.
  • Write and troubleshoot shell scripting, SQL,, and PL/SQL scripts.
  • Implemented 11g Standby database setups, Active Dataguard Developed and maintained PL/SQL Stored Procedures, Packages and Functions.
  • Created various Database triggers using PL/SQL Experience in Patching and Upgrade Experience in MySQL database.

Show More

5. SQL Trace

demand arrow
high Demand
Here's how SQL Trace is used in Senior Oracle Database Administrator jobs:
  • Frequent interaction with Developers, and working with them in developing the applications using SQL Trace and Explain Plan utilities.
  • Used online redefinition from partitioning large table to run SQL's in definite time window using SQL trace.
  • Involved in identifying Performance bottlenecks in the application and find out the cause using SQL Trace files.
  • Analyzed and tuned database performance using STATSPACK, SQL Trace, Explain Plan, TKPROF, etc.
  • Used SQL Trace and TKPROF for application tracing for Instance, Session and Module levels.
  • Experience in working on TKPROF, Explain Plan and SQL Trace for Performance Tuning.
  • Identified SQL statements with poor performance using Performance Tools and SQL Trace tools.
  • Tuned SQL statements using explain plan and SQL trace.
  • Analyzed and solved Performance issues by generating reports AWR, ADDM, ASH, SQL TRACE and TKPROF.
  • Identify and tune poor SQL statements using EXPLAIN PLAN, Hints, SQL TRACE, and TKPROF.
  • Used to TRACE sessions using SQL TRACE & TKPROF for poorly performing queries.
  • Tuned SQL queries using TKPROF, EXPLAIN PLAN, and SQL TRACE.
  • Utilized OEM/Cloud Control, SQL trace, Statspack/AWR report to conduct database system and application optimization and performance tuning with signification improvement
  • Worked with developers to optimize SQL queries using Statspack, TKPROF, Explain Plan & SQL Trace.
  • Performed SQL Tuning using explain plan, TKPROF with SQL trace and SQL Tuning Advisor.
  • Tuned and optimized stored procedure written in PL/SQL using SQL trace, Profiler and StatsPack.
  • Tuned database using Explain Plan, Tkprof, SQL Trace, session Trace.
  • Experienced in dealing with Query execution plan, SQL trace, TKprof.
  • Monitored database performance using TKPROF, explain plan and sql trace.
  • Used Tkprof, Explain plan, hints, SQLT and SQL Trace utilities for SQL tuning.

Show More

Job type you want
Full Time
Part Time
Internship
Temporary

6. Linux

demand arrow
high Demand
Here's how Linux is used in Senior Oracle Database Administrator jobs:
  • Worked with senior DBA's for preparing cluster, configuring and Installation of Cluster ware and Oracle RAC on Linux.
  • Migrated applications from UNIX to Linux using golden gate with minimum down time and resolved issues in Golden Gate.
  • Experience on Oracle monitoring tools including Oracle Application Server monitoring and Oracle Linux monitoring using NMON and TOP commands.
  • Worked and coordinated with client management to formulate highly complex technical solutions for Oracle and Linux.
  • Manage 30+ server data center with mixture of UNIX, Linux and Windows Servers.
  • Installed and configured Oracle Warehouse Builder (OWB) 11.2.0.4 on Linux environment.
  • Migrated Oracle Databases from Windows to Linux and upgraded to 11.2.0.4 and 12c.
  • Supported, administered and installed upgrades of MySQL on Linux/SE Linux.
  • Installed Oracle 12c database on Linux in a test environment.
  • Installed RAC binaries and created six node environment in LINUX.
  • Installed on Oracle Enterprise Linux with Application Server 9.1..
  • Installed the fresh homes for 11.2.0.4 on Linux servers.
  • Shell scripting/Linux for MySQL automated processes.
  • Designed and installed Oracle High availability environment using Oracle data Guard, linux Clustering.
  • Utilized Oracle 10g and SQL Server 2005 databases supported on a Redhat Linux AS 2.1 / Microsoft Server 2003 environment.
  • Major Accomplishments: Implemented 10g OEM/Grid Control on Linux servers to host the management service and repository environments.
  • Installed and configured OAS 10.1.3 and OAS 10.1.2 on RedHat Linux and Windows environment.
  • Upgrade Oracle Databases to 11.2.0 on Sun Solaris and Linux Systems.
  • Installed and configured Weblogic 11g and 12c on RedHat Linux environment.
  • Performed Migration of databases [ ] on Solaris to Oracle [ ] on Linux.

Show More

8 Linux Jobs

No jobs at selected location

7. DBA

demand arrow
high Demand
Here's how DBA is used in Senior Oracle Database Administrator jobs:
  • Plan long-term goals and perform weekly maintenance and daily DBA duties such as physical and logical backups and root cause analysis.
  • Developed/customized UNIX shell scripts to automate routine DBA tasks like monitoring space and memory requirements and Memory tuning.
  • Provide DBA support for Oracle 8i, 9i, & 10g databases and develop data transformation SQL scripts.
  • Supported this environment in DBA role and designed and implemented the data migration strategy from legacy systems.
  • Served as Primary Remote DBA for a small consulting firm for dozens of clients remotely.
  • Shell scripting to automate the DBA daily routine work and free resources for future developments.
  • Established performance tuning best practices used by the DBA and Development teams.
  • Trained Aqua DBA's on how to configure and maintain.
  • Worked as a level 3 support Oracle DBA.
  • Mentored and trained several junior DBA's.
  • Trained 2 Devon employees on DBA activities.
  • Configure and test DBATOOLS jobs scripts.
  • Worked as a Sr. Oracle 11g and 12c core DBA at VMWARE Command and Control Center (VC3).
  • Support more than 30 Oracle 10g RAC/ASM, database instances as primary DBA (PROD/DR/QA/DEV).
  • Worked on On-Call and queue manager roles as part of the DBA team.
  • Provide development and production support related to database Perform other regular DBA activities including space management and performance monitoring.
  • Worked as Team Lead for GDBA MIGRATION TEAM * Did Binary installations for Oracle 11g in DCC servers.
  • Certified EPIC Cache ODBA: Monitor and support assigned database applications and services as required.
  • Provided support to Production DBAs during releases or some major database changes.
  • Performed full complement of Oracle Application DBA duties including performing autoclone, adadmin, autoconfig, adpatch, and admerge.

Show More

171 DBA Jobs

No jobs at selected location

8. OEM Grid

demand arrow
high Demand
Here's how OEM Grid is used in Senior Oracle Database Administrator jobs:
  • Experience in monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM grid) 10g /11g/12c.
  • Monitored/managed 2 node RAC environments, databases using OEM Grid control, and RMAN database backup and recovery.
  • Installed and Configured OEM, OEM Grid Control and OEM agents for 10g and 11g databases.
  • Demonstrated experience in managing Oracle 9i and 10g RAC environments using the OEM Grid Control tools.
  • Used OEM Grid Control Diagnostic and tuning packs to tune the application and SQL queries.
  • Installed and configured OEM Grid control and performed administration on databases.
  • Installed and configured OEM Grid Control and deployed Agents on target.
  • Utilized oracle 10g OEM grid to deploy software across multiple nodes.
  • Installed and configured OEM Grid Control to monitor all databases.
  • Configured and monitored various databases using OEM Grid Control.
  • Customized OEM Grid Control to manage production databases.
  • Maintain and Support Cloud Control/OEM Grid environment 10.
  • Installed and configured OEM Grid Control.
  • Administer RAC Database servers using SRVCTL, VIPCA, OEM Grid control, V$/GV$ views.
  • Experience in Oracle OEM Grid Control 12c.
  • Monitored the database performance using OEM Grid Control Configured the Golden Gate replication for the HA purpose.
  • Installed and upgraded OEM from 10.1.3 to 12c OEM Grid Control Itanium.
  • Configure and manageRMAN backup using OEM GRID.
  • Used JAGENT at server level and GG plugin at OEM grid level for Goldengate monitoring and also used cron scripts.
  • Worked on scheduling the automated jobs via OEM grid control, cron and autosys (using jil file).

Show More

1 OEM Grid Jobs

No jobs at selected location

9. ASM

demand arrow
high Demand
Here's how ASM is used in Senior Oracle Database Administrator jobs:
  • Performed daily DBA Activities such as monitoring RAC Nodes, ASM, databases using OEM, and own Linux scripts.
  • Configured and implemented Oracle ASM on Linux, UNIX and Windows platforms and maintained ASM instances and ASM disk Groups.
  • Worked with a team for installation and maintenance of ORACLE 10g RAC, ASM database for high availability.
  • Well conversed using the CRSCTL and SRVCTL tools for maintaining database, ASM and node applications.
  • Installed, configured Databases with ASM for billing systems, account detail databases.
  • Performed disk and disk group management in ASM while installing 11gR2 RAC.
  • Installed and configured oracle one node RAC for 11gR2 with ASM.
  • Installed, configured and monitored Oracle RAC11gR2 and 10gwith ASM.
  • Installed Patch for 11.2.0.4 and moved ASM to newer homes.
  • Implemented ASM on RAC and stand-alone databases.
  • Migrated ASM file system to ACFS.
  • Installed Oracle 10g, 11g RAC software with ASM & OCFS2 File systems.
  • Add, drop, and re-balance ASM disks using ASMCA.
  • Worked on building and rolling out new 12c RAC, CRS databases using ASM for Test/Dev/QA environments.
  • Migrated data to a new ASM Diskgroup to improve the IO performance of the database.
  • Configure ASM on both stand-alone as well as RAC databases during the built process.
  • Created and Rebalanced ASM disk and disk groups and maintained Oracle ASM instance.
  • Involved in the installation, configuration of multi node -- 2, 3, 4 Node Oracle 10g/11g RAC with ASM.
  • Created physical standby databases (ASM to NON ASM, Non ASM to ASM etc.
  • Set up stand by , failover , load balancing by using Oracle RAC, ASM, Data Guard.

Show More

3 ASM Jobs

No jobs at selected location

10. Solaris

demand arrow
high Demand
Here's how Solaris is used in Senior Oracle Database Administrator jobs:
  • Migrated Metadata Repository databases from Solaris to Windows.
  • Performed an upgrade of Oracle Apps 11.0.3 to 11.5.10.2 on Solaris which included three iterations and the go-live upgrade.
  • Installed Oracle 10g and 11g RAC database on Sun Solaris and utilized ASM as shared storage.
  • Support & Maintenance of Production, Development and Test Databases on various servers Solaris and HP.
  • Created 10.2.0.1 and 11.2.0.2 databases for Testing, Development and Production on Solaris 9.
  • Installed RAC 11gR1 on 2, two-nodes on Sun Solaris servers.
  • Migrated Oracle 10g databases from Solaris 10 to Windows 2003 servers.
  • Administered, configured Solaris, maintained all Sun hardware and software.
  • Installed Oracle Software 9i/10g on Windows and Sun Solaris platforms.
  • Upgraded Databases from Oracle 9i to Oracle 10g on Solaris.
  • Install and configure Oracle 8i/9i on Sun SPARC/Solaris servers.
  • Installed Oracle binaries on Sun Solaris for training group.
  • Worked on Windows 2003 & Sun Solaris O/S.
  • Configured and managed Oracle Solaris ZFS Database Overview.
  • Migrated 11g database from Solaris to Linux.
  • Installed 11gr2 Grid Infrastructure on Solaris.
  • Worked on Performance Tuning Oracle DBA (11g &10g) on Solaris 10, AIX 5.2.
  • Performed the database's migrations and upgrades from AIX/Solaris to Redhat Linux platforms as a cost effective measure.
  • Upgraded Oracle 10GRAC to Oracle 11GRAC on SUN Solaris.Configured Data Guard for disaster recovery.
  • Involved in the Solaris 10 migration projects which involves migrating 4 terabyte databases from Solaris 8 to Solaris 10 platform.

Show More

7 Solaris Jobs

No jobs at selected location

11. Unix

demand arrow
high Demand
Here's how Unix is used in Senior Oracle Database Administrator jobs:
  • Experienced in managing space issues in the Database Level for table space and Regular file system cleanup at UNIX level.
  • Developed backup plans and UNIX shell scripts for the database, database archive log files and operating system.
  • Supported Oracle environments hosted on servers ranging from Windows NT to Linux distributions to various UNIX installations.
  • Worked on UNIX Shell Scripts, PL/SQL Stored Procedures, Functions and Triggers.
  • Developed UNIX shell scripts for routine tasks which included monitoring and reports.
  • Reviewed and scheduled AutoSys jobs for UNIX and Windows systems.
  • Coordinate with UNIX administrators for space management on various servers.
  • Implemented necessary monitoring scripts for Golden gate in Unix/Perl scripting.
  • Used OID to create service accounts on Unix.
  • Developed UNIX shell scripts for database monitoring.
  • Support on call Environment: Oracle 11GR2, 10G, RAC, MS SQL Server, HP UNIX, Windows
  • Replicated application stack and application files using Rsync utility at Unix/Linux level.
  • Supervised a team of four DBAs and three Unix admins including hiring and appraisals.
  • Developed UNIX shell script to automate various DB jobs and send alert mails accordingly..
  • Installed & configured Weblogic server on UNIX platform and deployed applications.
  • Prepared the document for applying quarterly UNIX patch over several databases.
  • Worked on Export, import scripts using unix named pipes.
  • Created UNIX shell scripts to automate batch jobs through Cron.
  • Used Crontab in UNIX environment for scheduling routine tasks.
  • Implemented necessary monitoring scripts for GoldenGate in unix/perl scripting.

Show More

3 Unix Jobs

No jobs at selected location

12. AWR

demand arrow
high Demand
Here's how AWR is used in Senior Oracle Database Administrator jobs:
  • Performed Database and SQL tuning by using various Tools like STATSPACK, AWR, TKPROF, EXPLAINPLAN, and optimizer hints.
  • Involved in performance tuning by general health checks and maintenance of Database using AWR and ADDM reports by finding wait events.
  • Checked AWR reports on a regular basis and troubleshot and fixed any performance degradation if found in terms of DB waits.
  • Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.
  • Delivered Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, AWR, SQL TRACE.
  • Performed Load Tests and run AWR/ASH reports on staging environment (Database) to optimize the tuned parameters.
  • Resolved performance related issues for Database / Application AWR report/STATSPACK, SGA Tuning- Memory, Disk I/O tuning.
  • Analyze the critical production databases using OEM, ADDM, AWR, ASH and perform the tuning.
  • Experienced in generating AWR reports for multiple database environments manually and using scripts for various time intervals.
  • Worked with development team on Database Performance Tuning using AWR/ADDM/ASH and TKPROF and Explain Plan.
  • Developed custom scripts and implemented standard procedures to troubleshoot live production issues by AWR Data.
  • Performed database performance tuning using AWR, Grid Control, stats pack and SQL.
  • Used Oracle 11g/12c AWR & ADDM to monitor database activities and performance tuning.
  • Perform Oracle performance tuning and monitoring using Oracle OEM/AWR/Quest tools.
  • Monitored the database health using the OEM Grid ADDM, AWR and ASH Reports.
  • Use Oracle Grid Control for AWR, ADDM and other activities.
  • Involved in Database Performance Tuning using AWR/ADDM/ASH on RAC (also including ODA) and NON RAC databases.
  • Tuned databases leveraging AWR and ADDM to increase performance at the I/O and instance levels.
  • Performed and tuned using AWR, OEM Grid and tkprofetc Oracle Databases.
  • Perform SQL tuning by using AWR reports and SQL tuning advisor.

Show More

4 AWR Jobs

No jobs at selected location

13. High Availability

demand arrow
high Demand
Here's how High Availability is used in Senior Oracle Database Administrator jobs:
  • Involved in Design and implementation of oracle 11g Data Guard both physical/logical Standby databases for high availability and disaster recovery.
  • Worked with IT managers and application developers to ensure the database integrity, high availability and security.
  • Maintained Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
  • Implemented Oracle 10g Data Guard for high availability and maintained standby database for Disaster Recovery.
  • Experience ensuring the high availability and integrity of databases.
  • Configured high availability environments using Oracle Streams.
  • Implemented High availability using GoldenGate Replication.
  • Managed ASM and High Availability, monitor, install, configure, and maintain RAC 10g, 11g servers.
  • Experienced in maintaining high availability of databases for global operation using Oracle RAC and Data Guard/ Standby databases.
  • Implemented Oracle Data Guard 10g as Oracle's data protection, High Availability and disaster recovery solution.
  • Involved in designing of disaster recovery plan using Data Guard, and High Availability using RAC.
  • Experience in creating and managing physical and logical Standby database using Data guard for HIGH AVAILABILITY.
  • Configured High availability and set-up custom monitoring through Heart beat tables using Golden Gate.
  • Installed RMAN for backups with Data Guard for high availability reporting instance.
  • Migrated Non-ASM databases to ASM environment for high availability on 11g.
  • Conducted in-depth Linux Kernel and Oracle RAC component performance optimization and stabilized database instance with high availability and scalability design.
  • Implemented Golden Gate for Active-Active Replication between the Datacenter for High Availability.
  • Used high availability features of RAC like connection timeout failover, TAF, Client side/Server side load balancing.
  • Migrated single instance databases to multinode 10g RAC environment for high availability and load balancing.
  • Implemented Oracle database 12C RAC databases using Oracle Clusterware for achieving high Availability.

Show More

133 High Availability Jobs

No jobs at selected location

14. Automatic Storage

demand arrow
high Demand
Here's how Automatic Storage is used in Senior Oracle Database Administrator jobs:
  • Experience with Automatic Storage management implementation and also analyzing different problems including CSS related issues.
  • Configured Automatic Storage Management (ASM) for 11g RAC databases for reducing disk contention and providing centralized management for Disks.
  • Supported Automatic Storage Management (ASM) database and performed migration to normal database to ASM database using RMAN.
  • Handled individual project for ASM (Automatic Storage Management) migration in every 2 months for Linux servers.
  • Tested and documented some Oracle10g new features, such as Automatic Storage Management (ASM).
  • Worked on RAC on RHAS with 4 nodes server side load balancing using Automatic Storage Management.
  • Administered 10G RAC, 11G RAC databases and experienced with ASM (Automatic storage management).
  • Performed fresh installation of 11g RAC on Automatic Storage Management and created databases in RAC environment.
  • Configured and installed RAC One Node Production Databases with Automatic Storage Management (ASM).
  • Configured Automatic Storage Management (ASM) for 10g/11g RAC databases for reducing disk.
  • Implemented & Managed Physical Standby and even Configured Automatic Storage Management (ASM).
  • Supported offshore setup of Oracle 10g with Automatic Storage Management (ASM).
  • Worked on Automatic Storage Management (ASM) for managing data in SAN.
  • Administrated the automatic storage management (ASM) like adding the disk groups.
  • Converted Oracle traditional Storage structure into Automatic Storage Management (ASM).
  • Migrated file systems to ASM (Automatic Storage Management).
  • Configured Automatic Storage Management (ASM).
  • Implemented Automatic Storage Manager (ASM).
  • Implemented and configured GoldenGate on a 2-node RAC cluster Configured Automatic Storage Management (ASM) for 11g RAC databases.
  • Configured installed & supported 10g RAC on Sun clusters 3.2 Implemented Automatic Storage Manager (ASM).

Show More

1 Automatic Storage Jobs

No jobs at selected location

15. Setup

demand arrow
average Demand
Here's how Setup is used in Senior Oracle Database Administrator jobs:
  • Experienced in Golden Gate replication and extract setup for database migration using Unidirectional and Bidirectional methods.
  • Coordinated with the storage team to gather additional storage required on the servers and new mount points setup on the databases.
  • Installed OEM 11g, 12c and configured all RAC Nodes, Primary and standby databases and setup various monitoring alerts.
  • Provide Documentation, training and presentations to the client regarding the12C OEM interface, new features and configuration setup.
  • Worked on installing the data guard on RAC databases for disaster recovery and setup the broker.
  • Project: Installation, Setup, Maintenance and Upgrade of Oracle 9i to Oracle 12c,.
  • Worked with System Administrators in getting the hardware required for database setup in clustered environment.
  • Install, maintain and monitor Web Logic server as part of OEM Grid Control setup.
  • Work with OEM Grid control 11g for the monitoring, alerts and notification setup.
  • Implemented Real Application Cluster (RAC) Setup & Administration using Sun Cluster.
  • Experience in Data Guard Setup, RAC DG setup and FSFO configuration.
  • Worked on all setup required to run 11i Application and database.
  • Supported installation and setup of ORACLE Cluster's and RAC database.
  • Perform setup of maintenance jobs in AUTOSYS and promote jobs.
  • Performed database cloning to setup test, development database and Disaster Recovery Database using Physical Standby.
  • Performed database cloning to setup test and development database.
  • Implement, setup of physical Standby database using Dataguard in oracle for disaster recovery.
  • Experienced in administrating oracle databases, Golden Gate setups on Exadata X5 environments.
  • Installed Cognos ReportNet and Framework Manager, setup Cognos server.
  • Performed Golden Gate replication setup activities for Oracle-Oracle, Oracle-Sybase, Sybase- Oracle, Sybase - Sql databases.

Show More

5 Setup Jobs

No jobs at selected location

16. Toad

demand arrow
average Demand
Here's how Toad is used in Senior Oracle Database Administrator jobs:
  • Created stored procedures and triggers using PL/SQL for database managing utilizing TOAD developing environment.
  • Performed Tuning, coding and Monitoring for Oracle Real Application Clusters (RAC) nodes, Production Standalone Servers via Toad.
  • Configure database entries and Monitoring of all databases using OEM 10g/11g grid control and TOAD.
  • Experience in Toad (Tool for Oracle Application Developers) for database maintenance tasks.
  • Experience with OEM, TOAD, and Oracle SQL Developer for database administration.
  • Performed Database activities using Integrated Development tools like SQL Developer and TOAD.
  • Performed database tuning using Explain Plan, Toad, and Enterprise Manager.
  • Used Toad, Grid Control to monitor the databases and the Servers.
  • Used Oracle Enterprise Manager and Quest Toad for database monitoring and tuning.
  • Used TOAD, PL/SQL Developer tools for faster application design and development.
  • Involved in Logical and Physical Schema Design and Data Modeling using Toad.
  • Performed Database Administration using TOAD, Oracle Enterprise Manager and SQL scripts.
  • Skilled in using tools such as SQL Developer and TOAD.
  • Performed data modeling tasks using E/R Studio/Toad.
  • Installed and configured Toad 10.6.
  • Used tools like TOAD, SSH.
  • Perform SQL tuning and assist developers with coding PL/SQL Performed PL/SQL querying and troubleshooting errors in queries using TOAD tool.
  • Used TOAD and OEM grid control to Optimize and test SQLs, PL-SQL statements developed by the Development Team.
  • Used TOAD as third party software for analyzing the database issues and generating results sets in xls formats.
  • Experience using Toad to monitor the waits, locks, long running sql's on the databases.

Show More

17. AIX

demand arrow
average Demand
Here's how AIX is used in Senior Oracle Database Administrator jobs:
  • Install and configure Oracle 11gR2 on AIX 6.1, applying patches and upgrading the existing 11gR1 databases to 11gR2.
  • Deployed agents to monitor and administer Oracle databases on HPUX, Sun, Linux, AIX and Windows.
  • Administered databases on 9i/ 10g/11g in all environments on RHEL, IBM-AIX, HP-UX, Windows 2003.
  • Involved in Implementation and support for Oracle 11g RAC instances in Enterprise Linux and AIX Environment.
  • Resolved implementation issues with HP Service Guard, AIX HCMP and Sun high availability environments.
  • Implemented first Oracle database on AIX P5 in support of a new inventory replenishment project.
  • Support member from the database team during the OS upgrades-AIX 5.3 to 6.1 and patches.
  • Utilized Oracle10g/11g, Oracle Fail Safe, Windows 200x Enterprise Server and AiX 7.1.
  • Completed Migration of Oracle Databases from AIX IBM machines to Linux.
  • Developed AIX Shell Scripts for maintaining file system.
  • Installed RAC and single databases on Windows, Linux, AIX, and HP-UX servers.
  • Migrated the databases from 9i and 10g to 11g from SunOS to AIX.
  • Migrate from DB2 V8.2 On AIX to Oracle10g.
  • Build 11gR2 RAC/Stand-alone databases using Blade Logic Automation (BBDA) on Linux, AIX and Solaris.
  • Migrated databases in all environments from Sun Solaris 10, IBM-AIX 5.2 to RHEL 4.1 using XTTS.
  • Installed and configured4 Node RAC/Multinode RAC of 11gR2 on AIX, LINUX and UNIX environments.
  • Build 11GR1 RAC/Stand-alone databases manually on Linux, AIX and Solaris using GTI standard scripts.
  • Recovered Lawson Financials Database on DR IBM AIX Server.
  • Administered [ ] RAC/11g RAC in OLTP, Data Warehouse environments on RHEL, IBM AIX.
  • Installed Grid Infrastructure Software on new AIX and Linux Servers for 2 node and 3 node RAC and Failover environments.

Show More

1 AIX Jobs

No jobs at selected location

18. Addm

demand arrow
average Demand
Here's how Addm is used in Senior Oracle Database Administrator jobs:
  • Perform schema comparison for development databases, generate AWR and ADDM report, and create script using Toad.
  • Utilized Oracle utilities such as AWR, ADDM and ASH reports for Database, Systems and Application tuning.
  • Experience working with Oracle Enterprise Manager, working with AWR reports, ADDM, and gathering statistics.
  • Trace, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
  • Performed database and SQL tuning troubleshooting using AWR, ASH and ADDM on Real Application cluster.
  • Involved in Application tuning using explain plan, SQL Trace, DBMS_STATS and ADDM.
  • Performed Performance Tuning by analyzing AWR, ASH, ADDM reports.
  • Worked on Performance analysis using AWR/ASH/ADDM reports and wait event analysis.
  • Have experience in performance tuning using AWR and ADDM Reports.
  • Used AWR/ADDM to analyze the database and do tuning.
  • Generated AWR and ADDM reports for Performance and Tuning.
  • Performed troubleshooting of database using AWR and ADDM reports.
  • Run and review ASH, ADDM, AWR reports for performance tuning.
  • Worked on AWR, ADDM, ASH reports for performance tuning.
  • Generated AWR, ADDM, ASH and taken Backups using OEM.
  • Performed Performance Tuning, ADDM, AWR and ASH.
  • Generate scripts in a timely manner using AWR and ADDM.
  • Worked on 10g Grid control for performance monitoring Worked on Awr, Ash, ADDM, reports for performance tuning.
  • Generated and analysed the AWR, ADDM reports to provide best tuning solutions for performance issues.
  • Worked on all various features of Oracle like Import/Export, Oracle OEM, Impdp/Expdp, ADDM and AWR.

Show More

2 Addm Jobs

No jobs at selected location

19. Explain Plan

demand arrow
average Demand
Here's how Explain Plan is used in Senior Oracle Database Administrator jobs:
  • Assisted application development team in query tuning & optimization, partitioning, explain plan recommendations.
  • Helped users understand and fine tune queries which took hours to run and optimized explain plans while laying out best practices.
  • Involve in Data Maintenance, using Explain plan, SQL Hints, Table and Index Partitioning to improve the Performance.
  • Analyzed query plan using Plan Table, Explain Plan, optimizer Hints and for estimating CPU & Query costs.
  • Worked with developers to check the SQL performance through the AWR reports, explain plan and stress/load test.
  • Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements.
  • Experience in using SQLT to force the optimizer to use better explain plan and pin hash values.
  • Used Explain Plan extensively for monitoring and improving the performance of databases and SQL queries.
  • Use of explain plans to tune SQL queries, building indexes to improve performance.
  • Assisted developers in tuning their queries using explain plan, ADDM, AWR.
  • Worked on SQL explain plans and query performance, session tracing.
  • Tuned performance of queries using explain plans and hints.
  • Provided explain plan and analyzed the query plan.
  • Tuned SQL queries using AUTOTRACE and EXPLAIN Plan.
  • Use Explain plan to tune SQL queries.
  • Worked extensively on SQL Profiler, Explain Plan and Stats Pack for tuning top wait events, high cost SQL's.
  • Worked with core development to optimize and tune databases and queries by using AWR, Statspack, and Explain Plan.
  • Tune the Databases for optimization using Statspack and Explain Plan, Estimating Table & Index Size.
  • Used Explain Plan and Autotrace to tune slow queries.
  • Performed SQL tuning by using Explain Plan Resolving incidents and implementing change request Documentation of procedures/process wherever required.

Show More

20. Capacity Planning

demand arrow
average Demand
Here's how Capacity Planning is used in Senior Oracle Database Administrator jobs:
  • Perform capacity monitoring and short and long-term capacity planning in collaboration with development resources, system administrators and system architects.
  • Performed day-to-day SAP DBA activities including performance tuning, security management, capacity planning, standards development and enforcement.
  • Worked closely with the system operations team on database deployment processes and database capacity planning.
  • Collaborate with system administrators and operations on capacity planning, strategy, processes tuning.
  • Evaluated server/instance architecture, hardware, system specifications, and capacity planning.
  • Performed GoldenGate replication Monitoring, Performance Tuning, and Capacity Planning.
  • Performed Oracle installations, configurations, database refresh/capacity planning.
  • Participate in planning strategies for future database needs for business needs in perspective of capacity planning, performance and available technology.
  • Involved in the database Capacity Planning for the future business growth requirements and suggested the input value to the customer.
  • Develop performance testing plans and strategies, responsible for capacity planning strategies for all Oracle systems.
  • Perform capacity planning for the server and database based on new initiatives and data growth.
  • Estimated current and future requirements in terms of storage and other resources including capacity planning.
  • Participate in capacity planning and providing input for the budget planning processes.
  • Perform SAP architecture sizing and capacity planning to meet SAP enterprise deployment.
  • Worked on capacity planning of memory/disk usage for the application.
  • Involved in capacity planning and resource planning.
  • Involved in Database sizing, Capacity Planning.
  • Performed capacity planning, space monitoring like tablespace growth, ASM disk space.
  • Involve in the capacity planning of various databases application design and architecture for Ariba, and SAP implementations.
  • Managed project deliverables and handled capacity planning while reporting directly to the IT Director.

Show More

134 Capacity Planning Jobs

No jobs at selected location

21. Tkprof

demand arrow
average Demand
Here's how Tkprof is used in Senior Oracle Database Administrator jobs:
  • Tuned application with EXPLAIN PLAN and TKPROF, analyzing database objects, maintaining the security of the databases.
  • Worked database performance tuning tools, including AWR, ASH, ADDM, extended tracing and TKPROF.
  • Enabled and analyzed trace files using TKPROF analysis and system wide event tracing.
  • Experienced at enabling and analyzing SQL tracing and using TKPROF utility.
  • Analyzed the trace files Using TKPROF utility.
  • Performed Database and SQL tuning by using various tools like STATSPACK, AWR, ADDM, TKPROF and EXPLAIN PLAN.
  • Optimized SQL, PL/SQL code and performance tuning using AWR, TKPROF, EXPLAIN PLAN & TUNING ADVISOR.
  • Used oracle tools like AWR, ADDM, Advisories, TKPROF, EXPLAIN PLAN for improving database performance.
  • Used EXPLAIN, Log miner and TKPROF for SQL tuning.
  • Performed performance tuning using Explain Plan, SQL*Trace, TKPROF, Statspack, ASH and Unix commands.
  • Performed performance tuning by using Oracle utilities like Stats Pack, Tkprof for addressing performance bottlenecks.
  • Monitored and tuned the database extensively using tkprof, Query Analyzer, explain plan.
  • Worked on Performance Tuning/query optimization using Oracle Trace, Explain Plan, and TKprof.
  • Used TKPROF to analyze tracefiles and tuned long running Queries on Database.
  • Utilize TKPROF, Query Explain Plan, ADDM, ASH, and SQL_Trace for Oracle database performance and tuning.
  • Tuned database and application performance with homegrown shell scripts and Oracle utilities Like ExplainPlan, TKProff and Statsspack.
  • Monitor and fully analyze performance issues in production Oracle databases by using AWR/ADDM, statspack/tkprof tools.
  • Involved in sql tuning of various queries using explain plan and tkprof.
  • Worked on db system performance and SQL tuning using Explain Plan, Tkprof , AWR and OEM.
  • Performed performance tuning by using Explain Plan, Tkprof, Statspack, AWR, ADDM andASH.

Show More

22. Data Guard

demand arrow
average Demand
Here's how Data Guard is used in Senior Oracle Database Administrator jobs:
  • Configured Active data guard and performed Troubleshooting data guard environment.
  • Implemented Data Guard with maximum availability, protection and performance.
  • Configure active data guard replication and Golden Gate replication.
  • Implemented Data guard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
  • Configured and maintained Oracle Data guard for disaster recovery (physical standby database).
  • Planned and implemented Disaster Recovery (DR) solutions using Oracle Standby Database/Data Guard.
  • Implemented database migrations and managing the data guard in from 10.2.0.5 to 11.2.0.1 version.
  • Implemented DATA GUARD (Standby) for disaster recovery (DR) purpose.
  • Involved in the implementation of Oracle 11g Data Guard on physical standby databases.
  • Experience in configuring Data Guard 10g R2 for physical standby database.
  • Configured Active Data Guard from Production to Reporting system.
  • Experience in managing Data Guard configuration using DGMCRL tool.
  • Involved in Implementation of Oracle 11g Active Data guard.
  • Configured Oracle 11gR2 active data guard and Streams.
  • Upgraded databases from Oracle 9i to 10g, 10g to 11g Implemented Data Guard, Standby for Disaster Recovery.
  • Implemented Data Guard on oracle 10g and 11g and performed switchover.
  • Supported the quarterly reboots for multiple servers and involved in Data guard home relinking as well as RAC Relinking.
  • configured data guard broker and monitored standby database, log shipping.
  • Performed Failover and Failback using Data guard.
  • Worked on switchover and Failover scenarios for High Availability both manually and using Oracle Data Guard Broker Agent.

Show More

23. Statspack

demand arrow
average Demand
Here's how Statspack is used in Senior Oracle Database Administrator jobs:
  • Run the Oracle STATSPACK on the Oracle Instances to find out the System Performance Statistics during the peak load times.
  • Performed performance-tuning activities using tools such as SQL TRACE, STATSPACK, EXPLAIN PLAN, and TKPROF.
  • Help with troubleshooting, analyzing STATSPACK reports/explain plan/SQL Trace and tracing user sessions for performance analysis.
  • Performed Performance tuning for optimized results using tools like Explain Plan, TKPROF and STATSPACK.
  • Used OEM, SpotLight, STATSPACK, and other Enterprise monitoring Tools for database monitoring.
  • Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.
  • Performed Database tuning using StatspackAWR and ADDM.
  • Skilled with STATSPACK, AWR, ADDM, SAR to check health of database & hardware.
  • Trouble shooting performance issues using Explain Plan, TKPROF, STATSPACK, AWR and ADDM.
  • Experienced in Tuning SQL statements using Explain Plan, SQL Trace, TKPROF and STATSPACK.
  • Implemented auto statspack snapshot collection on all production databases for troubleshooting and problem resolution.
  • Worked on AWR repository, Statspack report and Session Trace 10046 to find/fix root causes for performance degradation in the databases.
  • Generate statspack report regularly to know the bottlenecks in the system and send them to Oracle support for analysis.
  • Involved in proactive and reactive Performance Tuning using Statspack, Explain Plan, ADDM, AWR and ASH.
  • Conduct database, network and application tuning using SQLTRACE, Explain Plan, TKPROF, Traceroute and STATSPACK.
  • Tuned Oralce9i database server using tools dynamic, dictionary views, Statspack, Diagnostic and tuning packages.
  • Tuned several production databases using partitioning, indexes, parallel query and running statspack.
  • Experience in SQL tunning using STATSPACK, EXPLAIN PLAN and TKPROF.
  • Assisted Programmers with Tuning Advice (STATSPACK, Explain Plan, tkprof, SQL Trace,).
  • Worked extensively on Oracle Statspack report, collecting statistics, generating & analyzing statspack report for Performance Monitoring and Tuning.

Show More

24. SQL

demand arrow
average Demand
Here's how SQL is used in Senior Oracle Database Administrator jobs:
  • Optimized data loading using SQL*Loader to load different types of data from flat files to the Oracle server.
  • Provided solutions using query rewrites, hints, outlines, SQL profiles and SQL plan baselines.
  • Redesigned the database model for few applications in migration from SQL Server 2005 to oracle 11g.
  • Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
  • Used Microsoft SSIS to cleanse/massage data from Oracle 11g to SQL Server 2012..
  • Define and Execute database backups and disaster strategies for Oracle and SQL Server.
  • Monitored SQL SERVER Databases and assisted developers in debugging T-SQL Procedures etc.
  • Worked on performance and tuning on SQL queries wherever it is required.
  • Develop table structures, PL*SQL stored procedures and database triggers to implement.
  • Deployed Agents to over 100 Oracle and Microsoft SQL Server Instances.
  • Performed Backup and Refreshed SQL SERVER 2005 Databases using SSMS.
  • Performed Explain Plan analysis for Query Optimization and SQL tuning.
  • Used MySQL Workbench for administration.
  • Used Microsoft SSMA (SQL Server Migration Assistant for Oracle 5.2.1259) Project (Oracle to SQL).
  • Migrated Oracle 11g database (2 TB) to Microsoft SQL Server 2012..
  • Developed solution to clean environment on SQL Server [ ] database.
  • Installed and supported MySQL 5.5.27/5.6.X.
  • Configured bi-directional MySQL master to master asynchronous replication for a highly transactional e-commerce webstore application.
  • Converted 50 Oracle 11g Schemas to Microsoft SQL Server 2012 Schemas.
  • Implemented highly-available and scalable Percona XtraDB MySQL cluster using Galera synchronous replication and load balancer technology (F5).

Show More

46 SQL Jobs

No jobs at selected location

25. Physical Standby

demand arrow
average Demand
Here's how Physical Standby is used in Senior Oracle Database Administrator jobs:
  • Configured parameter file, Listener and Net service names manually for production and physical standby databases in Data-guard environment.
  • Configured disaster recovery site with physical standby database for high availability using Oracle Data Guard.
  • Converted physical standby to logical standby for reporting.
  • Implemented Active Data guard, creating both Logical and Physical Standby databases in 10g,11gRAC & 12C environment for the Production databases.
  • Target environment is 3 node RAC primary with 3 node RAC physical standby (Data guard).
  • Created physical standby database (for disaster recovery) from hot backup of primary database.
  • Installed, configured and maintained Physical Standby Databases for the Production databases using Data Guard.
  • Configured Physical Standby databases and logical Standby database for ACTIVE DATA GAURD.
  • Involved in conversion of physical standby to snapshot standby for testing purposes.
  • Created a physical standby for Disaster Recovery (DATA GUARD).
  • Converted Physical Standby to Snapshot Standby and also to Active data-guard.
  • Upgraded Argus Safety/Argus Insight database to 11gR2 with Physical Standby.
  • Implemented oracle high availability solution using oracle 10g PHYSICAL STANDBY.
  • Configured physical standby databases for ACTIVE DATA GUARD.
  • Created Physical Standbys, configured log shipping.
  • Configured and Managed Dataguard to implement Physical standby database for DR solutions.
  • Configured one logical standby and one physical standby database using dataguard.
  • Worked on switching over these physical standbys to primary and original primary at CA location as physical standbys.
  • Implemented Dataguard, creating both Logical and Physical Standby databases.
  • Worked with 6 node RAC configuration/administration Configured DR environment (Physical Standby ) with Dataguard.

Show More

26. Production Environment

demand arrow
average Demand
Here's how Production Environment is used in Senior Oracle Database Administrator jobs:
  • Generate Standard Operating Procedures for the database operations in the production environment in other to standardize all relevant database activities.
  • Performed maintenance tasks on production environments that included modifying database sizes and migrating changes through various environments.
  • Designed Backup and Recovery procedures for production and non production environments using RMAN.
  • Used duplicate database for cloning Oracle database from production to non-production environments.
  • Based on the request from application team, generating the model using reverse engineering approach (Erwin) from production environment.
  • Installed, Setup and Configure Oracle 11g as well as 10gR2 RAC on AIX for the EBS Production environment.
  • Performed schema, and table refreshes from production environment to development and test environments.
  • Use Oracle Grid control for daily maintenance and database monitoring of production environment.
  • Migrated production environments from Oracle 9i to 10g and then 10g to 11g.
  • Cloned databases for development, QA, unit testing and production environments.
  • Duplicated RAC Databases in non production environment through RMAN.
  • Worked with team to support 24x7 production environments.
  • Performed in DEV, TEST and production environments.
  • Top secret Clearance Providing technical support in development and high-availability production environments.
  • Advanced Backup and Recovery using Oracle RMAN software; used offline/online for recovery in a production environment via Korn shell scripting.
  • Support of daily operations including job monitoring and troubleshooting of the 24x7 production environment Provided performance tuning on a 10G database.
  • Introduced and leveraged new Oracle 11g features across development, testing, and production environments to maximize uptime and minimize risk.
  • Provided expert remote Oracle DBA support to production environments via Webinars and VPN remote log in using P-Shell and Putty.
  • Installed and configured 6 node oracle 11gR2 RAC for production environment.
  • Compiled esql program Prepared hardware software requirement for development, test and production environment.

Show More

27. CPU

demand arrow
average Demand
Here's how CPU is used in Senior Oracle Database Administrator jobs:
  • Performed health checks and monitored logs and CPU, memory, I/O and disk usage on production and application servers.
  • Applied CPU & PSU security patches in both RAC and standalone systems in ASM & non - ASM environments.
  • Experience in applying several patches such as CPU/PSU patches, interim patches as per the Oracle recommendations.
  • Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries.
  • Identified bugs and applied required patches like CPU, PSU Patches as per the oracle recommendations.
  • Identified performance bottlenecks with RMAN backup and resolved the overhead on database and CPU performance.
  • Applied Oracle CPU patch quarterly for different version databases and other Oracle patches.
  • Monitored server level performance by checking CPU, I/O, and paging.
  • Monitor CPU usage, I/O contention, memory paging on UNIX server.
  • Applied critical patch updates (CPU) released by oracle quarterly.
  • Applied PSU & CPU patches for the oracle enterprise database servers.
  • Apply critical and CPU patches and keep in-sync all environments.
  • Installed Oracle Quarterly CPU patches and off-patches for performance reasons.
  • Applied CPU patches and other patches for bug fixing.
  • Applied both CPU and PSU patches as per requirements.
  • Apply CPU, DST, RDBMS patches as per the requirement.
  • Upgraded and applied CPU patches and bug fixes as and when required and performed database refresh from Prod to Dev.
  • Applied Consolidated Update, Critical Patch Update (CPU's), Security alert patches using Opatch.
  • Configured instance caging to limit the usage of cpu for databases.
  • Applied patches, patchsets and Critical Patch Update (CPU) using OPatch utility and OUI.

Show More

28. Red Hat

demand arrow
average Demand
Here's how Red Hat is used in Senior Oracle Database Administrator jobs:
  • Migrate and upgrade oracle 10g RAC databases to 11g Linux RAC databases from Windows to Red Hat Linux operating systems.
  • Installed, configured, and provide support to production Oracle 11gR2 databases on Red Hat Enterprise Linux and Windows platforms.
  • Installed 12c Golden gate binaries on Red hat Linux 6.4 server and Monitoring and troubleshooting Golden Gate Replication.
  • Install, configure and administer of databases for applications on Red Hat Linux systems in various environments.
  • Monitored all the 11g databases on Red Hat Linux environments by using OEM 11g and 12c.
  • Administer multiple 11 Oracle Databases on Linux Red Hat platform using Banner ERP front end.
  • Configured and Installed ORACLE 10g, 11g software on Red Hat Linux 4 Servers.
  • Installed and Configured 3 Node RAC on Red Hat Linux AS 4 platform.
  • Migrated Oracle 10g from windows environment to 11g on Red Hat Linux Platform.
  • Installed missing and required Red Hat Linux packages for Oracle 10G.
  • Designed a two node RAC on Red hat Linux.
  • Install and Configure (11gR2) Oracle RAC One Node Setup on Red Hat Linux (5.5) Servers.
  • Installed Oracle 10g, 11g RAC database on Red Hat Linux.
  • Installed STANDALONE servers on ASM, Red hat LINUX.
  • Red Hat Enterprise Linux 3/4 test system administration and data warehousing configuration support (i.e.
  • Implemented 10g/11g RAC, Grid infrastructure for 5 nodes Oracle Clusterware on Red Hat Linux.
  • Involved in Installation and configuration of Oracle 10g/11g RAC on 2 node Red Hat Linux.
  • Installed HP-UX, Sun Solaris, IBM AIX, Red Hat Linux, and Windows servers.
  • Worked with lead DBAs for preparing cluster, configuring, installing Clusterware and Oracle RAC on Red Hat Linux.
  • Support Oracle EBusiness suite Applications R12.1.3 and database [ ] in Red hat Linux platform.

Show More

29. Goldengate

demand arrow
average Demand
Here's how Goldengate is used in Senior Oracle Database Administrator jobs:
  • Installed and implemented GoldenGate to replicate data between databases in both Uni- directional and Bi-directional modes.
  • Configured two way replication with GoldenGate.
  • Engineered replication solution using GoldenGate.
  • Performed zero downtime migration with the help of GOLDENGATE * Configured Extract and Replicate pumps for Golden gate replication.
  • Implemented Oracle GoldenGate HA RAC environment to several downstream databases which are acting as offload databases by application teams.
  • Configured GoldenGate to maintain replication to other Oracle, MySQL and SQL Server databases.
  • Installed and Configured Oracle GoldenGate (with and without DDL support).
  • Upgraded GoldenGate from 11g to 12c while upgrading Oracle databases.
  • Worked on Implementing Oracle GoldenGate with Amazon RDS and EC2.
  • Configured GoldenGate for DDL and DML replication in Production.
  • Configured Oracle GoldenGate 12c for data Replication.
  • Worked on Data replication such as one-to-many, many-to-many, cascading and bidirectional using Oracle Goldengate.
  • Installed and used Oracle GoldenGate veridata for data comparison in various databases.
  • Installed WebLogic server 12c and Installed Oracle GoldenGate Veridata and Agents and created jobs compare data between instances.
  • Installed Goldengate binaries and Setup two way replication in production for the upgrade from 10gR2 to 11gR2.
  • Performed DB Cloning using various methodologies Implemented GoldenGate replication in Oracle RAC Multimode and Oracle RAC One Node.
  • Integrated all the databases with 12c OEM (Multi OMS configuration) to monitor databases and Goldengate effectively.
  • Performed role switchover in Exadata RAC environment with GoldenGate HA running on the servers.
  • Monitored Goldengate using 12c Goldengate Plugin and also Goldengate Director and shell scripts for alerting GG process down alerts.
  • Converted Goldengate Classic Replicat to Co-ordinated Replicat to improve the throughput of golden gate apply.

Show More

30. Performance Issues

demand arrow
low Demand
Here's how Performance Issues is used in Senior Oracle Database Administrator jobs:
  • Provided support on performance issues during project development resulting in improved response times and reduced contention.
  • Support Oracle 9i 4 terabyte OLTP Claims database release process, tuning and troubleshooting performance issues on a daily basis.
  • Monitor and fully analyze performance issues in production Oracle databases by using AWR/ADDM/OEM 12c and home-cooked scripts.
  • Worked in the matters of performance issues, major reorganizations and auditing the required down times.
  • Interacted with Oracle Support regarding multiple service requests to solve performance issues of the Database.
  • Solved severe production database performance issues related to hanging of jobs under load.
  • Troubleshooted database performance issues and also help team mates understand the resolution process.
  • Utilized ADDM, AWR and ASH for problem resolution and troubleshooting performance issues.
  • Handled Chained Rows and Row migration, and solved the database performance issues.
  • Monitor, Identify and Tune poor code, trouble shoot the performance issues.
  • Experience in Analyzing AWR and ASH reports and identifying key performance issues.
  • Support and provide guidance to developers with the queries and performance issues.
  • Experience in troubleshooting Performance issues on RAC Instances.
  • Trouble shooting for performance issues.
  • Solved several show-stopping performance issues to ensure that we were able to migrate to Exadata within very tight timescales.
  • Used Oracle Advanced Replication feature to set up multi-master replication, dealt with conflict resolution and performance issues.
  • Resolved complex database performance issues for Oracle and SQL Server databases Multiple versions.
  • Trouble shooting of workflow performance issues.
  • Worked with defgen and Logdump utilities in troubleshooting GoldenGate performance issues.
  • Managed backup and recovery strategy with RMAN/TSM Identified / trouble shooted Oracle database/sql performance issues.

Show More

31. Export

demand arrow
low Demand
Here's how Export is used in Senior Oracle Database Administrator jobs:
  • Performed migration of around 30 small 8i and 9i databases into one single large 11g database using conventional export/import.
  • Automated many common tasks including Backups, exports and imports, archiving old records and verification of such processes.
  • Scheduled database maintenance tasks such as tables/indexes analysis, index rebuild, materialized views refresh and db exports.
  • Devised & Implemented backup strategies using hot, cold, and exports based on the business requirements.
  • Managed testing, assisted developers, and created backups by Exporting and Importing tables when needed.
  • Used EXPORT/IMPORT to do table level and full database imports as per application team requirements.
  • Implemented backup/recover strategies using HOT backup, COLD backups RMAN and Export/Import utilities.
  • Created db link for inserting large tables directly without taking export.
  • Performed Export and Import utilities in SQL SERVER databases.
  • Worked on import/export and SQL- loader.
  • Export and import of data.
  • Planned Backup/restoration strategy, taking logical Backups with export and Datapump utilities.
  • Performed Initial load, Extract, Replicat, trial files and exporting data onto Repository Database using Golden Gate tool.
  • Created reports for the data warehousing team using Sqoop to export data into HDFS and Hive.
  • Export, import of several databases to refresh the dev, int and test paths.
  • Worked with database export & import scripts to backup database structures and automation procedures.
  • Recover Drugdb tables by export and import the same tables from standby.
  • Worked on export/import of various tables/schemas as per the requirement.
  • Used EXPORT/IMPORT to do table level and full database defragmentation.
  • Installed and exported APEX and schemas export and from one Env to other Env and applied latest patches.

Show More

1 Export Jobs

No jobs at selected location

32. Rhel

demand arrow
low Demand
Here's how Rhel is used in Senior Oracle Database Administrator jobs:
  • Installed and Configured Oracle 9i/10g server on HP-UX, RHEL 5 and Windows for Large Multi-Terabyte Databases (VLDB).
  • Experience in Design, Creating and maintaining the Oracle Databases 11g from the scratch on UNIX and RHEL.
  • Assist in the daily maintenance and tuning of RHEL 5.8 kernel parameters that host Oracle databases.
  • Supported the upgrade of RHEL and Hard work are diagnostics on various servers.
  • Migrated 30 TB Databases from HP UNIX to RHEL with minimal down time.
  • Involved in migration of databases from HP-UNIX to RHEL.
  • Upgraded 30+ databases from 9.2.0.6 to 10.2.0.1 to 10.2.0.3 to 11gR1/R2 on RHEL and AIX.
  • Upgrade Oracle RAC (From RHEL4.1+Ora10.1.0.5+ASM 2.6.9-11 TO RHEL4.3+Ora10.2.0.3 2.6.9-34).
  • Upgraded a 5-node RAC on RHEL4 from 10g to 11g.
  • Migrated databases around 1.7 TB (VLDB) across platforms from Sun Solaris 10 to RHEL 3.2 using TTS.
  • Performed upgrade from 9.2.0.8 to 10.2.0.4 on Solaris 5.10 and Linux RHEL AS3 32-bit that involved standby database.
  • Involved in migration of applications from Solaris on Oracle 10g to RHEL 5.3 on Oracle 11g RAC.
  • Migrated the databases from 9i and 10g to 11gr2 from Solaris 1o to RHEL 5.5..
  • Upgraded development and production databases from 10.2.0.x to [ ] on RHEL.
  • Possess strong RHEL and Solaris skills.
  • Installed 10g & 11g 2 Node RAC & Cluste ware installation on RHEL 5.x server.
  • Installed Oracle 10G R2 RAC on HP UX, Sun Solaris and RHEL platform.
  • Upgrade of oracle 11gR1 to11gR2) on RHEL.
  • Administered Oracle [ ] production, test, development environment on RHEL, IBM-AIX, Solaris, HP-UX.
  • Obtained detailed understanding of Database Schemas and data sources and Migration of database from Solaris to RHEL.

Show More

33. Troubleshoot

demand arrow
low Demand
Here's how Troubleshoot is used in Senior Oracle Database Administrator jobs:
  • Worked on Troubleshooting Complex Golden Gate production issues including latency optimization and conflict resolution.
  • Included patching all applications, monitoring performance and space, application troubleshooting, cloning, and monthly status reporting.
  • Helped developer in installing Oracle Client, troubleshoot and establish the connection to Oracle database through JDBC.
  • Maintain 24 7 Availability by implementing standard processes and troubleshooting live issues within defined tight SLA times.
  • Managed all aspects of SQL Server administration, from basic troubleshooting tasks, to full scale installations.
  • Involved in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate EXTRACT and REPLICATE issues.
  • Work closely with application teams in troubleshooting issues, support root cause analysis and resolve issues.
  • Created and troubleshoot DB Link issues in Oracle for communicating with external databases.
  • Perform Oracle performance tuning and troubleshooting in tuning SQL queries and system settings.
  • Provide stakeholders with dump files via automated daily data dumps and also troubleshoot.
  • Worked in troubleshooting 2node and 4node RAC and implemented 11g New ASM features.
  • Worked on configuration of Oracle 10g RAC environment and troubleshoot performance problems.
  • Experience in Oracle Golden Gate installation, configuration, troubleshooting GG issues.
  • Assisted with system troubleshooting to isolate and diagnose common system problems.
  • Experienced writing UNIX scripts and troubleshooting issues.
  • Worked on to troubleshoot skipped transactions.
  • Help to troubleshoot other OS (Unix/Linux/Windows/Network), DBs problems and manage group project under supervisor's instructions.
  • Changed scan port number, troubleshooting clusterware components, performed HEALTH CHECKS in RAC clusters.
  • Help application DBAs, developers to optimize, troubleshoot the DB design/programming issues; turn sql for maximum performance upon request.
  • Performed health checks of RAC clusterware components and Troubleshooting Issues using Clusterware logs in 12C and 11g RAC Environments.

Show More

126 Troubleshoot Jobs

No jobs at selected location

34. Hp-Ux

demand arrow
low Demand
Here's how Hp-Ux is used in Senior Oracle Database Administrator jobs:
  • Applied Patches for the bugs/ OS compatibility issues on HP-UX server and solved issues on generating traces on internal errors.
  • Used Hewlett Packard HP-9000 hardware for the Oracle Database Servers and ran HP-UX for the Operating System of choice.
  • Support production and test Oracle 10g databases in HP-UX based RAC utilizing ASM disk groups and non RAC environments.
  • Performed migration from 9i, 10g, and 11g to 12c HP-UX cluster & non cluster environment.
  • Involved in migrating databases from Windows to Linux, HP-UX to IBM AIX.
  • Install and configure Oracle 10g Databases on Linux, HP-UX and Windows NT.
  • Developed a method to clone standard databases with standard configurations for AIX/HP-UX/LINUX.
  • Administered remote Oracle VLDB databases on HP-UX and Windows NT.
  • Migrated Databases from Linux to HP-UX, Windows to LINUX.
  • Migrated databases from HP-UX to AIX.
  • Upgraded Real Application Cluster (RAC) from Oracle 9i to Oracle 10g on HP-UX.
  • Installed/configured numerous Oracle 9i databases on HP-UX 11.0, HP-UX 11.23 Itanium and Linux 2.0 - 4.0.
  • Migrated applications from Sun Solaris to HP-UX Unix, IBM AIX, Windows to Unix.
  • Designed and implemented business rules in Oracle, AIX, HP-UX and Solaris environments.
  • Migrated databases from HP-UX to Sun Solaris, and Windows to Linux.
  • Managed Oracle database server 11.2.0.4 on HP-UX Itanium (HP-UX Itanium is one type of Unix operating system).
  • Used Reflection and Tectia to connect from Windows to HP-UX Itanium; doing daily work on Unix.
  • Ford Motors Brazil Responsible for Oracle 7.x Database at the HP-UX 10.20 / SUN Solaris platform.
  • Installed and upgraded databases from 10gR2 to [ ] on Linux, Sun Solaris, HP-UX, and AIX.
  • Installed Oracle 11.5.10.2 on Linux, AIX , Windows 2003 Server, HP-UX and Solaris.

Show More

35. Data Warehouse

demand arrow
low Demand
Here's how Data Warehouse is used in Senior Oracle Database Administrator jobs:
  • Designed and setup Data Warehouse for identifying marketing and sales strategies and opportunities.
  • Designed, Developed and implemented the Military-Civilian Data warehouse.
  • Supported functional data warehouse projects.
  • Re-engineered client's 11 TB data warehouse backup strategy, using only the assets available, and eliminated daily database downtime.
  • Involved with providing production support for databases and data warehouses to resolve all production issues within SLA defined time frames.
  • Experience in development, testing, performance tuning, deployment, and support in Data warehouse system.
  • Worked on partitioning of tables for data warehouse operations for achieving faster response time.
  • Administrated Very Large Data Warehouse Databases (VLDB) ranging from 500GB to 20TB.
  • Supported different Databases like Production, Development, Testing, and Data warehouse.
  • Migrated data warehouse database - Oracle 9i/P770 to Oracle 11g/P780.
  • Worked in EDW (Enterprise Claims data warehouse environment).
  • Supported Data Warehouse, Active Directory & Connection Manager.
  • Duplicate all the non-production databases on Exadata server according the Data Warehouse development project's requirement.
  • Created extraction/transformation (ETL) routines and loaded jobs to capture Oracle data for import into the Vtech Enterprise Data Warehouse.
  • Installed, configured and managed both OLTP and enterprise Data Warehouse on Oracle 7.3 thru 11g and DB2 UDB environments.
  • Used Oracle streams for Data replication, Data warehouse loading, Event notification as well as business event mgt.
  • Created the enterprise data warehouse for MyHealthbank and developed many Oracle PL/SQL Packages and Procedures for their Applications.
  • Integrate Oracle 8i and SQL Server [ ] for data warehouse, web interfaces and reporting.
  • Maintained Very Large Multi Terabyte (VLDB) around 1TB+ in Data Warehouse Environment for DSS.
  • Supported the ETL (Informatica) and BO ( BO ) tools for the data warehouse database.

Show More

36. Table Spaces

demand arrow
low Demand
Here's how Table Spaces is used in Senior Oracle Database Administrator jobs:
  • Worked on LOGICAL BACKUPS and Database migration (HP-Unix to SOLARIS) using with DATAPUMP, Export/Import and Transportable Table spaces.
  • Created tables, indexes, table spaces, users, integrity constraints and supported all phases of a development cycle.
  • Performed various DBA tasks (Managing database profiles, users, table spaces, security etc.).
  • Configured and created required table spaces and database objects with appropriate storage parameters as well as placement.
  • Worked on Golden Gate patching, upgrade and solutions for compressed and encrypted tables and table spaces.
  • Created and Managed users, user profiles, table spaces, data files, archive log.
  • Installed the Oracle 10g, Oracle 11g databases and Created Table spaces on ASM environment.
  • Created additional table spaces, Rollback Segments, Redo log Groups for production support.
  • Partitioned very large database tables and indexes and placed them in separate table spaces.
  • Managed Table spaces, Rollback Segments, Redo Logs and other database object.
  • Involved in De fragmenting data blocks of table spaces for optimized performance.
  • Create table spaces, tables, and users for custom applications.
  • Used BRTOOLS to create table spaces, indexes and collecting statistics.
  • Performed Cross platform migration using transportable table spaces and RMAN.
  • Table Partitioning, Creating Locally managed Table spaces.
  • Performed Cross Platform Database Migration from 10g on Solaris to 11g on Linux servers using Transportable Table spaces and Exp/Imp.
  • Have faced situations where recovery was needed for the control files, table spaces and data files.
  • Table Partitioning, creating Index Organized tables Creating and configuring locally managed Table spaces.
  • Used Data pump for exporting and importing tables, schemas and table spaces.
  • Created and Managed user, table spaces, datafiles, archive log.

Show More

1 Table Spaces Jobs

No jobs at selected location

37. QA

demand arrow
low Demand
Here's how QA is used in Senior Oracle Database Administrator jobs:
  • Cloned Production databases periodically for DEV/QA environment using RMAN.
  • Provided 24/7 database administration support to production (3-4 TB), staging and QA databases in three data centers.
  • Involved in all phases of database development, from needs assessment to QA/QC, design, and support.
  • Used Oracle Enterprise Manager 12c monitoring of production, stage, QA and Development Oracle Database Instances.
  • Work also includes supporting a team of system engineers, Java developers, and QA testers.
  • Installed, configured, cloned, supported GIS spatial production, replication, QA databases.
  • Followed Central Issue and Change Management Process for DEV, QA and STAGE Environment.
  • Cloned/Refreshed Database environments to create patch, test, development and QA environments.
  • Provide database application support to development teams from build through QA and release.
  • Worked with development and QA teams and provided solutions for Oracle issues.
  • Completed 2 development and QA environment setups for Starbucks Global Business.
  • Handle the databases to QA, by completing the PRR process.
  • Support Production, QA, DEV, UAT databases.
  • Created several multi-Terabyte size ODS (Operational Data Store) in Production, Development, QA, Staging on Oracle 10g.
  • Provided 24x7on call support for all the Production, Staging, Integration, Dev and QA databases.
  • Involved in production, staging, QA and development support for Kenexa/IBM application Oracle databases.
  • Cloned production database to QA, development and test instances using rman.
  • Clone and refresh databases from Production to Dev/QA Environments.
  • Provide 24x7 production support and over all responsible for database production, QA, dev, patch Env.
  • Installed an configured Oracle 11g in Dev, Stage, QA and production.

Show More

38. Space Management

demand arrow
low Demand
Here's how Space Management is used in Senior Oracle Database Administrator jobs:
  • Perform Data Warehouse maintenance such as partition management, space management and materialized view creation.
  • Space management over database layer and monitoring physical space utilization.
  • Undo table space management for rollback segment; Rollback segment creation and assignment for transaction as per departmental requirement for process.
  • Monitored the database, table space management and sizing of objects and space utilization in database using shell scripts.
  • Experience in writing shell scripts to check to the Status, Space Management and Performance of Database.
  • Worked on creation of users, granting roles and privileges to users, table space management.
  • Use of Perl programs to automate daily DBA tasks - Perform Database Space Management.
  • Migrated Non ASM file system to ASM File system for better space management.
  • Space Management which includes table space creation, adding new data files.
  • Supported space Management, patching activities on RAC (11.2.0.3/11.2.0.4).
  • Table Space management, Database Refreshes, and User Administration.
  • Perform Space Management & Troubleshooting the database issues.
  • Space management on file system and ASM.
  • Space management and support for 24*7.
  • Space management using BRTOOLS etc.
  • Worked with developers/testers to troubleshoot day-to-day issues like tablespace management, user creation, JDBC/application database connectivity, and ORA- errors.
  • Perform day-to-day database administration tasks - tablespace management, user password management, ASM space/disk addition, privileges and grants etc.
  • Performed various routine DBA tasks like Table space Management, Alert Logs UNDO-Tablespaces and Temporary TS etc.
  • Automated operational DBA activities like schema refreshes, RMAN backups, tablesspace management, monitoring etc.
  • Space management of logical structures (i.e.

Show More

1 Space Management Jobs

No jobs at selected location

39. I/O

demand arrow
low Demand
Here's how I/O is used in Senior Oracle Database Administrator jobs:
  • Provided Instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
  • Experience in Oracle Clustering services, VERITAS Cluster Services VCS(Quick I/O file systems) and High Availability features.
  • Created many baselines to stabilize execution plans, optimized plans and reduced CPU, logical and physical I/Os.
  • Configured the Oracle EXADATA server X2 for migration from legacy servers for enhanced improvements in hardware I/O performance.
  • Worked with local administration staff in Singapore and solved I/O throughput problems on large EMC storage array.
  • Design and implement advance database storage structures for improved I/O, optimized data retrieval and data management.
  • Reorganized data files, identification and elimination of contention factors like I/O, buffers and locks.
  • Tuned database for optimum performance and tuned the database both at I/O and instance levels.
  • Involved in I/O tuning by moving data files and redo log files to faster disks.
  • Performed database tuning and monitoring; involving I/O, memory tuning, and application tuning.
  • Migrated the production database from slower Disks to faster I/O disks with zero downtime.
  • Configured ORACLE Flash storage and reduced I/O in the system to enhance the performance.
  • Identify & elimination contention factors like I/O, buffers & locks.
  • Evaluated AWR reports for indicators of any I/O performance bottlenecks.
  • Configured Voltaire's InfiniBand I/O fabric switch for interconnect.
  • Tune SQL and database parameters; balance I/O.
  • Optimize I/O Extent Management, Partitioning.
  • Tuned and balanced I/O by monitoring file system and table space I/O statistics Tuned performance of SQL statements in 11g/12c database.
  • Implemented physical database design after sizing tables and indexes and creating tablespaces for proper account I/O load distribution.
  • Managed the size and I/O weights for tablespaces.

Show More

40. Rdbms

demand arrow
low Demand
Here's how Rdbms is used in Senior Oracle Database Administrator jobs:
  • Work with SA for setting up local mount points for BBDA agent, Oracle cluster and RDBMS binaries for Database Builds.
  • Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.
  • Monitored the SQL and Oracle RDBMS through the integrated Enterprise Manager of the 12-c Grid Control software.
  • Provide primary DBA support for establishing, upgrading and maintaining the RDBMS software environments.
  • Stay current with quarterly security patches for all RDBMS and applications.
  • Implemented Oracle RDBMS on NT servers at remote client sites.
  • Applied RDBMS oracle patches for the Database Oracle Home.
  • Configure RMAN backup for ASM and RDBMS production instances.
  • Migrated all the RDBMS database to EXADATA machine.
  • Install and Manage Oracle RDBMS Products.
  • Upgraded Oracle RDBMS and Cluster CRS (cluster resource services) from Oracle 10g to 12c.
  • Upgraded Oracle RDBMS and Cluster CRS (cluster resource services) from version 11.2.0.2 to 11.2.0.3.
  • Applied latest PSU and One-off patches for both Oracle Grid and RDBMS homes.
  • Applied various One-off and PSU Patches for Oracle 11g GRID/RDBMS homes.
  • Provide assistance to applications developers providing backend support for Applications and new projects that rely on an Oracle RDBMS.
  • Performed RDBMS patching of Oracle database software code tree using OPatch utility.
  • Applied latest PSU patch updates from MOS to Oracle Clusterware and RDBMS on 11.2.0.4.
  • Applied the Clusterware (GI), Database (RDBMS) Patches i.e.
  • Performed documentation for Clusterware installation, RAC RDBMSinstallation, RACDatabase creation, Grid Control installation, Oracle 11g Standby Documentation.
  • Upgrade of Rdbms 9.2.0.5 to 9.2.0.8. and 9.2.0.8 to 10.2.0.3 (10g) Provided performance tuning on a 10G database.

Show More

41. Oltp

demand arrow
low Demand
Here's how Oltp is used in Senior Oracle Database Administrator jobs:
  • Supported airline reservation systems including high traffic OLTP e-commerce.
  • Worked with very large scale Database environment and mission critical OLTP and OLAP systems ranging from 1TB to 4TB.
  • Build and developed, tested, staging, production, RAC and standby databases for OLTP systems.
  • Replicated databases using Oracle Streams and Data Guard for reporting purposes in OLTP environment with minimum lag.
  • Designed and Implemented Oracle Disaster Recovery Solutions for high profile OLTP system by using only Oracle products.
  • Administered and tuned several Data Warehousing, OLTP and Hybrid databases, Oracle and SQL Server.
  • Replicated databases using Oracle Golden Gate for reporting purposes in OLTP environment with minimum lag.
  • Provide 24x7-automated lights out mission critical production support for an OLTP web application.
  • Played a major role in designing a Relational database for OLTP and OLAP.
  • Involved in EDW Support for OLTP and OLAP Data ware house Applications.
  • Created new data warehouse for enterprise reporting, from OLTP system.
  • Managed large oracle databases servicing OLAP, OLTP and DSS applications.
  • Involved in loading the partner flat files into the OLTP database.
  • Worked extensively on the performance tuning for the OLTP database.
  • Worked on VLDB (OLTP 1.5 TB and DSS 7 TB).
  • Expanded Physical Data Model (PDM) for the OLTP application using ERwin.
  • Support Oracle databases forhigh transaction OLTP and Large Data Warehouse databases.
  • Performed Exadata for OLTP database systems.
  • Supported and maintained multi-terabyte high transactional OLTP RAC-enabled database.
  • Worked on setting up of Goldengate 12c Integrated Capture on Exadata Servers for replication purposes from OLTP system to Downstream systems.

Show More

1 Oltp Jobs

No jobs at selected location

42. R2

demand arrow
low Demand
Here's how R2 is used in Senior Oracle Database Administrator jobs:
  • Migrated data from old 10g environments to new 11gR2 environments using database cloning and DATAPUMP (EXPDP).
  • Upgraded oracle 10g to the latest oracle version 11gR2 using DBUA and by applying required patches.
  • Performed Migration of databases 10g on Hp - Unix to Oracle 11gR2 on Linux.
  • Lead DBA role in 10gR2 to 11gR2 database upgrades on multiple production database simultaneously.
  • Installed and configured Oracle Grid Infrastructure 11gR2 and upgraded the existing Grid Control.
  • Worked on Debugging and trouble-shooting replication issues in Golden Gate 11gR2.
  • Experience in supporting SQL Server databases 2008R2/2012 as a supporting DBA.
  • Installed Golden Gate for replication of database on 11gR2 RAC environment.
  • Upgraded and migrated databases from 10g to 11gR2 with minimum downtime.
  • Configured database backups to flash recovery area on 11gR2 databases.
  • Configured 11gR2 machines, Migrated MySQL databases to Linux environments.
  • Involved in upgrading the databases from 11gR1 to 11gR2.
  • Upgraded Oracle databases from 10g to 11gR2.
  • Installed and implemented 10gR2/11gR2 RAC.
  • Upgraded 11gR2 (11.2.0.3) to (11.2.0.4) in rolling fashion.
  • Installed MS SQL Server 2008 on Windows server 2008 R2.
  • Upgraded RAC databases from 10gR2 to 11gR2.
  • Upgraded databases in production, test, development environments from 9.2.0.6 to [ ] (Oracle 10gR2).
  • Patched Oracle Exadata Machine 11gR2 Grid Infrastructure and RAC databases.
  • Install, upgrade and maintain Oracle11g R2 on, Sun Solaris and Windows xp, Redhat4.

Show More

43. Data Pump

demand arrow
low Demand
Here's how Data Pump is used in Senior Oracle Database Administrator jobs:
  • Performed Database replication from production to test/development environment Using RMAN, Data pump utilities and manually.
  • Cloned/Refreshed databases for testing/QA environments using export/import, data pump and cold backup.
  • Performed Logical backup using and full/partial export/import and Data Pump.
  • Performed cloning and refresh of Database from production environment to test environment using RMAN Duplicate database and Data pump import export.
  • Worked on Features: Data Pump, ASM and RMAN, Data Base Recovery (complete & Incomplete).
  • Support RMAN backup and recovery including physical backups and logical backups by using data pump (Exp/Imp) tool.
  • Implemented Data Pump, Export and Import on day to day basis as per development and test servers.
  • Perform schema refresh using export/import and Oracle Data pump utilities and full database refresh by database cloning procedure.
  • Used Data Pump to take partial or full backup of databases before any minor/major database change.
  • Export and Import of User, Tables and Database using exp/imp and Data Pump.
  • Used Data pump for faster export/import of data in various DEV/TEST environments.
  • Set up SQL loader and Data Pump as required using shell scripts.
  • Configured Extract, Data pump and Replicate processes in a production environment.
  • Involved in logical backup using and full/ partial export/import and Data Pump.
  • Implemented data transfer using Data Pumps and Export/Import utilities.
  • Migrated Database between servers using Data pump Export/Import.
  • Used tools like export/import and data pump export/import.
  • Performed Import and Export using Oracle Data Pump.
  • Automated refresh of databases using data pump.
  • Cloud and GRID Control, OEM/OMS, Data Pump (expdp/impdp, dbms_datapump), SQL Loader, scp, ftp.

Show More

44. PSU

demand arrow
low Demand
Here's how PSU is used in Senior Oracle Database Administrator jobs:
  • Applied critical patch and security patches (PSU) on RAC ASM, single node and standby database.
  • Apply security patches (CPU/PSU) and bug fixes on RAC databases and Grid Infrastructure
  • Plan Oracle PSU patching and apply patches to Prod and non-prod databases.
  • Applied security patches, Patch Set Unit PSU and Performed testing.
  • Applied Patches includes PSU and Bug fixes for database performance issues.
  • Involved in applying CPU and PSU patches for Oracle Server.
  • Applied latest PSU patches after the up gradation of databases.
  • Applied PSU Patches in the test environment whenever required.
  • Applied PSU patches to Oracle Databases and Oracle Applications.
  • Configured RMAN, patched till the latest PSU patches.
  • Install, upgrade (10.2.0.5 to 11.1), patching (one-off & PSU) oracle grid control (OMS/AGENT).
  • Apply the PSU patches and RMAN patches to the binaries as well as to the databases.
  • Upgraded 10g to 11g, 11g to 12c and applied latest PSU every quarter.
  • Applied PSU (Patch Set Updates) more than 250 servers.
  • Applied Patch Set Updates (PSU) on regular basis.
  • Installed 11.2.0.4 RAC on 2-node and applied PSU 4.
  • Applied PSU 20299016 on 12.1.0.1.0 to upgrade to 12.1.0.1.7.
  • Apply security patches (CPU/PSU) and bug fixes on databases and Grid Infrastructure Coordinate with Onshore and Offshore team members.
  • Applied CPU/PSU database patches using OPatch utility.
  • Applied grid infrastructure PSU including database PSU to upgrade grid and database home to latest version using OPatch utility.

Show More

45. Veritas

demand arrow
low Demand
Here's how Veritas is used in Senior Oracle Database Administrator jobs:
  • Managed and monitored the Oracle Real Application Cluster (2 node RAC) running on VERITAS storage.
  • Performed regular backup of the entire network using VERITAS Exec 11d, and 12 Tape Backup.
  • Implemented 11i on an active/passive VERITAS Cluster Server (VCS) when 11i was not cluster-aware.
  • Implemented VERITAS Net Backup using RMAN (Recovery Manager) as a media management layer.
  • Experience in High availability design with VERITAS Cluster and Volume Management.
  • Experience in monitoring the VERITAS Net Backups.
  • Installed Oracle on VERITAS Cluster.
  • Mentored PeopleSoft Sysadmin, DBA and PeopleSoft Application and Veritas Cluster Services environment.
  • Configured and installed Oracle ASM volume manager, and replaced veritas volume manger software for the enterprise.
  • Recommend and implemented fail over solution for SAP architecture using Veritas HA solution and IBM HACMP capability.
  • Monitored VLDB applications running on 2/3 node Veritas clusters for various production and performance issues.
  • Used to perform back up and recovery using Veritas NetBackup integrated into RMAN.
  • Worked on SAN Maintained and Monitored the VERITAS Net backups.
  • Implemented backup and restore strategy using VERITAS Netbackup.
  • Maintained Oracle Databases in a Veritas Clustering/RAC configuration Installed, Configured and Implemented Oracle Enterprise Manager
  • Installed Sun Servers, installed Solaris OS and Veritas volume manager, configured RAID5 volumes and file systems.
  • Performed Oracle backup and recovery using Tivoli Storage Manager ADSM, BMC SQL Backtrack, and VERITAS Netbackup.
  • Created duplicate databases using RMAN tape backups with Veritas Netbackup.
  • Worked extensively on Veritas Netbackup for DB backups.
  • Used Storage from Vendors Veritas and Hitachi .

Show More

46. ETL

demand arrow
low Demand
Here's how ETL is used in Senior Oracle Database Administrator jobs:
  • Involved in business analysis and technical design sessions with business and technical staff to develop requirements document, and ETL specifications.
  • Partitioned large tables, indexes- implemented global partitioned indexes and also local indexes to improve the performance of ETL file loading.
  • Developed PL/SQL scripts for Extraction, Transporting & Transforming (ETL) data from Production databases to Data Warehouse Databases.
  • Planned and deployed the performance of overall ETL and EUL by logic tuning for smooth execution of the system.
  • Developed ETL to load Data warehouse from Oracle e database according to spec in a fast passed environment.
  • Implemented Star schema design, dimensional modeling, ETL design, physical database design for several DataMarts.
  • Lead a team of 4 developers, in implementing ETL Staging, Transformation, and Loading procedures.
  • Star schema design, ETL process design, dimensional modeling, for a large data warehouse.
  • Involved in ETL tool evaluation, selection, data management strategies, standards, best practices.
  • Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.
  • Experience in Extracting, Transforming and Loading (ETL) data using SQL*Loader Utility.
  • Performed tuning and optimization with ETL Batch Load Processes and web service applications.
  • Installed and configured Oracle Warehouse Builder (OWB) for ETL.
  • Design a new ETL process using in house utilities.
  • Designed and implemented ETL Routines to load Data Warehouse.
  • Performed data migrations and ODI using ETL tools.
  • Architected and developed ETL Procedures using PL/SQL to load and update data from multiple sources.
  • Deployed 5 instance 2 node RAC environments with dedicated dataguard and handled migration to GoldenGate for ETL to BI environment.
  • Utilize cognos reporting and Informatica ETL software to extract, transform and load data into Data Warehouse large production databases.
  • Implemented ETL tools informatics and Ascential.

Show More

1 ETL Jobs

No jobs at selected location

47. Suite

demand arrow
low Demand
Here's how Suite is used in Senior Oracle Database Administrator jobs:
  • Supported on implementing and maintaining an Oracle E-Business Suite R12 application environment.
  • Provided database support for E3 suite of applications which replaces the legacy ENFORCE application for CBP.
  • Managed the Oracle E-business suite Balance scorecard for the high level management to forecast the budgets.
  • Lead and maintain efficient and highly available operation of WebLogic, SOA suite and Portal environments.
  • Installed and maintained the Oracle Application Suite including cloning 11i application for development and testing.
  • Completed upgrade of Oracle e-Business suite from 11.5.10 TO 12.0.6 and then to 12.1.3.
  • Used Oracle Developer Suite 10g, Forms Builder, and Reports Builder.
  • Installed, patched and maintained Oracle E-Business Suite with Single-sign on service.
  • Managed and mentored the clients DBA on supporting Oracle E-business Suite.
  • Implemented Oracle e-Business Suite Application 11i with Shared Application TOP.
  • Installed and implemented OEM 11GR1/AMP 4.0 for the E-Business Suite.
  • Experience dealing with E-business suite and rapid clone.
  • Enabled India Localization in Oracle E-Business Suite R12.1.3.
  • Worked on certificates installation by using wallet for e-business suite Configured hardware load balancer for the servers.
  • Upgraded mission critical 11.5.9 E-Business Suite to 12.1.3 E-Business as part of a multi-year project.
  • Install Ebusiness suite related additional software to support HRMS and Payroll modules such EiS.
  • Integrated Oracle E-business suite 12.1.2 with PeopleSoft Financials 9.1.
  • Implemented 12.2.2 application on Dev& UAT servers Installed and integrated OID, OAM, OEM with R12 E-business suite.
  • Installed, Configured and Mainted e-Business suite R12 Applications and SOPs.
  • Used Oracle E-Business suite (EBS) includingbutnotlimitedto Oracle customerrelationshipmanagement (CRM), Oracle financials, Oracle projectportfoliomanagementaswellas Oracle mobilesupplychainapplications.

Show More

2 Suite Jobs

No jobs at selected location

48. Cloud

demand arrow
low Demand
Here's how Cloud is used in Senior Oracle Database Administrator jobs:
  • Configured and 11g R2 Active Standby database in Amazon cloud for supporting high priority reporting application to offload the primary database.
  • Deployed highly available Oracle Enterprise Manager 13c Cloud Control running multiple OMS servers and Oracle 12c RAC repository database.
  • Monitored the RAC database using OEM 12c Cloud control configured with RMAN database backup and recovery.
  • Implemented OEM Cloud Control 12c Agent installations, plug-ins installations and adding targets to OEM.
  • Installed and configured OEM 13c cloud control and upgraded from earlier versions 12c / 10g.
  • Configured and Installed Oracle 10g for DECC and Virtual machine(VM) Cloud computing.
  • Installed and configured Oracle 12c database and cloud control 12c to monitor all databases.
  • Configure and deploy LDAP and Cloud Control for Oracle RAC Database Management.
  • Install / Configuration of the Oracle Grid Control / Cloud Control.
  • Installed and configured Oracle Cloud Control 12c.
  • Used 12c cloud control to monitor databases.
  • Implemented Oracle Enterprise Manager Cloud Control 12c.
  • Installed OEM 13c, 12c cloud agents and migrated the targets from 10g OEM to 12c / 13c.
  • Installed ORACLE 12c database and Cloud control (12.1.0.3) on Linux 64 bit server.
  • Involved in Upgrading Oracle 11g OEM GC to 12c OEM Cloud Control.
  • Configured and Installed Oracle 11g and VMWARE Virtual machine(VM) for Cloud computing implementations in our new datacenter.
  • Boot-strapped Tiffany's Oracle DB [ ] Infrastructure managed by OEM 12c Cloud Control and completed with industrial best practice.
  • Perform full lifecycle duties from Cloud Infrastructure design, build/test, deployment, and Go-Live support.
  • Manage users, privileges and profiles, schemas using Oracle 12c Cloud Control.
  • Installed and setup Oracle [ ] Enterprise Manager for cloud on AWS.

Show More

49. SAN

demand arrow
low Demand
Here's how SAN is used in Senior Oracle Database Administrator jobs:
  • Performed AIX administration, SAN administration and software installation.
  • Plan and project system-wide resources usage, especially with disks (SAN/NAS) into future in a whole enterprise scale.
  • Experience using modeling tools, logical and physical database design and SAN storage and Proficient in Enterprise Database Operations.
  • Migrated over database of 30 business units from Santa Ana to Dell Data center in Quincy, WA.
  • Coordinated with System Admin's for Server Support, NAS and SAN storage.
  • Supported SAN Migration and ASM migration, allotted new candidate disks.
  • Upgraded Oracle11g Sandbox database to the latest release for TDE project.
  • Migrated Oracle ASM and Oracle Cluster File System (OCFS) to new SAN Storage.
  • Install, upgrade and manage Oracle RAC databases with ASM and SAN.
  • Worked with the OS / TSM / SAN admins on infrastructure issues.
  • Recreated ASM storage for QA to new SAN.
  • Design, develop, and manage data on Cassandra cluster End-to-end performance tuning of Cassandra clusters against very large data sets.
  • Installed Oracle VM Manager 2.2 and 3.0.2, installed VM Servers, configured networking and SAN Storage, setup multi-pathing.
  • Utilized OEM (Oracle Enterprise Manager), TOAD and DBArtisan to monitor and tune multiple databases.
  • Worked extensively with OEM, Toad and pl/sql developer, DB Artisan to perform various db activities.
  • Worked closely with Sun Storage and Unix team for the RAC setup and distribution of san space.
  • Well versed with Veritas Cluster Environment, SAN storage systems, RAID, Logical Volume Manger.
  • Performed pre-action test in Sandbox database including regression and smoke testing for Oracle TDE settings.
  • Experience in monitoring Cassandra, Mongo DB and Windows 2008/12 Databases.
  • Worked with DBArtisan, Compuware Vantage View, Tivoli, VMware tools.

Show More

50. EMC

demand arrow
low Demand
Here's how EMC is used in Senior Oracle Database Administrator jobs:
  • Developed backup and restore strategy, processes, and procedure using RMAN and EMC s BCV feature.
  • Worked with Legato, and EMC vendors to evaluate the fault tolerant, and disaster recovery methods.
  • Created, tested, documented and implemented shell scripts for database backups using EMC's NMDA.
  • Worked on configuring Oracle Data Guard and EMC Symmetric Remote Data Facility on production server.
  • Configured Automatic storage management (ASM) with EMC storage for managing data in SAN.
  • Worked on Automatic Storage Management (ASM) with EMC Storage for managing data.
  • Used extensively EMC SRDF replication technology to manage the Disaster Recovery sites.
  • Managed EMC Clusters for physical layout of partitioned tables and indexes.
  • Implemented Automatic Storage Manager (ASM) ASM on EMC SAN.
  • Created backup/recovery procedures using RMAN interacting with EMC Symmetric SRDF.
  • Worked with EMC on migrating SAN/NAS storage.
  • Configure RMAN with TSM We are working on Oracle database backup also by using EMC SnapView, SnapMirror.
  • Experience in storage migration from Netapp to EMC.
  • Restore and recover databases using EMC Networker.
  • Upgraded Oracle 10G RAC on Redhat Linux with ESXi and EMC Clarion that included patching to version 10.2.0.4 from base release.
  • Installed multiple Sun Solaris Systems in a clustered environment with redundant backup, failover and replication utilizing EMC's BCV technology.
  • Upgraded 2 Node RAC cluster from 11.2.0.2 database to 11.2.0.4 Configured RMAN cumulative backups and Recovery with EMC DataDomain storage.
  • Configured EMC-CX4 240 san, setup zoning, luns for Oracle VM environment.
  • Worked on EMC Symetrix DMX, EMC CLARiiON NAS devices, DMX SAN storage devices.
  • Used Storage from Vendors Veritas , Hitachi , SAN , EMC , HP , Oracle.

Show More

Senior Oracle Database Administrator Jobs

NO RESULTS

Aw snap, no jobs found.

20 Most Common Skills For A Senior Oracle Database Administrator

Database

22.4%

Recovery Procedures

6.6%

Rman

6.5%

Pl/Sql

6.5%

SQL Trace

6.5%

Linux

5.1%

DBA

4.4%

OEM Grid

4.2%

ASM

4.1%

Solaris

3.9%

Unix

3.7%

AWR

3.3%

High Availability

3.3%

Automatic Storage

3.2%

Setup

3.2%

Toad

3.0%

AIX

2.8%

Addm

2.7%

Explain Plan

2.3%

Capacity Planning

2.2%
Show More

Typical Skill-Sets Required For A Senior Oracle Database Administrator

Rank Skill
1 Database 16.0%
2 Recovery Procedures 4.7%
3 Rman 4.7%
4 Pl/Sql 4.7%
5 SQL Trace 4.6%
6 Linux 3.7%
7 DBA 3.1%
8 OEM Grid 3.0%
9 ASM 3.0%
10 Solaris 2.8%
11 Unix 2.7%
12 AWR 2.4%
13 High Availability 2.4%
14 Automatic Storage 2.3%
15 Setup 2.3%
16 Toad 2.2%
17 AIX 2.0%
18 Addm 1.9%
19 Explain Plan 1.7%
20 Capacity Planning 1.6%
21 Tkprof 1.5%
22 Data Guard 1.4%
23 Statspack 1.4%
24 SQL 1.3%
25 Physical Standby 1.2%
26 Production Environment 1.1%
27 CPU 1.1%
28 Red Hat 1.0%
29 Goldengate 1.0%
30 Performance Issues 1.0%
31 Export 1.0%
32 Rhel 1.0%
33 Troubleshoot 0.9%
34 Hp-Ux 0.9%
35 Data Warehouse 0.9%
36 Table Spaces 0.9%
37 QA 0.9%
38 Space Management 0.9%
39 I/O 0.9%
40 Rdbms 0.8%
41 Oltp 0.8%
42 R2 0.8%
43 Data Pump 0.8%
44 PSU 0.8%
45 Veritas 0.7%
46 ETL 0.7%
47 Suite 0.7%
48 Cloud 0.6%
49 SAN 0.6%
50 EMC 0.6%
{[{skill.rank}]} {[{skill.name}]} {[{skill.percentageDisplay}]}%
Show More

6,576 Senior Oracle Database Administrator Jobs

Where do you want to work?

To get started, tell us where you'd like to work.
Sorry, we can't find that. Please try a different city or state.