Yana Glozman Email & Phone Number

Fort Lauderdale, Fl

As a sole SQL Server DBA in a 24/7 environment performed day to day Database Maintenance tasks -- Clustered & Non-clustered Database Monitoring, Backups, Space Management, Resource Utilization, was responsible for performing object migration between all production and development database Servers.Managed SSIS packages, stored procedures, SQL jobs, and utilized Server Side tracing to identify performance issues with deadlocks & other locking issues. Implemented SQL Server Disaster… Show more As a sole SQL Server DBA in a 24/7 environment performed day to day Database Maintenance tasks -- Clustered & Non-clustered Database Monitoring, Backups, Space Management, Resource Utilization, was responsible for performing object migration between all production and development database Servers.Managed SSIS packages, stored procedures, SQL jobs, and utilized Server Side tracing to identify performance issues with deadlocks & other locking issues. Implemented SQL Server Disaster Recovery scenarios from main Production to a remote location.Initiated, planned and executed SQL Server upgrades from 2005 to 2008R2 to 2014 to 2016 and 2017. Was responsible for setting up, managing and troubleshooting SQL Server Transactional Replication.Installed and configured SQL Server 2005/2008R2/2014/2016/2017 for other business functions. Managed user and data security to allow access to appropriate resources.Was responsible for Infrastructure issues related to SQL database server such as memory, CPU, I/O, Disk, etc. Monitored log files to proactively resolve issues.Efficient response to database events in a production environment including resource management & performance monitoring of cluster administration, managing high-availability, database recovery, replication, DTS/SSIS etc. Show less

Sunrise, Fl

As a member of a Production Support DBA team was involved in a day to day production support tasks for a 24/7 financial services company.Set up and maintained bi-directional transactional replication on production environments.Provided technical expertise in the design, implementation and maintenance of relational database management systems (RDBMSs) that support business applications.Worked and coordinated with Data Administrator and Applications Developers to determine physical… Show more As a member of a Production Support DBA team was involved in a day to day production support tasks for a 24/7 financial services company.Set up and maintained bi-directional transactional replication on production environments.Provided technical expertise in the design, implementation and maintenance of relational database management systems (RDBMSs) that support business applications.Worked and coordinated with Data Administrator and Applications Developers to determine physical database design including the definition and creation of table spaces, tables, indexes, views, data sharing protocols and evaluated SQL access paths.Monitored relational databases to optimize database performance, resource use, and physical implementations of databases; addressed a variety of database integration issues including synchronization between databases, integration, maintenance/conversion, capacity planning issues, and new applicationsMaintained production RDBMS environments.Monitored and maintained database security and database software, in cooperation with data security administrators.Provided advice to applications programmers in the effective use of database languages; advised on troubleshooting, exception processing needs, and other data management issues.Maintained availability and integrity of databases through multiple access schemes; facilitated sharing of common data by overseeing proper key and index management and data dictionary maintenance.Monitored and managed database backups and logs; restored and/or recovered databases as required.Participated in 24-hour on-call support. Show less

Chicago, Il

Was in charge of a company-wide upgrade from SQL Server 6.5 to SQL Server 7.0 and from SQL Server 7.0 to SQL Server 2000.Developed and implemented disaster recovery procedures of production environment.As a sole Database Administrator was responsible for:* acting as a key contact person for Finance and HR Departments personnel and MIS Help Desk personnel in coordinating efforts to improve performance or solve system-wide issues and problems;* 24/7 development, test and… Show more Was in charge of a company-wide upgrade from SQL Server 6.5 to SQL Server 7.0 and from SQL Server 7.0 to SQL Server 2000.Developed and implemented disaster recovery procedures of production environment.As a sole Database Administrator was responsible for:* acting as a key contact person for Finance and HR Departments personnel and MIS Help Desk personnel in coordinating efforts to improve performance or solve system-wide issues and problems;* 24/7 development, test and production support of multiple SQL Server database environments that included Financials, HR and Time Tracking databases (total of 15 boxes with multiple databases on each box);* proactively monitored development, test and production systems and suggested and implemented changes to improve performance using Embarcadero DBArtisan, Spotlight on SQL Server, SQL Server Query Analyzer and SQL Server Enterprise Manager;* implemented and monitored backup/restore and disaster recovery processes using Veritas Backup Exec V.8 and SQL Server Enterprise Manager;* development, optimization and tuning of queries, stored procedures and triggers;* applied Upgrades, Service Packs, Patches and Fixes to SQL Servers and related software;* constantly monitored and maintained reliability, high availability and performance of all database environments;* created and maintained DTS packages;* SQL Server 6.5/7.0/2000 operational configuration;* development, test and production databases maintenance;* disaster recovery planning and implementation;* worked in close contact with network administrators to coordinate server hardware installations and upgrades;* enforced corporate standards for database designs.* full life-cycle development of internal financial data transfer applications. Show less