We provide IT Staff Augmentation Services!

Lead Oracle Dba Resume

Bethesda, MD

PROFESSIONAL SUMMARY:

  • Oracle database engineer Manager Position in the Baltimore/Washington Metropolitan area
  • Senior Oracle 8i/9i/10g/11g DBA professional with over 30 years of engineering, computer and management experience.
  • 35+ years of engineering experience, 35+ years of hardware experience, 20+ years experience of Project Management experience
  • 10+ years of SQL programming experience, 7+ years of Oracle DBA experience, 5+ years as a Lead Oracle Core DBA
  • 20+ years, former business owner of Confidential Employed up - to 12employees and up-to 20 sub-contractors
  • 6+ year business partnership with Confidential
  • Record of solving customer problems in a creative and common sense manner
  • Has the ability to complete multiple tasks while meeting project deadlines.
  • Will review a problem and consider both the long-term and short-term impacts on it.
  • Will propose workable solutions to the problem.
  • Have the ability to manage multiple tasks with changing priorities, within difficult deadlines.
  • An effective verbal and written communicator with earned s, special and teacher.
  • Demonstrated the ability to work well with a team consisting of broad backgrounds and different technical levels.
  • Ability to directly interact with the customers and clearly articulate problems and solutions, orally and in writing.

SOFTWARE:

  • GoBeam Unified Messaging
  • TAPIT Call Accounting SW
  • Confidential Network Designer
  • Microsoft Visio
  • Microsoft Project
  • Intuit QuickBooks Pro, POS
  • JAVA, JCreator, JBuilder, JDeveloper
  • Linux - Red Hat, Mandrake, Suse
  • Novell Netware
  • Microsoft NT 4.0, 2000, 2003, 2008
  • Microsoft Windows 95 - Windows 7
  • Microsoft Office Suite, Corel Office
  • Microsoft Publisher, FrontPage
  • Confidential Network Supervisor, Solarwinds
  • Clipper, FilePro, dBase, Lotus Suite
  • C, C++, Fortran
  • PUTTY, xWindows, Reflection
  • HTML, XML
  • SQL, SQL*PLUS, PL/SQL, MySQL
  • PL/SQL Developer, SQL Navigator
  • Oracle 8, 9i, 10g, 11g
  • TOAD 7.0 - 8.6
  • Multitech VOIP
  • Confidential AVVID
  • Avaya Partner, Partner Plus, Partner ACS
  • Confidential NBX 100, V5000
  • Multitech RF550vpn, RF650vpn
  • IBM, HP, Compaq, Dell PCs & FileServers
  • Network Security appliances
  • Telephony VOIP Solutions
  • Wireless Networking
  • Confidential Routers, hubs, switches
  • Confidential Routers, hubs, switches dLink Routers, hubs, switches
  • LinkSys Routers, hubs, switches
  • HP Laser and Inkjet printers
  • CAT5, CAT5E cabling & testing
  • FiberOptic Cabling & testing

SKILL:

Operating Systems: UNIX (SUN Solaris 8, 9, 10, IBM AIX, HP), Linux X86-64, Windows 2000, 2003, 2008 servers

DataBases: ORACLE 11g/10g/9 i /8 i on Oracle RAC (Real Application Clusters), dBASE 3/3+/4, and MS Access

Progr. Languages: MySQL, SQL, PL/SQL, JAVA, UNIX Shell Scripting (in bash, korn, borne, cshell), PowerBuilder, C, & C++

Software: SQL*Loader, SQL*Plus, RMAN, ArcServe & Cheyenne Backup Agents, Check Point Firewall, Solarwinds, Confidential Network Supervisor

Tools: Oracle10g/11g Oracle Business Intelligence Enterprise Edition (OBIEE), IBM Rational, Oracle Portal 10g, Oracle Internet Directory (OID), Single Sign-On Server (SSO), Oracle Enterprise Manager GRID Control 10g/11g ( Confidential ), Oracle Applications Manager (OAM), TOAD, ODBC, JDBC, Visio, MS Office, MS Project

PROFESSIONAL EXPERIENCE:

Confidential, Bethesda, MD

Lead Oracle DBA

Responsibilities:

  • Operations & Maintenance support - Enterprise support for Oracle 10.2.0.5 databases and 11.2.0.3 databases on NIPR & SIPR networks. Oracle Deployments from Development to STAGE to CRM (pre-production), from CRM into local PROD and remote PROD. Daily Production support. Specification of systems administration and application infrastructure changes. Creation of Standard Operating Procedure (SOP) documents.
  • OEM Grid Control 12C installation on Linux servers with specialized Oracle plug-ins.
  • Day to day STAGE, CRM and PROD operations and maintenance Oracle support.
  • EMC 3500 VNX SAN installation lead. Lead the research, price quote, and installation of new EMC SANs on the NIPR and SIPR sides of the enclave network. These systems replaced faulty and aging 3par SANs. The direct purchase cost savings was over $300K. The indirect cost savings for having reliable equipment is immeasurable.
  • Write Standard Operating Procedures (SOP) helping to define operations within the enclave environment.
  • Resolve trouble tickets within the REMEDY reporting system.
  • Attend weekly group meetings, lead weekly meetings, project specific meeting, and IPR meetings.
  • Created checklists for the deployment and delivery of systems, applications and databases within the enclave environment. These checklists were put into place as a means of tracking what the government was actually receiving from the development teams.
  • Perform DOD database STIG (Security Technical Implementation Guides), documentation of mitigation performed and maintain Oracle Best Practice requirements for 10.2.0.5 and 11.2.0.3.
  • Helped Information Assurance (IA) officers from different contractor teams develop a template for defining and reporting to the VMS (Vulnerability Management System) system.
  • Corrected a 2 year plus problem with the performance and operation of military program on HP Windows bit Servers. Coordinated solution with government remote facility system administrator (SA) and HP Server Support to provide Oracle database VLM configuration.
  • Identified and corrected problem within Spectrum Twenty One On-line (SXXIO) program environment. This system was out of synch in all of its environments Improved the process and performance of an environment that took 13 - 30 hour to deploy to 4 hours to complete.
  • Leads activities to develop, document and maintain architectures, infrastructure, requirements, algorithms, interfaces and designs for software systems.
  • Leads development of code and integration of complex software components into a fully functional software system.
  • Develops software verification plans, test procedures and test environments, executing the test procedures and documenting test results to ensure software system requirements are met.
  • Provides technical leadership for software projects and leads software supplier management activities.
  • Reviews software supplier product specifications, perform product comparisons, negotiates product pricing, and verifies supplier agreements.
  • Leads development, selection, tailoring and deployment of processes, tools and metrics.
  • Plans, executes and documents software research to development projects.
  • Serves as a subject matter expert (SME) for software domains, system-specific issues, processes and regulations.
  • Tracks and evaluates software team and supplier performance to ensure product and process conformance to project plans and industry standards.
  • Defines schedule for database deployment in coordination with other project sections.
  • Provide a full plan, documentation and test scenario for Disaster Recovery.
  • Follows defined processes and procedures.
  • Works under minimal direction.
  • Works within defined schedule.

Confidential

General Partner

Responsibilities:

  • Provide System Engineering input and support on a variety of different products.
  • Windows networking, LINUX and UNIX networking, Wide Area Networking (WAN), Local Area Networking (LAN), Wireless Fidelity (Wi-Fi), software development, software patching, Voice Over Internet Protocol (VOIP),
  • Contracted to Customer’s for technical Project management, technical consulting, technical business planning
  • Define work orders: Set project estimates, schedules, budgets, man power estimates and product work
  • Ability to learn and install new third party software as required
  • ERP diagramming and ERP planning using TOAD Developer
  • Oracle Enterprise Manager Grid Control ( Confidential ) installation and configuration on LINUX, UNIX and Windows servers for customers on a contract basis
  • Contracted for short-term Oracle 8i/9i/10g/11g database CORE support
  • Application software installation and configuration
  • Databases modeling and architecture creation using TOAD Developer
  • Senior level knowledge and ability in installation, operating, configuration, and maintenance of the following ORACLE products: Single Server Sign-On (SSO), Oracle Internet Directory (OID), Oracle Enterprise Manager (OEM), and Oracle SQL Client
  • ROI analyst and assessment for Confidential, WAN installations, LAN installations and other networking solutions
  • Quote potential business projects
  • Extensive experience with Confidential Level 5 documentation of database methods, operations, and procedures

Confidential

Oracle DBA Lead

Responsibilities:

  • Senior Production Oracle DBA and network infrastructure security support.
  • Provide Oracle 10g/11g production database and off environment support.
  • Provided Application administration for, SQL and PL/SQL data management tasks, OBIEE 10.1.3.4.1 administration, Informatica 8.1.1, 8.6.1 client and server administration.
  • Installed Test Environment to evaluate Informatica 8.6.1 and OBIEE 12.1.
  • Installed OEM Grid Control 11gR2 on Solaris v5.10 OS.
  • Defined Confidential asset management process for Confidential .
  • Developed several Standard Operating Procedure (SOP) documents for changing passwords, starting and stopping applications, and application maintenance.
  • Defined and implemented database security standards scripts and documentation which included auditing.
  • Define database access and system auditing through SQL-PLUS and Confidential .
  • Review and testing of Oracle Exadata product to see how/if it could meet Confidential growing needs. Exadata is already integrated with Confidential with some standard plugins, high speed integrated interfacing, and Oracle Data Center software tool.
  • Data warehouse storage management planning for audit data. ETL database tuning. SSO, OID and OIM 11gR2 planning.
  • Provided OID 10gR2 administration. Defined database migration plan to upgrade from 10gR2 and 10gR3 to 11gR2 for 50 plus databases in four environments.
  • Apply Oracle patches to databases, applications and for security purposes.
  • Use of Remedy IT Service Management software for problem tracking and solution documentation.
  • Leads development, selection, tailoring and deployment of processes, tools and metrics.
  • Plans, executes and documents software research to development projects.
  • Serves as a subject matter expert (SME) for software domains, system-specific issues, processes and regulations.
  • Tracks and evaluates software team and supplier performance to ensure product and process conformance to project plans and industry standards.
  • Defines schedule for database deployment in coordination with other project sections.
  • Provide a full plan, documentation and test scenario for Disaster Recovery.
  • Follows defined processes and procedures.
  • Works under minimal direction.
  • Works within defined schedule.

Confidential

Consulting Oracle DBA

Responsibilities:

  • Provided Oracle technical planning
  • Project development
  • Services provided on a Part Time On-Call (PTOC) basis

Confidential

Consulting Oracle DBA

Responsibilities:

  • Installation of 2 Redhat Linux 5.2 Oracle 10g Release 4 RACs.
  • Each RAC contained two nodes of HP blade Fileservers with HP MSA2000 SANs & multi-pathing
  • Redhat 5.2, Oracle 10.2.0.4, OCFS2, ASMLib, Clusterware and ASM Disks
  • RACs developed using block devices
  • Oracle Streams project to pass replicated data actively between two Data Centers
  • Full test lab setup at customer site; fully documented installation
  • Project resulted in 2 Oracle RAC software modifications (OCFS2 and ASMLib), 2 new Oracle Support notes, and 2 modified notes for RAC building with Oracle 10gR4
  • 10 database migration from 10gR2 to 11gR1 in TEST environment
  • Apply Oracle patches to databases, applications and for security purposes.
  • OEM GC 10gR4 installed for RAC management
  • Also developed a test RAC in Oracle 11.0.1.0.1 (11gR1) on the same Redhat 5.2 LINUX platform to compare RAC stability and performance using block devices

Confidential

Senior Oracle DBA

Responsibilities:

  • Assigned to the Social Security Administration (SSA) DSAB Oracle group; Database monitoring of environments using Confidential 10gR3. Support DBAs for Oracle database problems in the environments of, Development, Integration, Valuation and Production. The job included but not limited to:
  • The Database Systems Architecture Branch (DSAB) responsible for the evaluation, installation, maintenance and performance of all Data Base Management System (DBMS) software such as Integrated Database Management System (IDMS) and ORACLE used by SSA's distributed environments.
  • DB releases; modifying the database structure, as necessary, from information given by application developers through database developers.
  • Create and resize primary database storage structures (tablespaces) after application developers have designed an application and to manage storage space
  • Evaluates, installs, maintains and reviews performance of all associated vendor software products used to monitor, evaluate and perform diagnostic functions related to database system software in the SSA distributed environment.
  • Enrolling users while maintaining system security
  • Control and monitor user access to the database
  • Troubleshoot and determine problems using: system dumps, system traces, log files, ability to research and correct problems in Oracle using MetaLink.
  • Provides support for database system functions which are part of the Agency's disaster recovery plan.
  • Logged numerous Service Requests (SR) to receive Oracle help
  • Apply Oracle patches to databases, applications and for security purposes.

Confidential

Oracle Enterprise Manager

Responsibilities:

  • Responsible for the installation and configuration of OEM Grid Control 10.1.0.4.0 (10gR1), 10.2.0.1.0 (10gR2) and 10.2.0.3.0 (10gR3) on Solaris SPARC 64 bit Solaris 9 (v5.08) and Solaris 10 (v5.10) operating system in the Test, Development and Production environments.
  • OEM Grid Control installed and configured in Test, Development and Production environments
  • 250 plus Database migrations and upgrades from 8i (8.1.7), 9i (9.2.0.8) to 10g ( 10.2.0.3.0 ) in 4 environments. Apply Oracle patches to databases, applications and for security purposes.
  • Provided direction for RMAN backup, recovery and scheduling through OEM Grid Control and participated in RMAN testing through Confidential
  • Agent installation, configuration, reassignment and deployment
  • Patching databases, database seek-trees and Confidential through Grid Control real-time and scheduled
  • OEM database audit reporting tested and configured
  • OEM asset management for 64 bit Solaris, Linux and Windows platform
  • OPatch and DST patching of OMS JAVA and OEM Oracle Homes of OMS, DB and AGENT
  • Documentation of Grid Control tasks, Seed-Trees and Database developments
  • Support 8i, 9i and 10g databases for developers in development and production environments
  • Support database refreshes for testing, cloning and troubleshooting with hot and cold backup scripts
  • Oracle Enterprise Manager used to setup DBA users, DBA user privileges, rights and roles; change system access and security, perform RMAN scheduled backups and recovery
  • Collaborated with Oracle engineers on bug fix documentation for Solaris Grid Control Agent deployment
  • Specify SAN usage for OEM and RAC environments
  • Assist in Oracle LINUX 4 installation on HP Server RAC nodes
  • Setup SSH for Confidential and RAC installations
  • Created UNIX shell scripting for starting and stopping Confidential and components of Grid Control
  • Provided documentation for modeling, grouping and managing the enterprise of hundreds of databases within Confidential
  • Sole interface with Oracle Engineering Support on problem resolutions with Confidential in a Solaris SPARC 64 bit environment
  • Troubleshoot and determine problems using: system dumps, system traces, log files, ability to research and correct problems in Oracle using MetaLink.
  • Modified existing backup & recovery script to demonstrate how the same was achieved in Confidential
  • Assisted with database migration from 8i to 10g
  • Learned how to direct Oracle problems to specific Oracle Support groups for faster support
  • Logged numerous Service Requests (SR) to receive Oracle help

Confidential

Oracle Consulting DBA

Responsibilities:

  • Support DBA for Confidential development project to change method of census data collections, file management, operation management and customer interfacing beginning in the year 2010.
  • TOAD used for database administration to create users, setup user privileges, setup dbLinks, run tests, check user access, test SQL and PL/SQL scripts, test migration scripts, check for database errors, check for file errors.
  • Confidential 10gR1 administration
  • Single Sign On (SSO), Oracle Internet Directory (OID) and 10g Portal setup and administration
  • Oracle RAC 10gR1 administration, monitoring and management
  • SQL scripts and OEM used to setup users, user privileges, rights, roles, change system access and security, perform backups and recovery, …
  • SQL Developer database used on a few occasions to create test databases and to database structures.
  • Participated in Oracle 10g software installation in Grid and RAC environments
  • Redhat 4, Oracle 10.2.0.2, Oracle Clustered File System (OCFS), ASMLib, Clusterware and ASM Disks
  • RACs developed using raw devices
  • Help setup and manage EMC SAN storage
  • Provide full documentation of installations
  • Confidential 10gR2 installed for RAC management
  • Apply patches to the database tiers on RAC, patch applications and security patches
  • Installation, configuration and administer Developer access to BI (Portal/Discoverer), Oracle XML Publisher and Single Sign-on (SSO) Server for Grid environments in Sandbox (Test), Development, Staging and Pre-Test instances; RAC environments of Pre-Test environments
  • Oracle 10gR2, Red Hat Linux 4 EAS, and Windows 2003 Enterprise Server and enterprise trouble-shooting assistance to network support engineers
  • Create primary database storage structures (tablespaces) after application developers have designed an application
  • Create and upgrade documents that explain precisely what was performed, how it was done and why it needed to be done
  • Create new Oracle instances as directed and needed
  • Assist in disaster recovery testing with Oracle DBA Lead
  • Confidential application code migration from Grid Development and Staging environments to Grid and RAC test environments
  • Developer notebook application installations and support for LAN wired and wireless environment
  • Review the Developers’ SQL and PL/SQL code to resolve or prevent problems
  • Wrote RHEL4 Enterprise Application Server and Windows 2003 Server Shell scripts for Starting up and Shutting down databases and applications to help simplify System administration support of environment
  • Wrote and implemented patching philosophy for OEM environment
  • Train Junior Oracle DBAs on providing developer and environment support
  • Train Junior System Analyst on providing developer and environment support
  • Logged numerous Technical Assistance Requests (TAR) to receive Oracle Engineering help

Confidential

Owner/ Systems Engineer / Manager/Database Developer

Responsibilities:

  • Managed up-to 12 employees and over 20 sub-contractors
  • Healthcare accounting, inventory control, and collections databases written in SQL for Oracle DBA 8i/9i
  • 70+ Local Area Networks (LAN) installed using product likes Netware, Microsoft Windows 2000/2003/2003 SBE/2008, Linux, and UNIX
  • 50+ Wide Area Networks (WAN) installed using products like Netware, Microsoft Windows 2000/2003/2008 servers, SBE 2008
  • Healthcare accounting database creations and modifications in dBase IV, Clipper, FilePro, and Access
  • Oracle 8i/9i DBA support with hospital Healthcare administration system doing physical and logical backups and recoveries
  • Telecom office management 8i/9i Backup & Recovery support - Use Oracle RMAN to perform Schedule Backup and Recovery of databases, SQL script writing, data migration from Access to SQL
  • Provided data conversion help from dBase IV data to SQL for Oracle 9i using the Oracle SQL* Loader utility
  • Provide data conversion help from Access and FilePro to SQL for Oracle 9i using Oracle SQL*Loader
  • Novell, LINUX, Windows network configurations and installations in peer to peer and client server arrangements.
  • MS Windows network configurations from Windows for Workgroups 3.1 to Windows 2008 Advanced Server
  • Windows Server Active Directory Server configuration configuring Domain Name Service (DNS), ADM and Trust management, SSO configuration, defining users and managing user functions and access, computer migration and application migration.
  • Project Manager for viral and SPAM disaster network recovery and cleanup
  • Projects managed with Microsoft Project, QuickBooks Pro, MS Access and MS Excel
  • Advertising business through print and Internet
  • Performed System Engineering consult, designs, specifications and development
  • Propose, design and implement VOIP solutions
  • Propose, design and implement LAN, WAN, and WiFi network solutions
  • Proposal writing for prospective business
  • Quote potential business projects
  • Review potential projects to determine project’s needs

Hire Now