lakshmi

Lakshmi Rajulapati

***********@*****.*** 603-***-****

SUMMARY:

8+ years of experience in Oracle Database Administration encompassing Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Data Modelling, Performance Monitoring and Tuning, RAC, Data Guard, Grid Control, Oracle Streams,Enterprise Manager and Golden gate on Sun Solaris, Red Hat Linux, HP-UX, AIX, and Windows Platforms

Expertise experience in Installation, upgrade/migration, Management, Administration, Backup and Recovery, Maintaining and Tuning of Oracle RDBMS.

Used Clustered Databases to achieve High Availability and Scalability at low cost.

Expertise Experience in Oracle DBA & PL\SQL expertise, Data modeling & partitioning skills, UML knowledge a plus, Process Analysis.

Exposure to Real Application Cluster (RAC) environment with Auto Storage Management (ASM) for Oracle 11g and 10g RDBMS ranging from few GB to 10 TB on UNIX, AIX, SUNSOLARIS and LINUX Environments.

Successfully implemented and managed Physical Standby Database using Oracle DATAGUARD feature for High availability configuration with Data guard Broker.

Experience in installing Oracle patches, Migration of database across different platforms and Cloning/Data Refresh from production environment to setup test and development environments.

Extensive experience designing and implementing backup and recovery strategy for databases using Recovery Manager (RMAN), traditional Export/ Import, Export/Import Data pump as well as conventional Hot/Cold Backups.

Experience in Oracle Enterprise Manager (OEM) Grid Control and RMAN.

Experience with Golden Gate implementation for DB2.

Extreme knowledge in oracle super cluster.

Proficient in all DBA responsibilities such as Instance tuning, I/O tuning, user management, space management, Memory Tuning, Performance Tuning, monitoring, Optimization and Troubleshooting.

Proven ability of providing production support for 24X7 on multiple databases.

Proficient in all DBA responsibilities such as Instance tuning, user management, space management, monitoring.

Migrated single instance databases 10g multi nodes to 11g RAC Real Application Cluster environment for high availability and load balancing.

Exposure to SQL Tuning Advisor, SQL Profiles, SQL Monitoring, SQL Access Advisor, SQL Baselines and SQLTXTRACT, OEM tools and utilities.

Experience on E-Billing using Ant scrip

Implemented various backup strategies for Large / Medium sized databases using RMAN / SAN / VERITAS Net backup technologies.

Experienced in Monitoring/Analyzing performance periodically and to tune, debug and optimize the databases, applications, SQL, and PL/SQL code from time to time.

Experience in Oracle databases running on the Linux OS and Exadata.

Excellent working knowledge in logical backups, Hot/Cold Backup and Recovery and Cloning of databases using Recovery Manager.

Knowledge of Exadata Smart Scan technology which improves query performance by intensive query processing and data mining scoring to scalable intelligent storage servers. Worked on Oracle Exadata X2-2 servers

Experience on informatica (ETL) development, batch jobs and control M.

Oracle E-Business Suite Architecture using Concurrent Processing server supports data-intensive programs.

Have implemented ORACLE STREAMS and worked on both types of standby databases supported by DATAGUARD (logical standby and physical standby).

Solution with strategic disaster recovery plans with different recovery procedures and methods.

Cloned Database from Production to Test and Development and from Development to Production.

Experience in migration of oracle database to higher version and installing patches.

Exporting and Importing of dumps using expdp and impdp

Experience on handling very large database (vldb).

Expertise in PL/SQL, SQL and UNIX Scripting (Used to write UNIX Scripts & implemented by Using CRONJOB for Day–to–Day activities).

SQL statement tuning using Explain Plans, SQL Trace using TKPROF utility and AUTOTRACE utility. 10gOEM Grid Monitoring custom scripts troubleshooting oracle databases using sql trace utilities.

Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.

Resolved database network problems using Oracle Net Configuration Assistant (NETCA) and Virtual IP Configuration Assistant (VIPCA).

Good coordinator, understanding and presentation skills with all work departments. Work as the subject matter in the matter of performance issues, reorganization, auditing the required down times and the effect on the business application between the developers, system administration and the end clients.

Experience as On-Call 24x7 production DBA support.

TECHNICAL ENVIRONMENT:

OPERATING SYSTEMS

OEL 5, Sun Solaris 2.5, 2.6, 8, 9, 10, HP-UX 10.x, 11.x, IBM-AIX 5.1, 5.2, RHEL 2.1, 3.x, 4.x, 5.x and Windows 95/98/NT/20003.

RDBMS

Oracle 12C,11g,10g/9i/8.x, Sql Server 2000, 2003, 2005.

LANGUAGES

SQL, PL/SQL, C#, C, C++, XML, UNIX Shell Scripting, PERL Scripting

SOFTWARE APPLICATIONS/TOOLS

SQL*Loader, Sql *Plus, 10g OEM, Grid RMAN, 10g Data Pump,DB2, Netezza,

Data Guard, Export/Import, ORACLE 11g,10g,9i,8.x, (RMAN), AWR, ADDM, DBMS_STATS,STATSPACK, Clusters, VERITAS Net Backup, PL/SQL DEVELOPER V6.0, SQL DEVELOPER 1.2,OEM, NETCA, DBCA.

WEB TOOLS

HTML, XML, Dreamweaver.

EDUCATIONAL QUALIFICATIONS

Bachelor degree, Jawaharlal Nehru Technological University, AP, India

PROFESSIONAL EXPERIENCE:

National Association of Insurance Commissioners (NAIC), Kansas City, MO

Oct 2014- Till Date

Role: Oracle Database Administrator

The National Association of Insurance Commissioners (NAIC) is the U.S. standard-setting and regulatory support organization created and governed by the chief insurance regulators from the 50 states, the District of Columbia and five U.S. territories. Through the NAIC, state insurance regulators establish standards and best practices, conduct peer review, and coordinate their regulatory oversight. NAIC staff supports these efforts and represents the collective views of state regulators domestically and internationally. NAIC members, together with the central resources of the NAIC, form the national system of state-based insurance regulation in the U.S.

Responsibilities:

Installed Grid Infrastructure Software on new Linux Servers for 2 node and 3 node RAC and Failover environments and Oracle Grid Control 11g Installation.

Experienced in Installing OEM agent and hooking up to the grid.

Worked on OEM 12C grid for monitoring the Listeners present in the oracle environment.

Worked in troubleshooting RAC and implemented ASM features.

Viewing Exadata Database Machine Topology, Drilling Down to Individual Targets, Viewing Exadata Database Machine Alerts, Viewing Exadata Database Machine Metrics, Adding Exadata Components Manually.

Applied necessary Patches during installation and also in up-gradation of databases.

Extensively worked in setting up Oracle physical standby database using Data guard.

Experience with Data Guard Feature, Implemented building and Rebuilding of Standby Databases.

Experienced in switching primary database to standby and standby to primary during regular maintenances of catalog databases and DR databases.

Configuring Oracle Self-Service E-Billing on Oracle Exadata using Oracle Real Application Clusters (RAC) requires that you manually create database instances using Database Configuration Assistant (DBCA).

Handy in utilizing data pump tool for exporting and importing the data between databases.

Involved and Upgraded Analytical Databases from 10g to 11g.

Installation and configuration of Golden Gate on 11g database for the replication.

Resolving the issues in conflicts between the target and source database in golden gate.

Supporting migration and upgrades using Oracle Active Data guard environment using Oracle Data guard Broker, Monitor and fix plans for sub-optimal SQL queries.

Implemented Bi-Directional replication in golden gate.

Performance tuning of queries consuming Excessive Resources or slow running queries by providing Required Hints to the Query.

Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using Explain Plan.

Well Experienced in taking Cold Backup for a very huge 64-Tb Database.

Experienced in managing Daily Online backups (Level-0 and Level-1) and Archive Backups using RMAN.

Migration of databases from 10g to 11g using export/import and data pump export/import utilities and Performed database refresh activities for business requirement and tuning purposes.

Weekly Data Refresh from Production to Development and Test environments using Data Pump export/import.

Having good exposure in user management, Table space Management, Session Management, undo Management issues.

Experienced in managing space issues in the Database Level for table space and Regular file system cleanup at UNIX level.

Experience with peregrine ticketing tools for resolving the tickets.

Environment : Oracle 12c/11g/10g, SQL Server 2000/2005/2008/2012, Windows Server 2003/2008/2012, OEM, RMAN, Data Guard, Oracle ZFS, DB2 9.7.

Tools: Toad for Oracle, SQL Developer, PL/SQL Developer, PUTTY, SSMS, DBArtisan, Foglight, Terminals.

Client: State of New Mexico Sep 2013-Sep 2014

Role: Senior Oracle Database Administrator.

Responsibilities:

Configuration, Installation and maintenance of Oracle 11g RAC databases including Golden gate, ASM and CRS.

Performed upgrades from Oracle 10g to 11g and applied patches.

Worked on this project as Oracle Core DBA. Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export /Import), Database backup (Hot & cold).

Worked on Features: Data Pump, ASM and RMAN. Data Base Recovery (complete & Incomplete).

worked on Oracle GOLDEN GATE for transferring data betweem 10g and 11g

Involved in Base migration from 10g to 11g in production databases

Proficient in managing Oracle Instance, database storage structure, schema objects.

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

Involved & performed Production Change Requests for PRD major DB changes. New DB creation, Existing DB deletion, various DB Housekeeping activities. Implemented 10g RAC and 11G RAC on a test basis.

Administration of all database objects, including tables, Indexes, views, sequences, packages and procedures.

Installing ASM environment and migrating database from NON-ASM to ASM.

Experience in Planning Database, Sizing table space, Create database, scripts, Monitor databases, Interact with developers, Oracle Install, Upgrade, 24x7 production support.

Generating Statspack reports and AWR and ADDM reports for Database for Application tuning and also database Partitioning. Collected performance statistics memory usage, data storage.

Adding the required User Logins, Groups and Users, Granting and Revoking Permission to/from the users. Co-coordinating with on-site counterpart as well as clients and understanding requirements

Installation of Oracle database 10g software with RAC using Oracle Cluster-ware. Oracle Data Guard setup done for RAC. Installation of Oracle 10g management agent and grid control.

Experience in Performance and Tuning databases using various techniques. Collected performance statistics memory usage, data storage.

Created Cluster-database, Cloning of Cluster database on Linux, start and stop Cluster database services.

Designed and developed Database structures (Database triggers, Procedures, Functions to implement business Rules). Loaded data into Database using external tables. Exposure to Oracle Utilities and Tools like OEM, Import-Export, Auditing, RMAN.

Environment: Oracle Database Server 10g/11g, Golden gate, IBM-AIX, SunSparcSolaris64bit, and Redhat Linux. TOAD, PL/SQL, PUTTY, Export/Import, RMAN, Data Pump, AWR, TKPROF, ADDM, ERWIN

Client: Fifth Third Bank Cincinnati, OH April 2012 – July 2013

Role: Oracle Database Administrator

Responsibilities:

Installed, configured, and maintained Oracle 10g and 11g R2 on Linux and also Upgraded from Oracle 10g to 11g.

Up gradation of Grid Infrastructure and Oracle Databases from 11.2.0.1 to 11.2.0.3 on 3 node RAC environment.

Database Refresh from one version to another version.

Focusing on Exadata administration. With nodes ranging from 2 to 8 and incorporating Dataguarded Exadata clusters for maximum availability.

Disaster recovery of Exadata Dataguard Physical Standby.

Failover/Switchover/Loss of service/Rebuild/Corruption/Loss of datafile testing.

Use of RMAN for backup operations with Exadata.

Worked on X3-2 machine where backups, restores are run across all database instances in Exadata system with two or four RMAN channels allocated per instance.

Scheduling the backups for the database using EM 12C cloud control.

Migration of database from one server to another server.

Responsible for setup and implementation of 2 Node RAC on Linux in 10g and 11g R2.

Implemented Data guard, creating physical standby databases in 10g and 11g RAC environment for production database.

Installed, Configured and Administered Golden gate.

Configured parameters for the Bi-directional replication.

Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.

Done migration of non ASM database to ASM database.

Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups.

Used cross platform transportable table space (TTS) to transport tablespaces across platforms.

Data Refresh in Test and Integration Databases using Transportable Table spaces.

Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.

Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.

Performed patching on Oracle Database Server 10g and 11g using Opatch utility.

Daily Health Check Up of the Database using AWR, ADDM.

Perform Daily Monitoring of Oracle Instances, monitor users, and tablespaces, Memory Structures, Rollback Segments, Logs and Alerts.

Performed day to day administrative tasks by analyzing the database like checking for failed processors, verifying the query for particular issues and validating disk space.

Created Users with limited rights as per specific module under specific client. Granting roles and profiles as per system study to users.

Replication of tables to cross platform and Creating Materialized Views.

Configured and Implemented Cold/Hot Backups Also configured database cloning using RMAN.

Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.

Developed Scripts for transferring data from production server to testing/development servers.

Shell scripting and PL/SQL programming to resolve business problems of various natures.

Experience with UNIX and SQL commands.

Managing databases on multiple servers.

Environment : Oracle 10g, 11g, Linux 4/5, OEM, DBUA, RMAN, Golden gate, Grid, RAC, ASM, Exadata X3-2, Data guard, SQL*LOADER, AWR, ADDM, ASH, TTS, Data pumps, Exports/Imports.

Client: National Life Insurance, Montpelier, VT Oct 2010 – Mar 2012

Role: Sr. Database Administrator

Responsibilities:

Involved in 24x7 support for both production and development databases with on-call pager

Installed Oracle Streams for Basic and Advanced Data Replication between Oracle Databases and other databases.

Used Oracle Streams for propagation and management of data, transactions and events in the data stream to ensure smooth and transparent data flow

Upgrade and Migration of Database from 9.2.0.6 to 10.2.0.2 later 10.2.0.4 and applying patches whenever required.

Cloned/Refreshed Oracle Databases for development and testing

Partitioned large tables to increase the performance.

Performance tuning of Oracle Database Objects by fixing row chaining

Installed and Configured Oracle Dataguard for Oracle 10g & 9i for the maintenance of Stand by database

Extensive use of Oracle Dataguard for protection of critical production data & provide data / disaster recovery support.

Optimization and tuning SQL queries using TRACE FILE,TKPROF,EXPLAIN PLAN

Continuous monitoring of database performance during peak and non-peak loads using STATSPACK

Tuning heavy data loads, monitoring and Performance tuning

Setup backup and recovery procedures using RMAN. Performed hot and cold backups using RMAN

Performed block recovery using RMAN. Performed backup validations using RMAN

Oracle Database monitoring, troubleshoot and resolve the issues

Management of schemas, objects partitioning the tables & indexes

Automation of data load using Korn shell scripting and SQL*Loader

Responsible for setting and managing user accounts, Granting required privileges to users

Defining and Implementation of backup and recovery strategies

Performing all daily Maintenance tasks. Interacting with Oracle Customer service when required

Writing scripts for the system and database for effective functionality and report generation

Applied High priority, security patches downloaded from Metalink.

Involved in Logical and Physical database design.

Environment: Oracle 10g with RAC, Oracle 9i, Oracle 8i, TOAD, Solaris8/9, PUTTY

Client: UBI Investments, India Nov 2007– Aug 2010

Role: Jr. Developer/Oracle DBA

Responsibilities:

Installing Oracle 10g and upgraded it to latest 10g patch set on HP-UX 11.23

Migrating applications from non-clustered oracle 8i/9i/10g databases to new

Monitoring and supporting Applications using OEM 10g Grid Control

Created PARTIONING of its types like Range, List & Hash by the specific use.

Implemented Oracle Streams for Replication and applying patches

Implemented schema level, table level and bidirectional oracle streams.

Registering Databases to Oracle 10g GRID

Registering Databases to RMAN Catalog

Planning and scheduling Backups, RMAN, taking Logical Backups.

Experience in Export/Import and Data pump.

Environment: Oracle 9i, ASM, Oracle 10g Grid Control, Oracle 9i, HP-UX 11.23.

Contact this candidate