Ensure the %99.995 uptime of a Cloud Services Marketing Management Application's Database Infrastructure. With over 70 SQL Instances and over 200+ databases, each with their own unique load profile. Responsible for the performance, maintenance, design of the hardware architecture, and development of utilitities and machanism to allow a team of 2 DBAs (to include myself) to meet these SLA requirements. Provided application support for the actual product and helped enable certain procedures and policy to protect the data.

Administer SQL 2000/2005 Servers - responsible for the backup, restore and moving of databases, tuning of stored procedures and queries, manage user account access at server and database levels, managed multiple SQL Server instances, managed logical and physical file access and storage requirements, performed DB optimizations.Administer SQL 2005 Test environment, where testing of High Availability Database Mirroring and Replication architecture is being tested for future roll-out.Perform installation and upgrades of SQL Server.Established and performed procedure for managing SQL Server Updates (patches)Design T-SQL processes, such as stored procedures.Authored reports utilizing Reporting Services SQL 2000Develop and implement ETL/SSIS SQL 2005 and DTS SQL 2000 processesDevelop VB6/VB.NET programming utilizing ADO/ADO.NETTroubleshoot problems in either Client side or Server side software - including Connectivity Issues within customer network or Internet, Internet Explorer/ActiveX Controls, IIS, SQL 2000/2005, Onbase DMS, Terminal Services, FTP, Client Side PC performance, Server Performance, and any other products installed at customer site by our organizationManage IIS - including creating/managing Virtual Directories, Application Pools, Server Extensions, and SSL Certificates.Manage FTP - including creating/managing user accounts local to the Web Server and internal user access via Active Directory, manage security ACL on shares within FTPManage staff members in auditing system data and review reports which may require system design revisions, such as Workflow Logic, VB Scripting, new Onbase Infrastructure objects, software upgrades to any portion of the KodataScan infrastructure which includes the above softwareDocumentation of all design implementation and considerations for KodataScan systemProvided phone support of all customer side hardware and software implementation - including Scanner Hardware, PC Hardware, PC Software