SUMMARY:

• Microsoft Database Administrator with over 6 years of experience and hands - on RDBMS designing, architecting, and management using MS SQL Server 2016, 2014, 2012, 2008 R2, 2005 in various environments including other database systems ( MySQL and Oracle )
• Performed monitoring, troubleshooting, performance tuning, proper index and statistics management for application systems, databases and queries.
• Installed and configured SQL Servers on standalone and cluster environment
• Installed, configured and managed high availability and disaster recovery solutions.
• Implemented security management technologies including database level security, AD, STIG, https, and IPSec
• Managed disk space and capacity planning, backup, restore, point-in-time recovery, RTO, and RPO
• Data modeler on logical and physical data modeling-forward/backward/reverse engineering.
• Used T-SQL for creating, altering and maintaining database and database objects
• Created SSRS reports such as parameterized, cascading, conditional, matrix, chart and subreports
• ETL/SSIS packages for integrating data from heterogeneous sources like Excel, CSV, Oracle, and flat file
• Window Operating Systems installation and management including AD & other technologies
• Cloud computing (Azure Service); migrating on-premises from legacy databases to Azure and managing database system in Azure Environment
• Upgrade/ migrate SQL Server, MySQL and Oracle databases and instances decommissioning servers
• Configured and Managed System Databases such as TempDB, MSDB, and Master DB
• Partitioned Tables and created Linked server

TECHNICAL SKILLS:

Database Features: SQL Server 2016, 2014, 2012, 2008r2, 2008, 2005, MS Access 2007& 2003

Database Migration: From SQL Server/Oracle/MySQL/MS Access to SQL Server

Operating System: Windows Server 2012R2, 2008R2, 2003 R2, VMware

BI/ETL/Data Warehouse: SSIS, DTS, SSRS

Reporting: SSRS, Report Builder, Cristal Report

Third Party Tools: JIRA, ERWin, OpNet, RedGate, SQL Sentry, Toad Data Modeler

Networking: Active Directory, DNS, TCP/IP, LAN, HTTP

Hardware/Storage: SAN, RAID, ISCSI

Native tools: SSMS, Performance Monitor, Query Analyzer, Extended Events, SQL Profiler, Execution Plan, Activity Monitor, DBCC, DMV, BIDS/DTS, Job Activity Monitor, Query Analyzer, Database Tuning Advisor, Built-in-Standard Reports

PROFESSIONAL EXPERIENCE:

Confidential, Alexandria, VA

Microsoft SQL DBA/ Architect

Responsibilities:

• Installed, configured SQL Server instances 2008 R2, 2012, 2014, 2016 in Dev, Test, UAT and Prod environments
• Worked on database refresh in Dev/Test servers with Production data and reinstate the server
• Supported daily operational activities for the database platform service requests and tickets, performance tuning, troubleshooting long running queries, locks, deadlocks and bottlenecks issues-CPU, I/O, and Memory
• Migrated/Upgraded SQL server instances from SQL Server 2005/2008 to 2014/2016
• Managed Security of SQL Servers and databases logins, users, granting/denying/revoking access and database encryption/decryption
• Led the effort in data masking of prod data to be used in test environment
• Applied SP/Hot Fixes on SQL server instances to address security issues and upgrade related issues
• Have used TFS to deploy script in different environments (prod/test/dev)
• Scheduled jobs to automate backup, monitoring database health, disk space management
• Worked with BI team to deploy SSIS package in different environment
• Involved in migration from Dev to Test/Prod data schemas, procedures, triggers and security reports
• Fine-tuned and improved database performance using SQL Server Profiler, Execution Plan, DMV, DBCC, indexes
• Optimized the database by creating various clustered, non-clustered indexes and indexed views
• Configured and maintained AlwaysOn AG using SQL Server 2014/2012 with Synchronous automatic-failover mode
• Monitored server activity, error log, space usage, database health, backup verification, cleaning history
• Developed and implemented database backup strategy and recovery plans for Prod, Test and Dev environments including mission critical databases
• Exported & Imported data from Flat file (CSV, Excel) to SQL Server database
• Provided 7 x 24 Production support for the database and application issues

Environment: Windows Server 2016, 2012R2, 2008R2, SQL Server, 2016, 2014, 2012, 2008R2, AD (Active Directory), and Application in JavaScript, ASP and ASP.net, TFS, SharePoint, SQL Sentry One, Oracle, ETL

Confidential

MS SQL Database Administrator

Responsibilities:

• Installed, configured, and maintained SQL Server 2012, 2008 R2, 2005 on Prod/Test/Dev environments
• Upgraded SQL Server 2005 and 2008 instances and databases to 2008 R2/2012
• Migrated Oracle 10gR2 and MySQL 5.1.23/5.5.6 databases to SQL Server
• Migrated DTS and SSIS packages from SQL Server 2008 R2 to 2012
• Configured and maintained AlwaysOn Availability Group using SQL Server 2012 with synchronous commit automatic-failover mode
• Applied Service Pack and Patching on SQL Server Instances on a routine basis
• Worked on database refresh in Dev/Test servers with Production data and reinstate the server
• Configured, managed, and monitored transactional replication and log shipping
• Implemented SQL server security, created and managed users, granted/revoked access
• Conducted performance tuning of servers, databases, T-SQL queries and stored procedures
• Used Native Tools, Execution Plan, Live Query Statistics, Query Store, Extended Events, Database Tuning Advisor, PerfMon, Resource Monitor and Activity Monitor for monitoring, tuning, and troubleshooting purpose
• Experienced in using DBCC commands to manage database consistency and repairs as needed
• Used DMVs and DMFs to monitor the health of a server instance, diagnose problems, and tuning
• Worked on T-SQL scripting, creating and modifying Tables, Index, Views, Stored Procedures, Triggers, Functions, declaring Cursors and variables, CTEs
• Performed regular backups, restores and automated different day to day tasks
• Installed, configured, and administered SQL Server Reporting Services (SSRS) and Report development, deployment, distribution and report subscriptions
• Developed, deployed, and managed reports like ad hoc, parameterized, cascade, drill down and subreport in SSRS using multiple sources
• Developed SSIS packages to perform various ETL operations from/to multiple sources and destinations using SSDT, SSIS, Import/Export Wizard for SQL Server
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, Execute SQL task and Send Mail task etc

Environment: SQL Server 2005, 2008R2, 2012, IIS 7.5, 8.5, Windows Server, 2003R2, 2008R2, ASP, ASP.net, Java, ETL and AD (Active Directory), Expand-IT, Financial Application, My SQL, Service-Now, JIRA, VM Server, Sponsorship management system, Timesheet, financial, inventory, payroll, and HR

Confidential

IT Coordinator

Responsibilities:

• Installed and managed PCs and Windows OS such as Windows 2000, XP, and 7
• Installed and managed office software packages including office suite, security, firewall, and other apps
• Managed numerous devices such as printers, routers, switches, internet connections/ISP, and cabling
• Configured, installed & maintained SQL Server 2005 and 2008
• Involved in designing conceptual, logical and physical data modeling.
• Installed, configured, developed and administered SQL Server Reporting Services (SSRS)
• Upgraded databases from SQL Server 7.0/2000 to 2005 in test & production environments
• Applied SP (Service Pack) and patches on SQL Server 2000, 2005, Windows Server 2003
• Set up databases security, tables, objects, procedure and managed security by defining roles and rights.
• Created and managed jobs, set up alerts, notifications, and SQL mail agent
• Migrated physical MS Exchange server 2007 server to virtual Exchange server hosted at a remote location in Germany, ensuring high availability and smooth functioning email service
• Optimized backup & recovery system through reduced recovery time (50%) & automation of all required user and system database jobs to appropriate media
• Set up master data by importing organization settings and project master data from WINPACCS accounting system
• Generated different reports as per client’s requirements using SSRS related to cost accounting and budget monitoring by establishing cost categories group and project internal structures

Environment: SQL Server 2000/ 2005/2008, Windows server 2003, applications (Timesheet, WINPACCS accounting/Cashbook/Cost Control/Project Finance Managers, Asset Management, payroll, and HR