We provide IT Staff Augmentation Services!

Senior Database Administrator Resume

Qualification Summary

Results-driven IT professional with proven successes in a broad range of data management initiatives. Relying on teamwork, resourcefulness and hard work to resolve the challenges facing the organization and in meeting corporate goals.

Professional Experience

Confidential – Project Contract

Senior Database Administrator

  • Senior Database Administrator for Sybase ASE on Red Hat Linux and Windows Server 2008R2.
  • Installed and configured four Sybase ASE 15.7 servers for use in comparative load testing.Executed multiple tests comparing performance on different file systems. Results were compared to similar tests on other RDBMSs.

Confidential

Senior Database Administrator

  • Senior Database Administrator for MS SQL Server, Oracle, Sybase and DB2.
  • Installed and administered MS SQL Server 2005, 2008, 2008R2 and 2012, Oracle 11g and 12c, Sybase ASE 15.x, DB2 9.x and 10.x.
  • Implemented and administered Oracle ASM 11g on UNIX/Linux and Windows platforms
  • Created and administered database backup and recovery processes for MS SQL Server and DB2.
  • Created documentation and processes for bare metal disaster recovery for MS SQL Server, DB2 and Tivoli Monitoring.
  • Designed and implemented stored procedures, functions, SSIS packages and administrative scripts for managing MS SQL Server, Oracle, Sybase and DB2.
  • Gathered user requirements, designed system architecture, installed, and administered IBM Tivoli Monitoring V6.1 and DB2 v9.7 Data Warehouse.
  • Installed and administered Oracle WebLogic and IBM WebSphere application servers.

Confidential

Senior Database Administrator

  • Provided 7x24x365 support for MS SQL Server 2008R2.
  • Instrumental in architecting hardware and software upgrade for SQL Server 2005 to SQL Server 2008R2.
  • Corrected long term blocking and deadlocking on production systems.
  • Applied, tested and certified service packs, patches and fixes to SQL Server 2008R2.
  • Designed and implemented stored procedures and SSIS packages for MS SQL Server.

Confidential

Senior Database Administrator

  • Provided 7x24x365 support for MS SQL Server 2005 in an international environment.
  • Developed SQL Server solution to facilitate customer invoicing.
  • Investigated and corrected long term blocking and deadlocking on production systems.
  • Applied, tested and certified service packs, patches and fixes to SQL Server 2005.
  • Created, tested and implemented DTS and SSIS packages.

Confidential

Senior Database Administrator

  • Provided 7x24x365 support for MS SQL Server 2005 in an international SaaS environment.
  • Architected and managed table partitioning for 200M row tables and .5TB databases.
  • Provided Windows Server 2003 and Server 2008 setup and support.
  • Instrumental in architecting move from NAS to SAN storage for databases and file system.
  • Developed and maintained stored procedures, triggers and functions for SQL Server 2005.
  • Created and managed SQL Server backup/offsite storage procedures using SQL LiteSpeed. Database and transaction log backups are written to NAS and then backed up to tape using Norton Backup.
  • Designed, wrote and administered SSIS and DTS packages for data transfer and ETL processing.
  • Created technical and business executive management reports using SQL Server and Excel.

Confidential

Process Analyst

  • Senior Database Administrator for MS SQL Server 2000 and 2005 and Analysis Servers.
  • Authored and maintained SAS programs for Consumer Marketing Analysis.
  • Provided statistical analysis of key call center performance metrics using JMP, SQL and Excel.
  • Instrumental in developing scorecards and reporting for call center initiatives.
  • Analyzed trends at multiple international sites and escalated issues arising from data variances.
  • Assisted in the identification of new reports and data needs to support business initiatives.

Team Lead – Application Support

  • Led team of five responsible for technical application support for a global user community.
  • Drove process improvements to increase Application Support Team efficiency by 50%
  • Provided high performance customer service to global users.
  • Senior Database Administrator for MS SQL Server 2000, MS SQL Server 2005 and MS Analysis Services for 40+ servers.
  • Managed MS SQL Server Data Warehouse and ETL (Extract, Translate and Load) processes.
  • Analyzed server and database performance and security issues and implemented improvements.
  • Mentored new-hire technical staff in MS SQL Server development and best practices.
  • Created self-service processes to automate repetitive, user initiated support tasks.

Strategic Planning Consultant

  • Created strategy and designed Data Warehouse hardware and software environment.
  • Created and implemented improved MS Analysis Server backup and recovery system.
  • Senior Database Administrator for MS SQL Server 2000 and MS Analysis Services for 15 servers.
  • Managed 27 servers, including Windows 2000 and 2003 Server Administration and hardware support.
  • Deployed and administered MS SQL Server, MS Reporting Services, MS Analysis Services and MS Project Server on Windows 2000 Server and Windows 2003 Server.

Hire Now