PROFESSIONAL SUMMARY:

• 20 years of professional experience designing, developing and implementing relational database management systems. Expert knowledge with Microsoft technologies: Microsoft SQL Server (6.5, 7, 2000, 2005, 2008, 2008R2/2012/2014), SSAS (2000, 2005, 2008, 2012), PostgreSQL (8.4.1, 8.3.8, 8.2.14), FoxPro (DOS 2.5, 3.0, 95, 97, 2000, 2003), Access (2.0, 95, 97, 2000, 2003, 2007), MySQL (Versions 4.x - 5.7), and Sybase Adaptive Server 11.5, Oracle (8i/10g/11g/12C), Progress DB Open Edge v9/10
• 8 years’ professional experience developing client-side website and 32bit applications.
• Over 20 years’ experience, development and support with Microsoft SQL Server, all versions up to version 2016
• Over 6 years’ experience with Oracle (OSS) Oracle Student System
• 3 years’ experience with Ellucian Banner ERP Student Information System
• Over 7 years’ experience, development and support with Mongo DB, all versions to current
• Replica Sets, Ops Manager, Sharding
• Rapid7 Nexpose Vulnerability Scanner and Masergy Vulnerability Security Scanner
• Expert in Vulnerability and Penetration Testing (Windows and Linux Systems)
• 2 years’ Support, Installation, Configuration and Development with:
• Rocket UniData v8.1.1 (Linux) - Current
• Rocket UniVerse v11.2.5 (Linux) - Current
• Rocket D3 (Windows v10.2) - Current
• Over 7 years’ experience with Hyper-V and VMWare
• Micro Strategy Analytics & Reporting - MicroStrategy Universal Edition - 8 years
• Oracle Cloud Compute (Elastic Cloud):
• Platform (PaaS), Infrastructure (IaaS), Hadoop (Big Data), Oracle Database 12c, Multi-Tennant and Single Tenant Virtual Machines for Development, Test and Production environments, Storage, Network and Cloud Machine, Oracle Cloud Messaging, Business Analytics and Business Intelligence.
• OpenStack Technologies - 5 years’
• Data Center Power Systems (High Efficiency Power Distribution Systems AC 120/240) - 6 years’
• Over 7 years’ experience with IaaS platforms (Amazon Web Services, Microsoft Azure, IBM Cloud, Mongo Cloud)
• Expertise with Oracle RDBMS 8i/9i/10g/11g/12c.
• Expertise with Oracle Real Application Cluster (RAC) 9i/10g/11g/12c.
• Expertise with Oracle Data Migrations (9i to 11g/12c).
• Expertise with Oracle Database Appliance (X4-2, X3-2) installation, configuration and administration.
• Over 3 years’ experience and development and support with Amazon Web Services (AWS) and OpenStack
• Over 7 years’ hands-on experience with Data Center Consolidations and Migrations (Physical and P2V)
• Expertise with Oracle upgrades 9i to 10g/11g/12c.
• Oracle Enterprise Linux (OEL, current version 7) - 12 years’
• Security Hardening for Network, Windows Servers, Linux Servers - 10 years’
• Expertise in migrating Oracle database to Microsoft SQL Server (11g to SQL Server 2008R 2/ 2012/2014/2016 ).
• Expertise with Oracle upgrades and Migrations from 32bit to 64bit platforms.
• Expertise in migrations of data/DDL/DML, Packages, PL/SQL Procedures, database objects from 8i/9i to 10g/11g/12c.
• Expertise in migration of Oracle 10g/11g/12c to Microsoft SQL Server.
• Expertise with Oracle Recovery Manager 9i/10g/11g/12c.
• Expertise with Oracle Patch Management (Oracle Enterprise Manager) and Grid Control/Cloud Control.
• Expertise with Oracle RAC 10g/11g/12c implementations, support and resolution of performance issues.
• Expertise with Oracle Streams and Replication 10g/11g.
• Oracle Goldengate 11g/12c - 4 years’
• Expertise with Oracle Data Pump 11g and Oracle Golden Gate 11.2.1.0.2.
• Expertise with Oracle RDBMS migrations from 8i to 9i/10g/11g/12c.
• Expertise with Oracle Real Application Testing (RAT), Sarbanes Oxley (SOX), RAD and SDLC.
• Expertise with Oracle Sun Systems
• Expertise in developing and supporting Multi-Terabyte Data Warehouses (Oracle and Microsoft SQL Server).
• 7 years’ experience developing two, three-tier systems, and N-Tier systems using various methodologies.
• 7 years’ experience in web development utilizing IIS, ASP, ASP.Net, and C #, ADO.NET, XML, CSS, JavaScript, HTML, DHTML, VBScript, FTP, Java and HTML.
• Over 7 years’ development and script writing in Perl, Python, Ruby/Ruby Gems, Linux Shell Scripting (Korn, Bash, SH), MS Windows PowerShell Scripting
• Expert at SQL Server 2008/ 2012/2014/2016 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE), Object Search, Object Explorer Details, Activity Monitor, Multi Server Query, Intellisense in Query Editor and T-SQL Debugger.
• Experience in migration and maintenance of data using various utilities like DTS, SSIS, Import and Export, ATTACH/DETACH Data Migration tools.
• Expertise in RDBMS S/w Installation, applying patches, upgrading, configuring, managing, monitoring disk space usage, and database integrity/consistency and troubleshooting of SQL Server 2008 R 2/05/00/ 2012/2014/2016 on Windows 2008/03/00 servers built on Clustered & Stand Alone Servers.
• Expertise in implementing and setting up DISASTER RECOVERY and HIGH AVAILABLITY solutions like Log Shipping, Mirroring and Replication (Transactional and Snapshot Replication), Microsoft SQL Server Clustering 2012/2014/2016 Always On
• Expert in Performance tuning of Database Management Systems (i.e. Table/Index Partitioning, T-SQL Performance Tuning, etc.)
• Experience in creating and deploying the CUBES in BIDS with Fact and Dimension Tables using different data warehouse styles (star and snow-flake schema).
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities and DMVs and DMFs.
• Creating SSIS Packages using Complex Tasks like ActiveX script task, Fuzzy Lookup and fuzzy Groupings.
• Extensively used tools like SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Excellent skills in database Backup, Recovery, Linked Servers, Database Maintenance Planning.
• Excellent SQL Server administration skills including user authorizations, Database creation, Tables, indexes creation.
• Expertise in planning, implementing Database Security by creating users, Roles, and assigning permissions to them.
• Experience in creating and scheduling DTS and SSIS packages, SQL Mail Setup, Jobs, and Alerts.
• Strong T-SQL Developer skills including stored procedures, Indexed views, User Defined Functions (UDL), Triggers, and Distributed Queries and Common Table Expressions.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS).
• 24 X 7 Production Database on Call Support.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.

WORK EXPERIENCE:

Confidential

Sr. DBA/Architect/Systems Administrator

Responsibilities:

• Provided support of development, QA and Production Microsoft SQL Server 2008 R2, 2012, 2014 and 2016 Instances/Databases
• Performance tuning (indexing, stored procedures, batch processes)
• Table/Index Partitioning for very large tables
• Install and configure Fog light for monitoring of Production SQL Server’s
• Support for Fail-Over/SQL Server Clustering (Installation and configuration)
• Microsoft Data Protection Manager (DPM) - backup all systems
• Microsoft SCOM - For monitoring and performance tuning.
• Setup and Configuration of SQL Server Replication
• Configure Publishers and Subscribers
• Transactional, Merge, Peer-to-Peer and Merge Replication from SQL Server’s in the Montreal and Boston Data Centers to Data Centers in California and China
• Development with Visual Studio 2012/2013/2015 (SSIS) – ETL Packages, support current BI Team
• Upgraded VS from legacy Visual Studio 2005 to VS 2013
• Migrated and Converted all SSIS Packages (200) to VS 2013
• Installation, administration and support Cassandra 3.7
• Security, Administration, Maintenance, back and Recovery and High Availability
• Setup and configure Vulnerability and Security Penetration Testing
• For all our Microsoft Windows and Linux Servers in Boston and Montreal
• Setup scripts and batch jobs for weekly Security Vulnerability and Penetration Testing using:
• Rapid7 Nexpose Vulnerability Scanner – For our internal testing and;
• Masergy Vulnerability Security Scanner – For External testing of all open TCP,UDP, …Ports
• Recommend and Implement Security Hardening:
• Windows Host Security Hardening
• Linux Host Hardening using SE Linux
• Network Security Hardening (disabling unused ports, enforcing firewall rules)
• Web/Application support (Linux, Node.js, Python and Perl, PM2, NVM-Node Version Manager and NPM – Node Process Manager), Dev., Test and Production
• Team lead, Architect for Data Center Consolidation and P2V migrations of Development, QA and Production Web Applications
• Linux Shell Scripting, Ruby Scripting, Python Scripting and Perl
• Developing interfaces, Node Micro services, batch jobs and Messaging with RabbitMQ
• Migrated Web Applications (Node.js/Java Script Micro Services) – P2V (Hyper-V) Hardware Consolidation
• Over 100 individual Web Applications
• OS Migration from Sun Solaris (Joyent) to RedHat Linux/Centos
• 20 Windows Server 2008 R2 with Upgrades to Windows Server 2012 R2
• Physical to Virtual Data Center Migrations (P2V)
• Bare Metal build/OS install, OS Packages, DNS and Network Configuration
• Security
• Network configuration
• Configure Backups with DPM
• Support for RabbitMQ in Development, QA and Production
• Support, Installation, Configuration, Management (Administration), Development: (In support of Shark Ninja Customer Web Sites, Marketing Information, Sales and Product Information)
• Rocket UniData v8.1.1 (Linux)
• Rocket UniVerse v11.2.5 (Linux)
• Rocket D3 (Windows)
• Rocket U2 Development Platform
• SystemBuilder v6.4.1
• Support QlikView Applications on Windows Server 2012 R2 and batch processes
• Development, QA and Production support for Node.js Web Applications
• Support for JAMS Batch Scheduling
• Installed, configured MySQL Cluster CGE ver. 7.2 (Linux) – DB’s For External Web Applications
• Setup/configured replication between data center and DR facility
• Write procedures, creating tables and indexing
• Performance tuning
• Backups with MySQL Enterprise Backup and MySQL Dump
• Monitoring with MySQL Enterprise Monitor
• Responsible for supporting 12 Mongo DB (3.X) Instances (Linux and Windows Server 2012 R2)
• Designed and Configured an (11) node Sharded Cluster with Replica Sets
• 3 config servers, 2 application servers with Mongos, 2 Primary/4 secondary
• Backups/Restores mongoexport, mongoimport, mongodump, mongorestore
• OpsMgr and Mongo Cloud
• Administration support with Mongo Cloud, and all utilities
• Setup/support for daily backups

Confidential

Elastic Cloud Architect/Oracle ExaData DBA

Responsibilities:

• Provided support of development, QA and Production Microsoft SQL Server 2012 Instances/Databases
• Manage/Configure SQL Server 2012 in Microsoft Azure Cloud
• Responsible for design of database Data Model, Logical and Physical Design
• Patching of all tiers (Exalogic & Exadata)
• Development of Stored Procedures, functions, views
• Oracle Cloud Compute/Elastic Cloud – (DR Site)
• Multi-Tennant and Single Tenant Virtual Machines for Development, Test and Production environments
• Platform (PaaS), Infrastructure (IaaS), Hadoop (Big Data), Oracle Database 12c, Storage (Configured all storage), Network (Configured) and Cloud Machine (Install and Configure), Oracle Cloud Messaging (Install, Configure and work with development to integrate with Node.js applications, Business Analytics and Business Intelligence (Setup/Develop Reporting and Analytics).
• Installed and configure Oracle 12c/Oracle Enterprise Linux on Oracle Elastic Cloud (VM) - Production
• Implemented/installed and configured Oracle Exalogic Elastic Cloud & Oracle Database Machine (ExaData)
• Oracle WebLogic, Oracle Coherence, Tuxedo, Exalogic Control and Exalogic Hypervisor on Oracle Exabus.
• Exachk for security and configuration, auditing and reporting. Provide support for full system checks, updating platform templates & configurations, applying patches, and network assignments
• Cycle complete platform (shut down complete architecture/sub-systems and bring up, for maintenance purposes)
• Support of Exadata Database Machine (X2) & Exadata Storage Server & Fabric Switches
• Support Java/Node.js applications/Micro-Services on Oracle Enterprise Linux 6
• Designed and Implemented (HA Proxy – Application Server Load Balancing), 4 node Centos 6 with Physical F5 Load balancer.
• Installed, Configure Oracle DataGuard for DR of Production Oracle Exadata/Exalogic System/Databases to Oracle Compute Elastic Cloud
• Configure and Manage DNS
• Setup & Configured MicroStrategy Universal Edition – For Analytical & Reporting needs
• Developed custom dashboards and reports
• Configure SSH for Linux
• Power Shell Scripting, Batch Command line scripting, Python Scripts for automating batch jobs, Disaster Recovery - Python Scripts for automating copies of data files, restoring.
• Import 1TB of Oracle exports (Partitioned data)
• Data Center Migration of all SQL Server Instances and databases to Microsoft Azure Cloud, including all Apache and IIS Web Applications

Confidential

Senior Oracle DBA/Systems Architect/Migration

Responsibilities:

• Provided support of development, QA and Production of Oracle Instances
• Installed and configured Oracle 11g/12c in Dev., Stage, QA and Production
• Migrated Oracle databases from legacy hardware to Oracle Virtual Machines in Quest Data Centers.
• Data Center Consolidation and Migration
• Physical/Bare Metal installs/platform migrations
• Physical to Virtual (P2V) Migrations, from Legacy Unix Operating Systems to RedHat Linux/Centos
• Patched and upgraded Oracle
• Setup and configured RMAN for backups
• Linux, Perl and Power Shell Scripting for Migrations, Moving large data files, backups, automated startup/shutdown scripts
• Provided detailed documentation on all processes.
• Configured Symantec VCS for fail-over clustering
• Supported Align Sys admins
• Daily meetings with Quest and Align
• Responsible for Sybase ASE (15), Sybase IQ, Sybase Replication server database administration. Primarily responsible for database design, data warehouse administration. Monitor disk space, database health checks, database backups and error log scanning. Configure Servers to achieve the best performance and writing automated database monitoring scripts.
• Installation, administration and support Cassandra 2.27
• Security, Administration, Maintenance, back and Recovery and High Availability
• Created ETL for Oracle to Cassandra
• Developed and maintained ETL processes Oracle to Cassandra

Confidential

Senior MySQL DBA/ETL Developer

Responsibilities:

• Provided support of development, QA and Production MySQL Instances/Databases
• Manage/Configure MySQL (5.0) 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) to MySQL databases/schemas and Mongo DB (Big Data) Collections
• Create JSON Blocks/Format for load of JSON data to Mongo DB Collections
• Linux Shell/Perl Scripting for ETL processes/engines
• Setup & Configured MicroStrategy Universal Edition – For Analytical & Reporting/Data Warehousing
• Developed custom dashboards and reports
• Designed Data Models for Multi-Dimensional Analytical Reporting
• D3 – Used Tree Diagram generated from external JSON data
• JSON data from Mongo DB
• Load of external data and CSV data using D3 JavaScript
• Handling dynamic JSON data via D3
• Reading in data using D3 JavaScript (PostgreSQL DB)
• Install and configure PostgreSQL DB – Migrate Data from Mongo DB Collections via JSON blocks to PostgreSQL DB
• Monitor, Tune and backup PostgreSQL DB
• Indexing for PostgreSQL DB
• Data Modeling for PostgreSQL DB
• High Availability for PostgreSQL DB
• 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 Power plant (System for Water and Sewer).
• Maintained and upgraded current Power plant system and worked with vendor during upgrade.
• Maintained security for Power plant.
• Cloned Oracle databases from production to development 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.
• Supported Banner ERP and Oracle 12c
• Upgrades and Patches
• ETL and Data Warehousing (to SQL Server 2012 R2 Data Warehouse & Batch processes)
• BI and Analytics
• 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 to over 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 to configure and maintain.
• Configured and maintained Oracle RMAN Catalog for daily backups.
• Developed AIX Shell Scripts for maintaining file system.
• Used Python and Perl with AIX Shell Scripting to develop tools for automating back and recovery, monitoring and batch jobs
• Developed Crystal Reports for Lawson Financials and Human Resources (for budgets, purchase orders and work orders).
• Installed and configured Oracle Goldengate 12c
• Maintained HA/DR processes
• Deployed Crystal Reports to Lawson 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

SQL Server DBA/Architect/Sr. Oracle 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 Auto Service 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 to 11g).
• Oracle archiving and Oracle partitioning.
• ADRCI/Log rotate 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.
• 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 Dev, Test and Production SQL Server 2012 R2 Instances from IBM’s Data Center to IBM’s new Cloud
• Data Center Consolidation and Migration
• Migrated Oracle 11g database (2 TB) to Microsoft SQL Server 2012.
• Used Microsoft SSMA (SQL Server Migration Assistant for Oracle 5.2.1259) Project (Oracle to SQL).
• Mapping of Oracle and SQL Server data types.
• Converted 50 Oracle 11g Schemas to Microsoft SQL Server 2012 Schemas.
• Used Microsoft SSIS to cleanse/massage data from Oracle 11g to SQL Server 2012.
• Loading Converted data from oracle 11g to Microsoft SQL Server 2012.
• Assessment reports.
• Backup and recovery procedures/jobs.
• Converted PL/SQL Procedures, Functions and Packages to SQL Server Stored Procedures.
• Performed in DEV, TEST and production environments.
• Involved in Oracle database upgrades and patches.
• Installed and configured and maintained Oracle Goldengate 11g
• Involved in staff meetings, team meetings, technical documentation and training.

Confidential, Monterey, CA

Senior ExaData Oracle 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 to Oracle 11g (8 Terabytes).
• Supported Banner ERP on Oracle 11g DBMS
• Focused on Exadata administration. With nodes ranging from 2 to 8 and incorporating Dataguarded Exadata Clusters for maximum availability.
• Take Down and Bring Up (Entire Exadata/Exalogic) platform for testing and maintenance purposes.
• 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.
• Patching of all tiers (Exalogic & Exadata)
• 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 (VMWare – Maintenance & Configuration of Virtual Servers
• Exachks 12.x
• Overall Health Checks and Security and Configuration Auditing, and systems analysis
• Hardware: Oracle X2-2(4170), X2-2, and X2-8, X3-2, X3-8, Exalogic, SPARC SuperCluster
• Operating System: Linux X86-64 and Solaris 11 X86-64
• 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 offsite disaster recovery.

Confidential, Emeryville, CA

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 to Oracle 11gR2.
• Installed and configured Web Logic 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 to Innodb storage engine to increase performance and betterment of integrity constraints.
• Manage/Support MySQL 4.0 in production, QA and development environments
• 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 to Innodb 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 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 and 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.
• Installed and configured Oracle Database Appliance (X4-2).
• Use of ILOM, OAKCLI, deployed on Virtualized Platform, Using ODA BASE Template.
• Configured Oracle Auto Service 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/archive log tuning.
• Tuned PL/SQL and T-SQL Queries.
• Tablespace/table placement and partitioning and indexing.
• Used AWR, ADDM and OEM for tuning analysis.
• Stats pack.
• Maintained and supported backup Oracle RAC 10g/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) and monitored performance.
• Maintained user security and 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 and cloned using Rapid Clone for Oracle 10gAS.
• Backup and recovery RMAN.
• High availability/redundancy and load balancing for Oracle 11g Data guard (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).

Confidential, Palo Alto, CA

Senior Oracle DBA

Responsibilities:

• Installed 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 and 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.
• Performed backup and recovery in non-RAC and RAC environments/procedures.
• Performed 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.
• 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, Houston, TX

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 to support 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 into zones.
• 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 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.

Confidential, Salt Lake City, UT

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 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.
• Planned installation/configuration of test and development environments (3 and 2 node RAC Cluster).
• Developed 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 US Concrete’s production Oracle Servers.
• Coordinated efforts with development teams, UNIX System Administrators and various staff members to cut-over from present production system to 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.