We provide IT Staff Augmentation Services!

Etl Developer Resume Profile

5.00/5 (Submit Your Rating)

UsA

SUMMARY

  • Over 10 years experience in Rapid SQL development/Embarcadertechnologies/LightSwitch - Rapid Application Development RAD .
  • Expertise with Oracle RDBMS 8i/9i/10g/11g.
  • Expertise with Oracle Real Application Cluster RAC 9i/10g/11g.
  • Expertise with Oracle Data Migrations 9i t11g .
  • Expertise with Oracle Database Appliance X4-2, X3-2 installation, configuration and administration.
  • Expertise with Sun Oracle Java Systems Access Manager 7.X.
  • Installation and configuration.
  • Business processes and workflows.
  • Authentication and access management.
  • Expertise with Oracle Document Capture.
  • Oracle Change Data Capture CDC .
  • Expertise with Oracle 10g/11gR2 Cluster-ware.
  • Expertise with Oracle upgrades 9i t10g/11g.
  • Expertise in migrating Oracle database tMicrosoft SQL Server 11g tSQL Server 2008R2/2012 .
  • Expertise with Oracle upgrades and migrations from 32bit t64bit platforms.
  • Expertise in migrations of data/DDL/DML, Packages, PL/SQL Procedures, database objects from 8i/9i t10g/11g.
  • Expertise in migration of Oracle 10g/11g tMicrosoft SQL Server.
  • Expertise with Oracle Recovery Manager 9i/10g/11g.
  • Expertise with Oracle Patch Management Oracle Enterprise Manager and Grid Control.
  • Expertise with Oracle RAC 10g/11g implementations, support and resolution of performance issues.
  • Expertise with Oracle Enterprise Manager OEM 10g/11g - Grid Control/OEM DB Control.
  • Expertise with Oracle Streams and Replication 10g/11g.
  • Expertise with Oracle Data Pump 11g and Oracle Golden Gate 11.2.1.0.2.
  • Expertise with Oracle RDBMS migrations from 8i t9i/10g/11g.
  • Expertise with Oracle Real Application Testing RAT , Sarbanes Oxley SOX , RAD and SDLC.
  • Expertise with Oracle Sun Systems:
  • Oracle SPARC Super Cluster T4-4 installation and configuration.
  • Oracle Exadata and Oracle Exalogic X3-2.
  • Oracle Database Appliance ODA installation and configuration.
  • Expertise in developing and supporting Multi-Terabyte Data Warehouses Oracle and Microsoft SQL Server .
  • Expertise with ITIL concepts and processes.
  • Good experience in Oracle Enterprise Performance Management 11.1.2.3 - OFSAA.
  • Experienced in using Security Standards, IDM and Solix.
  • Expertise in Oracle Applications 11i/R12, installations, high availability, performance tuning, backup and recovery, maintenance, security and identity management Oracle Internet Directory and Single Sign-On .
  • Good experience in Enterprise Resource Planning ERP - Supply Chain Management SCM , Customer Relationship Management, CRM , front office, back office and collaborative commerce.
  • Expertise with Oracle Applications Enterprise Business Suite Oracle Financials 11i/12 11.5.10.2/ 12 - GL General Ledger , AP Accounts Pay , AR Accounts Receivable , CM Cash Management , HR Human Resources , Order Entry, Manufacturing - all modules, BOM Bill of Material , Asset Management and Procurement - all modules, Purchasing, Order Fulfillment - all modules, technology - Workflow, Tutor and Business Intelligence .
  • Expertise in Oracle Applications upgrades and platform migrations.
  • Proficient in development using tools - Oracle Forms, Oracle Designer and Oracle Developer.
  • Expertise with Oracle Applications systems administration and security.
  • Expertise in supporting Oracle Applications R D teams in Oracle Applications module development and customizations.
  • Oracle Utilities Customer Care and Billing 2.4.0.2 .
  • Oracle Utilities Application Framework.
  • Expertise 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 .
  • Expertise with Java/J2E/OC4J web based applications.
  • Expertise in using Change Management and Release Management.
  • Changeman, ClearCase and PVCS Tracker.
  • Expertise with Oracle DBVault.
  • Expertise in business continuity and GAP process management.
  • Expertise in design and installation of high-availability storage, clustering, Storage Area Networks SAN , NAS and RAID technology.
  • Expertise 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 and Sybase .
  • Expertise in project management, technical writing and end-user training.
  • Expertise with Oracle A.I.M. Applications Implementation Methodology and standards.
  • Good knowledge of Agile Modeling, Agile Unified Process AUP , Agile Data Method, DSDM, Essential Unified Process EssUP , Extreme Programming XP , Scrum and Open Unified Process.
  • Expertise 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 operating systems: Win 95/98/ME/XP.
  • Expertise in database physical/logical design and database administration, database disaster recovery, performance tuning, capacity planning and data migrations-tools: LegatNetworker, HP OpenView for Oracle OVO, Veritas, NetBackup, BMC SQL Backtrack and VCS.
  • Extensive Expertise in UNIX Shell scripting Korn, Bourne, C-Shell, Bash and Sed/Awk , Perl Scripting, Subversion, PVCS for source code management/Maven.

CERTIFICATIONS

Oracle 9i/10g/11g OCP - installations, upgrades, migrations, integration, high availability, performance tuning and backup/recovery.

EXPERIENCE

MediSpend MMIS /iSpace Inc. October 2014 - Present

Senior MySQL DBA/ETL Developer

Responsibilities:

  • Provided support of development, QA and Production MySQL Instances/Databases
  • Manage/Configure MySQL in Amazon Web Services/RDS Cloud
  • Responsible for design of database Data Model, Logical and Physical Design
  • Development of Data Model and ETL Design tasks in Agile/Scrum environment
  • Scope and complete daily/weekly Sprint tasks/Stories
  • Responsible for development of Clover ETL Job Flows and Graphs for load of external data sources and Customer data Medical/Pharmacy tMySQL databases/schemas and MongoDB Big Data Collections
  • Create JSON Blocks/Format for load of JSON data tMongoDB Collections
  • Responsible for Design and Architecture of ETL

Confidential

Senior Oracle DBA

Responsibilities:

  • Provided production, Quality Assurance UAT and development support for Oracle 10g/11g.
  • Supported Oracle 10g/11g for Lawson Financials.
  • Supported Oracle 10g/11g for Powerplant System for Water and Sewer .
  • Maintained and upgraded current Powerplant system and worked with vendor during upgrade.
  • Maintained security for Powerplant.
  • Cloned Oracle databases from production tdevelopment and test Expdp/Impdp and RMAN .
  • Developed disaster recovery procedures for Lawson Financials and Oracle 11g database.
  • Involved in 5 day DR exercise at IBM site in NY State.
  • Recovered Lawson Financials Database on DR IBM AIX Server.
  • Staff at DR location tested and confirmed Lawson Application/Oracle database.
  • Installed and configured Oracle Cloud Control 12c.
  • Configured user defined Metrics and Alerts email .
  • Configured job scheduling, asset and configuration management, change management, metric thresholds, provisioning and patch management.
  • Deployed Agents tover 100 Oracle and Microsoft SQL Server Instances.
  • Applied management packs.
  • Utilized ADDM, AWR and ASH for problem resolution and troubleshooting performance issues.
  • Trained Aqua DBA's on how tconfigure and maintain.
  • Configured and maintained Oracle RMAN Catalog for daily backups.
  • Developed AIX Shell Scripts for maintaining file system.
  • Developed Crystal Reports for Lawson Financials and Human Resources for budgets, purchase orders and work orders .
  • Deployed Crystal Reports tLawson Business Intelligence LBI Dashboard.
  • Oracle Enterprise Performance Management 11.1.2.3 - OFSAA.
  • Funds transfer pricing, pricing management, profitability analytics, balance sheet planning, DB administration, reporting, patching and upgrades.
  • Weekly staff meetings on daily projects.

Confidential

Senior Oracle DBA/MySQL DBA

Responsibilities:

  • Involved in production, staging, QA and development support for Kenexa/IBM application Oracle databases.
  • Supported Oracle RAC 11g, Oracle RAC 9i and Oracle RAC 10g.
  • Installed and configured Oracle Database Appliance X4-2 .
  • Used ILOM and OAKCLI, deployed on virtualized platform, using ODA BASE Template, Configured Oracle AutService Request, installed Oracle Grid binaries and Oracle Database, setup and configured Oracle RAC, shared repositories, configured Linux OS and applied Oracle Patches.
  • Used ODA for production web Oracle Applications.
  • Maintained ODA in stage and production.
  • Oracle data migrations 9i t11g .
  • Oracle archiving and Oracle partitioning.
  • ADRCI/Logrotate for Oracle maintenance log files, listener and alert logs.
  • Installed, configured and supported Oracle distributed document capture.
  • Installed database and configured server configuration.
  • Created application pools and configured capture security.
  • Installed and configured Sun Oracle Java Systems Access Manager 7.1.
  • Installed on Oracle Enterprise Linux with Application Server 9.1.
  • Installed Access Manager for distributed load balancing.
  • Configured Access Manager/authentication for SSO/LDAP.
  • Installed/configured data store.
  • Provided detailed installation document and configurations.
  • Performed health check after installation.
  • Installed and configured Change Data Capture CDC .
  • Captured change data and published and subscribed.
  • Modes, Asynchronous AutoLog Publishing and Distributed HotLog Change Data Capture.
  • Maintaining and managing.
  • Installed and supported MySQL 5.5.27/5.6.X.
  • Used MySQL Workbench for administration.
  • MySQL Enterprise Backup - Innodb/MyISAM backups of MySQL DB's.
  • MySQL Clustering and MySQL Replication.
  • Supported, administered and installed upgrades of MySQL on Linux/SE Linux.
  • Shell scripting/Linux for MySQL automated processes.
  • Involved in Linux/UNIX Shell scripting and automating of monitoring systems, disk usage, resources and ASM capacity planning and forecasting .
  • Used Oracle Enterprise Manager 12c monitoring of production, stage, QA and Development Oracle Database Instances.
  • Migrated Oracle 11g database 2 TB tMicrosoft SQL Server 2012.
  • Used Microsoft SSMA SQL Server Migration Assistant for Oracle 5.2.1259 Project Oracle tSQL .
  • Mapping of Oracle and SQL Server data types.
  • Converted 50 Oracle 11g Schemas tMicrosoft SQL Server 2012 Schemas.
  • Used Microsoft SSIS tcleanse/massage data from Oracle 11g tSQL Server 2012.
  • Loading Converted data from oracle 11g tMicrosoft SQL Server 2012.
  • Assessment reports.
  • Backup and recovery procedures/jobs.
  • Converted PL/SQL Procedures, Functions and Packages tSQL Server Stored Procedures.
  • Performed in DEV, TEST and production environments.
  • Involved in Oracle database upgrades and patches.
  • Involved in staff meetings, team meetings, technical documentation and training.

Confidential

Senior Oracle DBA/Microsoft SQL Server DBA

Confidential

Responsibilities:

  • Provided Arrow ECS with SI and professional services for Oracle Support tinclude various databases technologies such as Microsoft SQL Server and MySQL.
  • Worked with sales in scoping calls with partners/VARS and customers/pre-sales engineering and develop Statements of Work SOW .
  • Worked as a Project Management/PMand Technical Lead for all ongoing projects.
  • Involved in pre-screening of technical resources and hiring for projects.

Confidential

Responsibilities:

Performed Microsoft SQL Server Assessment on 4 production servers and 4 Quality Assurance Servers and provided as builts and recommendations.

Confidential

Responsibilities:

Setup Microsoft SQL Server Log Shipping for Disaster Recovery in production environment.

Provided end-user as builts and documentation.

Confidential

Responsibilities:

  • Installed and configured NetApp Snap Manager 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.
  • Used LightSwitch/.NET for Rapid Application Development for frontend Microsoft SQL Server, SQL and Procedures for Microsoft SharePoint 2013.

Confidential

Responsibilities:

  • Performed overall Health Check of FHLB's Sun Oracle Java Systems Access Manager 7.X installation.
  • Validated installation Linux .
  • Validated Web/Network Layer implementation.
  • Validated/verified security.
  • Validated User Directory Framework Active Directory/LDAP .
  • Validated Access Management/Authentication/Policy Agents.
  • Validated Identity Repository Framework.
  • Validated Data Store.
  • Provided health check tcustomer for enhancements and modifications.
  • Migrated Oracle 11g database 700 GB tMicrosoft SQL Server 2012.
  • Used Microsoft SSMA SQL Server Migration Assistant for Oracle 5.2.1259 .
  • Mapped Oracle and SQL Server data types.
  • Converted 15 Oracle Schemas tMicrosoft SQL Server Schemas.
  • Used Microsoft SSIS tcleanse data from Oracle tSQL Server 2012.
  • Loaded converted data from Oracle 11g tMicrosoft SQL Server 2012.
  • Created backup and recovery procedures for Microsoft SQL Server migrated schemas.
  • Converted PL/SQL Procedures tSQL Server Stored Procedures using SQL Developer.
  • Performed in Dev, test and production environments.

Confidential

Senior Oracle DBA/Microsoft SQL Server DBA

Responsibilities:

  • Administered and supported 15 production Oracle 11g instances in a 24/7 environment.
  • Sun Solaris OS .
  • Supported over 9000 users world-wide.
  • Upgraded Oracle 9.2.0.7 Data Warehouse tOracle 11g 8 Terabytes .
  • Focused on Exadata administration. With nodes ranging from 2 t8 and incorporating Dataguarded Exadata Clusters for maximum availability.
  • Involved in disaster recovery of Exadata Dataguard Physical Standby. Failover/Switchover/Loss of service/rebuild/corruption/loss of data files 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 and 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 tOracle 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 offsite disaster recovery.

Confidential

Senior Oracle DBA/WebLogic/MySQL DBA

Responsibilities:

  • Assessed Business Intelligence, Reporting Crystal Reports, BOBJ and Business Objects and ETL - Data Services/Data Integrator.
  • Installed Oracle 11gR2 in 4 Node RAC Cluster development, UAT and production .
  • Migrated Oracle 10gR1 database tOracle 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 and administered MySQL multi-master replication setup.
  • Audited and tuned production MySQL Servers.
  • Expertise in database migration from MyISAM format tInnodb storage engine tincrease performance and betterment of integrity constraints.
  • Manage/troubleshot 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.
  • Configured MySQL Replication as part of HA solution.
  • Designed databases for referential integrity and involved in logical design plan.
  • Involved in performance tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor.
  • Developed Stored Procedures and Triggers in MySQL for lowering traffic between servers and clients.
  • Managed database clustering on NDB technology.
  • Performed MySQL Replication setup and administration on Master-Slave and Master-Master.
  • Installed, security and maintained Linux based systems including Apache and MySQL 5.0.22 configuration.
  • Installed, maintained and troubleshot Windows operating systems.
  • Performed MySQL database administration on a large scale MySQL installation.
  • Experienced with MySQL on both Linux and Windows.
  • Converted databases from MyISAM format tInnodb storage engine for databases that needed greater referential integrity.
  • Managed database clustering on NDB technology.
  • Automated Data Import Script using shell scripting, PHP, MySQL and Regular Expressions.
  • Involved in MySQL database backup and recovery strategies and replication and synchronization.
  • Created, tested and maintained PHP scripts, MySQL programming, forms, reports, triggers and procedures for Data Warehouse.
  • Created database application using PHP and MySQL as database tmonitor 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 theterogeneous 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 and monitored for issues and performance.
  • Maintained ETL processes intData 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.
  • Installed and configured Oracle Database Appliance X4-2 .
  • Use of ILOM, OAKCLI, deployed on Virtualized Platform, Using ODA BASE Template.
  • Configured Oracle AutService Request and installed Oracle Grid binaries and Oracle database.
  • Setup and configured Oracle RAC, shared repositories, configured Linux OS and applied Oracle Patches.

Confidential

Senior Oracle DBA/Microsoft SQL Server DBA

Responsibilities:

  • Supported over 40 Oracle 10g/11g Instances in development, QA and production environments in Danger Network Operations Center for Sidekick Smart Phone users 1 million users on 24/7 schedule.
  • On-call for development/QA and production support.
  • Used 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 instances - adjust/modify Oracle instance parameter files.
  • Log switching/archivelog tuning.
  • Tuned PL/SQL and T-SQL Queries.
  • Tablespace/table placement and partitioning and indexing.
  • Used AWR, ADDM and OEM for tuning analysis.
  • Statspack.
  • Maintained and supported backup Oracle RAC 10g/11g installations.
  • Maintained Oracle Data Pump for loading large amounts of data tDR 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 and monitored performance.
  • Maintained user security and partitioned tables.
  • Migrated 2 Oracle 10g databases tOracle 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 and cloned 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 tOracle 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 .

Confidential

Senior Oracle DBA

Responsibilities:

  • Installed Oracle Beehive tmigrate production Oracle Collaboration Suite.
  • Installed and configured Oracle 11g in a 4 node RAC Cluster/ASM for Oracle Beehive Oracle instance.
  • Upgraded Oracle 10g tOracle 11g.
  • Upgraded Oracle 10g RAC Cluster tOracle 11g.
  • Created migration process/migrated Oracle Collaboration Suite 10.2.0.4 tOracle Beehive - migrated mail accounts - all data, including mail attachments and calendar Over 5 Terabytes .
  • Migrated 8000 Mail boxes/accounts and calendar tOracle 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 tQA 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.
  • Performed backup and recovery in non-RAC and RAC environments/procedures.
  • Performed database migrations from Oracle 10g tOracle 11g from 32Bit t64Bit platforms on Redhat Linux.
  • Supported 2 BEA WebLogic 8.1 Servers in support of Space Engineers.
  • Installed and supported Redhat Linux 10 servers - VMware.
  • Installed operating system RPM's and configured Kernel parameters.
  • Installed/created system disk devices/SAN/HBA for RAC Cluster.
  • Supported during build and through roll-out.

Confidential

Senior Oracle DBA/Oracle Applications DBA

Responsibilities:

  • Installed Oracle Applications E-Business Suite R12.
  • Installed in Dev, UAT and 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 tsupport installations .
  • Used Rapid Clone for cloning systems.
  • Supported 15 Terabyte Oracle Data Warehouse Oracle 10g .
  • Maintained backups and supported end-users.
  • Used Sybase Power Designer for development and support of Data Warehouse.
  • Used Oracle Warehouse Builder.
  • Supported development teams in deployments of J2E/Java/JSP web based applications.
  • Used PVCS for code management and deployment/Maven for builds.
  • 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 intzones.
  • Installed on SAN/RAW devices and ASM.
  • Installed Oracle RAC with Sun Solaris Cluster, Sun Sparc and Sun Solaris x86/64 Sun UDLM .
  • Installed and configured Oracle Streams for Oracle Instances on RAC Cluster.
  • Installed and configured RMAN/Data pump - setup RMAN and Data pump backups.
  • Performed day-to-day support and administration.
  • Upgraded 4 Oracle 9.2.0.7 RDBMS DB'/Instances t10.2.0.3.
  • Installed Oracle 11G and configured for migrations.
  • Migrated 4 Oracle 10.2.0.3 tOracle 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.

Confidential

Senior Oracle Applications DBA

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 tresolve 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 tuse proper client side load balancing for JDBC thin client connection tRAC Cluster.
  • Configured server side load balancing for RAC cluster for proper load and fail-over functionality.
  • Planned installation/configuration of test and development environments 3 and 2 node RAC Cluster .
  • Developed cloning process for production ttest/dev RAC tRAC 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 OVHP OpenView for Oracle for monitoring of US Concrete's production Oracle Servers.
  • Coordinated efforts with development teams, UNIX System Administrators and various staff members tcut-over from present production system tnew 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.

Confidential

Senior Oracle Applications DBA

Responsibilities:

Confidential

Senior Oracle Applications DBA

Responsibilities:

Confidential

Senior Oracle Applications DBA

Responsibilities:

Confidential

Senior Oracle Applications DBA

Responsibilities:

Confidential

Senior Oracle DBA

Responsibilities:

Confidential

Senior Oracle Applications DBA/SAP Administrator

Responsibilities:

Confidential

Senior Oracle Applications DBA

Responsibilities:

Confidential

Senior Oracle Applications DBA

Responsibilities:

Confidential

Senior Microsoft SQL Server DBA

Confidential

Senior MS SQL DBA/Senior Oracle Applications DBA

Confidential

Senior Database Administrator/MS SQL DBA

Confidential

Senior Database Administrator/MS SQL DBA

Confidential

Technical Support Officer/Senior DBA - Oracle/MS SQL

Confidential

Senior MS SQL DBA/ Senior Oracle Database Administrator

Confidential

Senior MS-SQL DBA/Oracle DBA

Confidential

Communications Maintenance Technician/Oracle DBA

We'd love your feedback!