We provide IT Staff Augmentation Services!

Senior Dba Resume

2.00/5 (Submit Your Rating)

Tempe, AZ

SUMMARY

  • Over twenty eight years of experience using Informix, SQL Server, Oracle, Teradata, MySQL and Netezza Database Servers. Skills include Data Modeling, Backup and Recovery
  • Performance tuning, UNIX Scripting, Capacity Planning, Trouble Shooting, Development, Support, Data Warehousing, Decision Support, Workload Management, and System Analysis

TECHNICAL SKILLS

Informix: Relational Database Design, SQL, Advanced SQL, Managing and Optimizing Databases, Performance Tuning, Online 5.0 DBA, ISQL, 4GL, Advanced 4GL.

Oracle: SQL&PL/SQL, SQL tuning, Oracle DBA I & II, Backup & Recovery.

Teradata: DBA I & IINetezza Onsite trading for installation and deployment of existing warehouses to Netezza platforms.

Web Development: Basic & advanced courses from Ziff - Davis on MS Front Page

Computer OS: HP-UX, Sun, IBM, Sco UNIX, Windows, NT, plus others.

PROFESSIONAL EXPERIENCE

Senior DBA

Confidential, Tempe, AZ

Responsibilities:

  • Support and development of online testing and certification system. Cleanup and securing of MySQL database design, support of existing SQL Server instances, redesign of security policies,
  • Redesign outbound customer ETL modeling, application development support, training of new DBA hires, transition from windows platforms to centOS on vmware.

Lead DBA

Confidential, Phoenix, AZ

Responsibilities:

  • Manage a team of 20+ DBAs in 24/7 support of nearly 20,000 midrange databases on SQL Server, UDB, Informix, Oracle, Netezza, MySQL, Cassandra and Teradata across multiple datacenters.
  • This includes Web based OLTP systems running millions of transactions per day, petabytes of data, data warehouses with thousands of users, and many other large - and small-scale systems. As team lead
  • I was responsible for making sure all systems were properly monitored, documented, and supported. This included testing, recommending and deploying monitoring tools usable by both our staff and the help desk.
  • I also provided development support on numerous projects. OS: Sun, HP, IBM, Windows/vmware, Teradata & Netezza.

DBA Consultant

Confidential, Scottsdale, AZ

Responsibilities:

  • DBA Consultant for Nautilus Insurance: 10/04 to 02/05. Redesign existing Informix OLTP system to permit nightly incremental updates of a SQL Server data warehouse.
  • Current system is refreshed nightly. Redesign and optimize existing process to execute in reduced time frame. Additional support includes: tuning, optimization, UNIX scripting, trouble shooting and full system analysis.

Senior DBA/Data Modeler/Contractor

Confidential, Scottsdale, AZ

Responsibilities:

  • DBA and Data Modeler for DHL: 10/03 to 7/04. Develop and design logical and physical models for Informix databases.
  • Support and maintain Informix, MySql and Oracle Database Systems. Production support, tuning, backup, recovery, capacity planning, installations
  • UNIX scripting, documentation, system monitoring, reporting, data warehousing, project implementation, and development of team utilities

DBA Contractor

Confidential, Phoenix, AZ

Responsibilities:

  • Database Engineer for American Express: 4/01 to 5/03. Provided support, design, and maintenance of Informix and Oracle databases.
  • The Engineering team is responsible for all production and QA implementation changes, as well as support of these systems.
  • Oracle 8i and 9i and Informix 7 and 9 database versions are currently in use.
  • Capacity planning, 24x7 high availability using replication across data centers, database tuning, scripting, 3rd level tech support, system monitoring, and project implementation make up the majority of my work.

DBA Contractor

Confidential, Orlando, FL

Responsibilities:

  • DBA for confidential 3/00 to 12/00. The major project for this assignment was the migration of a large Informix data warehouse to a new machine, OS version, and IDS 9.2.
  • Additional tasks included standard support, version upgrades, database tuning, data modeling, capacity planning, disk layout, backup and recovery procedures
  • Unix scripting, SQL tuning, and general maintenance of other databases. OS: HP-UX and Solaris.

DBA

Confidential, Rochester, NY

Responsibilities:

  • Include data warehousing with Metacube product, database design, maintenance, Intranet development lead for the IT operations, support and implementation of Informix Online and SE databases and support of Oracle databases and applications.
  • Informix was new to the company and thus I have taken on the role of Instructor to the other DBAs who are primarily Oracle based.
  • Additional tasks included database design, disk layout, SQL tuning, performance tuning, data replication, development support, project leader, authoring of DBA support tools
  • Unix shell scripting project implementation, organization of DBA documentation for company's intranet, disaster recovery planning, backup and recovery, data replication, conversion of systems and databases from Oracle to Informix, beta testing of Informix's CISAM datablade, and regular database

We'd love your feedback!