SUMMARY

• Database Administrator, wif over 20+ years of experience in teh IT industry and 10+ years of experience in SQL Server and DB2 both LUW and zOS in large, mission - critical production environments.
• Experienced in establishing, leading, and working wif cross-functional teams wifin and outside of IT environment.
• Consistently recognized as having excellent interpersonal skills, and teh ability to work under pressure.

TECHNICAL SKILLS

Platforms: Windows, Unix, z/OS, OS390, Novell 3.11

Languages: PowerShell, VB, C++, Perl, Shell,, HTML, PL/SQL, SQL, T-SQL, VBA, COBOL, Pascal

Databases: SQL Server 7-2012, UDB DB2 for OS390 4-8, DB2 for Windows 5-9, Oracle 8i, Access 95-2000, Approach

Other: BizTalk, IIS, SSIS, SSRS, SSAS, SharePoint, Informatica, AutoSys, CA-7, JCL, MS Office, Lotus Suite and various Mainframe related utilities.

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Senior SQL Server DBA/SQL Engineer

Responsibilities:

• Manage and administer all aspects of multiple OLTP databases, this includes but is not limited to backups, restores, log shipping, batch processing.
• Review all pre-production SQL code to ensure standards are met, test and optimize for performance.
• Implement and manage database security.
• Review and make changes to existing disaster recovery methodology.
• Develop technical project plans for database upgrades to SQL 2012 and SQL 2016 in addition to identifying which new features will be implemented as well as changes required to take full effect of these features.
• Assist developers and report developers wif complex queries as well as maximize performance.
• Design and develop complex SQL code to perform mass updates based on client requirements.
• Design, develop and implement automated mass update strategy using SSIS vs current manual process.
• Provide 24/7 hardware, operating system, database and application support for all Viventium systems and vendor applications.
• Monitor and report on system and database performance and take corrective actions to reduce workload on systems.
• Perform all SQL production implementations and deployments.

Confidential, Yonkers, NY

Systems Engineer/Database Administrator

Responsibilities:

• Manage, modify and administer SQL Server Databases, including tuning, optimization, monitoring, backup, restore, space management.
• Install, configure, administer, and troubleshoot Windows servers, SQL Database servers and operating systems.
• Administer all Operating System, File and Database security for all environments.
• Develop technical project plans for major system and application upgrades.
• Create complex SQL Server stored procedures and optimize existing SQL code.
• Design and implement security, design and coding standard policies.
• Convert existing SQL Server 2000 DTS packages and MRS reports to SQL Server 2008 R2 SSIS packages and SSRS reports as well as create new complex SSIS packages and SSRS reports.
• Provide DBA and development support to teh Data Analysis & Reporting teams in Data Warehousing procedures, best practices, troubleshooting and optimization of new and existing SQL code.
• Provide 24/7 hardware, operating system, database and application support for all CMO and Call Center systems which comprise 258 servers, 61 SQL Server Instances, 286 OLTP databases, 784 Report and Support databases and 30+ vendor and in-house applications.
• Provide 24/7 support for teh Care Management Systems, Claims and Billing Systems and teh Data Analysis and Reporting Systems.
• Install, configure, administer, and troubleshoot BizTalk Systems.
• Perform analysis on existing SQL Server 2000 instances and develop project plans to upgrade and migrate to SQL Server 2008r2.
• Monitor and report on system and database performance and take corrective actions to reduce workload on systems.
• Perform all production implementations and deployments.

Confidential, Elmhurst, NY

Computer Systems Manager me - Database Administrator

Responsibilities:

• Team Lead for teh SQL Server and DB2 Database Administration Groups.
• Lead SQL Server DBA and Technical Services resource in teh Automated Meter Reading (AMR) project from start of project to current. Teh AMR system is comprised of 13 databases and 8 instances across different domains on SQL Server 2005 & 2008 platforms. Teh system is designed to collect water meter consumption readings from over 800K City of NY water customers at a minimum of 4 times per day. Teh database system processes in excess of 3 million inserts per day (24x7).
• Lead DB2 DBA and Technical Services resource for legacy Customer Information System (CIS) system. Teh CIS system is comprised of 2 DB2 for zOS sub-systems and 6 DB2 for Windows systems.
• Designed and implemented Centralized SSIS and SQL Server Processing Server, to consolidate all ETL packages from 20+ individual SSIS servers, which contributed in teh reduction of maintenance and support efforts.
• Design and develop all Integration Services packages used wifin teh OIT group.
• Convert DB2 (Windows & zOS), Access and Oracle databases to SQL Server 2005/2008.
• Provide production level 1 - 3 database support for SQL Server and DB2 as well as support of teh development and operations teams. Encompassing over 20 servers and over 40 databases.

Confidential, New York, NY

Consultant - Production Support Specialist

Responsibilities:

• Participate in planning, and in making recommendations to senior management regarding computing environment consisting of multiple sites and multiple shifts.
• On-site/remote technical and batch support of Global Business Unit Control System (Teh Americas, Europe and teh Far East), which comprised 12 Solaris Servers, 12 NT Servers, 15 Oracle and SQL Server Instances, 12 Power Mart Servers and 2 AutoSys Servers.
• Provide application support as well as monitor batch processing of over 7,000 jobs comprised of 3 production environment and 6 development environments.
• Troubleshoot any abnormalities in processing or wif system performance, take appropriate action to resolve teh problem or escalate to proper support team in a timely fashion as not to impact deliverable to teh users.
• Write/modify scripts as needed to correct or to enhance processing and/or usability.
• Write Oracle DDL/DML scripts used during testing and software releases.
• Write SQL Server Stored Procedures as needed for teh QA teams, for pre-release testing and data validation.