We provide IT Staff Augmentation Services!

Database Engineer & Administrator Resume

New York, NY

OBJECTIVE:

Database Engineer & Administrator

SUMMARY:

  • Engineer & Administrator of Decision - Support, Data-Warehouse & OLTP Type Databases
  • Strong knowledge & experience in all phases of database design, implementation and maintenance with Oracle (8, 9, 10g & 11g on Sun Solaris & Linux Large), Microsoft SQL Server (2000, 2005 & 2008) & Sybase RDBMSs;
  • Strong experience in database Performance Tuning and troubleshooting of complex database problems;
  • Strong experience in SQL Performance Tuning;
  • Vast Experience with all Proprietary (OEM, SQL Developer, SSMS, SSIS, SQL Profiler, Sybase Central,etc.) and Third Party (Toad, Team-Quest, BMC Patrol, Tivoli, Guardium, etc.) DB Management, Performance & Monitoring tools for Oracle, MSSQL & Sybase databases.
  • Strong Experience with database Migration from Older Versions of Oracle & MSSQL to Newer versions within the same RDBMS platform;
  • Strong Experience of Database Migration from Oracle to MSSQL platform via Microsoft SSMA;
  • Strong experience in design & implementation of CUSTOMIZED Enterprise-wide solutions for database maintenance & monitoring;
  • Strong knowledge & experience in design and implementation of databases Replication Solutions for High-Availability Applications and Disaster Recovery purposes via database Streams, Mirroring, Log-Shipping, etc;
  • Strong knowledge & experience in developing SQL Scripts & Stored Procedures in Oracle, MSSQL & Sybase environments;
  • Strong Experience in developing Unix Shell, AWK, Windows Batch & Windows PowerShell scripts for database administration;
  • Strong Experience in Physical & Logical Database Modeling utilizing Erwin, Cayenne (COOL) DBA Case Tools;
  • Significant experience with database jobs implementation & scheduling via Maestro & ESP software;
  • Some experience with DB2;

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Database Engineer & Administrator

Responsibilities:

  • Responsible for design, implementation and maintenance of several Decision-Support, Data-Warehouse & OLTP type databases on Oracle, MSSQL & Sybase platforms for Confidential
  • Extensive interaction with customers in developing database requirements;
  • Logical Database Design utilizing Erwin (currently) & Cayenne (in the past)
  • Physical Database Design utilizing Erwin & Cayenne Case Tools;
  • Physical database implementation;
  • Capacity planning;
  • Database Replication (Streams, Mirroring, Log-Shipping);
  • Database & SQL Performance Tuning & troubleshooting;
  • RDBMS & Server upgrades;
  • Database Migrations;
  • Security Roles & IDs Implementation & Management;
  • Development & implementation of DB Maintenance Procedures including Backup & Recovery procedures, Partition Maintenance ProceduresDB Consistency Checks, Database Reorgs, etc. via Unix Scripts, Windows Scripts, SQL Scripts and utilization of Enterprise Management Database Tools;
  • 24/7 Production support of large number of databases including space & performance monitoring, problem troubleshooting, etc;
  • Responsible for development of custom Database Maintenance & Monitoring Enterprise-wide solutions.

Hire Now