SUMMARY:

• 8+ years of IT experience in Administration and Development on Database Design using SQL server 2008, 2012, 2014, 2016 and 2019 Servers in OLAP and OLTP environment systems along with experience inBusiness Intelligence development, Data Modeling and Analyticsin Banking & Financial Services.
• Excellent SQL Server administration skills including Database Creation, Tables, Indexes and Clusters Creation.
• High level understanding ofRDBMSconcepts as well asData ModelingandAzure SQLconcepts.
• Sufficient hands - on experience inHA DR High Availability Disaster Recoverytechniques likeLog Shipping,Always on, Mirroring High safety High performance, Replication Snapshot TransactionalandClustering Active - Passive and Active- Active.
• Experience working with data-tier application DAC formigration & experience inmigrating SQL Server 2008/2008R2/2012/2014 & 2016. Furthermore, extensive use of DTS in SQL Server, Performance Tuning & Application Design, Disaster Recovery Planning, Security Management, Managing server and clients. Also, supported teams in resolving SQL Server Reporting services and T-SQL related issues.
• 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).
• Experience in supporting dozens of Amazon AWS implementations including Amazon EC2 (IaaS) and all Amazon RDS (DBaaS)Amazon AWS services include provisioning, implementation
• Administration and monitoring support for Microsoft SQL Server, very strong in Amazon AWS provisioning, administration, monitoring and troubleshooting.
• Experience in using third party tools for Data modeling SQL Diagrams, Erwin, for Backup Solutions SQL Lite Speed, for performance Fog light and for alerting Idera
• Experience in data migrations, backup and recovery, geographic data replication (Region and Availability Zones), Cloud Watch performance monitoring,
• System tuning and disaster recovery configuration and execution
• 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 TEMPeffects, detect and resolve CPU, me/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:

Platform: Windows 2019,2012,2017, HP Unix, Sun Solaris Unix, Linux, Windows, AWS cloud RDS, EC2

Topologies: Ethernet, Token Ring, Wireless, TCP, IP, Telnet, SSH, SQSH, FTP, SFTP

Tools: Microsoft Enterprise Manager, SQL Browser, TOAD, Microsoft SQL Server Management Studio. Microsoft Business Intelligence Studio. Visual Studio, DBARTIZEN, SSMA (SQL Server Migration Assistance), Profilers, Trace, Query Analyzer and EPV tools, MS VISIO, DTS (Data Tool), Perf Mon, SpDiag, sql360, SCOM, ErWin, PuTTY, SSH, Hummingbird, Exceed, Query Analyzer, SQL Sentry, PGADMIN, SQL Browser Workbench.

RDBMS: MS SQL Server 2008R 2/2012/2014/2016/ to /2017/2019), Sybase ASE 11.x,12.x,15.x, Oracle 10g, 11g, 12c, UDB, DB2, Always On, FCI Clustering, Replication Servers & Tera Data, AWS RDS, EC2, S3 backups.

Languages: SQL, XTML, Web Services, C, C++, .NET, Angular, Atana.

Version Control: PVCS, SVN, Bit Buckets, Object Smith, SharePoint, Clear Case, SharePoint.

ETL and Connectivity: ODBC, JDBC, linked Server, OLEDB, Oracle Driver, SQL Driver, Sybase Drivers, SQL Integration Services,(SSIS), SQL reporting Services (SSRS), Robocop, BCP,RDP(remote desktop Connectivity),Microsoft terminal Services, Windows Scheduler, control-M job scheduler, SQL Agent Scheduler & CRONTAB, Data Stage.

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

PROFESSIONAL EXPERIENCE:

Confidential, East Windsor, NJ

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 SQLServers 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 me/O applications, disk Wait, high latency, 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 autantications, 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 s (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.

Confidential, Bloomington, MN

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.

Confidential, Lake Forest, IL

SQL Server DBA

Responsibilities:

• Installed SQL Server 2005/2008R2/2012 and administered nearly 50+ servers ensuring zero downtime.
• Installed and Configured SQL Server 2005 and SQL server 2008 enterprise editions and upgraded the existing databases to SQL Server 2008.
• Worked as Application Primary DBA for the projects assigned.
• Collaborate with the SAP Project Management, Business and Systems Analysts and user departments to develop specifications for system enhancements for continuous functional improvement.
• Good Knowledge in Active/Passive and Active/Active Clustering and implemented RAID Technology on windows 2003 servers.
• Installed, configured and maintained SQL Server Failover clustering (Active/Passive) for 15 production environments and for many missions’ critical applications.
• Addressed the Replication Issues. Created new replications, implemented Mirroring to maintain high availability of the data between the servers.
• Involved in implementation of Replications like Snapshot and Transactional in OLTP environments.
• Configured SNAPSHOT Replication using Snapshot agent. (Creating Distribution Databases, creating & managing Publications, managing Replication monitors)
• Experience in creating complex SSIS packages using proper control and data flow Elements and deployed the packages and scheduled them.
• Extensive experience with SSIS packages in creating ad hoc reports using EXCEL and XML files, used as a ETL tool to pull data from SQL server (OLTP) to Teradata (data warehouse), maintenance tasks, providing alerts through email, Scheduling tasks and to generate scripts during migration and up gradation.
• Hands-on working experience with analyzing query plans, managing indexes and locks, troubleshooting deadlocks, managing triggers.
• TEMPEffectively using DBCC commands, Dynamic Management Views (DMV), SQL Profiler, Performance Monitor, SQL Server Management Studio, Trace Analysis and Execution plans as part of troubleshooting and performance tuning.
• Involved in Partitioning Databases and Tables for better Performance.
• Experience in taking Backups and restoring using various 3rd party tools like Lite-speed, VERITAS and created Disaster recovery strategy and automated the tools to perform scheduled backups.
• Experienced with Managing user accounts and security in Standard, Integrated and Mixed Security. Assigned user permissions SA, DBO AND Ownership Chains
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Built different types of chart reports using SSRS for the business requirement like column chart, Pie Charts.
• Configured and maintained SSRS for local area reporting and has good knowledge in
• Assisted project activities as per PMI Project Lifecycle methodology.
• Managing and Coordinating with the offshore team on daily Database maintenance activities. Worked as a team member for 24X7 on call production support.

Environment: SQL Server 2012/2008R2/2005, Windows 2003/2008, Lite-speed, VERITAS, ETL, SSIS, SSRS, .ASP, VB scripting, MS Excel and MS Access, Oracle, Teradata, UNIX, SSAS, System Monitor / Performance Monitor.

Confidential, Mt Laurel NJ

SQL Server DBA

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: TEMPEffectively 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.