SUMMARY:

• 10 plus years of experience in Information Technology as Oracle Database Administrator and knowledge in Systems Analysis and Design, Development and Documentation at various levels.
• Strong Knowledge of all phases of Software Development Life Cycle (SDLC) such as Requirement Analysis, Design, Development, Testing, UAT, Implementation and Post Production support.
• Conducted workshops to gather user requirements and performed Gap Analysis and translate them to technical requirements.
• Performed Oracle 8i/9i/10g/11g/12c software and database installation and upgraded various versions.
• Designed strategies for performing database backups and recovery using RMAN.
• Experience in Implementing Streams, Data Pump, Export and Import utilities.
• Experience in loading data from flat files using external tables, SQL*Loader.
• Experience with Installation, Configuration, Upgrades, Migrations, Administration and Patching (CPU/PSU) of Oracle Databases 10g/11g and Oracle Applications.
• Extensive Performance Tuning experience, specializing in Operating system tuning, SQL tuning, Database/Instance tuning.
• Experience in Database performance tuning using AWR, Statspack, TKPROF, SQL Trace, and Explain Plan.
• Worked with Oracle Databases (12c/11g/10g/9i/8i), ASM, RAC and Data Guard on Unix/Linux/Windows platforms.
• Experience with Standby Database, DataGuard, Replication Active Database.
• Knowledge on Oracle 11g new features like data pump, flashback tables, ADDM, AWR, ASH.
• Experience with Golden Gate installation configuration and maintenance.
• Good Knowledge in Data Modeling tools like Erwin.
• Experience in Implementing and configuring OEM, TOAD and SQL Developer.
• Experience in maintaining Database Security using auditing.
• Experience PL/SQL Packages, Stored Procedure, Trigger, Function.
• Experience PL/SQL Forms and Reports.
• Experience in Installation, Configuration and Administration of 11i/R12 Oracle Applications.
• Experience in Patching, Cloning, Troubleshooting and System Administration of Oracle ERP E - Business Suite 11i/R12.
• Experience in troubleshooting Forms, Reports, and concurrent managers/programs of Oracle Applications 11i/R12.
• E-Business application like Customer relation Management (Oracle order Management), Financial Management (Financial Analytics, Oracle General Ledger (GL), Oracle Payables (AP), Oracle Receivables (AR), Project Accounting (PA)), Human Capital Management (HR Analytics, workforce Management).
• Result oriented, self-motivated, Team player, ability to work independently and within a team.
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.
• Strong analytical problem solving and good communication skills with ability to work within team environment and independently when needed.
• As part of the Architecture team OBIEE Installation, Configuration and Administrative.
• Experience end-to-end OBIEE solution by configuring metadata & building Analytics Repository, dimensional modeling design, building business models, generating reports, and creating Interactive Business Intelligence Dashboards using Oracle Business Intelligence 10.x. as well as 11g.
• MongoDB Database online training from MongoDB University.
• Flexible in 24x7 production oracle database support.

TECHNICAL SKILLS:

Operating Systems:  UNIX, Solaris 5.8/5.9/5.10 , IBM AIX 5.2/5.3, HP UX 10.2/11.10/11.20 , LINUX, Windows NT/95/98/2000/XP

Databases:  Oracle 12c/11g/10g/9i/8, Oracle 11g/10g Real Application Cluster (RAC), SQL Server 2005/2008, DB2

Tools/Utilities:  RAC, OEM Grid Control, SQL* Loader, ASM, Export/Import, RMAN, TOAD, Patch Management, SQLNET, ODBC, Export/Import, Data pump, Data Guard, Putty, VMware, CronTab, Erwin, MS Visio.

Tuning Tools:  TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR

Application Servers:  BEA Web logic, IBM Web Sphere

Language:  UNIX Shell Scripting, SQL, PL/SQL, C/C++, Java

PROFESSIONAL EXPERIENCES:

Chicago, IL 

Oracle DBA

Responsibilities:

• Database Administrator with experience on Unix, AIX and Windows platforms for Oracle (9i, 10g, 11g, 12c).
• Experience in database installation, configuration, monitoring & administration in Production, Stage, and Test & Development environments.
• Optimizing the SQL’s for optimum performance by using through EXPLAIN PLAN, Auto Trace, SQL Trace and TKPROF.
• Performance tuning for an Oracle Database using AWR, ASH and ADDM reports.
• Responsible to improve the performance by Using the Hints, Indexes, Histogram.
• Setting up of Oracle and Application user accounts and passwords, monitoring application security.
• Logical Backup/Restoration strategy of Export and Import.
• Used Data Pump to export and import Tables, Schemas and Database. 
• Cloned Oracle databases using Oracle RMAN.
• Refreshing development databases from PROD using RMAN.
• Implemented Monitoring and Backup Scripts.
• Implementing backup strategies -- RMAN and User Managed Backups. 
• Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
• Automate DBMS tasks with OEM Grid Control 11g.
• Managed ASM storage having 10+ databases. ASM cloning. Prepare/Add/remove ASM disks. Tuning of I/O on ASM based databases. Troubleshoot ASM crashes & memory problem.
• Implemented Data Guard Physical using DG Broker, and experienced with Data Guard new features Active Data Guard and Snapshot Standby.
• Security Administration and Creation of Users, Managing their roles and privileges.
• Control user access and ensure database security through privileges and roles in Oracle 11g
• Hands on experience of High Availability through Oracle Real Application Clusters (RAC).
• Developed shell scripts for tracing Oracle errors, free space in the table spaces and free disk space in Archive destination for production database.
• Shell scripting experience.
• Configured Oracle tools like SQL*Net to access the database from the network.
• Managing Instances, redo log files, Table spaces, Data files, storage structures, rollback segments, Undo segments, Temporary segments, Indexes.
• Assign users appropriate rights and table’s access through roles.

Pittsburgh, PA

Oracle Database Administrator

Responsibilities:

• Installing and Managing Oracle 9i, 10g, 11g, 12C databases for Testing, Development and Production.
• Installation and configuration of databases on Linux, Windows, AIX and Sun Solaris. 
• Managed and resolved design issues during development.
• Build 4 node 11gr2 RAC clusters in Linux servers.  
• Administered 10g and 11g R2 RAC nodes. 
• Identified, resolved, or provided recommendations to other different kinds of the performance problems ranging from Database performance problems to I/O hardware performance problems.
• Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack, and STATSPACK.
• The tools used mainly are TKPROF, Explain Plan, ASH, ADDM and AWR reports.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Worked on implementing new backup procedures using RMAN.
• Refreshed the DEV, Testing and UAT using RMAN and tradition hot backup method.
• Performed capacity planning required creating and maintaining the database environments.
• Created new databases and users, setup RMAN backups, Export, and other monitoring scripts.
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
• Moved database Schema changes to stage or production.
• Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services.
• Database Services creation for distributing the applications across multiple nodes, extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD.
• Space Management, which includes table space creation, adding new data files.
• Experienced with ASM, adding, deleting disks to the disk group.
• Supported development teams for all the database related issues and handled the critical issues like network failures and ASM DISK group errors and node failures in the RAC cluster.
• Implement disaster Recovery through Data Guard and Golden Gate.
• Designed Golden Gate databases to meet business needs. 
• Installation and configuration of Golden gate for replication and resolve issues to sync Databases.
• Set up Oracle Golden Gate unit-directional and Bi-directional setup. 
• Upgrade and Migration of Database from 9.2.0.6 to 10.2.0.2 and applying patches whenever required.
• Developed some Unix Shell scripts to automate database operation and database monitoring.
• Managed Table spaces, Rollback Segments, Redo Logs and other database object.
• Assisted developers in Creating stored procedures, Triggers, Functions, Cursors and Packages.
• Helped the Production teams in Applications Performance Tuning and providing 24*7 Production Support.

Oracle DBA/Data Analyst

Responsibilities:

• Worked with Oracle Databases (11g/10g/9i/8i) on Unix/Linux/Windows platforms.
• Part of the Data Architecture team, which supports development, test and production databases.
• Resolve performance tuning related issues, reports, and queries.
• Perform root cause analysis on failures.
• Tracing, troubleshooting with database performance and tuning issues.
• Monitor and fully analyze performance issues in production Oracle databases by using, Explain Plan, Auto Trace, SQL Trace and TKPROF tools.
• Work actively on Performance tuning such as AWR, ADDM, and ASH, performance statistics collection, and fine-tuning database wait events.
• Designing the security and database access strategies.
• Taking Backups on scheduled time and monitoring scheduled Backups
• Performing backups and recoveries using RMAN conventional hot backups.
• Scheduled RMAN backups purge jobs, Maintenance Jobs using DBMS JOBS, DBMS SCHEDULER and crontab.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Cloned database using RMAN Duplicate. 
• Refreshing development databases from PROD using RMAN.
• Used TOAD, SQL Developer and dynamic view along with dictionary tables to maintained database 
• Monitored databases using OEM.
• Creating and dropping of users, granting and revoking rights as and when required.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Involved in OBIEE upgrade to OBIEE 11g.
• As part of the Architecture team involved in the following tasks.
• Code review of the development work done by all the development teams.
• As part of the Architecture team OBIEE Installation, Configuration and Administrative.
• Worked on OBIEE BI Administration Tool, Presentation Services, Answers, & Interactive Dashboards and Security Implementation.
• Experience end-to-end OBIEE solution by configuring metadata & building Analytics Repository, dimensional modeling design, building business models, generating reports, and creating Interactive Business Intelligence Dashboards using Oracle Business Intelligence 10.x. as well as 11g
• Experience in implementing the Oracle BI Security Setup (groups, data access/query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• 24/7 on-call supports for the production environment.

Oracle database Administrator

Responsibilities:

• Responsible for the design, development, implementation, integration, and maintenance of multiple premium and core database management technologies, tools and utilities.
• Participated in a team environment for the delivery and maintenance of data and/or database management systems.
• Provided technical, interpersonal and administrative skills in performing day to day work
• Escalated issues in a timely manner and provide mitigation recommendations to Data Team Lead and Project Director.
• Experience of installation and managing Oracle databases 8i, 9i and 10g using the OEM Grid Control tools.
• Upgrade and Migration of Database from 9i to 10g Monitored database log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues (deadlocks, I/O, memory, CPU, etc.)
• Performed oracle Software's Installations, Creation of new standalone and clustered databases.
• Trouble shooting and resolving any database and/or application issues or errors that occurred.
• Resolved different issue like space management, conducting sizing, capacity planning and security.
• Maintaining schemas and partitioning tables.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Established database backup/recovery strategy for different databases. Utilized RMAN for backup and recovery strategy. Completed export and import of different databases using Oracle Export / Import utilities and SQL Loader. Applied different recovery procedures for complete and incomplete recoveries depending on the type of failure.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Designed and Developed shell scripts to automate the processes and to proactively monitor the database.
• Monitoring and optimizing system performance using index tuning, disk optimization, advanced database techniques, and other methods, including the use of automated tools
• Generated ASH, ADM and AWR reports using OEM from Oracle 10g database and analyzed the reports for Oracle wait events, time-consuming SQL queries, table space and database growth.
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries.
• Importing data from flat files into database using SQL loader & External Tables.
• Upgraded and applied CPU patches and bug fixes as and when required and performed database refresh from Prod to Dev. Troubleshooting Day-to-Day Users Issues in various modules. 
• Set up and maintained oracle disaster recovery site using Data Guard.
• Implemented oracle high availability solution using oracle 10g Physical Standby.
• Code review of the development work done by all the development teams.
• Oracle Applications/Oracle E-Business Suite 11i(11.x)/10.x.
• E-Business application like Customer relation Management (Oracle order Management), Financial Management (Financial Analytics), Human Capital Management (HR Analytics, workforce Management).
• Oracle Application Modules: Oracle General Ledger (GL), Oracle Payables (AP), Oracle Receivables (AR), Project Accounting (PA), Oracle Assets (FA), Oracle Purchasing (PO), Inventory (INV), Order Management (OM), Bill of Material (BOM), Work in Process (WIP), Oracle Payroll, Oracle HRMS.
• Created and troubleshoot linked servers from SQL Server to Oracle and SQL Server databases.
• Worked on Database migration from 2000 and 2005 to 2008 R2. 

Confidential

Oracle Developer

Responsibilities:

• Working as a Forms, Reports, Crystal Reports and PL/SQL programmer and handling all the duties and work assigned to this position efficiently, these duties are as follows:
• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Studied and analyzed the business requirements, designed entity relationship diagram using Erwin.
• Designed logical and physical data models for star and snowflake schemas using Erwin.
• Review the data model and designed database tables as per technical specifications
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• In writing PL/SQL code and debugging for triggers, functions, and procedures and packages in the Oracle 8i/9i Database
• Trouble shooting for the end users requirement and optimizing the Oracle database.
• Loading data using SQL Loader both conventional and direct path loading and stored procedures.
• Coordinating and scheduling changes to database based on requirements.
• Responsible for all version control of code and technical documentation.
• Upgraded Oracle 9i to 10g software in different environments for latest features and also tested databases.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
• Worked on XML along with PL/SQL to develop and modify web forms.
• Designed Data Modeling, Design Specifications and to analyze Dependencies.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
• Created some Custom reports, crystal reports and Forms for the end users to check the details and errors.
• Providing support to team member on daily basis.