Oracle Database Administrator Resume Profile
Summary:
- Confidential, SAP BASIS, GRC Security, SAP Consultant with Migration Vmware, SAP Solution Architecture, having a total of 15 year of IT experience, extensive hands-on experience in Project Evaluation, Information Gathering, Business Blue Print, Documentation, Customization, installation, configuration, Master Data Management architectures, business processes and data integration methodologies, SAP MDM Console, SAP Import Manager, SAP Syndicator SAP Data Modeler, Conversion, upgrade, migration and maintenance of SAP applications such as SAP R/3 4.6C, 4.7 EE, ECC 6.0/5.0, NetWeaver 7.3/7.0/2004, Solution Manager 7.1/7.0/6.0, Enterprise Portal, BI/BW, XI/PI, CRM, SRM, SCM APO 7.0, BOBJ, Data Services, SAP DR Disaster recovery on Oracle, Hp, Cisco , GRC Security, Security on PI, EP, eWM, EPM, BI, EP, HANA, BPC, BW, BOBJ:EP Admin MDM 7.1, SAP Finance, Controlling and integration with MM,PP,QM SD Modules, Master Data Governance MDG Material , Performance analyst and also has extensive hands on Hp-UX 11, Unix and Windows Networking and Oracle 11G Exadata DBA, DB2, MS SQL, HANA DBA.
- SAP Business Objects / BPM / EPM / PM / QM :- User Management System Architecture: -Enterprise infrastructure, Web Dynpro Java for developing portal applications, BPM MDM integration - workflow modeling/development, Server Intelligence, Clients, Central Management Console CMC , Central Configuration Manager CCM , Import Wizard, Services, Central Management Service Web application servers, Databases, Central Management System CMS Database, Auditing database, Authentication and single sign-on, end to end CE BPM 7.1/7.2/7.3/7.4, user administration on the portal such as role assignment, group assignment, granting/revoking permissions, maintaining user attributes, SAP NetWeaver Technical design, configuring, development, problem solving debugging, Central Management Server CMS security, Security plug-ins, Authentication and authorization, Information Workflows, Managing Web Application Container Servers WACS , DCOM and Firewall Settings with EPM, Architecting SAP NetWeaver BPM Composite Application Development and Process Modeling, Specifications review sessions, drafting , document and subsequent delivery of the development object, using Java / J2EE, modeling/development experience, SAP Master Data Governance MDG Material , BRM for Workflows.
- Upgrade to Oracle 11g for the Automated Client Eligibility System and will include set-up, administration and management of the Oracle Fusion Middleware server environment Oracle 10g upgrade to Oracle 11g, Applying SQL, DB2 Oracle database patches Windows and Hp-UN, Sun Solaris, AIX, Solaris RED Hat linux and Sco-Unix DB2, MS SQL and Oracle installations, Performance Tuning, upgrade, analyst monitoring at all levels sub-system, SAP DBA Cockpit, SAP Data Archiving, Oracle Database, SQL, DB2 DBA, RevTrac, Max Db .
- Backup SAP Br-tools Oracle Br-Backup, SAP system Audit Internal External performance tuning, analyst monitoring, Lifecycle in order to support business initiatives.
- Implementation and maintain the SAP instances that comprise the SAP environment sandbox, development, test, training and production , technical support to SAP application teams and internal customers/clients, SAP Correction and Transport System CTS to ensure all configuration and development objects are promoted properly, technical changes into the minimizes risk and achieves high reliability, availability and performance of each SAP instance.
- Expertise in SAP Security - Role Administration role creation, custom authorization objects and modification , and User administration user creation, assigning roles or derived / profiles and locking/unlocking/resetting password with good communication skills to support end user..
- Installation and system configuration ECC/ERP/BW/EP/XI/PI/CRM/SRM/SCM/Solution Manager/NWDI/NWDS/BPM/CE/CAF/BOBJ/BPC/MDG/EPM Administer the SAP database, plan and perform database upgrades, maintenance, perform database reorganizations, maintain database security, administer database performance, iDoc, ALE, RFC, Proxy, database problem determination and resolution, Development experience using Java / J2EE technologies, Development experience in working with WebDynpro Java for developing portal applications, BPM MDG integration - workflow modeling/development, BRM implementation experience for Workflows , SAP Master Data Governance MDG Material , completed 2 end to end CE BPM 7.1/7.2/7.3/7.4 projects.
- Implementation of Solution Manager - CHARM, service desk, document Management, Maintenance optimizer, Alert configuration, Early Watch Alert setup, Configuring root cause analysis, Business process monitoring, E2E monitoring setup, incident management, Alert monitoring, SMD Agents, Managed system setup, DB6CONV Central system monitoring, Experience working in SAP BODS, SAP Business Objects, HANA, SAP BW, Clustering of CMS Services as well as load balancing of Web servers Used Solman Service disk on ticket queue management, Managing Releases, presenting weekly ticket status to client, SAP Solution Manager ChaRM, EWE, maintaining SLA/Compliance, ITIL tools processes, HP Service Manager, Mercury tools, CPG industry experience.
- SAP Hardware migration, Hp Service Guard Virtual, Cluster, CITRIX, VMware SAP Server Hardware upgrade / OS/ DB/ SAP Manage data center operations with team on migration of New Server DR plan projects, SAP archiving by using t-code SARA and organize resources.User Management Security Administrator and Spool Management, Patch uploading, Client Copy, HANA replication using SLT, Data loading using BODS, HANA administration and security, project-specific test processes UTI, CRF raises test-related risks.
- 5 Years of post go-live production support after all consultants have left worked with ABAP/Database/Middleware/ProcessConfiguration/SD/MM/FI/CO/PP/CS/PS/PM/QM/HR /BI/EP/ EPM/ CCR/ GRC/SOLMAN/DR/Retail.
- 10 Years of SAP development, quality and production support experience in Medical, Healthcare Pharmaceutical Project and modifying Java/J2EE web applications for Online system, Develop and maintain ABAP programs, function modules, classes/objects.
- Develop of detailed specifications and the design of coding, testing, debugging and documenting of programs written from functional and technical specifications.
- Develop and maintain the Third party Interfaces with SAP HCM system, Develop and maintain user-exits, customer exits, BADIs, enhancements, Citizen Connect, WCEM, Hybris, CRM Service Manager, SAP NetWeaver Technical design, configuring, development, problem solving debugging.
- Work with Business and SAP function team and Third party systems and transferring information in and out of SAP using standard and custom methodologies. Follow up standards and developing reusable objects with object-oriented programming. Experience of leading various SAP implementations and Migrations H/w, OS and Database .
- Strong working knowledge of OS / Hardware / Network / analytical Storage integration in an SAP environment on existing setup in data center in 24X7 Production support environment Support off hours and weekends in required , Interfacing Informatics and Tibco etc , HPQC system.
- Actively attending all SAP Audit, SPA ITGC audit, SOX, FDA,USFDA audit and SOP prepare Training.
- SAP Disaster Recovery on SQL, Oracle DR Server Remote Location configuration and Monitoring , HACMP, HADR and Log Shipping, DB2 Workload Manager, DB2 Storage Optimization, BI/SQL software development, SAP E-learning module LSO configuration in SAP HCM, C , DB2, Visual Studio .NET, Crystal Report, CISCO routers, switches, CISSP, CISM, GIAC GSEC, CompTIA Security or Cisco security, SCORM Learning standards Skillsoft, Experience writing technical documentation.
Experience:
Confidential
Designation : SAP BASIS, SAP Solution Architecture.
Environment : SAP ECC EHP6, BW, EP, Open Text, DMS, Solution Manager 7.1
Responsibilities:-
- Technical Management : - Hp EVA enclose / Blade server management tools, Snapshots and snap clones on RAID Level on OS / DBA/ SAP, HP Admin on lungs assigning, HP DATA Protector Management tool for Backup schedule Online, Offline and incremental designing and analyzing in a real time production environment on live servers .
- Solution Manager Admin :- Installed Solution manager 7.1 with SP04 on windows 2008 server with MS SQL database, configured ChaRM, service desk and CTS for ALL the systems in landscape, configured maintenance optimizer and central monitoring systems, configured the solution manager diagnostics and deployed agents,
- Oracle Database Administrator : - Installation and design, table Index rebuild and reorganizing, ECC, BW, EP System refresh, SQL/PL SQL, ORACLE RAC, SAP tools, Performance Tuning, upgrade, analyst, DB refresh monitoring at all levels sub-system, Database, SQL, Oracle RAC, Data Guard, DB2 DBA, Max Db . database internals, data dictionary, PL/SQL coding, Backup Recovery concepts, database security and monitoring Grid Control MS SQL DBA Data Profiling, Data Architecting, Data Modeling , Data Profiling Toolsets Informatica, Oracle , Oracle Application Servers, SAN, NAS, XMLDB, WebDynpro Java for developing portal applications, BPM MDM integration - workflow modeling/development, Exposure to virtualized database environments is desirable.Data Modeling Toolsets ErWin, brtools, Oracle OID/OAM , Oracle DB Backup and Recovery using RMAN - Create and administer database Servers including backup RMAN, ASM , recovery, monitoring, tuning, etc. Oracle DBA with Golden Gate, Oracle RAC Cluster product and provides load-balancing, scalability and automatic failover protection, Oracle RDBMS version 11g and MS SQL 2008 and DB2 DBA, administrator TIS-Storage, BI/SQL software development, SQL and/or PL SQL, Unix/Linux/hp-un Shell Scripting.
- User Administrator :- User creation, Role and profile creation, providing authorization, resolving authorization issue as per the matrix in GRC RAR security creation and maintenance of risks Or SOD, facing the internal and external audits.
- SAP ECC 6.0, BW, EP, MM, QM, SD, GRC Consultant :- Installed, Implementation of ECC, MM, PP, QM, SD, BW, Solman, PI, EPM, GRC Security, CRM, SRM and EP portal systems across the landscape, performed post installation and post implementation support activities for all the systems ECC 6.0 EHP 6, BW, EP, PI, EPM, CRM, SRM, MDG Solution manager, NWDI, BPM, CE, CAF, BPC, BOBJ, BPC , ECC, BW, EP System refresh by using SAP, MS SQL DBA, HP EVA enclose management tools, IBM P/Power Machines I Series/400, configured wily intro scope for root cause analysis, WebDynpro Java for developing portal applications, , Master Data Management architectures, business processes and data integration methodologies, SAP MDM Console, SAP Import Manager, SAP Syndicator SAP Data Modeler, Conversion, BPM MDM integration - workflow modeling/development, Server Intelligence, Clients, Central Management Console CMC , scheduling background jobs and analysis the dumps, implementing the notes relevant to the dumps on error analysis, SAP-router configuration and maintained routab entries, integrating solution manager with the other systems in landscape, installation of business object and integration with BW, BI and EP Server, user administration on the portal such as role assignment, group assignment, granting/revoking permissions, maintaining user attributes, SAP NetWeaver Technical design, configuring, development, problem solving debugging, DCOM and Firewall Settings with EPM, SAP NetWeaver BPM Composite Application Development and Process Modeling, SAP Master Data Governance MDG Material , remotely supporting 24/7 to client on issue base and assisting my team members.
- Change Request Management.
- Test Management.
- Technical Operations.
- EP Administrator, CTS .
- DCPS Landscape support.
- Client Administrator.
- Spool Administrator.
- System Administrator.
- SAP GUI Administrator.
- SAP Landscape Security.
- System Audit.
Senior SAP Basis Administrator Consultant
Confidential
Responsibilities:-
- Presented 2 Different Landscape Pharmaceutical Generics , Assessment on Basis point of view and Sizing for present landscape Architect Servers, Implementation of ECC 6.0 EHP 6 and New dimension product of SAP NetWeaver Component ERP EHP 6, BI, BW, EP, CRM, GRC, CPI, SRM, PI, EPM, BPC, DMS, HR, DR, MDG, SOLMAN ChaRm with Oracle and SQL DBA backend in Hp Unix.
- Disaster Recovery Strategy for SAP Environments is the most economical Oracle DBA Oracle Data Guard Oracle RAC Cluster product and provides load-balancing, scalability and automatic failover protection, Oracle RDBMS version 11g solution for SAP users of all sizes, achieving cost-effectiveness as per the IT- ITGC audit requirement and license etc.,
- SAP ECC / GRC Security :- Updating SAP / IT Policy, Presentation and Preparing SOP, SAP GRC Access Control Functional on Risk Analysis Remediation, Compliant User Provisioning
Emergency Access Management, Enterprise Role Management,
Roles Responsibilities
- Business I.T. Collaboration GRC 5.3 RAR, SPM, CUP maintenance of connections and configuration of environment infrastructure security concepts in ECC BI, PI, GRC, EPM, HCM, FI CO, BW, Enterprise portal, SAP Master Data Governance MDG Material , User matrix and approval matrix as per the ITGC policy, GRC RAR creation and maintenance of risks Or SOD.
- Lead SAP Basis Team geographically and providing SAP Basis support to International, Domestic Juice projects of Glenmark Pharmaceutical Ltd covering 24x7 support.
- Maintained SAP R3/ ECC 6/BI 7x BIA/SRM/EP/GRC/PI/ BPM/MDM/EPM/APO/ Solution Manager 7.0 SAP servers. SAP ITS server installation and WebDynpro Java for developing portal applications, BPM M, Master Data Management architectures, business processes and data integration methodologies, SAP MDM Console, SAP Import Manager, SAP Syndicator SAP Data Modeler, Conversion, DM integration - workflow modeling/development.
- Quarterly sap quality system refreshes of R/3, ECC6,EP, GRC, SRM, BI,PI, BPC, EPM, APO and Live cache systems. Sandbox system refreshes, EPIUSE Refresh/Post Processing, SAP Content Server refresh Imaging solution i.e. HP EVA Management admin tool, IXOS, Filenet, Documentum, etc Performed batch job configuration, monitoring bug fixing.
- Provided downtime follow-ups between offshore/onsite for weekly maintenance activities.
- Provided BW Accelerator Monitoring/tuning and administration. Work closely with BI team for improving BI Load performance and follow-up on administration tasks.
- Provided SQL Oracle DB Administration, DB Size 5TB in 2 different landscape.
- Handling Outages/Maintenances for all Production servers and Production services.
- SAP daily monitoring for all servers and issue resolving, OSS management, Daily DR Server monitoring oracle archive log updating work processes, users, system logs, short dumps, locks, developer traces, system traces, disk space, etc. , Weekly EWA review and implementation.
- Spool Administration and configuration SAP printing subsystem for all SAP instances, STMS, Workload Analysis, Patch updating and support pack, service tool kernel upgrade.
- Migration from one environment to another, Performance Tuning, work closely with ABAP Team for resolving issue with performance impacting ABAP SQL's.
- Daily log checks and updates, spool maintenance, SAP front-end SAPGUI maintenance.
- Solution Manager configuration, MOPZ, EWA, CCMS, Basic Configuration, Solution Monitoring, DBACOCKPIT configuration and IT Performance DASHBOARD Setup.
- Used Solman Service disk on ticket queue management. Managing Releases. Presenting weekly ticket status to client, SAP Solution Manager ChaRM, EWE, maintaining SLA/Compliance.
Environment: Linux, Windows, Hp Blade server, Cisco, Oracle, SAP R/3, Hp Linux shell Scrip , IBM P/Power Machines I Series/400, Mobility SUP, Sun Java, Java/J2EE web applications C, C .
Senior SAP Basis Consultant
Confidential
- Mentored SAP team of 12 member. Involved in SAP implementation project like Landscape, Architect, Business Blue Print and Go-live- Support blueprint to sustain for multiple archive objects, backend with SQL Oracle DBA on SAP ECC 6.0 EHP6 modules- MM, FICO, SD, PP, QM, BI, XI PI, CIN, CRM, BPM, EPM, CTI, HR, HCM, MDG, MDM, BW, GRC, SOLMAN, SAP DR Server and SAP BI Pharmaceutical Generics , Authentication and single sign-on, end to end CE BPM 7.1/7.2/7.3/7.4, WebDynpro Java for developing portal applications, BPM MDM integration - workflow modeling/development.
- User Administration Security Admin : Client Administration for creating users, profile, role and authorization and authentication technologies on knowledge of risk assessment procedures on controls Application support and infrastructure security concepts in ECC BI, GRC, EP, EPM, PI, HCM, FI CO, BW, Enterprise portal, User matrix and approval matrix as the IT policy SAP Systems Audit Report, Solution manager SAP Router Configuration, SAP Market place monitoring and downloading etc.,. SAP Master Data Governance MDG Material , GRC RAR creation and maintenance of risks Or SOD.
- Transport Administration TMS Solved CMS issues with Configured Transport Management System and carry out daily transports from Development server to Quality assurance server and Production server in three systems landscape, TDMS working experience
- Daily tasks included checking backup logs, system logs, spool logs, application servers, work processes, failed updates, cancelled jobs, old locks, job logs, operating system at various level of the file system, and review work load and buffers statistics.
- Project Coordinator for the SAP implementation project responsible for preparing project status reports, managing small complex projects, and generating and maintaining documentation.
- Monitoring and Configuring the TMS, Solution Manager Server and Disaster Recovery DR SAP SERVER, Oracle / SQL Data card by arching as per the IT Policy.
- Monitoring and Support HP Unix version 11 OS with HP C 7000 Blade Chassis, HP Integrity Blade Server, Planned and led the major network infrastructure implementation to connect the 21 remote locations to the SAP data center.
- Liaised and negotiated with IT vendors for setup of the WAN, LAN, hardware data centre.
- Developed business case justifications and cost-benefit analysis for IT expenditures initiatives, Coordinated with Purchase and Warehouse business owners for the enhancement and new developments in the materials management system.
- Managed the Material Management System to support 10 end-users of purchase warehouse.
- Budgeted IT and SAP related requirements and controlled ongoing IT spend.
- Identified vendors, coordinated with them, prepared evaluation chart and price comparison charts to present to the management for approvals.
- SAP Hardware migration, hp Service Guard Virtual, VMware, Cluster .
- Actively attending all SAP Audit, PWC SPA ITGC, USFDA audit, SOP and Training.
- Monitoring Solution Manager configuration, Monitoring SAP DR connectivity, Monthly Backup Log, Monthly Client open activity log, monthly specimen signatures, monthly review on User Creation / User Exit, monthly review on authorization, monthly review on password reset, monthly monitor SAP ALL, HALF YEARLY T-code list review, quarterly restoration of backups, weekly offline Backup for TEST DEV.
Environment: Windows 2008 Server, CISCO, SQL Oracle 10.0.2g, Hp- UX, Redhat Linux 4.7 64 bit, SAP ECC 6.0, Sun Java, C, C .
Senior SAP Basis
Consultant
Confidential
- Confidential leading manufacturer of steel doors since 1995. special application doors.
- Involved in SAP implementation project like Landscape, Architect, Busniness Blue Print and Go-live- Support, SAP modules.
- Installed and configured LINUX RAID DELL Power Vault Servers.
- Installed MySAP ECC 6.0 Sr3 on Development and Quality servers.
- Upgraded Support Packages and Kernels SAP System Audit Report.
- Performed Backup Administration by using BRTools online and offline backups.
- Performed trouble shooting in SQL Oracle by using SQL, leasner.
- User Administration, Client Administration Transport Administration TMS .
Environment: CISCO, Oracle, Hp Linux shell Scrip , SAP R/3, Sun Java, C, C .
SAP Basis Consultant
Confidential
- Maintaining RFC destinations and Logical systems definition between R3 ERP and BW systems, Monitoring BW systems BW-DEV,BW-QTY,BWPRD .
- Performed system copy of ERP systems and BW Systems.
- Oracle Knowledge, Table Space maintenance, performance fine tuning, Oracle parameters fine tuning, Daily Space Management on Production Server.
- Creating Roles and Authorizations in ERP and BW systems.
- Upgraded the Support Packages and Kernels by using Download Manager and Solution Manager, Installed and configured LINUX RAID DELL Power Vault Servers.
- Installed MySAP ECC 6.0 Sr3 on Development and Quality servers.
- Upgraded Support Packages and Kernels.
- Performed Backup Administration by using BRTools online and offline backups.
- Performed Trouble shooting in oracle by using SQL, leasner.
- User Administration, Client Administration Transport Administration TMS .
- SAP System Audit Report and on issue base visit Data center.
Environment: CISCO, SQL Oracle DBA, Hp Linux shell Scrip , SAP R/3, Sun Java, C, C .
Confidential
Role: Networking Administrator Database, SAP Administrator.
- Assembling the GiPC Gastrointestinal Personal Computer Systems that's includes Digital Board that's connects with 8 channel Isolated Amplifier Design and Presser Pump with Catheter Sensors based on Biomedical analysis software for testing the patients.
- Checked the GiPC System before Delivering the System. It includes Testing and Verification of GiPC Software before it is given clearance, Acquisition of the Motility Signals, Conversion of the Motility Signals, analysis of the various Motility Signals, preparing patient database and reports, providing technical support to all customers residing in the South India Hospitals, Doctors through Telephone, Chat, E-mail or by sending Fax to Customer. If necessary I also visited the customers personally.
- Responsible for PCs and installing Windows NT Server and 98/NT Clients. Taking Backups in SQL And Oracle Database.