We provide IT Staff Augmentation Services!

Principle Cloud Architect & Solution Designer Resume

2.00/5 (Submit Your Rating)

San Diego, CA

PROFESSIONAL SUMMARY:

  • Over 30 years of technical and management experience as a thought leader and principal consultant covering a broad scope of technologies and services: Industries include Manufacturing, Pharmaceutical, Technology, Consulting, and Government (Defense, DOD and DHS), Healthcare & Insurance. 25 years with Senior Oracle, Sybase, SQL Server, DB2 EEE, SAP, PeopleSoft on Unix and Windows Servers as a manager, DBA and Data Systems Architect.
  • Principal Architect & Engineer with Data Warehouse, Oracle EDI, BizManger, BizLink Consulting experience.
  • Act as principle contributor to Enterprise Security designing security methods and procedures, have background in global IS infrastructure, data center builds, Data Warehouses, Operational Data Stores and Data Marts, strong track record in delivering enterprise - level technical projects.
  • Project Management expertise, Experienced with implementing Oracle Projects Costing & Billing & integration with Oracle Suite of Modules.
  • Expert level Architect and Administrator with Oracle WebCenter & WebCenter Services.
  • Lead Developer and Administrator with Oracle Universal Content Management and BPEL Process Manager using Oracle database, MS SQL Server or IBM DB2.
  • Knowledgeable with implementation and customization of Social Networking Services, Shared Services & Shared Services
  • Proven track record implementing client server technology and sound IT infrastructure notably the selection of hardware, software and personnel best suited to building strong and profitable IS departments. Experience in pharmaceutical research industry and GLP/Part 11/SOP compliance.
  • Design B2B and B2C sites as senior Architect with Oracle and other J2EE frameworks and tools resulting in sound IT investments saving dollars and making greater profits possible.
  • Design, build and deploy web applications & SOA compliant web service buses with J2EE/JEE and .Net.
  • A successful executive, who has run his own consulting firm managing multiple projects and consultants for 20 years, Peter possesses the keen ability to visualize, capture in documentation and expertly communicate requirements with management, technical resources and identify for other consultants the necessary work to ensure timely completion of projects. A principle contributor to Enterprise Security designing security methods and procedures including but not limited to Oracle R12 Suite, Microsoft Suite and many other highly secure environments using WS-Federation, Saml, Saml 2, oAuth, ADFS, Ping Identity, Oracle OIM.
  • Installation and deployment of WebCenter Suite & Services with Oracle, SqlServer and DB2.
  • Design and build SOA compliant services, applications and UI with JDeveloper.
  • Administration and management of Oracle WebCenter Collaboration and Commerce systems.
  • Created ADF and non ADF applications which included taskflows and services to support UI.
  • Configured WebCenter Spaces and custom WebCenter applications for OAM 10.1.4.3 single sign-on authentication. Setup & Configured Access Server, WebGate & Identity Assertion Provider (IAP)
  • AutoAccounting: Generation of GL Accounts according to rules; Data Captured in the Project & Rules
  • Indirect, Capital and Contract Project Types
  • Capture, Collect and Manage All Costs
  • Import Costs from other Oracle Modules e.g. Oracle Payables.
  • Adjust Costs & update Oracle subledgers with adjustments
  • Integration with entire suite of Oracle modules
  • Experience with Account Generator building the accounts & validation
  • Functional expert with Transfer Costs to GL, Budgetary Control, Create Asset using GL and FA
  • Project Costing - Online Inquiries, Project Costing - Reports
  • Familiar with MOAC Enabled, Integration with Subledger Accounting & Subcontractor Payment Management
  • EDI, BizManager & BizLink expert
  • Profiling, Audit and Dashboards
  • Parsing and Standardization
  • Match and Merge
  • Case Management
  • Address Verification
  • Product Data Scrubbing
  • Architecting, planning, designing, developing, deploying and supporting RAC/ASM environment
  • Installing & configuring Oracle clusterware & Database Software (Troubleshooting using cluvfy & handling common issues that arise during integration of the whole - bugs, network issues, configuration files issues, OCR issue, deinstallation & cleanup of clusterware)
  • Testing and benchmarked the application prior to going into production to determine its effects on GES and GCS with special focus on load testing for interconnect traffic.
  • Worked with customer for different RAC related issue: hangcheck timer, split brain, RAC recovery, ASM, OCR corruptions, Voting disk loss & so on
  • Troubleshoot performance issues for the RAC instances (GC events)
  • Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle clusterware) & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files. Also used the Merge backup for backing terabyte databases. Issues with block change tracking & also flash recovery area.
  • Resolved/Diagnose Node Eviction.
  • Upgrade of 10g R2 RAC to 12c
  • Add or Remove Node from RAC.
  • Oracle BPEL Process Manager 10.1.3.1
  • Oracle JDeveloper 10.1.3.3
  • Oracle B2B Integration Server
  • EDIFECS - SpecBuilder
  • Oracle Apps Adapter
  • Oracle BPEL PM 10.1.3.1
  • Oracle Apps Adapter
  • Compatible Connectivity Tools (GSX BizManager Suite)
  • Oracle E-Business Suite 11.5.10
  • FTP through GXS/VAN
  • Over 15 years of experience in as an Oracle DBA (11g/10g/9i/8i/8.0.x/7.x) in Production and Development environment.
  • Worked in 24x7 production environment and provided on-call and day-to-day support.
  • Datacenter Migration between NewYork to Manroe for All oracle databases for Barnes & Noble.
  • Datacenter Migration between Denver to boulder for all oracle databases for ABG (Avis Budget Group).
  • Migrated Non-ASM Single Instance to ASM RAC Instance.
  • Used BCV split/Data Guard technology to migrate over 13 TB Database.
  • Supporting Data Warehouse Database i.e. over 30 TB in size.
  • Manage RAC environment for Day to Day Database administrator, Performance Tuning.
  • Migrate over 3 TB data from Across the Platform ( From Solaris to AIX)
  • Strong trouble shooting, problem solving, analytical and design skills.
  • Expertise in Oracle 8i database replication, Expertise in Oracle 11g/10g/9i/8i Data Guard and standby databases, Snapshot maintenance and creation
  • Expertise in Oracle Enterprise Manager (OEM), TOAD, ERwin
  • Experience in Logical and Physical Design of Databases for OLTP and Data Warehouse.
  • Expertise in handling Very Large Database (VLDB) and OLTP environment.
  • Experience in Migration of Oracle 7.x to Oracle 8.x to Oracle 8i to Oracle 9i
  • Expertise in Performance tuning the production database towards optimal performance based on the changes in the database storage structures due to application change requirements. Monitoring and optimizing the performance of the Database through Database Tuning - Tuning Applications, Tuning Memory, Tuning Disk Usage, Tuning OS
  • Experience in Oracle 9i/8i/8.x/7x - Installation, Migration and implemented new features.
  • Experience in capacity planning, space management, database upgrades/migration
  • Experience in working with RAID environment.
  • Experience in clustered databases using AIX HACMP technology and Veritas Cluster on Solaris 8.
  • Expert DBA including planning/implementing backup/recovery strategies using RMAN or scheduled to execute PL/SQL stored procedures designed for the purpose.
  • Expertise in installation and configuration of Oracle and large databases on Unix Operating System.
  • Oracle Certified Professional (OCP) for DBA
  • Database population using SQL*Loader, Bulk Loading Expert
  • Creating and maintaining logins, synonyms and access privileges using roles, controlling access to the database using operating system and Oracle security features.
  • Installation, Disk partition, Unix File Systems, Auto mounting, Patch/ package installations, file system backups and administration. HPUX, SUN OS, AIX, Red Hat Linux
  • Experienced Oracle Architect/DBA with 9i, 10g, 11g R2 RAC, Data Guard, and Physical standby Databases, BI/ Data Warehouse and Oracle Applications including HR and Payroll.
  • Provide 24x7 support for Oracle production environments.
  • Expert PL/SQL developer. Expert with Oracle SQL Procedures, Triggers, Libraries.
  • Implemented Oracle Projects Costing & Billing & integrated with Oracle Suite of Modules.
  • Security Expert with Oracle Access Manager providing security integration with multiple applications. Expert with Role Management technologies. Knowledge of BitKOO, Oracle Entitlements Server, Oracle Access, CA Siteminder.
  • Works as a data taxonomy manager and consolidate data taxonomy requirements.
  • Creates taxonomies and enterprise data models RDBMS tools and create technical documentation.
  • Develops project plans, delegate responsibility and thought leader with skills in distributed systems.
  • Works as a data center DBA manager and consolidate data from many operations into a single homogenous data pool.
  • Routinely create taxonomies and enterprise data models using sophisticated CASE tools.
  • Develops project plans, delegate responsibility and has been a thought leader.
  • Has expert skills in distributed systems NT, UNIX and AIX technology
  • Over 10 years experience in Sun Solaris, HPUX, AIX, Red Hat Linux, Windows NT, 2008R2, Microsoft Office 2010, Project and Exchange, Novell, Visual Basic, MS Access, C++, Java, HTML, HACMP for many clients.
  • Experienced performing Performance and Capacity Planning, Operating Systems support, and data storage (tape and DASD), Tivoli and HP Openview tasks.
  • Able to analyze client requirements, organizational structure, operations staffing, system management disciplines, service improvement and cost reduction strategies.
  • Strong customer focus to ensure the thorough understanding of business and technical IM application migration requirements and issues.
  • The ability and to communicate with various business and technical personnel.
  • Works as Chief Oracle Architect & Designer creating EDI solutions using BizManger & Bizlink. enterprise portal taxonomy into enterprise wide production sites. Also created backend logic with PL/SQL procedures.
  • Develops project plans, delegate responsibility and thought leader with skills in distributed systems.
  • Working as a Oracle specialist, for several major corporations and have performed data center consolidations.
  • Develop project plans, delegate responsibility and thought leader.
  • Experienced with Performance and Capacity Planning, Operating Systems support, and data storage (NAS, SAN).
  • Able to analyze client requirements, organizational structure, operations staffing, system management disciplines, service improvement and cost reduction strategies.
  • Experience configuring, tuning and administrating MS Sql Server 2008/2013 standard and enterprise.
  • Experience configuring, tuning and administrating Oracle 11g R2 RAC
  • Strong customer focus to ensure the thorough understanding of business and technical requirements and issues.
  • Mortgage origination experience using LPS Empower, responsible for data migration from Sqlserver and other sql and NoSql data stores to MongoDB. Developed client requirements with .Net for Empower and integrating data from several production systems.
  • The ability to communicate with various business and technical personnel.
  • Over 25 years of experience providing Oracle enterprise support.
  • Act as a principle contributor to Enterprise Security designing security methods and procedures.
  • Experience managing internal and external membership directories (AD/ADFS/LDAP/Oracle Identity Manager (OIM), Oracle Identity Analytics (OIA), Oracle SOA Suite, Oracle Enterprise, WebLogic Server, Oracle databases, Tivoli Enterprise Directory).
  • Create Java and J2EE/JEE applications & Java Script, SOA Services, Web applications, Spring Framework and Web services. Work with cloud services including AWS, Rackspace and Azure. SAP Cloud experience.
  • Strong MS Stack skills including Visual Studio 2010-2016 .Net 3.5 - 4.5

SKILLS PROFILE:

Hardware: SUN Sparc Series, HP9000, IBM 7040-681, IBM 9119-595, Intel

Operating System: UNIX (SUN Sparc Solaris 2.6/2.7/2.8,9,10, HP-UX 9.x, AIX 5.3,5.2,5.1,4.3), Windows XP/2000/NT/98/95

Tools: / Utilities DBArtisan, Erwin, TOAD, Oracle JDeveloper, VS 2012 .NetTivoli ADSM for oracle, DB2 on AIX, Veritas NetBackup for oracle, DB2 on Solaris and NT, DBverify, Exp/Imp, expdp/impdp, Server Manager, SQL * Loader, TKPROF, Log Minor, Statpack and Oracle Enterprise Manager grid control

Languages: UNIX shell programming, PL/SQL, C# .Net, Java, JSP, JSF

Database: ORACLE 12R/12c/11g/10g/9i/8i/ 8.x/ 7.x on UNIX and NT

Big Data: Big Data Streaming with Hive, Spark, Flume, Python, Scripts, Horton, Hadoop. Knowlegable Hadoop Administrator.

Cloud: CI/CD Scripted Azure Cloud Deployments with PowerShell Run Books, Chef, Puppet, Ansible Play Books of YAML. IBM Bluemax expert. Scripted AWS Cloud Deployments with AIMs, Ansible Play Books with Horton, Spark, Hadoop for IoT solutions. SAP Cloud Solution Security.

Migration: Migrated Large Oracle Databases to AWS EC2 using Data Pump and Tsunami. Fluent with RDB.

PROFESSIONAL EXPERIENCE:

Confidential, San Diego, CA

Principle Cloud Architect & Solution Designer

Responsibilities:

  • Architect & Solution Designer for migration from Sharepoint 2010 to hybrid Sharepoint 2016/SqlServer 2016 & Office 365. Responsible for Exchange, Azure AD, ADFS, Certificate Server provisioning and integration & MFA and inTune configuration.
  • Migrated as many as 40K users to Exchange.
  • Required some custom objects to be recreated.
  • Workflows created with K2 Smartforms V4.7 (later used V5).
  • Required extensive validation testing design unit tests created, managed that effort.
  • Implemented Migration Strategy & Risk Assessment
  • Migrated Servers (e.g. Exchange etc) to the cloud creating Hybrid Sharepoint 2016
  • Performed Governance planning & Created SharePoint Governance plan
  • Created or recreated UI objects as needed (e.g. K2 V5 Workflows using Studio)
  • Implemented MFA and inTune
  • Created & manged validation testing
  • Performed system troubleshooting and debugging (hands on)
  • Back Office Connectivity with Oracle 12c on AWS. SAP Cloud Data Security expert.
  • Power BI solutions with Azure
  • InTune & MFA configuration and rollout.

Confidential, West Long Branch, NJ

Principal Enterprise Architect

Responsibilities:

  • Order Management
  • Shipping
  • Advance Pricing
  • Inventory
  • Purchasing iProcurement
  • Costing
  • Additionally used Java, Unix Shell and Powershell script programming & debugging for break/fix issues requiring corrections.
  • Required extensive Oracle 11i & R12 & 12c (Cloud) Enterprise Edition(s), High Availability Administration, Load Balancing, Compression Solutions knowledge (Riverbed Steelhead WAN accelerators) Load Balancing solutions.
  • Used phased approach with requirements gathering for each phase. Recent Big Data projects included streeming Hadoop MapReduce on AWS.
  • Recommended & implemented state of the art Paas, Saas, Iaas with SOA, load balancing, DR/BC and room for system and data growth.
  • Designed Cloud backup/restore solutions for AWS.

Confidential, Arlington, VA

Oracle DBA, Architect and Designer

Responsibilities:

  • Responsible for Architecting Oracle Solutions and access management security. Personally responsible for Oracle Webcenter and Services including security solutions managing internal and external membership directories including (Oracle Identity Manager (OIM), Oracle Identity Analytics (OIA), Oracle SOA Suite, Oracle Enterprise, WebLogic Server, Oracle databases, Tivoli Enterprise Directory).
  • Deployed Oracle EBS, EDI and GSX Biz Manager Suite using BizLink & BizConnect to facilitate B2B partner connectivity and reliable data communication & exchange. Developed client requirements with .Net for Empower and integrating data from several production systems.
  • Platform also included running Windows 2012 with SharePoint 2013, Oracle 11g RDBMS and multiple Oracle applications. In addition, I created Illustrated Training documentation for all users, technical staff and administrators. Managed developers and end users and provided training classes for security. Additionally:
  • Oracle Architect/DBA with 9i, 10g, 11g RAC R2, Data Guard, and Physical standby Databases, BI/ Data Warehouse, EBS, EDI, BizManager, BizLink, BizConnect and Oracle Financial applications.
  • Oracle WebCenter & Services deployment and customization using JDeveloper. Work with cloud services including AWS, Rackspace and Azure.
  • Architecture, Development and Administration of Custom Collaboration Solution using WebCenter.
  • Manage internal and external membership directories (AD/ADFS/LDAP/Oracle Identity Manager (OIM), Oracle Identity Analytics (OIA), Oracle SOA Suite, Oracle Enterprise, WebLogic Server, Oracle databases, Tivoli Enterprise Directory).
  • Installed, configured and managed of Oracle 11g, Access Manger and supported developers.
  • Implemented Oracle Projects Costing & Billing & integrated with Oracle Suite of Modules.
  • Acted as technical lead supervising the entire and managing the infrastructure and Oracle design and deployment.
  • Working with Oracle migration vision, strategy and deployment for 9g to 11g migration.
  • Developed Migration Plan and Requirements Analysis for new 11g Platform.
  • Architected new Oracle 11g, gathered requirements, writing the LDD and building production environment.
  • Created Java and J2EE/JEE applications, SOA Services, Web applications, Spring Framework and Web services using (Eclipse/RAD, SVN/CVS and Apache Ant) as needed.
  • Design, develop and deploy OIM Workflows and integrations
  • Implemented: Oracle GoldenGate Capture, Trail Files, Delivery, Manager, Veridata and Management Pack for Oracle GoldenGate.
  • Mortgage & Loan origination using LPS Empower, responsible for data migration from Sqlserver and other sql and NoSql data stores to MongoDB.
  • Created: Real - time BI, Operational reporting, OLTP data integration Using Oracle Golden Gate.
  • Design and implemented Data Center migration for over 18 TB EDW databases.
  • Upgraded 10.2.0.4 Two Node RAC ASM Database to 11g R2 Two Node RAC ASM
  • Advanced Backup and Recovery using Oracle s RMAN software; used offline/online for recovery in a production environment via Korn shell scripting.
  • Mentor other DBAs in effective use of RMAN software, and my scripts.
  • Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.
  • Data center Migration using Data Guard.
  • Implemented TimesTen (In memory Database) for Personalization and Recommendation project.
  • Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using golden gate.
  • Supporting Nook Devices from 1st generation to Nook Tablet.
  • Implemented BNCLOUD Database to support devices.
  • Strategic involvement with team for Server virtualization and manageability of infrastructure.
  • Implemented Stream, Golden Gates for Active-Active Replication between the Datacenter for High Availability.
  • Currently helping team to use existing infrastructure to achieve Maximum benefit to reduce cost and maximum performance.
  • Actively working with other teams for Server Consolidation & Database Consolidation.
  • Changes were made dynamically whenever possible to fulfill high-availability requirements.
  • Enforced need of regular data purging processes from production, design and development, to deployment.
  • Implemented and maintained Oracle 10g/11g Data Guard/standby databases for fail-over purposes.
  • Propagation from primary to standby via automated scripts, and sometimes uses standby databases to immediately restore primary database.
  • Experience with graceful switchover and switchback between primary and standby databases.
  • Replicated to a disaster recovery site for increased server manageability and availability.
  • Participated in development of enterprise-wide security standard methodology, and ongoing deployment.
  • Installation of RAC and Managing RAC Environment efficiently
  • Proficient in RAC Performance Tuning.
  • Create and maintain materialized views.
  • Implementing and maintaining database security (create and maintain users, roles and assign privileges)
  • Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.
  • Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
  • Monitored the production Oracle alert logs for database errors.
  • Monitored system resource availability and responded to system memory and data issues.
  • Expert with OEM Grid Control.

Confidential, Needham, MA

ORACLE DBA ARCHITECT & CONSULTANT

Responsibilities:

  • Responsible for consolidating one of the largest worldwide data centers.
  • Responsible for hardware planning and Oracle Database and Applications migration.
  • Oracle Architect/DBA with 9i, 10g, 11g RAC, Data Guard, and Physical standby Databases, BI/ Data Warehouse and Oracle Applications including Advanced Benefits, Daily Business Intelligence for HR, Compensation Workbench, Human Resources, Incentive Compensation,
  • Created procedure libraries and applications performing huge dataset manipulations and data parsing matching solutions with Oracle PL/SQL.
  • Implemented Oracle Projects Costing & Billing & integrated with Oracle Suite of Modules.
  • Expert with Oracle Access Manager providing security integration with multiple applications.
  • Provide 24x7X365 Support Solution Architecture for Oracle production environments.
  • Provided Oracle and Sql Server Database support as Designer, developer and DBA. Created Data Models and Databases.
  • Deployed EBS, EDI and Biz Manager Suite using BizLink & BizConnect to support B2B operations.
  • Supported Oracle Financial Applications including Advanced Collections, Assets, Balanced Scorecard, Cash Management, Daily Business Intelligence for Financials, Enterprise Planning and Budgeting, Financial Consolidation Hub, Financials Centralized Solution Set ( FINS), General Ledger, Internal Controls Manager, Internet Expenses, Payments, iReceivables, Lease Management, Loans, Payables, Property Manager, Receivables, Treasury.
  • Supported Oracle HR Applications including Advanced Benefits, Daily Business Intelligence for HR, Compensation Workbench, Human Resources, Incentive Compensation, iRecruitment, Learning Management, Payroll, Performance Management, Self Service HR, Time and Labor, Tutor, Workforce Scheduling and Payroll.
  • Worked with IBM, HP and SUN vendors to provide the best solutions and servers.
  • Engineered the relationship between systems, servers, nodes, frames and Databases using Grid Architecture and VMWARE, ESX 2.X or dedicated non-shared or virtualized hardware. knowledge in web and emerging technologies using Veritas, WebLogic, Apache, Oracle, LDAP and many other software tools.
  • Design included fiber, switches, routers, frames, network communications (T1) and security firewalls and redirection. Required optimum selection and deployment of infrastructure hardware and OS and Software optimization.
  • Planned and implemented the GRID and VMWARE strategy used to maximize Resources for non-production environments. Made key decisions on use of SAN and NAS storage solutions to maximize performance when needed or save the budget when possible.

Confidential, Pleasanton, CA

Principal Engineer - Lead Developer and SQL DBA

Responsibilities:

  • Responsible for managing several Documentum Webtop & Web Publisher, DCM and GxPharma EDM projects, meeting with change control team and presenting the business processes needed, designing the technical modules for the system, performing validation and delegating responsibilities to my team.
  • Hands on manager and often take full responsibility for the design, development and training of Documentum EDM systems. Have Implemented silent and single sign on portals.
  • The improvements to the 5i dfc helped me improve already quick development cycles using Webtop, WDK and Web Publisher. Helped with DST issues
  • Acted as Lead for consultants and employees.
  • DCM, Webtop, Web Publisher, GxPharma WDK application expert with experience up through 5.3 SP4 and D6.
  • Liquent Aqua, Adobe fusion expert.
  • Managed VMWare esx2 server farm for eRoom and Documentum Engineers.
  • Worked as a DSE for eRoom as well as Documentum full product line.
  • Provided Oracle and Sql Server Database support as Designer, developer and DBA. Created Data Models and Databases.
  • Manage staff and projects, created procedures manuals, perform training
  • Handle details with a high degree of confidence
  • Interface with senior level executives, customers and vendors
  • Prepare and execute presentations for management using PowerPoint
  • Coordinate logistics of conferences and meetings
  • Quickly perform ad-hoc reporting and analysis on special projects
  • Maintained executives schedules, appointments, meetings and travel arrangements
  • Customized internet user interface and created sophisticated applications.
  • Customized application services using WebLogic and WDK Components.
  • Designed and developed data migration applications.
  • Implemented E-Signatures, Authentication and Audit Trail.
  • Customized client processing with WDK and server processing with docbasic scripts.
  • Trained and Mentored users in use of the Desktop Client, Web Publisher and other WDK processes.

Confidential, NY, NY

Principal Oracle DBA & Infrastructure Architect

Responsibilities:

  • Provided Oracle and Sql Server Database support as Designer, developer and DBA. Created Data Models and Databases.
  • Supported and Trained users of Oracle and Ariba
  • Oracle Financial Applications including Advanced Collections, Assets, Balanced Scorecard, Cash Management, Daily Business,Intelligence for Financials, Enterprise Planning and Budgeting, Financial Consolidation Hub, Financials Centralized Solution Set ( FINS), General Ledger, Internal Controls Manager, Internet Expenses, Payments, iReceivables, Lease Management, Loans, Payables, Property Manager, Receivables, Treasury.
  • Oracle HR Applications including Advanced Benefits, Daily Business Intelligence for HR, Compensation Workbench, Human Resources, Incentive Compensation, iRecruitment, Learning Management, Payroll, Performance Management, Self Service HR, Time and Labor, Tutor, Workforce Scheduling and Payroll.

Confidential, Phoenix, AZ

SENIOR ORACLE DBA

Responsibilities:

  • Architect within a large data warehouse environment, managed Oracle Databases on SUN servers.
  • Designed publishing system to published statements and customer data to website.
  • Created Multiple packages and stored procedures/functions with PL/SQL.
  • Developed Reports with Reports 6i & PL/SQL packages.
  • Administered Oracle and Documentum environments and oversaw object regeneration and deployment on 9i Web Server and change control for Documentum 5i webtop production application.
  • Installed setup and administered portals on 9I AS to facilitate connectivity between different data warehouses including SAP repository.
  • Analyzed repository reports and made needed design changes following Oracle Case methodology.
  • Worked on thin client xml, java, java beans, servlets portal solutions for entire enterprise.
  • Maintained data warehouse and required technical documentation.
  • Responsible for user manuals, documentation of systems, programs, methods and procedure manuals.
  • Required MS Office & Lotus Notes experience.

We'd love your feedback!