Senior It Architect Resume
Jacksonville, FL
SUMMARY:
- Over 25 DBA/Developer/Database design/Database Architect/System Admin experience
- 10 years Oracle RAC 10gR2 RAC 10.2.0.3/4/5 , 11gR2 RAC 11.2.0.3/4,12cR1 RAC 12.1.0.1/2
- 4 years Oracle GoldenGate 10g, 11g implementation and support.
- 5 years Oracle E - business Suite technical implementation and Support. Oracle E-business 11i, R12.1/12.2
- 3 years Oracle Application Server 10g, Oracle Weblogic 10g,11g,, Oracle GlassFish 10.
- Oracle Data Guard 10g,11g,12c, RMAN 8i,9i,10g, 11g. 12c. OEM Grid 10g,11g, Cloud 12c
- SQL Server 2008 DBA, Informix DBA, MySQL5 DBASoftware Development - SQL, PLSQL, C/C++, Java, UNIX Shell
- UNIX - Sun Solaris, IBM AIX, OpenVMS, Windows Server NT, 2000, 2008, 2012.
WORK HISTORY:
Confidential, Jacksonville, FL
Senior IT Architect
Responsibilities:
- Architected/Installed/Configured Multi-node Oracle EBS 12.2.6//PCP/Oracle 12cR1/Oracle Linux 6 in the MS Azure Cloud - 4 instances SIT/QA2/UAT/PROD, Non-shared FS/APPL TOP.
- Installed/Configured Oracle SOA 12c instances and integration with the EBS R12 in all instances for SOAP web services invocation from the front-end business customer applications.
- Implemented Oracle Transparent Data Encryption (TDE) in Oracle EBS 12.2.6/4-node app tier in PROD instance as a security data privacy measure for data at rest and backup archives.
- Performed periodic EBS instance cloning and database refreshes.
- Performed quarterly PSU/CPU/ patches on Oracle Database 12cR1/Oracle EBS 12.2/SOA 12c/OEM
- Implemented Flexagon FlexDeploy 4.5/Oracle 12cR1/Apache Tomcat 8.5 for EBS customizations/artifacts deployments to support all the EBS instances.
- Installed multi-OMS/LBR OEM 13cR2 to support 8 EBS/Oracle instances for EBS environ monitoring
- Implemented Oracle Audit Vault Database Firewall 12.2.0.8 with AVS/DFW resiliency for DB/system auditing.
- Performed EBS deployments with FlexDeploy, upgrades and SOAP webservices support.
- Provided DB Advisory Admin support to EBS developers, business users and internal auditors.
Environment: Oracle EBS 12.2.6, 12.1.3, Oracle SOA 12.2.1.2.0 Oracle EBS Adapter 12.2.1.0, Oracle FMW Web tier 12.2.1.2.0 Oracle Database 12cR1,11gR2, Oracle Enterprise Linux 6.8/6.9, OEM Cloud Control 13cR2, Flexagon FlexDeply 4.5, Oracle AuditVault and Database Firewall 12.2.0.8, Oracle Database Vault 12cR1
Confidential, Atlanta, GA
Senior Oracle DBA
Responsibilities:
- Oracle Database Installation, Database Reorganization, Online Data Compression and Data Migrations. Database Refreshes across versions of Oracle binaries and across HW/OS platforms.
- Performance Tuning - SQL queries Baselines migrations, and Query execution cost improvements.
- Performed Oracle Database RAC 10g to 11g Database Migrations and Upgrades.
- Implemented with Oracle Data Guard 11g a production reporting database as standby databases
- Performed Oracle Patching, Database Refreshes, Health Checks, OEM Target Integrations
- Production Oracle Support for Oracle UCM/DIS System (VLDB +32 TB) and 7 other Business Applications.
- Performed Online DB Reorganization -Partitioning, Compression, De-duplication ) - Reduction of disk space usage.
- Performed a massive data upload into the test/production database using scripted Oracle SQL Loader with intensive data validations.
- Planning Oracle ILM- ADO/Heat Map implementation on VLDB (Oracle UCM/DS DIS).’
Environment: Oracle Database 10gR2,11g2, 11gr2 RAC, 12c1,12c1 RAC/ASM on Solaris 10, Oracle Enterprise Linux 4, 5, Windows Server 2008, Toad, SQL Developer, Spotlight, OEM Grid/Cloud Control.
Confidential, Charlotte, NC
Senior Oracle DBA
Responsibilities:
- Performed many Oracle Database refreshes using Oracle RMAN 10g, 11g, and Oracle Datapump 10g,11g
- Data Management - migrations/refreshes/partition maintenance of very large databases (VLDB).
- Replication and maintenance with Oracle Data Guard and GoldenGate on several databases, etc.
- Upgraded Oracle Database 10g to Oracle Database RAC 11g for a critical application in a single night.
- Installed, configured and supported Oracle GoldenGate 10g, 11g with Oracle Database 10g and RAC 11g
- Solely responsible for DBA support on 8 applications including some VLDBs of 6 TB and 80 TB.
- Database Administration - implementation, maintenance and support including upgrades, patching, and performance tuning as project/development and production support DBA.
- Shell/PLSQL development and Oracle support on several projects and live production systems.
Environment: Oracle Database RAC/ASM 10.2.0.4, 11gr2, RAC One-Node 11gR2 on IBM AIX 6.2, RedHat Linux 4, Oracle GoldenGate 10g, 11g, RMAN, Oracle CDC, SQL Developer, Oracle Data Guard, OEM Grid/Cloud Control 11g, 12c, Oracle Gateway for SQL Server 11g, MS Project.
Independent Oracle Consultant
Confidential, CA
Responsibilities:
- Installation, configuration and upgrade of Oracle Database 11gR2 RAC OneNode with 2 nodes server pool.
- Integration of Oracle Enterprise Manager Database Control 11g with Tivoli Enterprise Control - Forwarding SNMP traps to Tivoli EC.
- Replication of Database Schema tables between SQL Server 2008 database instances and a central Oracle Database 10gR2 and between Oracle Databases using Oracle Golden Gate 10g within the local bank site.
- Demonstration of Oracle Database 11gR2 RAC OneNode in a Virtual Infrastructure environment Oracle VM Server 2.1 servers and administered with Oracle VM Manager both running in 3 Linux virtual machines (VM) in a 8-processor, 64Gb RAM Windows Servers 2008 R2 (Hyper-V).
Confidential, Atlanta, GA
Manager, Lead Oracle DBA
Systems Used/ Supported: Oracle Database 10g RAC, Oracle 11g RAC, Oracle WebLogic Suite 11g, Oracle Application Server 10g, Oracle Reports Services, Oracle Beehive 1.3,1.5, Oracle Enterprise Linux 5 (32/64-bit), Oracle JDeveloper 10g, 11g, Oracle DataPump, OCFS2, NFS, ASM, OEM Grid Control 10g3,4,5, 11gOracle Data Guard, Advanced Replication, Oracle GoldenGate 10g, MS Project.
Responsibilities:
- Installed, configured and supported Oracle Database 10g RAC 10.2.0.3, 4 and Oracle RAC 11gR1 (3-node clusters) in development, QA and production environments.
- Upgraded and patched many instances of Oracle 10g (10.2.0.3) RAC to Oracle 10g RAC (10.2.0.4), Oracle 10g RAC to Oracle 11g RAC (11.1.0.7), (3 -node RAC Cluster). Cluster Homes, Oracle Homes, ASM Homes, Database.
- Implemented Oracle Audit Vault/Database Vault in Dev. and Prod. Environments.
- Enhanced and implemented Oracle RMAN / Veritas NetBackup Backup Recovery Scripting for development, QA, QAC, production environments.
- Led the implementation of Oracle Data Guard (Physical Standby) for Disaster Recovery and Business Continuity between two site locations.
- Implemented/Supported Oracle GoldenGate 10g, GoldenGate Director and Veridata for sets of table data replication across Oracle Databases.
- Led in the implementation of Oracle Application Server (OAS) 10g in dev, QA, cert/gold, and production environments using the OHS, OC4J, Portal, OID/Single-Sign-On.
- Web/java application deployments on Oracle WebLogic servers and OAS 10g servers.
- Implemented Windows Automatic Login with SSPNEGO for an Oracle ADF application deployed on a 3-node clustered Oracle WebLogic Servers running on Oracle Enterprise Linux.
- Led the implementation, configuration, upgrade and support of Oracle WebLogic 11g in cluster configurations in development, QA and production environments, and integration with MS Active Directory, OID, ADF.
- Led the implementation of Oracle Beehive 1.3,1.5 and integration with OID and MS Exchange Servers.
- Installed, configured Oracle APEX, APEX Listener and BI Publisher on Clustered Oracle WebLogic servers with integration with MS AD.
- Provided support for schema and application code changes and deployments and SQL query performance tuning and advisory on database object definitions and capacity planning.
- Supervised/mentored 2 Staff Oracle DBAs/Application Server DBA and worked with Developers/Analysts.
Confidential, Atlanta, GA
IT Manager /Lead Snr. Oracle Application DBA
Systems Used/ Supported: Oracle E-Business Suite 11i (11.5.10.2) x 7 instances with 350 users access nation-wide on the Production Oracle Database 10.2.0, 10.1.0 (RAC/ASM. OCFS2, Oracle Application Server 10g, Oracle Forms/Report Server 6i, Oracle Discoverer 10g Server, Red Hat Linux Enterprise/Advanced Servers 4 (32-bit), 7 Oracle 10.2.0, 10.1.0 (RAC) Servers., Perl, XML Publisher, Oracle Internet Directory, Oracle Data Guard, DataPump, Oracle Enterprise Grid, RMAN, Toad, Discoverer Admin, Plus/Viewer. Veritas NetBackup, MS Project, MS SQL Server 2000/2005.
Responsibilities:
- Responsible for the Oracle E-business technical environment and manage outsource service provider, by delivering the following:
- Oracle Applications 11i administration and management.
- Oracle database administration and data management.
- Oracle Discoverer Administration and Support.
- Red Hat Linux ES System administration
- DBA Support to Java, PLSQL developers and BI / DW reports developers.
- Provided technical support for the Oracle Application 11i databases and Red Hat Linux servers.
- Streamlined Oracle Application 11i maintenance process, patching schedules and researches.
- Implemented Oracle XML Publisher or BI Publisher with Oracle App s 11i for financial reporting.
- Oracle RMAN Backup and Recovery Scripting for development, QA, cert, production databases.
- Performed Oracle Apps 11i upgrades, patching and cloning biweekly for project development.
- Performed Discoverer Patching, and upgrades and provided support also with Discoverer Admin.
- Incorporated Veritas NetBackup Oracle Agent into the corporate database backup strategy.
- Implemented of Oracle Workflow Notifications, Oracle iExpense module and DataLoader for uploading formatted data into Oracle Apps 11i Assets, etc.
- Implemented a SOX compliance plan at the Oracle EBS, database, application and Linux OS levels.
- Designed and implemented disaster recovery plan and implementation.
- Provided Oracle and SQL Server integration support.
- Managed other 3 contractor/DBAs remote and UNIX Administrator.
Confidential, Alpharetta, GA
Senior DBA Developer
Systems Used/Supported: Oracle Database 10g 10.2.0, 10.1.0, Oracle 9.2.0, Oracle Internet Directory (OID)Sun Solaris 6, 8, 9, Red Hat Linux Advanced Server 4, SuSE Linux 9, MS SQL Server 2005 Streams Advanced Queues Processing, Oracle Advanced Replication, Ksh, PLSQL Developer, Data Guard Manager, Oracle Enterprise Manager 9i, RMAN, MicroStrategy 7.1, MS Project, MS Visio.
Responsibilities:
- Daily operational production database support, change management, research and testing for new Oracle technologies.
- Implemented project to enhance database availability and performance of Production databases.
- Migration and Implementation of new production databases in RedHat Linux from Sun Solaris.
- Managed the integration of Oracle Data Warehouse with MicroStrategy 7.
- Performed Oracle database upgrades and patched applications modules.
- Implemented Oracle Data Guard for Production and QA databases for high availability
- Performed new development and enhancement of business application stored procedures in PL/SQL.
- Performed planning and implementation of RMAN for production/QA/test databases.
- Managed the Oracle multi-master replication for production databases.
- Managed VOIP Data Warehouse Project and the Data Modeling tasks.
- Technically supervised the contractors on the VOIP Data Warehouse Project.
Confidential, Nashville, TN
Oracle DBA
Systems Used/ Supported: Oracle Database 10gR1,R2, Oracle Database 9.2.0, Oracle Database 8.1.7, Oracle Client 8,9,10g, ToadOracle Enterprise Manager 10g Grid Control, RMAN, Veritas NetBackup, Korn shell scriptingODBC, JDBC, MySQL Databases, IBM AIX 5L, Sun Solaris 8, 9, Red Hat Linux
Responsibilities:
- Performed Oracle Database 10gRAC installations and support. (3-node clusters)/Oracle ASM instances
- Performed of migration of non-RAC Oracle instances to Oracle RAC instances, and non-ASM-enabled databases to ASM-enabled databases.
- Performed many Data and Database Refreshes with DataPump and RMAN database recovery.
- Performed Oracle Databases Migration from Sun Solaris to IBM AIX.
- Supported a couple of Database Multi-master Replication (MMR) across two site locations.
- Performed Database Performance Tuning assisted with Statspack, OEM.
- Developed and Implemented a new parameterized RMAN/Korn shell script for backing up Oracle Databases 8i, 9i and10g databases with Veritas NetBackup MMS.
- Performed many Oracle Databases patches and Upgrades. Oracle Databases 8i to 9i and 9i to 10g.
- Installed, configured, and supported Oracle Databases 9i, 10g and Oracle Client 9.x on IBM AIX5L, Sun Solaris.
- Installed, and managed 6 MySQL environments on Red Hat Linux, Solaris.
- Provided after hours/Weekend Database Maintenance and Change/Production Support.
Confidential
Principal DBA
Systems Used/ Supported: Oracle 8i Servers for Windows Servers 2000, IBM Netfinity AIX Servers. Windows Servers Sun MicroSystems SunFire Sparc Servers, Solaris 7, 8, IBM Informix IDS 9.40, IDS 9.30UC7, CCOBOL, Perl, Ksh, expect. IDS 9.21UC7, IDS 7.3, Informix ACE, Informix HDR, Informix ERTivoli TMS, TDP for Informix, Veritas NetBackup, TSM, Tivoli TDP for Informix.
Responsibilities:
- Daily responsible database administration, supporting 35 UNIX servers running Solaris and all together 46 databases (production / test / development) databases. (Database with average size of 90 gigabytes, the largest database size of 350 gigabytes).
- Conducted installation, configuration and support of Oracle Databases and Informix databases.
- Responsible for ongoing support and administration of the production, testing, training and archive databases.
- Conducted Solaris network configuration for distributed processing environments on 3 shared database instances and one application code server for business application code modules.
- Developed a suite of database health checks scripts and performed regular DB health checks.
- Conducted capacity planning for all databases and growth planning.
- Allocated system storage and plan for future storage requirements for the database system.
- Coded stored procedures, triggers, functions in Informix SPL and developed ACE reports for management reports.
- Configured and Implemented backups and restores/imported restores using Informix Onbar/Veritas NetBackup.
- Installed and configured Informix HDR (High-Availability Data Replication) databases for application fail-over.
- Provide database connectivity support (ODBC/JDBC) for Java applets and applications.
- Developed suite of functions to ease the task of configuring, maintaining and monitoring the ER environment.
- Developed Informix 4GL modules for performing data entry and reports generation.
- Provide technical resolution to Informix database related problems and vendor management.
- Supported korn-shell scripts for automating application module access, security, ftp-ing tasks, etc.
- Configured and Implemented Tivoli DP for Informix for database instance backups and restores.