SUMMARY:

A full - time position utilizing extensive experience with database creation and administration, user interface development, business and data analysis and proven ability to work independently with business users and as part of a team.

TECHNICAL SKILLS:

Windows 7/Server 2012/R2, MS SQL Server 2012(TSQL, SSRS, SSIS), Oracle 11g/PL/SQL, TOAD with ER modeling tools, VS .Net 2013: C# & VB, JavaScript & AJAX, QlikView 11, Seagate Crystal Reports 10, Infragistics Net Advantage Suite 2012 v2, MS Office Suite 2010, Visio 2007, CVS, TFS 2013, Remedy ticketing tracking system, Platinum Accounting, FORTRAN, vSphere 5.1., MySQL, JAVA, PRTG, Pager Duty, Confidential, PowerShell, Insight Software.

PROFESSIONAL EXPERIENCE:

Confidential

Consultant, Baltimore, MD

Responsibilities:

• Used VS .Net 2013 C# created program for comparing two databases. Structure of databases are the same but some data is not the same.
• For comparing these database we cannot use tools like Red Gate because in lookup tables PK values for the same records are different so we have to check lookup tables & dependencies as well.
• Using connections to two date sources I loaded data to in memory dataset & defined PK for each data table.
• After I created loop per each data table & each record & tried to find PK in another data\ table with the same structure (from another source). Result I loaded to the log file.
• As development tools used MS SQL Server 2008R2 & VS .Net 2010/C#.
• Experience scripting with Windows Batch and Powershell.
• Created View object from a few tables (relational database) & using software "Insight" designed few custom reports.

Confidential

Sr. Database Engineer, Washington, DC

Responsibilities:

• Using PowerShell created & implemented automated system for checking data integrity without downtime on remote servers with interactions with normal network & Windows Azure environments.
• Monitoring ~ 20 Production MS SQL Servers using Confidential, preparing & implementing solutions for fixing different database server issues: in Confidential software I created template & here I checked list of parameters which should be monitored for example High usage of machine resources as Memory, CPU, I/O, replications, dead locks ...etc. Each database server was related to its template, at the same time I created alerts & here I setup recipients for server & databases issues. Every day I reviewed different alerts & for each issue opened Ticket in JIRA, prepared technical solutions, tested, documented everything & attached to JIRA results. After approval I deployed solutions to PROD environment and experience scripting Windows Batch and Powershell.
• Using PowerShell created & implemented automated system for checking data integrity without downtime on remote servers with interactions with normal network & Windows Azure environments: For checking data integrity we use statement DBCC CHECKDB (). When we run this statement database is completely locked & at this time nobody can do anything else with this database. We needed to keep all our databases online in multi user mode 24/7 & in this situation I made a decision to run data integrity check on remote server, so I created PowerShell script for automatically server by server & database by database copy backup files from its network location to local drive, restore databases from backup, run DBCC CHECKDB, drop database & delete copied backup files. I tested this script & deployed to Windows Schedule on TEST machine, it runs automatically one server per day. For making sure each step runs in right order & starting only if previous step is completely done script automatically regenerates job per database with 6 steps job in SQL Agent & execute this job, write result to the log & sent email alerts if something is wrong. With this job we actually restore each prod database from backup so it means we run Disaster Recovery Test at the same time automatically at least ones per month.

Confidential

Database Administrator, Columbia, MD

Responsibilities:

• Performed all Standard Database Administration tasks in Cluster Environment including backup, recovery, maintenance, replications, log shipping, performance tuning, and security including Confidential .
• Worked for IT Architect Department designing databases using Database Diagrams.
• Created TSQL multi- stored procedures tasks for data distribution between Master Medical & RX claims Database & Data Marts.
• Experience scripting with Windows Batch and Powershell.
• Created CLR stored procedures & functions using VS .Net 2013/C#.
• Managed release of all changes of databases including in-house designed & vendor’s.
• Perform tasks as a TFS 2013 Administrator.

Confidential

DBA/Systems Architect, Bethesda, MD

Responsibilities:

• Leaded projects working directly with clients for analyzing business rules, designing whole data architecture including databases, Web Applications & different shared libraries, was responsible for deployment, released & managed final products & all changes.
• As development tools used MS SQL Server 2008R2 & VS .Net 2010/C#.
• Within VMware Environment performed all tasks a database administrator including maintenance, backup/recovery & security management, upgraded MS SQL Servers from version 2000 to 2005 and from 2005 to 2008 R2, setup SQL Server 2 nodes Cluster.

Confidential

Senior Consultant, Linthicum, MD

Responsibilities:

• Analyzed & improved performance for multi-stored procedure tasks with multi-million rows data manipulation.
• Improved TSQL tasks analyzing & changing existing database table designs.
• Created summarized data warehouse.
• Created universal C# program for analyzing & fixing a different .dat files with NULL values in the data rows; this program is a very useful before the data is being loaded by a different ETL tool.
• Created Old Syntax Finder Utility. Program prepares objects list (like stored procedures, triggers or views) with old SQL syntax & helps with database migration from old SQL Server versions or Sybase to SQL Server 2005.
• Experience scripting with Windows Batch and Powershell.
• Created Log Files Analyzer using C#.

Environment: MS SQL Server 2005, using SQL Profiler, Management Studio & TSQL, Visual Studio.Net 2003/2005 using C#, Visio.