We provide IT Staff Augmentation Services!

Senior Oracle Dba Resume

SUMMARY:

  • Around 8+ yearsof experience in Oracle 11g/10g/9i Database Administration and Support.
  • Involved in various administration tasks such as Install, Configuration, Upgrade, Patching, Backup and Recovery, Migration, Memory and Space management, Cloning, Replication, Performance tuning, RMAN, RAC, Data guard, and OEM Grid Control.
  • Experienced in Installation, Configuration and Troubleshooting of Oracle Database on Solaris OS, IBM - AIX, Red Hat Enterprise Linux (RHEL) and Windows on highly transactive and Very large databases (VLDB).
  • Expert level experience in Oracle 10g RAC implementation & administration using Oracle Cluster-ware, Sun Cluster and VERITAS Cluster Server.
  • Worked on Oracle Cluster ware setup and configuration, RAC installation, configuration and patching, RAC Backup and Recovery.
  • Configured Automatic Storage Management (ASM) to fulfill storage needs.
  • Experienced in Implementing, configuring, troubleshooting, switchover, failover of Physical Standby Data Guard on 10g and 11g.
  • Configured and maintained replication using Oracle Golden Gate.
  • Experienced in Backup & Recovery (Cumulative and Differential Incremental backups) techniques of databases running in ARCHIVELOG MODEusing RMAN.
  • Used ADDM (Automatic Database Diagnostic Monitor), AWR (Automatic Workload Repository), ASH reports (Active Session History) for analyzing the database performance and tuning.
  • Managing Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
  • Planning and scheduling Physical Backups (offline/online) and Logical Backups.
  • Experience in implementing Flash Back Pointing Time Recovery.
  • Experienced in User Management by granting and revoking privileges according to the requirement.
  • Experienced in Space Managementby Monitoring and Managing Tablespaces.
  • Managed the databases up to date by applying the latest CPU and PSUusing the OPATCH utility.
  • Configured network components like TNSNAMES, Names Server, Connection Manager, etc.
  • Configured Listener for external procedure calls.
  • Performance Tuning of SQL statements and Database using tools like Explain plan, TKPROF, SQL Analyze, STATSPACK and Dynamic Performance Views.
  • Diagnosed and trouble-shoot typical SQL Tuning issues using SQLTXPLAIN.SQL.
  • Experienced in Partitioning and creating Global, Local Indexes on Partitioned Tables.
  • Experienced in Administering Oracle Database using Oracle Enterprise Manager, Toad, PL/SQL Developer.
  • Communicated with Oracle support via Meta-link to troubleshoot day-to-day database issues.
  • Experienced in UNIX bash shell programming.
  • Experienced working on highly available environments.
  • Familiarity with working in an on-call support basis on active Production instances.
  • Well versed in addressing concerns related to DB integration working with cross functional teams and addressing concerns combined with strong problem solving skills.

TECHNICAL SKILLS:

Operating Systems: Red Hat Linux RHEL 2.1, 3.x, 4.x, 5, Windows 95/98/NT/2000/XPSun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2,5.3 and HP UNIX.

RDBMS: Oracle 11g R1/R2, 10g R1/R2,9i.

Scripting: UNIX Shell Scripting SQL, PL/SQL, C, HTML.

Tools: /Utilities: RMAN, OEM, Oracle Management Server, SQL*Loader, SQL Server, Export/Import, TOAD, Data pump, VB, MS Access, Oracle Streams, VMWARE, VSS, VERITAS Net Backup, Quest, Putty, VERITAS cluster manager.

Tuning Tools: AWR, ADDM, TKPROF, EXPLAIN PLAN, STATSPACK, AND ASH.

Database Modelling: Erwin 4.0, 7.3; Oracle Designer.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle DBA

  • Participated in Installing, upgrading and maintaining the Oracle software products/versions for on Linux, Sun Solaris, AIX and HP-UX..
  • Installation, setup and configuration of Data Guard.
  • Performing day-to-day database administration tasks like Table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
  • Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora and sqlnet.ora.
  • Upgraded the Oracle 11g to the latest Release 2 and applied patches as required.
  • Expertise in Upgrading databases and applying Oracle PSU and CPU patches.
  • Extensively used CRSCTL and SRVCTL commands in RAC.

Confidential

SeniorOracle DBA

  • Installed, configured and maintained Oracle 11GR2 4 node RAC on Linux 5.8.
  • Installed, configured, and maintained Oracle 11g R2 on RHEL and upgraded Oracle 11g to 12c.
  • Implemented new TDE setup on 11g and 12c on all Ticketing Databases.
  • Applied level n-1 PSU patch set update on supported database on quarterly release.
  • Performed schema refresh every 9 weeks on all INT, CERT and PROD database.
  • Created services in RAC usingSRVCTL and used CRSCTL to manager cluster ware resources
  • Troubleshoot RAC wait events and improved performance of database.
  • Executed changes to database based on preapproved change requests
  • Backup/Restored& Recovered of the databases using RMAN and FLASHBACK database procedures.
  • Backup and recovered procedures using RMAN.
  • Created scripts for RMAN incremental backups and for full database backups using datapump.
  • Administered User management, Table space management, and file system space management.
  • Expertise in troubleshooting RAC issues, very strong in using ocrconfig to backup OCR and Voting files.
  • Implemented database refresh with the hot backup using full export.
  • Used EXPORT/IMPORT to do table level and full database defragmentation.
  • Monitored disk space, database health checks, database backups and error log scanning.
  • Managed database servers on a highly clustered multi datacenter environment.
  • Configured Servers to achieve the best performance metrics based on benchmarks.
  • Troubleshooting RAC wait events and improving performance of database.
  • Experienced working with Database Resource Management.
  • Developed scripts for transferring data from production server to testing/development servers.
  • Diagnosed and troubleshoot typical SQL tuning issues using SQLTXPLAIN.SQL.
  • Responsible for granting required privileges and roles to users.
  • Setup Monitoring alert log files and trace files for effective troubleshooting.
  • Monitored performance using Advisors, AWR, ADDM, SQL Tuning etc.
  • Upgraded the database by applying patches using OPatch.
  • Effectively supported production instances and off hour support, and hand - offs with offshore teams.
  • Involved in creating Golden Gate EXTRACT and REPLICAT files.
  • Performed Schema as well as Table level Replication using Oracle Golden-Gate.
  • Set up Disaster Recovery solution using Oracle Golden-Gate.
  • Installed and configured Cloud Control 12c(OEM) and deployed 12c agents.

Environment: Oracle 12c/11g/10gon Unix/Aix/Linux,Red Hat Linux 5.8, AIX 6, OEM 12c, RAC, Oracle Advanced Security, Golden gate 11.i, Sybase, Teradata, Defgen utility, 12c Data guard including DG Broker setup, DGMGRL, RMAN, OEM 12c, RAC, Pluggable databases, DBFS, OPatch Auto.

Confidential, Chicago, IL

Senior Oracle DBA

  • Installed, configured, upgraded, and maintained Oracle 10g and 11g R2 on RHEL.
  • Performed daily administrative tasks such as: DB analysis, failed processors check,validation of disk spaces.
  • Migrated 30 TB Databases from HP UNIX to RHEL with minimal down time.
  • Implemented and supported4 Node RAC on RHEL 12c.
  • Performed backup and recovery using VERITAS Netback-up integrated into RMAN.
  • Installed Oracle Goldengate for EDGE application, configuration and maintenance.
  • Upgraded Oracle 10g to the latest Release 2 and applied patches as required.
  • Performed Cold/Hot Backups and databasecloning using RMAN.
  • Upgraded Oracle 10g to the latest Release 2 and applied patches as required.
  • Daily Health Check Up of the Database using AWR, ADDM.
  • Configured Flash Recovery Area in Dev databases.
  • Performed replication of tables to cross platform and createdmaterialized views.
  • Setup backup & Recovery with export and import for non-archive and archive database with RMAN.
  • Developed and enforced both database and OS-level security policies for data protection.
  • Administered all databases in the areas of maintenance, tuning, performance, and troubleshooting.
  • Utilized oracle tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net.
  • Developed table structures, PL*SQL stored procedures and database triggers to implement business rules.

Environment: Oracle 9.2.0.8/10.2.0.4/11.2.0.3 , RHEL 5.8, Hp- Unix 7, Solaris 10, ASM, RMAN, RAC Oracle Enterprise Manager Grid Control, Oracle Goldengate, RDBMS, SQLPLUS, PL/SQL, Shell Scripting, Stored Procedures.

Confidential, Brookfield, WI

Senior Oracle DBA

  • Implemented a setup of 4 Node RAC on Linux in 10g and 11g R2 using VERITAS.
  • Configured and maintained Oracle Cluster-ware.
  • Configured and maintained replication using Oracle Golden Gate.
  • Implemented and Managed Oracle Data Guard on Oracle 11gR2.
  • Upgraded the Oracle 10g to the latest Release 2 and applied patches as required.
  • Created Users with limited rights as per specific module under specific client.
  • Grantedroles and profiles as per system study to users.
  • Performed daily maintenance tasks like space management, rectified locking problems, manage quotas.
  • Configured network components like TNSNAMES, Names Server, Connection Manager, etc. for easy and effective management of Oracle networking. Configured listener for external procedure calls.
  • Implemented Data Guard on production database.
  • Developed and enforced both database and OS-level security policies for data protection.
  • Administered all databases in the areas of maintenance, tuning, performance, and troubleshooting.
  • Developed Scripts for transferring data from production server to testing/development servers.
  • Scripted using Shell and PL/SQL programming to resolve business problems of various nature.
  • Developed and maintained the applications by utilizing ASP.NET.
  • Developed table structures, PL*SQL stored procedures and database triggers to implement business rules.

Environment: Oracle 10.2.0.3/11.2.0.3 , Linux, Solaris 10, ASM, RMAN, RAC, Oracle Enterprise Manager Grid Control, RDBMS, SQLPLUS, PL/SQL, Shell Scripting, Stored Procedures.

Hire Now