We provide IT Staff Augmentation Services!

Database Consultant Resume

Hoffman Estates, IllinoiS

SUMMARY:

Senior database administrator with substantial SQL Server administration, migration performance tuning and disaster recovery. Strong leadership and management skills including mentoring of database administrators meeting deadlines and budgets. Very strong customer service skills working with multiple departments and business units

PROFESSIONAL SKILLS:

Microsoft SQL Server Systems: Have administered SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2012 systems and SQL Server 2000 systems. Familiar with SQL Server Integration Services and SQL Server Analysis Services and SQ Server Reporting Services.

PROFESSIONAL EXPERIENCE:

Confidential, Hoffman Estates, Illinois

Database Consultant

Responsibilities:

  • Mentored newly hired database administrator, transferring knowledge and setting up monitoring.
  • Wrote company standards for database administrator role.
  • Migrated application system to updated SQL Server environment.

Confidential, Hoffman Estates, Illinois

Database Consultant

Responsibilities:

  • Assigned to ATC Transportation.
  • Audited and documented SQL Server environment.
  • Administered production 2008 R2 and 2005 systems.
  • Wrote company standards for database administrator role.

Confidential, Chicago, Illinois

Database Consultant

Responsibilities:

  • Managed production, staging and development database servers in a SQL Server 2008 R2, SQL Server 2005 and SQL Server 2000 environments.
  • Monitored and tuned performance for all environments using SQL
  • Server queries, stored procedures
  • Served as resource for business units, management and development staff.

Confidential, Chicago, Illinois

Senior Database Administrator

Responsibilities:

  • Lead team of three database administrators in designing, implementing, supporting and maintaining data architectures, data dictionaries, and SQL Server relational database systems for transactional and data warehousing applications.
  • Monitored and tuned system performance for physical and virtual serves.
  • Provided SQL stored procedures, queries, and reports for development staff.
  • Led and documented Disaster Recovery tests as well as producing divisional standards and enforcing best practices.
  • Migrated applications and databases through out the process cycle. Developed standards and best practices.

Confidential

Senior Database Administrator

Responsibilities:

  • Architected best practices for SOX compliance, back up and recovery, developed Data Transformation Services (DTS) packages to populate multiple systems, developed stored procedures for development staff, and developed disaster recovery plans.
  • For a major software distributor, tuned performance of web based customer service system. Tuning included hardware, operating system, MS SQL Server 2000 in a clustered environment, stored procedure and query analysis.
  • For a major publishing firm, led migration of legacy accounting system from Oracle to MS SQL Server 2000.
  • Replicated Oracle based reports to new environment utilizing Crystal Reports.
  • Providing database backup and recovery, 24 x7 monitoring, system sizing and Configuration.
  • Tuned performance of existing and newly developed systems as large as 1 terabyte.
  • Produced SQL code, physical and logical data models, stored procedures and triggers for SQL Server 2005 and 2008 R2
  • Monitored and tuned performance of Relational Database Management Systems
  • Created Data Transformation Services (DTS) packages to import and export data between environments and servers
  • Developed fault tolerant architectures for a major credit collections firm
  • Provided best practices and knowledge transfer for SQL Server and Oracle systems for clients
  • Assigned duties, responsibilities, and scope of authority to project personnel to assure project completion under assigned deadline and within designated budget
  • Served as Database Administrator / Developer for large mortgage company,
  • Providing database backup and recovery, 24 x7 monitoring, system sizing and Configuration.
  • Tuned performance of existing and newly developed systems as large as 1 terabyte.
  • Produced SQL code, physical and logical data models, stored procedures and triggers for SQL Server 2005 and 2008 R2
  • Monitored and tuned performance of Relational Database Management Systems
  • Created Data Transformation Services (DTS) packages to import and export data between environments and servers
  • Developed fault tolerant architectures for a major credit collections firm
  • Provided best practices and knowledge transfer for SQL Server and Oracle systems for clients
  • Assigned duties, responsibilities, and scope of authority to project personnel to assure project completion under assigned deadline and within designated budget

Confidential, Houston, Texas

Senior Enterprise Consultant

Responsibilities:

  • Provided technical expertise to external customers.
  • Responsible for project management and completion, pre - sales support, transfer of technical expertise to our clients and post sales systems implementation.
  • Implemented and optimized enterprise wide, fault tolerant SQL Server and Oracle systems for internal and external customers
  • Provided hardware and software architecture for customers, including sizing recommendations, capacity planning and backup/recovery best practices
  • Provided SQL Server database administration services to customers including knowledge transfer to client staff
  • Managed Compaq's Midwest Enterprise Solution Center as well as proof of concept and benchmark projects

Confidential, Emeryville, California

Manager of Support Services

Responsibilities:

  • Staffed and trained the Midwest Technical Support Center
  • Developed consulting engineer practice for Midwest Region
  • Provided Customer Support Services for Customer and Design Issues
  • Worked with marketing and sales teams to promote premium support packages
  • Resolved escalated issues with system engineers and customer staff

Hire Now