Database Administrator

Manjusha Koti

E-mail: acx47d@r.postjobfree.com Contact: 703-***-****

OBJECTIVE

Highly accomplished, sincerely motivated, and willing database developer and administrator with a successful 9 year’s track record as an Oracle Database Developer and Administrator. Has the proven ability to tackle and succeed in all projects and endeavors efficiently and on time. Able to handle and exceed with multiple deadlines and assignments in fast-paced environments. Communicates effectively with users, clients, and fellow colleagues.

PROFESSIONAL PROFILE

Having 9+ yrs of experience as a Database Administrator, which includes Oracle databases Production, Test, Dev and Real Application Cluster Database experience.

Have the extensive experience in database support, upgradations and migrations from Oracle 9i/10g to Oracle 11g, Oracle 12c in mixed environments and cross OS platforms (Linux, Solaris, HPUX, AIX, and Windows Server).

Installed and configured Oracle 12c RAC databases on Linux and Solaris environments.

Upgraded Oracle Database from 11.2.x to 12.1.0.x.

Installed MySQL 5.6 on Linux and provide support.

Installed and Configured Oracle 11g GoldenGate.

Configured OEM 13c/12c for databases monitoring.

Performed GoldenGate migration activities from 11.2.0.2 to 11.2.0.4

Involved in configuration of goldengate and Streams.

Expertise in Migration of database from Non RAC to RAC.

Upgraded Oracle RAC from 10g to 11g

Upgraded Oracle Databases from 9.2.x/10.1.x to 11.2.x/10.2.x and Migrated From 10.1.x/11.1.x to 10.2.x/11.2.x

Expertise in Migration of database from Non RAC to RAC.

Implementing the TAF and RMAN backup in RAC, Load balancing.

Tested 10g RAC using ASM (Automatic storage management).

Expertise in configuring Disaster Recovery – Physical Standby Database, Using cold backup in different mode like Max Protection, Max Availability, Max performance.

Configured Bi-Directional, Uni-Directional Oracle GoldenGate between oracle databases.

Involved in automation of the table partitions and indexes for the data ware house databases.

Configured GoldenGate between oracle database and WebLogic server.

Troubleshooting of manger, extract, replicate processes in the GoldenGate.

Configured Active Dataguard and provided support for the RAC instances.

Performed failover and Switchover activities.

Configured Physical standby database and performed day to day activities.

Worked on database performance tuning activities like query, application, memory tuning.

Written PL/SQL code for the applications better performance.

Reviewed and deployed the PL/SQL code in the production databases.

Co-ordinated with CAB team and Customers for the forecasting of the changes in the production databases.

Written the code in oracle plsql for setup functions, trigger, packages, and cursors in the database.

Expertise in cloning of the database Using cold backup, hot backup and RMAN.

Expertise in Hot backup & cold backup And Logical backup (Exp/Imp & Expdp/Impdp).

Configured and Maintained Oracle RMAN Backups, Involved in RMAN Pointing Time Recovery and Preformed Duplicate the database using RMAN.

Creating the Private, Public and Global database link.

Creating Materialized View and Using Query Rewrite for Performance.

Migration of Non-ASM database to ASM database environment using RMAN.

Expertise in handling Internal Errors (ORA-00600) and Corruption Issues.

Expertise in migration of databases from HP-Unix, Solaris to Linux.

Applied patches to the database for security purpose.

Performed database design activities.

Experience in configuration of automated reports using perl and UNIX shell scripts.

Experience in migration of applications from lower to higher versions and troubleshooting application’s performance.

Expertise in database physical and logical modelling using CA Erwin.

EDUCATION & CERTIFICATIONS

B-tech (Computer Science Engineering) from JNTU, Hyderabad, Inda.

Technical Skills

Databases

Oracle RDBMS/ORDBMS 8i,9i,10G,11G (RAC,ASM and Data Guard, Flashback Database Features)

OS

Linux, Solaris,HP Unix, IBM AIX, Windows Server

Oracle Technologies

RAC, ASM, Data Guard, Standby database, Transportable Tablespace, External Tables, Partitioning, Materialized views and snapshots, partitioning, Oracle Flashback, Datapump, Oracle Streams, asmlib, ocfs/ocfs2,GoldenGate

Programming Languages

PL/SQL, SQL, SHELL (sh, bash, ksh)

Development/Administration/

Performance Tools and Utilities

RMAN with recovery catalog and without, SQL Plus,

STATSPACK, AWR/ADDM,TKPROF, EXPLAIN

PLAN,Oracle SQL Optimizer, hints, TRACE Analyzer,

Quest TOAD,Oracle Enterprise Manager, Remedy

Unix Tools/Commands

cron, at, vi, sed, awk, other Unix, Linux commands and utilities, SQL Developer, Notepad ++

PROFESSIONAL EXPERIENCE

Company:Sears Holdings Duration:Nov‘2015 to Till-Date

Client: Neustar,Sterling,VA Position: Database Administrator-III

Provided Oracle databases support for production, development and test environments.

Installed Oracle11g software and created databases on Linux.

Managed Logical And Physical Database Design.

Requirement study, Installation of Oracle 12c/11g, Data Modeling, Database design & creation.

Built the Standby by databases using OEM.

Worked on database performance tuning activities like query, application, memory tuning.

Configured Oracle 11g dataguard and performed day to day activities.

Configured Oracle GoldenGate and performed date to date support activities.

Experienced in monitoring databases through OEM.

Expertise in standby database configuration and performed day to day activities.

Database backups using RMAN &cold backup.

Performed day to day GoldenGate activities

Refresh production environment to QA/E2E/Test/Dev environment using RMAN backups and cold.

Refresh Schema and tables using datapump.

Experienced in Production databases restoration and recovering.

Experienced in Memory Tuning, Query Optimization, SQL Tuning & Database Tuning.

Monitoring the ASM instances on the multiple nodes.

Written and Implemented PL/SQL Scripts to check the performance of the database.

Experience in configuration of automated report using perl and UNIX shell scripts.

Experience in migration of applications from lower to higher versions and troubleshooting application’s performance.

Environment:

Operating system : AIX, Linux, HP-Unix

Databases : OracleRAC11g, GoldenGate

Scripting : UNIX shell, SQL/PLSQL

Utilities : RMAN, SQL*Loader, TKProf, Export, Import.

Tools : TOAD, OEM, Grid, Db Visualizer, Perl.

Company:Tata Consultancy Services Duration: Jan‘2015 to Oct’2015

Client: Comcast,Herndon,VA Position: Database Architect

Providing Oracle databases support for production, development and test environment.

Managed Logical And Physical Database Design.

Installed / configured Oracle 11.2.0.2 Golden Gate and implemented bi-directional replications.

Implemented GoldenGate bi-directional with oracle 11g.

Configured Datapump, Extract and Replication Processes in GoldenGate.

Performed day to day GoldenGate activities

Configured custom scripts for GoldenGate for the extract and replicate process.

Migrated the GoldenGate from 11.2.0.2 to 11.2.0.4

Worked on veridata configuration for GoldenGate to compare records between source and target.

Upgraded RAC databases from oracle 10g to 11g

Applied PSU patches for RAC databases.

Configured active dataguard and performed DR activities.

Configured OEM 12c for databases monitoring.

Refresh production environment to QA/E2E/Test/Dev environment using RMAN backups and cold/hot backups.

Refresh Schema and tables using datapump.

Experienced in Production databases restoration and recovering.

Experienced in Memory Tuning, Query Optimization, SQL Tuning & Database Tuning.

Written the code in oracle plsql for setup functions, trigger, packages, and cursors in the database.

Automated Backup & Recovery procedures using UNIX shell scripts and PL/SQL Scripts through cronjobs.

Written code in PL/SQL, Perl and Unix shell to generate the reports.

Performance tuning review and provided effective technical solutions.

Application Tuning like Procedures, SQLs using Explain plan and TKProf.

Configured grid for monitoring all the databases.

Environment:

Operating system : Sun Solaris, AIX, Linux, HP-Unix, windows

Databases : Oracle9i/10g, OracleRAC10g/11g/12C, GoldeGate, Replications,

Scripting : UNIX shell, SQL/PLSQL

E Business Suite : 11.5.9, 11.5.10.2, R12.

Utilities : RMAN, SQL*Loader, TKProf, Export, Import.

Tools: Remedy, TOAD, TSM, OEM, Grid, Exchange, SQL/PL SQL,Erwin.

Company:Mastech Inc Duration: Feb‘2013 to Dec’2014

Client: CenturyLink,Littleton,CO Position:Sr.Database Administrator

Roles and Responsibilities:

Providing Oracle databases support for production, development and test environment.

Managed Logical And Physical Database Design.

Upgraded databases from 9i, 10g to 11g.

Performed production deployment activities.

Migrated oracle databases from HP-Unix, Solaris to Linux.

Performed switch over and failover activities.

Configured Physical standby databases and performed day to day activities.

Installed / configured Oracle 11.2.0.2 Golden Gate and implemented bi-directional replications.

Performed day to day GoldenGate activities

Refresh production environment to QA/E2E/Test/Dev environment using RMAN backups and cold/hot backups.

Refresh Schema and tables using datapump.

Experienced in Production databases restoration and recovering.

Experienced in Memory Tuning, Query Optimization, SQL Tuning & Database Tuning.

Applies PSU patches for RAC databases.

Written the code in oracle plsql for setup functions, trigger, packages, and cursors in the database.

Automated Backup & Recovery procedures using UNIX shell scripts and PL/SQL Scripts through cronjobs.

Experience in configuration of automated report using perl and unix shell scripts.

Experience in migration of applications from lower to higher versions and troubleshooting application’s performance.

Environment:

Operating system : Sun Solaris, AIX, Linux, HP-Unix, windows

Databases : Oracle9i/10g, OracleRAC10g/11g/12C, GoldeGate, Replications,

Scripting : UNIX shell, SQL/PLSQL

E Business Suite : 11.5.9, 11.5.10.2, R12.

Utilities : RMAN, SQL*Loader, TKProf, Export, Import.

Tools: Remedy, TOAD, TSM, OEM, Grid, Exchange, SQL/PL SQL, Oracle 10g, Visio 2010, Erwin, Perl.

Company:Tata Consultancy Services Duration:June‘2008 to Jan’2013

Client: London Clearing House Position:Database Administrator

Successfully Installed and Implemented RAC Database on Linux and Sun Solaris.

Created various RAW Partitions for the database and symbolic links to access these Raw Partitions from the Oracle Database.

Involved in creating the database on Shared Disk Subsystem on RAW partitions and put the Database in Archive Log Mode.

Taking hot backup of files using Disk Dump (DD) command.

Configured 'SRVCTL' utility to administer the RAC database.

Configured the listeners and aliases to set up Transparent Application Failover.

Upgraded oracle RAC databases from 10g to 11g.

Configured GoldenGate and developed custom scripts for data replications

Experienced with SRVCTL, CRSCTL, OCR and Voting Disk of 10g/11g RAC.

Upgrading RAC/NON RAC databases from 9i to 10g and from 10g to 11g.

Managing the cluster ware files i.e., OCR files & voting disk.

Creation of RAC Database Using ASM.

Monitoring the ASM instances on the multiple nodes.

Configuring the RAC database in archive log mode.

Converting the single instance database to RAC database for test instance.

Maintaining RAC and non-RAC databases, adding ASM disks on prod and non-prod RAC databases.

Created undo tablespaces, redologfile groups and thread 2 for adding second instance to the RAC System.

Configured Recovery Manager (RMAN) for RAC Database backup, restore and recovery operations.

Creation of the database with the complete understanding of hardware configuration to provide maximum performance and high availability.

User Creation and Maintenance.

Performed every day Database health Check.

Taken the backup of the database regularly using Logical, Cold and Hot Backup.

Cloning databases and Disaster Recovery Database.

Written the code in oracle plsql for setup functions, trigger, packages, and cursors in the database.

Tuning heavy data loads. Monitoring and Performance tuning.

Environment:

Operating system : Sun Solaris, AIX, Linux, HP-Unix, windows

Databases : Oracle9i/10g, 10g/11gRAC, GoldeGate, Replications.

Scripting : UNIX shell, SQL/PLSQL

E Business Suite : 11.5.9, 11.5.10.2, R12.

Utilities : RMAN, SQL*Loader, TKProf, Export, Import.

Tools: Remedy, TOAD, TSM, OEM, Grid, Informatica Power Center 9.0.1, Power Exchange, SQL/PL SQL, Oracle 10g, Visio 2010, Erwin.

Client:GVR Infra Projetcs Limited. Duration:June‘2007 to May 2008’2012

Position:Associate DBA

Creation of the database with the complete understanding of hardware configuration.

User Creation and Maintenance.

Enabled the Database in Archive Log Mode

Performed every day Database health Check.

Taken the backup of the database regularly using Logical, Cold and Hot Backup procedures

Taken care of space related activities.

Assigning specific Profiles, Privileges and Roles to Database Users for Database Security.

Creating and dropping of users, granting and revoking rights as and when required.

Environment:

Operating system : Linux, HP-Unix

Databases : Oracle9i/10g, 10g..

Utilities : SQL*Loader, TKProf, Export, Import.

Tools : Remedy, TOAD, TSM, OEM, Exchange, SQL/PL SQL, Oracle10g

Contact this candidate