PROFESSIONAL SUMMARY:

• Performed large batch jobs, and tuning of SQL queries and database systems.
• Involved and Configured Oracle 11g database instance running across two oracle RAC nodes on Red Hat Linux AS 4 Server.
• Tuned the database at various levels such as Application Tuning, Memory Tuning, SQL Tuning and Database Contention, I/O Tuning, Capacity planning by using TK prof, Explain Plan, SQL Trace, UTLSTAT, Stats Pack, AWR and ADDM.
• Proficiency using Flash-Back Recovery, Automatic Storage Manager ASM Automatic Database Diagnostic Manager ADDM .
• Planned and Implemented DR High Availability oracle solutions using Data Guard, Streams.
• Create new Oracle databases using DBCA or database scripts. Creating new ASM disk group or raw devices for RAC DBs.
• Strong experience in Oracle DBA tasks like Installation, creation, maintenance, performance tuning, problem identification, resolution and migration in production and development environments.
• Over 7 years of Information Technology experience which includes Oracle Database Administration on 24x7 critical production and large databases of over 6-10 TB using Oracle 11g, 10g, 9i, 8i.
• Experienced in maintaining large Production, UAT, IST and DEV environments.
• 24/7 support for Production databases and responsible for round-the-clock database operations. Offered solutions for Production/Development of database applications and ensured customer satisfaction as the prior important.
• Expertise in installing, configuring and maintaining Standalone and RAC databases on various platforms.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control OEM .
• Performed manual recovery using archived logs, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backups.
• Experience in Cloning the process of copying an existing Oracle installation to a different location and updating the copied bits to work in the new environment.
• Hands-on Experience in installing and configuring Oracle WebLogic 11g application server.
• Installed Oracle 10g RAC software with ASM File systems.
• Installation, maintenance and tuning of RAC Applications. Used rapid install and other Oracle Application maintenance utilities like OEM.
• Monitoring data transfer between the Database servers using Data Stage, Oracle Streams/CDC
• Automated database periodic maintenance and activities using Perl Shell Scripts, Autosys.
• Experience writing Stored Procedure, Functions, Trigger and packages using PL/SQL.
• Enforced Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.
• Worked extensively on Oracle Version Upgradation, Migrations and Patching.
• Configured and implemented different types of Advanced Replication Models of distributed databases.
• Used Repository manager to build Repository and managed Very Large Scale Databases VLSD .
• Configured Oracle on different Operating Systems for OLTP Data Warehousing environments.
• Experienced in loading data from flat files into database tables using SQL Loader and ETL Tools like Informatica, Dataflux, Data Stage.
• Assisted in designing conceptual, Logical and physical data models using Pl/Sql Programming, and Shell Scripts.

TECHINCAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle DBA

Responsibilities:

• Installation, Configuration and Administration of Oracle 9i/10g/11g databases on different platforms as well as the clients.
• Worked in Agile development to support multiple environments across the application.
• Upgrading oracle databases from 10.2.0.3.0 to 10.2.0.4.0, 11.2.0.2.
• Oracle server in installation and configuration on virtual environments.
• Cloned/Refreshed staging environment with production data using RMAN.
• Installing, Configuring and Administering Automatic Storage Management ASM .
• Implementation and support of Oracle 10g and 11g migrations and Upgrades from Oracle 9i and 10g databases, including Oracle RAC Real Application Cluster .
• Performs Golden Gate replication monitoring, tuning, and capacity planning.
• Installing, Configuring and Administering Real Application Clusters on 2 and 4 node cluster.
• Installing CPU/PSU and other security, bug patches for Oracle databases on Solaris, Linux Platforms.
• Cloned/Refreshed databases for testing/QA environments using export/import, data pump and cold backup.
• Install and configure Oracle RAC and configure ASM disk storage.
• Install and configure Oracle Golden Gate Veridata 3.0.
• Implemented Hot and cold backups, Restore and recovery manually.
• Implemented RMAN backups and Restore and Recovery.
• Installed, configured and maintained Physical Standby Databases for the Production databases using Data Guard.
• Created and monitored all SQL tasks SSIS Packages and scheduled daily jobs using Agent Scheduler through SQL Server2012 Management Studio. Includes, implementation of necessary batch processes for periodic updates.
• Configured Oracle Golden Gate and parameter files in an active-active architecture.
• Experience in Implementing and performing Disaster Recovery using Data Guard.
• Implemented replication between databases using advanced replication.
• Participating in Auditing of databases like PCI Auditing.
• Ensure high availability of all Production and Development databases with little or no downtime by implementing Oracle's Data guard and RAC.
• Developed DTS Packages to transfer the data between SQL server2012 database and files.
• Helped in migrating terabytes of data between different versions of analytics databases.
• Configuring and maintaining OEM.
• Active participation in code deploy for engineering releases.
• Written PL/SQL, Stored Procedures and also UNIX Shell scripts for monitoring database activities,
• Experienced at SQL Loader, exude, impdp, exp, imp and other Oracle utilities.
• Experienced at administering database security by installing Ingrain, create users, grant/revoke roles, privileges to the users, creating and assigning profiles to the users
• Perform capacity planning required to create and maintain database environments.
• Management of schemas, Table spaces, objects partitioning the tables indexes.
• Worked closely with application team members to perform SQL Tuning using Explain Plan, SQL Trace, Optimizer Hints, TKProf utility.
• Implement Physical Standby and logical standby databases using Oracle's Data guard.
• Configure GRID control and scheduling RMAN backups.
• Re-organization of database objects Tables, and Indexes etc.
• Generated SQL and PL/SQL scripts to create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Aided developers in writing efficient code and making efficient use of resource leading to better performance and optimization.
• Used Diagnostic tuning packs along with AWR ADDM reports
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Helped build extensive documentation for all Oracle related Administration

Environment: Oracle8i/9i/10g/11g, Sun Solaris 5.8 sparc/5.10 x86, Linux, Golden gate, Data Guard,SQL Plus, Sql Server 2012, ASM, RMAN,RAC, Oracle Enterprise Manager OEM , Shell scripting.

Confidential

Oracle DBA

Responsibilities:

• Worked extensively on monitoring 10G grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.
• Responsible for capacity planning, database security, recovery planning and installing patches
• Cloned schemas, objects and data on new server using exports from 10g database and imported in 11g using data pump.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
• Implemented and managed optimum physical database design tablespaces, datafiles, extents, redo logs, archive logs and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.
• Experience in Backup Recovery using RMAN which includes hot backups and Cold backups.
• Monitoring Day-Day Backups, Log's recovering them as per the requirement. Utilized LOG MINER Technology applied Application Database Transactions on other Databases.
• Monitored data transfer between the Database servers using Data Stage, Oracle Streams/CDC
• Worked on different types of storage structures SAN/NAS .
• Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.
• Extensive experience in RMAN recovery testing and standalone database.
• Experience in installation OWB and OWF .
• Hands on experience on installing and upgrading Apex 3.2 to Apex 4.1.
• Performed Database Refresh from Production to IST, UAT and Development databases.
• Responsible for the installation, configuration and overall up from 10g/11gr1 to 11gr2 10.2.0.2 to 11.2.0.2 .
• Performed day to day activities such as managing user privileges, tablespaces, file system, undo segments, temp segments and indexing.
• Refresh schema using export/import, Creating the database, table spaces, tables, indexes, setting privileges and user logins.
• Migrated from a 12 box system to 36 box system with pairs of 2 DEV, IST, UAT, Production, Disaster Recovery .Migrated single instance database to multiple instance database using export/import, datapump.
• Installation and configuration of Oracle 11gR2 on Red hat Linux AS 5.
• Involved in configuring two node RAC on 11gR1, oracle clusterware on Red hat Linux AS 5.
• Databases migrated to RAC for improved resiliency and performance.
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication
• Creating Materialized views and Materialized View Logs for Increased Performance and Data Replication.
• Created indexes to facilitate easy user interface implementation and tuning.
• Involved in construction of DR sites for all the Production and IST environments.
• Installing and configuring Oracle WebLogic 11g application server.
• Utilized Oracle Enterprise Manager OEM , Grid control to manage users, privileges, profiles, and schemas.
• Oracle 11g/10g/11gr2 Oracle 10g/RAC, UNIX, Solaris 10, Apex 4.1, ODI, OWB, OWF TOAD, OEM, SQL, MYSQL PL/SQL, TKPROF, EXPLAIN PLAN, Data Guard.

Confidential

Oracle developer

Description:

SAP Business Objects XI has set of reports and scripts that run on daily/weekly/monthly basis. In the back-end, we have a database where the script's data is stored into the tables and there is the work for PL-SQL developer/dba here.

Responsibilities

• Worked in the Database design team to articulate the reporting needs using the DB tools and objects.
• As a DBA, analyzing the data and reporting requirements to recommend and design solutions through the creation of appropriate database structures, reports and query structures.
• Worked on WEBI server's memory consumption issues during WEBI services starting phase for solving space related constraints.
• Worked on proactive approach to develop the test scripts. Troubleshooting of the reports for the performance and better design by adding functions, parameters with subset of data.
• Worked as an administrator in Business Objects with PL/SQL related script analysis.
• Worked on Administration tasks of BO such as security setup, creation of BO objects folders, groups, scheduling of reports etc.
• Worked in the upgrade plan with study of BO 3.1 set up and the project plan for migration project for BO XIR2 to BO XIR3.
• Worked on BI reporting design based on SAP BI queries, multi providers, BEX queries, functions, filters, dimensions, OLTP and OLAP cubes.

Environment: Business Objects 3.1, SAP BI, Oracle 10g, UNIX, Solaris.

Confidential

Oracle developer

Description:

This project aims at improving the capture of data at product and facility level and ensuring that they are linked to the most recently approved CARM application, in addition to having a complete view and control of retail data within the SIF through inclusion of HFC data. Business wants to sends the MIF Monthly Input File to UKDWH every month. The Hungary business is being sold and as part of the sale contract customer data has to be provided by the buyer. We have copied all the Customer related data onto the IFS folders on the respective production servers which has been copied onto a cleaned up local server at Hungary. As a step ahead of this process we will be putting Hungarian Jobs on Hold and implementing the utility.

Responsibilities

• Creation of the document for various region specific requirements.
• Performed Role of offshore coordinator and developer, involved in many business level meeting to understand the requirements.
• Involved in coding and unit testing for variant tasks.
• Changes in the existing code and in various UNIX Scripts
• Working as a DBA and checking solving relative issues.
• Developed new Robot Server Jobs and UNIX Scripts.
• Understanding Specification for the development.
• Interacting with Management and Business to gather source and there requirements.
• Handling the Source file on UNIX Server
• Fixing the defects.