Resume of SQL SERVER DBA AND DEVELOPER

Title
SQL SERVER DBA AND DEVELOPER

Primary Skills
SQL Server 2000/2005 EnterpriseC/C++, Java, .NET, C#, COM+, Visual C++, HTML, XML, ASP, JSP, JavaScript

Location
US-NY-New York (will consider relocating)

Posted
Jul-17-07

SENIOR SQL SERVER DBA/DEVELOPER

• Over 7 years compound experience in IT, 5+ years solid SQL Server database administration & development experience with DBA duties
• Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2005
• Experience in developing and monitoring SSIS Packages and DTS
• Extensive experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity
• Solid experience and outstanding knowledge of high availability SQL Server solutions, including Log shipping, Replication and SQL Server clustering
• Extensive experience with Monitor, tune and analyze db performance and allocate server resources to achieve optimum db performance.
• Working Experience in designing, implementing, maintaining, and documenting complex database applications, and data warehouse in financial environments
• Hands on experience and outstanding knowledge of high availability SQL Server solutions, including replication and SQL Server clustering
• Extensive experience in design techniques, ETL processes, relational database theory, N-Tier development
• Excellent report creation skills using Microsoft Reporting Services
• Extensive experience Crystal Report, and Crystal Analysis
• Excellent communication, presentation and interpersonal skills
• Strong troubleshooting and organizational skill

TECHNICAL SKILLS

Category Technology
Database SQL Server 2000/2005 Enterprise
Oracle 8i/9i/10g
SQL, T-SQL, PL/SQL, SQL/PLUS
Performance Tuning, Capacity Planning
Installation, Upgrade, & Migration
ODBC, JDBC, OLE DB, DTS, SSIS
Operating Systems Windows Enterprise 2003/2000 Advanced Server/2000 Server/Windows 2000 Professional/Windows XP Professional/NT 4.0 Server
UNIX (Sun Solaris), Red Hat Linux
UNIX Shell Scripting
Applications Erwin 3.5/4.1
Crystal Report 8.5/9/10, Crystal Enterprise 10
UML
Visual Studio 6.0/.NET
Client / Server
Language C/C++, Java, .NET, C#, COM+, Visual C++, HTML, XML, ASP, JSP, JavaScript
Protocols HTTP, TCP/IP, FTP

EXPERIENCE

1. TD BankNorth, Portland, Maine
SQL Server DBA (Jan, 2007 - present)
TD Banknorth Inc. is a leading banking and financial services company which provides a comprehensive range of financial services: personal banking, commercial banking, insurance, investment planning and wealth management. My responsibilities in this bank were to support multiple SQL Server 2000 and 2005 databases, SQL Server 2000 to 2005 upgrading, and also developed and monitored SSIS packages.

• Managed the migration of SQL Server 2000 databases to SQL Server 2005
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Developed and optimized database structures, stored procedures, views, triggers and user-defined functions.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases
Environment: SQL Server 2000/2005 Enterprise, Windows Enterprise Server 2003,IIS 6.0, .NET,Microsoft Visio 2003, SFTP, Microsoft Reporting Service

2. U.S. Cellular Corporation, Chicago, IL
SQL Server DBA/Developer (June 2006 -- Dec 2006)
U.S. Cellular Corporation is a national wireless company, serving 6 million customers in 189 markets throughout 26 states. The project that I worked is a National Sale Tracking (NST) system, which uses Microsoft SQL Server 2000 and Microsoft 2000 advanced datacenter Servers, including 4 set of cluster servers. My responsibilities involved in writing store procedures, designing DTS packages, automating SFTP and migrating databases from UAT to Pilot and to Production environment. Also responsible to monitor and tune large databases for performance and availability, modify database structures, develop database backup/recovery procedures, provide support and guidance to operational models, and forecast database and platform resource utilization, consistence check, security administration, data quality, documentation, and technical support.

• Designed dynamic DTS Packages for Landing-Pad to transfer data between servers, load data into database, and archived data file from different DBMS.
• Automated and scheduled SFTP to transfer data from other systems.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis
• Scheduled and monitored all maintenance activities of SQL Server 2000 including database consistency check, and index defragmentation.
• Maintained cluster servers to provide high availability.
• Set up database backup and recovery strategies.
• Worked with development teams in the design of physical databases and in modification
• Ensured developers coordinated their efforts in managing and maintaining different application databases
• Provided technical support to internal developers and external clients

Environment: SQL Server 2000/2005 Enterprise, Windows Enterprise Server 2003, BizTalk Server 2004, IIS 6.0, .NET, Erwin, Microsoft Visio 2003, SFTP, Microsoft Reporting Service

3. Bank of the West, San Francisco, CA
SQL Server DBA / Developer (Jul, 2005 - Jun 2006)

Bank of the West now serves over 3 million households and businesses in hundreds of communities in 19 Western and Midwestern states. It provides a full range of commercial & individual banking products and services. The bank primarily engages in generating deposits and originating loans. My responsibilities in this bank were to develop, implement and maintain all databases including stored procedures, triggers, and complex queries, which include the administration of various bank databases in both development and production environment.

• Collected and managed data information including its branches, employees, subsidiaries, partners and stock holders
• Designed and implemented SQL Server 2000 databases for mission-critical business applications by using Microsoft .NET N-tier Enterprise Application Architecture
• Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications
• Created logical and physical database design, data structures, and implemented large databases using Erwin
• Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis
• Managed the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity
• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and SQL code
• Generated the weekly, monthly, and quarterly report by using Crystal Report

Environment: SQL Server 2000, C#, .NET, Rational Rose Enterprise, Erwin, Crystal Report 10

4. Patelco Credit Union, San Francisco, CA
SQL Server Develop/DBA (Dec 2003 -- Jun 2005)

Patelco Credit Union is one of the largest and most successful credit unions in the United States. During the term of contract, I focused on generating analytical reports of market research data and existing customer data, and reported to the Marketing Department.

• Developed and optimized stored procedures, triggers, and DTS packages.
• Used SQL programming knowledge to build internal data warehouse functionality
• Developed SQL Server applications, translate data and manage implementation to ensure successful execution of the application
• Troubleshoot databases and custom application issues
• Performed DBA duties including: database backups, restores, performance tuning, and capacity analysis

Environments: SQL Server 2000 Enterprise Version.

ComScore, Inc New York, NY
Database Developer (July 2002 -- Dec 2003)

ComScore is a global Internet information provider to which leading companies turn for consumer behavior insight that drives successful marketing, sales and trading strategies.
My job is to support the fast-growing ComScore survey business. It includes the development of DTS packages, creating complex T-SQL, and report design.

• Performed DBA duties including: database backups, restores, performance tuning, and capacity analysis
• Collaborated with web developers on the backend design and development to support the survey UI and applications. Ensure queries are optimized, tables are correctly indexed, and data is accurate.
• Developed and created stored procedures, advanced queries, triggers, views, indices, and functions for databases
• Work with end users to define, implement, and maintain their reporting requirements.
Develop and maintain complex DTS packages.

EDUCATION

BS in Computer Information System (Database Administration Minor) (2001)
@ Stony Brook University, NY
Microsoft Certified Professional

Certifications
Microsoft Certified Professional


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in US-NY-New York »
View all resumes in US-NY »

View other SQL SERVER DBA AND DEVELOPER resumes, Database Administrator resumes