Sap Basis Administrator/database Administrator Resume
2.00/5 (Submit Your Rating)
SUMMARY
- My main area of experience has been as an SAP BASIS Administrator in technological forte SAP. My current role is a Technical Lead at Confidential BASIS Team of 17 members.
- Providing architectural direction to BW on HANA, SOLMAN 7.1 upgrade, Successfully worked on 2 full fledged SAP implementations across the globe in a span of 10 yrs
- Acted as a backup to Basis Team Lead for a team of 12 members.
- Experience in working on multiple SAP products including ECC, BW, SCM, CRM, Livecache, Optimizer, XI/PI, Portal, SLD, Solution Manager, CUA, GRC, MDM, HANA etc.
- Working knowledge of working in third - party products like Transport Express, ChaRM, Rev-Trac, Vertex, CPS, HPSM, Remedy, etc.
- Participated in Disaster Recovery solution design and carrying out full exercise twice
- Excellent skills in troubleshooting SAP R/3 system administration issues.
- Handled large databases running into many terabytes including carrying out backup restores and recovery on actual Production Systems multiple times. Experience in Root Cause Analysis
- Lot of experience in doing project planning for complex technical solutions
- A very good understanding of setting up the right technical operation procedures for SAP systems
- Carried out training in SAP Basis courses and awareness training for multiple employees
- Build the Basis expertise into existing teams with less or no experience in that area
AREAS OF EXPERTISE
- SAP System Installations & Configuration
- Landscape & Client Deployment Strategies
- SAP Transport Management System
- Support Package Stack application
- SAP Workload Analysis & System Sizing
- Database administration including backup & recovery procedures
- Performance Tuning both SAP & Database
- Middleware configuration of SAP systems including CRM, ECC, SCM, BW etc
- SAP System EHP Upgrade specialist
- OS & SAN Storage level expertise
- J2EE engine admin & Performance tuning
- DR Planning & Execution
- SAP Router Installation & Setup
- Portal & SLD setup
- BW Source system management & setup
- System refresh & Client management including copies, exports & deletes
- H/W & S/W migrations
- Third Party Integration
- Printers Management
TECHNICAL SKILLS
- Windows XP/2003
- RHEL5 x64
- Oracle
- MaxDB
- GRC 5.3
- SAP CRM 7.0
- SAP ERP 6.0 with EHP 6.0/Netweaver 7.31
- SAP BI 7.0
- SAP XI 7.3
- Solution Manager 7.0
- CHaRM
PROFESSIONAL EXPERIENCE
Confidential
SAP Basis Administrator/Database Administrator
Responsibilities:
- Performed system upgrades such as upgrade of ECC 6.0 system to EHP7/NW 7.4, EHP8/NW7.5 and BW upgrade from 7.0 EHP 2
- Perform SAP support package stack update, kernel upgrade, SAP system upgrade in all environments of the landscape as per business requirement.
- Perform the system copy from production to non-production environments using the Libelle system copy tool or using the Oracle RMAN as per the release calendar.
- Scheduling and administration of Background Jobs using SAP CPS(Redwood Cronacle) for production systems and in SAP directly for non-production systems.
- SAP HANA system Administration, HANA DB start, stop, change parameters, backup, restore, recovery, HANA Studio monitoring.
- SAP system client copy, export, import, open and close administration
- Oracle database installation, applying optaches, upgrades on single instance and on RAC and ASM environment
- Processing of users change requests, the SAP Transports in Transport Express after the approval of SQA team’s approval or using STMS for the SAP systems where Transport Express is not implemented.
- Attend weekly Integration meeting with different SAP functional teams and discuss the scope of SAP BASIS for the business customization and future plans on upgrades and implementations.
- SAP system client copy, export, import, open and close administration
- SAP Database backup, copy, restore and recovery using Oracle RMAN and BRTOOLS
- Installing new/ renewal of SSL certificates and applying licenses in ABAP and Java systems
- RFC Administration - Creating RFC’s and analyzing issues with RFC connections, monitoring IDOCS, TRFC's and QRFC's queues administration, partner profiles ports, BW source system connections, trusted/trusting connections.
- Batch input sessions(SM35) monitoring(delete, lock and process sessions)
- Opening and closing client in SAP systems for the changes to be made by SAP functional teams.
- SAP GUI, SNC, SSO implementation and troubleshooting connectivity issues.
- Providing SAP software change access key to the developers from functional teams for the customization as per business needs.
- SAP printer administration, spool configuration and troubleshooting the issues
- Delete the old and inactive batch input sessions twice a year in SAP ERP system which is connected to many legacy SAP or non-SAP systems to have the data at one place for analytics.
- Tablespace administration, handling additional space requirements by extending tablespaces, monitoring them and index rebuilding
- Dropping and rebuilding Index tablespace on BW databases as part of Database reorganization
- BIA(TREX) Administration, start, stop, index build and performance check.
- Opening OSS connections to SAP system, maintaining access data, saprouter setup and troubleshooting in case of issues
- Generating developer keys, object keys, OSS user administration in SMP
- Monitor the daily backup of all SAP production systems and perform the restore and recovery whenever required.
- Maintenance Activities for SAP systems like Starting and Stopping, Application of BASIS and Application SAP Patches
- SAP solution manager system support, connecting to satellite systems, installing diagnostic agents, setup monitoring alerts and generate EWA reports
- NetWeaver Administration (EP, BW/BI, PI) and monitoring SAP JAVA systems like SAP Enterprise portal and SAP GRC system.
- Application of patches through SDM & JSPM and deployment of par and ear files.
- Content repository and archiving administration using IXOS
- Performing system health checks, analyzing the dumps, system logs, trace files, memory buffers, workload monitor, file system storage, backups, archive logs and troubleshooting if there are any issues.
- Take appropriate action on the received monitoring alerts for the stable system run
- Providing 24/7 on-call SAP BASIS support on rotation.
- Transfer few and daily operational activities to Confidential and discuss on questions and further improvement in weekly call.
- Perform the monthly update to Vertex software upon receiving the ticket from SAP finance team, which is used for internal tax calculation
- Connect all SAP systems to SAP solution manager for better monitoring, configure alerts, diagnostics and to generate EWA reports.
- Perform the database upgrade, tune memory, run statistics jobs whenever required to boost the SAP system performance
- Disaster Recovery database setup for SAP systems, maintenance and monitoring
- Technology - Linux 5.5, 6.4, Windows 2008, ECC 6.0 EHP5, EHP7, EHP8, NW 7.42 Enterprise Portal 7.0, Oracle 11.2.0.3, Solution Manager 7.0, 7.1, SRM 5.0, BW 7.0 EHP2, SLD, GRC, HANA 1.0 SPS 7, SAP CPS 8.0, Transport Express 5.0 Libelle System Copy 2.9.2
Confidential
SAP ABAP Basis & J2EE Engine Administrator
Responsibilities:
- Perform SAP support package stack update, kernel upgrade, EHP7 upgrade in all environments of the landscape as per business requirement.
- Perform the system refresh from production to non-production environments using the Oracle restore and recovery procedures.
- Oracle database installation, applying optaches and Oracle upgrades from 10.2.0.4 to 11.2.0.3
- SAP system client copy, export, import, open and close administration
- Opening and closing SAP OSS connection which enables the SAP support team to connect to its customers SAP systems and provide solution for the bugs or standard issues which cannot be fixed by customers themselves
- SAP printer administration, spool configuration, printer drivers setup, new device types creation, print queue setup and monitoring at OS and troubleshooting the issues
- SAP Database backup, copy, restore and recovery using BRTOOLS
- MDM and Live cache administration and monitoring.
- Scheduling and administration of Background Jobs using SAP CPS(Redwood Cronacle v7.0) for production systems and in SAP directly for non-production systems.
- Tablespace administration, handling additional space requirements by extending tablespaces and monitoring them
- Dropping and rebuilding Index for tablespace on BW databases as part of Database reorganization
- TREX Administration, start, stop, index build and performance check.
- SAP solution manager system support, connecting to satellite systems, installing diagnostic agents, setup monitoring alerts
- Generate the monthly Early Watch Alerts(EWA) for all the production systems, analyze the report and suggest any recommendations to improve system performance
- SAP system upgrades like SAP portal implementation and upgrade from 7.01 to 7.30
- Setting up operation modes for application servers
- NetWeaver Administration (EP, BW/BI, PI) and monitoring of SAP JAVA systems like SAP Enterprise portal.
- Performing transports using Rev-Trac(Similar to ChaRM) implemented in Solution manager and from OS level for legacy systems.
- Opening OSS connections to SAP system, maintaining access data, saprouter setup and troubleshooting in case of issues
- Monitor the daily backup of all SAP production systems and perform the restore and recovery whenever required.
- Performing health check monitoring on all the production systems (currently 41) per checking critical transactions every 8 hours
- Maintenance Activities for SAP systems like Starting and Stopping, Application of BASIS and Application SAP Patches
- Readsoft Invoice scanning server administration, database administration, certificates exchange and transmission of date from external applications/solutions/parties to Readsoft.
- SAP solution manager system administration including monitoring setup, connecting satellite systems, generating EWA reports.
- Integrating the ECC 6.0, EP 7.0, BW 7.0 systems to talk to each other including setting up SSL, SSO, LDAP integration
- Carried out the source system setup between BW, ECC & CRM systems
- Finalizing the documentations including step by step instructions
- Technology - AIX, ECC 6.0 EHP4, Enterprise Portal 7.0, SAP CRM 7.0, 7.31, SAP BI 7.0, SAP XI 7.3, Solution Manager 7.0, SAP CPS (Redwood Cronacle 7.0), Rev-Trac(ChaRM), Oracle 10g, Oracle 11g, Readsoft
Confidential
SAP Basis and Security Administrator
Responsibilities:
- Led the effort to carry out release work activities including system refreshes, transports, landscape design & new system builds
- Providing SAP BASIS Support to the landscapes (ERP, HR, BW, CRM, SRM, LSO, PRM and Solution Manager)
- Handling Release Delivery in which major developments will Go-Live to production system (in five system landscape) along with parallel patching in systems.
- Patching includes, System refresh and post refresh activities, SAP Kernel Upgrade, applying Support Packages, SPDD/SPAU Procedures and EHP4 Upgrade
- Handling Maintenance Delivery in which major Developments move from project to Production landscape. Transport Buffer preparation according to the SAP IT landscape strategy. Transport lock and unlocking
- Creation of new RFC connections and maintenance of existing ones. Creation of Source System Connections in BW Systems for ECC, CRM, XI and SRM systems. Configuration of Trusted/Trusting relationship for an RFC Connection
- Transports- Creation of new requests, release and import of existing requests via STMS. Transport routes and auto import job monitoring. Troubleshooting imports and tp log monitoring.
- Performing the transports across landscapes using CHaRM.
- SAP VBM (Volume Business model) monitoring-Registration troubleshooting.
- SAP security notes implementation as per the recommendations
- Background jobs creation, scheduling, monitoring and troubleshooting.
- SAP web services configuration relevant to few functionalities and activating in SICF.
- Opening and closing client in SAP systems for the changes to be made by SAP functional teams.
- SAP system client copy, export, import, open and close administration
- Performing language translations to fill the language gas in production systems after every major transport releases.
- System health checks including, background Job Monitoring, SAP Lock Management, ABAP Dump Analysis, DB monitoring, System logs
- Monitoring and analyzing performance issues using Workload Monitor ST03N, monitor the system hourly using ST02, DB02 and ST06.
- Batch input sessions monitoring, troubleshooting and monthly deletions.
- Handling Authorization issues like creation of new users (Dialog, Emergency, Communication, Service), roles, profiles, Changes to existing roles/profiles, Suggesting roles/profiles to users based on SU53 Screenshot, Roles/profile assignment, generation of profiles, mass maintenance of users and roles/profiles, maintaining snc details and user master data
- Monthly security parameters check, adapt the recommendations and change in system profiles.
- SAP TMS setup and configuration of transport routes, layers, buffers, virtual systems and domains across the landscape and organization
- Providing SAP GRC Compliant User Provisioning Support
- Creating and Maintaining Workflow
- Request/reject profiles, Approve or reject Compliant User Provisioning (CUP) requests.
- Handling Cost Centre Manager Changes.
- Trouble shooting User Requests for authorizations
- Creating and Maintaining Functional Area
- Maintaining Business Processes/Sub Business Process
- Maintenance of profiles
- Approver Handling
- Mapping Dependent Roles