Dorian Gitelman Email & Phone Number

New York, New York

Greater New York City Area

Installed SQL Servers 2005 and SQL Servers 2008 in Development, QA and Production environments.Installed and supported SQL Server Cluster, Transactional Replication and DB Mirror in Development, QA and Production environments.Consolidated data and migrated servers from SQL Server 2005 to SQL Server to 2008 with the goal of decommissioning servers.Assisted developers in writing the most sufficient T-SQL code, stored procedures and triggers.Implemented Disaster Recovery strategy, by offering best solutions according to Applications and Business needs.Involved in data capacity planning and strategy when engaging with Application owners and users.Provided and implemented best SQL Server high availability solutions.

TECHSKILLS:MS-SQL SERVER 2000, 2005, 2008. Oracle 8 and 9i.Front end applications: VB4,VB5, VB6, VBA, VB.NET and light experience with Java Operating Systems: Windows ,UNIX; Installed SQL Servers 2005 and SQL Servers 2008 in Development, QA and Production environments.Installed and supported SQL Server Cluster, Transactional Replication and DB Mirror in Development, QA and Production environments.Consolidated data and migrated servers from SQL Server 2005 to SQL Server to 2008 with the goal of decommissioning servers.Assisted developers in writing the most sufficient T-SQL code, stored procedures and triggers.Implemented Disaster Recovery strategy, by offering best solutions according to Applications and Business needs.Involved in data capacity planning and strategy when engaging with Application owners and users.Provided and implemented best SQL Server high availability solutions.Utilized SSIS packages to transfer data between servers.

Installed SQL Servers 2005 and SQL Servers 2008 in Development, QA and Production environments.Installed and supported SQL Server Cluster in Development, QA and Production environments.Consolidated data and migrated servers with the goal to decommission servers.Successfully migrated databases from SQL Server 2005 to SQL Server 2005 and SQL Server 2008.Worked closely with various business application teams to solve different back-end issues that would impact production.Offered solution and helped implement table partitioning on SQL SERVER 2005 to make it more efficient and better resolution for data warehousing and reporting purposes.Helped business team to load data faster using either BCP utility or BULK INSERT Worked with business teams on making better design of the applications, create indexes, breaking down stored procedures to make it run much faster. Worked with business teams to bring CPU utilization down from 90% to under40% by applying various database tuning methods.Worked with Oracle as a DBA Backup. Installed and configured Oracle. Monitored Oracle Production server. Managed tablespaces, grated users access, and monitored backup and maintenance plans.

Supported Production, Staging and Development SQL Server environments that were shared by multiple business critical applications.Installed SQL Server Cluster for both Staging and Production environments. Both environments were configured as Active-Passive.Consolidated many SQL Server databases to our shared environments.Installed and configured SQL Server 2008 for our Business Intelligence data warehouse.Migrated several SQL server databases from SQL server 2000 to SQL server 2005, and SQL server 2008.Performed day to day Database administrative duties, such as monitoring the whole SQL Server environments. Made sure DBA backup, optimizations jobs were running and working correctly. Governing the security of the SQL Server databases. Pro-actively worked with the users on making sure availability, scalability and performance of the databases would be at the highest and most efficient level.Worked on performance and tuning of the databases or developer's code to make sure the code is correctly optimized.

MS SQL Server DBASupported production and development environments of major online retail websites. Participated in implementation and provided support to the main POS, Data Warehouse, Accounting and Inventory system. Developed and implemented strategies for backup and recovery utilizing full, differential and transaction log backup methods. Created and implemented maintenance plans for each database to improve its performance and efficiency. Created and utilized the Transactional Synchronization of data between different servers using DTS packages and stored procedures. Implemented Migration process that involved conversion and manipulation of data between several systems. Successfully tuned database to better enhance performance. De-fragmented, rebuilt indexes. Recompiled and tuned store procedure to boost performance. Used profiler to monitor performance and detect performance issues. Maintained system security.

Part of team responsible for the development, implementation and support for the following systems: Accounting, HR, Real Estate Brokerage. Installed and upgraded the Oracle and MSSQL servers and applications tools, installed patches for Oracle and MS SQL servers. Creation of the MS SQL server and Oracle databases. Implemented, maintained physical and logical database layouts for the broker and HR on-line system - MS SQL server. Created Oracle Distribution system utilizing materialized views. Created and schedule scripts utilizing the BCP, MS DTS packages, Import/Export utilities, SQL Loader, stored procedures. Created and scheduled the backup scripts. Database performance monitoring using MS SQL - Performance and Profiler; Oracle - OEM, patrol, Toad and DBArtisan. Implemented MS SQL server transactional replication model for the broker database (installed distribution / publication / subscription databases, created publication, implemented backup procedures, and monitored replications).Application programmer activities:Participated in the development, implementation and maintenance of the CountyAll application. Real estate brokers used these applications to look up the properties, view maps, and real estate property information. Designed new HR, Accounts applications system based on the old systems utilized Oracle Forms and Access databases. New developed version used VB6/ MS SQL server architecture. Developed security system that gives appropriate access to different application forms depending on user's authorization level. Designed, developed, maintained and managed a reporting system that allowed real estate workers to schedule, view appointments with clients, print customizable Summary Reports.

Worked on the development of a complete Financial Data Warehouse Reporting System. Data Warehouse System Cube structure contained financial data and allowed financial analysts to view this data in Excel Spreadsheets format. Provided performance evaluation, attributions and other services to clients. Responsible for the Oracle and MS SQL Server installation and upgrading. Implemented and maintained security system in test and production. Implemented the backup procedures for MS SQL server / Sybase databases Created and implemented system conversion (from Oracle8i to Oracle9i). Successfully tuned database to better enhance performance. De-fragmented, rebuilt indexes. Recompiled and tuned store procedure to boost performance. Developed and implemented the Financial Data Warehouse Reporting programs. Used VB custom controls to graphically display data. Applications utilized ActiveX Controls in MS Visual Basic. The back-end was a Sybase database and Essbase database running on Sun Solaris OS. Applications interacted with the database using ActiveX Data Objects (ADO) and Essbase API functions to establish connection between Essbase and VB6. Created store procedures to transfer data from the Sybase data mart system to the Essbase Data Warehouse.

Education record

Computer Technology