SUMMARY

• Over 8 years of professional IT experience in Administration, Systems Design Development, Maintenance, Testing, Integration, documentation in high - availability environments such as Networking, Retail, Finance, IT, Sectors.
• Expert in Architecture of Oracle Databases 12c, 11g, 10g with objectives of saving costs and time.
• Good Experience in Cassandra Installation, Data Modeling, Tuning and Data Migration from RDBMS to Cassandra (NOSQL).
• Strong experience in supporting development, unit test, system test, Integration test, certification test, load test and production databases under the flavors of UNIX
• Proven experience with mission critical databases high availability and disaster recovery environments configuration in 24*7 environments using 12c, 11g Data Guard with real time apply.
• Proficient in Database Administration activities such as Upgrades, Patches, TAR support Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation Experience in Upgrading databases. (11g to 12c, 10g R2 to 11g, 10g R1 to 10gR2)
• Expert in Administration, Productivity and Modeling Tools including OEM, Data pump, Exp/Imp, Option Packs/OLAP/Partition/RAC, TOAD, SQL.
• Expert in using BITMAP, B-Tree Indexes, Composite indexes, Hash partitioning and Histograms.
• Expertise in troubleshooting and performance tuning.
• Good Experience in Database Space Management, Memory Tuning, instance level tuning, SQL tuning using HINTS and suggesting recommendations based on analysis to the Application team.
• Expert in Database Health Maintenance using Stats pack, TKPROF, UTLXPLAN, Enterprise Manager, Self-developed Scripts & methodology, Log Miner, Diagnostic and Tuning Pack, DBMS Utilities/Procedures.
• Experience in SQL (DDL, DML, and DCL), and PL/SQL and experience in writing stored procedures, packages, functions, and triggers.
• Extensive experience with AWR, ADDM, ASH STATSPACK.
• Extensive experience with DBMS API’S and V$VIEWS, TOAD, Quest Spot Light, BMC Patrol and 10g Grid, 11g and 12c.
• Extensive experience with proactive monitoring the databases using 10g, 11g and 12c Grid Control Monitoring.
• Expertise in cloning using RMAN Duplicate DB and hot backups to create Test, QA, DEV Instances
• Experience in configuration of 11gRAC, 10gRAC, 9iRAC on Linux and Solaris using ASM and RAW devices and Oracle CRS.
• Sound experience in different phases of a project life cycle including design, architecture, programming, testing, end user support, and preparing customer specifications as a part of software requirements.
• Experience in using VERITAS Backup Exec and Net Backup in conjunction with RMAN to backup and recover databases.
• Experience in Data warehousing and ETL tools (Cognos & Data Stage)
• Experience in Managing/working/converting RAC databases.
• Experience in creating and managing Standby database using Data guard.
• Experience in Backup and Recovery activities using RMAN utilities.
• Excellent work experience in developing applications using ORACLE SQL Scripts, PL/SQL and Shell Programming.
• Worked extensively with configuring database backups in RMAN environments using TSM, Netbackup and Commvalut backup utilities.
• Expertise in Replication of Oracle Databases using Logical Standby and Streams.
• Extensive Expertise in data archive and purge methodologies using partitioning.
• Team player, maintained client/customer relationships by providing timely, superior quality products and services, understanding of client/customer needs, opportunities and satisfaction criteria.
• Proficient in interpersonal relations, leadership skills, Project Management, Communication, Outsourcing Partner Teamwork, and Organization

TECHNICAL SKILLS

Database Administration: Oracle 11g RAC, Oracle 10g, Oracle 10 RAC, Oracle 9i, Oracle 8i, Performance Tuning, Dataguard,Clonig,Upgrades and patches Backup and Recovery using Cold, SQL server clustering, Replication, Log shipping Database shipping, GoldenGate, Hot, and RMAN and Other Utilities

Programming: PL/SQL, Pro*C, SQL*Plus, C, C++, Shell Scripting. Exposure to J2EE

Operating Systems: HP-UX 10.x/11.x, AIX 4.3.x/5.1/5.2,WINDOWS NT/2000/2003 Server, RHEL 2.1/3.x/4.x/5.x, Sun Solaris 8/9/10, VMware ESX Server 3.0.x/3.5.0.

Tools: TOAD, PL/SQL Developer, BMC Patrol, NetBackup, OracleGolden Gate Repository database, DSE 4.8/5.0, Dev Center, Opscenter

Domain Experience: Financial Services, Telecom, IT, Retail.

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Oracle and Cassandra Database Consultant

Responsibilities:

• Managing multiple production, testing, QA and development Utility database instances which are more than 25TB size.
• Successfully Implemented Cassandra POC to PROD.
• Installed 6 node Solar enabled Cassandra (DSE 4.8/5.0) ring and migrated data from Oracle to Cassandra using Sqoop.
• Involved in Cassandra Data Modeling.
• Very Good Knowledge on Cassandra Architecture and Internals.
• Responsible for Cassandra Installation, backups and Health monitoring.
• Expert in Cassandra node addition and removal using nodetool utility.
• Expert in Cassandra Read, Write, Consistency Level and Compaction Tuning.
• Database migration from 11.2.0.3 to 12.1.01 and applied patchset 12.1.0.2 to multiple databases.
• Installed and configured Oracle 12c database with 2 nodes.
• Responsible for performance tuning and optimization at both the application level and database level.
• Database Maintenance and clearing of deadlocks, cleaning of database logs, Re-indexing, Tablespace monitoring, database objects monitoring, sql tuning and DB monitoring.
• 50+ databases upgraded from 11.2.0.2 to 11.2.0.4.
• Created different profiles and roles to secure the access path of database.
• Design and implement database backup and recovery procedures using RMAN for 50+ databases.
• Performing Create database objects (tables, indexes, etc.) and assisting developers with database activities.
• Scheduled the maintenance jobs and alerts through OEM 11g and 12c Grid Control and Troubleshooting the OEM Agent issues and fixing.
• Databases refresh using Oracle Data Pump export and Import.
• Continuously monitoring Production and Staging databases for optimal performance and very closely working with DEV and QA team to perform LOAD TESTS.
• Designing and developing packages in the database layer, stored procedures, functions and triggers.
• Responsible for Making Documentation on collaboration site for every monthly release changes.
• Responsible for providing DB capacity planning based on forecast customer numbers.
• Worked with Oracle Support on Sev1 issues to keep business running.
• Initiated different POC (Streams, MVIEWS, idle time option in Profile and Oracle Database resource Manager) to improve the DB performance and reduce the cost.
• Implemented Memory Parameters based on memory Diagnostics views recommendation to improve the Database performance.
• Expert in RCA (Root Cause analysis) reports.
• Expert in Sql in tuning.
• Responsible for monthly maintenance releases, writing scripts, checking in SVN location and reviewing changes with DEV, QA team and recommending any changes required to improve the performance for DELTA changes.

Environment: Linux RHEL 5.6, 12c, 10g RAC, 11gRAC, Oracle 11g (11.2.0.2, 11.2.0.3, 11.2.0.4), PL/SQL, SQL Scripts, Shell Programming, TOAD, RMAN, OEM 11g and 12c.

Confidential, Pleasanton, CA

Oracle Database Consultant

Responsibilities:

• Installed and configured Oracle 11g/10g RAC database with 4 nodes.
• Troubleshooting day to day issues in RAC environments and applying ASM, Grid Infrastructure (GI) patches and bug fix when and where required.
• User management and work as part of a team and provide 24x7 production support of type on-call operations.
• Cloning and maintenance of application system and database on Linux platform.
• Responsible for performance tuning and optimization at both the application level and database level.
• Maintained the disk groups using ASMCMD, to accommodate the huge databases.
• Monitoring the instance statistics and tuning the database to improve performance.
• Monitoring & Scheduling jobs for the daily activities for all the databases using CRONTAB.
• Design and implement database backup and recovery procedures using RMAN.
• Performing Create database objects (tables, indexes, etc.) and assisting developers with database activities.
• Troubleshooting the issues related to Performance issues, especially which impacts the application.
• Performed Tuning database queries, jobs, and data replication processes.
• Responsible for data load from data warehouse Teradata to Oracle using ETL.
• Setup, configuration and maintenance of standby databases (Oracle Data Guard) to ensure disaster recovery, high availability and data protection.
• Configured and tested services for failover in the event of node failures.
• Monitoring the instance statistics and tuning the database to improve performance.
• Scheduled the maintenance jobs and alerts through OEM Grid Control.
• Responsible for writing UNIX scripts to take the backups on weekly basis and scheduling jobs in crontab.
• Responsible for creating and troubleshooting the stored procedures.
• Responsible for working with release management people to sync up the all environments depending up on monthly deployment.
• Used Data Pump import to load data into tables.
• Databases refresh using Oracle Data Pump export and Import.
• Performed data load using SQL LOADER.
• Troubleshooting the OEM Agent issues and fixing.
• Performing clear state of the OEM Agents whenever required to keep the target and destination agents in sync.
• Continuously monitoring Production and Staging databases for optimal performance.
• Worked with Oracle Support on Sev1 issues to keep business running.
• Responsible for Making Documentation on collaboration site for every monthly release changes.

Environment: Solaris 9, Linux RHEL 5.6, 11gRAC, Oracle 9i (9.2.0.8), Oracle 11g (11.2.0.2), PL/SQL, SQL Scripts, Shell Programming, TOAD, Data Guard, RMAN, OEM 11g.

Confidential, Atlanta GA

Oracle Database Administrator

Responsibilities:

• Managing more than more 200 productions, test and development instances in 15 TB Environment.
• Administering ORACLE Databases 11g, 10g, and 9i.
• Applications Patch management: Patch impact analysis, patch application and trouble shooting.
• Applied database patches using Opatch utility.
• Involved in a project, which analyzes and applies quarterly Security patches (CPU).
• Involved in implementing Dashboard-based Monitoring solution by developing shell scripts and SQL scripts.
• 24 x 7 technical support, 24 x 7 during quarter and month close and weekends on call support.
• Performance Tuning of Applications and Databases using precise tool, tkprof, explain plan.
• Generating trace files for problem resolution.
• Involved Oracle Golden Gate configuration and troubleshooting GG issues.
• Provided day - to-day administration tasks like space and log management in SQL server.
• Involved in Database Migration from Oracle database to SQL Server 2005 database using SSIS
• Created Tables, Stored procedures, Constraints, Views and Indexes.
• Implemented Database Mirroring on different databases for High Availability
• Provided day-to-day administration tasks like space and log management. In SQL Server
• Worked on fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC.
• Involved in managing of users including creation, alteration, grant of system & db roles and permissions on various database objects.
• Created backup strategies, worked on scheduling the backups and automated the backups using SQL Server Agent.
• Created reports using SQL Server Reporting Services.
• Performed efficient and accurate Database conceptual/physical/logical modeling based on sophisticated yet successful system requirements analysis.
• Responsible for backup/recovery using RMAN utilities.
• Performing backups and recoveries using RMAN/ conventional hot backups.
• Responsible for setting-up and managing Standby database using Data guard for DR sites..
• User Maintenance (Creation, modification and deletions).
• Worked on user documentation like Instance strategy, Instance management, Problem manager, Setup document and Change management docs.
• Problem resolution repository, using Clarify solution linking utility has been created to reduce issue resolution timings.
• Working with Development, QA and other teams to support the related issues.
• Creating primary database storage structures (tablespaces), altering, and modifying the database structure according to the company’s requirement as necessary, from information given by the application developers.
• Creating and managing users, roles and profiles, auditing and monitoring databases and user access.
• Planning and implementing Backup strategy for the databases using RMAN, Scripting backups, once in two weeks on the application database.
• Planning and implementing Backup and Recovery procedures (Hot Backups, and RMAN), scheduling daily backups and performed periodic recovery tests.
• Allocated system storage and planned for future storage requirement for the database.
• Created primary database storage structure for developers to develop and test the Application.
• Created reverse engineering scripts, scripts for tablespace usage, table sizes and SGA Usage.
• Data loading using Oracle SQL Loader, developing SQL Loader scripts to load global data, and fine tuned SQL Loader performance using Direct-load mechanism
• Estimating the space requirements for database growth for next 12 months and availability of hardware to support the processes.
• Developing, Implementing and administering database policies and procedures.

Environment: SUN Solaris 5.9, AIX 5, 4.33 Linux RHEL ES/AS 3, Oracle10g, Oracle 9i, Oracle 8i,Database, AD Utilities, PL/SQL,SQL Server 2000/2005, SQL Scripts, Shell Programming, Clarify, Oracle 10g RAC

Confidential, San Jose, CA

Oracle Database Administrator

Responsibilities:

• Implemented and maintained high availability solutions using Standby Database, Data Guard, RAC; Analyzed and implemented different backup and recovery strategies.
• Upgraded and migrated databases (9i, 10g), designed and implemented solutions for data extraction, conversion, and replication and archiving.
• Developed solutions, PL/SQL procedures, scripts dealing with schemas such as tables, indexes, partitions, views, triggers, for daily production and performance.
• Configured the Hardware to install the Sun Solaris and oracle 9i software. Created multiple database instances for HA environment.
• Applied the updated latest patches to oracle and sun Solaris.
• Installed and configured the oracle 9i RAC on sun fire servers using VERITAS Enterprise edition cluster file system.
• Setup and maintained Logical Standby Database using Data Guard.
• Implemented Backup and recovery strategies using export/import, RMAN and online backups.
• Wrote shell scripts to implement periodic security management on the production databases
• Used Crystal Reports Tools when worked with Development teams and QA teams.
• Tuned the multiple databases for Performance. Involved in security audit of databases and servers.
• Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.
• Wrote packages, functions and procedure for reporting.
• Designed and implemented procedures and jobs for oracle database providing 24x7 support. Deployed disaster recovery plans and OEM emailing.

Environment: Oracle 10g/ 9.0.1.0/9.2.0/9.2.6 , SQL Server 2000, Dell power vault storage, SAN (Hitachi), Oracle RAC 9.2.0, SQL, PL/SQL, SQL Loader, OEM, Standby Database with Data guard, Erwin

Confidential

Oracle Database Administrator

Responsibilities:

• Managing Users, roles and privileges, space management Creating storage structures, Performance Tuning
• Responsible for maintaining multiple instances and a production instance.
• Configuring client machine to access Oracle Instance.
• Training of Client users & Maintained good documentation of DB.
• Monitoring Applications proactively and scheduled shell scripts.
• Actively involved in gathering requirements, system design, development, and application support.
• Worked as a Developer to implement the Customer Data mart creation of Qwest residential customers for Marketing Supporting systems.
• Scripts (PL/SQL, SQL, PRO*C, Shell) were developed to extract the customer data from Corporate Data Warehouse and loaded into the Customer Data Mart for MDSS.
• Performance tuning was done to improve the performance of the queries using EXPLAINPLAN.
• Queries performance was improved by creating new Indexes, forcing indexes, parallel processing, and modifying Where Clauses, etc.
• Re-organization of Tablespaces and Application and Database Performance tuning.
• Troubleshooting DB related issues and providing scripts for taking regular backups.
• Performed day-to-day database administration and ensured integrity, security, and availability of the database.
• Storage management, sizing the database objects, monitoring file systems, and table space growth.
• Performance tuning of the queries using Explain Plan, tkprof.
• Standby Database has been setup and monitoring using Data Guard.
• Provided On Call DBA support.
• Alerts setup for Database monitoring.
• Planned and implemented Backup and Recovery strategies.
• Provided Ad-Hoc reports from the Data Warehouse for management.
• Worked with Unix Core and storage teams for any issues related to OS level or storage issues.
• Developed user documentation for supporting tools and database and created problem resolution repository.

Environment: Solaris 2.6, RHEL ES/AS 2.1, Oracle 9i, PL/SQL, NetCool Reporter, Remedy, Oracle 8i, 9i