PROFESSIONAL EXPERIENCE:

Confidential

SAP Netweaver Basis Admin

Responsibilities:

• Early watch reports, locating the critical issues and making necessary changes and applying support packages/stacks and add - ons
• Maintained all the system profiles in development and production systems
• Worked with ABAP developers on tuning recommendations and index design of tables
• Implementing, upgrading and extending existing SAP HR applications ECC 6.0
• Assisting clients in implementing HR payroll systems
• Delivering HR process and deliverables in SAP HR Payroll Module
• Recommended SQL configuration changes for present ECC 7.0 landscape and for new landscapes such as SRM and BW 3.5
• Performed standard Basis administration and monitoring tasks in an highly critical environment with 24/7 support
• Provide guidance and leadership in the areas of issue troubleshooting and resolutions, maintenance,
• SAP security technologies and system architecture / product roadmap design
• Develop baseline plan for as a knowledge base for future tuning of SQL and SAP
• Maintain multi-landscape environments through client copies, system refreshes, and transports
• Expert knowledge in performance monitoring/tuning and daily Basis technical support including troubleshooting
• Perform BI, BW, and ECC performance tuning of SQL 2005 and 2008 with Windows based systems
• Strong background assisting in architectural design, planning and providing SAP technical architecture and support training
• Advance planning of system using system growth statistic and developmental efforts
• Worked with DBA team on new index maintenance plan of 60,000 plus indexes to minimize downtime for Confidential worldwide offices
• Recommended database configurations to reduce data load times between SQL instances
• Index Analysis and Expensive Statement Analysis via SAP and SQL tools
• Spool administration such as configuring printers and trouble-shooting, spool request, deleting old spool jobs and working with TemSe objects
• Worked on new Implementation, upgrade & migration projects as team lead.
• Implementation of SRM 7.01, PI 7.11, MDM 7.0, EP 7.01 & BI 7.01 on the current ECC5 Landscape
• Installed and configured SRM 7.0, PI 7.1, EP 7.0, MDM 7.0 & BI 7.0 on SQL 2008/Win 2008
• Worked on Blueprinting, Sizing and Realization phases
• Applied EHP1 to Solution Manager 7 and upgraded to Solman 7.1.
• Strong practice of Database backup, Archiving, recovery process with DR drills
• Daily Ad hoc troubleshooting of DEV/QA/Production system
• Applied ABAP support packs using SPAM and installed/upgraded add-ons using SAINT
• SOX support for SQL and SAP landscape
• Moving transports between development quality and production
• Archiving project for DEV using SARA and SARI T-codes
• Recommended analysis for Zerto Virtual Replication for always-on data protection and recovery solution for virtualized SAP deployments along with SLA agreements for DR
• Migrated BW to Hana Database using DMO option in SUM Tool SAP HANA Monitoring and Troubleshooting
• Knowledge of BO reporting tools Analysis for Office for reporting, query and analysis purposes and integrating them with SAP HANA
• SAP HANA Administration including creation and management of schemas for different SAP systems, data model objects, and import/export content
• Administration and troubleshooting of SAP HANA database using SAP HANA studio and DBA Cockpit, Starting / Stopping of SAP HANA, Backup & Recovery

Confidential

Basis Admin

Responsibilities:

• Participate in the Project planning and delivery, production support, monitoring, SAP Software upgrades, support packs and performance tuning of SAP Environments, ensuring the efficient and secure operation of the SAP system
• Implement best practices guidance on all SAP Basis and Administration related task
• Maintain multi-landscape environments through client copies, system refreshes, and transports
• Provided comprehensive Basis support on SAP Windows and SQL Server platform
• Experience in SAP database administration activities such as monitoring, table space management, backup and recovery of Oracle database using SAPDBA and BR Tools
• Worked on Client Administration such as Client copy/export/import
• Management and resolution of SAP problem tickets

Confidential

SQL DBA

Responsibilities:

• SAP maintenance on SQL 2008 for Basis admin, SAP developers and end users
• SAP OSS note management to drive resolution
• Administration of system transports and change control
• Development and enforcement of process and procedure
• Works directly with 3rd party system integrator and application support team
• BASIS Support during project go-lives
• Siebel maintenance on SQL 2000 for Siebel admin, developers and end users
• Production DBA for Confidential environment for 35 SQL servers including QA and Dev
• Implementation of SQL 2005 standard and enterprise installations for new projects
• Implementation of SSRS sites for both dev and production
• Development and deployment of queries and maintenance for SSRS sites for reports in Helpdesk and finance
• Setup test environment for SQL 2000 to SQL 2005 migration and upgrade
• Developed disaster recovery options for SQL 2005 servers such as clustering and database mirroring and recovery procedures
• Developed in Share Point 2007 and deployed code for reporting purposes
• Implementation of event forwarding for management of multiple SQL servers of different versions
• Developed and migrated to SSIS jobs to new environments from SQL 2000 TO SQL 2005

Confidential

SQL / Oracle DBA

Responsibilities:

• Applied Confidential statements such as SHOWCONTIG, DBREINEX in regards to fragmentation
• Identified the variety of locking modes such as shared locks, exclusive locks, update locks, intent locks and special lock modes for transactions
• Established a linked server environment with remote sites
• Implemented and updated Erwin diagrams of databases for IT group
• Established DTS packages in regards to data transfers between SQL servers
• Implemented testing environment for SQL Server 2005 to test enhanced replication features
• Implemented testing environment for SQL Server 2005 to test performance with copy of LIVE database for performance issues with present connectivity
• Developed procedures for SQL Server Cluster environment in order to reduce downtime for over 3000 users
• Reviewed final code from development before deployment to LIVE environment on weekly basis
• Project lead on T-SQL code development for Stored Procedures that require code changes and testing
• Data-Warehousing maintenance with development team on DTS packages, table modifications and stored procedures
• Usage of Visual SourceSafe in regards to projects and code deployment between different staging platforms
• Problem solved issues that occurred in a 60 GB production database such page corruption and executed repairs that allowed minimal interference with 24/7 database for mortgage data
• Delivered timely reports to key users in regards to query requests such as latest closures on loans and loan process
• Continuous monitoring in data access and securing SQL Server due to sensitive personal data of clients Increased SQL Server database's availability by implementing MS log shipping
• Maintenance of Crystal Reports 11 Server for delivery of up to date data of projects for accounting group
• Used Windows 2003 Enterprise Edition AWE enabled
• Troubleshooting of SQL Server Failover using Cluster. log and sqlclstr.log
• Implementation of native tools for backing up complete cluster systems such as NetBackup, clusrest.exe and clustool.exe
• Worked with IT group of RBC in order to have SAN storage as backend
• Implementation of Cluster deployment by zoning to protect Cluster from interference
• Followed best practices in regards to facilities, power planning, system installation and configuration in order to minimize problems for RBC
• Responsible for 2 onsite Oracle databases v. 9i
• Migration and upgrade from Oracle 8i to Oracle 9i
• Monitoring of overall health of database via Server Manager in line mode and GUI tools
• Performance tuning of queries and applying solutions
• Space management of table spaces and extents
• Creation of new instances for test environment of production database
• Tuning of SGA in regards to data buffer cache, redo log buffer and other background processes
• Daily monitoring of trace files such as user dump and alert file

Confidential

SQL / Oracle DBA

Responsibilities:

• Responsible for 23 SQL Servers onsite and monitored 5 SQL Servers at remote sites that are critical to Ocean Energy as consultant
• Daily use of T- SQL scripts in regards to monitoring all processes of databases and user requests and implementation of triggers, stored procedures and other SQL tasks
• Developed backup strategy and procedures to reduce downtime
• Worked with development in regards to table and constraint creation and other tasks
• SQL Server upgrades from SQL 6.5 to 7.0 to 2000
• SQL scripting and tuning of scripts for better performance
• Setup of different SQL instances on different arrays of RAID
• Developed backup and restoration strategy for all databases
• Developed plan for consistent maintenance of system databases and users’ databases in regards to index and table maintenance and security
• Worked with remote sites such as Cairo, Lafayette and Colorado in regards to database replication
• Used established methods to troubleshoot poor performing queries and databases