acpkuj@r.postjobfree.com

Ph:612-***-****

Proffesional Summmary

. 10+ years of IT Experience and 10+ years in Oracle 12c/11g/10g/9i/8i

DBA in Production, Development, Test and Data warehousing environment

in Oracle and teradata.

. Experienced in oracle RAC / ASM environment & Data guard, Database

cloning.

. Experience 4+ years in My SQL databases.

. Experienced in Installing 12C Grid Infrastructure.

. Experienced in Managing Oracle Software Library and Database

Lifecycle.

. Migrated / upgraded database from Oracle Version.

. Experinece in compliance management using IAM.

. Experience in Backups and Recovery skills that involve logical backups

(Import / Export/Data pump), Hot/Cold Backup using RMAN. Planning

Backup / Restoration / Recovery Strategy for 24x7 operation support

. Applying patches, Database upgrades, Maintaining cluster servers.

. Performance and tuning using AWR reports, ADDM, Oracle 10G/11g

Advisors.

. Monitoring and optimizing the performance of the database through

Tuning Applications, Tuning Memory, Tuning Disk Usage etc.

. Tuning of SQL statements using tools like Explain plan, TKPROF, Auto

trace, STATSPACK, DBMS_PROFILER, Gathering statistic, analyzing

tables and indexes.

. Experience in Table partitioning and rebuilding, validating the

Indexes.

. Performed database administration like User Management and implement

Security using Roles, Privileges, Grants etc.

. Experience in Modifying Storage for tablespaces in Capacity Planning,

Space Management,, Storage Allocation, segments, Undo Segments

depending on application requirement.

. Data loading using Faster Batch Processing, SQL Loader, external

tables, UTL_FILE package etc.

. Excellent SQL, PL/SQL programming skills like Triggers, Stored

Procedures, Functions, Packages. etc in developing applications

. Experience in Table partitioning and rebuilding the Indexes.

. Worked as a part of team in 24x7 production/development environment

and provided on-call and day-to-day support.

. Working knowledge of nosql monodb(Took a training from professional to

understand the deep concepts and got hand on their lab).

. Worked on golden gate for replication.

. Set up 12c OEM environment for database monitoring, installed plugin

for goldengate.

. Experience in UNIX shell script.

. Manage databases on Sun Solaris, Linux, Windows-NT, AIX and Windows

2000.

. Well versed with all phases of SDLC, quality process and procedures

like business requirements definition, enterprise strategy and

architecture, guidelines and standards, process/data flow, conceptual

/ logical/physical/design, performance, partitioning, optimization,

scalability / throughput, data quality, exception handling, Metadata,

Master Data design, implementation, auditing etc.

. Significant experience in Data Modeling, Dimension Modeling, Star

Schema, snowflake schema using Erwin tool, DB Artisan, ER Studio,,

Power Designer, DB desinger.

Education & Certification

. Masters in Computer Science (M.Sc.) in 2003, Kurukshetra University,

India

. ORACLE - 9I (2004), 10G (2007) (DBA-TRACK)

Technical Summary

Databases Oracle- 12c, 11g,10g, 9i, 8i,Teradata - 5, 4.x,Sql Server, MS

Access, My SQL

DBA Tools OEM (Oracle Enterprise Manager 12C,11G), Golden Gate,Toad,

SQL Server Management Studio, DB Artisan, Platinum SQL

Station & Analyzer, DB Vision, DB Designer, PL/SQL Editor,

Erwin

Monitoring Tools Nagios, MRTG

Tools Harvest, VSS, Edit Plus 7, Test Director, Excel, Word, Power

point, Visio etc

Languages D2k (Forms, Reports),PL/SQL, Visual Basic, C, C++, JAVA

Job Functions Handling Database, Analysis, Design, Coding, and Testing

,Documentation, Maintenance, Application Support,

Configuration Management, Project Management

Operating Systems XP, Win 2000/2003, Solaris 8, Sco- UNIX, Linux, AIX, HP-UX

Others Shell Scripting

WORK EXPERIENCE

Care FirstBlue CrossBlue BlueShield(BCBS)- Owings Mills MD

January 2014 to Till Date

Role: Oracle Database Administerator

Project : ODS/EDM Data Resource Management

Environment: Oracle 10g, Oracle 11g, Golden gate,Oracle 12c on Linux/AIX

CareFirst makes health care its No.1 priority. The firm is a not-for-

profit, non-stock holding company with subsidiaries providing managed

health care plans to about 3.3 million members in Maryland and

Washington, DC. The company's main subsidiaries, CareFirst of

Maryland and Group Hospitalization and Medical Services are licensees of

the Blue Cross - more... and Blue Shield Association. Together, the

subsidiaries do business as CareFirst BlueCross BlueShield and offer Blue-

branded HMO and PPO plans, as well as consumer-driven coverage, to

individuals and employers throughout their service areas. Non-Blue

subsidiaries and affiliates provide life insurance and third-party

benefits administration. In addition to traditional and consumer-driven

(high deductible, low premium) plans, the company also provides some

Medicare and Medicaid options, and it serves more than 570,000 members in

the Federal Employees Health Program. With health care costs continuing

to rise, the company has been looking for ways to reduce costs across the

board.

. Implements and maintains Oracle databases in support of the

development and installation of new systems for data warehouse, E-

commerce and corporate systems.

. Uses available tools and utilities to provide for necessary DBMS

maintenance activities:

Database reorganizations,backup and recovery, space management,

performance and tunning and change management.

. Performed mutilple upgrades from 11.2.0.2.0 to 11.2.4.4.

. Worked on Compliance management using IAM.

. Performed multiple upgrades from 10G to 12C database.

. Performs system adminstration and system management functions for

Oracle database systems.

. Assist application developers and other clients with database usgage

and software development activities.

. Maintains and installs Oracle database software, Oracle Enterprise

Planning (ERP) software, DBA Oracle tools and the coroprate repository

software.

. Represents DBA on departmental level technology projects and assumes

project management responsibilities for enterprise projects.

. Set up 12c OEM environment for database monitoring, installed plugin

for goldengate.

. Golden gate monitoring on veridata.

. Applied regularar patched based upon oracle recommendation and

security audits.

. Trains and counsels less experienced DBA staff members.

. Controls and monitors disk space allocation for mulitple databases.

. Provide Oracle DBA support and problem resolution support for

developers.

. Creates,loads and refreshed databases for testing.

. Enforces and maintains corporate data and database policies,guidelines

and standards.

. Updates and maintains corporate data and database dictionary and uses

in support of applications development, data warefould and end user

support.

. Assist application development and operations personnel in the

identification and resolution of problems related to supported DBMS

platforms.

. Creates the Database Lifecycle for differenct environments.

. Works on the Templates for the standard configurations.

. Provided the 24/7 support in Monitoring, Maintenance and Planning of

the database servers and their availability.

. Helped out with creating, recommending and defining tools, standards

and best practices all over the enterprise.

. Works on Backups and Recovery policy that involve logical backups

(Import / Export), Hot/Cold Backup using RMAN.

. Performed database administration like User Management and implement

Security using Roles, Privileges, Grants, tablespace management and

capacity planning etc.

. Used Oracle analytical functions to reporting purpose

. Applied patches, Database upgrades, Maintained cluster servers

. Provide recommendations to optimize the queries.

. Worked on Day to day DBA acitivities: Creation of new users, assign

required privileges, creation of new database instance, provide AWR

reports for performance issues etc.

Centers for Medicare & Medicaid Services- Columbia

August 2013 to Jan 2014

Role: Oracle DBA (CDBA Team)

Project : Central DBA Team

Environment: Oracle 11g,12C on Linux, SQL Server 2008 SP1 on Windows

Server 2008 R2

The Centers for Medicare & Medicaid Services (CMS) provides direction

and technical guidance for the administration of the Federal effort to

plan, develop, manage and evaluate health care financing programs and

policies. To this end, CMS needs to procure a wide range of supplies and

services to support Medicare and Medicaid programs including Research

Studies and Demonstrations, Utilization of Health Services, Provider

Fraud and Abuse, Health Quality and Standards, Computer Programming, Data

Processing, Office Supplies, Computer Hardware and Software etc.

. Created Processes and Templates for CMS databases to set Monitoring

threshholds.

. Created the Process and Work insturctions to add New targets in the

monitoring enviroments.

. Created the Database Lifecycle for differenct environments.

. Worked on the Templates for the standard configurations.

. Provided the 24/7 support in Monitoring, Maintenance and Planning of

the database servers and their availability.

. Helped out with creating, recommending and defining tools, standards

and best practices all over the enterprise.

. Designed Process flow and created templates for each and every service

used and provided.

. Installation and upgrade SQL Server software and services.

. Helped the Client in creating deploying a stable development domain.

. Worked on Backups and Recovery policy that involve logical backups

(Import / Export), Hot/Cold Backup using RMAN.

. Performed database administration like User Management and implement

Security using Roles, Privileges, Grants, tablespace management and

capacity planning etc.

. Used Oracle analytical functions to reporting purpose.

. Worked on Compliance management using IAM.

. Applied patches, Database upgrades, Maintained cluster servers

. Provide recommendations to optimize the queries.

. Worked on Day to day DBA acitivities: Creation of new users, assign

required privileges, creation of new database instance, provide AWR

reports for performance issues etc.

Shire Pharmacutical, Chesterbrook - PA

September 2012 to August 2013

Role: Database Architecture

Environment: Oracle 11g,12C on Linux, SQL Server 2008 SP1 on Windows

Server 2008 R2, My SQL on Linux

Project : Datababse-Re-Architecture

Shire is one of the world's leading specialty biopharmaceutical

companies. In practice Shire focuses on developing treatments for

conditions where the impact of its drugs can make an immediate and tangible

difference for patients. This might be a therapy to treat an extremely rare

and life-threatening disease like Hunter Syndrome or Fabry Disease; or a

medicine for a specialist condition like ADHD or ulcerative colitis; or a

treatment to help the healing of diabetic foot ulcers which if not treated

effectively, can dramatically affect the lives of the patient and their

whole family.

Responsibilities:

. Planning Database Re-Architecture.

. Discovered the Re-Achitecture requirements.

. Designed and Develped Re-Achitecture requirements.

. Installed of 12C Grid Infrastructure on Linux 5.8 with 2 Nodes of OMR

and OMS .

. Intalled SQL Server 2008 SP1 on Windows server 2008 R2.

. Installed My SQL on Linux.

. Installed Oracle 11g Grid Infrastructure on Test and Dev environments.

. Installed SQL server Pluggins to add SQL database in the 12C

monitoring environment.

. Created Backup & Recovery Processes including process diagrams for

Oracle and SQL databases.

. Create Backup & Recovery Templates for Oracle and SQL databases.

. Worked on Compliance management using IAM.

. Created Processes and Templates for to set Monitoring threshholds.

. Created the Process and Work insturctions to add New targets in the

monitoring enviroments.

. Created the Database Lifecycle for differenct environments.

. Worked on the Templates for the standard configurations.

. Provided the 24/7 support in Monitoring, Maintenance and Planning of

the database servers and their availability.

. Helped out with creating, recommending and defining tools, standards

and best practices all over the enterprise.

. Planned and Implemented High Availability and Disaster Recovery

solutions.

. Designing and Planning on implementing Virtualization to reduce IT

cost and increase productivity.

. Designed Process flow and created templates for each and every service

used and provided.

. Installation and upgrade SQL Server software and services.

. Created documentation for My SQL and SQL server databases.

. Helped the Client in creating deploying a stable development domain.

. Worked on Backups and Recovery policy that involve logical backups

(Import / Export), Hot/Cold Backup using RMAN.

. Performed database administration like User Management and implement

Security using Roles, Privileges, Grants, tablespace management and

capacity planning etc.

. Used Oracle analytical functions to reporting purpose

. Applied patches, Database upgrades, Maintained cluster servers

Fedex Corporation, Memphis - TN

Sep 2011 to August 2012

Role : DBA/Developer/Architect

Environment: Oracle 11g,10g on Linux

Project : Roads databases

ROADS is a comprehensive route planning, evaluation and execution

system for DGO.

There are algorithms written by ORSA to calculate the best routes for

couriers to drive

based on current stop and address information. The algorithms sizing

and processing was

Initially performed by capacity planning with the assistance of the

solutions center.

Responsibilities:

. Worked as production DBA in 11g RAC and ASM environment.

. Worked on My SQL databases.

. Applied patches, Database upgrades, Maintained cluster servers

. Worked on Golden Gate replication.

. Performed database administration like User Management and implement

Security using Roles, Privileges, Grants, tablespace management and

capacity planning etc..

. Worked on Backups and Recovery policy that involve logical backups

(Import / Export), Hot/Cold Backup using RMAN.

. Worked on Git for version control.

. Used Oracle analytical functions to reporting purpose

. Installation of oracle 11g on Unix, window environment

. Created databases for development, test and Refreshed the database

from Prod to test and Dev

. Performance and tuning using AWR reports, ADDM, 10G Advisors.

. Monitoring and optimizing the performance of the database through

Tuning Applications, Tuning Memory, Tuning Disk Usage etc.

. Data loading using Faster Batch Processing, UTL_FILE package etc.

. Implemented and Setup Data Guard.

. Shell scripting, Automation of the system using cron tab.

. Created and maintained stored procedure, function, trigger, and

packages etc.

. Tuning of SQL statements using tools like Explain plan, TKPROF,Auto

trace, STATSPACK, DBMS_PROFILER, Gathering statistic, analyzing

tables and indexes, using Pipeline function, parallel query, Inline

views, analytical function, Bulk Binds, Bulk Collect, Query rewrite,

hints.

. Experience in Table partitioning and rebuilding, validating the

Indexes

Fedex Corporation, Memphis - TN

May 2010 to Aug 2011

Role : DBA/Developer/Architect

Environment: Oracle 11g,10g on Linux

Project : Revenue data profiling

Fedex Revenue data comes from different databses and consolidatie in

single database. The purpose of this project is to maintain production

databsae.

Responsibilities:

. Worked as production DBA in 11g RAC and ASM environment.

. Applied patches, Database upgrades, Maintaed cluster servers.

. Worked on My SQL databases for security and capacity planning.

. Performed database administration like User Management and implement

Security using Roles, Privileges, Grants, tablespace management and

capacity planning etc..

. Worked on Backups and Recovery policy that involve logical backups

(Import / Export), Hot/Cold Backup using RMAN, Datapump and SQL

Obacktrack.

. Created the database desing as per businedss requirment for their new

testing environment in using teradata.

. Used Oracle analytical functions to reporting purpose

. Manage the multiple database environments using grid control.

. Installation of oracle 11g on Unix, window environment

. Created databases for development, test and Refreshed the database

from Prod to test and Dev

. Performance and tuning using AWR reports, ADDM, 10G Advisors.

. Worked on Git for version control.

. Monitoring and optimizing the performance of the database through

Tuning Applications, Tuning Memory, Tuning Disk Usage etc.

. Data loading using Faster Batch Processing, UTL_FILE package etc.

. Implemented and Setup Data Guard.

. Shell scripting, Automation of the system using cron tab.

. Created and maintained stored procedure, function, trigger, and

packages etc.

. Tuning of SQL statements using tools like Explain plan, TKPROF,Auto

trace, STATSPACK, DBMS_PROFILER, Gathering statistic, analyzing

tables and indexes, using Pipeline function, parallel query, Inline

views, analytical function, Bulk Binds, Bulk Collect, Query rewrite,

hints.

. Experience in Table partitioning and rebuilding, validating the

Indexes

First Data Corporation, Hagers Town - MD

Jun 2009 to May2010

Role : DBA/Developer

Environment: Oracle 11g,10g on HP-UX,Linux

Project: TMS system

First Data Corporation is a worldwide leader in electronic payment

solutions. First Data through its bank partners gives a competitive edge to

businesses and financial institutions, offering a complete portfolio of

payment systems and services to meet the globally expanding needs of our

clients

Responsibilities:

. Worked as production dataware house DBA in 10g RAC and ASM

environment.

. Implemented and Setup Data Guard.

. Performed database administration like User Management and implement

Security using Roles, Privileges, Grants, tablespace management and

capacity planning etc..

. Installation of Oracle -10g on HP-UX

. Worked on Backups and Recovery policy that involve logical backups

(Import / Export), Hot/Cold Backup using RMAN,datapump and SQL

Obacktract utility.

. Created databases for development, test and Refreshed the database

from Prod to test and Dev

. Performance and tuning using AWR reports, ADDM, 10G Advisors.

. Monitoring and optimizing the performance of the database through

Tuning Applications, Tuning Memory, Tuning Disk Usage etc.

. Worked on Git for version control.

. Tuning of SQL statements using tools like Explain plan, TKPROF,Auto

trace, STATSPACK, DBMS_PROFILER, Gathering statistic, analyzing

tables and indexes, using Pipeline function, parallel query, Inline

views, analytical function, Bulk Binds, Bulk Collect, Query rewrite,

hints.

. Experience in Table partitioning and rebuilding, validating the

Indexes.

. Applied patches, Database upgrades, Maintaed cluster servers

. Data loading using Faster Batch Processing, UTL_FILE package etc.

. Shell scripting, Automation of the system using cron tab.

. Mangage the multiple database environment using grid contrl.

. Created and maintained stored procedure, function, trigger, and

packages etc.

. Provide technical assistance to Oracle developers

. Data modeling, Database Designing, Preparation of Reports

Fedex Corporation, Memphis- TN

Nov, 2008-to Jun 2009

Role : Sr Oracle DBA/Developer

Environment: Oracle 10g on HP-UX

Project: imarket

The proposed Marketing tool will be a single global solution for FedEx

(across OpCos, regions and channels) to plan, design, execute, and fulfill

marketing campaigns. In addition, the tool will also be a central

repository for storing marketing collateral/documents and all marketing

interactions.

Responsibilities:

. Implemented and Setup of Data Guard.

. Performed database administration like User Management and implement

Security using Roles, Privileges, Grants

. Applied patches, Database upgrades, Maintained cluster servers

. Worked on ASM.

. Worked as production DBA in 10g RAC,ASM environment.

. Tablespace management and capacity planning .

. Installation of Oracle -10g on HP-UX

. Worked on Backups and Recovery policy that involve logical backups

(Import / Export), Hot/Cold Backup using RMAN,datapump and SQL

Obaktrack utility.

. Created databases for development, test and Refreshed the database

. Performance and tuning using AWR reports, ADDM, 10G Advisors.

. Monitoring and optimizing the performance of the database through

Tuning Applications, Tuning Memory, Tuning Disk Usage etc.

. Worked on the grid control system to manage the multiple database

environment.

. Experience in Table partitioning and rebuilding, validating the

Indexes.

. Data loading using SQL Loader,external tables,UTL_FILE package etc.

. Shell scripting, Automation of the system using cron tab.

. Created and maintained stored procedure, function, trigger, and

packages etc.

. Migrate the databases from old Servers to New Servers.

. Capacity planning for the new requirements.

. Help to optimize the queries, Tuning of SQL statements using tools

like Explain plan, TKPROF,Auto trace, STATSPACK, DBMS_PROFILER,

Gathering statistic, analyzing tables and indexes, using Pipeline

function, parallel query, Inline views, analytical function, Bulk

Binds, Bulk Collect, Query rewrite, hints.

. Work on the all the Helpdesk Tickets related to Oracle

Lafarge North America, Inc, Herndon - VA

Sep 2008 to Nov 2008

Role : Sr oracle DBA

Environment: Oracle 10g on HP-UX

Project: Lafarge database

Lafarge in North America is the largest diversified supplier of

construction materials in the U.S. and Canada. We produce and sell cement,

ready-mixed concrete, gypsum wallboard, aggregates, asphalt, and related

products and services. Our products are used in residential, commercial and

public works construction projects across North America.

Responsibilities

. Up gradation and Installation of Oracle -10g, RAC Applied patches.

. To provide solution for data warehousing and to design system

architecture

. Created databases for development, test, production etc.

. Performance and tuning using AWR reports, ADDM, 10G Advisors.

. Monitoring and optimizing the performance of the database through

Tuning Applications, Tuning Memory, Tuning Disk Usage etc.

. Tuning of SQL statements using tools like Explain plan, TKPROF,Auto

trace, STATSPACK, DBMS_PROFILER, Gathering statistic, analyzing

tables and indexes, using Pipeline function, parallel query, Inline

views, analytical function, Bulk Binds, Bulk Collect, Query rewrite,

hints.

. Experience in Table partitioning and rebuilding, validating the

Indexes.

. Data loading using Faster Batch Processing, UTL_FILE package etc.

. Change database character set

. Applied patches, Database upgrades, Maintaining cluster servers.

. Worked with ETL team for extraction, transformation and load BODI

IX (ETL tool)

. Created summary tables; materialize views for query rewrite purpose

etc.

. Create partitioned table, index according to the need of application

. logical backups (Import / Export), Hot/Cold Backup (RMAN)

. Shell scripting, Automation of the system

. User Management and implement Security using Roles, Privileges, Grants

. Implementation and Setup of Data Guard.

. Data modelling, Database Designing, Preparation of Reports

Portfolio Recovery Associates, Norfolk - VA

Jan, 08 - Aug 2008

Role : Sr oracle DBA

Environment: Oracle 10g on HP-UX

Project: PRA Database

Portfolio Recovery Associates, Inc. "PRA" and its subsidiaries purchase and

manage portfolios of defaulted and bankrupt consumer receivables and

provide a broad range of accounts receivable management services to

lenders, service providers, governments, and others.

Responsibilities:

. Up gradation from 9i to 10G.

. Maintain the performance of the Application and the database.

. Implemented the grid control 10G.

. Managing the Grid control.

. Monitoring the tablespaces and adding the data files as per the

requirements.

. Refreshing the database from Prod to test and Dev using Hot Backup

. Cloning through RMAN.

. Documentation for the existing tasks.

. Maintain the performance of the Application and the database.

. Database operations like Analyze tables, indexes, rebuilding of

indexes

. Taking the Backups using RMAN, Imp/Exp methods.

IBM - Airtel, India

May, 2007-Dec, 2007

Role : Sr oracle DBA/Developer/Application DBA

Environment: Oracle 10g on HP-UX

Project : Airtel Call-Home Database

Airtel Limited provides end-to-end telecom solutions to corporate customers

and national & international long distance services to carriers. Objective

of this project is to provide the Online Support for the Applications PACS

to ensure the Best performance of the database of Complete Airtel Billing

System.

Responsibilities:

. Installation of oracle 9i on sun solaris

. Monitor and manage database operations,

. Backup and recovery strategy for the database using exp/imp, RMAN,

Standby database etc.

. Shell scripting related to oracle

. Creating and maintaining stored procedure, function, trigger, packages

etc.

. Database operation to suit the applications like indexes, constraints

etc.

. User Management and implement Security using Roles, Privileges, Grants

and Enroll users on request.

. Tablespace management and capacity planning for optimal performance.

Evaluate and resize space usage on daily bases.

. Using Export/ Import RMAN for backup and recovery of the database.

Using Sql * Loader tools for data transfer and migration.

ING, Atlanta, GA & Hartford, CT

OCT 2005 to NOV 2006

Role : Sr oracle DBA, MSSQL server DBA

Environment: Oracle 10g on HP-UX

Project: Database of ING

ING Group is a global financial services company of Dutch origin with 150

years of experience, providing a wide array of banking, insurance and asset

management services in over 50 countries. Approximately 113,000 employees

work daily to satisfy a broad customer base: individuals, families, small

businesses, large corporations, institutions and governments. Based on

market capitalization, ING is one of the 20 largest financial institutions

worldwide and ranked in the top-10 in Europe. The Objective of this project

is to handle the database Production, Test, Development of US ING Remotely

and managing the database on approximately 200 different servers.

Responsibilities:

. Moving the data from Production, test and development database server.

. To check the performance issues at application level and database

level.

. Capacity Planning, Space Management

. Database Upgrades/Migration

. Creating and maintaining stored procedure, function, trigger, and

packages etc.

. Database operation to suit the applications like indexes, constraints

etc.

. To optimize the queries to enhance the performance of the database.

. User Management and implement Security using Roles, Privileges, Grants

. Tablespace management and capacity planning for optimal performance.

. Export/ Import for backup and recovery of the database.

. Using Sql * Loader tools for data transfer and migration.

. User Management and Implement Security using roles, Privileges

. Backup and Restoration of database.

. Import and export

. Shell scripting in unix

Employer: Chandigarh Infotech Center Ltd.

Client :- Modern Steels Ltd

October 2002 to October 2005

Role : Sr oracle DBA

Environment: Oracle 10g on HP-UX

Project: Modern steel database

Objective of this Project to maintain the production database of Modern

Steel. Job involved maintaining the production database of Accounts Dept,

administration dept, production of complete steel engineer plant having 60

nodes. About 3000 tones of steel production are done and of all stages of

data are recorded.

Responsibilities:

. Installation of MySQL and Oracle -10g

. logical backups (Import / Export), RMAN

. To check the performance issue at application level and database level

in Oracle.

. Created and Maintained stored procedure, function, trigger, packages,

jobs

. Database operation to suit the applications like indexes, constraints

etc

. Table space management and capacity planning for optimal performance.

Evaluate and resize space usage on daily basis.

. Shell scripting, Automation of the system

. Create summary tables, materialize views for query rewrite purpose

etc.

. Create partitioned table, index according to the need of application.

. Worked on data guard

Contact this candidate