Oracle Data

Ram chilukuri

Email: *********@********.***

Address: ***** ****** **** **

City: herndon

State: VA

Zip: 20171

Country: USA

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

Skill Level: Experienced

Salary Range: 98

Willing to Relocate

Primary Skills/Experience:

See Resume

Educational Background:

See Resume

Job History / Details:

Ram 703-***-****

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

US Citizen

GOAL:

To pursue a challenging career as an Oracle DBA in a dynamic organization in information technology by making a long term contribution to the organization successfully through consistent hard work, sincerity and dedication.

SUMMARY:

14 years of total IT experience with 6+years as an Oracle DBA with an expertise in standalone and RAC environments.

Experience in Linux, SUN SOLARIS, AIX, and Windows environments.

Excellent experience in Installation and configuration of Oracle 9i, 10g,11g on Sun Solaris, Linux and Windows environment.

Configured high availability services like TAF, load balancing as per client side connection requirement.

Experience in applying patches for upgrades and various problems.

Experienced in implementing ASM for data storage and raw devices for clusterware files in RAC environments.

Extensive Experience in designing and maintaining Oracle Database in Clustered environment (RAC) on both Windows and Unix.

Great depth of knowledge in planning and implementing physical and logical structures of a very small database to very large database.

Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to 11g RAC environment.

Configured RMAN for full and incremental backups and used RMAN to create standby databases, for recovery, to migrate database from file system to ASM

Experienced in using 11g features Data Pump, Flash-Back Recovery, AWR, ASM, ADDM, ASMM, Grid control, and Recycle Bin.

Created and Managed Production database as well as Development/Test environments using tools like OEM, Performance Pack, SQL Navigator, TOAD, PL/SQL and SQL*Loader.

Experience in data modeling using ERWIN tool.

Plan, Implement and test disaster recovery using RMAN and custom written shell scripts.

Create and maintain oracle Data Guard configuration for disaster recovery and to manage planned maintenance.

Strong working experience in Install/Upgrade and Migration, troubleshooting of Oracle script files creation (using SQL, PL/SQL) for creating, maintaining, tuning the database, tuning the parameters as and when the situation demanded.

Database monitoring and tuning, application and queries using TKPROF, OEM, STATSPACK, ANALYZE, and custom scripts.

Experience in taking logical backups of data using oracle data pump utilities expdp and impdp to move Oracle data from a database or schema to another.

Good exposure to data transfer using advanced features like Transportable tablespace in export/import utility tools.

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

EDUCATION:

Bachelor of computer Science in Engineering,

CERTIFICATIONS:

Oracle Database 11g Administrator Certified Professional (OCP).

TECHNICAL SKILLS:

OS: HP-UX, Tru, IBM AIX, Sun Solaris, Red Hat Linux, Oracle Enterprise Linux, Oracle VM Server, VMware and Windows XP/7

Languages: SQL and PL/SQL, UNIX Shell, SED/AWK .

Databases: Oracle 8,8.x, 9.x,10.x and 11.x,DB2

Package Suite: Oracle DBA Support for Oracle 11i and Enterprise Applications

Clusters: Veritas Cluster, Oracle Clusterware and OCFS.

High Availability: Oracle 9i/10g/11i RAC, Standby Database, Advanced Replication, Oracle Streams, Clustering and Data Guard Setup, Automatic Storage Management and Configuration and Tuning and Materialized Views

Replication: Oracle Streams and Oracle Advanced Replication

Tools & Utilities: ERWin, Toad, Formatter Plus, PLSQL Developer and SQL Tools.

Oracle Tools: Oracle EnterpriseManager, 10g OEM Grid, StatsPack, Export/Import, RMAN, Toad, SQL Navigator,Quest Spotlight, BMC Patrol, Veritas NetBackup

Protocol: TCP/IP, SFTP, TELNET, HTTP, SSL, SSH

Office Tools: Microsoft Office/Works

EXPERIENCE

Client: Verizon Business, VA.

Environment: Oracle, 9.2.0.8/10.2.0.3/11i, 10g/11g RAC, RHEL, Sun Solaris, Red Hat Linux4,OEM, RMAN Jboss,ASM, Veritas

Tools: ADDM, AWR, Data Pump, Data Guard Broker and Statspack, TOAD,

Role: Oracle Database Administrator

Duration: Sep 2005 to Till Date

Verizon provides communications, information, and entertainment products and services to consumers, businesses, and governmental agencies worldwide I am an active member of Customer Care DBA group that has been vested with an important task of managing Databases related to core applications critical to business. As a member of this group I had been actively and proactively supporting various online and in-house applications such as ACSS - Automated Customer Support System, IVR, and Prime Biller, Single View and express Trak and providing administrative support for oracle stand-alone databases in RAC environments

Responsibilities:

24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues

Installed 9i, 10g and 11g databases on SOLARIS and Linux

Migration of Database from 9i to 10g and applying patches whenever required.

Upgrade of Databases from 10g to 11g

Installed and configured Oracle 10g/11g RAC high availability

Installation of Oracle cluster ware, Configuring public(SCAN) and private network and VIP

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

Implemented DATAGUARD (Standby) for high availability/disaster recovery purpose and configured the database to Switchover and failover.

Scheduling maintenance and health check of the application and databases using dbms_scheduler.

Proactively monitoring, identifying areas that need to be improved in the application and database using StatsPack, AWR, ADDM.

Implemented flash back technology with ASM option to use alternative ways for point in time recovery and to reduce recovery time in the situation of database crash.

Determine possible backup, restoration and recovery strategy using RMAN (level 0 and level 1 backup) and incremental updated backup.

Recovery and Cloning of databases using RMAN with VERITAS Net Backup

Used Data Pump utilities like expdp/impdp for logical backup.

Developed UNIX shell scripts and setting up cronjobs that automate database monitoring.

Created and maintained different database entities included tablespaces, data files, redo log files, rollback segments and renaming/relocating of data files on servers.

Write and execute PL/SQL code such as procedure, function, package or trigger as well as worked with pre-defined Oracle package to administrate database.

Implemented database auditing, data securityand Remediate high-risk violation in production environment.

Performance Tuning for long running queries using TOAD,STATSPACK, AWR reports, analyze, DBMS_STATS, SQL trace, explain plan. Re-designing of tables into partitioning tables. Analyzing existing table structures and fine tuning if required

Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and stand-alone instances.

Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).

Gathering schema stats and monitoring the index usage.

Provided all kinds of DBA support to development teams as well as production support to various applications.

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

Provided 24x7 on-call support for the production databases.

Significant Achievements:

Streamlined the Database refresh procedure for all the Dev/Uat and Training Databases.

Automated the daily Data-load process for few of the critical applications.

DB2 Database Administrator (July 1998 to Sep 2005):

Served as the DB2 DBA for the development, installation, and support of all online applications including implementation of various Amex projects.

Designed and documented monthly updates load process and scripts.

Installation of DB2 instances on AIX.

Excellent experience working on multi node environment with database sizes ranging from a few GB to multi terabytes.

Performing tasks for DASD projections/revisions, index analysis, review explains, and table partitioning strategy for DB2 on Z/OS.

Defining procedures, triggers and resolving issues on performance, backup/recovery, data integrity, database availability and other requirements for DB2 and IMS.

Build data refresh procedures for Model office and training subsystem databases.

Extensive use of Platinum tools RC/Update, Log Analyzer, Plan Analyzer, Boole and Babbage, IBM's MVS and DB2 utilities to manage the DB2 and IMS objects.

Participated with Data conversion team for converting legacy Data.

Implemented a Disaster Recovery Solution for the database.

Did capacity planning for the existing database when the data was supposed to increase and new schemas added.

Implemented db2 fixpaks and did migrations, client installations and upgrades.

Altered tables and added check constraints and referential integrity

Created and maintained databases, tablespaces, tables, views, Stored Procedures, Triggers and indexes

Interact with business team and development teams for incorporating new functionality

Participated in enterprise-wide application and database production releases

Developed shell scripts to handle DBA tasks and alerting systems

Documented plans and procedures in terms of backups, restores and disaster recovery

Data maintenance activities like REORG, RUNSTATS, LOAD, UNLOAD, IMPORT and EXPORT

Tuning application queries, databases and systems for best performance

Performed performance tuning and capacity planning using the parameters of dbm configuration file & db configuration file and various db snapshots

Achieved great performance improvement by migrating to p690, lesser maintenance. Down time and maintenance window was reduced.

Collaborated with developers to devise DDL and DML, in addition to contribution to code walk-thru's to analyze SQL code efficiency.

Ensured that developers adhered to standards during program preparation and implementation by assessing program SQL, verifying efficient access path, giving security access, and providing support.

Extensive DB2 DBA and DB2 Connect experience with activities involving design, installation, configuration, requirements gathering, data modeling, tuning, security, backup, recovery and integration of database applications.

Migrating data from DB2 7.1 to DB2 8.2.

Performance monitoring and tuning for DB2 databases

Creating EXPLAIN tables and running the visual explain utility on SQL statements.

Production support to various db servers and participated in On-Call rotation on weekly basis

Configured and Implemented the server including setting up the database filesystems(with sudo root access privileges) and implemented the full physical design.

Client: MIC Electronics Ltd, India

Environment: Oracle 8i, ODBC, JDBC, PL/SQL, LINUX, Windows

Role: Oracle Developer

Duration:Jan97 to May 98

Responsibilities:

Designed and developed scripts for administrative tasks like backups.

Analyzing and resizing objects for production database, running export/import utilities, off-line and on-line backups.

Manage monthly updates using exp/imp and SQL Loader.

Developed PL/SQL packages, procedures, functions and triggers to support application

Grant privileges to users to access systems and databases.

Created database objects like tables, tablespaces,indexes and views.

Helped developer to install oracle client, troubleshoot and establish the connection to oracle database through ODBC, and JDBC.

Contact this candidate