PROFESSIONAL SUMMARY:

• Strong working experience as a Database Administrator in MS SQL Server ( 2016/2014/2012/2008 R2/2005) in Production, Development, and Test (Clustered, Stand Alone, and VM Servers) Environments
• Working experience with developers, application owners, system administrators and users to deploy software release across Development, Testing, and promoting into Production or resolve issues
• Solid professional work experience in SQL Server Installation, Configuration, Administration and maintenance with effective monitoring and troubleshooting capabilities
• Proven experience in the areas of Database Performance Tuning using SQL Server Profiler, Extended event, Database Tuning Advisor, Execution plan, Performance Monitor and Activity Monitor, DMV, DBCC, Windows Event Viewer, SQL Server Error Log, Agent Error Log
• Extensive work experience in Monitoring Server Activity, Error Log, space usage, database health, backup verification, cleaning history and solving problem as needed
• Experienced in Upgrading SQL Server (2005/2008 R2) to SQL Server 2012/2014/2016 and Migrating from Oracle, MySQL to SQL Server
• Strong knowledge and experience in capacity planning and implementing disaster recovery solutions - Database Backup, Restore, Point-in-Time Recovery in accordance with RTO and RPO guidelines
• Good experience in automating of administrative tasks such as Maintenance plans, Jobs, and Alerts using SQL Server Agent
• Experienced in implementing, configuring, monitoring, and administering High Availability solutions-AlwaysOn, Log shipping, Mirroring, Replication especially on Transactional Replication and SQL SERVER Fail-Over Clustering
• Proven experience in monitoring, troubleshooting, optimizing, and tuning Block, Deadlock, Index Fragmentation, Slow Running Queries, etc. using Native and Third Party Tools
• Experienced in creating, supporting and maintaining database administration scripts
• Extensive work experience in TempDB configuration
• Proficient in Database Optimization, Shrinking and Compression
• Experienced in implementing SQL Server Security, Managing Users, Granting/Revoking access, Encryption, TDE, Data Masking, Auditing, and Monitoring to comply with Microsoft and industry best practices
• Worked and maintained VLDBs, Partitioned table.
• Strong Skills in ETL operations using SSDT/BIDS, SSIS
• Great working knowledge in Configuring and Managing SSRS (SQL Server Reporting Services)
• Worked on migrating different types of SSRS reports from DEV to PROD servers
• Basic Knowledge on SSAS and managed users permission on SSAS servers as well as loaded data from different sources to Data Warehouse for analysis purpose.
• Experienced with Developing and Deploying Reports using SSRS and Report Builder 3.0/2.0
• Very good understanding of T-SQL batches and Developing Indexes, Stored Procedures, User Defined Functions, CTEs, Triggers, SQL Joins, Views, Cursors, Table Variables, Sub-Queries
• Expertise in Logical/Physical Database Design, Reverse/Forward Engineering using ERwin and Native Tools
• Extensive work experience in Linked servers, applying latest Service Packs, Patches, and HotFixes
• Exported data from SQL Server to multiple destination/format such as Flat file, CSV file, Oracle, MySQL, ODBC/OLEDB data sources
• Imported data from SQL Server from multiple destinations/format such as Flat file, CSV file, Oracle, MySQL, ODBC/OLEDB data sources
• Very good knowledge on SQL Server and Database Architectures and Design
• Excellent ability to work as part of a team and independently and able to manager time effectively to meet deadlines and prioritize workload.
• Providing 24X7 production On-Call support on a rotational basis
• Having excellent verbal, written and presentation skills, Independent problem solving, team player, proactive, multi-tasking, task prioritizing, detail oriented and excellent interpersonal skills

TECHNICAL SKILLS:

Databases: SQL Server 2016/2014/2012/2008 R2/2005

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

Languages: SQL/T-SQL

ETL Tools: SSDT/BIDS, SSIS

Reporting: SSRS (SQL Server Reporting Services), Report Builder (3.0, 2.0)

Data Modeling Tools: ERWin, Toad Data Modeler

Upgrade/Migrate: SQL Server to SQL Server, Oracle to SQL Server, MySQL to SQL Server, and MS Access/Excel to SQL Server

ThirdParty Tools: Foglight, SentryOne, Idera, RedGate, UltraBac, ERWin

Ticketing Tools: ServiceNow, JIRA

Native tools: SSMS, Performance Monitor, Query Analyzer, Extended Events, SQL Server Profiler, Database Tuning Advisor, SSMA, Execution Plan, Activity Monitor, Job Activity Monitor, Built-in Standard Reports, BIDS/SSDT, DMVs & DMFs, SQL Server Configuration Manager

Hardware/Storage: SAN, RAID, iSCSI

Domain/AD: DNS, Active Directory

Networking: TCP/IP, DNS, WAN, LAN, SFTP

PROFESSIONAL EXPERIENCE:

Confidential, Warren, NJ

SQL Server DBA

Responsibilities:

• Installed, Configured, and Maintained SQL Server 2016, 2014, 2012, 2008R2 on Prod/Test/Dev environments
• Monitored Server Activity, Error Log, space usage, database health, backup verification, cleaning history and solving problem as needed
• Supports day to day operational activities for the database platform like service requests and tickets, monitoring, performance tuning, troubleshooting long running queries, locks, deadlocks and performance issue like CPU, I/O, Memory bottlenecks
• Upgraded/Migrated SQL Server 2005 and 2008R2 to SQL Server 2012/2014/2016
• Migrated SSIS packages from SQL Server 2008R2 to 2014
• Applied SP (Service Pack) on SQL Server 2014, 2012, 2008 R2 on a routine basis
• Configured and Maintained AlwaysOn Availability Group using SQL Server 2014/2016 and created documentation and Run book for AlwaysOn
• Configured, managed, and monitored Transactional Replication and Log Shipping
• Worked on Database Refresh in DEV/UAT servers with PROD data and reinstate the server
• Implemented SQL Server Security, Creating and Managing users, granting/revoking access on database level or server level
• Implemented Transparent Data Encryption(TDE) on Production Server and Managed Keys and Certificates
• Performed performance tuning for servers, databases, SQL/TSQL queries and Stored Procedures
• Worked and maintained VLDBs, Partitioned table.
• Have used TFS to deploy script in different environments (prod/test/dev.)
• Used Query Analyzer, Execution Plan, Extended Events, SQL Server Profiler, Database Tuning Advisor, PerfMon, 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 tune performance
• Provided support for SQL Server Reporting Services (SSRS) including installation, configuration, report deployment, setting up report subscriptions and managing security to using SSRS and migrated SSRS reports from DEV to PROD servers
• Developed, deployed, and managed Reports in SSRS using multiple sources by SSDT and Report Builder
• Proficiently worked on T-SQL scripting, creating and modifying Tables, Index, Views, Stored Procedures, Triggers, Functions
• Assisted and reviewed Developer SQL queries (T-SQL) and Stored Procedures for optimization and security purposes
• Involved in Database developing and Data Modeling project defining Data architecture and developed Normalization Form data redundancy and improve data integrity.
• Performed regular backups, restores and automated different day to day tasks
• Developed and manage SSIS packages to perform various ETL operations
• Worked extensively on SSIS Packages for extracting data of file system and transformed that data and loaded it into OLAP system
• Exported data from SQL Server to multiple destination/format such as Flat file, CSV file, Oracle, MySQL, ODBC/OLEDB data sources
• Imported data from SQL Server from multiple destinations/format such as Flat file, CSV file, Oracle, MySQL, ODBC/OLEDB data sources
• Knowledge of Microsoft Azure cloud-based database technologies
• Provided 7 x 24 Production support for the database and application issues

Work Environment: MS SQL Server 2016/2014/2012/2008 R2, Windows Server 2012/2008 R2, Application in JavaScript, ASP and ASP.net, SSRS, SSIS, TFS, Visual Studio 2010, IIS 7.5, Foglight, SentryOne, IDERA, UltraBac, JIRA, ServiceNow, Oracle

Confidential, Arlington, VA

SQL Server DBA

Responsibilities:

• Worked as a Production DBA and responsible for performance of the SQL server Instances and safety of the data in databases.
• Maintained SQL Server 2008 R2 and 2012 on PROD/UAT/DEV environments
• Monitored data activities such as database status, logs, space utilization, extents, Checkpoints, locks and long transactions and solved problems as needed
• Created and managed schema, entities, relationship, constraints, normalization, developed E-R Diagram using ERWin and SQL Server Data Diagram
• Deployed database design through Backward & Forward Engineering using ERWin
• Provided customized support for Client’s Applications and was responsible for creating and maintaining database objects and structures such as tables, indexes, views, triggers, Functions, Procedures
• Implemented SQL Server Security, Managing Users, Granting/Revoking access, Encryption, TDE, Data Masking, Auditing, and Monitoring to comply with Microsoft and industry best practices
• Created logins and Roles with appropriate permissions for temporary and permanent access requests.
• Creating and Managing users, granting/revoking access on database level or server level
• Implemented & managed MS SQL Cluster (Active/Passive) and load balance technologies as per clients’ requirements
• Configured, managed, and troubleshoot Transactional Replication, Merge Replication
• Configured and Maintained Log Shipping as Standby database for Reporting Purposes
• Planned and implemented backup strategy according to RTO and RPO and performed point-in-time recovery
• Exported data from SQL Server to multiple destination/format such as Flat file, CSV file, Oracle, MySQL, ODBC/OLEDB data sources
• Imported data from SQL Server from multiple destinations/format such as Flat file, CSV file, Oracle, MySQL, ODBC/OLEDB data sources
• Working experience in Change Control Procedures and developed & executed scripts in accordance with change control procedures
• Installed and Configured SQL Server Reporting Services (SSRS)
• Developed and managed Reports in SSRS and deployed reports
• Involved in report migration from Dev to Test/Prod and adding Data source, managing security of reports
• Developed SSIS packages and deployed into multiple destinations
• Provided 7 x 24 Production support for the database and application issues

Work Environment: MS SQL Server 2012/2008R2/2008, RedGate SQL Compare, Visual Studio 2010/2005 and Windows Server 2008 R2/2008/2003, IIS 7.5, 7.0, TFS, ERWin, Visual Studio 2010/2005, ServiceNow

Confidential, Washington DC

SQL DBA/Analyst I

Responsibilities:

• Installed, Configured and Maintained SQL Server 2005 and 2008 R2 in development, test, and production environment
• Worked in database Performance tuning using native tools (SQL Server Profiler, Database Tuning Advisor, Execution Plan, PerfMon, DBCC, DMVs)
• Regularly inspected SQL Server Error Logs, Space Usage, Disk Utilization, Backup Status, Jobs, Customer Complaints, Windows Event Viewer for information, errors and warnings and daily routine tasks
• Experienced in automating of administrative tasks such as Maintenance plans, Jobs, and Alerts using SQL Server Agent
• 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
• Ensured all database servers are backed up in a way that meets the business RPO and RTO.
• Working experience in Database Backup, Restore and Point-in-Time Recovery
• Configured and Maintained Mirroring, Log Shipping as HA solutions
• Applied SP (Service Pack) and patches on SQL Server 2005, 2008R2
• Created logins and Roles with appropriate permissions for temporary and permanent access requests.
• Wrote T-SQL codes, Stored-Procedures and created & modified tables, Index (Cluster/Non-Cluster), Constraints, Views, Triggers
• Worked on different Data Modeling projects using Toad Data Modeler on designing Logical & Physical Database
• Exported data from SQL Server to multiple destination/format such as Flat file, CSV file, Oracle, MySQL, ODBC/OLEDB data sources
• Imported data from SQL Server from multiple destinations/format such as Flat file, CSV file, Oracle, MySQL, ODBC/OLEDB data sources
• Installed and Configured SSRS and Generated parameterized reports, sub reports, tabular reports using SSRS/Report Builder
• Migrated different types of SSRS reports from DEV to PROD servers.
• Provided 7 x 24 Production support for the database and application issues

Work Environment: SQL Server2008R2/2008/2005, Windows Server 2008/2003, IIS 6.5, 7.0, Idera Diagnostic, RedGate products, Visual Studio 2008/2005, Toad Data Modeler, JIRA