We provide IT Staff Augmentation Services!

Cloud Systems Architect Resume

Cambridge, MA

SUMMARY:

  • Over twenty - eight (28) Years of experience in Information Technology - 20+ years in Oracle starting with Oracle 6.0.3 coupled with current Oracle Certified Profession Certification in Oracle 11g Database Administration. ( Oracle Certified Associate as well)
  • Experienced Unix/Linux Systems Administrator and Oracle DBA: including bash/korn scripting, Unix/Linux kernel parameter tuning, (Solaris 10 projects) local and SAN storage management using LVMS and ASM. Deep experience with Unix/Linx based performance monitoring tools such as iostat, vmstat, top, and sar.
  • Strong DBA Skills with databases/tools performance tuning/troubleshooting/diagnosis. (TOAD/OEM/Cloud Control 12c)
  • Excellent Skills in Administering Oracle Database in multiple configurations and environments. Extensive use of RMAN for DB Clone operations, Physical DataGuard Standby, incremental and full backups using both control file based and Recovery Catalog configurations.
  • Implementation, Upgrade and Administration of Oracle 10g/11g RAC. Including operating system rpms (yum installs/repository configuration) and system kernel parameters /cluster preparation and ASM configuration.
  • Oracle Transparent Gateway for MS SQL Server administration experience.
  • Strong Skills in transforming single instance Oracle 10g Databases to multinode RAC clusters running ASM and Oracle Cluster Services.
  • Experience integrating RAC clusters with single node Physical DataGuard standby database at remote DR site. Extensive DR planning and implementation
  • Experience includes RAC, Backup & Recovery (RMAN as well as cold OS) Performance Tuning, Oracle Apps / DB Security, Patching, DB Cloning, DB Migration, Unix Shell Scripting, Cron jobs
  • Extensive experience migrating/upgrading Oracle 9i/10g from Solaris/Windows Platforms to Linux platforms running Oracle 11g
  • Strong Skills in Unix including IBM/AIX 5L, Sun/Oracle Solaris 10, HP TRU64 5.1A, Linux (RedHat, OEL, Debian)
  • Use of Oracle 10g/11g Oracle Enterprise Manager Compliance feature to aid in Sarbanes-Oxley (SOX) compliance reporting/mitigation.
  • Excellent QA/performance tuning skills including experience with Oracle Database Replay, SQL Tuning Sets (STS) and SQL Access Advisor.
  • Strong experience in implementing customized Java applications via Web Logic Server
  • Strong written and spoken English language skills with extensive technical documentation experience.
  • Strong MS Visio and PowerPoint Presentation skills.
  • Extensive experience with Oracle Enterprise Linux 5.x/6.x with VM technology.
  • Familiarity with Hadoop, Cloudera Cassandra and other Big Data/Map Reduction technologies, especially as it relates to polyglot data persistence solutions.

TECHNICAL SKILLS:

Databases: Oracle Database Versions 8i/9i/10g/11g

Oracle Middleware: Weblogic 8.1.5 - 10.3.5

Oracle Enterprise Manager: 10g/11g, Oracle Cloud Control 12c

Operating Systems: IBM/AIX 5L, HP Unix 11.11, Sun Solaris8, Compaq (HP) Tru64 Digital Unix 5.1, Confidential Linux 2.1 & 3.0, Windows XP, Win2k, Windows98 & Windows 95.

PROFESSIONAL EXPERIENCE:

Confidential, Cambridge, MA

Cloud Systems Architect

Responsibilities:

  • Explaining issues and presenting a clear technical approach going forward
  • Performance tuning of VM and Amazon Elastic Computing Cloud technologies
  • Desing/implementing ASM storage management, Oracle OEM Cloud Control12c, RMAN/shell scripting on virtual systems
  • Implementing Apache, Websphere, Weblogic, and Tomcat Monitoring and management via Oracle Cloud Control 12c
  • Creating reference architecture for Oracle RDBMS optimized Linux builds to be deployed in Amazon Elastic Cloud virtual environment

Confidential, Waltham, MA

Lead Oracle DBA

Responsibilities:

  • Manage Nepal based offshore team of 4 DBA’s
  • Production DBA support and performance tuning of Multi-Terabyte OLAP/DSS DB’s
  • Patching and upgrades of Oracle RDBMS/Clusterware/ASM
  • ASM storage management, Oracle OEM Grid Control, RMAN/shell scripting.
  • Use Oracle Basic/Advanced Compression for OLTP - ~50TB dataset to ~26 TB
  • Architected Oracle 12C Cloud Control roll out to 30 plus OEL/Oracle RDBMS Servers
  • Created reference architecture for Oracle RDBMS optimized Linux builds

Confidential, Boston, MA

Senior Oracle DBA / Solaris Systems Administrator

Responsibilities:

  • Production DBA support and performance tuning of Oracle 11g (11.2.0.1) OLTP/OLAP databases on Solaris 10 Sparc 64 platforms.
  • Patching and upgrades of Oracle RDBMS/Clusterware/ASM
  • ASM storage management, Oracle OEM Grid Control, RMAN/shell scripting.
  • Use Oracle Advanced Compression for OLTP for both storage space saving and better query performance.
  • Configure monitor RMAN catalog based DB backup. Standby archive log management for DataGuard Physical Standby DB’s.
  • Use RMAN parallel process and compression features.
  • Developer support and data masking and pruning for QA/test databases
  • Oracle Enterprise Manager Grid Control installation/configuration on Hypervisor VM’s
  • Solaris 10 System Administration / Sun StorageTek SAN administration
  • Oracle Enterprise Linux and Confidential Enterprise Linux support and administration,

Confidential, Wakefield, MA

Senior Oracle DBA (consultant)

Responsibilities:

  • Production DBA support and performance tuning of 1.5 and 1.4 TB Oracle 11g RAC DSS databases
  • Performed extensive index, partition and init.ora tuning, to increase batch performance times by factors of up to 3X.
  • ASM storage management, Oracle OEM Grid Control (10g), RMANbackup /shell scripting.
  • Developer support and data masking and data running for QA/test databases
  • Installed, configured, tuned 2 Oracle 11gR2 databases on Oracle Solaris 10 Sparc 64 T5540 Servers with StorageTek SAN Disk Storage. - Including complete 'soup to nuts' installation of Operating System from bare metal up including tuning, SAN storage configuration, ASM installation, operating system tuning using projects.
  • Performed Oracle 11gR2 software installation and customized database creation using DBCA on ASM managed SAN storage
  • Migrated/Upgraded existing Windows X86 64 based Oracle 10g Databases to new Solaris platform using Data Pump via Network Link
  • Configured 2 local Oracle 11g Physical Data Guard instances and one WAN based DataGuard standby database.
  • Installed and configured Oracle Enterprise Manager Grid Control 11g on a virtual 32 bit Windows 2008 R2 server. Configured 11g Grid Control agents on Sparc (64) Servers. Configured RMAN and Data Pump backup jobs within OEM Grid Control to support production environment

Confidential, Watertown, MA

Senior Oracle DBA

Responsibilities:

  • Reviewed current Oracle OLTP (2.3 TB) / DW (%.6 TB) environments for performance and High Availability options. Proposed Oracle Data Guard logical Standby for initial HA strategy.
  • Implemented Oracle Enterprise Manager Grid Control for monitoring, alerting and job control for existing production servers. ( ~ 35 targets)
  • Monitored Daily DB health and RMAN jobs.
  • Secondary role included administering MySQL and MS SQL data stores.

Confidential, Westford, MA

Senior Oracle DBA (consultant)

Responsibilities:

  • Researched and authored 2 Confidential Reference Architecture documents regarding Oracle RDBMS migrations and upgrades from Windows platforms to RHEL 5.x platforms ( 10g to 11g R1, 11g R1 to 11g R2).
  • Researched and demonstrated Confidential JBoss Application server inter-operability with Oracle data sources including Oracle RDBMS 11gR1

Confidential, Cambridge, MA

Senior Oracle DBA (consultant)

Responsibilities:

  • Project/technical lead for the schema consolidation, migration and upgrade of HBS’s primary data stores.
  • Migrated HBS’s existing Oracle 9i databases from various Solaris and Linux platforms to a centralized Linux Advanced Server x86 64 10g R3 RAC cluster environment
  • Installed and configured a 2 OMS Oracle Enterprise Manager Grid Control system that monitors, manages all DB enabled job control and database backups
  • Installed and configured both physical and logical Oracle 10g DataGuard instances using DGMGRL and OEM as monitoring interfaces
  • Performed rolling upgrades of RAC cluster (CPU patches) with DataGuard logical standby
  • Performed specific use case migrations /upgrades of 10g schemas/dbs to 11g schemas/databases
  • Performed init.ora, partitioning and index expereiements in a lab/test environment. Migrated some of these to production for performance gains
  • Configured OEM to monitor/manage BEA Web Logic Application Servers
  • Configured OEM for remote monitoring and management of MS SQL Server databases using the OEM SQL Server plugin
  • Customized OEM monitoring templates for production, QA and development levels of monitoring and alerting
  • Performed security audits and remediation based on customized OEM security policy templates and reporting

Confidential, Cambridge, MA

Senior Oracle DBA- Production Support (consultant)

Responsibilities:

  • Senior production support DBA role servicing customer requests for account creation, maintenance, database space management and monitoring using Sarbanes Oxley (SOX) DBA security best practices and FDA/WHO compliant validation procedures
  • Upgraded/configured Oracle Enterprise Manager 10.2.x.x environment supporting nearly 100 Unix (HPUX/Solaris) /Linux servers and nearly 300 Database targets ranging from Oracle 8i to Oracle 10G R2
  • Performance tuned a .6 TB financial Oracle 9i/Informatica data warehouse using Oracle partitioning (range/hash composite partitioning) and parallel query server as well as file based I/O distribution and tuning init.ora parameters
  • Performed installation and configuration of Oracle Adverse Reporting System (AERS) 4.6 Including Oracle application server infrastructure and database ( Windows 2003 based)

Confidential, Trumbull, CT

Senior Oracle DBA

Responsibilities:

  • Rapid prototyping/proof of concept (~30 Hours) that demonstrated Oracle RAC 10g R2 running on Confidential Advanced Server 4.0 on SUN SMP AMD based server hardware and Network Appliance SAN storage. (2 server nodes)
  • Setup and configured Confidential (Oracle Cluster Services) and ASM disk management as well as the Oracle/OS dependencies such as semaphores, hang check timer, secure rsh and raw device management (for the OCR and Voting disk as well as reliably presenting the same raw device names to ASM between reboots --UUID)
  • Demonstrated Advanced Queue behavior in a RAC environment as well as basic TAF (Transparent Application Failover-) capabilities within the RAC service oriented architecture

Confidential, Framingham, MA

Senior Oracle DBA (consultant)

Responsibilities:

  • Installed and Configured Oracle Enterprise Manager 10G release 3 on IBM AIX servers for Sarbanes-Oxley Compliance (SOX) remediation and reporting
  • Researched, identified and documented specific Confidential compliance points from the Confidential Security Implementation Guide (STIG) and then mapped these back to specific security checks OEM provides
  • Created custom OEM GC monitoring template based on these compliance points/security checks and applied this to Oracle databases, instances and listeners ranging in release levels from 8i to 10g
  • Configured OEM 10gR3 Agent running on AIX 5.3 server to service remote targets on AIX 4.3 servers ( 10g Agent doesn’t run on AIX 4.3)

Confidential, Quincy, MA

Senior Oracle DBA (consultant)

Responsibilities:

  • Led design/deployment of 3 Node Solaris 9/Oracle10g R2 RAC Cluster supporting 5 Production database instances for 24x7 Web Based online travel/cruise reservation system
  • Configured 1 terabyte of Oracle ASM managed SAN storage
  • Prepared Sun OS 5.9 Operating system for RAC installation including setting kernel parameters (etc/system), SAN Storage, shared raw device. setup/permissions, user and group administration, RSH/SSH connectivity and inter-connect networking issues
  • Installed Oracle 10g R2 base/patches for CRS, RDBMS and OEM agent software
  • Configured 5 oracle RAC database instances in corresponding setup in 2 node lab environment.
  • Installed, configured and deployed Oracle Enterprise Manager Grid Control Console and Agents in both DEV and Prod environments to monitor, manage and maintain RAC clusters
  • Installed, configured and patched Oracle Business Intelligence Discoverer and required Oracle Apps Infrastructure

Confidential, Salem, MA

Senior Oracle DBA (consultant)

Responsibilities:

  • Performed various basic Solaris 8/ Oracle 8i/ PeopleSoft 7.5 and 8.0 Maintenance/Administration tasks to PeopleSoft FIN, HR and SA modules
  • Installed and Configured Oracle HTML database ( Confidential )
  • Managed SSL security and CA certificates with Oracle Wallet Manager

Confidential, Burlington, MA

Senior Oracle DBA

Responsibilities:

  • Performed various and sundry Solaris 8/ Oracle 8i/ PeopleSoft 8.8 Admin Tasks on .5 Terabyte PeopleSoft Database
  • Configured multi node Tuxedo application server tier. This tuned and stabilized existing app server layer such that previous daily crashes haven’t occurred in 4 months
  • Configured and tuned PIA tier of PeopleSoft Application suite based on BEA Web Logic Web servers
  • Debugged and configured various MicroFocus Cobol license server issues
  • Installed Oracle 9i db test and migration server environments for pending oracle 9i upgrade
  • Accomplished huge online user performance gains by optimizing I/O and Solaris kernel parameters such that a 32 GB RAM Sun server could use 16GB SGA instead of the 3.7 GB SGA /etc/system setting previously allowed
  • Demonstrated huge batch processing performance gains by partitioning several multimillion row tables, enabling parallel query servers and optimizing disk I/O properly
  • Implemented Oracle Enterprise Manager Grid Control 10g release 2 ( upgraded from 1st installation of 10g R1) for 14 nodes running various versions of oracle 8i and 9i on both Windows 2000 and Solaris 8-9 Servers. Initial 10g R1 OEM grid Control installation was on Windows 2K server. Migrated OEM repository to Solaris Platform and upgraded both OEM console and all agents to 10g R2
  • Ran all DB backup jobs via RMAN administered through OEM

Confidential, Needham, MA

Senior Oracle DBA (consultant)

Responsibilities:

  • 24x7 Support of Oracle 10g R1 3 node Linux RAC DSS cluster and Oracle 9i Solaris Veritas (Dataguard) cluster running web enabled financial OLTP system
  • Managed oracle tars ( Service requests) for several production critical bugs
  • Scripted and debugged various shell programs to support customized application
  • Managed several large .7 Terabyte data transfers from one live system to another
  • Installed, debugged and configured ASM/Oracle 10g RAC on Linux test servers

Confidential, Maynard, MA

Senior Oracle DBA (consultant)

Responsibilities:

  • Installed configured and optimized Oracle 10g (release 1 and 2) for 32 bit Intel Linux.
  • Configured various Oracle 10g OEM backup jobs, event monitoring and auditing functions of the OEM interface as well as hand scripting actual DDL for custom partitioning Designed highly optimized 300 GB + data mart schema using Oracle hash range partitioning, index organized tables (IOT), materialized views and other Oracle 10g OLAP/DW features
  • Installed/configured Oracle Transparent Gateway for MS SQL (TG4MSQL) gateways for high performance heterogeneous connectivity-- achieved rates of 65 million rows transferred per hour (single stream) on Wintel based XEON 2way 2GB hardware
  • Used Oracle Data Warehouse Builder (10G) to create various mappings and process flows to populate Oracle Data Mart
  • Tuned and troubleshot a 4 node Linux RAC experiencing severe performance problems
  • Used Oracle Designer to create/document/deploy terabyte data mart logical/ physical schema
  • Set OEM based RMAN backup processes

Confidential, Boston, MA

Senior Oracle DBA (consultant)

Responsibilities:

  • Oracle DBA tasks on Win 2K platforms. Installed and tested Oracle 10g on Windows 2003 64 bit
  • Perform various day to day production support tasks for very large (by NT standards at least -- 800 users) voter registration database
  • Used Erwin data modeling tool to reverse engineer existing schemas and create organizational data dictionary

Confidential, Westborough, MA

Senior Oracle DBA

Responsibilities:

  • Provided Oracle DBA architecture and technical support/documentation for Ascentials in house development and testing of their DataStage product. Created 2 node IBM AIX 4.3x and 5L Oracle 9i RAC installations for this purpose
  • Performed DBA mentoring and knowledge transfer for Ascential Datastage employees
  • Installed Oracle 9i Linux RAC ( Confidential ) configuration on 3 node IBM blade server

Confidential

Senior Oracle DBA (consultant)

Responsibilities:

  • Implemented Oracle 9i RAC on Suse Linux Advanced Server (Raw Devices)
  • Setup Oracle modplsql gateway, HTTP server and supported development of PSP/Intermedia Text based document storage/retrieval system
  • Administered Digital UNIX and Solaris 8 servers

Hire Now