Sql Server Database Administrator

DMITRII FOLOMEEV

**** **** ******* ** #*** San Diego, CA 92119 Ph. 224-***-**** ac27j5@r.postjobfree.com QUALIFICATION SUMMARY:

** ***** ** ********** ********* and maintaining databases. 5 years of experience developing software applications. 3 years of experience managing and leading teams of developers, report writers, network engineers

TECHNICAL SUMMARY

Operating Systems: Windows 3.x, 95, 98, NT, 2000, XP, Vista, 7,8,10; MS-DOS, Windows 2008, 2012 server

Databases: MS SQL Server 2005, 2008(R2),2012, 2014; MySQL, Interbase, MS Access

Software Tools: Crystal Reports, SharePoint, MS Office, Visio, DBA Tools Languages: SQL, Pascal, C++, Delphi

PROFESSIONAL EXPERIENCE

UCS-UKR

Kiev, Ukraine (1998 – 2000)

IT SPECIALIST

• Designed and optimized SQL Server databases

• Participated in development of applications

• Design numerous stored procedures, triggers and other database processes to support data flow in coordination with third party vendors

• Implemented data transfer processes with encryption

• Participated in implementation of SSRS and transition from Crystal Reports toSSRS environment

CS Control Ltd

Kiev, Ukraine (2000 - 2015)

One of the biggest dealers of UCS company in Ukraine (POS systems for restaurants, bar, hotels).

SQL SERVER DATABASE ADMINISTRATOR

• Performance, optimization, security tasks

• Backups, maintenance plans, issues with database errors

• Build SQL cluster and configured manual/auto failovers

• Participated from SQL side in building new web server

• Helped solve various issues with SSIS/SSRS

• Worked with developers to tune SQL queries, stored procedures, views and triggers.

• Installed database software and implemented log shipping for the disaster recovery sites.

• Created scripts used to recreate databases used by the nightly build process for the development environments.

• Created new queries, stored procedures, views and triggers.

• Designed and wrote the stored procedures and scripts used in the data migration process.

• Worked with developers, network administrators and system administrators to implement dependable database environments.

• Responsible for optimizing and normalizing database processes.

• Designed and implemented database changes.

• Reorganized databases and sized database objects to improve performance.

• Create add-hoc reports per customer request using Crystal or Excel.

• Familiar with pivot table and different operations within MS office.

• Reviewed and tuned SQL queries, stored procedures, views and triggers.

• Managed stored procedures, jobs, and utilized tracing to identify performance issues with deadlocks & other locking issues.

• Supervised the health of SQL Servers including backups, restores, monitoring.

• Analyzed issues related to SQL database server such as memory, CPU, I/O, Disk, and log files sizes.

EDUCATION

Pridnestrovsky State University

Moldova(1998)

Master’s Degree in Computer Science

Contact this candidate