We provide IT Staff Augmentation Services!

Senior Oracle Dba/ Microsoft Sql Server Dba/mysql Dba Resume

0/5 (Submit Your Rating)

Monterey, CA

SUMMARY:

  • Proficient with Oracle RDBMS 8i, 9i,10G,11G
  • Proficient with Oracle Real Application Cluster (RAC) 10g/11g
  • Proficient with Oracle 10g/11gR2 Cluster - ware
  • Proficient with Oracle upgrades 9i to 10g/11g
  • Proficient with Oracle upgrades and migrations - from 32bit to 64bit platforms
  • Proficient in migrations of data/DDL/DML, Packages, PL/SQL Procedures, database objects from 8i/9i to 10g/11g
  • Proficient with Oracle Recovery Manager 9i,10g, 11g
  • Proficient with Oracle Patch Management (Oracle Enterprise Manager) and Grid Control
  • 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
  • Proficient with Oracle Streams and Replication 10g/11g
  • Proficient with Oracle Data Pump 11g
  • Proficient with Oracle Golden Gate V 11.2.1.0.2
  • Proficient with Oracle RDBMS Migrations from 8i to 9i/10G/11G
  • Expert in upgrades from Oracle Enterprise Manager 10g to OEM Grid 12c Cloud Control
  • Proficient with Oracle Real Application Testing (RAT), Sarbanes Oxley (SOX), RAD, SDLC
  • Expert Level with Oracle Sun Systems:
  • Oracle SPARC SuperCluster T4-4 Installation and configuration
  • Oracle Exadata and Oracle Exalogic X3-2
  • 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)
  • Proficient in 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)
  • Proficient in Oracle Applications upgrades and platform migrations
  • Proficient in Development using tools-Oracle Forms, Oracle Designer, Oracle Developer
  • Proficient with Oracle Applications Systems Administration and Security
  • 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
  • Proficient with Java/J2E/OC4J Web based applications
  • Proficiency and use of Change Management and Release Management
  • ChangeMan, Clear Case, PVCS Tracker
  • Proficient with Oracle DBVault
  • Proficient in 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

WORK EXPERIENCE:

Senior Oracle DBA/ Microsoft SQL Server DBA/MySQL DBA

Confidential

Responsibilities:

  • Provide Arrow ECS with SI and Professional Services for Oracle Support, to include various databases technologies such as Microsoft SQL Server, MySQL
  • Migrated MySQL 5.X (Multiple databases) to Oracle 11g using Oracle SQL Developer
  • Assist in Scoping calls with partners and customers/Pre-Sales Engineering
  • Performed Microsoft SQL Server Assessment on 4 production servers and 4 Quality Assurance Servers
  • Provided As Builts and recommendations
  • Setup Microsoft SQL Server Log Shipping for Disaster Recovery in Production environment
  • Provided end-user As builts and documentation
  • 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
  • Installed and configured Oracle 11gR2 RAC on 4 nodes in Production
  • Installed and configured Oracle Golden Gate for Replication of Production data to legacy data warehouses
  • Installed and configured Oracle 11gR2 RAC in QA on 4 nodes
  • Upgraded Oracle Enterprise Manager 10g to OEM Grid 12c Cloud Control - Configured and setup agents on remote hosts.

Senior Oracle DBA/ Microsoft SQL Server DBA

Confidential, Monterey, CA

Responsibilities:

  • Responsible for administering and supporting 15 production Oracle 11g instances in a 24x7 environment
  • Sun Solaris (OS)
  • 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 Exadataclusters 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:
  • Oracle Weblogic, Oracle Coherence, Tuxedo, Exalogic Control, Exalogic Hypervisor on Oracle Exabus
  • 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
  • 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:

  • Assessment for Business Intelligence, Reporting (Crystal Reports, BOBJ, Business Objects), ETL - Data Services/Data Integrator
  • Installed Orace 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
  • Configured Oracle Internet Directory and Single Sign-On
  • 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
  • Supported Oracle Golden Gate
  • Continued development and support of 22 Terabyte Data Warehouse (Oracle 11gR2)
  • 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
  • Partitioned large data warehouse tables for performance
  • 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, CA

Responsibilities:

  • 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
  • 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
  • Maintained and supported backup Oracle RAC 10g and 11g installations
  • 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 security
  • Partitioned tables
  • Migrated (2) Oracle 10g databases to Oracle 11gR2 (6 TB)
  • Installed, maintained and supported Oracle Dataguard Physical Standby installation (11g) in Maximum Availability Architecture (MAA)
  • Maintained and supported 2 Oracle logical standby database instances
  • Maintained 5 Weblogic 11g Servers
  • Configured Oracle Streams 11g (object and schema level)
  • 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
  • Created SSIS / SSAS packages and supported SSRS reporting services
  • 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
  • Supported 400 users
  • Cloning using Rapid Clone for Oracle 10gAS
  • 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
  • Configured and supported Oracle Enterprise Manager Grid Control in a multiple node environment.
  • Managed over 200 Oracle instances / many in a RAC environment (multiple nodes)

Senior Oracle DBA

Confidential, Palo Alto, CA

Responsibilities:

  • Installing Oracle Beehive to migrate production Oracle Collaboration Suite
  • 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
  • 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 IBM / 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
  • Installed in Dev, UAT, Production
  • Installed in 4 Node RAC (Oracle 10g) cluster in production
  • Supported development teams in support of applications modules (Oracle Financials and Human Resources)
  • 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
  • Used Sybase PowerDesigner for development and support of Data Warehouse
  • 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, Utah

Responsibilities:

  • Supported Oracle Applications 11.5.10.2 / 12.0.4 (DEV,UAT and Production)
  • 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
  • Installed and configured Oracle Discoverer (created various EUL’s for business areas)
  • Trained end users on Discoverer Plus and thick-client
  • Administered and supported Workflow processes for Field Services and iSupport.
  • 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)
  • 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, St Augustine, FL

Responsibilities:

  • Installed, configured and supported Apache, Tomcat / JBoss Web application servers in support of development, QA and production environments for St. Johns County School 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
  • 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:

  • 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
  • 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:

  • Performing role as Senior Oracle Applications DBA for Oracle Applications 11i (11.5.10) - Financials
  • Managing security for Oracle Applications (user accounts, responsibilities)
  • Developing custom reports using Oracle Discoverer (EUL) and Oracle Reports
  • Concurrent Managers (PCP), concurrent requests
  • 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:

  • 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
  • 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
  • Configure directory provisioning and synchronization processes from Oracle Internet Directory and Microsoft Active Directory

Senior Oracle DBA

Confidential, Fresno, CA

Responsibilities:

  • Implemented, and installed Oracle Collaboration Suite 9.0.4.2 (Windows 2003)-Integrating with Oracle Application Server 10g
  • Installed and configured Information Storage database (Oracle) version 9.2.0.5
  • 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·
  • Installed and configured Oracle 9iAS, Oracle Portal, Single Sign-On, Oracle Forms, and Oracle Reports (10gAS)
  • 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

Confidential, Houston, TX

Responsibilities:

  • Serving as the lead Oracle Application Server 10g implementations and architectural engineer.
  • Perform analysis on network architecture and propose recommendations in regards to Oracle Application Server 10g and Oracle Applications 11i
  • 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
  • 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.
  • Design custom Oracle Portal interface, to include page groups, pages and Portlets for access to existing 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
  • Design architecture for Directory Information Trees in relation to LDAP
  • Integrate LDAP compliant directories
  • Integrate Microsoft Active Directory with Oracle Internet Directory and Single Sign-On achieving Single Sign-On at the desktop level
  • Design and develop Identity Management (OID) infrastructure for support of user account creation and management.
  • 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 DBA

Confidential, Canoga Park, CA

Responsibilities:

  • Installed and configured Oracle Collaboration Suite with Oracle 9i.
  • Installed Oracle Collaboration Suite (Infrastructure, Middle-Tier and Storage 3 separate nodes) on Linux.
  • Installed and configured Oracle Portal, OC4J and use of portlets
  • 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!