Dba Consultant Resume
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