We provide IT Staff Augmentation Services!

Technical Architect Lead Oracle Dba Resume

Richmond, VA

PROFESSIONAL PROFILE (SUMMARY):

  • Total Experience is 12+ years as Oracle DBA. Worked as a Lead DBA 5 years.
  • Hands on experience on Oracle 9i, 10g, 11g, and 12c.
  • Hands on experience of upgrading databases from 10g to 11g and 11gr2 to 12C.
  • Oracle Core DBA experience: 11 years
  • Oracle RAC experience: 8 years (10g, 11g and 12c)
  • Application and Database level tuning: 4 years
  • Installed and configured Oracle Enterprise Manager 11g, 12c and 13c.
  • Hands on experience of AWS - includes instance creation, S3 storage management, security and identity access management, administration of RDS instance.
  • Golden Gate 11g - 2 years
  • SQL server 2008 R2 - 2 years
  • Excellent knowledge of shell scripting.

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Technical Architect Lead Oracle DBA

Environment: Oracle 11gR2, 12c and OEM 13c

Responsibilities:

  • Lead the planning, design, implementation, maintenance and backup/recovery and configuration management for production, test and demonstration databases in the DOA environment.
  • Provided key inputs, setup the process of procedures and documentation used for problem resolution and day-to-day maintenance, capacity planning.
  • Participated in planning software upgraded from 11gR2 RAC to 12c. Installed and configured 12c and upgraded the existing databases to 12c.
  • Used 12c new features of Multi-Tenancy and cloned the databases.
  • Provide L2 and L3 PeopleSoft DBA support for Finance, HCM and BI.
  • Supported and participated planning of PeopleSoft upgrade from 8.50 to 8.55.
  • Supported BI upgrade database OBIEE - OBIA 11.1.1.7.1 to 11.1.1.9.1
  • Monitoring software database license process
  • Successfully migrated total 15 databases (Production and Non-production) character set from Western European Unicode (WE8ISO8859P15) to character set WE8MSWIN1252.
  • Excellent knowledge in working with Oracle on Ora-600, 700 and resolved bugs/issues with DBMS software by applying patches/fixes.
  • Managed planned, designed, Installed and configured 13c OMS from 11g, installed agent on each target server, installed and configured PeopleSoft plugins, configure notifications and alerts rules, managing groups and access.
  • Supported Development, Test and Production teams, plan the refresh of non production database on regular basis as per the project requirement (at least once in a week)
  • Provided support to database maintenance activities like OS level patching, network or storage issues or application maintenance.
  • Troubleshoot Database performance issues using Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM) and Active Session History (ASH).
  • Good experience designing and implementing backup and recovery strategy for databases using Recovery Manager (RMAN), traditional Export/ Import, Export/Import Datapump as well as conventional Hot/Cold Backups.
  • Using UNIX Crontab and writing Shell Scripts for automated monitoring, backup and data loading.
  • Resolved database network problems using Oracle Net Configuration Assistant, Oracle Net Manager, Netstat and tnsping utility.
  • Provided outage resolution support and perform analysis to resolve recurring database issues
  • Provided database support for software development/ application projects
  • Verifies on a daily basis that database backups have completed successfully, RMAN backup on tape using third party tool for non-prod and production databases.
  • Implemented TDE (wallet), enabled database audit trail.
  • Monitoring performance of the system and jobs on regular basis and reported issues Fine Tune SQLs
  • Developed/designed/performed disaster recovery plan/drill in every 6 months to test the DOA’s disaster recovery.
  • Developed junior resources in Oracle Skills like SQL tuning, dba activities etc.
  • Completely automated the refresh process of database from production using shell scripting.

Confidential

Tech Arch - Environment lead

Environment: Oracle 11gR2 RAC on Linux 5 (AWS).

Responsibilities:

  • Provided support as tech arch and environment lead.
  • Worked a performance tuning expert and supported PAT team to resolve many database/application level performance issues. Used hints, profiles, scheduled jobs and used materialized view to solve the issues.
  • Involved in I/O tuning by moving data files and redo log files to faster disks.
  • Performed Explain Plan analysis for Query Optimization and SQL tuning with OEM.
  • Performed Database and SQL tuning by using various Tools like STATSPACK, AWR, TKPROF, EXPLAINPLAN, and optimizer hints.
  • AWS environment administration for Vodafone client includes instance creation and security maintenance.
  • Provided database support (database admin) of ST, SIT and PAT databases.
  • Automation is done for monitoring environment and scheduled Crontab job scheduling using shell scripting in Linux.
  • Use S3 command to take backup and restore the images(export & import)
  • Successfully migrated character set few non-production databases from WE8MSWIN1252 to AL32UTF8
  • Used Golden Gate 11g to extract and load data.
  • Supported and maintained Oracle database instances including production
  • To run update statistics on a periodic basis & generate AWR/ADDM reports & analyze as well.
  • Review the scripts developed and ready to deploy, provide analysis on performance and suggest the modification.
  • Data Guard using physical standby database, Implement log miner, Data guard / Standby both physical perform switchover/failover and monitor using Data Guard manager command line and GUI.
  • Supported PAT (Performance Acceptance Test) with respect to database performance and provided many inputs.
  • Resolved issues related to database connectivity, deployment and defects raised by team.

Confidential

Senior Database Administrator

Environment: Oracle 11gR2 RAC and 12c on Linux 5/7.

Responsibilities:

  • Provide L2 & L3 level production support from offshore.
  • Install and configure Oracle RAC 11g release 2 for SAP system. Configured ACFS file system and used shared Oracle Home.
  • Refresh test and QA environment every month/Quarter from production.
  • Test the tape production backup restoration on test server as a scheduled month end activity.
  • Crontab job scheduling and maintenance is done through Linux scripting.
  • Create and configure Oracle database in RAC using DBCA
  • Cloning, Patching, and Upgradation on Database tier.
  • Configure Physical standby database (data guard).
  • Database Backup and Recovery using RMAN and OEM; Refresh the database on periodic basis on test server and on pre-production server.
  • Support and maintain Oracle database instances including production
  • Troubleshoot issues concerned with CRS, OCR and VD in RAC environment
  • To run update statistics on a periodic basis & generate AWR/ADDM reports & analyze as well.

Confidential

VES Data Management Lead - Oracle DBA

Environment: Oracle 11gR1 and 11gR2 Grid on Linux 5.

Responsibilities:

  • Handled the team to provision the data in various system like Oracle and Siebel.
  • There are more than 7 test data environment which we support and we do backup and refresh the test instance with production dump given by production team.
  • We created some batch jobs which configure/modify and generate the dummy data in the respective system.
  • Used Golden Gate 11g to extract and load data.
  • Automation is done through Oracle PL/SQL, UNIX scripts.

Confidential

Data Automation Lead - Oracle DBA

Environment: Oracle 11gR1 on Linux.

Responsibilities:

  • The FileAid tool to generate XML message files for the specified request.
  • Java program generate batch files to execute the TIL services using generated XML message files.
  • Designing Data Model for SPOT database for storing the required data and maintaining the data provided to the project.
  • Anonymization of production data through FileAid tool.
  • Design and develop a framework of generating the data in respective systems through automation.
  • Refresh the test instance with production dump.
  • Wrote Oracle PL/SQL code for fetching data and updating data in master database.
  • Provide support to OLAP database.
  • Take the regular backup of the SPOT database.

Confidential

Oracle PL/SQL and oracle DBA

Environment: Oracle 10gR4 RAC and Oracle 11gr2 Grid on AIX

Responsibilities:

  • Install two nodes Oracle 10g RAC on IBM AIX also installed and configured Oracle 11g release 2.
  • Install and configure Oracle 10g Application Server for Java Application Module.
  • Administration of 21 production (OLTP) database for HDFC Ergo and 1 OLAP.
  • RAC implementation on test environment for High Availability.
  • Added a new Node on RAC production database.
  • Create and configure Oracle database
  • Cloning, Patching, and Upgradation on Database tier.
  • Configured Physical standby database.
  • Database Backup and Recovery using RMAN using Tape and Disk and OEM, Refresh the Backup on periodic basis on test server and on pre-production server.
  • Support and maintain Oracle database instances including production.
  • Troubleshoot issues concerned with CRS,OCR and VD in RAC environment
  • To run update statistics on a periodic basis & generate AWR/ADDM reports & analyze as well.
  • Apply database and applications patches, Perform SQL tuning, Assist developers in PL/SQL.
  • Perform space management and log checking for capturing errors.
  • Resolving issues related to database connectivity and application connectivity.
  • Write PL/SQL procedure and function for Database integration and schedule jobs.
  • Create and Manage Services with the help of SRVCTL and DBCA.
  • Configure the listeners and aliases to set up Transparent Application Failover (TAF).
  • Data migration from legacy system to new systems.
  • SQL*LOADER was used to load data from external files.

Confidential

Performance Tuning and Oracle DBA

Environment: Oracle 10gR3 RAC on HP-UX.

Responsibilities:

  • Installed Oracle 10gR3 RAC on HP-UX for NSDL client for other application.
  • Administration production database, maintaining statistics and scheduled all sort of backup includes RMAN, hot backup, and export backup on different criteria using HP data protector software to take backup on Tape.
  • Created UAT and Pre-production database.
  • Used the utility AWR and TKProf for the finding out the most time consuming queries.
  • Wrote and reviewed Oracle procedures, functions, created indexes for performance tuning, fixed the bug by assigning the task to the team. Suggested application level tuning for the same.
  • Created and Managed Services with the help of SRVCTL and DBCA.
  • Backup of RAC database and restore on single instance Preproduction server to test the backup are proper and working fine.

Confidential

Team Lead Oracle DBA plus PL/SQL Lead

Environment: Oracle 10gR3 RAC on AIX.

Responsibilities:

  • Installed and configured 3 nodes Oracle 10gR3 RAC on IBM AIX for Universal Sompo General Insurance.
  • Installed Oracle 10g Application Server on Linux 4 for different Module.
  • Set the process for Maintaining statistics and scheduled all sort of backup includes RMAN, hot backup, and export on different criteria using Tivoli third party tool to take backup on tape.
  • Wrote the PL/SQL code for the project and reports.
  • Restored the database from backup up to tablespace and data file level.
  • Configured the servers for the application. Setup the process for Release management. Tuned the queries, procedures and functions.
  • Administration of Services with the help of SRVCTL and DBCA.
  • Configured the listeners and aliases to set up Transparent Application Failover (TAF).
  • Given the training of Oracle PL/SQL and Database Administration to the team.
  • Analysis of customer requirement, fix the bug by assigning the task to the team and maintain the timelines.

Confidential

DBA cum PL/SQL programmer

Environment: Oracle 9i single instance on Windows.

Responsibilities:

  • Monitoring production database.
  • User and tablespace management.
  • Export production database and import on test environment for EOD and EOM activity.
  • Take hot backup and cold backup
  • CR development and deployment after successfully tested
  • Involved in EOY audit in LIC DMS.

Hire Now