Senior MS SQL Database Administrator with 20+ Years Experience

ALEXANDER GOFMAN

SENIOR MS SQL DATABASE ADMINISTRATOR

- LEVERAGING +20 YEARS OF EXPERIENCE

*********@*****.*** c: 646-***-**** Brooklyn, NY

CAREER OBJECTIVE

Hardworking, highly motivated professional eager to lend combined knowledge and skills to enhance business performance. Operates well in both individual and team capacities, leveraging seasoned work ethic to quickly adapt to different processes and drive company objectives. Resourceful and results-driven with a passion for growth and efficiency to meet company needs and increase service value. Excellent problem-solving and communication skills and demonstrated passion for learning and implementing new technologies.

SKILLS

Dependable and Reliable, Team Player, Azure, Dell ESX, MS SQL Server 2012/2014/2017/2019/2022, Visual Studio, ETL, SSIS, SSRS, SSAS, Microsoft Power BI, PowerShell, Python, Jira, AppDynamics, ServiceNow, SolarWinds, OpCon, Azure. AWS

EXPERIENCE

Senior DBA

May 2024-January 2026 Jefferies (Uebiz), New York, NY

Orchestrated a company-wide optimization project for MS SQL, that improved the query performance by 25%

Tuned the complex queries by introducing the proper indexing, partitioning and compression

Championed the adoption of the database automation for the routine maintenance tasks, freeing up 20 hours per week for the database team to focus on strategic initiatives

Established the advanced rules for monitoring

Designed, configured and optimized the usage of MS SQL replication for tens of servers

Coded the new DB archival solutions, reducing the size of the primary dbs by 80%

Senior Technologist and DBA

November 2013 - July 2023 Hermes of Paris, New York, NY

Researched and recommended new Azure database technologies and tools, resulting in 15% improvements in database performance and 10% reduction of operational costs

Supervised the design and deployment of 2 new Azure warehouses to support BI initiatives, which led to $30M additional revenue

Achieved 99.99% uptime all Azure databases under management

Configured tens of SQL servers, including the MS cluster instances and SQL AOAG instances

Planned, designed and implemented the e-faxing corporate solution from the Concord Fax

Created the Opcon schedules/programs for the automatic data refresh of the Manhattan Scale Test environments, including the sensitive data anonymization

Database security and auditing, monitoring, performance management and tuning, fault analysis and resolution, backup and disaster recovery procedures for more than 50 servers in the ESX environments

Created the PowerShell scripts, comparing the user’s data in AD with the one in the Cegid ERP and updating the users records in Cegid

Designed the ETL SSIS package with the custom coded VB.NET, updating the Momentis ERP with the EDI data

Designed the SQL replication, feeding the reports for the third-party SSRS with data from Cegid

Created a unique technology/stored procedures for the SQL maintenance to report the SQL blockages and to initiate the SQL db snapshots

Configured the Power BI servers and reports

Database Administrator

December 2012 - April 2013 Allscripts, Garden City, NY

Designed customized maintenance plans for specific database usage.

Provided technical support for database applications and systems, including troubleshooting and resolving issues.

Database security setup and Audits.

Designed the ETL SSIS packages for the FTP data transfer from the SFTP Emblem Health site and uploads to SQL, using Putty and CodePlex SSIS ZIP extension

Created the SSIS package, providing the custom coded VB.NET log shipping for the 16 remote Allscripts dbs., feeding the reporting data warehouse of the Allscripts SSAS Analytics

Database and Applications Administrator

October 2003 - November 2012 Queens Long Island Medical Group, Garden City, NY

Developed database objects such as tables, views, functions and stored procedures to support application requirements.

Designed the Billing reporting database using Erwin

Database security and auditing, monitoring, performance management and tuning, fault analysis and resolution, backup and disaster recovery procedures

Database conversions and migrations of the databases between different SQL instances

Designed the SQL replication for the OneApp Symed dbs for reporting, implemented mirroring and log shipping

Created SQL stored procedures to report directly from Lawson DB and SYMED using Crystal Enterprise with SMTP report delivery

Created Formscape projects to print out graphic forms (checks, purchase orders) for Procurement/Accounts Payable from Lawson DB and linked them to RightFax for automatic fax delivery

EDUCATION

Microsoft Azure Fundamentals Cert Prep, Linkedin.com

Prepare for the AWS Certified Cloud Practitioner Certification Exam, Linkedin.com

Google Cloud Platform Essential Training for Administrators, Linkedin.com

Agile Software Development, Linkedin.com

Snowflake Hands on Essentials – Data Warehouse, Snowflake.com

IBM WebSphere Application Server v6.1 Administration on Windows WA361, Jack Morton

Microsoft Office SharePoint Server 2007 Administration, Learning Tree

Oracle DBA, New Age Training, Inc.

Structured Query Language using Oracle/Front-End Development using Visual Basic, American Training Center

M.S in Computer Science, Russia, Moscow University of the Oil and Gas

CERTIFICATIONS

Microsoft Azure Database Administrator Associate

Microsoft Azure Fundamentals

Microsoft Certified System Engineer (MCSE)

AWS Cloud Practitioner

Contact this candidate