Donald D. Email and Phone Number

•Took a unplanned medical leave and had to focus on health over this time; Excited and energized to return to the workforce.•Proactively pursed training in SQL Server and Azure related technologies and versions . •Freelanced several one off projects related to SQL Server, ETL and Azure related projects.

•Orchestrated five SQL servers that maintained 20 databases in supporting Tableau, SSRS, Salesforce, and a range of key applications; handled backups, conducted performance monitoring, implemented tuning, oversaw Security, and performed Maintenance functions.• Facilitated Developers with crucial research and the timely execution of SSIS packages and SQL Scripts.•Designed, implemented, and maintained database architectures that supported production databases, leading to enhanced efficiency and reduced downtime. •Strong concentration on performance tuning of SQL systems and profiling and optimizing code and stored procedures and ETL’s.

•Directed all facets of supporting operations across the SQL Server environments; completed required performance monitoring and tuning, security, backups, and maintenance.•Oversaw SQL Servers that host 91 databases and several SSRS & Web servers; maintained servers which enable Association’s billing, web applications, blogs, and donations.•Built and updated a central repository via T-SQL and PowerShell to compile nightly statistics of all database metrics, servers, and KPIs; accumulated system hardware spec’s and SQL spec’s (index information, sizes, SQL Server system info, Security). •Collaborated with several consulting partners with web support upgrades of IPV2 to IPV3, facilitating prospective upgrades for website’s security architecture.•Charted and integrated backup and recovery strategies, resulting in a reduction in data loss risks during critical incidents; led performance tuning efforts, optimizing query performance, and reducing response times.•Supervised database security implemented robust access controls, encryption mechanisms, and routine security audits to facilitate compliance with regulations.

Database Administrator /Data Architect•Spearheaded the highly accessible solution via AlwaysOn to guarantee that all RPO/RTO were fulfilled in compliance with SLA’s defined by management.•Handled all facets of SQL support for server environments, Security, Maintenance, Performance, Backups, Patching, code deployments, and database build outs. Strong focus on Performance tuning of systems and daily focus on code performance and optimization. •Monitored and maintained 345 databases and 35 servers that bolster the company’s applications, analytics layer, data warehouses, and reporting systems; facilitated and built in SSIS the data movement ETL tasks.•Refurbished SQL Servers, reporting servers, and analysis services from 2008R2/2012/2014 to Windows 2016 and SQL Server 2017.•Guided third-party Partners for constructing and maintaining Heiman’s data warehouses; cooperated on code review, data management, change controls, and improvements.•Joined with partners to overhaul Heiman’s property management application into an outsourcing company that delivers services for efficient property management.•Devised a central repository via T-SQL and PowerShell to gather nightly statistics for all database metrics, KPIS, and servers, including SQL Server spec’s, index information, Security, and SQL Server system information.•Designed and implemented end-to-end data architecture for enterprise-level projects, ensuring seamless integration, high performance, and data consistency.•Advised the crafting and integration of ETL processes, ensuring efficient data extraction, transformation, and loading data into data warehouses.

•Headed all TTX’s 145 servers hosting 2K+ databases, spanning from micro instances to 14TB data warehouses and 17TB application databases; enhanced all ETL’s and data replication technologies.•Provided on-call 24/7 database and application support; formulated and implemented solutions for database installation, configuration, high availability, and disaster recovery.•Conducted database deployments for projects teams and third-party software; integrated, handled, and audited Database security for application, and end user access to databases; established company standards and policies in regard to databases and all relevant integrated technologies.•Coordinated directly with the creation and performance tuning of databases and indexes; coded and devised 2K+ ETL’s via SSIS to migrate data from operational systems to EDW.•Maintained communication channels and advanced prospective state of TTX’s database systems and related technologies; performed consistent tuning of software, systems, and databases to drive performance.•Contributed directly with infrastructure team to devise architecture to bolster SQL servers locally and at the remote site; assisted geo clustering capabilities of AlwaysOn servers; formulated DR solutions to guarantee TTX’s RPO and RTO SLA’s.•Incorporated data governance and quality standards, enforcing data integrity and facilitating compliance with industry regulations; evaluated and recommended data technologies, tools, and platforms to enhance data processing, storage, and accessibility.•Mentored and trained junior team members, sharing best practices, and fostering a culture of continuous learning; worked closely with business stakeholders to comprehend data requirements and provided solutions that enhanced data accessibility and usability.•Development support of data repositories in Postgres and MSSQL. Development for TTX Custom application and third party on Prem software in Postgres and MSSQL.

Baan SQL system to SAP Migrations at Newell Rubbermaid/Technical ConceptsDatabase Administrator (Contractor- Migration Project)I was contracted to migrate the companies SAP and internal systems to Redbrick. This included writing SSIS packages and modification to preexisting DTS packages to ETL data to external systems.

Recruited to provide main support for production servers for paymentnet application consisting of ~7 Terabytes. Served as secondary support for legacy systems totaling over 4000 databases. Rendered a full range of support services for UAT and staging sites. Debugged application code and SQL procedures. Created and fixed stored procedures used by production support and other business entities. Accountable for producing Crystal reports from mined data and distributing to business units. Instrumental in all application quarterly rollouts to production and UAT environments. Worked with development team to resolve any critical issues. Administered 24-hour on-call support services as needed. Corrected data issues and fulfilled custom requests by debugging applications and scripting custom code for updates. Optimized application performance by debugging application code, database, and server resources .Developed data mining databases to gather metrics from production servers .

Maintained an acute awareness of server database performance and activities, conducting monthly and daily health checks of assigned clients. Closely monitored functionality of development and online production servers. Rendered 24-hour on-call, database support services. Installed, configured, and troubleshot development SQL servers. Migrated development and production server data as needed. Active participant in weekly SQL server administrators’ meetings and monthly IBM and contractors’ goal meetings. •Conferred with client’s project managers daily to advance project and upgrade efforts.•Provided a full range of support for remote SQL Server for large-scale companies.

Ensured optimal performance of ticketing application and administer daily database activities. Solely supported and developed ticketing and donation software. Facilitated data migration from existing proprietary database to current SQL server. Generated complex reports using Infomaker and Crystal Reports to effectively analyze sales. Worked closely with box office and marketing managers to create reports. Applied business rules to customer base via SQL development of stored procedures. Debugged and fine-tuned stored procedures and database environment. •Bolstered security by reengineering backup plans for production and test environments. •Served as sole resource for high-level database and technology issues. •Converted existing data from antiquated ticketing system to current live SQL database . •Developed reports using both Crystal reports and Infomaker for box office and marketing departments.

Enlisted in early stages of company growth, assuming control of all IT software and hardware. Charged with designing, installing, programming, upgrading, securing, and managing SQL Servers/databases. Full responsibility for support, troubleshooting, performance monitoring, optimization, and tuning of server and SQL Server environments across entire system. Oversaw activities of 2 support technicians.Managed multiple DBA roles simultaneously, including programming, database / application support, and data transformation.•Increased efficiency by researching, formulating, and instituting standardized plan to conduct meetings. Boosted sales force’s productivity via creation of new applications.Optimized financial system’s performance, administering front- and back-end operations and as well as providing training and user support. Facilitated executive management’s critical decision-making process by developing reporting system to generate on demand reports and analyses.