MS SQL administrator Resume

SUMMARY:

Experienced MS SQL server DBA - design, administration and support (2016/2012/2008 R 2/2008/2005/2000 ) in production and test environments
Planning, installing, configuring and monitoring all MS SQL services(SSIS, SSRS, SSAS)
SQL server and database migrations to higher versions.
Disaster recovery planning, execution and testing.
Physical database design, Development, Performance Tuning and Query optimization.
Working knowledge on SQL security, SQL queries, backup and recovery
Experience on High availability, replication(transactional and merge), database mirroring and SQL failover clusters
Implementing ETL processes
Developing T-SQL, cmd and powershell scripts for automation
Creation of pro-active monitoring system with 3d party apps
Well versed in administering Windows server 2003/2008/2012 , VMWARE vSphere 5.5

PROFESSIONAL EXPERIENCE:

MS SQL administrator

Confidential

Administering MS SQL servers -full cycle (2000, 2008, 2012,2016) Administering MS SQL services (SSIS, SSAS, SSRS) - deployment, configuring, monitoring Configuring failover clusters and AlwaysOn groups as well as using standalone systems MS SQL services structure planning and deployment, supporting ETL packages and data flow processes Implementing backup and maintenance procedures, tuning user access, patches and other administrative routines Creation of pro-active servers and databases monitoring system as well as gathering performance statistic information Optimization and performance issues, determining bottlenecks Developing sql, cmd and powershell scripts for automation tasks and data transfers Administering VMWARE vSphere 5.5 - full set of tasks. (preparing hosts, ESXi deployment, configuring standalone hosts and HA/DRS clusters, virtualization of existing application servers and creating newbackups(Veeam) and monitoring Administration of windows systems (2003,2008, 2012) - hardware (SuperMicro, Adaptec RAID, IBM
Storewize) as well as virtual (VMWARE, IBM cloud - CMS and VDI)

MS SQL DBA

Confidential - Boston, MA

Remote administration of MS SQL servers (2000/2005/2008/2008 R2/2012) and sql services (SSIS, SSRSSSAS) Planning and implementing full cycle of backup and maintenance procedures Administrative routines (backup-restore, user rights assignments, patches etc.) Supporting cluster and standalone instances, replication and mirroring Optimization and performance issues Databases and servers state pro-active monitoring Writing T-SQL scripts for automation tasks DTS packages development and support

MS SQL DBA

Confidential

MS SQL servers administration (2000, 2005, 2008, 2008R2)
(backups, maintenance procedures, server state monitoring, user access, index tuning and performance issues etc.)
Data export-import operations Process automation (cmd, vbs and T-SQL scripts and stored procedures) Consulting developers Database and server parameters monitoring

Software Developer

Confidential

Developing corporate RDBMS (MS SQL 2000) - planning structure and implementing server side business logic (T-SQL) Developing front-end application for information system in C++Builder (client interfaces, reports etc.) Implementation of ETL processes and automating "on demand" data export\import operations via XML,DBF and Excel. Implementation of data cubes for analytics MS SQL server 2000 administration - backups, maintenance procedures, replication, security

Software Developer

Confidential

Developing corporative information systems (C++Builder, FoxPro, InterBase, MS SQL Server 2000)
Planning and development from scratch corporate RDBMS (MS SQL 2000) Migration of existing information from several data sources of different formats Developing front-end side of the system ( ++Builder) Administering SQL server, automating backups and maintenance procedures Writing technical documentation, creation of help library Support and development of existing RDBMS (MS DOS FoxPro, Delphi, InterBase)

TECHNICAL SKILLS

MS SQL server, Windows Server, SSAS, SSRS, SSIS, VMWARE, PowerShell, T-SQL, C++Builder, ETL, SAN, RAID