SUMMARY:

• An experienced SQL Server DBA with detail oriented, analytical and troubleshooting having more than 6 years of professional experience in different Microsoft products as a SQL Server DBA.
• As a DBA professional and troubleshooting experience include SQL Server database administration, data modeling, gathering and analyzing business requirement and Operating Systems.
• Solid working experience in managing large databases, backup/recovery, developing and managing reports using SQL Reporting Services (SSRS), Monitoring, Performance Tuning, stored procedures, triggers, functions, constraints and views etc.
• Working experience entails strong knowledge on using database third party tools like SolarWinds, Idera, ERWin.
• Cloud/Azure experience includes Azure Services, PaaS, IaaS, and Migrated from premises databases and Legacy databases to Azure, deployed products on Azure, Setup development and test environment on Azure.
• Strong business and technical vision with effective people skills, ability to manage multiple complex projects, innovative and creative problem solver, results oriented, and has an aptitude for learning and can maximize resources while possessing a sense of urgency.

SKILLS:

Database Expertise: SQL Server 2016, 2014, 2012, 2008 R2, 2005, MS Access

Database Migration: SQL Server to SQL Server, Oracle to SQL Server, MySQL to SQL Server, and MS Access/Excel to SQL Server

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

Languages: SQL, T - SQL, PowerShell, ASP, ASP.net

Cloud/Azure: Azure Services, PaaS, IaaS, Migrated on premises databases and Legacy products on Azure, deployed products on Azure, Setup development and test environment on Azure

ETL/Data Warehouse Tools: SSIS/DTS, BCP

Reporting: SSRS (SQL Server Reporting Services) - Enterprise Reporting

Data Modeling Tools: ERWin, SSDD (SQL Server Database Diagram)

Third Party Tools: SolarWinds, Idera, ERWin

Domain/AD: Active Directory, DNS

Hardware/Storage: SAN, RAID, iSCSI

Ticketing Tools: BMC Footprint, Tracker

PROFESSIONAL EXPERIENCE:

Confidential, Manhattan, New York

SQL Database Administrator/SQL DBA

Responsibilities:

• Installed, Configured, and Maintained SQL Server 2017,2016, 2014, 2012, and 2008 R2 in development, test, and production environment
• Configured and Maintained Replications, Log Shipping, and Mirroring Fail-Over Clustering, Always On using SQL Server.
• Actively monitor server activities, error logs, drive space, critical alerts for optimal performance Tuning and proactive maintenance of database.
• Upgraded/Migrated SQL Server Instances/Databases from older version SQL Server to new version of SQL Server like 2005,2008 R2 and 2008 R2 to 2012. 2014 & 2016
• Applied SP (Service Pack)/ Hot Fixes on SQL Server Instances to address security and upgraded related issues
• Wrote SQL/T-SQL queries, Stored-Procedures, functions, and Triggers
• Scheduled many jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
• Developed Different Maintenance Plans for database monitoring
• Setup Jobs, Maintenance plans for backups, Rebuilding indexes, check server health, alert, notifications
• Worked on Data Modeling projects, Backward Engineering, Developed E-R Diagram and used multiple tools like ERWin and SQL Server Data Diagram
• Installed and Configured SQL Server Reporting Services (SSRS)
• Developed and deployed different types of Reports using different data sources like SQL Server, Oracle, Excel, CSV files
• Deployed SSIS packages to Transfer data across server Transfer logins, load data from different data sources
• Used Imp/Exp. Tool to Export & Import data from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports ODBC, OLE DB Data Sources
• Manual, on Demand and setup jobs for Database Backup, and design backup strategy
• Migrated Oracle 10gR2/11gR2 and MySQL 5.1.23 databases to SQL Server 2008 R 2/2012/2014/2016
• Deployed and Restored database including Point in Time Recovery
• Monitor Server Activity, Error Log, space usage and solving problem as needed

Confidential, Washington, DC

SQL Database Administrator/SQL DBA

Responsibilities:

• Migrated and Upgraded from SQL Server 2005 to 2008/2008 R2
• Configured database software, associated database tools and performance monitoring software.
• Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
• Customized support for Client’s Applications and provided client will own the responsibility of creating and maintaining database objects and structures such as tables, indexes, views, triggers, Functions, Procedures.
• Developed & maintained scripts, utility jobs or implement needed software for database maintenance.
• Implemented & managed database clustering, failover and load balance technologies as per client requirement.
• Developed, tested & implemented a robust database backup and recovery strategy with client assistance.
• Monitored data activities such as database status, logs, space utilization, extents, Checkpoints, locks and long transactions.
• Suggested Application level tuning changes for code, queries, SQL objects that may not be performing up to the optimum database performance standards.
• Adhered to Change Control Procedures and developed & executed scripted changes requests in accordance with change control procedures.
• Set up security and access profiles and procedures for database system administrators.
• Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 8 Node.
• Handled Logical Data and Index partitioning for large tables in SQL Server 2005, 2008 & 2008 R2.
• Created, administered & maintained SQL Server Databases to Production, Development, Test and Staging Environment for various groups such as Developer, QA, BA, and User.
• Managed security by defining roles and rights.
• Handled Fine Tuning Operating System in-coordination with Server and Network Administrator to utilize the maximum resources for Database and Applications.
• Monitored the database server performance and if required go for tuning of the TSQL queries, Stored procedures.
• Working individually, as a member of a team, and lead small teams to collaboratively design and model systems at a high level prior to construction