Summary

12 years of IT Experience as Oracle DBA in Oracle 11g/10g/9i databases design, implementation, Administration, tuning and troubleshooting on different operating systems such as AIX/HP-UX/Solaris/ Linux VM ware cloud and Windows.

• Proficient in Oracle 11g/10gR2 Database Design/Architecture, Disaster recovery, Data Guard, Oracle 11g/10gR2 RAC, ASM and in backup and flashback recovery techniques. Strong in SQL Application Tuning. Expertise in DBA Scripts for adhoc backup recovery and Database tuning
• Experience in Amazon Ec2 cloud setup and migrations.
• Experience in setting up Disaster Recovery using Physical standby with flashback and Oracle Data Guard, Logical Standby configure, troubleshoot sql apply, skip setting.
• Enterprise Management and Administration: Estimated technology requirements based on need. Recommended and implemented Oracle Enterprise products GRID, OEM, RAC, Data Guard and Active Data Guard required by the client. Architecture designed at Server, SSA Shared Storage , and Physical and Logical database levels. With many clients designed, revised and implemented near zero maintenance Modern Enterprise Management Architecture GRID, QUEST Enterprise Tools
• Strong migrations experience from Sybase ASE SQL Server to Oracle10g.
• Designed and implemented database backup recovery solutions using shell scripting, Recovery Manager RMAN and media manager Tivoli
• Expert in methodology development, process improvement, enterprise technology strategy development and implementation
• Experience in database capacity planning, sizing objects, space management, and monitoring DB growth
• Monitoring and optimizing the Database Performances through Database Tuning, System Tuning and Application Tuning using AWR, ADDM, DBMS SQLTUNE, SQL ADVISOR, DBMS STATS etc.,
• Extensive Knowledge of Flashback technologies, Oracle Data Pump, Export/Import
• Experience in Upgrade/migrations of oralce9i to 10g and 11gR2
• Worked extensively on production support environments, Test and Development databases and provided 24 x 7 production support for database and applications.
• Experience on various tools utilities like TOAD, OMW, OEM, Grid control, RAC, Data guard, ASM, SQ PL/SQL script, Autosys.
• Data Analysis, Design and implementation of Business Applications using Oracle Relational Database Management System on various platforms such as AIX/HP-UX/Sun Solaris/Linux and Windows.

Skills:

• Oracle RDBMS Architecture: Oracle 11R2/10g/ 9i, Grid Control, RAC 11g, 10g, Oracle internet Directories OID
• Non-Oracle RDBMS: SQL Server 2003/2000, Sybase ASE 12.5, MySQL 4.1,MS-Access
• Development Tools: TOAD, SQL Developer, DB-Artisan, SQL Loader, SQL PLus, PL/SQL, T-SQL isql, osql, isqlw - query analyzer , Erwin
• Diagnostic Tools: DB Grid Control, ADDM, AWR, TKPROF, Explain Plan, Statspack, UTLSTATs, Quest Spotlight, Quest SQL Optimizer, ASMCMD, SRVCTL, SQL Performance Analyzer, ADR, ODSM
• Backup Recovery: RMAN, Data Pump, Import/Export, ,Data guard,Recovery Advisor, SQL Backtrack, Tivoli Storage Manager TSM , Oracle secure S3 backups Amazon cloud .
• Operating Systems: VM Ware Solaris 10/9/8, Sun Cluster 3.1, IBM-AIX 5L, Red Hat Linux 9,VMware Cloud, Windows Servers 2000/2003
• Hardware: Dell Power Edge 6850, Compaq Proliant 8500 for clusters, Mid- Range Sun V480/V490, Sun fire X4100, X4200 for clusters
• Tools/Utilities: Rational ClearQuest, ClearCase, BMC Remedy, AutoSys
• Virtualization: Oracle VM 2.2, VMware Server 2.0.1
• Cloud : AMAZON Cloud.
• Languages: Sh, shell, K sh, Cron scheduling, Vi Editor, Shell Programming, WSH, VBScript, Java Script
• Applications: MS Project, Ms-Office, CVS, Remedy, Rational Clear Quest, Clear Case, Crystal Reports 8.0

Experience:

Confidential

Systems Engineer at Administration

Support Oracle 10gR2/11gR1/R2 production/development database and Applications to maintain accurate and efficient data collection across the nation. The Applications integrated with Oracle internet directories OID for their enterprise customers/users to provide high level security to access the data from any location.

Responsibilities:

• 24/7 production databases support.
• Amazon Cloud migration of Existing Databases Current ongoing Task.
• Successfully migrated ARTMS application to Amazon Oracle Cloud AWS .
• Migrated lower environment Oracle databases to VMware cloud computing for better performances
• Create and maintain standby databases for all the production databases using Data Guard as part of
• Upgrade Oracle 10gR2 to Oracle 11gR2.
• Installed OID and web logic to configure ODSM.
• Disaster recovery plan.
• Database installations/admin support for COGNOS Reporting services team
• Troubleshoot performance issues and tune the Database at various levels using AWR, ADDM, SQL tuning profiles/optimizer/TKProof/explain plan
• Monitor the databases using DB Grid Control
• Support Maintain databases for Grant solutions
• Provide DB development support.
• DB refresh on request from the customers/developers.
• Daily Backup setups automation using Datapump / RMAN
• Configure OSB Oracle Secure Backup to S3 Amazon cloud.
• Support and maintain Oracle enterprise users / internet directories OID

Environment: Oracele11g/10G/, Oracle internet Directories OID , VMware, Amazon Cloud, Red Hat Linux 9, Sun Solaris 9/10, Oracle Grid Control, ASM, Data Guard, Import/Export, Datapump, RMAN, SQL Loader, ADDM, AWR, TKPROF, Explain Plan, ODSM, Quest TOAD 11.x, Shell Scripts,,Jira, Win-XP, Ms-Project.

Oracle DBA Consultant Application and Support DBA

Confidential

Currently working as an Oracle DBA consultant to provide 24/7 support for Oracle databases in Capital Markets of DRM DSM services. The applications under capital Markets are Trade/ Cash mgmt/ financial / loan / Asset market to market / Price verifications/ Stamps etc.

Responsibilities:

• Performance tuning at various levels like DB level, memory and SQL application tuning using AWR, ADDM, SQL Tuning advisor.
• Configure and maintain Data Guard Physical Standby database for the production database and tested for Switchover, fail over, activating the standby to primary and zero data loss.
• Performing DB restores using Datapump/RMAN
• Coordinating with Oracle support teams to fine-tune the database and application at various levels.
• Migrated Sybase ASE 12.5 DB to Oracle 10.2.0.4 with Oracle Migration Workbench
• Installation, upgrading, patching, designing, configuration, tuning and production support for Oracle 9i, 10g 11g RAC databases
• Configure OEM, OMS and Agent on Linux servers for back office database servers.
• Troubleshooting Performance related issues and providing appropriate Performance solutions using AWR, ADDM, ASM, Automatic Space management, SQL Profiling, Undo Tablespace management, reusable space management features and SPA.
• Installetion and configuration DB Grid Control for managing databases and performance tuning of databases..
• Developed shell scripts, PL/SQL procedures to monitor the databases and scheduled UNIX cron jobs and Oracle DBMS JOBS.
• Providing support to application teams for designing and configurations for databases.
• Provided solutions for faster ETL loads using SQL Loader/ Erwin
• Experienced in monitoring the databases by using Oracle utility Grid Control.
• RMAN Setup for the Databases
• Cloned databases from Production to Non-Production to specific point in time. Restored Recovered databases to previous Incarnation Points.
• Implemented physical Data Guard for high availability and disaster recovery in Oracle 11g.
• Worked on sizing of database and tables, re-organizing of tables, tablespaces and users.
• Provided Assistance to development team on SQL tuning in applications.
• Server side tuning rebuilding indexes, Analyzing Schemas etc. Schema refreshes using Data pump and Export/Import utilities from Production to DEV, SIT and test instances.
• Developed Autosys jobs for automation of routine morning shakeout activities.
• Developed Unix shell scripts and SQL scripts to carry out routine monitoring on databases.
• Managed database security, create and assigned appropriate roles and privileges as required by the application.
• 24/7 on-call, to attend to problems on a daily basis and resolve various database-related issues and customer requests.
• Support Sybase and Sql Server DB issues and restores.
• Worked closely with Vendors, in house developers to achieve maximum application performance. Reduced certain report process time from 6 hrs. to 2 hrs.

Environment: Oracele11g/10G/9i, SUN SOLARIS 9/10, AIX 5L, Linux 9, Oracle Grid Control, RAC, ASM, Data Guard, Import/Export, Datapump, SQL Loader, SQLBackTrak, AutoSys, OEM, ADDM, AWR, DBMS STATS, DBMS SQLTUNE, RMAN, EXPLAIN PLAN, TKPROF, DB Artisan, Quest Spotlight, Shell Scripts, CVS, Remedy, Clease Case, Win-XP, Ms-Project, SQL Server 2005/Sybase ASE 12.5

Confidential

Role: Sr. Oracle DBA Production and Development

• Performed oracle11g R1 upgrade/migration from Oracle 10.2.0.4 on Solaris8
• Installed Oracle11g on HP-UX and prepared HHS standard documentation with checklist.
• Implemented 2Node RAC on HP-UX.
• Implemented RMAN for 11g production databases.
• Migrated SQL Server2005 DB to Oracle 10g using Oracle migration Workbench
• Designed backup and recovery plan for Oracle11g database.
• Involved in Data model designing for new DB Environment.
• Installed oracle10g and created instances according the HHS procedures standards
• Implemented Disaster recovery plan document with various levels of DB recovery according to HHS standards.
• Maintain high level security for data protection and Data Encryption
• Involved in data loading issues during migration.
• Data security maintenance Data Encryption/wallet implementation according the HHS security standards.
• Security Patches installations and upgrading the Oracle DB.
• Installed Oracle 10g grid control for daily health check/maintenance and tuning purpose.
• Implemented RMAN and wallet securities for production databases
• Database Tuning at various levels indexing/SQL tuning/ space issues/network
• Generating various Adhoc reports like payroll, Authentications, violations , Audit control, space usage for the federal Govt. maintenance and Audit purpose
• Production Database restore using DATAPUMP RMAN on various hosts for testing the applications
• Maintain and updating Standby databases for the production database.
• Involving with management team and updated Database developments, changes, productions issues, future tasks.
• Involved in conceptual logical Physical Database Modeling using Erwin
• Application support SQL and PL/SQL
• Maintaining and Supporting TriZetto's Facets Application

Environment: Oracle11g/10g/Grid control/ASM/ RAC/ HP-UX /X-Windows Humming Bird /Windows XP/ RMAN/ CRON jobs/Shell scripting/DBCA/SQL Loader/Data Pump/SQL/PLSQL/CVS/MS Visio/ MS Project

Confidential

Role: Oracle DBA Production and Project

• Supporting Mission-Critical applications revenue impact 24X7 production system, Database size like 600 GB
• Providing 24x7 production support for maintaining the databases, backup failures, error logs monitoring space related issues related to log segment and temp tablespaces, Tuning the queries.
• Time to time critical patch installations and upgrading.
• Successfully migrated Oracle9.2.0.4 database to 10.1.0.4
• As a production support team member, I have worked on Sybase and DB2 production databases, use to monitor Sybase DB2 error logs un AutoSys and report to concerned team for troubleshooting.
• Database Restore using SQL Backtrack RMAN.
• Scheduling monitoring scripts for Database space usage, DB up time down time, daily tablespace usage, alert logs using shell scripts.
• Maintenance jobs like update statistics and routine backups.
• Tuning the Database at various levels.
• Scheduling jobs using AutoSys for backups and sending to TAPE
• Installation, Administration of Oracle 10.1.0.4 installation on Sun Solaris Box.
• Implemented 2Node Oracle10g RAC System on Red hat Linux
• Deployed 3 Production Databases, UAT and development Database setup environment.
• Extract from the existing Sybase database to oracle Database using Oracle Migration work bench
• Supported Development migration team in procedural language code into PL/SQL
• Setting up RMAN for Backup and Recovery on Production Databases
• Installed oracle 10g grid control for easy maintenance
• Monitored Daily backups , space managements and alert logs
• Restoring the production databases to test/dev/UAT environments when ever client requests.

Environment: Oracle 9i/10g / Oracle 10g Grid control / RAC /ASM/RMAN/ Sun Solaris/ Linux / X-Windows HummingBird /Win-XP/ SQL backtrack 6.0.1/ DB Artisan/ SQL PLSQL/ Cron obs/ shell scripting /Clear Quest/Clear case/ftp/DBCA/SQL Loader/I MP/EXP/Oracle 10g agent/ Sybase ASE/Oracle Migration work Bench/People Soft Financials support

Confidential

Role : Oracle DBA

• Supporting Mission-Critical consumer applications impact 24X7 production system, Database size like 300 GB.
• Implemented Disaster recovery plan document
• RMAN configuration setup for Backup, Recovery Strategy and disaster recovery on Production, Dev and Test databases
• DB Installation and setting up the Environment on Sun Solaris and windows operating systems.
• Implementing and troubleshooting advanced replication setup at customers sites
• Applying security patches on database.
• Implementation of Oracle replication server
• Involved in Data model designing for new DB instances.
• Monitoring alert logs/ space issues/ tablespaces/ cron jobs/
• Testing backups eventually by performing complete recovery on a separate server
• Database tuning using different tools like TKPROF, dictionary views, and Operating system utilities like iostat, vmstat, TOP etc.
• Technical support to the application development and testing teams
• Involved in Database design and Modeling using Erwin
• Supporting People soft Data access from Oracle Administration

Environment: Oracele 9i/10G, SUN SOLARIS 8, Windows 2000 Server, 9i parrllel Server , Oracle 10g Grid Control,Datapump, Export/Import, OEM, ADDM, AWR, DBMS STATS, RMAN, STATSPACK, EXPLAIN PLAN, TKPROF, SQL, PL/SQL, TOAD, Shell Scripts, Cron Scripts.

Confidential

Role: Oracle DBA

• Installation, Configuration of Oracle 9i/10g database on Win-2000/AIX/Solaris
• Set up a common SQL Net connect string for all Oracle Parallel Server instances.
• Planning database Logical and Physical layout for the Production system.
• Planning Backup and Recovery Strategy on Dev, Test and Prod databases
• Migrating the Database from 8i to 9i on Solaris platform
• Deploying Development, Test and Production databases
• Planning Backup and Recovery Strategy on Dev, Test and Prod databases
• Setting up RMAN for the Backup and Recovery on Production system.
• Setting up Oracle Enterprise Manager to command control all the databases.
• Replicating the database
• Generating scripts for database loading
• Performance tuning, Database Query optimization parameters for the best performance
• Generating execution plans for benchmark queries using Oracle and DB2.
• Creating tables, triggers, procedures, functions and packages using SQL, PL/SQL.
• Creating union queries, Wrappers, servers, nicknames using discovery link Federated Technology.
• Designing XML Query capability documents using XML with SeqStore Schema.
• Supporting and maintain TriZetto's Facet healthcare application

Environment: Oracle9iR2 /10gR1 / SQL PL/SQL/ Pro C/ Sun Solaris / Linux/ Shell/ Perl/ Toad7.x/ /Cron job/ AutoSys/ Shell scripting /OEM/ Oracle replication / SQL Loader/ Putty/ MS Project/ MS-Office/ DB2 / ER-Studio/ Discovery Link/ DB2/ VC/VB-COM/SOAP/ J2EE/ XML/MS-Visual studio/ODBC/ ADO/ CVS /

Confidential

Role : Development and Support DBA

• Responsible for installation, configuration and physical and logical database creation on Oracle 7.3.4 under Sun Solaris
• Deploying Development, Test and Production databases.
• Implemented backup for the databases Test, Production and Dev environment
• Restore databases from production to Dev/Test environments.
• Migration from oracle 7.x to 8.0
• Developed PL/SQL packages/procedures/functions to call up windows API from Win32 DLLs
• Performance tuning and database re-organization performed on different applications.
• Tuned the database during the production usage.
• Planning Backup and Recovery Strategy on Dev, Test and Prod databases
• Involved in Query optimization using EXPLAIN PLAN and TKPROF utilities and fine tuned using optimizer hints and initialization parameters.

Environment: Oracle8i/9i, Solaris 7/8, SQL Loader, Import/Export, EXPLAIN PLAN, TKPROF, SQL, OEM, PL/SQL

Confidential

Role : Developer DBA

• LIMS administrator and data migration from MySQL to oracle using migration bench work and SQL loader.
• Analysis, Designing of database and creating tables.
• Writing triggers, procedures, functions and packages using SQL, PL/SQL.
• User Administration, Backup and Recovery operations.
• Migrating My SQL Database to Oracle 8i using Oracle Migration Workbench and Oracle tool SQL Loader
• Monitoring and performance Tuning of database Query optimization parameters for the best performance
• Designing User interfaces in PHP, JavaScript on Apache web server.
• Retrieving the Lab experiment values and images from HPLC and storing in oracle database, generating reports.

Environment: Oracle8i /OEM / SQL PL/SQL, Forms and Reports , MySQL 3.2 Linux/ Unix AIX/ PHP 4.21 and JavaScript.

Confidential

Role : Developer DBA

• Database design, installations, troubleshooting and schema design and tables creation.
• Writing benchmark queries, triggers, procedures, functions and packages using SQL and PL/SQL.
• User Administration, Backup and Recovery operations as a maintenance job.
• Application coding with ASP.
• Bugs fixing.
• ASP, HTML, Java Script, VB-Script, VB-COM, Oracle 8i, IIS4.0 on Windows NT.