Postgresql & Cassandra Dba Resume
Atlanta, GA
SUMMARY:
- Cassandra - DSE ver 5
- PostgreSQL 9.4
- Mongod
- MySQL
- Implemented Oracle EBS: applications, versions R12, 11.5.10,11.5.9 and 11.5.7
- Project lead converting Oracle 11g databases to PostgreSQL 9.4
- Managed Oracle DBA group
- Oracle Dataguard, GoldenGate, ASM
- Implemented Oracle EBS R12.1.3 on ExaData and ExaLogic engineered servers
- Created both single tier and multi-tier EBS instances on both RAC’s and non-RAC’s servers
- Created RAC’d databases on OEL, HP-UX and Red Hat Linux
- Implemented Oracle E-Suite on RHEL,Solars, AIX, Hp-UX, and Windows
- Cloning of E-Suite environments and databases using Rapidclone
- Install, patch and maintain Oracle Applications
- Implementation of RMAN solutions for database backups with Veritas Netbackup, Tivoli TSM and Netbackup Proxy Copy
- RMAN database duplication
- Designed and implemented both disaster recovery and backup/recovery procedures
- Installed and configured 11Gr2, 10G and 9i OEM for database monitoring and event notification
- Configuration of Metrics Server load balancing for E-Suite Web/Forms servers
- Created both logical and physical design of databases up to 30Tb
- Migrated database volumes from internal storage to EMC Symmetrix
- Performed Oracle database installations, patching and upgrades up to version 12c
PROFESSIONAL EXPERIENCE:
PostgreSQL & Cassandra DBA
Confidential, Atlanta, GA
Responsibilities:
- DBA supporting Production, QA and Dev databases for a persistent data-protection service that allows distributed data protection for enterprise documents so only those intended can access the data and decrypt it. Database technologies used are PostgeSQL 9.4, Cassandra 5, Mongod and MySQL.
Lead Oracle & PostgreSQL DBA
Confidential, Itasca, IL
Responsibilities:
- Lead Oracle DBA supporting Card Not Present Fraud Prevention platform running Oracle 11g on RHEL servers. Extremely high transaction rate applications running on large Oracle DB’s( 20+ tb). Databases severs are configured on ASM using 100% flash storage. High availability achieved via the use of Oracle Dataguard. Extensive use of Oracle Goldengate
- Backups are performed using RMAN. Monitoring is done using OEM, Ignite and Check MK. Lead PostresSQL DBA in charge of migrating Oracle databases to PostgreSQL 9.4. The goal of this initiative is to reduce Oracle licensing costs while maintaining the integrity and response time of the databases. Install, configure and maintain all PostgreSQL databases up to 11Tb in size.
Oracle Apps DBA
Confidential, Chicago, Illinois
Responsibilities:
- Oracle Applications DBA supporting EBS R12 running on a multi-node environment consisting of a 4 node RAC database, 5 tiered Forms & Web, and 2 tiered Concurrent Manager. Upgrade Hyperion EPM System from version 11.1.2.1 to 11.1.2.3. Implemented Hyperion, FDM and DRM. Provide database support for all Oracle products used by CPS.
Oracle Apps DBA
Confidential, Chicago, Illinois
Responsibilities:
- Supported, cloned and patched Oracle EBS R12 and 11.10 running on RHEL. Implemented Dell STAT 5.6.4. as well as taking on STAT Administrator duties. Provided backup support on Oracle Hyperion.
Lead Oracle Apps DBA
Confidential, Northbrook, Illinois
Responsibilities:
- Lead DBA for both Oracle and SQL Server Technical Lead for R12.1.3 re-implementation of EBS using ExaData and ExaLogic appliances. Install, maintain, patch, backup/recover and clone all instances of an Oracle R12 & 11.5.10 EBS implementation running on a multi-tire Solaris and LINUX environments. Support R12.1 and 11G database for Dev, Patch, Stage and Production. Additional Oracle products include SEIBEL, SOA, Agile, Hyperion 11g OEM. Responsible for over 150 Oracle databases and over 50 SQL Server instances.
Lead Oracle Apps DBA
Confidential, Chicago, Illinois
Responsibilities:
- Duties include: Install, maintain, patch, backup/recover and clone all instances of an Oracle R12 EBS implementation running on a multi-tire LINUX environment. Support R12.1 and 11G database for Dev, Patch, Stage and Production. Additional Oracle products include SSO, OID, Discoverer, and 170 Systems.
Lead Oracle DBA
Confidential, Schaumburg, Illinois
Responsibilities:
- Responsible for all logical, physical layout and configurations for multi-terabyte production databases. Project lead for migration of the datacenter to a new hosting company. Installation and configuration of Equallogics SAN devices.
Senior Oracle Applications DBA
Confidential, Oak Brook Terrace, Illinois
Responsibilities:
- Oracle Application DBA providing managed DBA Services support on Oracle E-Suite 11.5.10.2 instances running on a 2 node RAC’d database configuration running on Red Hat Linux Release 3.
- Oracle DBA and Oracle Application DBA consultant: supporting, patching and installing PeopleSoft release 8 and Oracle EBS 11.5.10 for various customers.
Senior Oracle Applications DBA
Confidential, Chicago, Illinois
Responsibilities:
- Installed, cloned and maintained Oracle Applications version 11.5.9 on both RAC’d muilt-node environments as well as single environments. Created RMAN backup strategy for all Oracle Application, third party and supporting databases. All RAC’d databases are backed up using Veritas Netbackup Proxy Copy. Creation and maintenance of RAC’d databases used for both Oracle Applications and supporting applications. Installation and configuration of 10G OEM Management Agent and creation of both database and host based monitoring.
Senior Oracle Applications Database Administrator
Confidential, Chicago, Illinois
Responsibilities:
- Installed Oracle E-Suite in a multi-node configuration using Rapidwiz. Cloned instances from single node to multi-node and multi-node to multi-node.. Configuration of Metrics load balancing on Production, User Acceptance, and QA instances. Installed and upgraded all Oracle database environments. Configured, tested and implemented backup/recovery solutions using RMAN with Tivoli TSM. Installation and configuration of Oracle Discoverer on a cloned production environment node used for report purposes only.
Database Administrator
Confidential, Chicago Illinois
Responsibilities:
- Database maintenance, backup/recovery, disaster recover and implementation of application upgrades. Database maintenance, backup/recovery and disaster recovery for Cerner Millenium clinical applications. Responsibilities included: installation and configuration of RMAN for database backups, cloning of databases from production to test and development servers, migration of current database server environment to a clustered Alpha GS160’s, configuration and set up of Oracle Parallel Server database environment for automate failover. Designed and implemented ETL procedures using SQL*LDR in order to expedite application upgrade of a Lawson environment.
Database Administrator
Confidential, Chicago, Illinois
Responsibilities:
- Designed, tested and implemented full disaster recovery procedures for a proprietary telecommunications database. Created and supported development, quality assurance and production databases. Migrated environments from development to QA and into production.. Sun Solaris environment uses external Hitachi SANS disk storage. Designed and laid out database storage on both the Hitachi and SUN A5200 external storage.
Senior Oracle Database Administrator
Confidential, Chicago, Ilinois
Responsibilities:
- Provided consulting services for a wide variety of clients covering all aspects of Oracle database creation and support. Installation of the Oracle Enterprise Edition software on various platforms, including Solaris, Windows NT, Windows 2000, and LINUX. Designed, tested and the implementation of backup and recovery procedures. RMAN and Oracle Enterprise Manager installation and configuration.
Manager Oracle DBA
Confidential, Chicago Illinois
Responsibilities:
- Snapshot replication was used to provide data consistency and security in six databases located in California, Illinois and Virginia with the master site located in Chicago; databases ranged in size from 5 to 75 Gb. Installed and configured Oracle products, created backup/recovery procedures, understanding of business requirements, migrated code from development to QA and into production. Managed a team of 4 DBA’s and 1 database architect and conducted performance reviews.
Oracle DBA
Confidential, Chicago, Illinois
Responsibilities:
- Oracle DBA responsible for Production and Development databases in a 24x7 environment. System Manager for a three node DEC Alpha Cluster, composed of two ALPHA 8400’s and one ALPHA 2100 as well as a standalone Alpha 4100. Technical Team Leader for the Cerner CIS/OCF project for a team of seven.