Manager Oracle

Centreville, VA KEREN SHAHEEN KHAN

***** ****** ******** *************

***********@*****.**

m

Phone: 703-***-****

Databases SKILLS SUMMARY

Administrat 12years of diverse engineering and development experience with

or concentration in RAC/ASM/Data Guard/ GRID and SQL. I have

US Citizen developed and displayed n-depth knowledge of Oracle 10g/11g

R1/R2 RAC implementation and administration on Linux and

Clearance : Solaris Clusters. I possess a Result Driven, Team Oriented and

proactive problem solving personality. Exceptional Soft

Public Skills, Excellent Written and Verbal Communication Talent,

Trust Exceptional Multi Tasking Abilities and Reliability.

cleared Networks: Windows NT O/S Windows NT/95/98/2000, MS-DOS,

(Active Linux, UNIX Solaris, Net App SAN,VCS, NetApp Snap Manager for

NACI) Oracle, DataGuard, Enterprise Storage Networking

Languages: SQL, Pl/SQL,HTML, ASP, VB

RDBMS/Storage: Sybase, MySQL, SQL Server,Oracle8i, Oracle9i,

10g,11g (R1 and R2),Dataguard (local standby and DR),RAC, Data

warehouse, Cognos, Datastage, Oracle Portal Infra and

Mid-tier, PeopleSoft Enterprise Portal, PeopleSoft EPM,

PeopleSoft HCM 8.9-9.1, People tools 8.49 - 8.5, ASM,OCFS2,MS

Access, SQL SERVER 2005, Teradata

GUI Tools: Oracle Reports, OEM, Crystal reports, SQL

Navigator, TOAD, SQL, 10g,11g, Grid Control, 12C cloud

control,

ACHIEVEMENTS

Built Oracle 11G RAC environment on Linux

Involved in successfully migrations, and operational support

of Oracle EBS (11i, R12)

Upgrade 11gR1 to 11gR2

Built Data warehouse Databases

Built Data guard local standby and DR

Built Oracle 11G Grid control environment on Linux

Performed Oracle Database upgrades from 9i to 10g in Linux RAC

Performed Oracle Database upgrades from 10.2.0.3 to 10.2.0.4

in Linux RAC

Migrated MS SQL to Oracle

Clone and Refresh Databases from cold and RMAN backups

Experience in installation, configuration, administration of

Oracle 8i, 9i, 10g, 11g, 10g RAC, 11g RAC database on Red Hat

Linux, and Windows environment.

Expertise working on oracle 11gR2 RAC environment.

Started working on new 12C databases and its new features by

involving in POC's.

Experience on installation and configuration of 12C OEM.

Continuous research in leveraging new features of oracle and

bringing them under day to day DBA activities

Expertise in troubleshooting Cluster issues in 11g RAC and 10g

RAC databases.

Upgrade/Migration of oracle databases from 8i to 9i and 9i to

10g and 10g to 11g.

Worked on Set up, configuration and maintained Oracle Data

Guard to control Primary and Secondary databases and also to

ensure disaster recovery using various data protection modes.

Expert in implementing High Availability solutions with Oracle

11g RAC, Oracle Data Guard

High ability to analyze and understand the AWR reports and can

fine tune the databases for maximum performance.

Extensively managed users, privileges, profiles, schemas using

Oracle Enterprise Manager (OEM).

Good knowledge in RMAN backups including full, incremental and

cumulative.

Excellent knowledge in Flashback Recovery, Hot/Cold Backup and

Cloning of databases using RMAN.

Extensively worked on Import/Export and Data Pump

Import/Export tools.

Implemented automated backup strategy and monitoring of

databases using UNIX shell script CRON UTILITY.

Expertise in overall tuning of Database using Automatic

Workload repository (AWR) and Automatic Database Diagnostics

Monitor (ADDM) tools and tuning of SQL using STATSPACK,

EXPLAIN PLAN and TKPROF.

Working experience on both OLTP and OLAP environments.

Project Experience

Strayer University (Herndon, VA)

Oracle DBA 12/2009 -

Present

Provided Oracle/PeopleSoft database administration support in

OLTP and DSS corporate environment.

Created and Managed Data warehouse(Cognos) Databases DSS

Applied patches and upgraded Release 11gR1 to 11gr2

Built Development, UAT, QA, Performance and Production

environment to support People soft application.

Built and supported Data Guard standby and remote DR

Built and supported database environment to support HECH

application.

Maintained the Heart beat tables to check the lag between the

sites.

Worked with application team to help resolving the conflict

and trouble shouting the replication issues.

Experienced in Design, implementation and generation of

documentation on Oracle 11g Data Guard on physical standby

databases in Maximum performance mode.

SQL tuning and Database performance tuning has been done based

on reports generated by SQL Trace, TKPROF, STATSPACK, Explain

Plan, AWR, ADDM and monitor the database performance on daily

basis.

Implemented backup strategies using hot/cold, exp/imp used on

the business req.

Performed Setup Recovery Manager (RMAN) and Flash Recovery in

RAC Environment.

Built and supported stand alone, RAC(2node cluster) RAC (3node

Cluster) databases

Clone and restore RAC to None RAC and RAC to RAC databases.

Refreshed RAC to RAC and none RAC to RAC databases

Configured and setup the RMAN

Configured Grid control 10g,11g for monitoring multiple

environments

Implement patches, updates, and fixes as necessary following

established Change Management processes

Work with team members to provide 7x24 production support

Utilize a working knowledge of Oracle database and consuming

third-party applications to troubleshoot technical issues,

i.e. error messages, software bugs, availability, etc.

Worked very closely with developer for performance and tuning

for database and application.

Worked with ADDM, AWR and SQL tuning advisor to tune any long

running queries and overall database sessions.

Performed cold backups and restore

Participated auditing session to comply with SOX requirements

Participate effectively in execution of projects to support

development, integration, production and infrastructure

deliverables.

Ensure system stability, availability and performance

Upgraded 11 Rel1 to Rel2 RAC and Standalone Databases

Implemented local and Remote Data guard.

Troubleshooting Database environments

challenges/exceptions/alerts

SAVVIS (FEMA) Sterling, VA

Oracle DBA 10/08 -

04/2010

Responsible for performance and tuning, Performance Monitoring

Stats Snapshots.

Installed and configured 10g Grid Control to maintain and

monitor databases

Configured, implemented 10g RAC with ASM disk on Linux

servers.

Installed Oracle 10G RAC on Linux platform using ASM for a

storage manager Provided performance tuning on a 10G RAC

database on a Linux platform

Implementation and support of 10g RAC instances

Administration of development, test and production databases

Provide on-call support for critical database issues on a

rotational basis

Perform database upgrades and migrations to updated version

Experienced in patching, upgrading, and monitoring multiple

database environments

Monitoring Development, Test, Staging and Production

Environments

Responsible for system and capacity planning

Responsible for software installation and database creation

IP reconfiguration for entire Data center move in Development,

Test, Stage and Production environments.

UNISYS (GSA) Chantilly, VA

Oracle

DBA

09/05 - 09/08

Monitoring multiple production and development databases.

Monitor RMAN backups.

Support of over 150 development, test and production Oracle

databases and SQL Server.

Responsible for performance and tuning, Performance Monitoring

Stats Snapshots.

Working on Database Hardening Edit and Monitor the daily jobs

Process data dump requests for clients Process database

changes for clients.

Working with DBA team to re-structure the windows environment

to accommodate ESC Database Standards.

Work closely with software developers to meet user requests

and assist with prioritization

Responsible for capacity planning weekly and performance

overview reports for all Production databases.

Responsible for database documentation.

Responsibilities included configuration and installation for

Test and Production.

Responsible for patch management and upgrades.

Responsible for 10G upgrade from 8i and 9i oracle versions.

Applied all DST patches for Application infra and mid-tier

production environments.

Responsibilities included running the daily batch loads from

the ESC Data center, monitoring the automated daily backup

routines, writing documentation for new components being added

to the system, performance tuning and monitoring of database

using Oracle Enterprise Manager, 10g Grid Control and

performance evaluation utilities.

Digital Inc Technologies (Xceed Tech) Vienna, VA

Oracle DBA

02/03 - 09/05

Database (10g) in Oracle Real Application Clusters (RAC)

environment.

Involved in configuration of (10g) RAC on EMC Storage Area

Networks (SAN) Migration from SQLServer to Oracle.

Working with development team for conversion of objects from

SQLServer to Oracle.

Monitoring the database activities jobs, backups, Logs, table

space, user activities. Monitoring the tables on sqlserver for

daily data update.

Updating development database daily with fresh data from

production

Setup backup and recovery procedures.

Monitored server disk spaces, databases performance,

replication, and backups and scheduled tasks. Daily management

of Oracle database, support and development of applications

using PL/SQL

Oracle DBA support including backups, recoveries,

installations, database performance analyzing existing

databases and their interfaces looking for opportunities to

improve efficiency.

Configured and managed users, security and redo logs.

Digital Inc Technologies ( ALFCIO)

Washington DC

Oracle DBA 06/99- 01/03

Introduction and firm foundation in clustering technologies

(RAC) Designed, implemented, and maintained a new Request

tracking system. Installation.

Solution in the COPE environment. Interfaced with users and

technical staff to troubleshoot and implement rules. Provided

appropriate reports and views into the data for process.

Generated information sensitive reports with visual pro as

front-end tool with SQL Server. Wrote queries against the

database for analysis with the help of shell scripts.

Programmed, searched and sorted using UNIX tools.

Collected data from remote system using FTP. Involved in

Oracle Forms conversion. Responsible for the back up of

databases on regular basis and performing recovery operations

when necessary.

Education

Currently working on Bachelor in info system (Strayer

University)

[pic][pic][pic][pic]

Contact this candidate