Database and infrastructure expertise for your growing small business

Maintain the database backend of the Xero web application with over 3 million users worldwide through on call database administration and work with teams in 3 different countries

• Help with database administration for a team of developers in San Francisco creating accounting software having to do with People administration (HR)• Developed a new continuous integration process which cut down release times from hours to less than 30 minutes• Created new SQL Server environments in Amazon Web Servers using Powershell and migrated live servers from Rackspace to AWS with less than an afternoon of downtime

• Convert older reports maintained in Excel to SQL Server scripts and stored procedures• Create SQL scripts to determine impacts of new compliance rules on the business using rolling time windows and rolling amounts• Train fellow analysts on basic and intermediate uses of T-SQL and SQL Server• Develop and maintain group SharePoint site• Advise management staff on developing new SQL Server

• Creating and editing stored procedures and views to support SSRS reports• Creating SSIS packages to export information to external and internal customers• Creating reports and dashboards using SSRS having mostly to do with financial information and web surveys• Work with users to define requirements for reports and exports

• Updated and created applications to improve Lab data in SQL Server 2005 databases through Access front ends along with creating SSRS Reports to access results• Took over as DBA and performed admin tasks such as backups, maintenance and performance monitoring• Helped with predictive analytics by optimizing queries written by lab staff• Maintained SQL Server Replication for field laptops that didn’t have any Wifi and needed to sync up to the system later

Made detailed reports about Call Center and Installation information.