.

* ** *

ALEXANDER GOFMAN

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 demonstrates a passion for learning and implementing new technologies.

EXPERIENCE

Senior Technologist and DBA

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

• 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 PowerShell ETL applications for the external FTP and SFTP connections to the third-party companies, like Neiman- Marcus and SAKS

• 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

Database Manager

November 2013 - November 2021 Hermes of Paris, New York, NY

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

CONTACT

ad3faa@r.postjobfree.com

LinkedIn Profile

Brooklyn, NY

SKILLS

• Dependable and Reliable

• Team Player

• MS SQL Server

• Visual Studio

• ETL

• SSIS

• SSRS

• SSAS

• PowerBI

• PowerShell

• Azure

.

2 of 4

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

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

• 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

• Database conversions and migrations of the databases between different SQL instances, including the migrations to Azure

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

• Patching and migrations of the Manhattan Scale environments and creation of the Scale/Cegid custom reports

SQL Developer

April 2013 - October 2013 NYC Department of Health and Mental Hygiene, Long Island City, NY

• Developed complex SQL queries to retrieve data from multiple tables for reporting purposes.

• Responsible for the development of the PowerShell scripts, auditing more than 40 SQL servers, and SQL performance tuning. 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.

• Interacted with clients, team members and outside auditors regarding database security.

• 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

November 2009 - 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

.

3 of 4

• 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 the 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 System Administrator

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

• Installed Office SharePoint Server 2007 and configured site for data exchange with another medical facility

• Supported Kronos Stromberg, OneApp Symed, Blackberry Enterprise, Symantec Backup Exec

• Supported Lawson ERP, including Procurement/General Ledger/Accounts Payable/Asset Management

• Installed and supported Cognos Finance and Analyst applications

• Created startup scripts and GPOs, mapping shares and printers, controlling WEB access, changing user profiles and deploying various applications

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.

.

4 of 4

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

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

CERTIFICATIONS

• Microsoft Azure Fundamentals

• Microsoft Certified System Engineer (MCSE Windows 2000)

• Microsoft Certified Professional+Internet (MCP+Internet)

• Microsoft Certified System Engineer (MCSE Windows NT)

Contact this candidate