PROFESSIONAL EXPERIENCE

SQL Server Database Architect

Confidential, NYC, NY

• Manage 1500+ database servers for various NYC agencies. Lead architect responsible creating multiple server models for HA/DR which included deploying SQL Database Mirroring, SQL Replication, SQL Failover Clustering and SQL Availability Groups. Responsible for ongoing assessment of database performance and the identification of administrative problem areas (installation, space management, backup & recovery, patching, upgrades, ETL processing etc.). Duties including optimizing query performance, index review and SSIS package management and creation
• Lead DBA resource responsible for migrating new and current production RDMS solutions to Microsoft Azure. Duties including assessing project feasibility for using SQL Server in a PAAS or IAAS configuration. Providing assistance in the migration of SSIS jobs (ETL) to Elastic Jobs and consulting service for the migration of SSRS reports to SharePoint or Power BI. Providing assistance in the integration of on premises AD with the SQL Azure security model. Configuring alerting & monitoring Azure RDMS and deployment response procedure and notifications.
• Developed data security (DLP) practices in order to meet various agencies NIST, PCI, HIPAA, FedRAMP, and SOX requirements. Trained junior level staff on various 3rd party products (Imperva SecureSphere, IDERA SQL Compliance Manager) to identify items related to excessive privileges, database misconfigurations, and server misconfigurations. Engaged with internal and external auditors on database security and compliance issues
• Lead administrator responsible for the management of Tableau Server. Responsibilities include implementing proactive Tableau environment health checks and performance threshold alerting, data usage, data security, and backup and recovery procedures.

Senior Database Analyst

Confidential, NYC, NY

• Conducted data mining and data modeling in coordination with the finance & compensation departments. This effort contributed to the implementation of a new medical payment procedure which helped to decrease annual medical cost by 2% on average per member
• Collaborated with various medical facilities to develop daily data feeds for medical billing and payments. Coordinated with medical IT staff on the data security issues in the proper handling and transmission of PCI, and HIPAA data.
• Developed Microsoft SQL SSIS packages to cleanse data before data loads into the organization’s data warehouse.

Senior Database Engineer, MS SQL Server DBA

Confidential, NYC, NY

• Provide 24/7 support for Production, QA and Development databases running on Microsoft SQL Server 2000, 2005, 2008, 2012, and 2014 and Oracle 9 - 10g. Duties involved working with internal and 3rd vendor application providers in the deployment of various business line databases. Duties involved working with various IT and business groups with the deployment of various need based HA & DR solutions
• Senior SQL Server DBA responsible for troubleshooting database service disruption events, identifying performance bottlenecks (SQL Server service-side trace, SQL Extended Events, SQL Server Resource Governor, and SQL DMVs) and capacity issues in a VMWare virtualized environment.
• Lead DevOps SQL Server DBA responsible for providing technical directive on RDMS data security practices (data encryption, data obfuscation, system authorization, user authentication, and event logging) related to HIPAA and PCI data protection liabilities.
• Research new technologies and solutions to support the business and technical security requirements of the enterprise. Assess existing platform and application hardening guidelines against industry standards. Assist with the development and implementation of global security policy, standards, procedures and work instructions to ensure ongoing maintenance of security
• Participate in the investigation of security violations originating both external and internal to the organization. Establish monitoring measures to detect security breaches and policy violations. Consult with the Security Governance staff and IT Staff to ensure that security is factored into the evaluation, selection, installation and configuration within all application(s) and supporting databases.
• Designed and deployed an enterprise wide IT security domain compliance framework for the city’s RDMS systems. Documented risk issues in the Client designated risk register and provided risk remediation recommendations that the business and technology units could implement to mitigate identified control gaps.
• Ensure standard security operating procedures/standards and where necessary evaluate and implement new, and manage existing, IT security solutions to meet Governmental and Industrial security requirements such (HIPAA, NIST, PCI)

Database Engineer Manager (MS SQL Server, Oracle 11G, SharePoint 2010)

Confidential, Hoboken, NJ

• Senior DBA member responsible for administering the company's Microsoft SQL Server 2000, 2005, 2008 R2, Sybase, and Oracle 10g databases. Duties included production maintenance, patch release, query troubleshooting, performance tuning, SQL Server Log Shipping, active/active and active/passive clustering, replication, backup and restore, disaster recovery and BCP planning.
• Designed and developed various business SSRS/SSIS ETL and reporting solutions for various business financial reports
• Administered and maintained the SharePoint 2010 BI Portal, data warehouse, and existing BI solutions.
• Analyzed existing database architectures and developed solutions to proactively resolve actionable items related to performance tuning, alerting and monitoring in production, UAT, and development.
• Developed security auditing procedures, authored weekly security incident reporting for the compliance and security teams. Provide technical guidance, knowledge transfer in areas of business process improvements and security enhancements.

Investment Banking Division Application Support Group Manager

Confidential, New York, NY

• Responsibilities included managing a global team of offshore (12) and FTE (8) resources tasked with managing the health of 56 Investment Banking, Commercial Real Estate, and Private Wealth Management applications in 4 global data centers.
• Team was tasked with identifying and troubleshooting application issues, issue(s) resolution or escalation to the appropriate development team when required.
• Team was would perform root cause analysis, user management communication with other Infrastructure Service Support team members.
• Attend development, and business application sessions as scheduled to ensures all production changes are made in accordance with lifecycle methodology and risk guidelines.
• Collaborated with technology continuity management, line of business (Lob) management, external business partners and key IT staff members for the purpose of planning, directing, controlling and maintaining an effective IT DR Recovery Plan. Conducted bi-annual Disaster Recovery exercises for all LOB applications

Infrastructure Operations Manager

Confidential, New York, NY

• Senior DBA responsible for maintaining the database production plant consisting of SQL 2000 and Oracle 9i. This included the migration of several Filemaker, 4D, and Oracle9i databases onto SQL 2000 databases. DBA duties included performance tuning, server sizing, backup and recovery. Database optimization duties involved the creation and maintenance of partitioned tables, stored procedures, triggers, views, and maintaining clustered/nonclustered indexes.
• Designed and implemented high availability architectures that supported solutions based on 3rd party (Lawson Software) and custom built in-house applications.
• Designed and deployed Windows 2000 Active Directory infrastructure spanning 4 regional offices (Manhattan NY, CT, PA, and Melville NY).
• Deployed and maintained an Exchange 2003 infrastructure for 500 users encompassing the company’s regional offices.
• Documented, trained, and conducted annual testing of disaster recovery plans.

Microsoft SQL Server DBA (Contractor)

Confidential, New York, NY

• Maintained daily database integrity and security operations such as creating MS SQL database objects (tables, stored procedures, views, indexes, etc.) in addition to monitoring database system resources.
• Implemented data recovery (on/off-site storage), database maintenance, access control and authorization for Oracle 8 and SQL 7.0.

SQL Server Database Administrator Senior Technical Officer

Confidential, New York, NY

• Level 3 DBA for several Oracle 8 and SQL Server 6.5 databases used by the Retail Comptroller's division.
• Supervised the support team tasked with the health management of a variety of Web-based and client/server applications.

Microsoft Windows Architect (Contractor)

Confidential, New York, NY

• Assisted in the migration of the New York server farm from Novell to Windows NT 4. Trained the NY IT staff in the deployment and maintenance of the Windows NT application servers.
• Sybase 10 Administrator for the Corporate Sales Team Web farm, daily tasks included backup/recovery, TSQL scripting, and database design.
• Developed proof of concept intranets operating on Microsoft IIS with Perl, Active Server Pages, Essbase Web Gateway and Sybase System 10.

Windows Programmer (Contractor)

Confidential

• Lead Visual Basic programmer tasked with designing and maintaining various Windows based reporting applications for Chemical Bank’s Retail Banking Division.
• Visual C++ programmer on the Bank of Montreal’s Database Warehouse team responsible for coding ETL modules to migrate monthly mainframe data feed.
• Lead PowerBuilder programmer at CoreState Bank (PA) responsible for converting a mainframe reporting application to a desktop based application for senior management.NYC