Post Job Free
Sign in

Sql Server Database Administrator

Location:
Brooklyn, NY
Posted:
June 20, 2024

Contact this candidate

Resume:

Qualifications Profile

Solutions-oriented Senior Database Administrator, Microsoft MVP & MCP, with a proven track record in application development, system architecture & design, and database administration/engineering, as well as a skilled project leader who is team-oriented, and works well on solo initiatives, as demonstrated over 15+ years of experience in the management of critical database operations across multiple industries, including Banking, Financial, Media and Healthcare.

System Architecture & Design

Standardization & Automation

SQL Server Consolidation

High Availability/Disaster Recovery

SQL Server Migrations

Database Administration

Remote Management

Audit Discovery & Compliance

Monitoring & Reporting

Research & Development

Project Management/Strategic Planning

Performance Tuning & Optimization

Experience:

Pearl Knowledge Solutions, Inc. - Independent Consultant (6/2010-Present)

• High-level consultant/SME in Microsoft SQL Server stack for various industries.

• Leadership roles, mentoring junior DBAs, and hands-on work in data centers, consolidation, migrations, upgrades, HA/DR, and automation.

• Specialization in health check assessments, audits, and performance tuning & optimization.

InMoment - Senior SQL Server DBA/Consultant – (1/2021-9/2023)

Provide technical guidance during all phases of database related development process.

Work with vendors in evaluating and implementing new technologies.

Present technical information to peers and project teams.

Support other technology and automation projects.

Database installation, configuration, patching, monitoring, maintenance and version upgrades.

Problem isolation, root cause analysis and solution implementation.

Work closely with management, developers, project managers, technical staff and end-users to ensure

successful project implementation and deliverables.

Database solution design, performance monitoring, analysis and tuning.

Backup, recovery and DR testing and planning.

Develop, implement and enforce procedures, security policies, standards and best practices to support

the operation of database systems.

Ensure high availability and optimum performance of database systems.

Installing, maintaining Failover Clustered Instances & Availability Groups for HA, scale-out reads.

Clustering, SSIS, data transfers, replication, TSQL.

Research and test new database technologies, share knowledge.

Determine database structural requirements, analyze client operations, applications, review objectives

with clients, evaluate current systems.

Remain current with emerging technologies and suggest adoption when appropriate.

Broadridge - Senior DBA Advisor & Performance Optimization Consultant (2/2022-7/2022)

Evaluated the Database & Server Performance of Index tuning to identify and resolve performance issues on critical servers.

Focused on reviewing SQL queries and providing recommendations to optimize SQL queries.

Experienced in monitoring and troubleshooting performance issues and optimized TSQL queries, stored procedures, functions etc.

Investigated and resolved performance issues with their newly installed and critical 3rd-party financial systems and processes.

Worked closely with core development team & managers to review queries and provide tuning and best practice recommendations.

Canon USA, Inc. - Senior DBA Consultant Recovery Advisor (8/2020-10/2020)

• Led recovery of 500+ SQL Server servers after a security breach.

• Assessed situation, created project plan, and oversaw recovery.

• Rebuilt, deployed, and configured SQL Server clusters and databases.

• Implemented disaster recovery solutions.

Orolia/McMurdo - Senior DBA Consultant & Advisor (2/2020-5/2020)

• Architected Microsoft SQL Server database solutions using AlwaysOn Availability Groups.

• Managed High Availability (HA) and Disaster Recovery (DR) options.

• Experience in database administration, performance tuning, and automation.

• Assisted with data migration and index management.

MagnaCare - SQL Server Architect DBA (3/2019-2/2020)

• Extensive knowledge of SQL Server administration, high availability, and backup.

• Designed, implemented, and monitored database health and performance.

• Migrated/Upgraded SQL Server infrastructure to SQL 2016.

• Proactively resolved performance and capacity issues.

Dallas DBAs - Sr. DBA Consultant (1/2019-2/2019)

• Managed infrastructure performance and security.

• Conducted comprehensive health check reports.

• Implemented monitoring and performance tuning.

• Participated in disaster recovery planning.

DVG Interactive - SQL Azure Architect (9/2018-12/2018)

• Evaluated and assessed migration to Azure for NY DEP.

• Designed Azure architecture and migration plan.

• Calculated resource requirements and estimated costs.

UCBI (United Community Bank) - SQL DBA DB Architect (4/2018-8/2018)

• Developed SQL Server data center migration roadmap.

• Designed database backup and recovery solutions.

• Addressed migration challenges and DR options.

NYSED (New York State Education Department) - SQL Architect Advisor (9/2017-1/2018)

• Managed SQL Server databases from development to production.

• Configured and maintained servers for high performance and availability.

• Developed technical documentation and procedures.

• Provided infrastructure hosting recommendations.

UMS (Universal Management Solutions) - Sr. SQL DBA (1/2017-9/2017)

• Collaborated with 40 NYC agencies.

• Conducted health checks and security assessments.

• Assisted with Microsoft licensing and SQL Server migrations.

• Trained teams on health checks and performance analysis.

Canon USA, Inc. - Senior DBA Consultant Advisor (4/2014-2/2016)

• Managed 100+ SQL Server servers and databases.

• Standardized documentation and best practices.

• Implemented backup solutions and clustering.

• Designed ETL framework and automation.

Previous Work Experience Summary:

• GroupM, Senior DBA & Solution/Design Architect, 9/2013-1/2014

• Synovus, Senior DB Consultant & Advisor, 8/2012-7/2013

• Nassau County Department of IT, Sr. DBA Consultant, 2/2011-3/2012

• Integrity Staffing, DB Consultant, 12/2010-2/2011

• SQL Solutions Group, Project DBA, 10/2010-12/2010

• Ntirety Corp., Independent DBA Consultant, 6/2010-9/2010

• IBM Consulting Division, Senior Production DBA Contractor at CDI Corp, 9/2009-6/2010

• Deloitte And Touche LLP, Senior DBA Engineer, Manager, 12/2008-8/2009

• REDCATS USA, Senior Production DB Lead, 5/2008-11/2008

• THE BLACKSTONE GROUP, Sr. Database Engineer/Lead, 5/2006-3/2008

• INTERNET COMMERCE CORPORATION, INC., DB Manager SQL DBA, 12/1999-11/2000

• EISNER COMPUTER SOLUTIONS, Implementation Specialist DBA, 10/1999-12/1999

• COLE SYSTEM ASSOCIATES, INC., Lead SQL DBA Technical Consultant, 9/1998-9/1999

Education Training:

• B.A. Political Science, Brooklyn College, City University of New York, MAGNA CUM LAUDE, 1994

• Microsoft MVP Award for SQL Server, October 2010

• Microsoft Certified Professional (MCSA) SQL Server 2012/2014, License: 13578454, October 2016

• Completed Microsoft SQL Server 6.5, 7.0, 2000, 2005, and 2008 System Administration

• Completed Oracle 9i System Administration Certification Course

Author:

• "HealthySQL, A Comprehensive Guide to SQL Server Performance" - Apress Media

“SQL Server MVP Deep Dives, Volume 2” – Chapter 34. What are you waiting for? An introduction to

waits and queues. Author, and Contributing Tech Editor – Manning Publishers

Tools: Powershell/dbatools.io, RedGate Suite – SQLToolbelt, SQL Compare, SQL Data Compare, SQLBackup, SQL Monitor ApexSQLLog, Quest Spotlight, Lite speed, Idera DM, Erwin, SQLIO, MAP Tool, Visio, CommVault, Azure (IAAS, PAAS, SQL MI), AWS/RDS, MySQL Workbench.



Contact this candidate