We provide IT Staff Augmentation Services!

Senior Database Administration Resume

5.00/5 (Submit Your Rating)

Downers Grove, IL

SUMMARY

  • An information technology professional with expertise in Oracle database administration, software installation and configuration, disaster recovery planning, performance tuning, capacity planning, database design, PL/SQL and Linux/Unix shell scripting, and technology project leadership.

TECHNICAL SKILLS

  • PL/SQL and SQL
  • Shell scripting
  • All supported database versions
  • OS: Linux, UNIX, Windows, AIX, HP
  • Project planning consultancy
  • SAP Basis Administration

PROFESSIONAL EXPERIENCE

Confidential, Downers Grove, IL

Senior Database Administration

Responsibilities:

  • Infrastructure oracle database administrator supporting Shell Global account.
  • Work as part of North America senior database administration team.
  • Provide level 2 support for more than 1600 oracle databases on Shell global account.
  • Database migration from classic server design databases to Dynamic Computing service design.
  • Migration Houston, Amsterdam, Munich, and Cyberjaya datacenters running on classic server to DCS server using "as it is" process.
  • Migration EXADATA databases to DCS server. Exa2DCS - migration of over 600 databases form EXADATA platform to DCS using data guard method.
  • Shell-Motiva migration. Separation Shell data and Motiva company data and migrate to different support system. Creating staging area using RMAN duplicate method and move data outside Shell network.
  • Bug Fire - database automated refresh process. Developed and support automated script for weekly refresh process from production RAC database to test environment using RMAN duplicate from standby database.
  • POC - New Install and test 12C MTA databases on DCS environment.
  • Database storage migration from G9 to G12 storage or NFS storage.
  • Database remediation for security audit process.
  • Database migration from Shell network to local customer system Proof of Concepts using Oracle Golden gate tools.
  • Oracle installation, patching, and maintenance for SGA customer.
  • Confidential, Respironics, Downers Grove, IL 01/2007
  • Senior Oracle Database Administration
  • Performs database system management function (e.g., software installs, version upgrades and configuration management).Provide hands on technical expertise, provides senior level technical guidance to staff, project leaders and other teams as necessary.

Confidential Rosemont, IL

Database Administrator, SAP Basis Administrator

Responsibilities:

  • Checking and Monitoring the database performance. Daily or periodical checklist of the database and SAP status, including maintains of the main profile parameter files.
  • Database storage management. Adding datafiles to tablespaces, modifying internal storage parameters, planning database reorganizations.
  • Database security maintains. User and password administration, checking and monitoring database network connections and database accesses.
  • Database problem analysis and escalation procedures. Actively report, solve, and document common database problem using HP open view and Service Desk application.
  • Daily Interaction with SAP Infrastructure. Participate in SAP classes offered by Advance Transformer as a way to improve my quality of service and become familiar with the ABAP dictionary and also collaborate in developments of new objects.
  • Design and maintains of the databases. Upgrade and converting of the physical database layout, managing location of the main file, sizing and forecasting the database growth.
  • Partisipate in the Short and Long Term Disaster Recovery processes with the Disaster Recovery team. Review and updated DR documents.
  • Oracle Database upgrade to 9.2.0.6 vertion.
  • Oracle Databse upgrade to 10.2.0 for SAP Solution Manager.
  • Participate in Data Center/Security Audit.
  • Work with Unix and Basis team o ITO, OEM, Quest and Serviec Desk applications to automate internal monitoring and maintains processes.

Confidential, Itasca, IL

Database Administrator, System Analyst

Responsibilities:

  • Oracle Database Administration on Unix and Windows NT platforms
  • Managed and monitored Oracle databases in a 24x7 environment include acknowledging and resolving issues in the stipulated time frame
  • Oracle 8-9i database upgrade on Unix HP-UX platform
  • Formulated Disaster and Recovery Strategy for Logistics and Billing Applications; Installed and configured a hot standby environment in Oracle 9.2.0.3 database using Oracle Data Guard
  • Installed and supported Oracle Database Repository for Enterprise Manager tools (OEM)
  • Developed internal monitoring system using Unix shell scripts and Oracle Enterprise Manager tools

Confidential, Itasca, IL

Software Designer, System Analyst, Programmer

Responsibilities:

  • Developed a batch-processing program for Operation Data Mart application to capture all incoming and outgoing messages in the mobile communications using Pro C, Oracle, DB2, VB tolls and software under Unix and Windows
  • Designed database for new customer using ERWIN and Power Designer
  • Customized software for large Utility companies like Texas Gas (Dallas), America Electrics (Columbus)
  • Installed Oracle and DB2 databases for the software development and testing

We'd love your feedback!