We provide IT Staff Augmentation Services!

Senior Database Administrator Resume

Fairlawn, NJ

CAREER OBJECTIVE
Accomplished Senior DBA/Database Developer, with over 10 years of Production Database Administration, Database Development, Data Warehousing and Business Intelligence experience is seeking a challenging career opportunity where my experience and expertise can be effectively applied towards achieving company objectives.

SQL SERVER AND OTHER DB SERVER ACCOMPLISHMENT HIGHLIGHTS

  • Implemented Information Builders WebFocus and InfoAssist self-service BI solution. This system was purchased 1 year prior to my arrival and not yet implemented. Implementation was done with no additional cost to the company.
  • Implemented SAP Business Objects solution. Implementation was done on-time and under budget.
  • Implemented custom Web-Based Reporting system.
  • Implemented Real-time replication and Disaster Recovery allowing systems to be available for 24x7 operations.
  • Expanded replication environment from 34 company controlled sites to over 400 company and non-company controlled sites (customer sites) to a central database for Reporting and Disaster Recovery.
  • Increased database performance by 90% and ETL process by over 80% by performance tuning stored procedures, implementing proper indexes and distributed databases.
  • Implemented a 2 node active/passive SQL Server Cluster.
  • Implemented MDM, EDW and Data Marts; creating a single version of the truth.
  • Implemented and consolidated SQL Server in a virtual environment using VMware VSphere 4.

EDUCATION
B.S. Computer Science
Web Development
Microsoft .Net Development
Microsoft Certification - SQL Server
Business Objects - Business Objects Enterprise XI

TECHNICAL

Technical - SQL Server 7.0/2000/2005 (Microsoft Certified)/2008, SSAS, SSIS, DTS, ASP, JavaScript, Microsoft Office
(97-2010) , Visual Basic, ASP.Net, Data Warehousing(Data Modeling, ETL), Windows 2000, Linux, Unix, Crystal Reports, Crystal Enterprise, SQL Server Reporting Services 2000/2005/2008, Business Objects,Microsoft and Unix Networking, Linked Servers, AS400, SQL Server Replication, Sybase, Transact SQL, OLAP (Dimensional Modeling), Information Builders WebFocus and InfoAssist, Oracle, MySQL

CAREER BACKGROUND

Confidential, Dec 2010 - Present
Senior Database Administrator / Business Intelligence Lead
Database Environment - MS 2003 Server, SQL Server 2008, Oracle, SQL Server Reporting Services, SQL Server Analysis Services, Information Builders WebFocus and InfoAssist, 3 Terabytes+ of data, Multiple Data Centers, Oracle, Whats Up Gold server monitoring software, Team Foundation Server, Sharepoint Team Services

Responsibilities

  • Install, configure and manage Information Builders Business Intelligence platform.
  • Mentor database and report developers.
  • Create roadmap for continuous improvement within the areas of Business Intelligence, Data Warehouse and Database.
  • Meet with business users to determine their Data Warehousing and Business Intelligence needs.
  • Derive functional and technical specifications from business requirements.
  • Develop detail project plans by doing technical research and analysis and organizing staff and client meetings. Providing project updates and developing technical specifications as needed.
  • Install, configure and manage SQL Server and Oracle Database Servers on multiple platforms.
  • Database design, security, backup and recovery, clustering to provide failover support, replication, optimization, integration, data modeling and documentation.
  • Develop Data integration for SQL Server using T-SQL and SSIS.
  • Database programming using Stored Procedures, Triggers, Functions and Cursors.
  • Proactive Database Performance Tuning and Capacity Planning.
  • Systems Analysis, Design and Quality Assurance.
  • Proactive database monitoring to ensure optimal continuous operations utilizing DMV, Perfmon, and custom processes.
  • Develop Disaster Recovery Plans, run test scenarios against plan and periodically execute and evaluate plan for Business Intelligence, Data Warehouse and Database environments.
  • Implement Best Practices for Database Maintenance, Security and Usage.
  • Creation of OLAP Cubes and Data Views for use with Decision Support Systems (Dimensional Data).
  • Programming in Microsoft Web-Based and scripting technologies as needed.

Key Project Achievements

  • Implemented Information Builders Webfocus and InfoAssist Business Intelligence solution. This was done on time and under budget. The software was purchased over 1 year prior to my arrival.
  • Planned, Designed, Documented and Implemented EDW Data Warehouse, creating the Single Source Data Concept where all corporate reporting originates.
  • Implementation of real-time SQL Server replication for populating and keeping the EDW.
  • Automated the process of populating the web portal as well as other processes.
  • Implemented Log Shipping and Remote Backup strategy to a remote location for Disaster Recovery.
  • Standardized the SSRS and Information Builders reporting environments.
  • Mentored a team of existing developers to eliminate our reporting backlog and turn around reporting requests from days to 1 hour or less.
  • Increased the enterprise reporting performance by 50% and application performance by 40%.
  • Assisted in data reconciliation for a major client. Without this reconciliation, the client would have gone with another vendor. Implemented a process for Data Quality Assurance to eliminate the need for major reconciliation in the future.

Confidential, Jul 2007-Dec 2010
Senior DBA/Database Architect/DW/BI
Database Environment - MS 2003 Server, SQL Server 2000/2005/2008, Sybase, Crystal Reports, Business Objects Enterprise XI, 3 Terabytes+ of data, Replication with 400+ locations, SQL Server Reporting Services, SQL Server Analysis Services, MySQL

Responsibilities

  • Install, configure and manage SQL Server and Sybase Database Servers and performance monitoring software on multiple platforms.
  • Database design, security, backup and recovery, clustering to provide failover support, replication, optimization, integration, data modeling and documentation.
  • Develop Data integration for SQL Server using T-SQL, Data Transformation Services and SSIS.
  • Database programming using Stored Procedures, Triggers, Functions and Cursors.
  • Proactive Database Performance Tuning and Capacity Planning.
  • Managing the Development, Test and Production database environments.
  • Systems Analysis, Design and Quality Assurance.
  • Derive functional and technical specifications from business requirements.
  • Develop Disaster Recovery Plans, run test scenarios against plan and periodically execute and evaluate plan.
  • Manage database architecture in a VMWare environment using VCenter 4.
  • Implement Best Practices for Database Maintenance, Security and Usage.
  • Creation of OLAP Cubes and Data Views for use with Decision Support Systems (Dimensional Data).
  • Programming in Microsoft Web-Based technologies as needed.
  • Install, configure and administer Business Objects Enterprise Environment.
  • Install, configure and administer SQL Server Reporting Services.
  • Create / Modify reports using Crystal Reports and SQL Server Reporting Service.
  • Proactive database monitoring to ensure optimal continuous operations utilizing DMV, Perfmon, and custom processes.

Key Project Achievements

  • Created replication environment, replicating over 400 Company Owned and Franchised centers (customer sites) to the corporate Data Warehouse.
  • Planned, Designed, Documented and Implemented Data Warehouse, creating the Single Source Data Concept where all
  • Improved application performance by over 90%.
  • Implemented Disaster Recovery for Database Servers with periodic testing.
  • Trained developers on how to write better performing queries.
  • Created standard library of Corporate Reports for Business Users, utilizing Business Objects Enterprise and Crystal Reports. This standard library of reports is a web-based intranet solution available to any user anywhere providing they have the appropriate permissions.
  • Implemented Visual Source Safe in the developer environment.
  • Implemented Business Objects Universes for business reporting.
  • Implemented SQL Server Reporting Services and Report Models for Ad-Hoc reporting.
  • Implemented and consolidated database in a virtual environment.
  • Upgraded SQL Servers to 2008.

Confidential, Jun 2000- Jun 2007
DBA/Database Developer, Manager of Application Development
Database Environment - MS 2003 Server, SQL Server, SSRS, Crystal Reports, Crystal Enterprise
(Business Objects), 3 Terabytes+ of data, Multiple Worldwide Data Centers

Responsibilities

  • Install, configure and manage Database Server on multiple platforms.
  • Database design, security, backup and recovery, clustering to provide failover support, replication, optimization, integration, data modeling and documentation.
  • Develop Data integration for SQL Server using T-SQL and Data Transformation Services.
  • Database programming using Stored Procedures, Triggers, Functions and Cursors.
  • Proactive Database Performance Tuning and Capacity Planning.
  • Systems Analysis, Design and Quality Assurance.
  • Derive functional and technical specifications from business requirements.
  • Develop detail project plans by doing technical research and analysis and organizing staff and client meetings. Providing project updates and developing technical specifications as needed.
  • Develop Disaster Recovery Plans, run test scenarios against plan and periodically execute and evaluate plan.
  • Implement Best Practices for Database Maintenance, Security and Usage.
  • Creation of OLAP Cubes and Data Views for use with Decision Support Systems (Dimensional Data).
  • Programming in Microsoft Web-Based technologies as needed.

Key Project Achievements

  • Developed EDI Module utilizing SQL Server DTS to allow customers to trade electronic information.
  • Planned, developed, documented, trained and implemented corporate Wireless Mobile Information System, allowing users to access real-time information anywhere/anytime.
  • Developed Web-Based Inventory Management System for our suppliers. Enabled tighter integration with our suppliers systems to improve supply chain operations.
  • Planned, Designed, Documented and Implemented Data Warehouse, creating the Single Source Data Concept where all corporate reporting originates. This allows users to access corporate data using standard tools such as Crystal Reports, Microsoft Excel and any other ODBC compliant application. Delivered project earlier than planned.
  • Created standard library of Corporate Reports for Business Users, utilizing Crystal Enterprise and Crystal Reports. This standard library of reports is a web-based intranet solution available to any user anywhere providing they have the appropriate permissions. Delivered project earlier than planned.
  • Integrated SQL Server and MySQL Database to allow seamless flow of data between Web-Based Applications.
  • Planned, Designed, Documented and Implemented Ecommerce application in ASP and SQL Server Technologies, allowing customers to do business over the Internet.
  • Integrated SQL Server in MS Windows environment and Btrieve Database in Unix environment to populate data for Data Warehouse.
  • Developed Software Solution for our customers to assist them in creating a more efficient manufacturing environment within their company. This solution opened the door for VMI and allowed the company to turn the IT department into a profit center.
  • Upgraded databases from SQL Server 7 and 2000 to 2005.

Confidential, 1998-2000

Database Administrator / Analyst / Developer

Database Environment - Windows NT Server, Unix, SQL Server 7, Oracle, 100 GB of Data
Responsibilities

  • Maintained information and data integrity for all Information Service functions including, database development, technical support, computer programming and analysis, and day-to-day computer systems operations.
  • Established technical priorities, standards, and procedures.
  • Maintained Oracle and Access database environment.
  • Backend database programming in VBA and SQL scripting language.
  • Developed detail project plans by doing technical research and analysis and organizing staff and client meetings. Providing project updates and developing training materials as needed.

Key Project Achievements

  • Planned, Designed, Documented and Implemented Data Warehouse in Unix environment.
  • Integrated Data Warehouse with BTrieve database for seamless flow of data into Data Warehouse.
  • Planned, developed, documented, trained and implemented corporate Warehouse Management System for Raw Materials Management.
  • Streamlined Production Control by enhancing and integrating the current Production Control System.
  • Integrated Electronic Scales into Production Control System.
  • Integrated Accounting and Production Systems.
  • Created Customer Service system utilizing Access and Visual Basic.
  • Created programming standards and documentation for use in future application development. This helped reduce program development time significantly.

Hire Now