SUMMARY:

• A software professional with years of varied experience in all aspects of Information Technology with predominant focus on Database management systems with hands - on technical strength in SQL server DBA.
• Experience as SQL Server DBA (2016, 2014, 2012, 2008, 2005, 2000) in Production, Development and Staging, Data Warehouse Environments (OLTP and OLAP).
• Extensive experience in Configuration, Implementation and Maintenance for Disaster Recovery solutions using Always-On, Log Shipping, Transactional & Merge Replication in SQL Server 2008/2005.
• Experience with analyzing query plans, writing stored procedures, try-catch blocks, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks and blocking, Checking the threshold values and baselines.
• Expertise in Query Optimization, Performance tuning, Database consistency using DBCC utilities and server connectivity, DMV’S, DMF’S, analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Hands on experience on using the Import/export & BCP tools to migrate the data to DB.
• Development of Automated notification when SQL Server Backups and schedule maintained jobs fails.
• Intensive experience in Monitoring and Tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, Windows Performance Monitor.
• Experience in solving Database issues with Index fragmentation, DBCC checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Error and Event Handling.
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and DB Engine Tuning Advisor.
• Object Level Audits using Change Data Capture (CDC).
• Managing database systems using Query Governor and Activity Monitor.
• Expertise in SQL Server Storage Structures and Security Architecture for databases residing on SAN storage on distributed systems.
• Expert in automating process by creating jobs, and error reporting using Alerts, SQL Mail Agent.
• 24/7 Production Databases on Call Support. Excellent Analytical, problem solving and communication skills.
• Worked in an agile development team to deliver an end to end continuous integration/Continuous delivery product in an open source environment.
• Excellent communicative, interpersonal, intuitive, analysis and leadership skills with ability to work effectively in both independent and teamwork environments. Ability and adapt quickly to emerging new technologies/environments. Self-motivated and self-reliant, can adopt to any kind of environment.
• Experience in performance tuning, query optimization, client/server connectivity, running database consistency checks using DBCC Utilities, SQL Server Profiler, Index Tuning Wizard, Database Engine Tuning Advisor (DTA), and SQL Server Agent
• Monitoring scheduled jobs and disk spaces, maintain security/permissions on all servers.
• Proven ability in database backup and recovery procedures.
• Resolved the HPSM/Service Now/Teamtrack tickets and provide support to the application teams.
• Expertise in the migration/ upgrade of the SQL servers 2005 to 2008, 2008 to 2012/2014/2016 based on application requirement.
• Good experience in resolving SQL Server blocking and Dead Lock Issues.
• Handled VLDB’s of around 10 TB in Size.
• Used third party backup tools like LightSpeed, Veritas net backups, Redgate, TSM/TDP, DD Boost.
• Involved in the Disaster Recovery exercises.
• Hands on experience and outstanding knowledge of high availability SQL Server solutions, including SQL Server Always-On, Log shipping, Mirroring and SQL Server clustering (Active/Active and Active/Passive).
• Maintaining the Active Directories and security at the server and DB level.
• Expertise in writing complex T-SQL (DDL, DML, DCL & TCL) queries, Stored Procedures, User Defined Functions (UDF's), CTE’s, Database Triggers and Exception Handlers
• Expertise in Normalization and De-Normalization techniques for both OLTP and OLAP systems.
• Debugging Stored Procedures, Views, User Defined Functions and Triggers.
• Extensive ETL experience using DTS/SSIS for Data Extractions, Transformations and Loads
• Conversion of DTS packages to SSIS packages and Interfacing Legacy components within SSIS for complex transformations and logic
• Experienced in extraction & migration of data from heterogeneous data sources like Excel, MS Access, Sybase, DB2 to MS SQL Server by using import/export Wizard, DTS/SSIS, BCP and Bulk Insert utilities.
• Experience in creating jobs, Alerts and schedule SSIS Packages using SQL Server Agent.
• Experience in scheduling and monitoring ETL processes using DTS Exec utilities and batch files.
• Experience in performance tuning of SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Extensive knowledge in Designing, Developing and deploying various kinds of reports
• Expert in creating Parameterized, Cascaded, Linked, Drill-through and Drill-down reports
• Experience in creating reports from CUBES and Performance testing using Report Analyzer
• Experienced in creating dashboards, scorecards and analyzed the results produced in the dashboard.
• Developed & supported various mission critical Client Server applications by handling Database requests for various application development teams involving complex business logic, functionality.
• Extensive experience with SQL Server and T-SQL in constructing tables, triggers, user defined functions, relational database models and data integrity.
• Good knowledge in creating, modifying, using and debugging Stored Procedures, Views, indexed views.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Experience in Implementing Change Data Capture (CDC) on databases.
• Involved in addressing Batch process issues, Job scheduling, Code Debugging, Maintenance and Bug Fixes.
• Experience in monitoring MS SQL Server databases and performance tuning using Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Test & Deploy code across various SDLC Environments like DEV, TEST and Production.

TECHNICAL SUMMARY:

Databases: MS SQL Server 2016/2014/2012/2008

ETL & REPORTING Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Integrator, Data transformation services (DTS)

Database Tools: SQL profiler, SQL Query Analyzer, Index Analyzer, DTA, SQL Server Management Studio, Perfmon.

Third Part Tools: Idera SQL Check, Companion, DD Boost, lite speed, Red gate, Veritas net backup, JIRA, Confluence, JFrog

DevOps tools: Chef, Puppet, Jenkins, Docker, Vagrant, Oracle Virtual box, Openstack, AWS, GIT, SVN (Source control tools)

Languages: T-SQL, C/C++, Visual Studio 2010/2012/2013 , XML, HTML, VB script, ruby

PROFESSIONAL EXPERIENCE:

Confidential

Sr. SQL Server Production DBA

Responsibilities:

• Build SQL Servers for new projects and upgrade projects, complying with SQL standards of Confidential, involving installation of 2014/2016 in Production, UAT, PT and Development.
• Post installation and configuration of SQL servers according to the application requirement.
• Installation, Administration and troubleshooting of active/active & active/passive SQL 2 node cluster and 6 node SQL AG setup.
• Provide additional support to the application team for install of their applications in regard to new Database environment created.
• Worked on the different types of Clusters Active-Passive Cluster and Active-Active Cluster.
• Worked on the tickets create by users in HPSM and team track requests.
• Respond to the alarm points generated by the monitoring in a timely manner.
• Involved in the SAN migration for the upgrade of servers.
• Provide on call support 24/7 to new production systems which went live, till the end of the warranty period.
• Review permissions for users to Database, should have the least privileges as per security practice.
• Setup and configuration of SQL 2014 Always ON Availability groups along with AG listeners.
• Setup, Managing and troubleshoot Mirroring (Synchronous mode) with witness server for automatic failover for application database.
• Assist the development teams to deploy the reports through SSRS and maintain security for the reports.
• Implementation of TDE (Transparent Data Encryption) for HPA-Data and maintenance of Encryption Keys, Certificates and migration of Encrypted Databases across different environments.
• Involved in setting up the Lync/skype for business setup from the DB perspective.
• Have experience in installing and maintaining the SQL servers in Cloud/AWS environments.
• Worked on writing the recipes as part of cookbooks for automating the SQL server tasks using the Chef automation tool.
• Worked on restoring the Dev DB using the prod Backup files.
• Involved in setting up the new 2016 sharepoint app & DB servers.
• Working along with the developers to perform database development activities.
• Data migrations across the environments, Dev, QA, ST and Production.
• Creating SQL stored procedures, views and triggers and managing indexes
• Using SSIS built high performance data integration solutions, including extraction, transformation and loading (ETL) packages for building a Staging Databases.
• Involved in implementing SSIS package security, protecting packages, executing, monitoring and managing them.
• Extensively deployed and troubleshoot SSIS packages along with support and troubleshoot existing SSIS package failures and performance tuning.
• Identify and optimize slow running query in OLTP and SSRS environment.
• Creating Data source, testing and deploying reports in SSRS environment.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed various operational, drill-through and drill-down reports using SSRS.

Confidential, Woonsocket, RI

Sr. SQL Server Production DBA

Responsibilities:

• Installed Sql Server 2014 and configured Always On With Primary and secondary Replicas, Read only databases, listener and with Application Intent.
• Monitored and modified Performance using execution plans with query hints and Index tuning.
• Maintaining the database consistency with DBCC at regular intervals, Managed Disk space and memory and User connections and Monitored SQL server performance using profiler to find performance and deadlocks.
• Creating views and stored procedures and optimizing them as required by front-end developers for easier implementation on web pages and performance testing on stored procedures, indexes, and triggers.
• Performed Database Integrity Checks, Database Maintenance plans, updated Database Statistics and performed Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance.
• Performed horizontal data partitioning for efficient management of database tables and indexes.
• Working on Client/Server tools like SSMS, SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support via ACTIVE DIRECTORY.
• Developing T-SQL stored procedures, log on & DDL triggers, views and adding/changing tables for data load and transformation, and data extraction and loading to data ware house.
• Working on different environments and a key resource for deployment of modified objects to production environments.
• Experience in writing scripts like retention of data using batch deletes.
• Designed and deployed SQL Server Integration Services (SSIS) Packages, with error handling, environmental and SQL server package configurations.
• Incremental loading of dimensions, facts, error handling in SSIS.
• Created Dynamic SSIS packages, to load Stage tables from text files.
• Created SSIS/DTS packages for Finance application that would transfer data among servers and perform other data transformations and scheduled the same SSIS packages by creating the corresponding job tasks.
• Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity.
• Generated Script files of the databases whenever changes are made to stored procedures or views.
• Configured and managed virtual Servers and worked on virtualization and clustering environment.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Created DB master key, symmetric keys, asymmetric keys, certificates for encryption.

Confidential

Sr. SQL Server DBA

Responsibilities:

• Involved in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 1 Terabytes.
• Actively involved in setting up Active-Active/Active-Passive clustering in production and Testing Environments and also troubleshot issues with the same. Applied hot fixes and Service Packs in clustering environments.
• Created and maintained various databases for Production, Development and Testing environments using SQL Server 2012
• Conducted Database mirroring in High Performance and High Availability mode and troubleshot issues with witness servers.
• Experienced in performance tuning using windows performance monitor and SQL profiler of SQL server. Used SQL Server error logs and event viewer to troubleshoot issues.
• Experience in Configuring, Managing and trouble shooting on SQL Server connection protocols like Kerberos and NTLM.
• Implemented Kerberos Delegation with SSRS.
• Performed daily backups and developed recovery procedures.
• Performed SQL server trouble shooting for immediately issue, such as deadlocks and Blocking.
• Involved in the migration of the data across different databases and different servers using SSIS, BCP and Import/export tools.
• Involved in Change Control Management is the discipline of systematically identifying and controlling change requests to a project from both internal and external sources.
• Implemented and configured database monitoring tools and focused on providing a high availability database.
• Troubleshot issues with log file full and database size increasing beyond threshold.
• Creation of new database, planning the location of data, index, and transaction log files on the disks
• Involved in Capacity Planning, data modeling and Logical/Physical database Design.
• Handled the database components of application releases.
• Manage SSIS packages, stored procedures, jobs, and utilize Server-Side tracing to identify performance issues with deadlocks & other locking issues.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting / Ad hoc reporting.
• Worked closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts etc.
• Involved in all ITIL process like Change management, Incident Management & Problem Management.
• Actively participated in determining the database schema, database schema changes, implementation plan for database schema releases in coordination with developers and data modelers in adherence with Organization policies.
• Developed and deployed stored procedures, created triggers and audits.
• Developed Jobs for maintenance in terms of updating statistics, rebuilding indexes, scheduled full/diff/log backups, refreshing database environments periodically or on demand. Also set up notifications for failure of jobs etc.
• Monitoring SQL server performance using profiler to find the performance and dead locks.
• Monitoring and Troubleshooting SQL Cluster, Mirroring, Log Shipping
• Handled 24/7 production issues.

Confidential, Boston, MA

SQL Server DBA

Responsibilities:

• Planned and Successfully Installed SQL Server 2008, 2012 on the Production and Development Servers.
• Involved in migrating the existing 2008 databases to SQL Server 2012 (Side by Side).
• Developing the successful Backup strategies based on Recovery models.
• Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases and transaction log on production/
• Involved in creating Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Raising the change management request and following up with the customer approval, for making any changes in the production server
• Involved in DTS/SSIS Package, DTS Import/Export for transferring data.
• Implementing Database maintenance plan for Database consistence & Integrity, On call 24/7 support to databases on weekly rotation.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• Used SSRS to build health check reports & deploying the SSRS.
• Experience in using Data Driven Subscription to prevent unforeseen circumstances.
• Monitoring SQL server performance using profiler to find the performance and dead locks.
• Monitoring and Troubleshooting SQL Cluster, Mirroring, Log Shipping.
• Creating the Jobs using maintenance Plans for Full, Differential and transactional log backups.
• Recovered many Databases at the time of Database crashes or data loss.
• Performing SQL Server database performance analysis and ongoing maintenance/tuning to ensure maximum performance.

Confidential

SQL Server DBA

Responsibilities:

• Installed SQL server 2008, applied security fixes.
• Involved in Migrating SQL Server 2008 Servers to SQL server 2012 provide support to all Production and development servers.
• Maintained database response times in 24X7 Production environments, proactively generated performance reports. Automating most of the DBA Tasks and monitoring stats.
• Planning and implementation of database backup/restore and disaster recovery.
• Responsible for defining Check constraints, Business Rules, tuning data, indexes, and queries.
• Configuring and administering Database Mirroring, Log Shipping on SQL Server 2012
• Running Index tuning wizard and rebuilding indexes for faster query response.
• Wrote Stored Procedures, Functions and triggers using T-SQL based on the requirement.
• Performed all aspects of database administration, including data modeling, backups and recovery.
• Configured Transactional replication between Primary Server and three Read - Only servers, with separate Distributor server and experience in troubleshooting replication problems.
• Expertise in Security Issues such as creation and granting permissions on various Objects.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes.