Sql Server Data

Konstantin Zolotarev

email: ********@*****.***; phone: +1-438-***-****

DBA

More than 16 years of work experience in the IT industry;

Strong knowledge of MS SQL Server, T-SQL, SSIS, SSAS, SSRS, MDX, Oracle, PL/SQL, MySQL, Sybase, DB2, MS Dynamics NAV, QlickView, Crystal Reports, XML, SharePoint, PowerShell, C#, Visual Basic, JavaScript, PHP, HTML, DHTML, CSS, jQuery, IIS, WMware, Windows Server, Linux, Exchange Server, Amazon Web Services.

Languages: English, French.

Work experience in American and European companies;

Knowledge of Telecommunication and Banking domains;

Strong problem solving, analytical and communication skills.

Education:

Master's degrees in Computer Science.

Certification:

70-461 Querying MS SQL Server 2012.

Employment:

Jul 2015 – up to now DBA at IT Consulting.

- 24/7 support MS SQL Servers(2005/0812/14).

- Install and configure Database Instances and related services.

- Server security(AD, login, user, schema).

- Server monitoring, optimization and performance tuning.

- Manage and control of ETL jobs(TSQL, SSIS).

- High availability and disaster recovery.

- Backup and restore databases.

- Manage and configure databases.

Dec 2014 – Jun 2015 DBA at NOVADBA.

- 24/7 support MS SQL Servers 2008/12 (SSMS, SSIS, SSAS, TSQL, PowerShell).

- Install and configure SQL Server and related services.

- Manage SQL Server Agent.

- Server security.

- Backup and restore databases.

- Manage and configure databases.

- Maintain database integrity.

- Import and export data (TSQL, SSIS).

- Maintain indexes.

- Identify concurrency problems.

- Server monitoring, optimization and performance tuning.

- High availability and disaster recovery.

Nov 2012 – Nov 2014 DBA at Luxoft Ltd.

- Develop existing databases.

- Develop and maintain processes to automate ETL of data.

- Write stored procedures, functions and triggers.

- Query optimization.

- Perform data analytics and manipulate data for reporting (SSRS).

Oct 2011/10 – Oct 2012 DBA at KBK Ltd.

- Implement control flow (checkpoints, debug control flow, transactions, implement the appropriate control flow task to solve a problem, data profiling and quality).

- Implement data flow (debug data flow, implement the appropriate data flow components.

- Implement dynamic package behavior by using property expressions.

- Implement package logic by using variables (system variables, user variables, variable scope).

- Implement package configurations.

- Implement auditing, logging, and event handling (uses system variables for auditing, use event handlers, propagate events, use log providers, data profiling).

- Deploy an SSIS solution (deploy SSIS packages by using DTUTIL, deploy SSIS packages by using the deployment utility, deploy SSIS packages to SQL or file system locations).

- Manage SSIS package execution (schedule package execution by using SQL Server Agent, execute packages by using DTEXEC, execute packages by using SQL Server Management Studio).

Mar 2006/03 – Sep 2011 at INS Ltd.

- Implement dimensions in a cube (attribute relations, hierarchies, translations).

- Implement measures in a cube (measure groups).

- Implement a data source view (named calculations, named queries).

- Configure dimension usage in a cube (implement reference dimensions, implement many to many relationships, implement fact relationships, implement role-playing relationships, define granularity).

- Implement custom logic in a cube by using MDX (actions, KPI, calculated members, calculations).

- Implement storage design in a cube (aggregations, partitions, storage modes, proactive caching).

- Implement report data sources and datasets (query types, dynamic data sources, filter location).

- Implement a report layout (apply conditional formatting, page configuration, headers and footers).

- Implement report parameters (data bound parameters, multi-value parameters).

- Implement interactivity in a report (drilldown, drill through, interactive sorting).

- Implement report items (matrix, table, chart, image, list, grouping).

- Configure report execution and delivery (subscriptions, report caching, schedules, snapshot history).

- Deploy an SSRS solution (RS.exe scripts, report builder, BIDS).

Oct 2002 – Feb 2006 DBA at Oil plant Ltd.

- Install and configure SQL Server and related services.

- Manage SQL Server Agent.

- Manage SQL Server security (logins, roles, permissions, audit).

- Back up databases (full backups, differential backups, transaction log, compressed backups, file and filegroup backups, verifying backup).

- Restore databases(online restores, full restores, differential restores, transaction log, file and filegroup restores, verifying restore, tail of the transaction log).

- Manage and configure databases (files, file groups, and related options; database options; recovery model; attach/detach data).

- Manage database snapshots (create, drop, revert).

- Maintain database integrity (DBCC CHECKDB, suspect pages, page level restores).

- Import and export data (BCP, BULK INSERT, OPENROWSET, GUI tools).

- Manage data partitions (switching data from one partition to another, add a filegroup, alter a partition function, alter a partition scheme, designing partition tables/indexes).

- Maintain indexes (create clustered and non-clustered indexes, disable and enable indexes, indexes with included columns, rebuilding/reorganizing indexes, statistics on filtered indexes).

- Monitor and troubleshoot SQL Server.

- Identify concurrency problems (blocks, locks, deadlocks, activity monitor, DMVs).

- Optimize SQL Server performance (Tuning Advisor, Profiler, DMVs, System Monitor).

- Implement high availability (database mirroring, log shipping, replication).

Sep 1999 – Sep 2002 System Administrator at TCPS Ltd.

- Maintain, troubleshoot and administer local area networks, workstations, connections to the Internet and peripheral equipment.

- Evaluate and install computer hardware, networking software, operating system software and software applications .

- Operate master consoles to monitor the performance of computer systems and networks and to co-ordinate access and use of computer networks .

- Implement network traffic and security monitoring software, and optimize server performance.

- Perform data backups and recovery operations.

- Perform shell scripting or other basic scripting tasks.

Contact this candidate