Paul Winans 934 South Beulah Street Philadelphia PA 19147 ...



Paul Winans paul_winans@

OBJECTIVE

Employment where I can utilize my experience and attention to detail to make SQL Server perform quickly and smoothly and gladly assist developers, other dbas, and end users through clear communication at company where collaboration really happens and people plan for the future.

OVERVIEW

• Over 10 years of hands on production SQL Server 6.5-2005 support and administrative experience.

• Over 14 years IT experience in large and small groups.

• Expert level understanding of SQL Server, database design, sql coding and tuning, and replication.

• I am an automation expert, and can use DOS scripts, DTS, SQL, VB, WMI, and ingenuity to make the only requirements of a task be reading the successfully completed email.

• I am a fantastic problem solver.

EXPERIENCE

Textainer, Inc. 2/01 to 5/08 Senior DBA

• DBA with “buck stops here” responsibility for multi site and multi instance SQL Server 2000 and 2005 support in a .NET environment, managing over 30 SQL Server instances worldwide 24/7.

• Worked effectively and extensively with developers to teach query tuning and best practices. Gave classes on proper indexing and query optimization. Mentored junior dbas, local and overseas.

• Instrumental in troubleshooting performance and complex technical system problems.

• Performed all SQL Server maintenance, including patches and monitoring of databases and servers; kept development environments in synch with production environments.

• Automated SQL Sever installation steps including replication configuration scripts.

• Proactively collected server stats to identify and resolve performance and future capacity issues.

• Fully documented disaster recovery steps.

• Administered bidirectional transactional replicated network and database feeds to DB2 databases.

• Tested and migrated from SQL 7 to SQL 2000 to SQL 2005.

• Extensive sql query tuning.

• Reworked security model to meet SOX requirements requests.

• Reviewed objects and sql code to ensure performance and integrity.

• Expert understanding of DTS and command line tools.

2/00 to 1/01 Senior DBA and Engineer

• Lead DBA for SQL Server 7 site content databases.

• Responsible for performance tuning, overall recovery strategy and implementation thereof, and security standards.

• Co-designed and migrated company to new database schema.

• Wrote and optimized numerous stored procedures.

• Implemented transactional replication.

• Automated and performed SQL Server installations.

• Performed all SQL Server maintenance, including patches and monitoring of databases and servers; kept development environments in synch with production environments.

• Set up product search using full text indexes.

• Served as “how to” reference for developers and other dbas.

• Participated in full time 24hr support rotation with other dbas.

Charles Schwab, Inc. 1/99 to 2/00 DBA and Database Developer

• Technical lead on application (SQL Server 6.5 backend) to track company's and vendor's year 2000 remediation and enterprise-wide computer assessment software database.

• Mentored other developers.

• Implemented integrated security.

• Implemented backup strategy.

• Optimized stored procedures.

• Participated in database normalization and data migration.

• Proactively monitored databases and servers.

Montgomery Management, Inc. 11/98 to 1/99 Database Developer

• Designed and created secure, object-oriented Access 97 claims system for general underwriting company.

• Performed interviews with end users and managers.

• Trained end users.

The Provident, Inc. - 1/98 to 11/98 Database Developer

• Performed interviews, designed and created Access 97 application to validate, parse, produce exception reports, and upload data to SQL Server 6.5.

• Extensive SQL Server 6.5 development and troubleshooting, data validation, integration with legacy application, fine tuning and correcting/creating procedures for interface.

• Implemented backup strategy.

Lisbon Children's Center - 12/97 to 1/98 Database Developer

• Designed and created Access 97 database to simplify billing; computerize enrollment of students; store student, faculty, enrollment, billing, and expense information; create invoices and reports.

• Performed end user interviews.

• Trained end users.

Healing Hands Massage, Inc. - 10/97 to 11/97 Database Developer

• Performed interviews, designed and created Access 97 database that reliably tracks package ownership and usage (formerly a large source of income loss), as well as client and employee data.

• Setup replication for multiple offices.

• Auto backup using System Agent.

• Provided instruction and support to end users, and hardware installation.

Chemical Leaman Tank Lines, Inc. - 4/96 to 10/97 Database Developer and Network Admin

• Developed Access 95 app to track help desk's results.

• Provided Windows NT 4.0 and 3.51, Novell network, and cc:Mail 6 administration and support.

• General hardware repair and installation.

• End user support and PC and network troubleshooting.

Quality Greeting Cards, Inc. - 2/93 to 4/96 Database Developer

• Developed dBASE IV application to automate store layout and stock-control ticket creation, eliminating formerly manual task of writing hundreds of tickets.

• Provided instruction, hardware installation and support for end users.

EDUCATION

• Temple University, Philadelphia, PA, pre-physical therapy courses (predominantly science and math) 1992-95. 3.92 G.P.A.

• University of California at Santa Barbara, Santa Barbara, CA, Bachelor of Arts, English 1991. Recipient of Excellence at Entrance scholarship. Varsity crew for three years.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download