Postgres on AzurePostgres on Open VZPostgres RDS in AWSAerospikeMongoDBCosmos DB

Senior Database Adminstrator supporting:* MySQL and MySQL Replication* MongoDB* SQL Server* Hortonworks Hadoop

* Lead DBA and Dev Ops engineer for Ghostery Inc. * Developed tools in Powershell to manage our SQL Server database schema and convert our SQL Server schema to MySQL* Install and support MySQL, AWS Aurora, SQL Server 2014, Redshift and AWS EMR* Manage our AWS environment by creating EC2 instances running Ubuntu and CENTOS, configure S3 buckets, manage IAM and Security Groups* Evaluated and created proof of concept environments for the following database products * Postgres XL * Hadoop (Cloudera and Hortonworks) * Aerospike * VoltDB * Raven DB

• Team lead for the DBA team in the Salt Lake City office• Installing and administering Standalone, HP PolyServe and clustered SQL Server 2005 through 2012 database instances.• Installing and administering Sybase 15.03 and 15.5 database instances.• Mentoring new members of the DBA team.• Developing scripts using WMI, VBScript, C#, PERL and PowerShell.• Managing SQL Server upgrade projects

• Served as DBA team lead and infrastructure point person for Chicago• Designed and implemented the disaster recovery (DR) strategy for the MS SQL Server and Sybase database instances• Designed and implemented the database component of the bank’s (Sarbanes Oxley Audit) SOXA and internal audits by devising solutions in Oracle, Sybase and MS SQL Server • Built and supported MS SQL Server clusters• Developed database utilities and monitoring scripts utilizing T-SQL, SQL-DMO, SMO, WMI, ADO and VBScript

• Attended weekly sessions with the division president and his direct reports to assist in the process of converting business rules to applicable system solutions for both the bank and the bank’s external customers• Designed and developed a billing system that calculated the charges the bank’s customers incurred providing day trading services that resulted in a savings to the of over 2 million dollars in internal charges• Developed the batch application that extracted trading data from the ADP BPSA vendor application that populated the bank’s customer web site and generated and distributed the financial reports• Developed the SQL component of the internal billing system that allowed the bank’s Operations department to charge back for processed trades• Provided Sybase and SQL Server infrastructure and application production support • Met with the Bank’s clients to gather requirements, train their technical employees and install our application

• Managed the Sybase ASE and Replication Servers for our investment and trading systems• Installed, configured and implemented Sybase ASE and Replication Server software• Developed and designed a solution to replicate close of business data to our London, Chicago and Tokyo offices

• Functioned as lead database designer, developer and analyst for a medical management information system which supported the over 300 nurses employed by the insurance company• Developed stored procedures and “C” applications to stress test the application and facilitate database maintenance for a customer service application used by a WI based consumer Power Company

Functioned as Sybase and SQL Server database consultant where my expertise in database design, development and administration were utilized at numerous client sites. Customers included an accounting firm, a regional transit authority, a benefits consulting concern and a nuclear power plant

• Provided standard infrastructure DBA and performance and tuning support for production and development databases• Analyzed business scenarios to accurately understand and decipher the business rules for the project in order to accurately create a normalized data model• Provided expertise, support and training in the design of logical data models using the principles of normalization