SUMMARY

• Database Administrator, with over 20+ years of experience in the 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 with cross-functional teams within and outside of IT environment.
• Consistently recognized as having excellent interpersonal skills, and the 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 with 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 the 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 the Care Management Systems, Claims and Billing Systems and the 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 I - Database Administrator

Responsibilities:

• Team Lead for the SQL Server and DB2 Database Administration Groups.
• Lead SQL Server DBA and Technical Services resource in the Automated Meter Reading (AMR) project from start of project to current.
• The AMR system is comprised of 13 databases and 8 instances across different domains on SQL Server 2005 & 2008 platforms.
• The 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. The 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. The 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 the reduction of maintenance and support efforts.
• Design and develop all Integration Services packages used within the 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 the 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 (The Americas, Europe and the 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 with system performance, take appropriate action to resolve the problem or escalate to proper support team in a timely fashion as not to impact deliverable to the 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 the QA teams, for pre-release testing and data validation.

Confidential, Elmhurst, NY

Computer Associate Software II - Production Control Shift Supervisor

Responsibilities:

• Analyzed workload and assigned to staff accordingly.
• Assisted subordinates and supervisors in identifying and resolving problems.
• Analyzed and improved operations, which increased productivity.
• Designed and developed multi-user relational database applications and data collection procedures.
• Performed job scheduling to ensure timely, accurate processing and ensure balancing of job runs.
• Received, resolved, referred, and documented software, hardware, network, and procedural problems.
• Assisted Manager on all technical issues, updates, and changes that will affect the normal on-line/batch processing.
• Assisted DBA on basic DB2 functions, as well as substitute as DBA on call when none available.