Oracle DBA Resume

SUMMARY

Overall 13 years of experience as an Oracle Database Administrator including one year as Oracle EBS DBA providing end - to-end production database support.

TECHNICAL SKILLS

Databases & Related Technologies: Oracle 12c/11g/10g/9i, Oracle 10g RAC, Oracle 11g RAC, ASM, Streams, Active Data Guard, Grid Control (OEM), Golden Gate, Exadata.

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, IBM, Red Hat, Linux RHEL 2.1, 3.x, 4/5/6

Languages: SQL,CQL, PL/SQL, UNIX Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Responsibilities:

Responsible for maintenance, tuning and support of Production, Development and Staging instances of Oracle Version 11g and 12c in Linux, HP-UX environments.
Performed database upgrades to 12.2 from lower versions.
Monitor database performance and implement changes and apply new patches and versions when required.
Minimize database downtime and manage parameters to provide fast query responses.
Perform tests and evaluations regularly to ensure data security, privacy and integrity.
Hands on experience on RAC multi-node environment.
Provide proactive and reactive data management support and training to users.
Generating AWR reports whenever required and find the bottlenecks and provide solutions

Confidential

Oracle DBA

Responsibilities:

Responsible for maintenance, tuning and support of Production, Development and Staging instances of Oracle Version 11g and 12c in Linux, HP-UX environments.
Performed database upgrades to 12.2 from lower versions.
Implemented ASM on RAC and stand-alone databases as per the client requirement.
Monitor database performance, implement changes and apply new patches and versions when required.
Minimize database downtime and manage parameters to provide fast query responses.
Perform tests and evaluations regularly to ensure data security, privacy and integrity.
Hands on experience on RAC multi-node environment.
Provide proactive and reactive data management support and training to users.
Generating AWR reports whenever required and find the bottlenecks and provide solutions
Hands on experience on Golden gate implementation and troubleshooting.

Confidential

Oracle DBA

Responsibilities:

Responsible for maintenance, tuning and 24x7 support of Production, Development and Staging instances of Oracle Version 8i, 9i, 10g, 11g in HP-Linux environments. Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
Involved in database migrations from AIX to Linux servers.
Worked closely with System Administrators, Network Administrators to build the RAC environment.
Create cronjobs for automatic RMAN backup, RMAN purge backup.
Involved in upgrading databases from 10g to 11g VERSION. Installed and configured RAC databases 10g and 11g.
Analyzing query performance issues and tuning the long running queries.
Performed DR drills for all Citgroup databases as per the schedule.
Hands on experience on RAC multi-node environment.
Installed oracle 11gR2 grid infrastructure on customer servers.
Generating AWR reports whenever required and find the bottlenecks and provide solutions
Hands on experience on Golden gate implementation and troubleshooting.
Involved in Oracle EBS upgrade by applying list of patches
Extensively working on performance issue and create Sql profiles and plan baselines to fix the poor performing queries.
Working closely with oracle support on high severity issues.
Check the cursor plan, get the bind values from there, execute the sqls on test environments, and tune the queries accordingly.
Working closely with testing and development teams in identifying and fixing performance issues.
Performing database health checks in regular intervals.
Good at tuning the database, Query tuning. Analyzing Automatic work load repository(AWR), Automatic Diagnostic monitor(ADDM), Working with Explain Plan, Eliminating Chained & Migration Rows, Database health check, Space management and Working knowledge on oracle outlines
Well versed with 11g new features like Workload Replay, SPA, invisible indexes.
Performed the smooth database upgrade from 9i, 10g to 11gR2 without any performance issues.
Run the sql tuning advisor on long running queries and get the optimal execution path for better performance.

Environment: Oracle/10g/11g/12c, Sun Solaris, Windows, Toad, Shell Scripting, RMAN, Sql Developer

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship