SUMMARY:

• Experienced in installing, upgrading, patching, administrating and maintaining Microsoft SQL Server 2016/2014/2012/2008 R2 in Production, Test and Development environments
• Proactively monitoring and troubleshooting database issues and make tuning adjustments to ensure database integrity, security and system performance
• Proficient in performance tuning of T - SQL queries, stored procedures and debugging the poorly written code and helping application teams in development life cycle
• Working experience with developers, application owners, system administrators and users to deploy software release across Development, Testing, and promoting into Production or resolve issues
• Highly proficient in database Backup, Restore, Point-in-Time Recovery, Linked servers, and Database Maintenance Plans
• Expertise in RDBMS concepts and constructs. Working with data modelers on logical and physical data modeling and DBAs/Developers in implementing and updating physical data models in databases
• Experience with SQL/T-SQL for creating, altering, and maintaining databases and database objects
• Experience of Upgrading and Migration from earlier version of SQL Server to SQL Server 2012/2014 in different environments
• Solid experience and outstanding knowledge of SQL Server High Availability and Disaster Recovery solutions (Log shipping, Mirroring, Replication, SQL Server clustering and AlwaysOn)
• Experience in creating, supporting and maintaining database administration scripts
• Experience with schema management, database reorganization, Partition, database maintenance and optimization
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS)
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Cascading, Conditional, Table, Chart and Sub Reports
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert
• Excellent in High Level Design of SSIS Packages for integrating data using OLEDB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all working Experience and good understanding of SSAS, OLAP cube and Architecture
• Extensive work experience in applying latest Service Packs, patch and hot fixes
• Manage Security Management: Securing SQL Servers and Databases, Manage users, Data encryption, granting/ revoking access, data masking
• Excellent ability to work as part of a team and independently and Able to manage time too effectively to meet deadlines and prioritize workload
• Extensively worked in 24*7 Production environment

TECHNICAL SKILLS:

Database Administration: SQL Server 2016/2014/2012/2008 /2005/2000, MS Access, Oracle 10g, Sybase ASE

Database Tools: Profiler, BIDS,DTS, Management Studio/Enterprise Manager, Query Analyzer, SSIS, Execution Plan, Extended Event

Operating Systems: Windows Server 2012,2008R2, 2003, Windows 7 Professional, Windows XP Professional, NT 4.0, HP-Unix, AIX, Linux (RHEL)

Version Control: TFS

ETL Tools: DTS/SSIS,BIDS,SSDT,BCP

Languages: T-SQL, PL/SQL, XML, JavaScript, ASP, ASP.net and C++,Power Shell

Reporting Tools: Report builder, Crystal Reports, OLAP Tools, BIDS,SSDT

Third Party Tools: Toad Data Modeler, Idera, Redgate, Spotlight, SCOM, Proactive DBA, CARA, Control M

Ticketing Tools: Service now, Remedy, JIRA, Call Agent

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

SQL Server Database Administrator

Responsibilities:

• Installed, Configured, and Maintained SQL Server 2016, 2014 on Prod/Test/Dev environments Provided application databases support and resolve problems related to the RDBMS platform environments like SQL Server, Sybase, and Oracle
• Setup, Configured and maintained AlwaysOn in SQL Server 2012,2014 and 2016
• Performed databases refresh on request: Refresh data from one environment to another at the request of the development team
• Managed SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems
• Provide solution and correct issues in real time resolution end-to-end users
• Performed scheduled maintenance and support release deployment activities after hours
• Used Quest Spotlight and SCOM monitoring tools to assist various aspects of system performance on numerous SQL Server instances
• When performance issues arise, determine the most effective way to increase performance including hardware, server, and databases
• Performed performance tuning for servers, databases, SQL/T-SQL queries and Stored Procs
• Used Query Analyzer, Execution Plan, Extended Events, SQL Server Profiler, Database Tuning Advisor, PerfMon, and Activity Monitor for monitoring, 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
• Reviewed TSQL scripts and staged the script for CARA code migration also advice developers in code optimization.
• Diagnosed Control M job errors and implemented solutions and worked with developers to solve break/fix and other issues
• Performed day to day DBA activities such as monitoring SQL Server health, job status, addressing user requirements
• Capacity planning and reporting: Monitor file system space, database allocation etc. verify efficient use of disk storage, reclaim unused space, optimize space allocation and avoid out-of-space conditions
• Ensured all database servers are backed up that meets the business’s Recovery Point Objectives (RPO)
• Troubleshoot SQL Server service outages as they occur, including after-hours and weekends
• Configured SQL Server monitoring utilities to minimize false alarms
• Providing 24X7 production On-Call support on a rotational basis

Work Environment: Windows Server 2012, 2008-R2, 2003-R2, IIS 7.5, SQL Server 2016,2014, 2012, 2008-R2, 2008, AD (Active Directory), and applications in ASP and ASP.net, Unix, Sybase ASE

Confidential, Washington, DC

SQL Server Database Administrator

Responsibilities:

• Installed, Configured, and Maintained SQL Server 2008 R2, 2012, 2014, 2016 in development, test, and production environment
• Upgraded/Migrated SQL Server Instances/Databases from older version of SQL Server to new version like 2005 /2008 R2 to 2012/2014
• Migrated MS Access Databases into MS SQL Server 2008 R2, and 2012
• Migrated Oracle 10gR2/11gR2,MySQL and Sybase databases to SQL Server 2008 R2/2012
• Applied SP (Service Pack)/ hot fixes on SQL Server Instances to address security and upgraded related issues
• Setup, Configured and maintained AlwaysOn SQL Server 2012.
• Delivered reports to users in variety of formats like Report Server (Web based), excel, pdf, html, excel and CSV formats
• Scheduled and managed daily/weekly/monthly sales and operational reports based on the business requirements
• Experience in SQL Server SSIS package design, constructing, and deployment
• Developed the dimension, fact tables and designed the data warehouse using star schema
• Good understanding on data modeling projects and generated E-R Diagram
• Performed database and SQL/TSQL Performance Tuning using Profiler, Execution plan, DMV, DBCC, Activity monitor, Performance monitor
• Experienced in SQL/T-SQL queries, Stored-Procedures, functions, and Triggers
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification, cleaning history, deleting old files, index and fragmentation managements
• Experienced in working with TFS server

Work Environment: Windows Server 2012, 2008-R2, 2003-R2, IIS 7.5, SQL Server 2016,2014, 2012, 2008-R2, 2008, 2005, AD (Active Directory), and applications in ASP and ASP.net.

Confidential, Rockville, MD

SQL Server Database Administrator

Responsibilities:

• Installed, Configured, and Managed SQL Server 2005, 2008R2 and 2012 in development, test, and production environments
• Applied SP (Service Pack) on SQL Server 2005, 2008 R2 and 2012
• Securing SQL Servers and Databases, Manage users, granting/ revoking access
• Data Encryption and Data Decryption for data security in Database & Column level
• Managed Backup/Restore, Point-in-Time Recovery including backup verification, security
• Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2008 R2
• Setup, configured, monitored, troubleshoot and maintained Log Shipping, Mirroring
• Monitored SQL Server activities/issues (such as CPU utilization, Memory utilization and IO utilization, disk space issues, blocking, deadlock, fragmentation, Identifying indexing issues, managing indexes, growth patterns, etc. ) and optimized performance using Execution plan, PerfMon, Profiler, Database Tuning Advisor, DMV
• Prepared and implemented backup strategy, maintenance and disaster recovery plan
• Setup and configured Database Mail and configured notifications and alerts
• Export & Import data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP
• Regularly inspected SQL Server Logs, SQL Server Agent Error Logs, and Windows Event Viewer for Information, errors and warnings
• Involved in resolving dead lock issues and performance issues and Health Check process for database
• Monitoring of database size and disk space in Production, Staging & Development environments

Work Environment: Windows Server 2008 R2/2003 R2, SQL Server 2005/2008 R2/2012, Access, PHP Applications, ASP, ASP.NET, IIS, and Apache Tomcat

Confidential, Washington, DC

SQL Server Database Administration

Responsibilities:

• Installed, Configured, and Managed SQL Server 2000,2005, 2008 and 2008R2 in development, test, and production environment
• Setup, Configured, monitors and Maintained Database Mirroring
• Configured and Maintained Log Shipping as Standby database for Reporting Purposes
• Expertise in database Performance tuning SQL profiler, Execution Plan, Database tuning Advisor, Activity Monitor, Performance Monitor
• Monitored data activities such as logs, space utilization, locks, long transaction
• Optimized the database by creating various clustered, non-clustered indexes and indexed views
• Processed data dump and Exported & Imported data from Flat file, CSV file, Oracle, My-SQL, and Access to/from SQL Server Database using DTS, SSIS, and EXP/IMP tool
• Installed and Configured SQL Server Reporting Services (SSRS)
• Developed Different Maintenance Plans such as backups, index management, fragmentation management, cleaning history, deleting old files
• Working experience in point-in-time recovery
• Monitored Servers activity, Error log, Space usage and worked with clients to solve different problems

Work Environment: SQL Server 2000, 2005, 2008, IIS Server 6.5, Windows Server 2003, 2003R2, ASP.net, Java, ETL and AD (Active Directory)

References: References available upon request