Dan Denney Email & Phone Number

San Diego, Ca, Us

Calabasas, Ca, Us

Calabasas, Ca, Us

Malvern, Pa, Us

Westlake, Texas, Us

San Diego, California, Us

Ashburn, Virginia, Us

Senior Database Administrator contractor for MUFG, Union Bank. • Migrating their data warehouse from SQL Server 2012 Enterprise to 2016 Enterprise in a highly available environment.• Migration of SharePoint 2013 environment to new infrastructure running SharePoint 2016.

Atlanta, Ga, Us

• Technical lead of an 8 person remote database team.• Expertise with MS SQL Server versions 2016, 2014, 2012, 2008/R2, 2005, and 2000, in both Standard and Enterprise Editions.• Architect, install, and maintain numerous MS SQL Server instances, on both VMWare virtual machines and physical servers.• Architect, maintain, and troubleshoot high availability solutions, including using Always-On Availability Groups and failover cluster instances.• Develop and test disaster recovery plans that adhere to Service Level Agreements (SLA) that meet our Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO) for production databases.• Provide 24/7, on-call support for production database servers, to ensure issues are dealt with within SLAs.• Performance tune and troubleshoot problematic servers, databases, and queries utilizing a variety of troubleshooting methodologies. This includes using dynamic management views (DMVs), extended events, profiler, query plans, wait types, Statistics IO and Time, and other monitoring tools.• Provide capacity planning for new database and server architecture. • Gather and analyze server and database metrics in order to consolidate database infrastructure.• Support for very large databases (VLDBs) of over 1 TB, including the use of partitioning, row and page-level compression, database files and filegroups setup, and back-up and maintenance tuning. • Configure, maintain, and troubleshoot high volume transaction replication for multiple publishers and subscribers.• Architect, install, and maintain multiple SQL Server Reporting Services (SSRS) environments, including scale-out deployments with multiple front-end servers for high-availability and load balancing. Includes versions 2016, 2012, 2008R2, and 2005.• Extensive use of PowerShell and T-SQL to create automated scripts for monitoring, database maintenance, backup and test restores, SSRS administration, and server installations.

Atlanta, Ga, Us

• Architect, develop, and support of multiple high concurrency Online Transaction Processing (OLTP) application databases.• Advanced Transact-SQL (T-SQL) experience with stored procedures, functions, views, and ad-hoc queries.• Develop Oracle PL/SQL queries in versions 12c, 11g, 10g, and 9i.• Data modeling using Sybase PowerDesigner.• Create and maintain operational data warehouse and data marts to support multiple lines of business.• Develop multiple ETL solutions using SQL Server Integration Services (SSIS). Includes versions 2014, 2012, 2008R2, and 2005.• Develop SQL Server Reporting Services (SSRS) reports using both Visual Studio (SQL Server Data Tools) and Report Builder.• Work with Microsoft Support to troubleshoot and fix database server issues.• Mentor and assist my peer database administrators, as well as Business Intelligence and application developers to help design, implement, tune, and support database solutions. • Establish database development and deployment processes and standards that utilized best practices for DBAs and software engineers to adhere to. Monitored compliance through code reviews and audits.• Project leader on multiple successful infrastructure and development projects.• Collaborate and partner with business’ leaders and subject matter experts from various lines of business, who are located across Cox’s nationwide footprint, to build highly robust and performant SQL Server solutions.• Establish procedures, train, and work with outsource contractors to deploy and support application databases.

• Designed, developed, implemented, and maintained an end-to-end procurement system used by a federal agency for purchasing goods for overseas employees.• Provided analytical reporting on purchases, billing, and payment data from procurement system.• Responsible for the installation, monitoring, and maintenance of a MS SQL Server 2000 instance containing a very large database (VLDB) of over 800GB (large for the time).

• Performed database administration duties for several MS SQL Server 2000 instances and MS Visual FoxPro 6 databases.• Designed, developed, implemented, and maintained several application databases used by the company to fulfill both federal contractual obligations, as well as internal support applications.• Mentored developers to help design, implement, and tune databases for their applications.

Ba

Advanced T-Sql Querying, Programming And Tuning For Sql Server With Itzik Ben-Gan

Cis