Sql Server DBA

Summary:

SQL Server Database Administrator with over 6 years of experience

developing business applications including database design, development,

and administration under MS Windows platform for Merchant Services, Real

Estate, Travel, Health Care, and Publishing Industries. Developed a broadly

evolved skill set and could be an asset to every project assignment.

Skills:

Operating Windows (2008/2003/7/XP)

Systems:

Technologies: SQL, TSQL, PL/SQL, XML, HTML, VB.NET

Databases: MS SQL Server 2012/2008/2005/2000, ORACLE 11g/10g/9i,

MySQL, MS Access

Tools and DTS, SSIS, SSAS, SSRS, BCP, ER-Studio, DBArtisan,

Application Rapid SQL, SQL*Plus, SQL*Loader, RMAN, MS-Visio, MS

Servers: Project, ER-Win, MS Source Safe, SVN, VNC

Professional Experience:

EVO Merchant Services Melville, NY

2012-present

SQL Server Database Administrator

. Manage all levels of database security and integrity, transaction

activity and utilization.

. Manage and maintain data in all production and developer

databases and replication servers.

. Develop Backup/Recovery strategy for databases with different

activities.

. Create different DDL triggers for both database and server

levels for monitoring user activities.

. Develop scripts and stored procedures for rebuilding and

reorganizing indexes.

. Implement SQL Server Mirroring and log shipping.

. Optimize T-SQL queries/indexes to enhance database performance.

. Set up and maintain failover cluster between 2 nodes. (SQL

Server 2000/2005/2008).

. Create stored procedures for monitoring disk space usage.

. Manage SQL Server Workload and System Resource Consumption

utilizing Resource Governor.

. Optimize SQL performance, partitioning, indexing, stored

procedures and DTS/SSIS packages.

. Create complex reports (SSRS) for senior management and

customers.

. Design and implement redundant systems, policies, and

procedures for disaster recovery and data archiving to ensure

effective protection and integrity of data assets.

. Collect and publish ongoing status reports on production

bottlenecks and issues.

Mondrus CCS Inc. Middle Village, NY 2008-2012

SQL Server DBA/ Database Developer

. Performed data migration from MySQL to SQL Server 2005. Designed,

created, maintained, and administered MS SQL Server 2005 databases.

Developed and maintained numerous stored procedures and functions

for a healthcare project.

. Implemented and troubleshoot different types of replications

(Snapshot, Transactional, and Merge) on SQL Server 2005, 2008 R2.

. Supported daily operations in a production environment by

proactively managing the performance, integrity, and security of

business applications' SQL Server databases and database servers.

. Created different packages using SSIS and numerous of reports using

SSRS.

. Conducted database migration from SQL Server 2005 to SQL Server

2008.

. Automated sales data loading processes (bulk copy, bulk insert),

create numerous back-end utilities for process automation (VB.NET,

Oracle 10g, SQL Server 2005).

. Upgraded from SQL Server 2005 to SQL Server 2008, developed and

maintained numerous stored procedures for a large Real Estate

client.

. Re-designed Oracle 10g database. Created numerous packages,

procedures, functions, and triggers for a state college. Other

responsibilities included development, backup/recovery (RMAN),

integration with external 3rd party packaged solution, performance

tuning.

. Imported production data to lower environments for testing purposes.

. For a travel agency client designed a database (SQL Server 2005),

consolidated product related data, and developed a set of stored

procedures to support automated data loading and publishing

processes.

. Established and maintained daily database backup procedures (SQL

Server 2005/2008).

. Installed, configured, and upgraded MS SQL server and client

software (SQL Server 2005/2008).

. Designed, created, maintained, and administered MS SQL Server

database for client's new suite of products. (SQL Server 2008).

Borisovskiye Manufactury Moscow, Russia 2005-2007

Business Analyst/Junior Database developer

. Generated numerous reports for upper management.

. Consolidated production data from multiple sources (Excel, MS

Access) into a SQL Server database (2000, 2005).

. Troubleshoot and resolved database issues.

. Installed, configured, and upgraded MS SQL Server servers and client

software (SQL Server 2000/2005).

. Created numerous of SQL Server Agent jobs. Developed different

Maintenance Plans.

. Interfaced with Microsoft and Oracle Corporation for technical

support.

. Conducted marketing research and prepared presentations for upper

management.

. Authored functional specifications for internal decision support

system.

. Assisted a team of web developers in writing stored procedures,

functions, triggers, and packages for internal asset management

system.

. Established and maintained daily database backup procedures.

Telephonnaya Birga Moscow, Russia 1995-2005

Business Analyst

Education:

. BS in Engineering, Moscow Auto-Mechanical Institute, Moscow, Russia

. MBA in Strategic Management and Entrepreneurship, Moscow

International Higher Business School (MIRBIS), Moscow, Russia

Certifications:

. Microsoft Certified IT Professional: Database Administrator 2008.

Contact this candidate