PROFESSIONAL SUMMARY:

• A proven database professional with over 20 years’ experience with MS SQL Server v7 thru 2016 doing data architecture and data modeling, DBA, developer, and instructor teaching public and private classes for all aspects of RDBMS and Data Warehousing along with Microsoft’s BI 2012 stack.
• In addition Confidential has over 10 years of experience leading database project management with developers, database administrators, and data analyst teams.

TECHNICAL SKILLS:

Databases: SQL Server 7 thru 2016, Oracle 7.x/8i/9i/10g, Sybase 4.9.2/12.5

Languages: DTS, SSIS, T - SQL, PL/SQL, RPG II, COBOL, VBScript

Tools: SQL Server Management Studio 2013, SQL Server Integration Services 2014, SQL Server Analysis Services 2008, MS Visual Studio Team, Team Foundation Server, MS Office, Quest LiteSpeed, TOAD Data Modeler, ERwin 4.x and 2.0, ModelMart 3.0, Sybase Power Designer

Reporting: SQL Server Reporting Services 2012 (SSRS), Google Docs

Operating Systems: Windows 7-10, Windows 2003, Advanced Server NT thru Windows 2012

PROFESSIONAL EXPERIENCE:

Director of Data Platforms

Confidential

Responsibilities:

• Coordinating DBA's to support client needs.
• Mentor DBA's at all levels of experience.
• Develop and Implement database designs.
• Attend sales calls with CEO
• Establish and document database concepts necessary to support the clients business.
• Drive out the direction of the database team and set goals and milestones to achieve.
• Create business processes that support the remote dba line of business.

DB Administrator

Confidential

Responsibilities:

• Responsible for the planning and execution of the data center move from one hosting provider to another.
• Researched, planned and implemented high availability and disaster recovery solutions for the production environment. This included creating Availability Groups utilizing the Always On feature.
• Responsible for enterprise database servers and all aspects of maintenance and new development.
• Support the .NET developers for their database needs, including modifications to all databases objects, access to the data, and maintaining a development environment that mimics production.
• Support a group of super users with writing and executing T-SQL in order to create user reports.
• Create and monitor backups for all environments of SQL Server.
• Research and document the features, similarities, and differences between 3rd party SQL Server monitoring tools.

Database Manager

Confidential

Responsibilities:

• Responsible for all aspects of design, development and support of the database environment.
• Provide mentoring to other members of the team through informal one on one learning sessions.
• Establish, develop and deploy the first enterprise-wide OLTP database.
• Design and develop the first data mart, paving the way for other data marts to be developed and maintained.
• Provide all of the administrative services for the development, QA, and production servers.
• Responsible for the direction of the data management strategies for the company.
• Responsible for the hiring of the desired individuals to full time positions and contract positions within the data management group.

Senior Database Developer

Confidential

Responsibilities:

• Responsible for the design, development, and support of on-line and batch trading systems.
• Provide mentoring to junior members of the team through formal presentations and informal one on one learning sessions.
• Develop and document departmental policies and procedures for the Database development.
• Assist production DBA’s with code deployment, troubleshooting, and performance and tuning of SQL code.
• Run SQL Profiler traces and research the results.
• Create and maintain database objects which included stored procedures, tables, indexes, constraints, and service broker queue objects.
• Create and maintain SSIS packages and SQL Server jobs and job schedules

Confidential

SQL DBA/SQL Developer - Consultant

Responsibilities:

• Responsible for the design, development and implementation of the necessary database structures for the Confidential .
• Create SSIS packages for ETL purposes.
• Develop dimensions and fact tables for the Confidential and fin Data Mart.
• Develop stored procedure to be used in Cognos 8 reports.
• Deploy all database objects from development to test and production in an automated fashion.
• Responsible for tuning SQL

SQL Server BI Specialist - Consultant

Confidential

Responsibilities:

• Responsible for design and development of a Sales cube.
• Established a replication environment from SQL Server .
• Migrated DTS packages to SSIS environment.
• Created ETL process to populate dimension and fact tables for Sales cube.
• Documented the current and future state of the data warehouse environment.
• Provided performance tuning for SQL Server 2005 and 2008 servers.
• Worked with both SQL Server 2005 and 2008 in a physical and virtual environment.
• Troubleshooting errors at the server, instance and database levels

SQL Server BI Specialist

Confidential

Responsibilities:

• Picked up project in mid-stream and completed a small data warehouse project.
• Created and modified ETL process to populate dimension and fact tables for Confidential cube.
• Created necessary SSRS reports to ultimately create a dashboard that used the Confidential cube as its data source.

SQL Server DBA - Consultant

Confidential

Responsibilities:

• Responsible for all development, staging and production servers.
• On-Call schedule, 24/7.
• Designed and implemented a consolidated backup strategy for 75 + servers
• Responsible for installing and configuring new servers in the enterprise
• Responded to TeamTrack requests, which were entered by the developers in order to support them.
• Researched and presented all possible, high availability solutions for SQL Server 2000 and 2005.
• Worked with both SQL Server 2000 and 2005 in a physical and virtual environment.
• Troubleshooting errors at the server, instance, and database levels

SQL Server DBA - Consultant

Confidential

Responsibilities:

• Responsible for all development, staging, and production servers.
• On-Call rotation consisted of 3 DBA's on a weekly rotating schedule, 24/7.
• Provided support for many development activities at the same time.
• Responded to the Customer Support ticket system that developers submit work requests through.
• Kept the turnaround time to a minimum.
• Provided long-term solutions to software and hardware problems that arose on the SQL Servers.
• Worked with a mixed environment containing SQL Server 2000 and 2005 servers.
• Installed SQL Server 2005 software for new servers in the environment.
• Troubleshot errors that arose during development, testing, deployment, and on-going maintenance.

SQL Server DBA - Consultant

Confidential

Responsibilities:

• Responsible for 4 SQL Server instances, which included development, test, stage, and production environments.
• Managed numerous projects at the same time and keeping up on any immediate needs that arise during the day.
• Technologies used include C# .NET and Cold Fusion.
• Responsible for the development and ongoing support of 8 different applications.
• Provide technical support for creating and tuning stored procedures.
• Deliver training for SQL Server 2000 to the development staff, including technical training for T-SQL and procedural training on Confidential 's internal standards.

Instructor/ SQL Server DBA / Project Manager / Data Architect

Confidential

Responsibilities:

• Served in various roles, including technical, managerial, and educational.
• For various projects, have managed team of 4 developers and up to 3 DBA's.
• Provided numerous consultants of varying levels of competencies, with answers to technical database design, development and implementation questions. Also assisted them in carrying out a particular task associated with database design and development.
• Provided guidance and mentoring to a technical team of consultants in order to lead them through the life cycle of a project.
• Managed numerous projects related to the RDBMS.
• Previous project technologies included .NET, PowerBuilder, C/C++, Visual Basic, Visual Interdev, ASP.
• Responsible for the presentation and delivery of the Microsoft SQL Server 2000 Database Education Curriculum and the Sybase ASE 12.5 Education Curriculum. Setup the classroom environment, which included the instructor and students computers.
• Technologies used include Oracle version 7.3.2 and 9i, SQL Server version 6.5 and 2000, Sybase version 12.5, MS Analysis Services version 2000 (OLAP), ERwin version 4 and 4.5, and Crystal Enterprise.
• Environment: SQL Server 6.5 / 2000, .NET, PowerBuilder, C/C++, Visual Basic, Visual Interdev, ASP, Oracle 7.x / 9i, Sybase version 12.5, SQL Server Analysis Services version 2000 (OLAP), ERwin version 4 and 4.5, Crystal Enterprise