Resume

Technology Summary

Over 12 years Microsoft SQL Server experience. Working in both small and large companies, I have developed, deployed, and managed numerous enterprise solutions. At every job I have successfully excelled at mastering new challenges and technologies and continue to develop a wealth of knowledge and troubleshooting skills. I find working as a Microsoft SQL DBA to be the most rewarding application of all these acquired skills.

 

Databases MS SQL Server 2000, 2005, 2008R2, 2012, using SSIS/SSRS, ETL, Stored Procs, Triggers, Functions
Tools SSMS, Idera, Red Gate, Visual Studio 2005-2012
Languages T-SQL, PowerShell, C#, XML, HTML, CSS, JavaScript, JQuery using ASP.NET, MVC, Entity Framework, LINQ, IIS 5/6/7
Platforms Windows Server 2003, 2008, 2012
Education BS in Computer Information Systems
Training Microsoft SQL Server 2012 (MCSA)
Microsoft Certified Systems Engineer (MCSE)
Cisco Certified Network Associate (CCNA)

Employment History

SQL Database Administrator – Stratosphere Casino & Hotel (ACEP LLC), Las Vegas, NV (2012 – 2015)

Senior IT resource for architecture design, deployment and management for all database servers, working with application and networking teams for all change management

  • Managed 50+ SQL Server instances virtual and physical on both stand-alone and failover clusters
  • Migrated 100+ SQL 2005 databases to SQL 2008R2 and 2012 clusters with SAN storage
  • Monitored SQL performance metrics to identify and troubleshoot performance and resources issues
  • Troubleshoot server/network related issues and diagnosed and tuned queries and indexes
  • Automated Red Gate backups and regular index maintenance scripts with alerting
  • Implemented Idera Compliance Manager for SQL auditing and compliance management
  • Maintained SSIS packages and SSRS reports pulling data from various casino systems
  • Maintained documentation for enterprise systems, servers and processes
  • Developed web apps using SQL, Visual Studio, MVC, and LINQ

SQL Data Warehouse Developer – Sunbelt Software, Clearwater, FL (2009 – 2011)

Worked in R&D division at anti-spam/anti-malware company providing data collection and data analytic systems for the software product development teams

  • Designed warehouse and extracted data from extremely high transaction volume servers, provided web portal with graphs and drill down analysis of business data
  • Designed web service processing 250K XML files/day, download FTP files, unzip and parse XML to perform SQL ETL for web portal display of real-time world-wide threat data
  • Designed Performance Monitoring System using SQL to bulk load 3 million rows/day, transform data and generate summary results and provide web based portal allowing visual results with graphs and drill-down analysis against 1 billion record database

SQL / Web Developer – Coastline Internet, Tampa, FL (2002 – 2008)

Developed various website and custom applications for various business

  • Built high performance ASP/SQL e-commerce website serving 1 million page views / month, custom content management system, inventory control, and order processing system, custom merchant integration, SQL based reports analyzing sales and inventory costs, shipping expense reports to monitor profit/loss, financial reports to reconcile merchant settlements
  • Designed Call Center Database Application using VB & SQL to process millions of prospect records/week. Setup on-site SQL database server to host the database and application
  • Architected and performed redeployment of company servers & network equipment and documented entire server network configuration

SQL / Web Developer – Buy.com, Aliso Viejo, CA (2000 – 2001)

Maintained middle-tier software solutions using ASP/SQL and Visual Basic. Maintained code for middle-tier systems such as Fulfillment, Gift Certificate, Product Catalog, Shopping, and XML document exchange for wireless store using SQL XML. Managed 50+ server web farm replication with Double-Take

SQL / Web Developer – Escrow.com, Irvine, CA (1999 – 2000)

As a member of the Product Integration team developed web-based B2B platform for auction and reverse-auction transactions with multiple payment services including escrow. Company acquired by eBay.com

Senior Windows Systems Engineer – FileNET, Costa Mesa, CA (1998 – 1999)

Provided system support and architecture/design for a corporate data center with 100 servers supporting 1,600 international employees

  • Provided Windows system administration and support for corporate IT infrastructure including Domain Controllers, Exchange, SQL database, and application servers
  • Infrastructure Consolidation Project – redesigned worldwide domain infrastructure and migrated infrastructure systems to a highly-redundant server architecture
  • Field Office Domain Integration Project – planned and integrated 35 national remote field offices and 300 computers into corporate domain
  • Server Performance Analysis – sized and configured new server systems and performance tuned production systems using automated performance logging and graphing

Senior Systems Engineer / IT Manager – CH2M HILL, Tustin, CA (1988 – 1998)

Hired as a Network Admin and promoted to Senior Network Engineer then IT Manager responsible for all IT financial, strategic and technical operations for the Southwest Region

  • Created annual IT strategic plan and IT budget for entire region (5 offices and 500 computers). Managed all capital and expense allocations while staying under budget every year.
  • Data Center Relocation – project manager for relocation of 350 computers and regional data center. Managed design and construction of data center and 3-day weekend disconnect and reconnect
  • Regional Help Desk – Raised IT support satisfaction levels to all time high implementing a three-tier model providing escalation, break/fix support, asset management, and management reporting.
  • Network Build – project manager for a new $250K network installation for Alexandria, Egypt project. Two month assignment included equipment transportation through customs, performed server and computer setup, network cabling, and trained local Egyptian support staff on network administration

Leave a Reply

Your email address will not be published.