Dan Howard Email & Phone Number

Chicago, Illinois, Us

• Managing the database infrastructure engineering group for Big Data and RDBMS platforms.• Leading engineering efforts for Hadoop, MarkLogic NoSQL, MSSQL, and MySQL.• Implemented Agile Project Management for the team's work efforts.• Planning and coordinating Azure Cloud migration for data platforms.• Oversaw migration from Cloudera Hadoop CDH v5 to Cloudera Hadoop CDP v7.• Managing team members in both US and APAC regions.• Working on Audit and Regulatory requests for documentation and system security hardening configurations across multiple database platforms.• Engagement with procurement processes to negotiate enterprise software licensing.• Capacity and growth planning for multiple data platforms.• Planning and strategy for cloud database migrations to Azure.• Collaboration with business and application support teams to prevent and resolve issues quickly.• Strong emphasis on documentation and change management procedures to ensure production stability and resiliency.

Chicago, Illinois, Us

• Implemented Encryption at Rest for MarkLogic Data • Configured deployment of MarkLogic database objects using ml-gradle.• Designed and configured MarkLogic for LDAP external authentication and SSL to streamline and secure database access.• Implemented new infrastructure for MarkLogic NoSQL at the bank, including High Availability and Disaster Recovery configurations.• Developed enterprise standards and procedures for MarkLogic NoSQL.• Standardized deployment and maintenance procedures for implementing MySQL on RedHat.• Worked on projects to implement SQL Server 2014 and SQL AlwaysOn.• Performed multiple Sybase to SQL Server conversions for internally developed applications.• Advised development teams on SQL Server performance and tuning.• Upgraded MarkLogic v9 to v10

• Primary DBA for mid-sized environment. • Wrote and implemented a full database maintenance framework to coordinate backups, DBCCs, and index maintenance in a SQL 2012 AlwaysOn environment.• Implemented SQL Server Reporting Services for internal and external reporting including writing, publishing, and managing SSRS reports.• Created multiple SSIS packages for ETL as well as custom script tasks for packaging SSRS reports for bundled delivery.

Hanover, Md, Us

• Project implementations DBA, successfully coordinating over 15 projects simultaneously. As a part of these projects I also provide guidance to project teams on standards for database development and steer the project through the software development lifecycle.• Major projects I have worked on recently include building a server infrastructure and facilitating custom development for financial analytics and trading applications from vendors such as Moody’s and SunGard.• Designed and built the database infrastructure for a 4TB SharePoint environment which also included a Microsoft BI implementation with SQL Server Analysis Services, Reporting Services and PowerPivot.

Charlotte, North Carolina, Us

• Primary production support database administrator for a large railroad services company.• Responsible for maintenance and deployments of the Unified Fleet Distribution system.• Reviewing and updating all developed SQL code for performance and adherence to standards.• Responsible for deploying database code updates between the development, QA, and production environments in accordance with change management procedures and policies.• Performing database maintenance including backups, restores, database continuity checks, index maintenance, and query tuning.• Participating in 24x7 on call support for all database systems.• Writing ETL processes using SSIS to load data into a shared data warehouse.• Installing and upgrading new SQL Server instances and databases.• Ensuring the recoverability of all database systems and testing Disaster Recovery processes multiple times a year at an off-site recovery center.• Writing T-SQL stored procedures and table driven processes based on system views to automate common DBA tasks.• Participating in data model review and design sessions for data modeling in both the data warehouse and OLTP environments.• Interacting with developers, analysts, and technicians on project teams to ensure the compatibility and sustainability of newly installed information systems.

Chicago, Il, Us

• Member of the Database Administration team. Responsible for Smart Circular databases, (online advertising circulars for major retailers such as Best Buy and Target) data migrations, and log shipping jobs.• Participated in migration of all production and development servers from SQL Server 2000 to 2005.• Managing database backup jobs and warm-standby servers during the week as well as participating in a 24x7 On-Call schedule.• Moving SQL Server instances, User and System databases between boxes for hardware upgrades.• Administrating and developing for office projects using MySQL as a database back-end.• Implementing and maintaining Quest Foglight and Performance Analysis for database monitoring and tuning.• Scaling out the production environment with an additional 25 database servers to meet seasonal demand. Wednesday and Thursday of Thanksgiving typically saw 260 million page views and a peak at 11.5 million page views in a single hour, with no database outages or significant slowdowns during this period.

New York, New York, Us

• Providing technical support for departmental databases, printers, desktops, and scanning equipment in Lockbox Operations.• Applying table updates, writing queries, creating development databases, building DTS packages and monitoring server performance in a SQL Server 2000 environment.• Collection, analysis, and presentation of machine and operator statistical data to discover process improvements needed and improve overall site FTE.• Working with Business Analyst project management on project planning and completion.• Created and implemented a database for the collection of operator errors on Legacy scanning equipment. Including a solution for pulling the data from an off-network source and populating the data tables. • Writing SQL queries to pull data from various sources into a site performance tracking tool.