Post Job Free

Resume

Sign in

Oracle Manager

Location:
Fort Worth, TX
Posted:
February 19, 2018

Contact this candidate

Resume:

Seasoned customer-focused success-driven professional with people skills, offering extensive experience in the information technology industry; encompassing database, middleware and systems administration, performance tuning, and shell scripting. Effective at providing technical support to arising issues, managing and maintaining various applications, and streamlining work processes. Armed with proven ability to fulfill multiple roles to support company objectives.

I possess a strong technical attitude able to quickly learn and apply skills with a proven capacity to work within fast-paced, highly stressed situations with emerging and multiple responsibilities. My current objective is to obtain a position that will utilize my skills and offer an opportunity for continued professional growth.

Technical Acumen

Databases

Oracle 6.x,7.x,8.x,9.x RAC, 10.x,11.x,12.x

SQL Server 4.0, 6.5, 7.0, 2005, 2008 R2, 2012 MongoDB 2.6, 3.2 Replication Sets

Middleware

WebLogic 6.x,7.x,8.x,9.x,10.x WebLogic Portal WebLogic Integration

Oracle Application Server 6i,9i,10g,10.3.x Fusion Middleware 11 Universal Content Management WebCenter Oracle Http SoftwareAG webMethods 9.7 SOA\ESB Tomcat IIS Apache Ngix

Tools

Oracle Enterprise Manager 9i,2.x Grid 10.x,11.x Cloud Control 12.x Oracle Developer 10g/2000/6.0 Oracle Forms 10g/6i/4.5 Reports 10g/6i/3.5 Toad for Oracle Toad for SQL Server Secured Shell Veritas NetBackup HP Omni Back II Tivoli NetWorker SQLServer Integration Services T-SQL SQLServer Performance Dashboard Reports SQLServer Performance Analyzer SQLServer Trace SQLServer Management Studio, Visual Studio BI BCP SQL Loader ERwin Microsoft Visio PVCS TKPROF Alkami WAF Http Watch NetMon Google Analytics Google Tag Manager Designer2000/10 SQL Plus PL/SQL SCOM MOM CVS Vi DBCA Microsoft Sysinternals Microsoft Office Suite Reflections Lynus Nmap ServiceNow Jenkins EM7 RMAN TKPROF PERFSTAT Quest Spotlight

Foglight Splunk McAfee Notepad++ Textpad Windows Failover Cluster Service WMIC

GitHub Microsoft Best Practice Analyzer NetScaler F5 BigIP PowerShell

Operating Systems

RHEL Linux AS/ES 3, 4.0, 6.x, 7.x CentOS 6.x, 7.x Ununtu 14 HPUX 11.i 11.0 SUN Solaris 8/9,

Windows NT 4.0 /2000/98/2002,2008,2010,2012 HITACHI SAN Cluster EMC Clarion CX700

EMC Symmetric Tru64, Suse Linux AIX 5.x,6.x,Netscaler,BigIP F5

Age-ing

Documentum 5.2 Cognos Hyperion Essbase EBS 11.5.10.2 SAP 4.6

Professional Development

Certifications

RedHat Certified Technician

NetScaler Certified Associate

ITIL® Foundation certified

Training

Oracle RDBMS Administration Training.

Oracle Developer 2000, 6i Training

Oracle Advanced PL\SQL courses

Stephen Feuerstine PL\SQL “Bible”

Oracle Java course.

SAP System Administration Training

BEA WLS, WLI, WLP Administration Training

Netscaler System Administration.

Cognos BI Administrator Training Courses

Oracle RAC Administration

Red hat Linux System Administration.

Hotsos Symposium, Oracle Internals

Microsoft Managing SQLServer Database Course.

Hyperion Essbase Administration Training.

Education

Coursework towards Associates in Computer Science

Tarrant County Junior College, Hurst, TX

Professional Experience

Greyhound Bus, Dallas, TX

Senior Middleware Admin, SQL DBA Oct-2015 Sep-2017

Served as member of the Datacenter Services Team, in charge of managing new and legacy middleware platform; coordinating and performing operational responsibilities for Linux, AIX and Windows platforms; supporting implementation of service-oriented architecture and enterprise server bus (SOA/ESB) of webMethods.

Implemented SQLServer maintenance plans for updating stale statistics, index defragmentation/rebuild, DBCC integrity checks for Clustered and non-clustered DB’s.

Lacking centralized management tool for SQLServer environments, Installed Microsoft SQLServer performance dashboard on critical DB’s for Instance level view to provide better management, troubleshooting, missing indexes and trending.

Implemented SQL Groups with mapping to AD groups to improve user provisioning, decommissioning.

Worked with Outsourcing vendor to resolve Cluster failover issues for SQL production clusters, vendor had miss configured LUN mappings within VMWare.

Provided build support for releases, deployment, troubleshooting, performance tuning, capacity planning, environment replication, operational support, certificate renewal, root cause analysis, and backup and recovery, performance monitoring.

Provided technical guidance and assistance to less experienced team members for SQLServer Linux Weblogic Bash.

Implemented Site Confidence for external site monitoring, capturing critical user paths for revenue applications, provided to vendor for monitoring.

Team unable to implement webMethods insight monitoring of ESB Integration Clusters; Vendor engineering unable to resolve, through diligent persistence troubleshooting I was able to diagnose root cause of Restful calls included unique GUID, I configured filtering and summary within tool allowing monitoring and resolved issue.

Assigned responsibility for MongoDB, quickly learned technology, upgraded production replication sets to 3.2 with WiredTiger and established equivalent lower environment by cloning production environment.

Assigned responsibility for Linux platform, established quarterly patching, scripted updates to security policies for password policy aging and expiration, restricted OS level access to privileged accounts, implemented proper file system layouts and communicated standards to vendors for future provisioning.

Addresses PCI/DSS compliance issues, removing weak ciphers, Java security across the enterprise, Linux/Windows

oTech: Windows Server 2012,2008,2003, SQLServer 2008,2012 clusters Active/Passive’ RHEL 6.x CentOS 7.x Bash Webmethods ESB 9.7,OneData 9.x, Integration Server, Gateway, Terracotta, Insight Monitoring, Java EE, WLS 8.x Tomcat IIS F5 Jenkins GitHub Sitecore 8.x, PowerShell, Nmap, Lynus, Spotlight On SQLServer, SQL Performance Dashboards, Google Analytics, Google Tag manager, Alkami WAF,DNS, Office 365 Excel analysis, Splunk POC. IIS- Apache WEB Log Analyzer.

Birlasoft (at Synchrony Financial), Dayton, OH

Middleware Administrator Nov-2014 Jul-2015

Member of cross-functional project team migrating e-commerce “payment solution” applications to new data centers supporting Synchrony separation from GE.

Presided over weekly meetings with off-shore application teams and outsourced infrastructure teams for issue management.

Employed keen attention to detail in monitoring infrastructure footprint

Operated in PMO methodologies covering: requirements, design, planning, construction and QA/UAT by providing and gathering necessary artifacts

oTech: Weblogic 8.x/ Oracle 11.2/IPlanet/ Solaris 10

KMM Technologies, Inc. (at OSHA), Sandy, UT

Senior Oracle Database Administrator Oct-2014 Nov-2014

For OSHA provided day-to-day support for development database environments, assisted with backlog of PL/SQL, re-wrote nightly batch interface for state compliance reporting, provided QA validation for functional testing of web application pre-prod deployments. SQL*Loader config to load external training data for online registrations for OSHA employees.

Tech: Oracle 11.2/Toad

Cash America International, Fort Worth, TX

Oracle/SQL Database Administrator Feb-2013 Jul-2014

Provided technical expertise for SQLServer and Oracle technologies to project and development teams.

Architecture review for database compliance to company standards and bringing awareness to vendor best practices.

CAB duties to review approve/reject production changes where risk of unscheduled outages or unexpected results are not mitigated through lifecycle process or reasonable testing completed with expected results.

Worked with development teams providing support for deployments, troubleshooting and performance tuning for VB, .Net applications Maintained SQL Reporting Services.

Provided guidance and assistance to less experienced team members in Oracle Linux/Unix environments.

Maintained SSIS packages supporting interfaces from Maximo to/from Lawson asset management and employee provisioning.

Stood up Microsoft Analysis Services environment for POC to replace Hyperion.

oTech: AIX:Linux,MSCS SQLServer 2008 R2/SQLserver 2008, Oracle 8.x,9.x,10,x 12.1, 12.c cloud control,Foglight

Rose International (at Verizon), Irving, TX

Middleware Administrator SQL Database Administrator Oracle Developer Feb-2012 Nov-2012

Executed daily duties which involved leading team members; handling offshore resources; and supporting the Six Sigma implementation

Created shell scripts to move log files off root file system associated with Apache, SiteMinder Web Agent, WLS plugin and apache rewrite logs, as well as bash shell scripts to streamline repetitive tasks and processes

Drove efforts in merging stored procedures into PL/SQL packages through functional areas

Addressed technical issues related to the execution of NetBackup for SQL server

Maintained application deployments, as well as start and stop procedures

Worked on Oracle databases and established backbone monitoring and associated charting/reporting in Gomez to develop metrics for baseline performance of geographic load balancing through Alkami

Delivered build and run support for corporate applications in multi-tiered and multi-datacenter environments for both production and non-production

Helped development teams in tuning or troubleshooting PL/SQL packages.

Succeeded in remediating security and vulnerability scan deficiencies by removing weak ciphers, modernizing certificates, and updating http to https where applications supported

Efficiently transported production clustered SQL Server databases to new datacenter by scripting process through automation and verification scripts

oTech: Oracle UCM 10.3, Webcenter 11, Siteminder, Apache, Apache rewrite, IBR, OBIEE, Linux,Windows 2008 R2,SQLServer 2005, SQLServer 2008 Webcenter 11, Alkami, Gomez, Http Watch, NetMon, Oracle 11.2, Oracle RAC 11.2, ASM, SCAN ., Linux, Windows 2008 R2, OVM, PL/SQL

Insight Global (at DynCorp), Fort Worth, TX

Senior Oracle/SQL Database Administrator Jun-2011 Dec-2011

Working at DynCorp as Sr. Oracle DBA duties included Solaris 10 System administration in addition to DB,

Storage consolidation from EMC CX400 to Left Hand,

successfully demonstrated performance gains in OLTP environment using SAME which was adopted as standard for OLTP.

Changed physical DB file layout taking advantage of SSD, replaced HBA’s and updated packages and firmware to supported levels.

I resolved lingering DR test recovery failures for Oracle DB’s

Removed parallel processing to improving stability for mixed OLAP/OLTP usage improving month-end close processing.

Performance tuning Cost Point application, assisted development team in re-writing custom PL/SQL modules post upgrade of financial applications.

oTech: Solaris 10 SPARC, Windows 2008 R2, Oracle RDBMS 11.2, 10.2, Grid 11.2

Alcon Laboratories, Fort Worth, TX

Oracle and SQL Server/Senior Systems Engineer Oct-2008 Mar-2011

As Sr Systems Engineer supporting corporate applications my responsibilities encompassed hardware, web, application and Oracle and SQLServer database tiers. Duties included operating system patching, backup and recovery, patch analysis and application, capacity planning, performance tuning, DR documentation and acting as liaison between infrastructure and applications.

Successfully planned, documented and executed Oracle CPU and upgraded two of the four databases dev, qa and production environments from version 9.2 to 10.2 supporting the IMANY software stack supporting pricing and contract compliance.

Successfully deployed Strohl's software for disaster recovery / business continuity project which was a requirement of the hosting provider for pre- production change validation.

Nominated and accepted to Alcon’s Oracle center of Excellence team.

Successfully sized and procured hardware to support Essbase upgrade and installed all vendor software in development and production.

Technical lead on project implementing global application adding workflow to AP purchase orders to JDE One World. Vendor contact for, coordinated various applications team and various infrastructure resources to successfully deploy solution.

Technical lead for the production upgrade of the Certus application used for SOX compliance. I was able to resolve many technical issues in-house allowing the project to be delivered on time and under budget.

oTech: SQLServer, IIS, Citrix,Cisco ACE load balancer, Control-M, Tivoli, Quest Spotlight, .Net), Essbase 11, SQLServer 2005, A, VMWare, Oracle on AIX, SQLServer 2005, Weblogic 8, IIS, Power builder, Control-M, MQ,

HealthMarkets, North Richland Hills, TX

Oracle Applications Database Administrator Linux Systems Administrator May-2007 Oct-2008

Responsible for the technical day to day health of Oracle E-business suite and related infrastructure.

Duties include operating system patching, backup and recovery, patch analysis and application, capacity planning, performance tuning, metric gathering and reporting.

Maintain Oracle Grid control environment, including Discoverer for reporting.

Addressed performance issues and HA requirements with implementation of shared APPL_TOP, shared application tier file system, moved DB storage to SAN and implemented load balancing at both the HTTP and Jserv layers additionally implemented SSL offloading., reduced downtime associated with patching and alleviated capacity issues for an improved end user experience.

Replaced Cold backups with RMAN hot backups increasing application availability.

Successfully recovered Oracle EBS during 24 hour recovery window.

EBS database tier in development, patch and QA to 10.2.0.3 from 9.2.0.7, planning Prod in fourth quarter 2008.

Provided user community and technical staff current patching levels across all environments, researched and applied patches

In addition to the above I was the Linux system administrator for all EBS servers.

Wrote custom vendor extracts supporting feeds\integrations.

LSG Sky Chefs, Irving, TX

Manager, Applications and Infrastructure Nov-2003 May-2007

As Manager Applications/Infrastructure responsible for the day to day operations and health of our Oracle stack, BEA environments and coordination with our infrastructure provider, Other duties and prior project work include capacity planning, server consolidation, instance Consolidation, designing Application Integration process, scoping, estimation, setup, migration, implementation, configuration and maintenance of entire Oracle Enterprise Application Databases, Application servers, Webservers.

Upgraded our 10g Grid Control from 10.1.0.2 to 10.1.0.5.

Replaced Cisco content switches used for application load balancing with Netscaler HA pair for Oracle and J2EE environments.

Technical lead working with Dell and Accenture on installation and configuration of J2EE and Oracle technologies.

Linux AS 3.0, Oracle 9i RAC, 9i/10g Application servers and 10G Grid OEM.

Setup, Upgraded, Migrated and managing 4 critical OLTP application databases to Oracle 9i RAC (Rel.2) HA environment

installed, configured Oracle 10G Grid Control for managing and monitoring Oracle databases and Application servers

Installed, configured and administered application servers Weblogic, Tomcat, Oracle 10G application server.

Deploying J2EE applications, Managing, Troubleshooting and Monitoring WebLogic 8.1/7.2

Managing various production oracle databases and 10g Application servers 24x7 support along with active projects.

Documented procedures for building and configuring webservers, set up sudo and permissions and Samba for W2k common shared server.

Database partition management, Archiving, Online Tuning, SQL Tuning, Perfstat and Periodic maintenance.

Performed various database Backup/Recovery using RMAN hot backups, RMAN Cloning.

shell scripts for

Performed various Export/Import techniques and Database refresh methods.

Automated custom monitor Shell scripts for database environments and Web Logic processes.

Maintenance and change process are followed by strict change management procedures and version management.

Planning to setup development, testing and QA environments for Oracle 10g database migration for our critical applications.

Engage and support developers during the SDLC and Working with programming teams developing Internet applications

Installation, Maintenance of Apache web server configurations, procuring and installing SSL certificates.

Responsible for maintaining and administrating PVCS/CVS version control software and building build scripts.

Responsible for documentation, knowledge transition and training of DBA support role to Accenture DBA's.

Worked with BEA on implementation of Weblogic Portal/Integration. WLP/WLI

Change Control Manager responsible for QA for any infrastructure/Application changes to production.

Installed ESSBASE analytics/application for ESSBASE development team.

oTech: Oracle 10g/ 9i RAC Rel2 / 8.1.7.4/8.1.6, Oracle 10G OEM Grid, Oracle 9i/10g Application Servers, RMAN, Oracle PL/SQL, SQL Loader, Unix Shell scripts,WebLogic 8.1/6.1/7.2,Redhat Linux AS/ES 3.0,,VERITAS NetBackup, Toad 8.6 for Oracle, Iplanet, Netscaler, Oracle

Accenture, Irving, TX

Information System (IS) Specialist Enterprise Database Administrator Jan-1999 Oct-2003

Involved in many database migrations, tuning process, Installation of various version Oracle database software, applying various patch sets and setup process. Worked with multiple software vendors to implementing their products into the LSG environment. Documenting installation, configuration and setup for team. Working on various development projects simultaneously with support responsibilities, designing the database and integration with other

applications.

SAP R3 4.6 implementation provided Oracle expertise for implementation and ongoing run support.

Successfully configured and implemented SAP R3/Omniback/Oracle integration and tested DR recovery scenarios.

Performed light Basis work, primary Oracle DBA maintaining DBA calendar and using SAPDBA to perform maintenance.

Participated on project team that moved entire data center from Arlington location to Infomart in Dallas.

Maintenance, sizing, installation and configuration of all Oracle databases and Oracle software.

Documented and transitioned LSG Sky Chefs DBA support role to Accenture DBA's providing support during transition.

Extensive work with applications development and support teams assisting with deployments and troubleshooting.

Implemented shell scripts for hot backups on servers not supporting HP OmniBack integration.

Payroll upgrade of Lawson Payroll system 7.3 to 8.0 which included DB migration from 8.1.7 to 9.2.0

Deployed multiple J2EE applications on Weblogic 6.1 and 7.2 in standalone, managed and cluster configurations.

Participated in on-call rotation for applications support and Oracle DBA.

Design and Create Database objects and help project teams with their Design and Development.

Setup various custom monitor Shell scripts and OEM for production databases and batch jobs status

Wrote Interfaces/scripts on application and database server Unix shell scripts, PL/SQL,SQL*Loader.

Documented installation, build processes, support procedures for Oracle database creation ongoing maintenance.

Upgraded multiple databases from 8.0.6/8.1.6 to 8.1.7 using export/import, DBCA 9i RAC

Oracle software installation, Setup, Patch updates in HPUX, SUN and W2K environments.

Capacity planning for all new and existing application databases.

Technical lead on Concur Expense Implementation, working with business users and vendors.

Database Partition management, Archiving, Online Tuning, SQL Tuning, Perfstat and Periodic maintenances

Responsible for Installation, configuration, administration of Cognos Software, Series 7 BI suite and report net, Implemented backups scripts for environment

Supported data warehouse environment for our Marketing department.

Responsible for SQLServer backup integration with Omniback and maintenance plans for exports.

Responsible for OEM monitoring/ job scheduling for Oracle environment.

oTech: Oracle 9i / 8.1.7.4 / 8.1.6 / 8.0.6, PL/SQL, SQL Loader, Unix,Shell scripts, Apache,IIS, W2K,XP,W98,W95, NT 4.0, OEM 2.2,SQLServer,2000/7.0,Documentum 5.2,Cognos Series 7/Report Net SAP R3, SAP DBA, MS Office, Concur Expense,BEA WLS Express for W2K, Solaris 6.1, 7.2, Tomcat

LSG Skychefs, Irving, TX

Programmer Analyst/ Jr. Oracle DBA Oct-1998 Dec-1999

Andersen Consulting, Irving, TX

Programmer Analyst Sep-1993 Dec-1998



Contact this candidate