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. 5300-04 (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

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 me.e Monitoring, alerts, lock information, backup, permission etc
• Resolved the Issue with Backup Recovery with RMAN.

Confidential, Murrysville, PA

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 education 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 (me.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, Toledo, OH

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, me/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 me/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.

Confidential

Responsibilities:

• 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.