SUMMARY
Seasoned SQL Server administrator experienced in all facets of database administration: server administration, performance tuning, storage allocation, replication, clustering, backup and recovery, and mirroring. Also experience leading diverse team supporting the server and storage infrastructure, software development, email/BES administration, data center operations and disaster recovery site support

SKILLS

• Databases/Languages: Microsoft SQL Server 6.5, 7, 2000, 2005, 2008, Microsoft T-SQL, VB.NET, Perl
• Operating Systems: Microsoft Windows 2000, 2003, 2008, VMWare ESX, Mac OS X, Linux
• Storage Area Network: IBM DS 4700/4800, Brocade Fiber Switches, Falconstor IPStor, Falconstor CDP
• Server Solutions: HP DL series, IBM X-series
• Applications: Platinum, Qlikview, QuickBooks, Peachtree, ADP, HRVantage/iVantage, Secretariat, The Museum System, Nagios, Lotus Domino, Blackberry Enterprise Server 4.1, 5.0, BrightStor Arcserve 12.5, DoubleTake, Microsoft Office: Word, Excel, Access, Project
• Trading Solutions: Charles River, Flextrade, Macgregor, VPM, Bloomberg
• Networking: TCP/IP, Microsoft Active Directory, SMTP, DNS, Apache, Tomcat

EXPERIENCE

Confidential, New York, NY 2002 - 2010
Server Administration Manager 2009-2010
Client Application Support Manager 2003-2009
Database Administrator 2002-2003

• Administered 35 + MS SQL Servers, including planning, clustering, design, development, production administration, upgrade, performance tuning & optimization, security, troubleshooting, back-up & recovery, change management, and documentation
• Upgraded SQL servers to SQL 2005/2008
• Successfully upgraded the BES servers to 5.0.1, utilizing mirrored SQL servers to provide failover protection
• Led network, server and storage infrastructure team maintaining Microsoft Active Directory, IBM X series servers, VMware, Lotus Domino, Blackberry Enterprise Server, SQL Server, Falconstor IPStor/CDP and IBM DS4700/4800 series SAN
• Headed the successful implementation of the IBM DS4800 SAN to efficiently manage the rapidly expanding storage requirements
• Successfully implemented VMWare in primary and disaster recovery locations utilizing a High Availability design, achieving 20% reduction in physical servers
• Implemented Falconstor IPStor to provide data replication to disaster recovery site
• Successfully upgraded the portfolio management system, VPM
• Supported trading environment: Charles River, Macgregor, Flextrade, Bloomberg
• Supported various client applications: Platinum, Qlikview, QuickBooks, Peachtree, ADP, HRVantage/iVantage
• Cross trained team members to ensure consistent coverage
• Contributed to a team that successfully built out disaster recovery site
• Compiled annual budget for my team
• Developed and successfully implemented move plan for 100+ servers for office relocation
• Implemented document management system and worked with end users to design their work flow

Confidential,Upper Saddle River, NJ 2001 - 2002
SQL Database Administrator

• Administered MS SQL Server database systems, including planning, clustering, design, development, production administration, upgrade, performance tuning & optimization, security, troubleshooting, back-up & recovery, change management, and documentation
• Analyzed data that define territory mapping of over 200,000 physicians for potential clients
• Trained junior DBAs in SQL language, AS/400 administrators, and network administrators
• Performed systems analysis and design; Developed and upgraded stored procedures, triggers, views, and DTS packages
• Managed a physician validation system that integrates MS SQL 2000 with AS/400 and Siebel ePharma 7. The system automatically validates over 200,000 physicians weekly according to current FDA regulations
• Reengineered data integration and process automation for existing systems and applications and back-office systems such as expense reporting and call reporting
• Upgraded MS SQL 7 servers to MS SQL 2000, verifying existing code base for compatibility
• Developed and managed data extracts and feeds to clients originating from various sources; AS/400, PeopleSoft, Siebel ePharma7, Access, and MS SQL Server

Confidential, Cincinnati, OH 1997 - 2001
Project Manager/Senior Database Administrator 2000-2001
Database Administrator 1999-2000
Developer/Network Administrator 1997-1999

• Administered MS SQL Server database systems, including planning, clustering, design, development, production administration, upgrade, performance tuning & optimization, security, troubleshooting, back-up & recovery, change management, and documentation
• Managed a team of Powerbuilder/SQL Server developers
• Developed and maintained database schema, stored procedures, triggers, views and DTS packages
• Created user interfaces to core business process using Visual Basic
• Managed developer outsourcing, administration, budgeting, deliverables and deadlines
• Assisted IT Director in developing IT strategic plan and budgets
• Oversaw co-op employees, led and mentored junior IT staff, conducted recruiting and first-round interviews for new IT staff
• Trained data entry, district managers and executives on the use of the in-house developed enterprise software which managed core processes of organization
• Analyzed geographic distribution of client data and optimize territory mapping with the existing field sales force
• Managed network and server infrastructure, including backup and recovery
• Migrated from MS SQL 6.5 to MS SQL 2000

EDUCATION

• Master of Business Administration, Management, 2000
• Bachelor of Business Administration, Information Systems and Management, 1996