We provide IT Staff Augmentation Services!

Senior Oracle Dba Resume

Nyc, NJ

PROFESSIONAL SUMMARY:

  • Over 10+ years of IT and Oracle DBA experience in Oracle 8i, 9i, 10g & 11g database implementation and administration, tuning and troubleshooting.
  • Good exposure in complete range of Oracle DBA activities including day - to-day production database monitoring, Backup & Recovery using RMAN, Troubleshooting production issues, Performance Tuning, Physical Database design, Extensive SQL and PL/SQL skills.
  • Proactive monitoring of the database using third-party tools, providing extensive support for Application Development Team for fine tuning applications and resolving the issues.
  • Good working experience with Oracle 10g & 11g on LINUX and Windows platforms supporting OLTP and Data Warehouse projects.
  • Experience in Oracle 8i/ 9i/10g / 11g Database planning, Installation, Patching, Cloning, and Upgrade.
  • Installed, Configured and Administered Production databases for 24x7 availability for auditing, monitoring.
  • Experience in Oracle ZFS Appliance and Oracle snap management Utility SMU
  • Experience in Configuring Single instance and multimode Oracle Real Application Clusters (RAC), Automatic Storage Management (ASM), Data guard.
  • Experience in Backup & Recovery, Disaster Recovery options, Oracle Recovery Manager (RMAN).
  • Experience in working with Grid Control and Oracle Enterprise Manager (OEM). Grid Control for
  • 24*7 Production Database Support to ensure availability, efficiency and recoverability.
  • Expertise in Installing and configuring ASM and RAC for high availability databases.
  • Experience in Oracle Golden Gate installation, configuration, troubleshooting GG issues
  • Experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by using tools/utilities by Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM).
  • Experience in maintaining Oracle Data Guard like Physical Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods.
  • Skilled in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
  • Expertise Oracle Enterprise Manager (OEM), Grid Control, TOAD, RMAN.
  • Cloned Database from Production to Test and Development.
  • Experience in migration of oracle database to higher version and installing patches.
  • Exporting and Importing of dumps using EXPDP and IMPDP.
  • Knowledge of new features in 11gR2, like RAC-One Node and replication using OracleGolden Gate.
  • Configured Standby database (Data Guard) for BCP/DRP (Business Continuity Plan and Disaster Recovery Plan). And configuring the advanced replication for reporting database.
  • Configured Oracle Golden Gate 11g.
  • Monitoring and optimizing the Database Performances through Database Tuning, System Tuning and Application Tuning using AWR, ADDM, DBMS SQLTUNE, SQL ADVISOR, DBMS STATS, Explain Plan, SQL*Trace, TKPROF.
  • An excellent communicator with ability to work independently as well as collaboratively in team environment to contribute problem-solving strategies. At ease in interacting with people at all levels, able to work under pressure.
  • Excellent interpersonal, analytical, communication and detail oriented organizational skills.
  • Good Understanding / Knowledge in Oracle Exadata.

TECHNICAL SKILLS:

Technology: RDBMS, Oracle

Databases Used: Oracle 11g, 10g, 9i & 8

Operating system: Linux, Sun Solaris, Aix, HP Unix, Windows 2003

Database Languages: SQL and PL/SQL

Tools: Toad, SQL Developer for 10g, Oracle 10g, Oracle 10g RAC,11g RAC, OEM 12c, TOAD,, puTTy, TightVNC, GoldenGate, Data Guard, ZFS Appliance, SMU

Reorg Tools: Space manager Quest reorg

Backup Tools: RMAN, Symantic, NetApp, EMC, ZFS Appliance for SnapshotReplication Tool : Golden Gate, Advanced Replication

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle DBA

Technologies: Oracle 11g, 10g, 9i, 8, RMAN, Data Guard, RMAN, Golden Gate

  • Onsite - Team Lead building exercises for the DBA team.
  • 24/7 support availability and working with SME at Staples Inc.
  • Database installation, migration in various platform.
  • Golden Gate installation.
  • Applying Oracle PSU Patch in SAP Critical database & SOX database.
  • RMAN backup implementation in non-production and production database.
  • Oracle databases RMAN restore / recovery based on end user request in non-production to non-production database Or production to non-production database.
  • Physical standby database Data Guard monitoring and building database. Providing Disaster Recovery Plan.
  • Configured Physical standby environment for disaster recovery
  • Proof of concept in Oracle Exadata with Real application cluster.
  • Experience and handling in Oracle 10g, 11g Flashback technologies in Real application testing.
  • Oracle 11g R2 database installation and building database based on application requirement as part Oracle delivery / development team.
  • Providing database support to SAP database.
  • Implementing / Monitoring GoldenGate process in Source & Target database.

Confidential, NYC & NJ

Senior Oracle DBA

Technologies: Oracle 11g, 10g, 9i, 8, RMAN, Data Guard, RMAN, Golden Gate, Netapp, ZFS Appliance

  • Onsite - Team Lead and Oracle Service team management , team building exercises for the DBA team & Oracle Development / Delivery Team for building / migrating database .
  • Managing Oracle database from East Coast EC, West Coast WC & International database servers UK .
  • Working with Customer for Daily / Weekly reports for infrastructure support request and request for change SLA tickets.
  • Preparing Daily Call report and discussing with Customer for ongoing ISR’s update / Outage update.
  • Request for Change management approver for Oracle database & reviewing pre-work technical criteria in RFC ticket.
  • Developed database system build sheets, code review check lists, code promotion process documents, outage reporting documents.
  • 24*7 Production Database Support from EST / PDT & IST Time Zone. Providing Second level of technical support from Onsite.
  • L3 support in Outage handling and providing RCA & RCCA document.
  • Providing L2 Technical support and managing ONAIR production database during US presidential election 2012, Golf Now 2012 & Sochi Winter Olympics 2014.
  • Working with SAP Team for implementing Quest Space manager tool and planning for SAP Online table reorganization.
  • Providing support to SAP Large database and cloning SAP database using EMC Recovery point.
  • Monitoring SAP tablespace by Daily and Weekly basis & Weekly Status call for SAP supporting database ongoing open items.
  • Oracle 10g, 11g standalone / Real application cluster database migration from various storage in EMC.
  • Performing all the database administration activity like space management in database, user and roles administration, schema management, checking alert log of the entire database.
  • Monitoring alerts from OEM, Alert log notification from non-production and production database.
  • Database Job management from OEM, ControlM.
  • Involved in the process of tuning and refining queries of various applications.
  • RMAN backup implementation in non-production and production database.
  • Oracle databases RMAN restore / recovery based on end user request in non-production to non-production database Or production to non-production database.
  • Physical standby database Data Guard monitoring and building database. Providing Disaster Recovery Plan.
  • Closing database using Oracle snap management utility 1.2 SMU and ZFS appliance snapshot.
  • Configured Physical standby environment for disaster recovery
  • Involved in Real Application Cluster administration including 10g, 11g Database cloning, tuning, patching and monitoring concurrent manager processing etc.
  • Critical Patch Update / Patch Set Update installation in non-production and production database.
  • Proof of concept in Oracle Exadata with Real application cluster.
  • Experience and handling in Oracle 10g, 11g Flashback technologies in Real application testing.
  • Oracle 11g R2 database installation and building database based on application requirement as part Oracle delivery / development team.
  • Proof of Concept document prepare using Real Application Testing for new hardware migration.
  • Creating table spaces, sizing the system table space, allocating default table spaces for users.
  • Creating tables and indexes, sizing their extent, partitioning and so on.
  • Creating users with restricted access, with default and temporary table spaces.
  • Creating roles and granting to users based on their group requirements.
  • Creating profiles and attaching them with users.
  • Performing hot and cold backups. Restoration and recovery from backup.
  • L1 support in Oracle Golden Gate monitor.

Confidential

Team Leader

Responsibilities:

  • Giving Support to Santander Cards UK.
  • Providing Level2 and level3 support.
  • Supporting 24*7 Production databases.
  • Fulfill DBA daily activities like User management, Space Management, Undo Management, Database Monitoring, Listener monitoring, Backup (RMAN) Management, Blocking session, etc.
  • Configuring and managing Oracle Cluster, Cluster database, ASM on Linux using DBCA, Provisioning through Grid Control & Cluster verification utility.
  • Troubleshooting Oracle Data Guard on RAC through provisioning.
  • Making backup strategies of different databases depend on environment, size, etc.
  • Collecting Statspack (9i) and AWR (10g) report and analyze the reports. Based on those report Tune databases.
  • Troubleshooting oracle errors (ORA-600, etc) and providing support and helps to the clients.
  • Upgrading Oracle RAC database.
  • Applying Bug fixing patches on oracle software.
  • Recovery of production databases at the crisis situation in time.
  • Refreshing Preproduction, Development databases from production databases through export/import, datapump, RMAN.
  • Monitoring RAC, RAC databases, ASM, Listener
  • Customer Interaction & Coordination between the team members.
  • Approving/Rejecting Change Request

Confidential

Oracle DBAResponsibilities:
  • Team Member - Giving Support to Sabic-IP, US, Asia Pacific & Europe.
  • Working in OS Cluster Environment and Handling Production DB’s and Development DB’s
  • Maintaining and Monitoring Backup activities throw AutoSys Tools.
  • Day-to-Day database activities like Monitoring Alert logs, Space management and resolving DB errors.
  • Ticket/Case/Task Execution in Production Environment on demand by Application developers.
  • Performed SQL Tuning and gave the reports to the end user about the database health after tuning
  • Monitoring each Instance and Application Usage in OS CLUSTER (Sun OS) Environment.
  • Working with AD utilities.
  • Applying Patches in APPS Environment (Both - Production and Development).
  • Database patch/patch set/cpu patches installation.
  • Tuned system Init.ora parameters for better performance.
  • Code movement to the production databases after testing effectively in test databases
  • Creating objects like tables, indexes, user profiles and auditing the database.
  • Monitoring OEM configuration & Trouble shot OEM.
  • Support Production And Development Databases
  • Need to be available on 24/7 Hour Support
  • Regular logical backup.
  • Regular backup and recovery procedures.
  • Maintaining Database consistency (primary, foreign key constraints)
  • Interface with Oracle Support.

Confidential

Oracle DBAResponsibilities:
  • Team Member, IS DBA – Giving Support to Toshiba TEG, Germany.
  • Monitoring database alert log files & Sun Solaris OS Error logs.
  • Working in OS Cluster Environment and Handling Production DB’s and Development DB’s
  • Maintaining and Monitoring Backup activities through net worker admin.
  • Monitoring Concurrent Manager processing.
  • Day-to-Day database activities like Space management and resolving DB errors.
  • Task Execution in Production Environment on demand by Application developers.
  • Performed SQL Tuning and gave the reports to the end user about the database health after tuning
  • Monitoring each Instance and Application Usage in OS CLUSTER (Sun OS) Environment.
  • Working with AD utilities.
  • Applying Patches in APPS Environment (Both – Production and Development).
  • Database patch/patch set/cpu patches installation.
  • Manage Oracle Basic Replication in 9i & 10g.
  • Monitoring replication activities.
  • Tuned system Init.ora parameters for better performance.
  • Implementing new objects in replication site.
  • Troubleshooting and Conflict Resolution in replication.
  • Code movement to the production databases after testing effectively in test databases
  • Creating objects like tables, indexes, user profiles and auditing the database.
  • Monitoring OEM configuration
  • Support Production And Development Databases
  • Need to be available on 24/7 Hour Support
  • Regular logical backup.
  • Regular backup and recovery procedures.
  • Maintaining Database consistency (primary, foreign key constraints)
  • Interface with Oracle Support.

Confidential

Oracle DBA

Responsibility :

  • Installation and Configuration of Oracle Servers and Installation and Configuration of Oracle Clients.
  • Perform Up gradation and Migration of Databases
  • Apply Patch and Patch Set for the Databases on time.
  • Develop Backup and Restore Strategies
  • Perform Backup and Restore
  • Test Backup and Restore periodically
  • Create and Maintain User Accounts
  • Control and Monitor User Access to the Database
  • Create and Maintain Primary Database Storage Structures (Table spaces etc.)
  • Create and Maintain Schema Objects (Tables, Views etc.)
  • Allocating System Storage and Planning for future storage requirements
  • Perform Database Maintenance functions
  • Monitor and Optimize the Performance of the Database
  • Assist Developers in Optimizing their Applications, Queries etc.
  • Manage Oracle Advanced Replication in 10g.
  • Monitoring replication activities.
  • Implementing new objects in replication site.
  • Troubleshooting and Conflict Resolution in replication.
  • Develop Database Administration tools / utilities / operation procedures
  • Interface with Oracle for Technical Support
  • Ensure Compliance with Oracle License Agreement
  • Documentation as per the Organization Standards.
  • Any other Task assigned by the Reporting Authority.

Confidential

Oracle DBA

Responsibility

  • Installed Oracle 10.1.0.2.0 (10g) on INTEL and created customized database, on Windows 2003 R2.
  • Implemented Planning and Performing Daily, Weekly and monthly Cold and Hot Backups.
  • Created Users and added roles & profiles to users to access the database and Granted necessary Privileges to Users.
  • Gathering statistics using Statspack Report regularly to check the Performance.
  • Monitoring of Space Allocation, Temporary Tablespace Usage, CPU Usage, Shared Pool, Hit Ratios, etc
  • Perform general technical troubleshooting of the database and handling application related problems.

Confidential

Senior DBA 

  • Installed Oracle 10.1.0.2.0 (10g) on INTEL, on WINDOWS, Suse Linux 9.3 and created customized database, on Windows NT Server (Intel XEON, 3GB Ram).
  • Implemented Planning and Performing Daily, Weekly and monthly Cold and Hot Backups.
  • Implemented ARCHIVELOG process and procedures for automatic copying files to development server as they generated.
  • Monitoring alert log file, generating statistics etc
  • Monitoring the backup; both RMAN and User Managed Backup.
  • Creating RMAN cloning of the test database.
  • Duplicate database using RMAN.
  • User creation and Management both on database and application Collect the performance figures by running STATSPACK and tune SQL Query using TKPROF and EXPLAIN PLAN.

Hire Now