MICHAEL YITBAREK

Austin, Texas

521-***-****

adve2n@r.postjobfree.com

Professional Summary

Five years’ experience in Microsoft SQL Server Developer, Database Administration, database installation, configuration, maintenance, database Design, analysis, development, performance tuning, backup/restore and disaster recovery experience in SQL Server 2019/2017/2016/2014/2012/2008R2\2008.

SKILLS

Languages: C, C++, Python, Java, Java Script, HTML, SQL

Operating Systems: Windows, Linux

Technologies: Visual Studio, Power BI, Tableau, Jira, Remedy, Spotlight. REDGATE

Area of expertise

Experience in SQL Server Installation, Configuration, Upgrading, troubleshooting skills and Patching of Server.

Worked on SQL server licensing option and optimization based on server requirements.

Expertise in managing and running SQL Server on VMware machines.

Skilled in writing T-SQL scripting and PowerShell languages for sending statements to the server.

Extensively worked on SSIS/SSRS, Stored Procedures and Triggers, REDGATE tool, Active Directory, performed debugging, troubleshooting and performance tuning.

Experience in SQL Server Performance Tuning, Query Optimization, blocking and deadlocking issues, Server Connectivity and running Database Consistency checks Using DBCC.

Experience in troubleshooting SQL issues by using SQL Tools, Execution plans, Trace, Statistics, and index tuning wizard.

Extensive experience in creating and modifying stored procedures, indexed views, triggers, cursors, and functions to meet business requirements.

Expertise in implementing different types of high availability and disaster recovery mechanisms such as log shipping, database mirroring, clustering and Always on Availability group setup and configuration.

Worked on database replication to improve the availability and consistency of data.

Experienced in SQL Server Reporting Services (SSRS) installation, configuration and maintenance using visual studio.

Developed Integration Services (SSIS) for transformation and movement of data from SQL and non-SQL databases into SQL Server.

Hands on experience in supporting Azure, Migrating databases to Azure Cloud.

Work well 24 x 7 production database on call support.

Professional synopsis

Xcel Energy

SQL Server Database Administrator

From Oct 2021 – Present

Responsibilities:

Involved in installation, upgrade, configuration, and migration of SQL server in clustered and non-clustered production environments of SQL server.

Experienced in SQL scripts for creation and upgrade of databases, maintenance plans, user logins, database mail notifications, automation of network and server monitoring.

Expert in performing routine maintenance on database instances including applying updates, patches, and hotfixes.

Configured SQL server security with business requirements such as server logins, user account and passwords along with database object permissions.

Manage complex stored procedures, functions, triggers, cursors, indexed views, tables, joins and other SQL statements.

Involved in database migration and server consolidation along with users and login.

Participated in SQL Server upgrade from SQL server 2008 to SQL Server 2014 and 2016/2017/2019.

Plan and implement backup and recovery strategies for large databases in Production and QA environments to ensure recoverability of the data warehouse.

Ensure high availability by implementing failover clustering, Log Shipping, database mirroring or Always on Availability Group Configuration.

Managed snapshot and transactional replication in between SQL server databases.

Installed SQL Server Reporting Services (SSRS) to create a common report template and use SSRS data source connections inside the report.

Configured SSIS packages to change the connection string and update the value of a variable to transform data as per Business Required Document.

Monitored SQL server logs to ensure whether the backup operations, batch commands and scripts were completed successfully.

Environment: Microsoft SQL Server 2019/2017/2016/2014/2012/2008R2 and Windows server 2016/2012/2012R2/2008R2/2008 Enterprise server, Azure, Microsoft Visual Studio, Remedy, Spotlight.

Professional synopsis

Citi Bank

SQL Server DBA

From September 2019 – Oct 2021

Installed, Configured, Administered, maintained, and utilized policies and procedures for ensuring the integrity, validity, and consistency of the database.

Developed strategies for data acquisitions, archive recovery, implementation of data access and table maintenance of SQL databases.

Participated in capacity planning and reviewed database changes for system impact.

Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries.

Developed and implemented database performance monitoring processes and analyzed monitoring data for performance optimization opportunities.

Experienced and proficiency in setting up backup recovery strategies supporting high availability and disaster recovery.

Performed backup using backup compression and data compression in SQL server databases on clustered environment.

Maintained referential, domain and column integrity using constraints.

Analyzed traces, debugged stored procedures, triggers, and packages.

Migrated databases from SQL server 2012 to SQL server 2019.

Worked on database refresh by taking backup from production database to development servers.

Implemented high availability and disaster recovery setup on the various servers using windows clustering, replication, log-shipping, database mirroring and Always on Availability Group setup.

Implemented and tested the point in time recovery of the production databases.

Environment: Microsoft SQL Server 2019/2017/2016/2014/2012/2008R2 and Windows server 2016/2012/2012R2/2008R2/2008 Enterprise server, Azure, Microsoft Visual Studio, Remedy, Spotlight.

Professional synopsis

Database Developer

City and County of Denver

From January 2018 –Aug 2019

Responsibilities:

Developed and designed advanced SQL queries, procedure, cursor, triggers, and scripts used for data migration cleansing and conversion projects.

Created Database and table design and implementation for data warehouse and related Extract, Transform and Load (ETL) processes.

Collected and analyzed data for the Enterprise Licensing System.

Created stored procedures and queries.

SQL Server multi-dimensional data modeling and Stored procedure maintenance

Analytics and ETL enhancement as needed.

Extracting data from multiple sources, manipulating, and validating

Database performance, integrity, security for Power BI reporting

Performed optimization of the queries with modifications in T-SQL queries, columns, and normalization of data.

Experienced in creating SSIS packages using control and data flow elements.

Power BI

Education

Bachelor’s degree, Computer Science, Colorado, USA

Associate of Science, Information Technology, Colorado, USA

Contact this candidate