DBA with over 20 years of experience in the computer industry including relational and non-relational (NoSQL) database development/administration. Dependable employee, who learns quickly and enjoys solving complex problems, streamlining processes, and automating tasks. Looking for a database developer or administration role where I can apply my technical skills and experience.
Certifications:
Microsoft® Certified IT Professional: Database Administrator 2008
Microsoft® Certified Technology Specialist: SQL Server 2008, Implementation and Maintenance
MCDBA Microsoft Certified Database Administrator
Sr. Database Administrator @ •Development of SQL schema patches and stored procedures and SSIS packages on massive OLTP SQL 2008R2 education platform databases.
•Performance tuning of SQL Server database objects to mitigate contention when under very heavy load.
•Work with development and deployment teams in an Agile setting to implement no downtime releases.
•Work with Automation team to develop and enhance MongoDB and Cassandra deployments to AWS and private cloud using Puppet.
•Automated MongoDB backups in AWS, including copying to S3 storage, and managing retention periods. From June 2010 to Present (5 years 6 months) Centennial, CODatabase Administrator @ • Responsible for day to day administration and support of production, staging and development SQL Server, MySQL and Oracle databases
• Database modeling/design in a custom application development environment
• Develop stored procedures, triggers, functions and views in support the application development and production support efforts
• Database tuning and troubleshooting as needed to optimize performance
• Responsible for migrating several systems from SQL Server 2000 to SQL Server 2005 and SQL Server 2008 From 2008 to June 2010 (2 years) Englewood, CODatabase Administrator @ • Responsible for the administration and support of production, staging and development SQL Server 2005 databases
• Develop and maintain complex SSIS packages for nightly production data processing to and from heterogeneous systems including Oracle and Access
• Database design in a project driven, custom application development environment
• Write stored procedures, triggers, and functions to support the application development and production support efforts of the IT department
• Support database servers in an on-call rotation
• Responsible for migrating from SQL Server 2000 to SQL Server 2005 and data migration projects from legacy database systems
• Implemented and support SQL Reporting Services for enterprise reporting needs From January 2007 to April 2008 (1 year 4 months) Highlands Ranch, CODatabase Administrator @ • Responsible for the administration and support of production and staging SQL Server databases as well as internal databases used by employees
• Responsible for database maintenance and backup processes on over 30 SQL Servers
• Technical lead for upgrading from SQL Server 7 and 2000 to SQL Server 2005
• Provide 24/7 on-call production support
• Design and optimize DTS and SSIS packages to support enterprise applications
• Analyze stored procedures/queries and implement improvements to optimize performance
• Create system documentation used for training and support
• Create reports using SQL Server Reporting Services From September 2005 to December 2006 (1 year 4 months) Database Administrator @ • Managed multiple 24x7 production and development MS SQL Server 2000 databases on a MS Windows Server 2003 platform residing on Dell servers
• Wrote and tuned complex stored procedures, SQL scripts, and DTS packages as needed to support enterprise applications
• Planed and developed new databases including structure, security, and disaster recovery
• Regular database maintenance including data cleansing, performance tuning, software upgrades and patch installation
• Created reports as needed in SQL Server Reporting Services and Crystal Reports
• Work directly with users and developers on system process improvement, implementation, and support
• Directly supervised four employees in the areas of network administration, application development, and desktop support From January 2001 to August 2005 (4 years 8 months) Database Administrator @ • Database architecture and design for incoming Managed Services customers
• Installation, administration, and support of production and development systems including SQL 2000 Cluster in fail-over configuration
• DBA of Onyx CRM implementation and development team
• Migrated systems from MS SQL Server 6.5 to 7.0 and from SQL 7.0 to SQL 2000
• Migrated customers and sales leads into CRM and Billing systems using SQL scripts and DTS
• System maintenance including comprehensive backup and recovery plans, and database optimization
• System development and customization through SQL stored procedures and SQL scripts
• Developed and implemented database security plans for production and development environments From September 1997 to September 2001 (4 years 1 month) Database Analyst @ • Coded and executed SQL scripts against customer and consumer databases for market research
• Developed and maintained sales lead tracking database
• Performed data loads on a regular basis
• Performed database backups and maintenance From July 1998 to April 1999 (10 months) Englewood, CO
Colorado State University Marty Day is skilled in: Databases, Microsoft SQL Server, T-SQL, SSIS, SQL, Database Design, Database Administration, ETL, Software Development, IIS, SQL Tuning, Disaster Recovery, Oracle, Windows Server, Scrum, Integration, HTML, Software Documentation, Unix, Enterprise Architecture, Linux, MongoDB, Cassandra, Puppet, Ansible