Experience

American Financing

• Financial Services
• 200 - 300 Employee

• Senior Database Administrator

  • May 2020 - Present



COGNIZANT TRIZETTO SOFTWARE GROUP, INC.

• Sr. Manager of Database Operations

  • Sep 2014 - May 2020

  Englewood, CO



LenderLive

• United States
• Financial Services
• 100 - 200 Employee

• Director of Data Services

  • Aug 2011 - Sep 2014

  Glendale, CO - Developed a daily meeting to provide a communication stream between employees and management. This meeting was created to discuss issues and changes, as well as a method of providing information and training for staff. Since the inception of this meeting two years ago, the number of system outages has dropped 75%. - Implemented an automated, robust and dependable release process. This release process has reduced risk from manual processes, saving the team hours on each deployment… Show more - Developed a daily meeting to provide a communication stream between employees and management. This meeting was created to discuss issues and changes, as well as a method of providing information and training for staff. Since the inception of this meeting two years ago, the number of system outages has dropped 75%. - Implemented an automated, robust and dependable release process. This release process has reduced risk from manual processes, saving the team hours on each deployment of new code to production systems. - Reorganized my teams to optimize performance and simplify management. - Oversaw the design of a custom method for creating data driven subscriptions. - Managed the consolidation of five separate domains into one forest with three domains with trusts. - Migrated the entire critical SQL infrastructure to clustered servers as to improve hardware redundancy and fault tolerance. Additionally was able to consolidate multiple instances on separate servers to instances within these clusters thus reducing our licensing costs. - Created company wide visibility into service desk request queues for all of my teams. This has provided management more visibility to prioritize their department’s requests.

• Manager of Database Administration/Senior DBA

  • Jul 2010 - Aug 2011

  - Lead a project which ended up saving our largest client millions of dollars by architecting a solution to distribute and share data between 6 servers on 3 different domains varying from SQL 2000-2008 in less than 30 days. - Created a custom backup/restore log shipping policy to keep a warm standby of our production environment at a secondary data center for disaster recovery purposes. - Grew the production environment from six SQL database servers to more than 30 servers… Show more - Lead a project which ended up saving our largest client millions of dollars by architecting a solution to distribute and share data between 6 servers on 3 different domains varying from SQL 2000-2008 in less than 30 days. - Created a custom backup/restore log shipping policy to keep a warm standby of our production environment at a secondary data center for disaster recovery purposes. - Grew the production environment from six SQL database servers to more than 30 servers spanning five separate divisions, while maintaining standards for security, storage and performance. - Created and implemented security policies to monitor activities of all database activity, including that of privileged users to ensure compliance with company security policies. - Developed multiple policies to mitigate loss of data from poorly written DML statements. Additionally built a process allowing the recovery of lost data from any point in time in less than 20 minutes without having to lose any production data by restoring from a backup.

• Database Administrator

  • May 2007 - Jul 2010

  Glendale, CO - Created a disaster recovery model to copy backup files offsite from the production servers to another location. - Implemented SQL Server Reporting Services and created hourly and daily reports that are delivered via email and ftp. - Built an entirely new environment for a new client to house a database with more than 10 million loan and over 20 million applicant records (our previous environment contained less than 250,000 records). - Tuned countless stored… Show more - Created a disaster recovery model to copy backup files offsite from the production servers to another location. - Implemented SQL Server Reporting Services and created hourly and daily reports that are delivered via email and ftp. - Built an entirely new environment for a new client to house a database with more than 10 million loan and over 20 million applicant records (our previous environment contained less than 250,000 records). - Tuned countless stored procedures to return the data from 20 million rows so that results that previously took minutes take seconds

• Help Desk Supervisor

  • Jun 2004 - May 2007

  - Created and maintained a reliable computing environment both local and remote for 200+ users. - Created a ticketing process within our software bug tracking system to get away from working off of an email distribution list. - Built the support department from a single support specialist to three employees and offering support 24x7. - Built and maintaining desktops, servers and VOIP across multiple geographically diverse branch offices. - Headed up a small… Show more - Created and maintained a reliable computing environment both local and remote for 200+ users. - Created a ticketing process within our software bug tracking system to get away from working off of an email distribution list. - Built the support department from a single support specialist to three employees and offering support 24x7. - Built and maintaining desktops, servers and VOIP across multiple geographically diverse branch offices. - Headed up a small team to migrate several stand alone servers and applications to VMWare to add hardware fault tolerance.