SUMMARY

• Having 8+ Years of Database Administration (DBA) experience on MS SQL SERVER / 2014/2012/2008 R2/2008/ in OLTP and OLAP environments
• Experience in installing MS SQL SERVER 2016, 2014, 2012, 2008 R2, 2008 and updating with hot fix and service packs
• Strong understanding of RDBMS concepts as well as Data Modeling Concepts
• Extensive experience in implementing HADR solutions like AOAG, Replication (Snapshot and Transactional), Log shipping, clustering and mirroring on physical and virtual machines
• Experience as an Application and Prod DBA, involved in builds, applying service packages and providing technical support to the development team.
• Lastly, experience is providing 24X7 support and experience in SQL Server 2008 concepts SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services).
• Implemented In - place and Side by Side Migration of MS SQL SERVER R2 and 2008 R2 to 2012
• Knowledge in writing T-SQL (DDL, DML, and DCL) statements
• Experience using SQL SERVER 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE)
• Worked on Data Integrity, Performance Tuning, Query Optimization
• Providing on call support 24/7 on rotational basis for production database on mission critical systems
• Implementing CR (Change Request) and CA (Change Amendments) requested by users
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources
• Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects
• Extensively used native tools like index tuning wizard, database tuning advisor, profiler, performance monitor, activity monitor, event viewer for performance analysis
• Experience in Client/Server Connectivity, Database health Check, Indexing and Updating Statistics
• Managed over 50 Servers with hosting the high-volume databases sizes up to 500 GB
• Configured SMTP SERVER for Database Mail setup and received Alerts for the Threshold values
• Worked on third party tools like BCP Remedy Tool, Lite Speed, Fog light and Red gate
• Experience in creating SQL SERVER Reports using SSRS 2008 and worked on Hyper-V and VMware environments
• Experience in supporting dozens of Amazon AWS implementations including Amazon EC2 (IaaS) and all Amazon RDS (DBaaS) Amazon AWS services include provisioning, implementation.
• Implemented change management
• 24*7 Production support experience.
• Performing Root Causal Analysis (RCA) of incidents and adhering to SLA standards
• Knowledge of Azure infrastructure: storage, network, Virtual machines.
• Experience in Azure SQL database
• Experience in using DBAtools PowerShell module to automate tasks.
• Proficient in installing Master Data Services.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative, and the ability to think outside the box.
• Expertise in installing MS SQL Server 2016/ 2014/2012/2008 and associated database tools, updating with latest Service Packs (SPs), hot fixes and Security patches.
• Implemented different types of High Availability & Disaster Recovery models like SQL Always On, Clustering, Database Mirroring, Transactional Replication and Log Shipping.
• Implemented & managed Active-Active and Active-Passive Clustering, Failover and Load Balance technologies.
• Expertise in Side-by-Side Migrations of MS SQL SERVER 2008/2012/2014/2016/2019.
• Experience in planning and implementing Database Security by creating Logins, Users, Roles and assigning permissions to them.
• Proficient in SQL Server features like Query Store, Resource Governor, Performance Data Collector (MDW), Transparent Data Encryption (TDE), Database Snapshot, Data partitioning, backup compression and encryption, Column Store and Filtered Indexes, online indexing, incremental statistics update.
• Expertise in resolving blocking and deadlocks, handling Isolation level and concurrency effects, detect and resolve CPU, I/O, Memory, Network resource contentions.
• Expertise in Performance Tuning, Query Optimization, Client/Server connectivity and Database Consistency and integrity checks using DBCC Utilities, DMVs, Wait Stats, Extended Events, SQL Profiler and other related monitoring and troubleshooting tools.
• Expertise in reading and understanding execution plan and fixing query to execute with low cost using various operators depending on the scenario.
• Experience in using SSMS to create and schedule jobs, alerts and operators with SQL Server Agent, handling Backup/Recovery of databases, Linked Servers, Database Maintenance Plans.
• Extensive experience in implementing BI solutions using Tableau Desktop, SSIS, SSRS&SSAS.
• Hands on experience in Installation, Configuration of SSRS and Designing, Developing and deploying the reports using SSRS and its Administration.

TECHNICAL SKILLS

Databases: SQL Server 2019, 2016, 2014, 2012, 2008 r2, 2008 and MS-Access

Cloud Services: Azure and AWS

Operating Systems: Windows 2000 Enterprise Advanced Server, Windows 2003 Enterprise/Datacenter Server, Window 3.x, XP Professional and Windows 2000, Windows Server 2012 r2, Window 10, Windows Server 2016

Development Tools: Microsoft Visual studio 2012, 2015, 2017, 2018

Database Tools: Fog light, SQL Profiler, QuestLite Speed, Quest Spotlight, Idera, SCOM, Sky Bot, Query Analyzer, SQL Server Management Studio (SSMS)

ETL Tools\Connectivity: ODBC, JDBC, linked Server, OLEDB, Oracle Driver, SQL Driver, Sybase Drivers, BCP, RDP(remote desktop Connectivity), PowerShell, Microsoft terminal Services, Windows Scheduler, control-M job scheduler, SQL Agent Scheduler, Data Stage, and SSIS 2019, 2017, 2016, 2012, 2008R2 and 2008

Reporting Tools: SSRS 2019, 2017, 2016, 2012, 2008R2 & 2008, Power BI, Microsoft Dynamics

Others: SKYPE, Symphony, Abode chat, WebEx, Zoom, MS office Suits, WinZip, Snipping Tool, Jira, ITSM, HPSM, EURC,EPV, Service Now & Symphony

PROFESSIONAL EXPERIENCE

Confidential, Downers Grove, Illinois

Sr. SQL Server DBA

Responsibilities:

• Served as DBA in the completion of medium- to large-scale implementations, managing projects from business requirements analysis to solutions delivery and support.
• Managed SQL database administration assignments for diverse industry clients. Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups. Ensure technical and functional designs meet business requirements.
• Datacenter Migration and Server Upgrade: Acted as Physical data modeler, did requirement analysis & capacity management for projects.
• Installed, Build & Implementation: Installed, Migrated & build MS SQL server from 2008/2008R2/2012/2014 to latest MS SQL servers 2016/2019 on Windows servers 2008, 2012 and 2016. Installed Service packs (SP), FCI multi nodes cluster instances, set up Always ON, Clustering, Listener, DAG, mirroring and replications. Installed and maintained SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL server Integration (SSIS) services.
• Middleware ETL connectivity: Set up ODBC, OLEDB, Linked Server, SSIS, and Oracle driver for connectivity.
• Platform Migration: Migrated databases from Oracle to SQL server, Sybase to SQL Servers, UDB to SQL Servers using SSMA tool. Migrated servers and databases to AWS Amazon RDS Cloud. (AWS, EC2, SQL, MYSQL).
• Maintenance, Support, Backups & Recovery: Monitored daily and weekly maintenance jobs( Backups Jobs, run DBCC run Rebuild Indexes, run update statics, run audit jobs), sent backups to tape(daily, weekly and monthly), Checked Server Error logs and validated space usage history(Log Files/data Files). Monitored replications and mirroring for servers.
• Monitored always-On failover and AG groups, Synchronized database between DR site and replicas. Monitored redo queue for any alerts, resumed replications to remove latency and synchronize data, Checked Server health and database health for any issues.
• Killed blocking process and monitored batch processes for any issue or slowness. Monitored failed jobs. Monitored TEMPDB space. Validated daily backups and log backups to meet business requirements for specified RTO and RPO
• Performance & Tuning: Provided the best Query plan, Tuned query for high I/O applications, disk Wait, high latency, and high CPU usage. Performed Index Optimization and did performance Tuning (DBCC, Update statistics, Fragmentation/index creation/data row or page level locking),
• Architect and implemented theSQL Always-On architecture in SQL Server 2014/2016/2017 to provide High AvailabilityandLoad balancing solution to the production servers.
• Experienced ininstalling and configuring SQL Server 2016and had experience innew features like Query store, Always Encrypted, Row level security, stretch database, Temporal table, SQL Always On.
• Security & Audit: Managed Security & users controls as per firms’ compliance (Active directory, Service id, database authentications, custom role, applications roles, GMSA, folder control)
• HA/DR Resiliency: Designed and Setup SRDF, Clustering, Mirroring, log shipping. Replication, Dump/Load, Always-On, AG, FCI, Cluster Failover for disaster recovery.
• Encryptions & Communications: Created Mail profiles, Implemented Encryptions (TDE), VORMETRIC encryption. Installed & Renewed SSL certificates (data in-transit), Defines Ciphers (TSL) for SQL server and windows. Implemented Symantec ESM (Enterprise Security Module) on windows/SQL Servers for data security control and audit across the firm.

Environment: MS SQL Server 2016, 2012/14, 2008, 2008R2, MS Access, Microsoft Access Database, SQL Server Management Studio, SQL Profiler, Data Transformation Services, Service now, SharePoint, SSIS, MS Office, MS Access, MS Excel.

Confidential, NY

SQL Server DBA

Responsibilities:

• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production.
• Fixing data issues and writing various SQL scripts and procedures for migration process.
• Worked on High availability env like clustering, replication, Database Mirroring & log Shipping
• Extensively worked on Snapshot and Transactional Replication.
• Implemented the disaster recovery processes.
• Used DTS jobs for importing data from legacy systems to the current model.
• Worked on DTS, Import and Export utility, BCP Utility and replication tool.
• Responsible for transferring packages using SSIS.
• Created and modified Stored Procedures and Functions to generate reports.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilt the indexes at regular intervals for better performance.
• Used log shipping for synchronization of database.
• Day-to-day activities such as backups to the disk and restore the databases and transaction.
• Setup, implemented, and maintained industry standards in database management.
• Monitored SQL server performance using profiler to find performance and deadlocks.
• Developed all the required stored procedures, user defined functions, triggers using T-SQL.
• Good at Data availability solutions like Online Restore, Online index Operation,
• Database Snapshot, and Fast Recovery.
• Responsible for creating Constraints and Indexes.
• Created views to restrict access for the security of data in a table.
• Caught and Reported errors using exception handling.
• Monitored performance of the scheduled jobs and alerts.
• Performance tuning and testing on stored procedures, indexes, and triggers.
• Generated reports using SSRS.
• Used SSRS to create drill-down and drill-through reports.
• Scheduled jobs and alerts using SQL server agent.
• Migrated data from different sources including flat files, MS Access, Oracle 8i/9i to
• SQL Server by using SSIS. Involved in SSIS Package, DTS Import/Export for transferring data.

Environment: MSSQLServer 2008, 2008R2 and 2012, Windows 2008R2 Advanced Server

Confidential - Branchburg NJ

SQL Server DBA

Responsibilities:

• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production.
• Fixing data issues and writing various SQL scripts and procedures for migration process.
• Worked on High availability env like clustering, replication, Database Mirroring & log Shipping
• Extensively worked on Snapshot and Transactional Replication.
• Implemented the disaster recovery processes.
• Used DTS jobs for importing data from legacy systems to the current model.
• Worked on DTS, Import and Export utility, BCP Utility and replication tool.
• Responsible for transferring packages using SSIS.
• Created and modified Stored Procedures and Functions to generate reports.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilt the indexes at regular intervals for better performance.
• Day-to-day activities such as backups to the disk and restore the databases and transaction.
• Setup, implemented, and maintained industry standards in database management.
• Monitored SQL server performance using profiler to find performance and deadlocks.
• Developed all the required stored procedures, user defined functions, triggers using T-SQL.
• Good at Data availability solutions like Online Restore, Online index Operation,
• Database Snapshot, and Fast Recovery.
• Responsible for creating Constraints and Indexes.
• Created views to restrict access for the security of data in a table.
• Caught and Reported errors using exception handling.
• Monitored performance of the scheduled jobs and alerts.
• Performance tuning and testing on stored procedures, indexes, and triggers.
• Used SSRS to create drill-down and drill-through reports.
• Scheduled jobs and alerts using SQL server agent.
• Migrated data from different sources including flat files, MS Access, Oracle 8i/9i to
• SQL Server by using SSIS. Involved in SSIS Package, DTS Import/Export for transferring data.

Environment: SQLServer 2008 R2, T-SQL, EXCEL, Power point, Windows 2008 Server, Visual Source Sate 6.0, ITSM, Foglight, Scom, Net App Snap manager, DB Monitoring Software Imperva

Confidential

SQL Server Administrator

Responsibilities:

• Expertise in implementation, administration, troubleshooting and remediation of MS SQL 2012, 2008 (SQL Engine, SSRS, SSIS).
• Comfortable migrating data from multiple sources, SSRS reports and SSIS packages. Help business partners create scripts to massage data in their ETL process.
• High Availability - Implement Log Shipping and Mirroring and supported several Disaster Recovery tests.
• Security Remediation: Tightly rolled out security to be consistent with Bank Baselines and application needs (keeping to the minimum appropriate access required). Expertise in ESM Reports using Discovery tool, which scans the MSSQL Servers/Machines/ Instances as configured, across various domains for various violations.
• Performance: Optimized database using execution plans and Index tuning.
• Troubleshooting: Effectively use Profiler to find performance issues and deadlocks. Resolve blocking and long running queries through Activity Monitor and Profiler.
• Catch and Report errors using exception handling.
• Monitor the performance of the scheduled jobs and alerts
• Migrate data from different sources including flat files, MS Access, Oracle 11i/ to SQL Server 2008 by using SSIS. Install multiple clients and resolved 32/64 bit driver issues.
• Work heavily with BBDA (for server builds), Fog light (for monitoring), and Lite Speed (for backup compression).
• Comfortable coding T-SQL.

Environment: SQLServer 2008/2008R2 Enterprise Manager,SQLQuery Analyzer,SQLProfiler, SSIS, MS ACCESS, Crystal Reports.