We provide IT Staff Augmentation Services!

Senior Database Engineer, Sap Resume

4.00/5 (Submit Your Rating)

SUMMARY

  • Over twenty five years of experience as Senior Oracle DBA/Developer/Database Architect with proficiency in building, administration, development and implementation, supporting of software application using Oracle and MS SQL Servers and SAP HANA,SAP ASE using modern database technologies and hardware component, especially in memory and flash storage options and fastest network technologies to significantly improve performance of database systems and applications .
  • Experienced Network/System administrator for Windows NT/2000/UNIX/Linux and MS SQL 6.5/7/2000/2005/2008.
  • Experienced Basis Administrator of SAP R/3 and HP UNIX/NT for Oracle 8,9,10G/MS SQL Server.

TECHNICAL SKILLS

Hardware: IBM PC/AT compatibles, HP 9000/N4000, SUN E450/E4500, SUN V440, IBM S70, LAN, WAN, StoreEdge3500, Oracle M5000/M8000,T3/T4/T5,Exadata,Super Cluster

Operating Systems: UNIX SCO, HP - UNIX 11, SUN Solaris 2.6-2.8,2.9, Windows NT Workstation/Advanced Server 3.51/4/2000/2003 , MS-DOS, Windows 3.11/95/98/XP. Linux Red Hat AS/ES, Oracle Linux 4,5,6

Languages: SQL, PL/SQL, JAVA, Visual Basic, ABAP, HTML, XML, Perl. T-SQL.

RDBMS: Oracle 7.x-8i-9i, 10G,11G 12C, MS SQL 6.5-7/2000/2005/2008 , SAP HANA, Apache Hadoop

Internet: Oracle Web App. Server 3/4 and MS IIS 3,4,5 (ASP), MS Index Server 2,VB Script, Java Script, MS Frontpage 97/98, BackOffice 2.5/4.Oracle WebDB. MS Exchange .

Tools: Developer 2000, Jdeveloper 3, Power Objects 2.1, Delphi 3, Visual Basic 6.0, Jbuilder3.5, Visual Studio 6, SQL Navigator, Crystal Report, XML SPY, Instance Monitor, Oracle Enterprise Manager, Developer/Designer 2000, Erwin, Bpwin, ColdFusion, ServletExec.

Other Packages: OLAP (Oracle Express, MS SQL 7), SAP R/3, Siebel, Legato Networker 5/6/7, Veritas Net Backup DataCenter 4.5-5, RMAN. TOAD,SQL Navigator, Quest SpotLight for Oracle and MS SQL, Azure, Oracle Cloud, AWS, Google Cloud

PROFESSIONAL EXPERIENCE

Senior Database Engineer, SAP

Responsibilities:

Responsible for installation, design, administering, supporting, tuning, migration and troubleshooting the platform for Oracle 11G/12C and SAP HANA/Apache Hadoop CDH4/5 on SUSE/Red Hat Linux and HP hardware as Senior DBA, backup/restore procedures with RMAN, physical and logical standby databases with RMAN/Oracle Guard, installation, implementation and settings the Oracle 13C Cloud Control. Also involved in development and tuning using SQL, PL/SQL on Linux. Supporting 24x7 Oracle 11G and SAP HANA databases. Supporting and troubleshooting of the migration the Oracle databases to SAP HANA.

The architecture, design, installation and implementation Oracle 11g and 12C Cloud Grid Control in HA, 13c agents, plug-ins, setting and configuration for production and DEV/QA/DR environment.

ENVIRONMENT: SAP ASE 16, Oracle 11GR2/12C, RMAN, Azure, Cloud Control 13C, Golden Gate, Data Guard, RedHat, SUSE, NetApp/CDOT, VMAX. 3PAR, SAP HANA, Apache Hadoop CDH4/5, Azure, Google Cloud

Senior ORACLE DBA

Confidential

Responsibilities:

Responsible for installation, design, administering, supporting, tuning, migration and troubleshooting the platform for Oracle 9i/10G/11G/12C and SUSE/Red Hat Linux/AIX/Solaris and Sun/HP hardware as Senior Oracle DBA, backup/restore procedures with RMAN, physical and logical standby databases with RMAN/Oracle Guard, installation, implementation and settings the Oracle 11g/12c/13C Grid Control, RAC,ASM. Also involved in development and tuning using SQL, PL/SQL on AIX /Linux. Supporting 24x7 Oracle 9i/10G/11G databases. Supporting and troubleshooting of the migration the Oracle databases from 9i/10G to 11G.

The large installation/implementation RAC Oracle 11GR2/12C, Direct NFS, using SAN/ASM and NAS storage. As part of “tiger team” together with Oracle Advanced Support involved in troubleshooting and fixing several a long standing and hard to resolve problems with production environment. Involved in process of integration of Genentech and Roche IT systems including the large project with replacing unix/oracle user IDs.

The architecture, design, installation and implementation Oracle 11g and 12C Cloud Grid Control in HA setup OMS/RAC, 11g agents, MySQL/MS SQL, Exadata plug-ins, setting and configuration for production and DEV/QA/DR environment.

ENVIRONMENT: Oracle 9i/10G/11GR2/12cC, RAC,ASM, RMAN, Grid Control 11g, Cloud Control 12C/13CR2, Exadata V2/X4, Golden Gate, Data Guard, Linux OEL, RedHat, SUSE, AIX,HPUX, Solaris, NetApp/CDOT, VMAX. 3PAR

Database Architect

Confidential

Responsibilities:

Evaluation, design and presentations, adaptation with education the newest Oracle software, hardware, storage, network and flash storage technologies, evaluation, design and presentation for comparison and costs of Oracle Exadata and SuperCluster for usage in bank for large banking systems and Oracle VLDB using 12C Cloud Control and Private Cloud Architecture, DBaaS. Design and implementation, migration and troubleshooting of Oracle MMA architecture and HA solutions, RAC and Active Data Guard, Archiving, Purging and storage tiering, Information Lifecycle Management and replication solutions and configuration for large OLTP, DW and Reporting databases. Evaluation and comparison the replication solutions for bank usage.

Troubleshooting, tuning and recommendations for overall Oracle databases internals, hardware and vendor’s application and storage subsystems performance improvement and migrations/upgrading and patching. Provide the supporting documentations for all level of troubleshooting, tuning and implementations and migration to Solaris, Linux, Exadata/SuperCluster platforms and new technologies of various Oracle database and hardware technologies. Verification of existing documentation and procedures and advice for implementation Oracle technologies per Oracle MAA/HA and business requirements. Production databases/systems migration support and the hard to resolve case troubleshooting, identification and recommendation for fixing. Database hardware and storage platform capacity planning for large environment and reports creation using Grid/12C Cloud Control .Recommendation for proper 12C Cloud Control and plug-ins implementations.

Environment: DELL R720/820, Oracle M 5000/8000/9000 , Oracle T3/T4/T5, Solaris SPARC, Red Hat, OEL Linux, Oracle 10g/11R2/12C, 12C Cloud Control, Oracle OPS Center, Golden Gate Oracle Exadata, Super Cluster, Oracle ZFS Backup Appliance, Oracle backup appliance, DBLRA, Oracle ZFS appliance, Hitachi VSP storage.

Senior ORACLE DBA

Confidential

Responsibilities:

Responsible for installation, design, administering, supporting, tuning, migration and troubleshooting the platform for Oracle 9i/10G/11G and SUSE/Red Hat Linux/AIX/Solaris and Sun/HP hardware as Senior Oracle DBA, backup/restore procedures with RMAN, physical and logical standby databases with RMAN/Oracle Guard, installation, implementation and settings the Oracle 10g Grid Control, RAC,ASM. Also involved in development and tuning using SQL, PL/SQL on AIX /Linux. Supporting 24x7 Oracle 9i/10G/11G databases. Supporting and troubleshooting of the migration the Oracle databases from 9i/10G to 11G.

The large installation/implementation RAC Oracle 11GR2, Direct NFS, using SAN/ASM and NAS storage. As part of “tiger team” together with Oracle Advanced Support involved in troubleshooting and fixing several a long standing and hard to resolve problems with production environment. Involved in process of integration of Genentech and Roche IT systems including the large project with replacing unix/oracle user IDs.

The architecture, design, installation and implementation Oracle 11g and 12C Cloud Grid Control in HA setup with two OMS/RAC 11.2.0.2, 11g agents, MySQL/MS SQL, Exadata plug-ins, setting and configuration for production and DEV/QA/DR environment.

ENVIRONMENT: Oracle 9i/10G/11GR2, RAC,ASM, RMAN, Grid Control 11g/12c, Exadata, Golden Gate, Smart Cache, compression, Data Guard, Linux OEL, RedHat, SUSE, AIX,HPUX, Solaris, NetApp,XP12000/XP24000HP hardware.

Senior ORACLE DBA

Confidential

Responsibilities:

Responsible for redesign, administering, supporting, tuning, migration and troubleshooting the platform for Oracle 10G/11G and Red Hat Linux/HP hardware as Senior Oracle DBA, backup/restore procedures with RMAN, physical and logical standby databases with RMAN/Oracle Guard, installation, implementation and settings the Oracle Grid Control, RAC,ASM, redesign and rebuilding EMC storage configuration and RAC hardware/interconnects. Also involved in development and tuning using SQL, PL/SQL on Windows /Linux. Supporting 24x7 Oracle 10G/11G databases and Linux’s applications servers, background processing, external data feeds, web servers for development and production systems. The sizes of Oracle production database is 5TB. Heavily usage and support the Oracle Text functionality. Support and troubleshooting of the migration the all databases from 10G to 11G

ENVIRONMENT: Oracle 10G/11G, four/two nodes RAC,ASM, Grid Control, Data Guard, Linux, EMC, NetApp, DELL/HP hardware.

Senior ORACLE DBA

Confidential

Responsibilities:

Responsible for administering, supporting, tuning, migration and troubleshooting the Confidential & Confidential platform for Oracle8i,9i,10G and AIX/SUN Solaris/Hardware as Senior Oracle DBA, backup/restore procedures with SQL Backtrack /Tivoli/TDP/RMAN, physical and logical standby databases with RMAN/Oracle Guard, Oracle Enterprise Manager and Oracle Grid Control, RAC,ASM . Also involved in development and tuning using SQL, PL/SQL on Windows /SUN/AIX. Supporting 24x7 Oracle 9i/10G databases and Unix’s applications servers, background processing, external data feeds, web servers for development and production systems. The sizes of Oracle databases are from 100GB to 10TB. Installation, implementation and settings the Oracle Grid Control.

ENVIRONMENT: Oracle 8i/9i/10G/11G, RAC, ASM, Grid Control, Data Guard, SUN Solaris, Windows 2000/2003, AIX.

Senior ORACLE DBA

Confidential

Responsibilities:

San Francisco-based company designs and develops a powerful Web-based Research Platform delivered to financial professionals. The company's proprietary metric system delivers essential valuation and price performance information, reducing time and resources traditionally involved in analyzing and aggregating information on public companies and their competitors. The platform consists of front-end Web applications based on Java Servlets and Applets, Oracle database and backend processes that handle external data feeds and perform various calculations.

Responsible for administering, supporting and troubleshooting the Revere platform for Oracle 10G and SUN Solaris/Hardware as Senior Oracle DBA, backup/restore procedures with Legato Networker/Veritas NetBackup/RMAN, standby databases with RMAN/Oracle Guard, Oracle Enterprise Manager and Oracle Grid Control, RAC . Installation, implementation and settings the Oracle Grid Control. Also involved in development and tuning using SQL, PL/SQL on Windows /SUN. Supporting 24x7 Oracle 8i/10G and MS SQL Server databases and Unix’s applications servers, background processing, external data feeds, web servers for development and production systems. Managed and instructed the system support team. Responsible for administering the Siebel system and MS SQL Server 7/2000 and several production MS SQL/Web Servers for Confidential. Involved in migration a trading system from Confidential.

ENVIRONMENT: Oracle 8i/9i/10G, RAC, Linux, SUN 4500/450, V440/V220, SUN Solaris, Windows 2000/2003, MS SQL 7/2000.

SAP Basis Administrator and Oracle DBA, System Architect

Confidential

Responsibilities:

Installed, implemented, supported, and administrated Oracle 8 as Oracle DBA and R/3 SAP 4.0 Retail development using Designer/Developer 2000 and Access 97 on Windows NT/HP-UNIX. Developed applications to transfer information from legacy system to SAP. Designed cluster hardware and software layout for SAP Retail 4.0. Analyzed and determined appropriate software and hardware platform for SAP Retail 4.0.

Administered Windows NT 4.0 networks and BackOffice products. Responsible for planning, implementing, and maintaining an R/3 System infrastructure using the Workbench Organizer, the Customizing Organizer, and the transport system. Distributed changes in the system landscape by transport and client copy or client transport. Made modifications during R/3 System upgrades and import of support packages.

Responsible for R/3 user administration, including CCMS configuration and administration, background processing, spool/output management, workload & performance monitoring and archiving. Supported databases using R/3 administration tools, sapdba, and BR* tools. Responsible for sizing/growth management, backup, recovery, and (alert and performance) monitoring. Responsible for network design, security, sizing and scalability, and interfaces. Installed SAPLOGON and SAPGUI. Used ASAP Roadmap methodology for R/3 implementation, ASAP accelerators. Migrating data from previous trading system to Oracle 8/MS SQL 7.

ENVIRONMENT: Oracle 8, HP UNIX 11, HP 9000, Developer 2000 on Windows 95/NT 4.0 and Intranet MS ISS, MS Office 95/97, BackOffice 2.5, SAP R/3 Retail for HP UNIX and Windows NT 4.0 .

SAP Basis Administrator and Oracle DBA, System Architect

Confidential

Responsibilities:

Responsible for supporting, administering, implementing and troubleshooting Oracle 8 as Oracle DBA and R/3 SAP 4.0 and several other applications and servers developed using Designer/Developer 2000 and Access 97 on Windows 95/NT/HP-UNIX. Responsible for planning, implementing, and maintaining an R/3 System infrastructure. Supported customizing and development project by software logistics, concepts and tools using the Workbench Organizer, the Customizing Organizer, and the transport system. Distributed changes in the system landscape by transport and client copy or client transport. Made modifications during R/3 System upgrades and import of support packages. Responsible for R/3 user administration, including CCMS configuration and administration, background processing, spool/output management, workload & performance monitoring and archiving. Supported databases using R/3 administration tools, sapdba, and BR* tools. Responsible for sizing/growth management, backup, recovery, and (alert and performance) monitoring. Responsible for network design, security, sizing and scalability, and interfaces. Installed SAPLOGON and SAPGUI. Used ASAP Roadmap methodology for R/3 implementation, ASAP accelerators, Question & Answer database (Q&Adb), Issues database .

ENVIRONMENT: Oracle 8, HP UNIX, HP 9000, Compaq Servers, Developer 2000 on Windows 95/NT 4.0 and Intranet MS ISS, MS Office 95/97, BackOffice 2.5, SAP R/3 for HP UNIX and Windows NT 4.0 .

Senior Software Engineer/Sr Oracle DBA

Confidential

Responsibilities:

Administered and supported the banking systems for Oracle 7/8 and Oracle databases as DBA. Developed using Designer/Developer 2000 on Windows 95/NT and Intranet cite (MS ISS and Oracle Web Server 3). Extensive used of MS Office 97, BackOffice 2.5, ODBC, JDBC. Developed bank reporting applications using Oracle OLE, PL/SQL and Access 97. Created new reports and modules. Supported and improved banking system using Oracle Forms and Oracle Reports. Administered Windows NT 4.0 networks and BackOffice products.

Responsible for backup, recovery, monitoring and performance of Oracle databases. Designed hardware and software layouts for new banking system. Installed and implemented new banking system and developed procedures for transferring the information from the legacy system to the new system. Analyzed and determined appropriate software and hardware platform for SAP Retail 4.0

ENVIRONMENT: Oracle 7, SCO UNIX, Oracle Forms 3 and Reports, Developer 2000 on Windows 95/NT 4.0 and Intranet MS ISS, MS Office 95/97, BackOffice 2.5 .

VP of IT department

Confidential

Responsibilities:

Involved in the design and development of the Trade Management System. This system automated all operations within wholesale trading company. Designed, purchased, installed, configured hardware platform and administered Windows NT, BackOffice, ISS and Oracle 7/8 as DBA for Windows NT. Responsible for network, system and applications development and principal design for the main office and several branches. Created several applications using Access 2/7 and Oracle Forms/Oracle 7. Administered Windows NT 4.0 networks and BackOffice/MS SQL 6 products at main office and branches. Created distribution applications for company workflow. Managed a group of analysts and programmers.

ENVIRONMENT: Oracle 7.X-8 UNIX SCO using Designer/Developer 2000 on Windows 95/NT and Intranet (MS ISS and Oracle Web Server), MS Office 95/97, BackOffice 2/2.5.

VP of IT department

Confidential

Responsibilities:

Involved in the design and development of Joint-Stock Management System which automated various operations in a Confidential . Managed a group of engineers and programmers. Responsible for system and applications development and design, principal design and system support 24x7. Administered the UNIX SCO NFS networks and Oracle 6/7. Designed, installed, configured hardware platform and administered Oracle 6/7 as Oracle DBA.

ENVIRONMENT: DOS, Windows 3.11,WFW 3.11, UNIX SCO, NFS, Oracle 6/7.

We'd love your feedback!