We provide IT Staff Augmentation Services!

Oracle And Sql Server Database Administrator Resume

2.00/5 (Submit Your Rating)

SUMMARY:

  • Seeking senior level role to build on my 30 years of experience in the IT industry as a Database and System administrator in Oracle and SQL Server environments running on UNIX (RHEL, HP, IBM and Solaris) and Windows OS.
  • 30 years of experience in IT, with principal role as both Database and System Administrator, with Oracle and SQL Server databases on RHEL, HP - UX 11i, IBM AIX, Solaris, and Windows platforms.
  • 5 years experience in Messaging Middleware Interface administration in an IBM WebSphere MQ and SAP XI environment.
  • Providing On Call support as needed over entire career span.
  • 7 years’ experience writing technical documentation in support of the job roles.
  • Part time hardware support of HP-UX, and Windows Servers.

TECHNICAL EXPERTISE:

Database Administration Software: Oracle (7.3 thru 12c), Oracle GoldenGate 11g and 12c, SQLPlus scripting, Microsoft SQL Server ( versions), Sybase (10, 11), SAP R/3, Remedy Help Desk

Database Monitoring Software: Oracle Enterprise Manager, SQL Server Enterprise Manager, Veritas i3 Focalpoint and Indepth for Oracle/Unix Performance Tuning, EMC Dbtuner for Oracle/Unix

Messaging and Middleware Technologies: IBM WebSphere MQ Explorer, SAP Exchange Infrastructure/Process Integration, and SAP systems. Message monitoring via BMC middleware management tool, and SAP interfaces.

Languages: Unix Shell Scripting, Perl, PowerShell, Oracle SQLPlus, SQL Server T-SQL

Operating Systems: UNIX (RHEL, HP-UX 11i, AIX v5 and 6, Solaris), Windows Server, IBM AS400/iSeries

Backup Technology: Data Protector 5, SQL Server Enterprise Manager and Oracle RMAN

Office Technology: Proficient in Outlook, Excel, Word and PowerPoint. Familiar with Open Office.

Change Request and Ticketing System: HP Service Manager

Hardware Monitoring and Maintenance: Hardware diagnosis and part replacements on Dell and HP servers as needed.

EXPERIENCE:

Oracle and SQL Server Database Administrator

Confidential

Environment: Windows 2012 and Linux RHEL servers with SQL Server 2012 and Oracle 11gR2/12c databases. Same role as with Confidential below, just change from sub-contractor to Confidential, principal contractor.

Responsibilities:

  • Provide Oracle and SQL Server database support for Defense Information Systems Agency.
  • Principal tasks include daily health checks, monthly patching, documentation and troubleshooting of the production environment as needed.
  • Top Secret level clearance.

Oracle Database Administrator

Confidential

Environment: Windows 2012 and Linux RHEL servers with SQL Server 2012 and Oracle 11gR2 databases

Responsibilities:

  • Provide Oracle and SQL Server database support for Defense Information Systems Agency.
  • Principal tasks include daily health checks, monthly patching and troubleshooting of the production environment as needed.
  • Clearance at Secret Level.

Oracle Database Administrator

Confidential

Environment: Windows and Solaris Server OS, Oracle 12c database

Responsibilities:

  • Provide Oracle database support for 3 Air Force programs.
  • Perform restores, data loads, and upgrades of 20+ databases.
  • Administration of Oracle GoldenGate and Dell Shareplex replication of data. A GoldenGate intensive environment.
  • Perform required install/patching of Oracle 11g/12c.
  • Hardware support for Dell R910/920 servers.
  • Clearance at secret level.

SAP/XI and IBM WebSphere MQ Middleware administrator

Confidential, St. Louis

Environment: UNIX (IBM, HP, and Sun), Windows servers ( ), and IBM iSeries/AS400 servers

Responsibilities:

  • Provided 1st and 2nd level support of SAP XI/PI and IBM WebSphere MQ messaging systems.
  • Performed monitoring and new message configuration of MQ queue managers via MQ Explorer and other tools.
  • Principal administrator of BMC Middleware Management for Websphere MQ application, which was utilized by multiple teams for testing and monitoring of MQ messages.
  • Implemented SAP interface configuration via SAP ALE and SAP xLink technology.
  • On Call 24/7 rotation with 4 other team members in Americas (AMS) zone.
  • Participated in Follow the Sun workflow model with AMS, AOA, and EUR zones.
  • Wrote technical documentation for the MQ middleware environment procedures and required administration.
  • Key participant in Nestle Continuous Excellence program, writing support documentation and reports, taking leadership role in the processes meant to drive higher efficiency and decrease operation costs.

Oracle, SQL Server and UNIX System Administrator

Confidential, St. Louis, MO

Environment: Oracle database (8i through 10g) running on HP-UX 9000 and IBM P series servers. SQL Server database running on Windows 2000 servers.

Responsibilities:

  • Installed, upgraded and configured new Oracle instances via Oracle Enterprise Manager.
  • Administration of HP-UX 11i and IBM P-Series AIX platform servers.
  • HP and AIX Server installations including SAN/NAS configurations.
  • Administration of SQL Server databases version maintenance on Windows 2003 and 2008 servers using SQL Server Enterprise Manager.
  • Administration of EMC Dbtuner and Veritas Indepth Performance products for Oracle Databases, for developer DBAs.
  • Responsible for all backup/recovery of databases and regular UNIX files using Data Protector 5 and RMAN.
  • Principal writer of technical documentation as needed for the UNIX servers and database procedures.
  • On call 24/7 in 5 person rotation by the Data Center.

Oracle Database and UNIX Administrator

Confidential, St. Louis, MO

Environment: Oracle 7.3.4 databases. Sun Solaris Server with a 30 disk array. Installed Oracle 8.0.5 to a second SUN Ultra 2 server running Solaris 2.5.1 OS. Converted data from anIBM AS400 mainframe to Client Server on Sun Enterprise and Ultra SPARC Server.

Responsibilities:

  • Administration of the front-end application and the data model supplied by AON Consulting for pension data systems.
  • UNIX administrator in support of the Omnipay Check Writing System.
  • Backup/Recovery duties including the physical cold/hot backups and logical backups.
  • Documentation for setting up and using the new interface and tracking of new data submissions.
  • Worked with PowerBuilder Application for analysts to track database submissions.
  • Used Linux to act as a server for error checking of data.
  • Programmed with COBOL and PERL to convert AS400 data to the AON/Oracle data model format.

Oracle Database Administrator

Confidential, St. Louis, MO

Environment: All servers running Oracle databases are IBM RISC 6000’s with the Client Servers running on Windows 95. The Oracle databases were back end for the SAP system. This SAP system unified the manufacturing plants, former database architectures and production applications. Legacy system databases such as DB2 were ported to Oracle 7.3 databases with SAP R/3.

Responsibilities:

  • Installation/administration of the Bendata Help Desk application as a front end application running on Oracle 7.3 database.
  • Converted customer service calls into knowledge database nodes in order to speed up problem resolution.
  • Installation/administration of Gentran, a server application that improved the Data Interchange system.
  • Monitored 5 IBM RS 6000’s and a total of 7 Oracle databases sized from 100 MB to 90 GB.
  • Utilized the Oracle tools Svrmgr and SQLPlus to query and maintain the databases.
  • Monitored 2 SAP R/3 central instances and their associated Oracle databases.
  • Ran SAP reorganizations of fragmented tables using the SAP DBA interface menu.

UNIX System Administrator

Confidential, St. Louis, MO

Environment: Working at Union Pacific on HP-UX, NCR-SVR 4 and IBM-AIX, utilizing Windows NT as the Emulation Workstation. Principal Applications are Exceed, Telnet, Microsoft Accessand Lotus Notes.

Responsibilities:

  • Resolved all tuning software and Operating Systems issues with Oracle databases running on all servers.
  • Installed new versions and troubleshooting of failures/performance problems at approximately 20 IBM, NCR, and HP servers.
  • Built database to store ‘package and patch’ installation details for the 3 server platforms.
  • Responsible for new installation of 2 HP servers using mass storage server as a secondary mirror source.
  • Managed day to day requests for 5 NCR servers.
  • Handled requests for OS changes and other questions at the 50+ servers spread over 6 cities.

Sybase Database Administrator

Confidential, St. Louis, MO

Environment: Sybase Server 10 and 11 and Sun/Solaris 2.5.1, Windows 95, Windows 3.xMS Office, Apple IIc and System 7. Powerpoint, IBM PC and clones ( ), Macintosh IIc and Powermac.

Responsibilities:

  • Monitored backup/recovery of 3 databases, with 15 GB of data, running on Sybase servers 10.0.2 and 11.
  • Installed new versions of Sybase and monitored site acceptance of functionality.
  • UNIX administration of one database through Client Server application.
  • Project manager support of 3 databases.
  • Received Top Secret clearance.

Unisys Database Manager

Confidential, St. Louis, MO

Environment: HP PC, Mac, Unisys 1100 and Unisys operating System, SUN/UNIX, Word 5.1 and Powerpoint.

Responsibilities:

  • UNIX administration of the SUN SPARC workstations.
  • Member of database/customer-request team.
  • Leadership role overseeing verification of new data entering 3 databases.
  • Lead analyst on one of the databases.
  • Wrote training manuals in Powerpoint and Word to update procedures on 2 databases.
  • Shipped customer requests in 9 track and 8 mm tape for 4 databases.
  • Ran quality reviews on data using SUN SPARC workstations.

We'd love your feedback!