SUMMARY:

Confidential has attained a broad skill set with 20+ years of IT experience, which includes Oracle Database Administration, Oracle Fusion Middleware Administration, development and UNIX systems administration. His adaptability and knowledge make him a successful member of any team.

TECHNICAL SKILLS:

Databases: Oracle 7.3.4 to 11.2.0, MySQL, DB2 UDB 9.6 and 10.1.

Middleware: Oracle Fusion Middleware 10g, 11g & 12c, Oracle Forms & Reports 10g & 11g

Languages: PL/SQL, Perl, Python, Shell scripting, Java, Groovy

O/S: Red Hat Enterprise Linux, Solaris, Windows 10, Windows Server, AIX

Software: Oracle Enterprise Manager, Oracle GRID 11g & 12c, MS Office, Apache, Secure Shell, Tomcat, Git, CA Service Desk, Kedit, Splunk, Giteye, RapidSQL, Confidential Change Data Capture, Eclipse, Jenkins

PROFESSIONAL EXPERIENCE:

Middleware Engineer

Confidential, Gaithersburg, MD

Responsibilities:

• Run Oracle T2P scripts: copyBinary/pasteBinary and copyConfig/pasteConfig
• Open Oracle SRs for errors in the T2P process, apply patches/fixes as necessary.
• Document process for Customer.
• Configure and validate configurations for complete environment. F5, OHS, WebGates, WebLogic Domains and Data - sources.
• Configure SSL. Setup certificate stores and configure WebLogic Domains and Node Manager for SSL.
• Open Change Requests as necessary.
• Validate and apply Oracle patches. One-off and CPU patches.
• Reviewed and made recommendations to OHS configutation.

Middleware Engineer

Confidential, McLean, VA

Responsibilities:

• Deploy applications to lower environments.
• Create and maintain Maven Profiles.
• Promote code for deployments.
• Configure new instances of WebLogic for lower environments; security realms, data-sources, JMS queues, clusters ect.
• Create/modify Jenkins pipeline jobs for deployments using groovy.
• Configure Jenkins jobs for Sonar scans and JUnit tests.
• Creating AD accounts for databases, mainframe and Linux servers.
• Managing CDC Subscriptions; starting, stopping and helping to debug issues.
• Creating Mainframe IBMGroups and profiles to conform with security standards.
• Creating new DB schemas using db2look in lower environments.
• Creating tickets and deployment guides for higher environments.
• Creating tickets and necessary documentation for PROD deployments.
• Assisting testing teams with creating Mainframe accounts.
• Liaison between developer/testers and Admin teams (DBA, Unix, WebLogic)
• Facilitate high priority issues.

Senior Oracle Fusion Middleware Administrator

Confidential

Responsibilities:

• Deploy and Document new verstion of RMST software to Pre-Production environment.
• Deploy new/upgrade applications in 10g, 11g and 12c Oracle Fusion Middleware environments.
• Create new 12c weblogic container for FDA developers.
• Document the installation procedure for installing Oracle Fusion Middleware 12cR2 for the Middleware Deployment Team.
• Document new features of 12cR2 WebLogic and Oracle HTTP Server for the Middleware Deployment Team.
• Created default OHS httpd.conf configuration for 12cR2 environment.

Senior Web/App Server Administrator

Confidential

Responsibilities:

• Created, configured, documented and tested new WebLogic Server installs.
• Redesigned existing WebLogic 11g environments.
• Designed and configured new 24/7 WebLogic environments for an Application with ~3 million transactions per day and expected to grow to 9 million
• Maintained 12 different environments in two locations running WebLogic and Oracle HTTP Server on ~1500 physical and virtual servers.
• Reviewed new projects as part of the Project Engineering Team.
• Resolved performance issues and bugs by working with developers and testing configuration changes.
• Configured GRID 12c for WebLogic environment.
• Installed and Configured Oracle WebCenter Content 11g.
• Key member for the migration of a data center from one location to another, including creating a whole new failover environment for the data center move.
• Achieved a reduction in the number of outages and downtime by implementing changes to the application infrastructure.
• Performance tuning for data-sources and JVMs.
• Installed, configured, patched, and upgraded Oracle Fusion Middleware. (10gR2 - 11gR1)
• Created OC4J containers/managed servers and deployed applications. (10gR2 - 11gR1)
• Created and installed PKI certificates
• Installed and upgraded Oracle Forms & Reports and Discoverer from 9i to 10gR2 to 11g
• Installed and upgraded Tomcat versions 5 and 6 for IAVA compliance
• Wrote 11g middle tier init scripts in python
• Installed and configured Cognos 8.4
• Configured and tested mod security 1.9 with Oracle 10gR3 Web Tier.
• Created and upgraded RCU accounts.
• Designed and implemented new web configuration for 11g Web Tier supporting ~300 applications in Production

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Performance tune, size and monitor Oracle production databases
• Back up Oracle Database; create and document Oracle Backup and Recovery procedures
• Install, create and patch Oracle 9i databases
• Load DBIDS software on Symbol PDAs
• Identified software bugs and suggested fixes to the development team.
• Develop plan and scripts to migrate databases from 3 different countries to one regional database
• Identified differences between databases and versions of DBIDS software
• Train customers on DBIDS software
• Create and modify Law Enforcement reports for customers using Crystal Reports 9
• Investigate and report data issues
• Setup and install DBIDS workstations; setup and configure DBIDS gate systems
• Trouble shoot PDAs for gate systems
• Run ABIS reports for Senior Confidential officials; created perl script to help automate reporting process
• Trouble shoot hardware and software for customers and assist in network trouble shooting
• Upload and Download BFC transactions using IIS ftp server
• Train new team members on DBIDS software and hardware
• Lock down Windows 2000 Sever using DISA Gold Disk

Confidential, Washington, DC

Production DBA

Responsibilities:

• Create and install new production and development databases
• Upgrade Oracle Software; apply Oracle CPU patches
• Monitor space usage and maintain SLA
• Monitor Oracle Database backups and production Standby Databases.
• Set up Oracle Data Guard configuration
• Monitor daily and weekly ftp processes
• Provide customer account maintenance including creating user accounts, adding/removing privileges
• Assist customers with database standards and review installation procedures; advise customer on Standard Oracle Practices and assist customers with writing SQL queries
• Assist in ATF year end processing by running and updating scripts to update the tax year for the National Special Occupation Tax
• Attend Data Management meetings as a representative of the production Oracle team; perform DBA on-call duties as scheduled

Senior Oracle Database Administrator / Developer

Confidential, Arlington, VA

Responsibilities:

• Data Mining monthly data from vendors to check for anomalies and to verify accuracy of data
• Setup and tested secure web access based on CAC Cards(Smart Cards)
• Installed and configured Oracle 9i Data Guard
• Installed and maintained Apache Web server 2.0 with SSL, multiple IPs and Virtual Hosts
• Designed and created a database and implemented security requirements which included:
• Network encryption
• Auditing
• User Accountability
• Creating accounts for the oracle software
• Creating reports to review the audit data
• Password policy to match computer login policy
• Web Development using Macromedia Dreamweaver MX 2004
• Maintain and patch the ColdFusion Application server
• Wrote Perl Scripts to load monthly data
• Made necessary changes to Operating System file permissions to comply with Security Guidelines
• Assisted other groups in the installation of Oracle Software and creation of Oracle Databases

Senior Oracle Database Administrator / Developer

Confidential, Silver Spring, MD

Responsibilities:

• Design and implement backup and disaster recovery procedures in a SAN environment
• Implement Oracle Database Security according to FIPS-140 Standards,
• Apply Virtual Private Database, Oracle Label Security and network encryption using Net8
• Redesign Oracle databases. Tuning of Oracle Databases using Oracle Stats Pack
• Install and tuning Oracle 6i Forms Server
• Trouble shooting Oracle Forms application
• Redesign Application Security to conform with FIPS Standards
• Assume role of Director of Database Management System
• Install and configuration of Oracle RAC
• Implement coding and database standards and source control for database and Oracle Forms application
• Trouble shooting customer issues
• Assist Network team with redesign of network
• Design and implement setup of Production, Development and Testing environments

Oracle DBA / Developer /Unix Systems Administrator

Confidential, Tampa, FL

Responsibilities:

• Designed, developed and implemented the physical and logical Database design for an operational data store
• Responsible for the administration and migration of existing production and development databases
• Support Oracle Financials underlying databases
• Set up multiple development and test environments for Oracle Financial modules Release 11i with Oracle database release 8i
• Analyzed databases, applications, and servers for performance bottlenecks
• Tuned and reorganized databases, applications and servers as necessary
• Designed, tested and implemented the Backup and Recovery scripts and procedures for all oracle databases in a 24x7 availability environment (disaster recovery)
• Developed procedures and scripts to support Oracle Financials implementation, testing and troubleshooting
• Lead a team of developers, designers and IT managers in the analysis and redesign of main production database and custom data entry application
• Designed and implemented a Multi-Master Replication site for a web-based data entry application, a data store and a public records web site
• Designed and implemented the use of partitioning on key tables to increase performance
• Optimized SQL statements by implementing parallel query to decrease retrieval time
• Analyzed and implemented the use of bitmap indexes and function based indexes to increase performance for a public records web site
• Supported development and migration of data entry application using Forms 5 from client/server based to web based application using Forms 6i
• Developed, modified, debugged new forms, object groups, and object libraries, wrote PL/SQL triggers, functions, and procedures for a custom data entry application using Oracle Forms Builder 6i in a team environment from specifications
• Designed and developed complex queries and procedures using SQL and PL/SQL
• Tuned complex SQL statements and debugged PL/SQL packages
• Installed XML Developers Kit and documented process for future installations
• Installed and configured InterMedia to use images in a custom Oracle Forms application
• Implemented the installation and configuration of the 9iAS on Windows NT and Windows 2000. Responsible for all aspects of the install from research to physical installation and documentation of process
• Upgraded 8i databases to 9i.
• Creation of user accounts, installation of new software, insuring all software is patched and up to date, capacity planning, and automation of day-to-day processes
• System security: reviewing and documenting current user accounts and password policies, researching and testing security software and making purchasing recommendations
• Lead the installation of Red Hat 7, Suse 6.4 and 7.2 on testing systems along with the installation of Cold Fusion 4.5, Apache web server and Oracle 8.1.7(8i)
• Analyzed requirements and made recommendations for production hardware for a fail-safe environment.
• Designed, tested, implemented and documented the Disaster Recovery procedure for all Oracle Databases and Unix servers. Using a perl script to manager the Hot Backup of the oracle databases, compressing and purging of archived redo logs, and incremental backup of the server
• Installed and configured Tripwire for product evaluation

Oracle DBA / Software Test Engineer

Confidential, Rohnert Park, CA

Responsibilities:

• Aided Developers by performing PL/SQL code reviews for an Oracle Forms Application.
• Made PL/SQL code changes based on testing results
• Responsible for the physical and logical database design and capacity planning for all databases
• Supported the development staff in designing and administrating development databases.
• Supported customers on security, backup and recovery, troubleshooting and new technologies
• Documented procedures for Backup and Recovery for customers
• Performance tuning of Oracle databases
• Responsible for hardware recommendations for Sales staff and existing customers.
• Developed test requirements, test plans, test matrices for various components of the product
• Executed test plans against incremental builds as well as release candidate builds.
• Reported interim and production release test results and provided rapid feedback on the overall quality to the Director of System Verification Testing
• Worked closely with development engineers to help identify and isolate problem areas in the product
• Responsible for training new employees on how to setup, maintain and test product
• Actively participated in the development of a variety of test suites including functional, regression, stress/load
• Developed perl programs to automate software testing to minimize testing time and increase accuracy of tests
• Created Awk scripts to automate testing results
• Configured, set up and maintained test configurations during various testing cycles
• Created high quality bug reports and tracked bugs from submission to closure