OBJECTIVE:

Seeking a challenging managerial position in the field of Oracle/PeopleSoft Database Management, Installation/Deployment and Implementation of Solution Delivery.

SUMMARY:

Over 20 years of experience in the analysis, design, architecture, development, installation/deployment and database/system administration of Client/Server systems with relational databases, Oracle, PeopleSoft and SQLServer. Proven expertise in setting up Replication (Shareplex, Oracle Streams and GoldenGate). Expertise in re - platforming of databases from one platform to other from inception to production.

TECHNICAL SKILLS:

Hardware: HP rp8400/rp7410/5470, HP-9000, Tru64, RHEL, ProLiant BL20p G3, RS-6000, AIXSUN SPARCstation, E2900, M9000, DEC, IBM PC Confidential, ICL

O S: HP-UX, TRU64, Linux (RHEL, Fedora), AIX, SUN OS, Unix (System V), Windows XP/2000/NT, MS DOS, VAX/VMS.

Languages: C/C++, Unix, Shell, Pro*C, PL/SQL, SQL*Loader, Data Mover, SQR, FORTRAN, Pascal.

Applications: Oracle 9i/10g/11g, ERWIN, PeopleSoft Financials 8.8, HRMS 8.8, PeopleTools 8.44.16/8Vantive 8.2, MC/ServiceGuard, Event Monitoring Service, Visibroker for C++ and Java, Java JRE/SDK, HP OpenView 4.5, GlancePlus, Omniback, SUN ONE Web Server, Sybase, SQLServer, MS SQL Server 2000, INGRES, Informix, Microsoft Access, Web Sphere MQ Series, Tuxedo, Samba, BEA WebLogic, IBM WebSphere, Apache Web Server, InstallShieldCrystal Reports, MS Project, OEM, VLDB, OLAP, OLS/VPD, SQL Navigator. DBArtisan 8.1.0TOAD 8.6, Tivoli Maestro, Shareplex 5.3.1 (Quest), Oracle StreamsOracle GoldenGate 12.2.0.1

PROFESSIONAL EXPERIENCE:

Oracle Database Management Analyst

Confidential, NJ

Responsibilities:

• Worked on backup remediation of databases setting up jobs in auto-sys and on boarding the databases to ZDLRA (Zero Loss Recovery Appliance), a ground breaking data protection solution that’s completely integrated with Oracle Database and eliminates data loss exposure for all databases without impacting production enviromments.
• Configured assigned databases successfully for DR Automation according to standards for automating the DR activity and created auto-sys jobs for scheduling.
• Install and configure Oracle GoldenGate to replicate DML and DDL operations which involves configuring the Manager process, create and configure Extract, Datapump and Replicat groups.
• Monitoring trends in incident management, determining problems and resolving those problems.
• Performing documented system builds and complying with release management, change management, configuration management, and quality assurance standards.
• Analyze Database Performance and suggest tuning tips to LOB DBAs by providing ASH, AWR and ADDM reports after identifying performance blockers and waiters.
• Administer tools like Enterprise Manager/Grid Control and Geneos. Setup DB targets in OEM and monitor in Geneos and trouble shoot. Setting up Dataguard.
• Strong performance tuning/troubleshooting skills with Oracle 11g & 11g R2 RAC environments.
• Use RMAN tools to effective management of space.
• Respond and Resolve helpdesk DBA support tickets
• Work with Dev, Perf, QA and production support teams on projects and production support related issues.
• Work in change management, create ITSMs for GI and RDBMS upgrades and for critical Patches and implement in various environments in a timely manner.
• Excellent problem solving and troubleshooting skills in resolving the PROD issues.
• Work with Oracle support in case of outages/issues related to incidents.
• Documenting processes and procedures as assigned by management.
• Enforcing Oracle Services and server configuration standards
• Enforcing all managed servers meet or exceed JPMCCSIRT standards (ESM & WESC).
• Providing Hotline customer project support for incident management.
• Involved in anticipating problem troubleshooting scenarios, analyzing ways in which to avoid the problem completely or greatly mitigate its risk.

Senior IT Architect/DBA Consultant

Confidential, NJ

Responsibilities:

• Worked in U2L project initiative of transitioning the current HW platform to Linux platform on implementing 5 node Linux RAC, migrating databases from Solaris (M9000) to Linux x86.
• Co-ordinate in deploying ITL implementations involving Oracle GoldenGate, Streams, Websphere, SQData and DataGuard. Provide expertise in high availability solutions.
• Co-ordinate and involve in AOTS DB refreshes with IBM DBAs and ITO DBAs in LSP, UAT and ST environments. Co-ordinate with EMAS/Dev team and make sure AOTS middleware deployment in DR environment is successfully installed for major releases.
• Attend ITL SWAT calls, End User support calls, VPMO calls for HW/SW, Capacity Planning and Performance calls and involve in resolving the issues.
• Work with Oracle support in case of outages/issues with replication and other DB related issues related to Golden Gate and Streams.
• Involved in ITL DB migration/deployment from E2900 to M9000 for ITL in Vtier architecture.
• Coordinate/Review ITL Deployment activities with IBM folks and EMAS.
• Install and configure Oracle GoldenGate to replicate DML and DDL operations as part of the AOTS DR initiative to achieve the real time replication for both CTS and AOTS databases.
• Worked with designing the best methodology in migrating the other ticketing systems such as CTS (Centralized Ticketing System) in to Confidential & Confidential One Ticketing System (AOTS) which is an infrastructure initiative based on the principles of the Concept of One.
• Provide technical expertise for the solution design, optimization, Business and System requirements following Confidential & Confidential standards. Support migrating various ticketing systems to AOTS.
• Involved in resolving database performance issues. Extensive usage of AWR, ADDM and other Oracle supplied tools.

Senior IT Solution/Service Manager

Confidential, La Roche, NJ

Responsibilities:

• Provide technical Subject Matter Expertise input into solution design, optimization, change requests and problem resolution.
• Participate in implementation of new projects and actively execute project related tasks and activities following Roche standards. Coordinate Install, configure, administer and troubleshoot RAC on HP-UX and Linux with ASM as storage option.
• Coordinate and manage new database creations, installations, upgrades, changes and software integration including test design, execution and support and ensure the integrity of solutions and qualified state during their lifetime.
• Coordinate and support security patching and upgrades with the PGx Solution Lifecycle Manager or Diagnostics equivalent in compliance with security SOPs/policies. These include moving/migrating databases from old servers and consolidating on new servers, moving databases to Shared Grid Environments and applying quarterly CPU Patches.
• Coordinate incident management activities with the PGx Solution Lifecycle Manager or Diagnostics equivalent and the PGI component providers until final resolution and supervise re-active problem management process and identify and analyze potential areas for improvement of the solution.
• Ensure re-use of existing PGI services, solutions and components wherever possible to minimize the development of new solutions and ensure that all new solutions are designed and developed in a cost efficient manner, delivering the appropriate level of service quality.
• Provide support in managing the relationships between involved PGI teams, and the IMs in the region supporting Customer Relationship Management (CRM) systems such as Siebel utilized by the Sales Force and other members of the Sales & Marketing Organization, Web systems such as Healthcare Providers portal, and all other Roche sales-oriented and intranet applications and all other Sales & Marketing systems including systems such as Analytics, Government Pricing System, Sample Accountability System, Customer Verification Systems, etc.
• Participate in all activities required to handle requests for new services from the IMs in the region or their business customers and associates. Managing and handling Oracle/SQL Server database service requests involving, creating new databases, altering the objects in various database environments, refresh of DEV/TEST environments from PROD to provide more current test data using BCVs. Creating the Component Specifications for creating new databases following the Roche’s ORASOE standards and co-ordinate in setting up the environments involving Siebel, Analytical Datawarehousing, CIVIC, HealthCare Practitioners Portal, Vantive, Global Medical Repository applications.
• Support large number of PGM databases ensuring that Streams is working to replicate the objects from one database to other. Install and configure Oracle GoldenGate to replicate DML and DDL operations which involves configuring the Manager process, create and configure Extract, Datapump and Replicat groups.
• Install Oracle Client software on Unix/Windows and perform the IQOQ as part of system validation.
• On request backups (logical or physical) of the databases as needed by developers or project managers and Review the space requirements of table/index and take appropriate action.
• Assisting in performance tuning Confidential Server level and SQL Query level based on customer request.
• Actively involved in planning different environments in re-plotforming of databases from HP RISC to HP Itanium Servers.

Senior Oracle/PeopleSoft DBA

Confidential, NJ

Responsibilities:

• 24/7 On-call production support for large number of databases, Setting up and Monitoring Maestro Jobs, Setting up Shareplex to replicate the objects from one database to other.
• Dealing with PeopleSoft Admins and handling database service requests, creating, altering the objects in various database environments. Daily Migration of objects from DEV to other databases as per the request and weekly migration to Production. Executing the approved production SQL and maintain the changes as per Sarbanes-Oxley Documentation. Creation of users, assigning the right roles for the users.
• Refreshing the DEV and TEST databases from the PRODUCTION database to provide more current test data, which includes copying the actual production database data files, renaming the database, creating the control file, applying recovery and performing some manual adjustments and executing the post-refresh scripts, so that the database can function as a proper test database.
• On request backups (logical or physical) of the databases as needed by developers or project managers.
• Reviewing the space requirements of table/index and either add space to the tablespace or reduce the next extent requirement.
• Identifying the maintenance items such as, SYSADM password changes, SGA tuning, Init.ora parameter modifications, Table and Index re-organization, and Tablespace De-fragmentation, and schedule them for implementation.
• Installation and configuring PeopleSoft system on UNIX and Windows.
• Set up PIA, configure Tuxedo Application Server Domain, Web Logic and Process Schedulers.
• Setting up single signon to navigate from PIA to report repository.
• Maintaining the PS system and databases with up to date patches and fixes.
• Performance tuning Confidential Server level and SQL Query level and; provide support to Application development team with tuning and troubleshooting.
• Develop DMS scripts for moving configuration and data from DEV to other environments,
• Adding new modules to PeopleSoft 8.4 installations, updating database to latest PeopleTools release. Creation execution of data mover scripts.
• Checking the database by executing DDDAUDIT.SQR and SYSAUDIT.SQR to verify that the database is complete.
• Involved in developing a strategy for successful Disaster and Recovery Plan for PeopleSoft Production HR database and FLS ( Federal Liaison Services) production database.
• Performance tuning Confidential Server level and SQL Query level based on customer request.
• Manage and support various backup and recovery strategies, installation of TSM/TDPO on different servers. Setting up cron jobs for daily exports, Daily, Weekly and Archive RMAN Backups. RMAN Deletions from the backups.
• Actively involved in setting up different environments in Re-Plotforming of databases from SUN to AIX from inception to Production.
• Troubleshooting hardware and software issues Confidential the OS level. Managing the HP and other technical staff Confidential local datacenter and remote Disaster Recovery site.
• Implemented NTP (Network Time Protocol) for HP-UX, Linux, HP Tru64 and Solaris to synchronize the clocks of computers across the Internet. Used different versions of NTP for different flavors of Unix.
• Every day health check of the systems, ERP VA (Virtual Arrays) monitoring which has Commandview software installed using armdsp, logprn and armlog commands. Monitoring of Tru64 servers using WEBES and ISEE tools.