SUMMARY

• Result oriented Oracle DBA with 7 years of comprehensive experience in maintenance of Oracle Databases.
• Good knowledge about Oracle Database architecture of standalone and RAC environments.
• Familiarize in Installation and configuration of oracle on Unix and Windows platforms.
• Experienced on Prod, Dev and Test Environments in oracle 11g and 12C environments.
• Experience in Database refresh or cloning and Upgraded the Oracle databases from 10.2.0.5 to 11.2.0.3.
• Extensive knowledge on database administration for Oracle 9i, 10g, 11g & 12c with experience within very large scale database environment and mission critical large OLTP and OLAP systems.
• Excellent experience in installation, setup and configuration of Oracle 9i, 10g, 11g and 12c in HP - UX, Sun Solaris, IBM AIX, Windows 2008, 2012 and UNIX/Linux Environment.
• Installed Oracle 12.1.0.2 and RAC (4-node) systems on Linux 6.5, administration using PL/SQL.
• Installed Oracle 11g & 12c RAC software with ASM File systems.
• Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to 11g RAC environment.
• Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by DATAGUARD.
• Exposure to Oracle Data Vault for providing security using latest version of Oracle database.
• Monitoring Database health using Oracle Enterprise Manager (OEM).
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Appling CPU patches using OPatch utility which are released on quarterly basis.
• Experience in RMAN (Recovery Manager) for backup and recovery solutions.
• Configured Disaster Recovery - Physical Standby Database, Using cold backup.
• Knowledge on Automatic Storage Management (ASM).
• Implemented and configured Oracle RAC database instance on Linux server.
• Database performance tuning by reorganization of the Database to minimize fragmentation.
• Experience in handling administrative tasks, database monitoring tasks, diagnosing database problems and fixing the issues.
• Good knowledge on Shell scripting especially in creating backup scripts.
• Monitoring database performance using AWR and ADDM.
• Availability, Incident, Change and Problem ticket management according to ITIL standards.
• Having Basic knowledge on SQL DBA administrative tasks.
• Quick adaptability on new technologies & zeal to improve technical skills.

TECHNICAL SKILLS

Platforms: Red Hat Linux, Sun Solaris SPARC 9/10, RHEL 5,6 & 7 VM Ware

Database: Oracle 12g,11gR1/R2 (11.1.0.7/11.2.0.3 ), Oracle 10g(10.2.0.4), Oracle 9i), DataGuard 11g

ERP Applications: Oracle E-Business Applications R12 (12.1.3,R12.2),11i (11.5.9/ 11.5.10.2 ), OAM, OID, WebGate and AccessGate

Languages: SQL,UNIX Shell Scripts, C, C++,JAVA and .Net

Third Party applications: HP Service Guard & Data Protector, HP Kintana Applications

Tools: & Utilities: Oracle Enterprise Manager(OEM) 12c,Toad, Putty, SSH,VNC &Winscp, SQL Developer, RMAN,OEM and TOAD

PROFESSIONAL EXPERIENCE

Confidential, Columbus, IN

Oracle Database Administrator

Responsibilities:

• Administrating databases for multiple database technologies i.e. Oracle, ERP and Netezza.
• Cloning of databases cluster database, Normal database using HOT&RMAN Methodologies.
• Performing database upgrade as part of new releases.
• Installed Oracle 11g/12.1.0.2 and RAC (4-node) systems on Linux 6.5, administration using PL/SQL.
• Upgraded database from 11.2.0.4 to 12.1.0.2 on Linux 6.7.
• Experience in Managing Applications on oracle 11g / 12c RAC databases using ASM.
• Oracle Golden gate for replicating the TERADATA data into Oracle databases.
• Linking Oracle and PostgreSQL databases, tuning and back up of both database.
• Daily database administration tasks including backup and recovery through RMAN, Import/Export
• Configured Golden gate downstream mining and Integrated components for active-active replication.
• Installation and configuration of Oracle Grid Control and installing OEM agents on all the database server hosts.
• Monitoring the operating system response in terms of CPU usage, disk space, and swap space by using various UNIX utilities like VMSTAT, ISOSTAT and TOP.
• Maintaining Test and Develpoment databases with Data Guard security.
• Monitoring production databases through Oracle Enterprise Manager (12c) to troubleshoot and diagnose database problems.
• Cloning databases for development/testing environments using RMAN.
• Setting up and monitoring RMAN backups that include archive log backups, full database backups, incremental backups and troubleshooting ORA errors for backup issues.
• Scheduled various maintenance jobs using DBMS SCHEDULER.
• Loading data using SQL Loader and Data Pump utilities.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Applied patches on application and database servers.
• Perform nzbackup of databases and nzrestore of databases/tables.
• Review Netezza System logs for problem diagnosis.
• Regular Refresh of ERP databases.
• Performed pre and post refresh steps during cloning
• Creating users and assigning responsibilities to users.
• Establish and maintain sound backup and recovery policies and procedures
• Managing databases, monitoring, patching, reports for Oracle database from Oracle Enterprise Manager (OEM) i.e. 12c, 11g etc.

Environment: OEM12c/11g, Oracle Database 12c/11g, Oracle ERP Applications R12.1, Oracle RDBMS 11g, RAC11g, DataGaurd 11g, Webogic 11g, Oracle Access Manger 11g & Oracle Internet Directory, HP Service Guard and HP Data Protector, EMC Documentum & GPS Applications

Confidential, Albany, NY

Oracle DBA

Responsibilites:

• Monitoring Alerts and Jobs to ensure the jobs are running in time and troubleshooting long running jobs.
• Performance Tuning: Tuned various large critical OLAP and OLTP databases of Terabytes size using various tools like AWR, and SQL Trace, TK prof, Analyze, ADDM and Explain Plan methods.
• Implemented Database Backup and Recovery concepts using RMAN utilities (scheduling full/incremental/cumulative backups, hot/cold backups writing/editing UNIX Shell Scripts for RMAN).
• Performed Logical Backups for Database migration using Data Pump, Export/Import and Transportable Table spaces.
• Set up 12C OEM Grid Control to monitor all databases centrally. Monitor health, availability, performance, cloned and schedule backups using 12c Grid Control.
• Manage, tune and troubleshoot database issues both on UNIX command line, SQL*Plus, OEM client, Oracle 12c OEM as well as other third party tools (TOAD, SQL Developer).
• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM (client), Oracle 10g database control & SQL*Plus, as well as pre-developed UNIX shell scripts.
• Managed Oracle databases in very large (over 10 TB) and DB2 databases.
• Performed Database, schema and table refresh from Production to Test and Development environments using RMAN Duplicate, EXPDP/IMPDP, traditional export and import.
• Created and Scheduled jobs through Oracle DBMS Scheduler and Oracle CRON.
• Responsible for Creating and dropping of users, granting and revoking rights as and when required.
• Purging the 6 months old data from the database based on business requirements.
• Applied Quarter wise PSU patching in both standard alone and RAC environment in 11g/12c.
• Responsible for providing Oracle database & Applications administrative support.
• Backups Validation and rectifying the issues in the failed backup scripts
• Installing oracle software on different platform and also patches.
• Tuning the warehouse long running SQL query’s and database.
• Migrating database from different platform.
• Handling RMAN backup and restore.
• Installing OEM agent and working on OEM cloud control
• Working on the Tickets based on the Priorities without escalation
• Perform database Refresh activities from Prod to DEV/QA/TEST servers using cold/hot backups.

Environment: Red Hat Linux 5.0, Oracle 11g and 12c, TOAD, SQL Developer, Oracle Enterprise Manager (GC), RMAN, RAC, Data Guard, ASM, TERADATA, TKPROF, Explain plan, AWS, ADDM, SQL* Plus, PL/SQL, SQL* Loader.

Confidential, Chicago, IN

Oracle DBA

Responsibilities:

• Working with Remedy Ticketing tool for providing services and solutions.
• Regular Monitoring of alert log files & trace files and checking database statistics regularly.
• Creating users and roles & assigning different roles to users.0
• Data refresh from production to development & test Databases.
• Database restore and recovery using RMAN and manual methods.
• Monitoring Disk space usage and tablespace usage.
• Cloning databases with various strategies like Cold, Hot and RMAN.
• Involved in Production Database Upgradations from 9i to 10g.
• RMAN backup setup for the newly cloned instances.
• Applying CPU/PSU patches on the database.
• Managing the Dataguard and ASM databases.
• Managing OCR, Voting disk and performing restore and recovery operations.
• Administering Oracle Clusterware and the RAC database instances using CRSCTL, SRVCTL, OCRCONFIG, CLUVFY utilities.
• Troubleshooting RAC Instances & Listeners
• Extensively worked on Backend Programming using PL/SQL, Stored Procedures, Functions, Packages, Database triggers for Oracle and also SQL queries and scripts.
• Experience in using SQL TRACE and TKPROF tools for Explain Plan, SQL tuning, collection of statistics and creation of indexes for database access and indexing the required columns.
• Maintaining the logical and physical organization of the database, like organization of database into different table spaces and organization of data files on different disks to reduce disk contention.
• User Management - creation and maintenance of users, creation of Roles and profiles.
• Helping application team with PL/SQL stored procedures.
• Regular backups & Recovery. Writing automated Regular Daily backup procedures using RMAN.
• Transferring of data across different platforms using SQL*LOADER.
• Converted the standalone MS-Access reports into Oracle Reports, web reports with business logic written in PL/SQL.
• Good experience in version control of documents and database objects using tools like StarTeam and GIT.
• Extensively worked with third party database tools like TOAD &PL/SQL Developer.
• Worked in Agile Environment as an OraclePL/SQL Developer
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using SQL,PL/SQL and SQL Loader

Environment: Oracle database 10g, SQL Developer, Data Modeler, TOAD, Oracle10.2.0.1, HP-UX 11, Sun Solaris 10.0 and Oracle Streams

Confidential

Data Analyst

Responsibilities:

• Monitoring Alerts and Jobs to ensure the jobs are running in time and troubleshooting long running jobs
• Working with Remedy Ticketing tool for providing services and solutions.
• Regular Monitoring of alert log files & trace files and checking database statistics regularly.
• Data refresh from production to development & test Databases.
• Database restore and recovery using RMAN and manual methods.
• Monitoring Disk space usage and tablespace usage.
• Cloning databases with various strategies like Cold, Hot and RMAN.
• Involved in Production Database Upgradations from 9i to 10g.
• RMAN backup setup for the newly cloned instances.
• Applying CPU/PSU patches on the database.
• Managing the Dataguard and ASM databases.
• Managing OCR, Voting disk and performing restore and recovery operations.
• Administering Oracle Clusterware and the RAC database instances using CRSCTL, SRVCTL, OCRCONFIG, CLUVFY utilities.
• Troubleshooting RAC Instances & Listeners.
• Meet with clients to determine their needs, gather and document requirements, communicate with customers throughout the project to manage customer expectations, resolve issues, and provide project status.
• Data Analyst in Data Architecture Team and responsible for Conceptual, Logical and Physical model for Data Repository.
• Written Complex queries using JOINS, RANK, STUFF, PIVOT and UNPIVOT.
• Validate the models with the production data and developed the STT (Source to Target) Mapping matrix, an expert solution to design and develop the mappings for the loading of data, to the ETL developers.
• ETL Testing by writing minus queries on source column data and target column data to check if any difference occurs.
• GitHub repository for storing the Data Warehouse and number of branches depending on the number of Analysts working for ETL.
• Collaborated with DBAs to ensure that any business issues, rules or concepts are reflected on the Physical Database Design.
• Devised & Implemented backup strategies using hot, cold, and exports based on the business requirements. Query Optimization to reduce load over the system and best performance.
• Partitioning and Indexing for better query speed.
• Analyzed the forecasting of data for future application growth and worked and worked with DBA's to come up with the necessary space.
• Dataanalysis of existing database and new sources to understand the dataflow and business rule applied to different databases by SQL.

Environment: ERWIN, Oracle Data Modeler, Oracle SQL Developer, Oracle 10g, Amazon Cognito Console, MS SQL Server, GitHub.