We provide IT Staff Augmentation Services!

Oracle Consultant Resume

Washington, DC

TECHNICAL SKILLS:

Software: Oracle 12c/11g/10g/9i/8i/7, Oracle 11g Fusion Middleware, Oracle 9i/10g Application Server, Oracle iDS, PL/SQL, SQL*PLUS, SQL*NET, Oracle Enterprise Manager Grid, Oracle Application Expres(APEX), Oracle Designer, Oracle Developer, Oracle Lite, Oracle Workflow, Oracle Portal, Oracle Discoverer and 11i E - business Suite(11.5.x), Quest Central, Telecomm Business Solution(TBS), Veritas NetBackup, HP IT/O, HP Network Node Manager, MS Access, HP Omniback II, Seagate Backup Exec, BEA Tuxedo, Requirements Trace Manager(RTM), NetWare Network Directory Services(NDS), IA Workhorse, Emass Amass, Apache Web Server, Oracle Web Server, Microsoft and Corel Office Suite, Lotus CCMail, Teamlinks, HP Openmail, Infomark Maps & Demographics, Retail Tenant Directory, Claris Works, Statit, PerfView, Glance Plus, Cisco Works, Exceed, Remedy, administration and configuration of other COTS products.

Platforms: Sun Solaris 2.x, HP-UX 9.x/10.x/11.x, NetWare 3.x/4.x/5.x & SUSE, RedHat Linux, Windows NT 3.51/4 / 2000 / 2003 / 2008, Macintosh, Pathworks, NEXT, SCO Unix, WANG VS

Hardware: HP 9000(K460&K430), Sun E6500, Compaq ProLiant 7000R, IBM compatible PC’s, HP Optical Jukebox Server, Macintosh, laptops, CD-ROMS, scanners, network interface cards, printers, & modems

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Oracle Consultant

Responsibilities:

  • Oracle Consultant working at Confidential providing production, development and test support for all Oracle related software running on Windows and Linux platforms including applying quarterly CPU patches and version upgradesOracle Real Application Clustered (RAC) support and Oracle DataGuard support on both Windows and Linux platforms
  • Provide support for database security and configuration to comply with security requirements
  • Work with outside agencies in support of external projects related to data migrations and extraction
  • Oracle 11g Fusion Middleware administration including upgrading/migrating from 10gAS Portal, Forms, Reports, Discoverer and all administration, patching, upgrading in support of Fusion Middleware
  • Oracle 10gAS Administration for upgrades and maintenance for OPM’s Financial System built on Oracle Forms and Reports on the web
  • Custom 10gAS configuration including adding virtual hosts and modifying port numbers for Apache Server, configuring and administering Oracle Portal and Single Sign-On (SSO) and maintaining Oracle Internet Directory (OID/LDAP) servers
  • Oracle Database Administration for a wide variety of production and development databases ranging from 11.2.0.x to 8.1.7.x
  • Solo implementation of Oracle Enterprise Manager/GRID for OPM environment including configuring and setting up notification methods, custom thresholds/alerts and agent installs for all Oracle targets for DBA team
  • Implement a separate Oracle Database as an RMAN repository for OPM databases to use for their catalogs
  • Troubleshoot issues that may arise in production, testing, and development environment

Confidential, Arlington, VA

Consultant

Responsibilities:

  • Consultant for JSI to the new SCMS project for expertise relating to Oracle platform, SCMS made up of 17 partners providing HIV/AIDS drugs to countries in Confidential Solo Oracle implementation of 10gRAC and 10gAS running on NetWare SUSE for development, test and production environments
  • DBA support for applications integration, production & development support and tuning for all systems running on Oracle 10gAS and or 10gRAC including COTS ERP System, custom applications and other 3rd party vendor applications
  • Followed Oracle standard practices for OFA compliant systems and recommended backup methods for database and application server
  • Tested both DataGuard and RAC and went with RAC on Oracle ASM
  • Custom 10gAS installation using RAC instances for Metadata Repository
  • Oracle DBA for JSI infrastructure which runs Oracle 10gAS and 9i and 10g databases

Confidential, Reston, VA

Consultant

Responsibilities:

  • Consultant for Confidential working on various projects simultaneously with a wide range of skill sets including DBA support, 9i Application Server, 11i Oracle Applications, Oracle Discover, Oracle HTMLDB, Oracle Database, etc.Projects for State Department, Transportation Security Administration(TSA), Department of Confidential (DHS)
  • Production & Integration Test DBA systems support for applications integration, production & development support and tuning, and member of AMSS DBA team
  • Upgrade databases from 9i to 10g and 9i Application Servers to 10g Application Servers for webcache, middle-tiers and infrastructure servers and provided support for 11i Apps upgrade from 11.5.8 to 11.5.10
  • Troubleshoot issues that may arise in production, training, and testing environment and on-call 24x7 production support for TSA & DHS critical oracle systems
  • Support and work with several 3rd party vendor custom applications and tools

Confidential, Reston, VA

Senior Principal Consultant

Responsibilities:

  • Senior Principal Consultant for Confidential working on various projects simultaneously with a wide range of skill sets including DBA support, 9i Application Server, Oracle Workflow, Oracle Discover, Oracle Developer, etc.Projects for State Department, Transportation Security Administration(TSA), Department of Confidential (DHS), Office of Domestic Preparedness(ODP), Department of Justice
  • 9i Application Server support at the Confidential developing a unified messaging prototype system in 2 months to replace all facets of the State Department’s messaging services
  • Lead 9i migration at Department of Justice for all Developer Forms/Reports applications to the latest release of Oracle 9iDS running on top of platforms Oracle 9i Application Server and Oracle 9i spending approximately 3 weeks per application
  • Provided support during critical demonstrations to top government officials at Confidential and Department of Justice
  • Supported other Oracle consultants with technical expertise during software development cycles and assisting less experienced consultants with personal technical experiences

Confidential, Herndon, VA

Senior Database Administrator

Responsibilities:

  • Senior Database Administrator for the OSS planning and development team; responsible for all oracle database activity for Confidential ’s mission critical application Telecomm Business Solution(TBS) in all stages of test, development and implementation environmentsAssist developers working on many different projects providing database expertise and other technical assistance across the company such as in-house order entry system which interfaced with TBS softwareDatabase Administrator for 14 test & development and 3 mission critical production systems and 11 other production systems using Oracle databases ranging from version 7.3.4 to 8.1.7 and being used on platforms various platforms including HP-UX, Sun and NT
  • Designer, dba and web developer for Bandwidth On Demand project which collected customer bandwidth usage statistics which Confidential used for billing purposes
  • Designed and developed web application and database using Oracle Applications Server, Oracle Developer and Oracle Database
  • Oracle developer, dba and web developer for Confidential Integrated Network Dispatch Systems(WIND) project which interfaced with DataMart and Remedy systems. Also, redesigned WIND system cutting transfer time from 3 hours to under 5 minutes pulling from DataMart database
  • Performance tuning for databases, sql statements, stored procedures, and other critical issues that would arise from the systems supported by our group

Confidential, DC

Senior Database Administrator

Responsibilities:

  • Senior Database Administrator for Confidential database team; responsible for installing, creating, maintaining and tuning development, testand production databases for the Confidential including; 19 production oracle database systems, eight databases using Oracle7.1.x on NetWare and eleven using Oracle 8.0.x on NT. Also, 17 test/development databases using Oracle 7 & 8 on NetWare and NT.
  • Database architect for migrating Claims, Eapc, Sars and Avis systems from legacy Wang VS systems to Oracle 8 RDBMS. Alsomigrated and upgraded LS, Oasis, Allowances and Darts systems from Oracle 7.1.x on NetWare to 8.0.4 databases on NT platform.
  • Perform all database administration concerning development, integration and production cycle of all oracle systems for Information
  • Resource Management at the Confidential, also providing support of all database system related issues in 2-tier and 3-tier
  • production and development/test labs, including server configuration using RAID level 5 and planning and management of all Oracle
  • database management systems
  • Installed, configured Executive Management database linking 5 production database systems creating a DataMart database for management decisions and reporting
  • System architect for upgrading STATS system consisting of 6 replicated Oracle databases at different geographical regions and
  • upgrading from SQL*Forms to Forms 4.5 and designing replication environment among the 6 databases.
  • Security clearance to work on databases at Confidential

Confidential, McLean, VA

Senior Database Administrator

Responsibilities:

  • Responsible for four Oracle databases on three HP 9000 servers ( HP-Unix 10.x platform) in a distributed Tuxedo three tier architecture for the Confidential & Networking( Confidential ) project
  • Developed gui applications using Oracle Forms/Reports to track transaction statistics to perform network management functions for managers of the user community
  • Configured and designed web site and server for internal informational purposes
  • Database administration included; creating databases, configuring SQL*NET, supporting users of the database, creating automated jobs to be run on the database, installing and configuring Designer 2000, Developer 2000, Oracle Enterprise Manager and other database related tools
  • Designed and developed easy to use menu driven application with unix scripts to perform backup and recovery administration for the Oracle databases to be used by the production administrator
  • Security clearance to work on Confidential & Networking project for Confidential

Confidential, Falls Church, VA

Senior Database Administrator

Responsibilities:

  • Maintained and supported network operating systems, databases, hardware, printing, workstations, internet and email of the local area networks of Confidential and Navair at three different sites with security clearance
  • Configured, installed and upgraded new server/client Novell NetWare network operating systems along with various client software solutions and hardware during support of wide and local area networks
  • Designed and developed a tracking inventory application for all hardware equipment for three locations using MS Access as the gui interface over top of an Oracle 7 database and configured SQL*NET and ODBC for connection purposes.
  • Daily duties of administration include managing IT solutions such as backups, CCMail Post Office, networks(NetWare, Windows NT, UNIX, Pathworks), creating users and providing user support, and administering oracle database for NAVAIR applications
  • Configured and administered production servers, databases and installed routers, workstations, network interface cards, printers and laptops to wide and local area network

Confidential, Arlington, VA

Senior Database Administrator

Responsibilities:

  • Designed and developed an Forms for leasing business resulting in timely Reports for retail real estate leasing
  • Architected network for office and developed application solutions for handling company data through the tool MS Access
  • Configured and developed intranet web server for internal company information
  • Provided daily system maintenance and support to the commercial real estate firm including administration of network hardware and software, providing backup solution, technical problem solving and user support when needed in a Windows and Linux environment
  • Automated part of the sales/leasing business by purchasing COTS software package solutions for retail real estate firm

Hire Now