Paul Samson

MS Certified Solution Developer

MS Certified Systems Engineer

Cell: 520-***-****

Email: acxu52@r.postjobfree.com

EDUCATION

B.S. UCSD

M.S. SDSU

SKILLS

10+ years relational database development, administration, design, and optimization

10+ years professional software design and development

Extensive SQL Server 2000-2014 and Oracle 8i-12c

10+ years experience with .Net technologies (C#, ASP .Net, ADO .Net, VB .Net)

Security Clearance

Active Secret in 2008 at Lockheed Martin

RECENT WORK HISTORY

8/16-present: Database Consultant, Arizona Community Physicians

• Redesigned database processes to more effectively utilize the maintenance window for a multi-terabyte system of SQL Server databases in a failover cluster and mirrored configuration supporting over one hundred physicians

• Worked with key stakeholders to architect the migration/integration of data to decision-support databases

3/12-6/16: Technical Lead, Database and Data Development Teams, Pima County

• Leader of the team responsible for the County’s Enterprise database infrastructure (SQL Server 2000-2014)

• Senior contributing member of the County’s team responsible for architecting and designing our Enterprise Data Warehouse, departmental Data Marts, and project-level OLAP cubes.

• Designed and optimized ETL processes

• Designer of dimensional models and analytical tools delivering valuable decision-support to the County’s leadership teams for financial forecasting, operational metrics, and public requests for information.

8/08-3/12: Database Administrator, City of Tucson

• Full database administration for dozens of enterprise-wide database systems on Windows, AIX and Linux platforms.

• Member of a team of 3 DBAs responsible for maintaining high-availability database systems to support the functions of the city’s operations: 45 Oracle, 43 SQL Servers, 4 mySQL, 2 Sybase

• Led the design and implementation of a SQL Server 2008 R2 Failover cluster using MS Server 2008 R2 supporting a multi-terabyte database application

12/07-7/08: Database Analyst/Software Developer, Lockheed Martin

• Complex stored procedure development against SQL Server 2000 and 2005 supporting application development.

• Built interfaces into the US Air Force databases to replace many paper-based processes for the Air National Guard.

• Designed new and enhanced existing ASP.Net web and client-server applications

• Implemented new features in an existing desktop application using .Net and SQL Server. This high-value application supports the day-to-day operations of the F-16 fighter training group within Lockheed Martin.

1/06-12/07: Sr. Computer Database Specialist, University of Arizona Cancer Center

• Rewrote all SQL Server stored procedures and User-Defined functions resulting in significant performance improvements in key reports providing decision support to researchers.

• Developed IIS-based web applications, targeting both ASP and ASP.Net platforms

10/98-1/06: Lead Software and Database Architect, Magnus Corporation/Title Security

• Designed a SQL Server database to support panoramic Virtual Tours of real estate over the internet.

• Developed many automated server-side processes in Visual C++ and Visual Basic to integrate and synchronize data with our partners (particularly Long Realty and the Hawaii MLS).

• Designed and developed a web-based process using .Net to provide a daily MLS synchronization of flat files and images into our on-line, searchable database, providing a valuable add-on to our customers and their web-site visitors.

8/98-1/03: Senior Database Analyst and Software Developer, National Airlines

• Performed a technical review of a 3rd Party-developed SQL Server database for the airline which supported their OLTP and decision-support systems. This analysis led to significant performance gains, resolving problems in critical business metrics.

• Co-led an effort to pull in house a complex (150 module) vacation and tour system from an external vendor. These applications were developed in Visual C++/Basic, consisted of 20 executables and over one hundred COM-based components. This application was an important source of revenue to the airline.

12/96 - 1/99: Senior Database Designer, EmeraldNet/Atlantic Records

• Designed a high-transaction volume SQL Server database, enabling analysis of web-site traffic statistics.

• Developed reports against this database to drive marketing and sales decisions based on customer use of the web site.

Contact this candidate