Oracle Developer

Asha

E-Mail: **********@*****.***

Tel: 469-***-****

Over 8 + years of professional experience in design, development, implementation, maintenance, documentation and administration in various domains like pharmaceutical, Finance, and Insurance industries.

Hands on experience on Oracle (8i/9i/10g RAC/11g RAC) database administration, schema implementation, backup, recovery, cloning, performance monitoring and tuning on different platforms like Windows, Unix /Linux (IBM AIX, Sun Solaris, HP-UX).

Experienced in maintaining databases on large Production environments.

Expertise in installing, configuring and maintaining Standalone as well as RAC databases on various platforms and responsible for 24x7 availability of the database.

Experience in Installation and administrations of Oracle 10g RAC, 11g RAC.

Expertise in upgrading Oracle 10gR2 RAC to Oracle 11gR2 RAC. Migrating Oracle Non-RAC databases to Oracle RAC database and migrate Oracle database from file system to ASM.

Implemented Data guard and configured both the physical and logical standby database in the production environments.

Also responsible for well functioning of the database by Checking and applying Patch set and Interim patches, Upgradations thereby making the database software up-to-date. Upgraded databases from 8i to 9i, 9i to 10g and 10g to 11g.

Worked extensively on Oracle Migrations. Migrated database from Windows to Linux, HP-UX to AIX.

Proficient in using Recovery manager (RMAN), Flash-Back Technology, Automatic Storage Manager (ASM) & Automatic Database Diagnostic Manager (ADDM).

Monitoring and optimizing the performance of the database through Database Tuning - Tuning Applications, Tuning Instance, and Tuning Disk Usage.

Developed database monitoring/health check alert scripts

Experience in using OEM/Grid Control

Setup, configure and maintain data replication using stream/golden gate.

Planning and scheduling the Physical (Cold/Hot) backups, Logical backups and RMAN incremental backups.

Experience in taking Full and partial backups, Incremental and Cumulative backups using RMAN (Recovery Manager).

Experience in taking backup and performing recovery.

Experience in performing point in time recovery at times of necessity.

Created Clone databases in Dev and Test environments using RMAN cloning procedure as well as User manual cloning.

Implemented data transfer using Data Pump, Export/Import utilities.

Experience in Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, and analysing security problems.

Extensive Experience in writing Stored Procedures, Functions, Triggers and packages using PL/SQL.

Configured Oracle on different Operating Systems for OLTP & Data Warehousing environments.

Experienced in loading data from flat files into database tables using SQL*Loader, ETL Tools and External Tables.

Managing database backup using RMAN/TSM and perform recovery, perform Disaster Recovery exercise on a regular basis, Refresh/Clone Non-Prod from Prod.

Excellent communication skills, with strong troubleshooting, and problem solving ability.

Worked as a team member to provide 24x7 on call production database support.

EDUCATION

Bachelor of Technology in electronics and communication engineering from JNTU.

TECHNICAL SUMMARY

Databases : ORACLE 11g Release 2, Oracle 10g RAC,9i RAC, 9i/8.x/7.x. SQL Server 2000

DBA Tools : SQL developer, DBA Studio, Oracle OEM, TOAD, Spotlight, Quest Central,

DB Artisan, SQL server Enterprise manager, Query Analyzer.

Operating Systems : Sun Solaris, HP-UX, IBM-AIX Linux (Redhat, SUSe, Oracle Enterprise Linux) &

Windows 2000 professional.

Cluster Wares : Veritas, Oracle Cluster Ware

Case Tools : Platinum ERWIN, Sybase Power Designer.

Languages : Developer/2000, Developer 6i.

ETL TOOL : Oracle warehouse builder.

Hardware : Sun Sparc, IBM PC, HP Superdome, IBM Blades.

Volume Manager : Veritas Volume manager.

Storage : EMC SAN with SRDF, IBM San with PPRC.

ORACLE Tools : OS watcher, L-TOM

EXPERIENCE

AT&T, Atlanta, GA Jan 2014 - Till Date

Role: Sr. Oracle DBA

Responsibilities:

Ensure availability of databases and all related services such as RAC, ASM, Oracle streams and Data Guard.

Setup new database infrastructure. Install Grid Infrastructure / Clusterware (RAC), database server software and related products. Setup, configure standby databases, replication using Oracle Streams/Golden Gate, ASM for data storage and RMAN for backup and recovery. Apply Oracle patchset/PSU.

Successfully upgraded and migrated databases for critical OLTP application from Oracle 10g RAC infrastructure to Oracle 11g Grid infrastructure. Built Oracle 11g Grid infrastructure for all the region from Dev to Prod. Worked in collaboration with AIX, Storage team in setting up Oracle 11g Grid infrastructure, Development team in performing application testing and Load Runner team in performing Capacity testing.

Upgraded Oracle 10g and lower Non-RAC databases to Oracle 11g including data warehouse databases.

Migrated Oracle Non-RAC databases to Oracle RAC databases.

Migrated Oracle database from filesystem to ASM.

Define database backup/restore procedures using RMAN and TSM, Manage database backups and perform recovery.

Participate in DR exercise twice a year to validate recovery procedures.

Prepare documentation and baselines. Analyze gap assessment and create road maps to overcome those gaps using Oracle best practices.

Perform database tuning and performance monitoring at the OS level, DB level and SQL level. Analyze data and make recommendations relating to performance and efficiency of data storage. Perform capacity testing before implementing new major application release to production environment. Provide advice and solution to Application Development Team to have effective use of indexes, how to reduce waits or other advices from OEM Grid control.

Work with the system administrator and storage administrator to perform software installations, and to configure hardware and software so that it functions optimally with the Oracle infrastructure.

Deploy new application releases/code to production environment as per Change Request. Provide support and assistance to development team in QA and UAT phases.

Refresh Non-Prod regions such as QA/UAT from production or staging databases.

Monitor and maintain DATABASE SECURITY. Co-ordinate with Security administrator in adding, maintaining and removing users account, administering quotas, auditing, and checking for security issues.

Interface with Oracle Corporation for technical support, solution to problems by utilizing Oracle support.

Provide after hours and weekend on-call support on a rotation basis.

Environment: Oracle 9i, 10g, 11g, SQL, PL/SQL, Oracle Grid Control, Oracle Enterprise Manager Database Control, Oracle Spatial, TOAD, SQL Developer, SQL*Loader, NT, Red Hat Enterprise Linux, ASM, JAVA, HTML

Lafarge, Herndon, VA Feb 2012 - Dec 2013

Role: Sr. Oracle DBA

Responsibilities:

Installation, configuration, upgrade of Oracle RDBMS software 9i, 10g (stand alone, RAC) on HP, Sun, AIX platforms and maintain patch level (One off patches, Patchests).

Implemented Oracle 10g RAC, Standby and Data Guard in some production databases

Installed and Upgraded 10.2.0.2 RAC (Red Hat Linux) to 11g (11.1) RAC.

Converted Oracle 10g Non-RAC database to 10g RAC database.

Creating standby databases as part of the DR strategy and ensuring the Primary and standby DB are in sync with each other.

Upgrade of DB running on Oracle 9i to Oralce 10g.

Managing and supporting technical changes being implemented into the environment.

Actively participating in Design (logical and physical), testing and implementation phases of Software Development life cycle for new projects.

Utilized RMAN for backup and recovery strategy.

Performed user and security administration activities, such as enrolling users, granting privileges to users, and maintaining system security.

Completed export and import of different databases using Oracle Export / Import utilities.

Table fragmentation tuning, partitioning the large table by date.

Increase database reliability and availability through process improvement.

Responsible for successful execution of the ticket, documenting status, providing feedback to the owner and closure of the tickets.

Actively participating in DR exercise to ensure the restoration of business continuity in a real disaster scenario.

Actively participating with application owners/ application developers to fine tune the application code and optimal utilization of DB and system resources. Stats pack and AWR reports are thoroughly analyzed to obtain the performance problems.

Using various Oracle tools like (OS watcher, L-TOM) to capture the run time events and operating system/IO statistics and events.

Ensuring the successful backups are happening and storing on tape using Net backup.

Participating in BCV and RMAN backups.

Providing after hours On-call Support for database related problems as part of an on-call rotation.

Documented Oracle physical and logical data models. Developed master data management models. Reviewed and optimized current Oracle table structures.

Implemented Oracle Data Guard, Standby, Oracle Enterprise Manager 9i/10g/11g Grid Control. Configured OEM / Grid Control to generate alerts for critical thresholds.

Maintaining Rogers standards for database implementations and service.

Installing/Administering SQL server 2005 Instances and DBs on Windows servers.

Production Support/On-call rotation for existing Oracle and SQL server Databases.

Environment: Oracle 10g, 11g R2 RAC, GridControl 10gR5, ASM, RHEL 4, 5, Shell Scripting.

AmeriHealth Mercy, Philadelphia, PA Oct 2011 - Jan 2012

Role: Sr. Oracle DBA

Responsibilities:

Working on production System (24 * 7) in Data warehouse division of DPS and handling production databases (for Avis and Budget) of over 5 terabytes and development database of over 300GB, my key responsibilities as Senior ORACLE DBA are listed as below:

•Installation of Oracle software (10g, 9i/8.x) on SUN SOLARIS & Windows 2000 professional.

•Creation and configuration of oracle based databases on Sun Solaris and Windows platforms.

•Conduct research and provide advice to other informatics professionals regarding the selection, application and implementation of relational database management systems.

•Design/support in defining and modifying logical and physical database model for DATA WAREHOUSE AND DATA MARTS.

•Managing users by assigning them privileges through roles, and quotas.

•Enforcing security using encryption/decryption and fine grained access control.

Entirely responsible for maintaining the Production, Test and Development databases of the company, which mainly includes the following:

•Managing schema objects, files of a database, creation of table spaces and data files, rollback segments.

•Setting storage parameters for dictionary managed table spaces.

•Monitoring the growth and sizing the table spaces for the smooth running of daily batch on production server.

•Creating TABLE SPACES based on raw data files using VERITAS Volume manager.

•Estimating storage parameters for tables, indexes and materialized views

•Analyzing the tables, indexes and schemas on the production server to gather up-to-date statistics in the oracle dictionary.

•Monitoring the usage of indexes and hence dropping the unnecessary indexes consuming space.

•Creation and setting storage parameters of rollback segments (in manual UNDO MANAGEMENT mode).

•Altering rollback segments and assigning large batch transactions explicitly to bigger rollback segments.

•Replicating the data between production databases (Avis and Budget) residing on same server using snapshot master replication method and Oracle streams.

•Analyze SQL queries and make recommendations to Data Warehouse engineers and extraction programmers for possible alternates to accomplish the tasks.

Execute backup procedures: COLD BACKUP, HOT BACKUP with database in ARCHIVE LOG MODE using RMAN & also Full and Incremental Database Exports.

Execute restoration procedures of complete & incomplete media recovery using RMAN. Restoring full backup & Time based Recovery.

Design and implement Networking between Oracle Servers on different operating Systems.

Extensive hands on working experience of Oracle Utilities: Export/Import, SQL*Loader, RMAN.

Hands on working experience of TOAD, Spotlight, OEM and DBA studio.

Experienced in Partitioning large tables across physical disks to increase throughput and better management and maintenance.

Provide 24x7 system support as a system DBA for Production and development systems on a rotational basis.

Environment: RHEL, Sun Solaris, Oracle 10g, 9i, ASM, RMAN, SQL, PL/SQL, UNIX scripting.

Travelers, Hartford, CT Nov 2010 - Sep 2011

Role: Oracle DBA

Responsibilities:

Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.

Installed and setup 10g Oracle Enterprise Manager Grid Control (10.2.0.3) and Mass Agent Deployment on several hosts.

Installed Oracle Dataguard for Oracle Disaster recovery, High Availability and data protection.

Manage multiple MySQL databases used for storing records, payment, and customer relations data.

Data Modeling, Database Design and Creation using ER-Win.

Experience in setting up Oracle ASM storage for Oracle RAC databases.

Involved in designing data warehousing boundaries and parameters, Data Transformation, PL/SQL.

Created PL/SQL, SQL*Loader and UNIX scripts as a part of data load process to load external data into Oracle database tables.

Working Experience with Latest TOAD 9.6 having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Audit Objects, Diagnose Extents, Log Miner, Segment Advisor, Database Monitor, Server Stat's, Session Browser, SGA Trace, Top Session Filter, HTML Schema Doc Generator, Query Builder.

Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects,database backup and recovery, monitoring and optimizing database performance.

Diagnose and tune performance problems and locking conflicts using Oracle database monitoring and diagnostic tools (SQL TRACE, EXPLAIN PLAN, TKPROF, UTLBSTAT/UTLESTAT) and dynamic performance tables/views.

Performed administrative maintenance, monitoring both Oracle and MS SQL Server database systems in a global 24x7 operational environment.

Implemented Oracle database backup & recovery solutions using RMAN and Exports/Imports.

Performed large batch jobs, and tuning of SQL queries and database systems.

Created user accounts, roles and granting access permissions to the database.

Extensive Responsible in configuring and backing up database using RMAN for hot backups, cold backups and logical backups

Installed and Configured Oracle 10g databases on Linux.

Performed automated backups and scheduling using PERL SCRIPTING.

Involved in designing logical & and physical data models using power designer.

Implemented Oracle Database 10g two node REAL APPLICATION CLUSTER (RAC) on a Linux system.

Installed and configured Oracle Enterprise Manager 10g Grid Control.

Environment: Oracle 10gR1, 10gR2, 11gR1, 11gR2, 12c with RAC, Data Guard, ASM, Golden Gate, SQL, PL/SQL, Erwin, SVN, GIT, Maven, HTTP, F-Secure SSH, F-Secure FTP, TOAD and Oracle Enterprise Manager.

Crompton Greaves Ltd., Chennai. India Oct 2009 - Oct 2010

Role: Oracle DBA

Responsibilities:

24x7 Oracle Production Database Administration including Oracle 10g/11gRAC.

Installed, configured and maintained Oracle Databases.

Installed and configured OEM Grid Control to monitor all databases.

Establishing standards, policies and procedures for Golden Gate replication administration.

Responsible for installing and configuring GoldenGate on Oracle Servers

Managing, troubleshooting and resolving oracle database, RAC and applications issues.

Implementation of High Availability solutions with Oracle 10g RAC, Physical and Logical Standby databases (Data Guard) and Replication using GoldenGate.

Developed back-end logic for business applications, e.g. Views, procedures, functions, packages, triggers.

Developed scripts and reports using SQL, PL/SQL and Perl.

Configured replication for a set of tables using GoldenGate V10.4.

Designed and implemented Oracle Real Application Clusters (RAC) on Solaris with EMC Storage for an OLTP application with Transaction Application Failover and high transaction volume.

Standby Database (Data Guard) setup and configuring DB links.

Migrated 4 node RAC environments for a 20TB database and Implemented Data guard on this RAC environment.

Responsible for finding the root cause of performance problems with ASH, AWR and ADDM reports

Migrated databases using cross platform transportable table space feature and RMAN convert functionality to perform database conversion.

Worked on agent related issues in OEM.

Defining and Setting backup and recovery procedures.

Performed and tuned using AWR, OEM Grid and Oracle Databases.

Tuning the database using stats pack and custom scripts.

Tuning and balancing I/O by monitoring file system and table space I/O statistics.

Experienced in Tuning SQL statements using Explain Plan, SQL Trace, TKPROF and STATSPACK.

Writing Shell Scripts for managing day-to-day activities and automation of backup.

Usage of Partitions to improve the query performance and manageability.

Installation of Oracle RDBMS server software and version upgrades.

Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)

SQL and PL/SQL Programming.

Installation and configuration of Oracle Client software and Tools.

Analyzed the user requirements and Designed views using STAR schema for improving performance of Data marts.

Performed partition maintenance and automated the process of creating new partitions as and when required.

Environment: Oracle 10g, 11g R2 RAC, GridControl 10gR5, ASM, RHEL 4, 5, Shell Scripting.

Union Insurance Corp, India. Apr 2007 - Sep 2009

Role: Oracle DBA

Responsibilities:

Installation of Oracle on UNIX/LINUX and Windows.

Created tables, indexes, table spaces, users, integrity constraints and supported all phases of a development cycle.

Performed Cold Backup, Hot Backup and Logical backups using EXPORT. Testing of Backup's and Documenting backup strategies. Created scripts for automating online daily backup for eight databases and for automating data loading from flat files.

Installed, upgraded and patched Oracle software. Setup brand new machines including Oracle software installation.

Created users and privilege Management using roles and grants.

Moved database Schema changes to stage or production.

Responsible for Oracle 9i logical and physical databases design, implementation and maintenance on UNIX.

Supported the agent PATCHING for 12c server transformations.

Maintained the data integrity and security using integrity constraints and database triggers.

Created database objects like tables, views, indexes, partitions.

Server side tuning included Rebuilding indexes, Analyzing Schemas etc.

Using SQL LOADER for populating static tables and fact tables from CSV Files.

Worked on providing the backend support for the developers, stored procedures and functions, reporting, SQL query tuning and optimization, performance monitoring, resource usage and profiles.

Taking backup of database and doing defragmentation with help of Exp/Imp utility of oracle.

Working with packages like DBMS_JOB and DBMS_SCHEDULAR to do various jobs like export/import done on specific time interval.

Environment: Oracle 10g, 11gR1, 11gR2, Linux 5.5, RHEL, Sun Solaris, IBM AIX, DBUA, OEM-12C, RMAN, RAC, ASM, Golden Gate, Grid, Data guard, Net-Backup, Team quest tool.

Contact this candidate