SUMMARY:

• Over 15 years of IT experience working at lead Position, primary Oracle DBA in both SAP and non - SAP environment.
• Managed, coordinate between Onsite and offsite Oracle DBAs, Team of 2 to 6.
• Comprehensive Multitasking projects including Installation, Implementation, supervision and troubleshooting.
• Experienced in multi-terabyte databases from 1.8 TB to 8.1 TB size. Lead offshore teams and was responsible for 24/7 production support on 270 Oracle and 110 SQL Server (2000 and 2005) database instances for ERP and non- ERP System Databases.
• Working experience in heterogeneous database environment consisting primarily of Oracle.
• Experienced leading Project Teams; these include operations, application developers and vendors to improve technical Infrastructure security reliability and cost.
• Experience in planning, designing, and developing database architectures and management policies/standards.
• Expertise in RAC Oracle (11g/10gR2/9iR2) installation, configuration, and the creation of databases (ASM) on Linux /Sun Solaris 10.1.
• Expertise in Upgrade database from 10.2.0.1 to 10.2.0.4 from/to 11.2.0.3 two databases at a time in RAC and non-RAC environment.
• Migrating single instance to multiple Instances (two node RAC)
• Cross Platform Migration from Sun Solaris to Linux(RHEL-5) - (VMware- vSphere 4 )
• Designing/Recommending Database Security Policy.
• Managing Partitioning in OLTP environment.
• Prepared configuration Shard Storage like RAW Device, ASM, NFS, etc.
• Expertise in server migration, installation, configuration, patching, and upgrading databases and binaries for both environments (Oracle/SQL Server).
• Experience in Data Modeling or remodeling using Oracle Developing tools.
• Experience in performance tuning using advanced tuning methods, customized scripts, Oracle Enterprise Manager, AWR.ASH,ADDM,TKPROF or DB COCKPIT.
• Converted from Single Instance to 10g RAC, Setting up. Experience monitoring RAC cluster inter connect performance issues.
• Setting up undo management, Auto-segment Space Management etc.
• Experience in Capacity Planning, Space Management, and parameter setting for SAP through BRTOOLS and for non-SAP OEM and manually
• Expertise in providing solution on gaining Online Space (without Downtime) through online reorg, shrink table.
• Experience creating new databases and supporting enhancements to existing databases and managing database Structure, Storage Allocation, Table/Index segments, and Rollback segments, Constraints, Database Access, Roles and Privileges.
• Experience in development task and admin of Goldengate ver 10.2, 11.2 that is including setup of broadcast, consolidation solution & unidirectional tropology.
• Provided zero downtime migrations (Undirectional) setup, Installation, configuration in golden gate, varidata, Directory & troubleshooting.
• Designed and implemented Disaster Recovery Plan and Backup/Recovery Strategy for 24x7 operation using tools like RMAN, BRTOOLS (SAP) and Recovery in a Raw file system environment and Logical Backups for Oracle.
• Wrote UNIX/Perl scripts for user management. Coordinated with ORACLE support.
• Oracle 9i, 10g, and 11g Certified Professional (OCP), 10g R2: Administering RAC.

TECHNICAL SKILLS:

Operating Systems: Sun Solaris 10, 9, 8, Linux, AIX, HP UNIX, SCO UNIX, Windows 2003, 2000, NT 4.0.

Hardware: Sun Fire V890, v240, SAN storage 6100, Sun Enterprise 450, 3500, Sun Fire 280R, Ultra Spark 20, 10 and IBM Xeon Processor Power edge 1750, 2850, 4600 server series. (IBM 5L (64bit)), Bald server, LPAR.

Database: Oracle 11g (11.2/11.1.0.6 ), 10g (10.2.0.4), 9i (9.2.0.7), 8i, 8.0, 7.3.4., SQL SERVER 2000/2005.

Applications: SAP 3.1/7.0,Peoplesoft Finch & SCM 8.2/8.9, PeopleSoft Tools Version 8.48/8.49, Web logic 8.1 and BEA App. Server, BEA Web server, ECC6, PI, XI, PORTAL BI, BW, FIN etc.

Tools: /Utilities: AWD, ADDM, SQL*Loader, RMAN, Statspack, OEM, Toad, SSIS/DTS, ODMA, AutoSys.

Languages: SQL, PL/SQL, iSQL, Shell/Perl scripting.

Programming Languages: VB6, C.

PROFESSIONAL EXPERIENCE:

Confidential, Tampa Florida.

Sr. Oracle DBA

Responsibilities:

• Primary work: support Healthcare (ACA Project). But also support other database including 3-node RAC Cluster Environment.
• Review & recommend on Platform Database Migration as well as upgrade to 11.2.0.3.6 ver.
• Resolved the migration, performance Issues.
• Monitor and/or on Request Tune the SQL Queries.
• Write & Rewrite or Convert the scripts from HP UNIX to Linux i.e Monitoring, alerts, lock information, backup, permission etc
• Resolved the Issue with Backup Recovery with RMAN.

Confidential

ORACLE SAP DBA

Responsibilities:

• Primary work: Managing team of 2 DBA/BASIS for ERP kernel.
• Coordination with other kernel DBAs and resolving the issues and if needed.
• Setup & Configure the OEM for 10g/11g.
• Design new architecture before upgrade and review existing.
• Upgrade SAP Database from 10.2.0.1 to Oracle 11g (11.2.0.3) along with patching on SPARC 64bit OS
• Move the database from single instance to RAC along with upgrade to 11g for Non-SAP environment.
• Applied multiple patches (PSU Bundles) through MO Patch.
• Built and refreshed environments varying from 40 GB to 7.5 TB in ORACLE SERVERS.
• Implementation and testing Oracle Golden Gate Director, Veridata on Multi-Tiered client-server application.
• Installation, Configure & testing cross platform database migration & upgrade from 10g to 11g with Zero down time solution with Golden gate ver 11.1. from scratch.
• Setup of Oracle Golden Gate-Veridata for Identifying & Reporting data discrepancies between database and data.
• Provided solution Online Space Management through online reorg packages, shrink table or DATA PUMP etc. and regain the space.
• Enabling Security check like COST (secure Transport) and/or like “valid node checking” to restrict direct access to database.
• Provided support to end users and developers to tune the SQL.
• Provide assistance to BI/BW TEAM for schema redesigning, space, setup alerts.
• Evaluate, suggest & Resizing Memory parameters (such as SGA/PGA, SHARE POOL etc.) as per business requirements and hardware availability for OLTP and OLAP environment.
• Schedule SAP jobs and transports.
• To ensure Security set alerts to prevent parameter file and network files changes.
• Installation, configure and Integrate with Audit Vault.
• Prevent, View audit trail, delete/archiving audit file in regular basis.
• System monitoring, service level reporting and root cause Analysis -SMD through SOLMAN.
• Maintaining Users and Security etc.
• Setup, Configure and Produce the Database/Instance/SQL tuning Reports (AWR /ASH / ADDM / DB COCKPIT etc.) And provide the solution on issues.
• Monitored process failures, buffer statistics, check locks, updates etc. through DB COCKPIT, AWR
• Monitored and forecasted database growth and increased the Tablespace size using BRTOOL, DB COCKPIT.
• Schedule Backup/Archived the database BRBACKUP/ BRARCHIVE etc. for SAP database.
• Critical database recovery using time base recovery / cancel etc.
• Create the test environment for test process.
• Rebuilt the indexes for SAP database and non - SAP DBA.
• Involved in DR and evaluate the design and provided suggestions on configuration.
• Setup new and reset cron jobs on SUN SPARC/Linux OS.
• Write shell script for Space management.
• Designing/Recommending Database Security Policy and Maintenance golden Images and setup alerts for monitor.
• Health check with Monitored process failures through Alert log / DB COCKPIT.

Confidential, San Jose, CA

Oracle Database Architecture

Responsibilities:

• Planning, designing, developing database architectures for customized Oracle user’s products.
• Convert SQL server database into Oracle database or migrate data as per requirement.
• Create Range Partitioning for converted tables.
• Including Database administration, Database Maintenance, Database Optimization etc.
• Writing database documentation, including data standards, procedures and definitions for the data dictionary (metadata).
• Managing security policies/standards (i.e.) controlling access permissions and privileges.
• Developing, managing and testing back-up and recovery plans.
• Ensuring that storage, archiving, back-up and recovery procedures are functioning correctly.
• Capacity planning.
• Working closely with database programmers and web developers.
• Communicating regularly with technical, applications and operational staff to ensure database integrity and security.
• Commissioning and installing new applications and customizing existing applications in order to make them fit for purpose.
• Support development team for developed/Tune the SQL Scripts for Reporting.

Confidential, Villa park, IL

Lead ORACLE SAP DBA

Responsibilities:

• Installed Oracle Software/Client (9i/10g/11g) along with Grid Control.
• Provided support to end users and developers for creating database.
• Built and refreshed new environments varying from 10 GB to 2.1 TB along with large Database in Oracle database.
• Database/Instance/SQL tuning using TKPROF, STATSPACK/AWR/ADDM/DB COCKPIT etc. for SAP and non-SAP environments.
• Monitored process failures, buffer statistics, check locks, updates etc. through DB COCKPIT (For SAP)/OEM (NON SAP).
• Monitored and forecasted database growth and increased the tablespace size using BRTOOL, DB COCKPIT (For SAP)/OEM (NON SAP).
• Reset parameters, backed up/restored and archived the database with BRTOOLS /BRBACKUP/ BRARCHIVE, RMAN etc. for SAP database.
• Rebuilt the indexes for SAP database and non - SAP DBA.
• Applied multiple patches (MO Patch) on both the environments.
• Database migration from different version like 8I, 9i to10g/11g and hardware migration weekend support.
• Qa1 re-fresh from production to development (SAP).
• Optimized complex queries and SQL statements that hindered the performance of the database.
• Critical database recovery using time base recovery in Oracle.
• Installed new version of Oracle 11g (11.1.0.6.0 ) Grid on SPARC 64bit OS, upgraded with 11.2.1.3 patch.
• Integrated and remodeled data between SAP module (Business Warehouse and new version of SAP BI) and other formats.

Confidential

Lead Oracle SAP/MS SQL DBA

Responsibilities:

• Managing offshore and onsite team of five, coordinating between offshore and onsite DBA’s
• Assigning, monitoring, supervising, and providing solutions on issues.
• Accomplishing task in relay and/or water fall manner etc.
• Involved in architectural design for server migration as well as databases creation and migration.
• Migrate databases from Sun Solaris to Linux(RHEL-5) (VMware- v sphere 4 environment) to test RAC with ASM.
• Accomplishing Multitasking project like Planning & Upgrade/Migration/Patching, etc w & w/o co-ordinates.
• Installed Oracle Software/Client (9i/10g/11g) along with Grid Control on Sun Solaris, and Linux 5.4 using VMware.
• Administered 210 instances of ORACLE and 110 instances of SQL Server, along with cluster servers (active/passive node).
• Built, cloned/refreshed, upgraded and tuned databases up to terabyte size. Used TKPROF/AWR/ASH/DB COCKPIT for tuning.
• Development task: Undiresctional, Data integration & consolidation (tropology) for SAP Databases 9i to 10.2.0.5G using Goldengate (ver 10.2 ).
• Setup Cross platform database migration with Zero down time solution using Golden gate (ver 10.2.) in various systems.
• Setup task (Installation, configuration ) in golden gate, varidata, Directory for all the systems.
• Monitored backups, database growth and application processes using BRTOOL, DB COCKPIT for SAP and OEM for non-SAP applications.
• Optimized complex queries that impacted the database performance.
• Designed installation, maintained Data Guard Servers, RAC servers and managed data partitioning.
• Migrate MS SQL database to Oracle Database.
• Installed MS-SQL SERVER 2000 and 2005 on Cluster (active-passive node) and non-Cluster environment.
• Performed SQL Server Database Tuning using profiler.
• Created, impersonated user and verified user using Active Directory.
• Created Link Servers for with in/out of Domain.
• Created and managed DTS/SSIS package.
• Set alerts, operators and schedule backup/SSIS jobs.
• Provided end user support to the developers for designing data re-modeling using Oracle SQL Data modeler Tools.
• Resolved issues like connectivity, orphan user (SQL Servers), tables etc. and database restorations.
• Developed Shell scripts for the installation of pre-Oracle setup, hot and cold backup.
• Write a scripts for cron in Perl.
• Installed and configured 11G RAC, including SCAN configuration.
• Create and configure package an email message into the appropriate format, locates SMTP Information and delivers the message to the SMTP SERVER.
• Additional responsibilities: created documents and processes; supported XML applications.

Confidential, Fremont, CA

Oracle DBA

Responsibilities:

• Responsible for DBA tasks for supporting Ver. 8.x of PeopleSoft Financials and HRMS running on Oracle 9i, 10g.
• Performed tools and application upgrades and applied security patches for the PeopleSoft Application.
• Migrated the database to the new server and upgraded Oracle Database from 9.2.0.1 to 9.2.0.7 & 10g.
• Installed and configured client copy to the end user and administrated the connection manager.
• Created scripts to monitor tablespaces, disk space, memory, file system, alert logs and backup.
• Cloned database to create new environments.
• Provided change manager support for monthly Change Control implementations.
• Loaded data from flat files to the Database using SQL Loader and shell scripts.
• Refreshed DEV/TEST/TRN environments from production using RMAN.
• Monitored and resolved the memory issues on the Database, Apps and Web Servers.
• Implemented PeopleSoft Security. Created users, roles, permission list as per functional requirements.
• Worked on DDDAUDIT, SYSAUDIT report and fixed the inconsistencies.
• Configured the Tuxedo Application Server, Web Server, Process Schedulers, Report repository as part of PIA architecture.
• Modified initialization parameter of database, tuned SGA, I/O and application to improve system performance and tuned the SQL’s for long running query.
• Fixed the People books problems, or resolve single sign on issue for all customer applications.
• Installed and configured workstations in 2nd and 3rd tier.

Confidential, Mahwah, NJ

Oracle DBA

Responsibilities:

• Installed Oracle Software (9i/10g) including management packs on AIX UNIX 5.3.
• Upgraded and applied patches like (CPU).
• Created database on AIX UNIX 52(64bit).
• Performed database health checks like monitoring process failures, network failures and media failures through OEM tools.
• Installed, configured clients for Oracle Connection Manager and migrated cman.ora from 9i to 10g.
• Developed Shell scripts for installation of pre-Oracle setup, hot and cold backup.
• Performed database tuning using UTLBSTAT and UTLESTAT and STATSPACK.
• Built and refreshed the new environments varying from 50 GB to 4 TB.
• Managed partition data, users, schemas and alert logs, reorganized tables, built table indexes, performed database backup, and monitored database growth and planning capacity.
• Resolved host names with DNS for Oracle or database connectivity issues.
• Reorganized database for performance tuning.
• Provided audit reports on data/database objects to the auditors.
• Involved in installation, configuration, and capacity planning etc. in the RAC and Data Guard environment.
• Automated the database refresh process for the test environment.

Confidential

DBA

Responsibilities:

• Installed Oracle software (8, 8i, 9i) and database on UNIX and NT platform. Migrated data between platforms.
• Applied security patches, upgraded the database.
• Developed Shell scripts for the installation of pre-Oracle setup, hot and cold backup, restoration, and to check the data in the tape drive.
• Supported end users, maintained security, monitored memory usage, logs, process failures, network failures and media failures. Managed schemas and indexes.
• Created structures like tablespaces, rollback segment, undo management segments etc.
• Exported/imported data between various database instances.
• Implemented backup/recovery using RMAN with Catalog.
• Created physical standby database using SQL.
• Troubleshooting activities included database connectivity problems, user maintenance, database backup etc.
• Refreshed the database.
• Database tuning using UTLBSTAT and UTLESTAT and STATSPACK.
• Deployed applications to the staging and production environment.
• Analyzed user requirements and managed space for various development projects.
• Generated statements of work and other custom reports per EDP and government guideline.

Oracle DBA

Confidential

Responsibilities:

• Provided administrative supports for PeopleSoft 7.5 and 8.44 with Oracle on Windows.
• Applied monthly bundles to the demo database to keep it current.
• Migrated application fixes and in-house development projects between development, staging and production environments.
• Created multiple schemas to help data migration between schemas.
• Identified, resolved, or provided recommendations for different types of the performance problems ranging from database to I/O hardware performance problems.
• Used TKPROF, Explain Plan, and scripts to do SQL tuning.
• Created domains, configured Application Server, Web Servers, setup Process Scheduler, and implemented and maintained the report repository.
• Provided 24x7 on call production support.Installed Oracle software and database on UNIX and NT platform. Migrated data between platforms.
• Coordinate with other Branches, Officers and technical & non-technical staff.
• Responsible for Providing Solutions on issues at regional level.
• Developed Shell scripts for the installation of pre-Oracle setup, hot and cold backup, restoration, and to check the data in the tape drive.
• Supported end users, maintained security, monitored memory usage, logs, process failures, network failures and media failures. Managed schemas and indexes.
• Developed Shell scripts for installation of pre-Oracle setup, backup, restoration, and to check the data in the tape drive.
• Monitored the memory structures in the SGA shared pool.
• Backup /restore export/import utility or from backup/restore command.