SUMMARY:

An experienced MS SQL Server Database Admin/Developer having more than 6 (Six) years of professional experience in Database Design, administration, ETL Processing, Report Development, Data Modeling, SQL/TSQL Scripting, Gathering and analyzing business requirement and Administering Windows Server Operating Systems. Solid working experience in managing and troubleshooting 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 third party tools like Idera, SpotLite, ERWin, Visio, and Toad Data Modeler. 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.

TECHNICAL SKILLS:

Database Expertise: SQL Server 2014, 2012, 2008 R2, 2005, 2000, 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, 2000, UNIX/Linux, VMware, Cloud

Cloud: Migrated and Managed Databases in Azure Database & Azure VM from on Premises databases systems Migrated and Managed Databases in Google VM, AWS.

Languages: SQL,T - SQL,HTML, DHTML, XML, JavaScript, ASP, ASP.net

ETL/Data Warehouse Tools: SSIS/DTS, BCP

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

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

Third Party Tools: SolarWinds, OpNet, RedGate, Idera, SpotLite, ERWin, Visio, Toad Data Modeler

Networking: Active Directory, DNS, TCP/IP

Hardware/Storage: SAN, RAID, iSCSI

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

SQL Database Administrator/SQL DBA

Responsibilities:

• Installed, Configured, and Maintained SQL Server 2016, 2014 on Prod/Test/Dev environments
• Upgraded SQL Server 2005 and 2008 instances and databases to 2014/2016
• Migrated Oracle 10gR2 and 11g and MySQL 5.1.23/5.5.6 databases to SQL Server 2012/2014
• Migrated SSIS packages from SQL Server 2008 R2 to 2014/2016
• Modified the application as well as database objects such as stored procedures, views, tables etc
• Deploy Changes/SPs/Queries in Production Environment
• Maximize the stability, uptime, and performance of databases in the production environment through system monitoring, performance tuning, and routine maintenance tasks such as index rebuilds, file compressions, statistical updates, and database consistency checks
• Configured and Maintained AlwaysOn Availability Group using SQL Server 2014/2012 with Synchronous Commit automatic-failover mode
• Applied SP (Service Pack) on SQL Server 2012,2014 on a routine basis
• Worked on Database refresh in Dev/Test servers with PROD data and reinstate the server
• Configured, managed, and monitored Transactional Replication and Log Shipping
• Implemented SQL Server security, Creating and Managing users, granting/revoking access
• Performed performance tuning for servers, databases, SQL/T-SQL queries and Stored Procedure.
• Used Native Tools, Query Analyzer, Execution Plan, Live Query Statistics, Query Store, Extended Events, SQL Server Profiler, 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 repair as needed
• Used DMVs and DMFs to monitor the health of a server instance, diagnose problems, and performance tune
• Proficiently worked on T-SQL scripting, creating and modifying Tables, Index, Views, Stored Procedures, Triggers, Functions, declaring Cursors and variables, CTEs
• Monitored Server Activity, Error Log, space usage, database health, backup verification, cleaning history and solving problem as needed
• Performed regular backups, restores and automated different day to day tasks
• Installed, Configured, and administered SQL Server Reporting Services (SSRS) and Reports development, deployment, distribution and reports subscriptions
• Developed, deployed, and managed Reports like ad hoc, parameterized, cascade, drill down and sub report in SSRS using multiple sources
• Developed SSIS packages to perform various ETL operations from/to various sources and destinations using SSDT, SSIS, Import/Export Wizard for SQL Server 2014/2012
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, Execute SQL task and Send Mail task etc.

Environment: Windows Server 2012, 2008 R2, IIS 7.5, 6.5, SQL Server 2014, 2012, 2008 R2, Sentry One, Idera, TFS, ASP, ASP.net, Visual Studio 2010

Confidential, Suitland, MD

SQL Database Administrator/SQL DBA

Responsibilities:

• Migrated and Upgraded from SQL Server 2005 and 2008 R2 to 2012
• 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.
• Performed acceptance testing to verify that database changes perform without adverse consequences.
• Customized support for Client’s Applications and provided client will won 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.

Environment: SQL Server 2012/2008 R2, ETL, SSIS, DTS, ASP.net Applications, IIs Application Server Windows Server 2012, 2008R2, AD (Active Directory). SCCM (System Center Configuration Manager, SCOM (System Center Operation Manager), Service Now, SolarWind, Net apps SM for SQL Server.

Confidential, New York, NY

SQL Database Administrator/SQL DBA

Responsibilities:

• Configured, Installed, and Maintained SQL Server 2000 & 2005 in development, test, and production environment
• Installed and Configured Operating Systems, Windows Server (2000 & 2003)
• Installed and Configured SQL Server Reporting Services (SSRS)
• Configured and Maintained Replications, Log Shipping
• Upgraded databases from SQL Server 7.0/2000 to 2005 in testing and production environment
• Upgraded MS Access 2000/97 databases into MS SQL Server 2000, and 2005
• Applied SP (Service Pack) and patches on SQL Server 2000, 2005, Windows Server 2003 Enterprise Edition
• Expertise in database Performance tuning
• Writing T-SQL and Stored-Procedures
• Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers
• Data Modeling, developing E-R Diagram using ERWin and SQL Server Data Diagram
• Backward & Forward Engineering with data modeling tools mentioned above
• Export & Import data from Flat file, CSV file, Oracle, and Access to/from SQL Server Database using DTS, SSIS, and BCP
• Generated Report using SSRS and in Excel, html, text from Database as well
• Working experience in Database Backup, Restore and Point-in-Time Recovery
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
• Developed Different Maintenance Plans for database monitoring
• Monitor Server Activity, Error Log, space usage, and solving problem as needed

Environment: SQL Server 2008 R2, 2005, ETL, SSIS, DTS, ASP.net Applications, IIs Application Server Windows Server 2012, 2008R2, AD (Active Directory). SCCM (System Center Configuration Manager, SCOM (System Center Operation Manager), Service Now, SolarWind, Net apps SM for SQL Server.