John Pastore Email & Phone Number

Build and manage epic software development and marketing teams to bring a new social classifieds website into being.

• Senior SQL Server DBA for the SharePoint team, as well as for dozens of other applications.• Provide 24x7 troubleshooting and Tier-3 support for 100+ instances of Microsoft SQL Server.• Maintain consistent development, testing, staging and production environments, both on physical machines and VMware virtual machines in four secure data centers.• Successfully designed and executed a plan to migrate 200 databases and 1.5 TB of data to a new secure data center, including auto-generating all T-SQL and Robocopy scripts in advance.• Troubleshoot problems by using SQL Server profiler, SQL Server Performance Dashboard Reports, Activity Monitor, PAL tool and Perfmon.• Routinely solve critical production problems, and perform point-in-time database recoveries. • Architect, design, install, configure and optimize SQL Server 2005, 2008 R2 and 2012 instances.• Responsible for many related technologies including installing Windows Server on both physical and virtual machines in VMware, implementing iSCSI as needed, allocating EMC and Clariion SAN LUNs and mount points, creating service accounts and adjusting GPOs in Active Directory, configuring networking and firewall rules, etc.• Apply SQL Server Service Packs to the current patch level, and Cumulative Updates as required to address specific issues.• Capacity planning including number of Windows and SQL Server cluster nodes and SQL instances, CPU and RAM speed and quantity, SAN optimization including LUN, RAID and spindle configurations.• Develop and implement sophisticated T-SQL and VBScripts for administration tasks.• Ensure high-availability and data security by implementing Windows and SQL Server Failover Clustering and SQL Server 2012 AlwaysOn Availability Groups, rigorous backup and recovery plans, SAN mirroring to disaster recovery sites, and implementation of Department of Homeland Security SQL Server hardening guidelines and auditing.

Alexandria, Va, Us

Provide high-level support for over 50 instances of Microsoft SQL Server 2000, 2005, 2008 and 2008 R2 across the enterprise. Ensure high availability in a mission-critical, secure production environment including backups, disaster recovery, and real-time system monitoring. Implement SQL Server high availability solutions including Failover Clustering, Database Mirroring, Log Shipping and Replication in 32- and 64-bit Windows Server 2000, 2003, 2008 and 2008 R2 environments. Perform regular maintenance including index rebuilds, reorganization and statistics updates. Apply and maintain service packs/patches for release management and to enforce security policies. Monitor database performance, identify issues, troubleshoot and optimize using Performance Monitor, Profiler, Execution Plans, Database Engine Tuning Advisor, SQL Nexus Tool, and Performance Dashboard Reports. Maintain thorough and rigorous documentation related to database server configuration, operation, and database change management.

Purchased, remodeled, rented, managed and sold investment properties in the metropolitan Washington, DC area.

Custom-wrote and managed professional three-tier e-commerce web application in ASP and SQL Server. Comprehensive DBA and systems administration responsibility for SQL, Windows and IIS Servers on production and development machines. Tested and rolled out all patches, updates and service packs for SQL and Windows Servers. Specified, tested and provisioned hardware, co-located production servers at internet service provider. Hardened SQL, Windows and IIS Servers. Set up ongoing SQL optimization, performance monitoring and backups. Hand-tuned queries, execution plans and indexes for maximum performance and scalability. Designed, normalized, optimized and indexed SQL Server database, fully programmed via stored procedures and thoroughly documented in Visio. Hand-coded fully object-oriented business logic layer in Classic ASP. Hand-coded all front-end programming in HTML, CSS, JavaScript and DHTML, both for end-user and administrative pages.

Arlington, Va, Us

Developer on a government contract to develop custom-written human resources web-based application in ASP and SQL Server.

Mclean, Va, Us

Led the team to develop and deploy an enterprise-wide system to automatically collect comprehensive asset information for 8,000+ PCs worldwide in over 30 countries. Adapted LAN-only COTS asset application to operate over WAN, managed development of a custom-written Visual Basic application, deployed FTP servers. Developed desktop application installer integrated with Novell Netware login. Produced comprehensive administrative procedures, best practices, and backups, as well as extremely thorough documentation (approximately 900 pages). Saved entire $80,000 project budget by updating, rather than replacing, the global employee database system. Tested and recycled existing idle hardware, deployed productions servers as well as redundant cold-spares, developed automatic server installer disks. Managed global system deployment, trained remote technical managers, fully documented system, installation, backups and procedures.

Mcts: Microsoft Certified Technology Specialist: Sql Server 2008 - Implementation And Maintenance

Mcts: Microsoft Certified Technology Specialist: Sql Server 2005 - Implementation And Maintenance, Microsoft Sql Server 2005

Mcse

Ba, Chemistry, Physics, Math

Physics