We provide IT Staff Augmentation Services!

Senior Oracle Dba / Mysql Dba Resume

0/5 (Submit Your Rating)

Monterey, CA

SUMMARY:

  • Proficient with Oracle RDBMS 8i, 9i,10G,11G o Proficient with Oracle Real Application Cluster (RAC) 9i/10g/11g o Proficient with Oracle Document Capture o Oracle Change Data Capture (CDC) o Proficientwith Oracle 10g/11gR2 Cluster - ware o Proficientwith Oracle upgrades 9i to 10g/11g o Proficient with Oracle upgrades and migrations from 32bit to 64bit platforms o Proficientin migrations of data/DDL/DML, Packages, PL/SQL Procedures, database objects from 8i/9i to 10g/11g o Proficient with Oracle Recovery Manager 9i,10g, 11g o Proficientwith Oracle Patch Management (Oracle Enterprise Manager) and Grid Control o Proficient with Oracle RAC 10g /11g Implementations, support and resolution of performance issues o Proficient with Oracle Enterprise Manager (OEM) 10g / 11g Grid Control/OEM DB Control o
  • Proficient with Oracle Streams and Replication 10g/11g o Proficient with Oracle Data Pump 11g o Proficient with Oracle Golden Gate V 11.2.1.0.2 o Proficient with Oracle RDBMS Migrations from 8i to 9i/10G/11G SAP o AC010 - Financial /Management Accounting Reporting o AC040 - Cost Management and Controlling o AC225 - Accounts Receivable and Configuration o BC660 - Data Archiving o
  • AC250 - Configuration & Organization in Financial Accounting o CA705 - Basics of the Report Painter and Report Writer o CA710 - Advanced Functions of Report Writer o CA950 - Configuration of Taxes and Purchases o WC620 - Vertex / SAP Sales & Use Tax o L0930 - LIS - Logistics Information Systems SAP/ABAP o Webdynpro o Workflow configuration and Monitoring o Enhancement Spot,BADI,User-exit o
  • BAPI,RFC,functionmodule,BTE,OO o Smartform,Sapscript o Module Pool o BDC,LSMW o ALE/IDOCS o Reports:Classical,ALV,Interactive o Data Dictionary o OSS notes o Performance tuning and Code Review 5 year consultant and project lead with MBA, and 4.6b experience FI/CO, SD, TR consultant to 6 SAP R/3 implementations AP/AR/TR/CM/CR/GL/CCA/PCA/PA
  • Accounts Receivable FI-AR & Credit Management TR-CM Project manager on 4 implementations Lockbox TR-CM Configuration on 3 implementation Vertex Sales & Use Tax manager to 2 SAP R/3 implementations DART Data Retrieval Tool and Archive Project Manager Profitability Analysis consultant to 3 SAP R/3 implementations Project Manager on 5 SAP R/3 implementations Integration specialist with configuration experience in FI/CO TR & SD Report Specification experience 6 implementations Proficient with Oracle Real Application Testing (RAT), Sarbanes Oxley (SOX), RAD, SDLC Expert Level with Oracle Sun Systems: o Oracle SPARC SuperCluster T4-4 Installation and configuration o Oracle Exadata and Oracle Exalogic X3-2 o Oracle Database Appliance (ODA) Installation and Configuration Proficient developing and supporting Multi-Terabyte Data Warehouses (Oracle and Microsoft SQL Server) Use and proficient with Security Standards, IDM and Solix 10 Years Rapid SQL Development / Embarcadero
  • Technologies / LightSwitch Rapid Application Development (RAD) Proficientin Oracle Applications 11i/R12, installations, High Availability, Performance Tuning, Backup and Recovery, Maintenance, Security,
  • Identity Management (Oracle Internet Directory and Single Sign-on Enterprise Resource Planning (ERP)-Supply Chain Management (SCM),Customer Relationship Management, (CRM), Front Office, Back Office, Collaborative Commerce Proficient with Oracle Applications Enterprise Business Suite (Oracle Financials 11i / 12 (11.5.10.2 / version 12) GL(General Ledger.), AP (Accounts Pay.), AR (Accounts Rec.), CM (Cash Management, HR (Human Resources), Order Entry, Manufacturing - All Modules, BOM (Bill of Material), Asset Mgmt. and Procurement - All Modules, Purchasing, Order Fulfillment - All Modules, Technology -Workflow, Tutor, Business Intelligence) o Proficient in Oracle Applications upgrades and platform migrations o Proficient in Development using tools-Oracle Forms, Oracle Designer, Oracle Developer o Proficient with Oracle Applications Systems Administration and Security o Proficient supporting
  • Oracle Applications R&D teams in Oracle Applications module development and customizations Proficient with Oracle 9iAS, Oracle 10g Application Server, Apache, Tomcat, Weblogic and JBoss Web Application Servers (Installation, Support, application deployments, configuration and integration with Open Source systems o Proficient with Java/J2E/OC4J Web based applications Proficiency and use of Change
  • Management and Release Management o ChangeMan, Clear Case, PVCS Tracker Proficientwith Oracle DBVault Proficientin Business Continuity and GAP Process Management Proficient in design and installation of High-Availability storage, Clustering, Storage Area Networks (SAN), NAS, and RAID technology. Proficient in SQL, PL/SQL,SQL Loader, Export/Import, BCP, Extraction-Transformation and Loading, Schemas, ROLAP,MOLAP,HOLAP,OLAP,OLTP, Data Warehouses, Data Mining, Data-Marts, Decision Support Systems (MDSQL and Multidimensional databases) for Database Management System environments (Microsoft SQL Server, Oracle, Sybase). Proficient in project management, technical writing and end-user ; proficient with and follow Oracle A.I.M. (Applications Implementation Methodology) and standards Proficient knowledge of Agile Modeling, Agile Unified Process (AUP), Agile Data Method, DSDM, Essential Unified Process (EssUP), Extreme Programming (XP), Scrum and Open Unified Process
  • Proficient in Mid-Tier computer operating systems including RISC 6000 AIX, Windows NT/2000,UNIX,SUN SOLARIS,HP-UX, Redhat Linux, SuSe, VMS and Novell.Other o/s: Win 95,98,ME,XP Proficient in database physical / logical design and database administration, database disaster recovery, performance tuning, capacity planning and data migrations-tools: Legato Networker, HP Openview for Oracle OVO, Veritas, Netbackup, BMC SQL Backtrack, VCS Extensive UNIX Shell scripting (Korn, Bourne, C-Shell, Bash, Sed/Awk); Perl Scripting, Subversion, PVCS for source code management / Maven

TECHNICAL SKILLS:

Technology and Tools: Proficient with Oracle Real Application Cluster (RAC) 9i/10g/11g o Proficient with Oracle Document Capture o Oracle Change Data Capture (CDC) o Proficientwith Oracle 10g/11gR2 Cluster-ware o Proficientwith Oracle upgrades 9i to 10g/11g o Proficient with Oracle upgrades and migrations - from 32bit to 64bit platforms o Proficientin migrations of data/DDL/DML, Packages, PL/SQL Procedures, database objects from 8i/9i to 10g/11g o Proficient with Oracle Recovery Manager 9i,10g, 11g o Proficientwith Oracle Patch Management (Oracle Enterprise Manager) and Grid Control o Proficient with Oracle RAC 10g /11g Implementations, support and resolution of performance issues Proficient with Oracle Enterprise Manager (OEM) 10g / 11g - Grid Control/OEM DB Control o Proficient with Oracle Streams and Replication 10g/11g o Proficient with Oracle Data Pump 11g o Proficient with Oracle Golden Gate V 11.2.1.0.2 o Proficient with Oracle RDBMS Migrations from 8i to 9i/10G/11G, FI/CO, SD, TR consultant to 6 SAP R/3 implementations AP/AR/TR/CM/CR/GL/CCA/ PCA/PA Accounts Receivable FI-AR & Credit Management TR-CM Project manager on 4 implementations Lockbox TR-CM Configuration on 3 implementation Vertex Sales & Use Tax manager to 2 SAP R/3 implementations, Proficient with Oracle Real Application Testing (RAT), Sarbanes Oxley (SOX), RAD, SDLC, Proficient with Oracle Applications Enterprise Business Suite (Oracle Financials 11i / 12 (11.5.10.2 / version 12) - GL(General Ledger.), AP (Accounts Pay.), AR (Accounts Rec.), CM (Cash Management, HR (Human Resources), Order Entry, Manufacturing - All Modules, BOM (Bill of Material), Asset Mgmt. and Procurement - All Modules, Purchasing, Order Fulfillment - All Modules, Technology -Workflow, Tutor, Business Intelligence), Proficient in Mid-Tier computer operating systems including RISC 6000 AIX, Windows NT/2000,UNIX,SUN SOLARIS,HP-UX, Redhat Linux, SuSe, VMS and Novell.Other o/s: Win 95,98,ME,XP, Assessment for Business Intelligence, Reporting (Crystal Reports, BOBJ, Business Objects), ETL - Data Services/Data Integrator Installed Oracle 11gR2 in 4 Node RAC Cluster (development, UAT and production) Migrated Oracle 10gR1 database to Oracle 11gR2 Installed and configured Weblogic 10 - for 2200 users o Configured database and HA/RAC Migrated 2000 users from existing Oracle Application Server system.,Installed

WORK EXPERIENCE:

Senior Oracle DBA / MySQL DBA

Confidential

Responsibilities:

  • Net2Source Production, Staging, QA and Development Support for Confidential / Confidential application Oracle databases. o Support of Oracle RAC 11g, Oracle RAC 9i, Oracle RAC 10g o Data Migrations ADRCI/Logrotate for Oracle maintenance log files, listener, alert logs o Installation, configuration and support of Oracle Distributed Document Capture
  • Install database and configure / server configuration * Creation of application pools Configure capture security o Installation, configuration of Change Data Capture (CDC), Capturing change data Publish and subscribe Modes, Asynchronous AutoLog Publishing, Distributed HotLog Change Data Capture Maintaining and managing Installation, support of MySQL, and Microsoft SQL Server Linux/Unix shell scripting and automating of monitoring systems, disk usage, resources, ASM. Database upgrades, patches

Senior Oracle DBA/ SAP-AMS Consultant

Confidential

Responsibilities:

  • Confidential - Ongoing Provide Confidential with SI and Professional Services for Oracle Support, to include various databases technologies such as Microsoft SQL Server, MySQL Work with Sales in Scoping calls with partners/VARS and customers/Pre-Sales Engineering and develop Statements Of Work (SOW) Project Management/PMO and Technical Lead for all ongoing projects Pre-screening of technical resources and hiring for projects Method Care - Contract ( Confidential ) - 2 weeks Performed Microsoft SQL Server Assessment on 4 production servers and 4 Quality Assurance Servers Provided As Builts and recommendations Sugar Foods - Contract ( Confidential )- 3 weeks Setup Microsoft SQL Server Log Shipping for Disaster Recovery in Production environment Provided end-user As builts and documentation Ariad Pharmaceuticals - Contract ( Confidential )- 4 months Installed and configured NetApp SnapManager and Remote BLOB Storage for backup and recovery of Sharepoint and Microsoft SQL Server in QA/Test and Production Provided end-user As builts and documentation
  • Using LightSwitch / .Net for Rapid Application Development for front end Microsoft SQL Server / SQL / Procedures for Microsoft SharePoint 2013 Confidential - Contract ( Confidential ) - 5 months Senior SAP Systems Analyst Main duties were the implementation, customisation and support of SAP MSA/CRM Mobile Sales for 300+ users globally. Successfully completed a full project lifecycle from implementation through substantial customisation to a worldwide rollout with several upgrades thereafter. Excellent technical and functional understanding of SAP CRM/Mobile Sales. Precise document authoring skills for both technical and functional audiences. Heavily customised Mobile Sales to meet business requirements for Accounts, pricing and opportunity/ quotation management using Visual Basic with SAP's workbench (Mobile Application Studio) together with SQL Server 2008R2 for data querying and manipulation, analysis and administration.
  • Data restructuring using SAP's BDOC Modeller (SQL stored procedures) & Admin Console. Collaborated with users to ensure business requirements were being met and providing feedback to the functional team. Provided 2nd & 3rd line support for business critical bug fixing by way of re-coding with rapid distribution and deployment of resultant new program versions to users. Regular written and verbal communication including conference calls with users in all EMEA countries, Asia- Pacific and the US. Excellent working knowledge of SAP data structures with an emphasis on Opportunity/Quotation/Accounts (Customer Master)/Pricing/Materials. Conducted the remote and manual installation of SAP Mobile Sales to 150 international users in 28+ sales offices in 15+ countries across Europe, Middle East, Africa and Asia-Pacific. Prioritized the SCR's (Software Change Requests) for programming work.

Senior Oracle DBA/ Microsoft SQL Server DBA

Confidential - Monterey, CA

Responsibilities:

  • Contract) Responsible for administering and supporting 15 production Oracle 11g instances in a 24x7 environment o Sun Solaris (OS) o Supporting over 9000 users world - wide Upgraded Oracle 9.2.0.7 data warehouse to Oracle 11g (8 Terabytes) Focusing on Exadata administration. With nodes ranging from 2 to 8 and incorporating
  • Dataguarded Exadata clusters for maximum availability. Disaster recovery of Exadata Dataguard Physical Standby. Failover/Switchover/Loss of service/Rebuild/ Corruption/Loss of datafile testing. Proficient in Exadata configuration/maintenance/support/dataguard/backup/recovery/failover/switchover. Proficient with Rapid SQL (RAD) for SQL procedures / developing Rapid SQL for Microsoft SQL Server and Oracle Implemented/Installed and configured Oracle Exalogic Elastic Cloud: o Oracle Weblogic, Oracle Coherence, Tuxedo, Exalogic Control, Exalogic Hypervisor on Oracle Exabus o Oracle Linux Virtualized
  • Environment Supported Oracle Exadata/Exalogic on Oracle RAC 11g in a multi-node environment. Installed, configured and supported Oracle Database Appliance in a (4) node RAC configuration o Oracle Enterprise Linux Supported and configured Oracle Recovery Manager for production backups Supported Oracle 11g Development and QA environments Supported Unix Shell scripts / CRON jobs for nightly re-builds and data loads for Oracle production databases
  • Installed and configured Oracle Enterprise Manager 11g Grid Control for monitoring and DBMS jobs Configured Oracle Data Pump for unloading and loading data to Oracle data warehouse Configured parallel streams for performance Installed and configured IGNITE performance monitor for Oracle and Microsoft SQL Server production databases Supported Microsoft SQL Server 2008 in a production environment for the scheduling system (Blue Pumpkin) 600 users Developed PL/SQL procedures and packages / tuned existing PL/SQL Packages and procedures Used Oracle Partitioning for very large tables Supported Oracle Dataguard for off-site disaster recovery

Senior Oracle DBA/Weblogic/MySQL DBA

Confidential - Emeryville, CA

Responsibilities:

  • Contract) Assessment for Business Intelligence, Reporting (Crystal Reports, BOBJ, Business Objects), ETL - Data Services/Data Integrator Installed Oracle 11gR2 in 4 Node RAC Cluster (development, UAT and production) Migrated Oracle 10gR1 database to Oracle 11gR2 Installed and configured Weblogic 10 - for 2200 users Configured database and HA/RAC Migrated 2000 users from existing Oracle Application Server system. Configured Oracle logical/physical standby (Data Guard) - supported Setup RMAN Backups Administrated MySQL multi-master replication setup Audited and tuned production
  • MySQL servers Expertise in database migration from MyISAM format to Innodb storage engine to increase performance and betterment of integrity constraints. Managing/Troubleshooting MySQL 5.0.22 and 5.1.24 in production and developer environments on both Linux (5.0, 5.1) and Mac OS X. Performed installation, new databases design, configuration, backup, recovery, security, upgrade and schema changes, tuning and data integrity. Increased database performance by utilizing MySQL config. changes, multiple instances and by upgrading hardware. Effectively configured MySQL Replication as part of HA solution. Designed databases for referential integrity and involved in logical design plan. Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor.
  • Developed stored procedures, triggers in MySQL for lowering traffic between servers & clients. Managing database clustering on NDB technology. Performed MySQL Replication setup and administration on Master-Slave and Master-Master Installed, security, and maintenance of Linux based systems including Apache and MySQL 5.0.22 configuration. Installation, maintenance and troubleshooting of Windows operating systems. MySQL database administration on a large scale MySQL installation. Experience with MySQL on both Linux and Windows. Converted databases from MyISAM format to Innodb storage engine for databases that needed greater referential integrity. Managing database clustering on NDB technology. Automated Data Import Script using shell scripting, PHP, MySQL and regular expressions.
  • MySQL database backup and recovery strategies and Replication and synchronization. Created, tested, and maintained PHP scripts, MySQL programming, forms, reports, triggers and procedures for the Data Warehouse. Created database application using PHP and MySQL as the database to monitor customer profiles and complaints. Installed and configured Oracle Application Server 10g o Configured Oracle Internet Directory and Single Sign-On o Configured LDAP integration with Microsoft Active Directory Installed BOBJ/Crystal Reports Server/Admin Installed Business Objects Data Services/Data Integrator
  • Defined ETL mapping rules (source-to-target mappings) Installed and configured Oracle Golden Gate for replication of data to heterogeneous targets/databases o Supported Oracle Golden Gate development and support of 22 Terabyte Data Warehouse (Oracle 11gR2) o Setup/Configured Data Warehouse for use with 2 node Oracle RAC Cluster for high availability Used Oracle Warehouse Builder for build of Oracle
  • Data Warehouse o Partitioned large data warehouse tables for performance o Maintained Backups (RMAN) Maintained Oracle Data Pump for data loads Maintained security Monitored for issues and performance Maintained ETL processes into data warehouse Created Start Schema (data model) based on business rules, processes and ETL mappings Used Sybase Power Designer for data modeling Created business process documentation and systems process documentation

Senior Oracle DBA / Microsoft SQL Server DBA

Confidential

Responsibilities:

  • CA (Contract) Supported over 40 Oracle 10g / 11g Instances in development, QA and production environments in the Danger Network Operations Center for the Sidekick Smart Phone users (1 million users) on 24x7 schedule On - call for development/QA and production support Using Rapid SQL for fast development of SQL procedures / developed over 100 procedures o Tuned Production Oracle 11.2.0.4 installations / instances * Tuned Solaris (Unix) operating system (kernel) * Tuned Oracle instance(s) - adjust / modify Oracle instance parameter files * Log switching / archivelog tuning * Tuning of PL/SQL | T-SQL queries * Tablespace / table placement and partitioning; indexing * Used AWR, ADDM and OEM for tuning analysis * Statspack o Maintained and supported backup Oracle RAC 10g and 11g installations o Maintained Oracle Data Pump for loading large amounts of data to DR Oracle databases Maintained and supported Oracle 11gR2 Data Warehouse for the analysis of usage statistics for all Side Kick users * Maintained ETL processes for data warehouse * Supported backups (RMAN) * Monitored for performance * Maintained user securit
  • Partitioned tables Migrated (2) Oracle 10g databases to Oracle 11gR2 (6 TB) o Installed, maintained and supported Oracle Dataguard Physical Standby installation (11g) in Maximum Availability Architecture (MAA) o Maintained and supported 2 Oracle logical standby database instances o Maintained 5 Weblogic 11g Servers Configured Oracle Streams 11g (object and schema level) o Maintained Oracle RMAN installation / processes on daily basis Configured Clustering / High Availability with Microsoft SQL Server 2008 and Microsoft Clustering Services Installed Microsoft SQL Server 2008 in a multi-node (4) cluster for a collaborative custom web application o Created SSIS / SSAS packages and supported SSRS reporting services o Maintained and supported user security Created backup environment and disaster recovery procedures. Supported during build and through roll-out. Installed and supported
  • Oracle Applications R12 in a multi-node HA environment o Supported 400 users o Cloning using Rapid Clone for Oracle 10gAS o Backup and recovery RMAN High Availability / Redundancy and load balancing for Oracle 11g Dataguard (physical standby) Configured Oracle Internet Directory with Single Sign-on (Main Source of Truth - Microsoft Active Directory * Setup user security synchronization from Microsoft Active Directory to Oracle Internet Directory

Senior Oracle DBA

Confidential - Palo Alto, CA

Responsibilities:

  • Contract) Installing Oracle Beehive to migrate production Oracle Collaboration Suite o Installed and configured Oracle 11g in a 4 node RAC cluster / ASM for Oracle Beehive Oracle instance * Upgraded Oracle 10g to Oracle 11g * Upgraded Oracle 10g RAC cluster to Oracle 11g Created migration process / migrated Oracle Collaboration Suite 10.2.0.4 to Oracle Beehive - migrated mail accounts - all data, including mail attachments, calendar (Over 5 Terabytes) * Migrated 8000 Mail boxes/accounts and calendar to Oracle Beehive Installed and configured Oracle Application Server 10g with OID/SSO o Configured
  • OID / LDAP integration with Microsoft Active Directory Setup synchronization processes from Oracle Applications E-Business Suite and Microsoft Active Directory Supported Oracle Applications 11i E-Business Suite (patched applications modules, maintained security, maintained concurrent managers, cloned systems to QA and DEV, and supported backup and recovery processes). Installed Oracle RAC / ASM for Oracle Collaboration Suite database Installed and configured Oracle Enterprise Manager 11g Grid Control (installed agents on 32 servers monitoring Oracle instances / RAC instances) Installed and configured Oracle 10g RAC/ASM on Confidential / AIX Operating System Performing backup and recovery in non-RAC and RAC environments / procedures Performing database migrations from Oracle 10g to Oracle 11g from 32Bit to 64Bit platforms on RedHat Linux Supported 2 BEA Weblogic 8.1 Servers in support of Space Engineers
  • Install and support of RedHat Linux (10 servers) - VMware Install of operating system RPM's and configure of kernel parameters Installation / creation of system disk devices / SAN / HBA for RAC cluster Supported during build and through roll-out

Senior Oracle DBA/Oracle Applications DBA

Confidential - Houston, TX

Responsibilities:

  • Installed Oracle Applications E - Business Suite R12 o Installed in Dev, UAT, Production o Installed in 4 Node RAC (Oracle 10g) cluster in production o Supported development teams in support of applications modules (Oracle Financials and Human Resources) o Installed patches (adpatch / used ad tools to support installations)
  • Used Rapid Clone for cloning systems Supported 15 Terabyte Oracle Data Warehouse (Oracle 10g) Maintained Backups Supported End-Users o Used Sybase PowerDesigner for development and support of Data Warehouse o Used Oracle Warehouse Builder Responsible for supporting development teams in deployments of J2E/Java/JSP web based applications Used PVCS for code management and deployment / Maven for build's Installed and configured Oracle RAC 10g (10.2.0.3) in multiple environments (DEV, INT, UAT, PATCH, Pre- production and Production) - Some of the environments were segregated into zones.
  • Installed on SAN / RAW devices and ASM Installed Oracle RAC with Sun Solaris Cluster, Sun Sparc, Sun Solaris x86/64 (Sun UDLM) Installed and configured Oracle Streams for Oracle instances on RAC Cluster Installed and configured RMAN/Data pump - set up RMAN and Data pump backups Performed day-to-day support and administration Upgraded 4 Oracle 9.2.0.7 RDBMS DB'/Instances to 10.2.0.3 Installed Oracle 11G and configured for migrations Migrated 4 Oracle 10.2.0.3 to Oracle 11G production database instances on Sun Solaris Installed, configured and supported/administered Business Objects 6.5 for reporting and analytics of Oracle Financials and legacy financials databases

Senior Oracle Applications DBA

Confidential - Salt Lake City, UT

Responsibilities:

  • Contract) Supported Oracle Applications 11.5.10.2 / 12.0.4 (DEV, UAT and Production) o Applied patches for applications modules (Financials and Human Resources) Worked with development team to resolve bug issues Performed clones (RAPID CLONE) Worked with all aspects of Notification Mailer for Workflow Notifications o Installed and configured Oracle Discoverer (created various EUL's for business areas) Trained end users on Discoverer Plus and thick - client o Administered and supported Workflow processes for Field Services and iSupport. o Assisted end clients/customers with stuck workflows Configured web applications to use proper client side load balancing for JDBC thin client connection to RAC cluster
  • Configured Server Side Load balancing for RAC cluster for proper load and fail-over functionality Planning installation/configuration of Test and development environments (3 and 2 node RAC cluster) o Developing cloning process for production to test/dev (RAC to RAC w/ ASM and RAW devices) Configured OEM Grid Control 10g for monitoring of Oracle Applications DB installations Installed and configured Oracle RAC 10g in a 4 node cluster (New install) for Data Warehouse Oracle 10g RAC, ASMLib/ASM, RAW devices and Ext file system for installation of Clusterware, ASM, DBMS and OEM10g Agent Installed and configured OVO HP Openview for Oracle - for monitoring of Confidential 's production Oracle servers Coordinated efforts with development teams, UNIX System Administrators and various staff members to cut- over from present production system to the new 4 node Oracle 10g RAC cluster. This was performed over a 6 hour period. Developed PL/SQL procedure/package for encryption/decryption of customer credit card data

Senior Oracle Applications DBA

Confidential - Saint Augustine, FL

Responsibilities:

  • Confidential, Inc - Contract) Installed, configured and supported Apache, Tomcat / JBoss Web application servers in support of development, QA and production environments for Confidential district custom student web applications Install and maintain Oracle Application Server 10g for Student
  • System Day to day responsibilities in support of Oracle Financials and Human Resources, systems administration Performed upgrade/migration of Oracle 9i to 10g 32bit to 64Bit platform migration for the companies Oracle Applications 11i financial system o Oracle Applications performance tuning, patching, cloning, backup and disaster recovery, Oracle Applications printers, concurrent managers Working closely with development teams, finance and human resources Install and maintain Oracle Enterprise Manager 10g for support of all systems

Senior Oracle Applications DBA

Confidential - San Jose, CA

Responsibilities:

  • Buxton Consulting - Contract) Performing role as Oracle Applications DBA in charge of day-to-day support of Oracle Applications 11.5.10 infrastructure and middle-tier Responsible for cloning Oracle Applications environments (DEV, QA, STAGING and Production) - Rapid Clone o Upgraded Oracle Applications 11.5.8 to 11.5.10 (Financials and Human Resources) Performing role as Senior Oracle Applications DBA/Functional Systems Administrator for: Oracle Applications 11i (11.5.10) - Financials, Human Resources, Internet Expenses, Receivables, Payables Managing security for Oracle Applications (user accounts, responsibilities)
  • Performing Oracle Applications11i Clones from production to various environments Responsible for monitoring and performance tuning of JVMs running on Weblogic Application Servers and Oracle HTTP Applications servers running on Linux (RedHat/SuSe) Installed and configured Oracle Application Server 10g (SSO/OID) LDAP integration with Oracle Applications E-Business Suite and Microsoft Active Directory Installed and configured RMAN for backup and recovery Designing and implementing an architecture to monitor, maintain, check/deploy patches, schedule jobs/ processes (all environments)

Senior Oracle Applications DBA

Confidential - Huntersville, NC

Responsibilities:

  • Confidential - Contract) Performing role as Senior Oracle Applications DBA for Oracle Applications 11i (11.5.10) - Financials o Managing security for Oracle Applications (user accounts, responsibilities) Developing custom reports using Oracle Discoverer (EUL) and Oracle Reports o Concurrent Managers (PCP), concurrent requests o Setup and configuration of Oracle Applications (AP, AR, GL, iSupplier, iStore, Order Entry, iProcurement, iSupport - configuration and development, Field Service, Manufacturing, Cash Management, Advanced Pricing, Order Fulfillment, IPayment and Oracle Workflow, Forecast to Plan and Fast User Interface FUI) Providing 11.5.10 post upgrade and implementation support, resolving functional and technical issues reported by consultants and handover AIM methodology documents to clients.
  • Install and support Oracle Tutor Support of Oracle Application Server 10g Portal and Discoverer Supporting 78 distribution centers over the U.S. Responsible for tuning cluster JVM's running on Weblogic and Oracle HTTP application servers. Supporting Oracle RAC 9i on Oracle Applications 11i Supporting backup and recovery processes (RMAN) Maintaining Middle-Tier Applications Servers (Load balanced JVM's) Performing clones of Oracle Applications 11i instances across environments Monitoring systems performance and availability Performance tuning of system and applications components (Concurrent programs, request sets, PL/ SQL) Sarbanes Oxley (SOX) security auditing for Oracle Applications - Lumigent Vulnerability Manager and DB Audit

Senior Oracle Applications DBA

Confidential - Lombard, IL

Responsibilities:

  • Confidential - Contract) Serving as the lead Oracle Application Server 10g/Oracle Applications 11i (11.5.10) implementations and architectural engineer. Installed, configured and supported Apache, Tomcat / JBoss Web application servers in support of development, QA and production environments for DeVry's customer facing web applications Perform analysis on network architecture and propose recommendations in regards to Oracle Application Server 10g and Oracle Applications 11i o Install 3 instances of Oracle Application Server 10g (development, QA and pre-production)Integrate Oracle Application Server 10g with Oracle Applications 11i (11.5.10)
  • Design systems architecture for Oracle 10g Application Server, Oracle Portal, Oracle Internet Directory (OID) / LDAP, Oracle Single Sign-On (SSO) and integration with Oracle Applications 11i (11.5.10), and Oracle Applications Framework (OAF). Responsible for source code management using PVCS and automated deployments with Maven Supported 1 Oracle 10g Data Warehouse (10 Terabytes) Maintained Backups and supported end users Maintained user security Monitored and tuned for system performance Supported all ETL processes into data waehouse Upgrade Oracle Applications 11i (IGS - Oracle Student System to IGS.M) Install and configure Oracle HTMLDB Design and implement backup and recovery / disaster recovery procedures Integrate Microsoft Active Directory with Oracle Internet Directory and Single Sign-On

Senior Oracle DBA

Confidential - Fresno, CA

Responsibilities:

  • TUSC - Contract) Implemented, and installed Oracle Collaboration Suite 9.0.4.2 (Windows 2003)-Integrating with Oracle Application Server 10g o Installed and configured Information Storage database (Oracle) version 9.2.0.5 o Implemented and configured Unified Messaging (Email), Oracle Files (iFS), Oracle Calendar, Oracle Ultra Search, Oracle Wireless & Voice and Oracle Web Conferencing and Computer Telephony - Integrated with Cisco Call Manager and DPA 7610 o Installed and configured Oracle 9iAS, Oracle Portal, Single Sign-On, Oracle Forms, and Oracle Reports (10gAS) o Installed and configured Oracle Workflow-Configured business events and workflow processes Installed and configured Oracle Application Server 9i (OID / SSO) / LDAP Configured Oracle Enterprise Manager (OEM) Grid Control and installed remote agents Migrating Microsoft Exchange email accounts to Oracle Mail-Fully configured Oracle Mail, with Microsoft DNS

Senior Oracle Applications DBA/SAP Administrator

Confidential - Houston, TX

Responsibilities:

  • Serving as the lead Oracle Application Server 10g implementations and architectural engineer. o Perform analysis on network architecture and propose recommendations in regards to Oracle Application Server 10g and Oracle Applications 11i o Perform discovery on existing company intranet and internet applications and network in relation to how they will be integrated with Oracle Portal, Single Sign - On and Oracle Internet Directory o Design systems architecture for Oracle 10g Application Server, Oracle Portal, Oracle Internet Directory (OID) / LDAP, Oracle Access Manager, Oracle Single Sign-On (SSO) and integration with Oracle Applications 11i (11.5.9), and Oracle Applications Framework (OAF). Design and implement backup and recovery / disaster recovery procedures and processes for Oracle databases (repositories and metadata), ERP and CRM (20GB to 150GB) Integrate existing intranet and Internet applications with Oracle Application Server 10g, Portal, SSO, OID and Oracle Applications 11i. o Design custom Oracle Portal interface, to include page groups, pages and Portlets for access to existin ERP and CRM applications to include: Oracle Financials, Oracle Sales Online, iSupport, iProcurement, iReceivables, iPayment, Oracle Customer Online, Oracle Discoverer, Oracle Forms and Oracle Reports Design and implement database architecture (logical and physical model, table spaces and tables with referential integrity Develop custom packages, procedures, functions, and triggers Create Corporate
  • User Directory for Lightweight Directory Access Protocol (LDAP) server architecture o Design architecture for Directory Information Trees in relation to LDAP o Integrate LDAP compliant directories o Integrate Microsoft Active Directory with Oracle Internet Directory and Single Sign-On achieving Single Sign- On at the desktop level o Design and develop Identity Management (OID) infrastructure for support of user account creation and management. SAP Development / Administration Help completion of Sales Orders through Invoicing
  • Modification of Purchase Order entry to facilitate Accounts Payable Cycle Count of Inventory Procedures Profitability Analysis Reports changed depending on requirements Reconciliation of Accounts and addressing errors Provide support to Auditors with necessary downloads of information Aid in the standard use of SAP eliminate the need of Consultants Corrections to Profitability and Financial Reports - Form and selection criteria Create line layouts and display variants Customization of SAP Change Configuration for executing a Cycle count and frequency Modify Release strategy for Purchase Order Requests Revise and delete Terms of payment Risk Categories and Credit Rep. Groups Credit Limit Check on Sales Document Types Account Assignment Group and Define and Assign Account Keys Create Condition Type Tolerance Groups for GR/IR clearing ABC Inventory indicators changed to aid Cycle Counts
  • Creation of new Work Centers and Development of Materials Sample Documents Recurring Documents Account Assignment Models Reversing of FI Documents Customer and Vendor Master Record Entry Year-end Closing Procedures G/L Account and Cost Element Entry Input of Annual budget by Cost Center and Profit Center Maintenance to Credit Master Release of Orders from Credit Hold Teach how to set Machine Hours Rate and Mass Roll-Up Developed a procedure to enter a Request for Credit ERP Design Credit Management utilization of risk Categories Develop ABAP Query and Report Writer
  • Reports Install infrastructure and middle tier components of Oracle Application Server 10g Install and configure Oracle Workflow Configure directory provisioning synchronization processes from Oracle Applications 11i (FND) technology stack to Oracle Internet Directory Configure directory provisioning and synchronization processes from Oracle Internet Directory and Microsoft Active Directory Configure Oracle Applications 11i Framework and systems profiles for integration with Oracle Application Server 10g, Portal and Single Sign-On Setup / configure Secure Sockets Layer (SSL) using hardware accelerators for secure digital s, in use with Oracle Application Server 10g, OID and Oracle Applications 11i

Senior Oracle Applications DBA

Confidential - Tulsa, OK

Responsibilities:

  • Implemented, and installed Oracle Collaboration Suite 9.0.4, in a multi - node architecture working with a third party LDAP server (Infrastructure, Middle-Tier and Storage) Implemented and configured Unified Messaging (Email), Oracle Files (iFS), Oracle Calendar, Oracle Ultra Search, Oracle Wireless & Voice and Oracle Web Conferencing Installed and configured Oracle 9iAS, Oracle Portal, Single Sign-On, Oracle Forms, and Oracle Reports Configured and Synchronized the third party LDAP directory to work with Oracle Internet Directory (OID) Installed and configured Oracle Corporate Time and Oracle Outlook Connector clients for 1000 faculty members and students Performed a Meeting Maker (legacy calendar/scheduler) to Oracle Calendar migration Completed all necessary documentation and to immediate staff and technical engineers

Senior Oracle Applications DB A

Confidential - Canoga Park, CA

Responsibilities:

  • Installed and configured Oracle Collaboration Suite with Oracle 9i. o Installed Oracle Collaboration Suite (Infrastructure, Middle - Tier and Storage 3 separate nodes) on Linux. o Installed and configured Oracle Portal, OC4J and use of portlets o Installed and configured Oracle Collaboration Suite on Oracle 9iAS in a multi-node environment (Oracle Email, Oracle Calendar, Oracle Files, Oracle Voicemail & Fax Oracle Ultra Search, Oracle Wireless & Voice and Oracle Web Conferencing) Installed and configured Oracle 9i SSO/OID / LDAP Created LDAP users and configured OID Provisioned and configured users for Oracle Calendar Created process and migrated LDAP entries from Netscape Email Server to Oracle Email (Mail) using Oracle Collaboration Suite LD utilities. Created startup and shutdown scripts in Linux (shell scripts) to start up and shutdown all Oracle Collaboration Suite processes on all nodes.
  • Configured Oracle Files (iFS) on Oracle 9i with Collaboration Suite. Migrated files from Novell Netware Server to Oracle Files (iFS) Installed and configured Oracle FileSync (Oracle File Sync) for synchronization of desktop clients and Oracle Files (iFS) Created technical documentation Trained technical staff on use of all features of Oracle Collaboration Suite

We'd love your feedback!