We provide IT Staff Augmentation Services!

Dba Consultant Resume

3.00/5 (Submit Your Rating)

Holland, MI

SUMMARY

  • Database administrator (DBA) with over 13+ years of extensive experience designing, testing and supporting next - generation database solutions in MS SQL Server and Progress/Openedge database environments.
  • Proficient in an assortment of multiple infrastructure technologies including MS SQL Server 2012/2008/2005, Progress/Openedge 9.1D -10.1C, Oracle 10g/11g, Citrix, NetBackup, SAN, NAS, Windows, Unix and Linux.

TECHNICAL SKILLS

Databases: SQL Server DB 2012/2008/2005, Progress/Openedge DB 10.x/9.x, Oracle DB 10g - 11g

OS: AIX 5, Sun OS 10, Linux Red Hat 5, Windows Server 2008R2Monitoring OEM, Fathom, Windows Perfmon, Windows Profiler, DBCC

Scripting: T-SQL, UNIX Shell, Windows Batch

Tools: Net-term, Putty, RDP, Remedy, CA Service Desk, Citrix

Applications: MES, QAD (MFGPRO), REAL ServicingProfessional Experience

PROFESSIONAL EXPERIENCE

Confidential, Holland MI

DBA Consultant

Responsibilities:

  • Installation and configuration of new business unit setup
  • Process Automation and scheduling
  • New Business unit separation project.
  • DB upgrades and migration project
  • Modification of t-sql scripts and programs for Server Domain migration project
  • Monitoring and Capacity Management

Confidential, Duluth GA

DBA Consultant

Responsibilities:

  • SQL Server DB Restructuring and migration
  • New Monitoring t-sql script scheduling in line with business requirements
  • Backup Management automation

Confidential, Detroit MI

Lead DBA

Responsibilities:

  • Served as Lead DBA or project lead in the transition of 2000+ databases from IBM to Visteon in house support as part of Visteon’s IT insourcing project.
  • Project Manager for Visteon Virtualization project
  • Initiated and implemented Disaster recovery setup for multiple SQL Server databases across Visteon
  • Implemented backup strategy for multiple SQL server databases
  • Developed and implemented multiple monitoring activities using T-SQL Scripts
  • Migrated multiple SQL server databases from 2005 - 2012 versions
  • Managed a data-integration project for Visteon that consolidated information from accounting applications, third-party market data and internal fixed income applications.
  • Contributed to server and database consolidation project which resulted in a cost save of $55,000
  • Involved with Visteon Business Operations in centralization of standalone servers which had a cost save of $100,000
  • Created automated monitoring scripts and alert mechanisms which resulted in the reduction of Severity tickets from 10/year to <1/year
  • Instrumental in process Innovation across different database function which resulted in 40% reduction in the overall downtime across Visteon business applications
  • Developed and tested storage strategies and disaster-recovery plan for Visteon’s operational database, delivering solution that guaranteed recovery performance and high availability.
  • Enhanced end users’ understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training materials.

Confidential, Milpitas, CA

Associate Consultant - DBA

Responsibilities:

  • Installation and configuration of SQL Server 2005 and 2008 databases
  • Periodic user security and audit scheduled and supported for yearly SOX Audit
  • Involved in the full life cycle of Project starting from transition of QAD databases of Confidential to HCL technologies to decommission of the Databases.
  • Developed approximately 15 custom scripts using Unix shell scripting for automation of monitoring and DB maintenance activities
  • Installation of oracle database software for all new Confidential business operation units.

Confidential, FL

Senior Database Administrator

Responsibilities:

  • Instrumental in re-designing the existing EOD process involving database backup and mirroring, which resulted in a major process modification with a cost save of $1 million
  • Served as the project lead in the formation of DR site in India with the Production Database located in Orlando Data Center
  • Initiated Purge and Archive processes across all Progress databases for Ocwen and its clients.
  • Developed approximately 30 custom scripts using Unix shell scripting for automation of monitoring and DB maintenance activities
  • Basic involvement of SQL Server database administration

Confidential

Database Administrator

Responsibilities:

  • Instrumental in developing monitoring and DB maintenance scripts for progress databases across all HLL plant locations
  • Progress DB migration activities
  • Creation of web and app servers (web speed)

Confidential

System trainee

Responsibilities:

  • Involved in the migration of 100 progress databases from version 7x to 9x
  • Installation of Oracle client across 500 user pc’s as part of Oracle Sale analyzer(OSA) implementation

We'd love your feedback!