DEEPIKA

Sr. SQL DBA

Contact: +* *** *** - ****

Email Id: ad48v5@r.postjobfree.com

PROFESSIONAL SUMMARY:

•Over 10+ years of experiences as MS SQL Database Administrator and programmer. Responsibilities include daily SQL optimization, Performance tuning, production support, maintenance review, Disaster recovery planning and ensuring 24x7 supports.

•Excellent experience working on different versions of SQL server like 2000, 2005, 2008, 2008r2, 2012,2014,2016.

•Experienced in installing SQL SERVER 2016/2014/2012/2008R2/2008 updating with the hot fix and service packs on Physical/VM Ware Clustered and Standalone Environments.

•Worked on migrations from on prem SQL servers to AWS cloud servers.

•Expertise in implementation of security models, windows users and groups, logins, roles, Trusted accounts, database authentication modes, users, database roles and permissions.

•Experience in creating Data Model for Data Warehouse.

•Strong T-SQL programming skills with real time experience in customizing applications by creating and managing database objects like tables, triggers, views, stored procedures, functions and indexes.

•Recovered many databases to point in time or max possible data in many cases during database corrupted or accidentally dropped objects due to human error.

•Ensuring high availability of databases for smooth running of the business by implementing high availability solutions like Database Mirroring, Log shipping and failover Clusters depending upon the criticality of the applications and as per Organizational requirement.

•Experienced in database development for both OLTP (Batch Processing) & OLAP Systems using MSSQL Server 2005/2008/R2/2012.

•Expert in the areas of MS SQL Server installation, Configuration, Server upgrade, Database design and normalization, Performance tuning, Security administration, Backup and recovery, Disaster recovery techniques such as mirroring, log shipping and clusters.

•Installed and maintained MS SQL Server 2005, Server 2008 on Windows 2003 Server.

•Solid experience in version control tools such as Team Foundation Server (TFS) and Sub version.

•Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler and DB Engine Tuning Advisor.

•Implement and maintain database security, replication, SQL Clustering, Stand by server, DTS, SSIS, SSRS, log shipping, database mirroring, SQL mail, database mail.

•Monitor databases and resolve any blocking issues. Identify slow running queries and perform performance tuning by examining the execution plans and creating missing indexes to boost the query performance.

•Extensively used tools like SSMS, SQL Profiler, index tuning wizard, windows performance monitor for monitoring and tuning MS SQL Server performance.

•Monitor SQL Server using Error Log, Event viewer and application log, and activity monitor for any blocking or heavy locking or high number of suspended sessions and wait stats of top waits.

•Good knowledge of SharePoint 2013 administration, deploying shared services, indexing, search, user profile creation and various application tasks.

•Experience in solving Database issues with Index fragmentation, DBCC checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Error and Event Handling.

•Installed and configured clustering i.e. active/active and active/passive.

•Handful of experience in PowerShell Scripting.

•Maintaining and Monitoring Production, Pre-Production and Development database server environment.

•Monitoring event viewer, SQL error logs and log file viewer for software, hardware errors.

•Strong experience working with stored procedures, database tuning methodologies, naming conventions, extraction, transformation and query methodologies.

•Expertise on business intelligence tools to create SSRS Reports, SSIS Packages and SSAS with OLAP. Migrating on premises SQL server database to Microsoft Azure.

•Experience in maintenance jobs to perform full, differential and transaction log backups using simple, bulk-logged and full recovery model for database backup, recovery solutions.

•Experience in providing 24X7 on call support on weekly rotation.

TECHNICAL SKILLS:

Programming Languages

SQL, TSQL, XML, HTML, ASP.NET, Visual Studio 2010, VBScript

RDBMS

MS-SQL Server 2016/2014/2012/2008/2008R2/2005/Microsoft Access.

ETL Tools

SQL Server Integration Services, DTS.

OLAP Tools

SQL Server Analysis Services (SSAS)

Reporting Tools

SQL Server Reporting Services (SSRS), Crystal Reports.

Database Tools

SQL Server Management Studio (SSMS), SQL Server Business Intelligence Studio (BIDS), SQL Profiler, Query Analyzer, SharePoint

Performance Tools

Erwin, Fog light, Idera, Spotlight, Tivoli, SCOM

Operating Systems

Windows Server 2003/2008/2012, Linux, Unix.

Backup tools

Idera, LiteSpeed, Native Backup, PowerShell, Red Gate.

Cloud Computing

Microsoft Azure Cloud and Amazon Web Services

Client: Transamerica, NY Feb 2020 - Present

Role: Sr. SQL Server DBA

Description – The Transamerica Corporation is an American holding company for various life insurance companies and investment firms operating primarily in the United States, offering life and supplemental health insurance, investments, and retirement services.

Responsibilities:

•Created and maintained various databases for production, development and testing environments using SQL Server 2017/2016, 2008.

•Gather service account information and document the same for all locations.

•Creating database maintenance plan for the performance of SQL server, which covers database integrity checks, update database statistics and re-indexing.

•Worked on migration of SQL databases from on prem SQL servers 2016 version to cloud AWS SQL servers 2016.

•Configured Always On, Replication, copy,restore databases and add databases to Always on during migration from on prem SQL server to cloud AWS SQL servers.

•Creating logins, users and groups with appropriate permissions, granting privileges to users and groups, server and database auditing using server-side tracing.

•Automation of frequent refresh requests are taken care of by creating SQL jobs that copy the backup from production, backup roles and users from development database, perform refresh and reapply the roles and users on to development.

•Using transactional replication for synchronization of database. Troubleshoot and fix the replication issues in SQL server 2016.

•Worked closely with developers, support and QA teams to maintain all DB environments.

•Monitoring the drives spaces in all the environments and taking necessary actions (shrink log files, delete old backups files\moving the files to shared network path) to free up the drive spaces.

•Work on SSRS. Deploying the packages from lower environment to production servers.

•Providing 24X7 on call support on weekly rotation.

•Responsible for bringing the database online, accessible and connected to the applications after the monthly patching.

•Extensive experience in using SSIS, SSRS to import/export data from different sources of data into SQL Server Databases.

•Hand full experience on Large Database size of 8TB.

•Troubleshoot system issues, monitored scheduled jobs and setting up maintenance plans for proactively monitoring the performance of SQL Server databases.

•Review SQL Server Agent jobs and take corrective actions for failed jobs on daily basis.

•Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexes updates. Ensure daily and weekly Database maintenance jobs succeed. Also take care of other application related jobs that are critical for the application.

Environment: SQL Server 2017/2016/2008 SQL Server Reporting Services (SSRS), MS Azure, SQL Server Integration Services (SSIS), Windows 2008, Windows 2012, T-SQL, SQL Sentry one, PowerShell, DFS, MS SQL Server Management Studio, ERWIN and MSVISIO, AWS.

Client: CO-OP Financial Services, Duluth, GA Sep 2018- Dec 2019

Role: Sr. SQL Server DBA

Description –CO-OP Financial Services is a nationwide credit union network supporting their members with industry-leading ATM, digital payment, security and marketing services. CO-OP is a payments and financial technology company created by and for credit unions.

Responsibilities:

•Installation and configuration/Maintenance of SQL Server 2016/2014/2012 /2008R2/2008/2005 in all Environments. (Which include both VMWare and Physical).

• Configured SQL server 2012 always on availability groups with one secondary replica on windows server 2008R2/2012.

•Created and maintained various instances for Production, Development and Testing environments on SQL Server 2012, 2008r2 and 2005.

•Used VBScript in Creating SSIS Packages and Control the Flow.

•For security management, creating logins, users and groups with appropriate permissions, granting privileges to users and groups, server and database auditing using server-side tracing, server audit specifications, event notifications and monitoring SQL Jobs.

•Extensive experience on working with Idera SQL Monitoring Tool.

• Troubleshoot and resolve issues related to database integrity, performance, blocking and deadlocking, transactional logs, application connectivity and database security.

•Experience working with third party tools like Red gate backup tool for backups and restores.

•Created PowerShell Automations for various tasks.

•Worked closely with developers, support and QA teams to maintain all DB environments.

•Experience in working with SCOM Monitoring Tool.

•Experience in SQL Server, to configure the network protocols used by SQL Server, and to manage the network connectivity configuration from SQL Server client computers.

•Monitoring SQL Server performance using SQL PROFILER to find deadlocks and blocking. Utilizing the traces for tuning the performance (advisor).

• Performance Tuning, Query Optimization using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.

•Designed and implemented comprehensive Backup plan and disaster recovery strategies.

•Perform building indexes, index management, integrity checks, configuration and patching

•Migrated databases from DB2 & Oracle, SQL Server 2005/2008 to SQL Server 2012 using SSIS, BCP and documented the process with Pre-Migration and Post-Migration steps.

•Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support via ACTIVE DIRECTORY.

•Strong T-SQL developer skills including stored procedures, indexed views, user defined functions, triggers, and distributed queries.

•Real time trouble shooting production issues during on call schedule with minimum timelines in resolving issues.

•Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

•Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, SQL Profiler, restoring full, differential, and log backups.

•Designed and implemented comprehensive Backup plan and disaster recovery strategies.

•Provided 24 x 7 production support.

Environment: Windows 2003, Windows 2008, Windows 2012, SQL Server 2005, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SSIS, SSRS, SQL backup Pro, MS Outlook, SCOM, Bitbucket, MS Excel, MS Project, and MS PowerPoint, PowerShell, SQL Profiler, Idera, SCOM, JIRA.

Client: Fiserv Inc, Sunnyvale, CA Aug 2017 – July 2018

Role: Sr. SQL Server DBA

Description: Fiserv is a global leader in financial services technology solutions. Fiserv enables consumer to move and manage money with ease, speed and convenience by providing online banking, online bill payment services and software for check clearance and Automated Clearing House(ACH) processing. It provides integrated technology, service solutions, innovative solutions and expertise that helps our clients deliver financial services experiences and enables best in class results for our clients.

Responsibilities:

•Created and maintained various databases for production, development and testing environments using SQL Server 2017/2016/2014/2012/2008R2/2005.

•Installed and configured clustering i.e. active/active and active/passive.

•Used log shipping, Always on availability groups (AAG) and mirroring for synchronization of databases and transactional replication to achieve load balancing.

•Migration and upgradation of databases from SQL Server 2005 to SQL Server 2008R2, SQL Server 2012 and SQL Server 2014.

•Configure troubleshoot all SQL Server components such as SQL server properties, database properties, table/column properties, SQL Server Agent Jobs, SSIS packages, database maintenance plans, error logs, alerts, and security.

•Installed SQL Server 2012 and configured Always on with Primary and secondary Replicas, Read only databases, listener and with Application Intent.

•Setting up SQL Azure Firewall and manage SQL Server Azure Databases.

•Experience in PowerShell scripts for SQL Server Maintenance activities.

•Developed database objects such as SSIS Packages, procedures, functions, tables, triggers, and indexes using T-SQL, SQL analyzer and enterprise manager.

•Working on Client/Server tools like SSMS, SQL SERVER Configuration Manager, Reporting Services Configuration Manager and SAC to Administer SQL Server.

•Designed and developed the backup and archiving, disaster recovery in AWS Cloud.

•Extensive experience in using SSIS, SSRS to import/export data from different sources of data into SQL Server Databases.

•Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis.

•Modify database systems and build logical design models for database.

•Implementation of high availability solutions with Oracle 10g RAC, physical and logical standby databases and replication using Golden Gate.

•Strong T-SQL developer skills including stored procedures, indexed views, user defined functions, triggers, and distributed queries.

•Used third party tool, lite speed, red gate to speed up backup operations.

•Help application team identify the blocking process by collecting information on block processes after the fact using scripts querying DMVs.

•Developed project managed and delivered customer solutions for Active Directory migrations.

•Installed, authored, and managed reports using SQL Server 2012 Reporting Services.

•Developed documentation for a .Net Platform and translate the information into database requirements and specifications to develop multiple databases for a multi-client database.

•Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, SQL Profiler, restoring full, differential, and log backups.

•Experience on Implementing and controlling the flow of data to and from Azure.

•Expertise in performance tuning, optimization, data integrity and statistics by using SQL profiler and DB engine tuning advisor

•Experience in automating day to day maintenance tasks using PowerShell scripts, converting existing TSQL batch scripts to PowerShell scripts and improving SQL Server maintenance jobs performance.

Environment: SQL Server 2017/2016/2014/2012/2008R2/2005, SQL Server Reporting Services (SSRS), MS Azure, SQL Server Integration Services (SSIS), Windows 2008, Windows 2012, T-SQL, Golden Gate, Red Gate, .NET 1.0, PowerShell, DFS, MS SQL Server Management Studio, ERWIN and MSVISIO.

Client: Daimler Trucks North America, Portland, OR Feb 2016 – June 2017

Role: SQL Server DBA

Description: Daimler Trucks North America is an automotive industry manufacturer of commercial vehicles. Its products include heavy- and medium-duty commercial vehicles for long-haul transport, local and regional distribution, and construction and services, school buses, recreational vehicles, and shuttle buses, heavy and medium-duty diesel engines, mechanical transmissions.

Responsibilities:

•Managed and administrated SQL SERVER 2014,2012,2008/2008R2, highly transitive production environment and Active Passive clustered environment.

•Design databases and apply normalization to minimize data redundancy.

•Used log shipping and data mirroring for synchronization of database.

•Implemented SQL Server 2008/2008R2 concepts like data partitioning, snapshot isolation, database mirroring, database snapshot, CTE, DDL triggers, try-catch blocks, online indexing, DMV’s, DMF’s, mail Setup, jobs, and alerts, SQLCMD and dedicated admin connection.

•Real time trouble shooting production issues during on call schedule with minimum time lines in resolving issues.

•Extensively worked on trouble shooting and fine-tuning of databases for its performance.

•Expertise on physical storage SAN configuration on different RAID levels.

•Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis.

•Installed SQL Azure instances and create databases on SQL Azure.

•Expertise in performance tuning, optimization, data integrity and statistics by using SQL profiler and DB engine tuning advisor.

•Monitor databases and resolve any blocking issues. Identify slow running queries and perform performance tuning by examining the execution plans and creating missing indexes to boost the query performance.

•Gather service account information and document the same for all locations.

•Creating database maintenance plan for the performance of SQL server, which covers database integrity checks, update database statistics and re-indexing.

•Wrote basic batch file and PowerShell scripts to automate jobs.

•Experience in SQL programming, physical database design, and SQL performance tuning, replication.

•Created tables and performed data imports and restores for successful migration. Script development and troubleshooting various security syncing scripts to new databases.

•Extensive experience in using SSIS, SSRS to import/export data from different sources of data into SQL Server Databases.

•Strong T-SQL developer skills including stored procedures, indexed views, user defined functions, triggers, and distributed queries.

•Work towards achieving 100% results with Service Level Agreements by handling requests as per severity and getting back to the users well before SLA with resolution.

•Ensure standard backup policies are implemented across all servers depending upon the application criticality. Make sure we have backup cleanup tasks are in place.

•Plan, test and apply SQL patches on SQL servers to make sure we are up to date.

•Check alerts from SQL Log and work with Server team to fix any I/O or operating system issues. Help troubleshoot error and perform Root Cause Analysis.

•Help improve performance of queries by analyzing the execution plans, monitoring resource utilization and Database engine tuning tool to identify indexes/statistics that can help in performance tuning.

Environment: Windows 2012, SQL Server 2014,2012,2008/2008R2, SQL Server Reporting Services 2005 (SSRS), SQL Server Integration Services 2005(SSIS), PL/SQL, SQL Server Analysis Services, MS Azure, Visual Studio 2012, VMware, T-SQL, SQL Server Profiler, Lite Speed, Idera.

Client: Bank of America Merrill Lynch, NY Sep 2015 – Nov 2015

Role: SQL Server DBA

Responsibilities:

•Installing, Configuring and Maintaining SQL server 2012/2008R2/2008/2005 on Active/Active Cluster with latest service packs, hot fixes.

•Designed and implemented disaster recovery Procedures like log shipping, transactional replication, database mirroring.

•Installed and maintained MS SQL Server 2005, Server 2008 on Windows 2003 Server. Worked on SQL Server 2003 failover clustering which is built on top of a Windows 2003 server cluster.

•Involved in development and implementation of SSAS, SSRS and SSIS application solutions for various business units across the organization.

•Implemented new features in SQL Server 2008 like Policy based Management, Table Compression, Backup Compression, SQL Server Auditing, Resource Governor and Merge statement in T-SQL.

•Work towards achieving 100% results with Service Level Agreements by handling requests as per severity and getting back to the users well before SLA with resolution.

•Create necessary T-SQL scripts, stored procedures, tables, views, functions, triggers and indexes

•Performed backups and restores, DBCC utilities, updated index statistics, monitor database and disk space.

•Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.

•Migrating SQL Server 2000 databases into SQL Server 2005 and SQL Server 2000/2005 to SQL Server 2008.

•Configuring, tuning and optimizing SQL Server 2005, SQL Server 2008.

•Experience in SQL programming, physical database design, and SQL performance tuning, replication.

•Check alerts from SQL Log and work with Server team to fix any I/O or operating system issues. Help troubleshoot error and perform Root Cause Analysis.

•Creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

•Used third party tool, Lite Speed, Red Gate to speed up backup operations.

•Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, SQL Profiler, restoring full, differential, and log backups.

•Created and maintained logical/physical data structures.

•Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and process SSAS cubes.

•Responsible for Stored Procedures optimization, Performance tuning & index tuning.

•Debugged and Deployed SSIS packages in to file system server and MS SQL Server with the help of manifest file.

•Maintained high availability of databases using Database Mirroring and Log Shipping.

•Expertise in performance tuning, optimization, data integrity and statistics by using SQL profiler and DB engine tuning advisor.

Environment: TSQL, MS SQL SERVER 2012/2008R2/2008/2005, SSRS, Query Analyzer, ETL, Visual Studio 2010, VB.NET, C#, MySQL, Windows Server 2008, SSIS, SSRS, SAN, database engine tuning advisor.

Client: InnVectra Softech Private Limited, Hyderabad, India Aug 2014 – July 2015

Role: SQL Server DBA/Developer

Responsibilities:

•Installed and configured SQL Server 2012/2008R2/2005.

•Extensively worked on log shipping and database mirroring for 2005 and 2000 production servers and SQL server 2005 security audit

•Performed data partitioning for efficient management of database tables and indexes.

•Troubleshooting blocking issues, deadlocks using blocker scripts, trace flags, activity monitor.

•Responsible for Stored Procedures optimization, Performance tuning & index tuning.

•Migrated SQL Server 2000 databases to SQL Server 2005 databases including DTS to SSIS migration and migrated SQL Server 2005 to VMware and SQL to Oracle using SSMS.

•Create necessary T-SQL scripts, stored procedures, tables, views, functions, triggers and indexes

•Configuring, tuning and optimizing SQL Server 2005, SQL Server 2008.

•Experience in SQL programming, physical database design, and SQL performance tuning, replication.

•Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, SQL Profiler, restoring full, differential, and log backups.

•Involved in complete database design including conceptual, logical and physical models.

•Administrator tasks like managing users, roles and permissions. Extensively worked on Log shipping for synchronization of databases for SQL Server High Availability.

•Maintain SQL Server Production databases and ensure high availability.

•Analyze slow running queries across environments and find the root cause for the same and resolve by introducing missing indexes, partitioning tables and placing them in different file groups on different drives to improve performance.

•Attend requirement gathering meetings along with application team and understand the requirement or change to be incorporated in the existing.

•Database objects design and normalization, review and implementation.

•Expertise in performance tuning, optimization, data integrity and statistics by using SQL profiler and DB engine tuning advisor.

Environment: Windows 2003, MS SQL Server 2012/2008R2/2005, SQL Server Integration Services (SSIS), VMware, SQL Server Profiler, SQL Loader, Database engine tuning Advisor, BIDS, Upgrade Advisor.

Client: Viitorcloud Technologies, Ahmedabad, India. Feb 2012-May 2014

Role: SQL Server DBA/Developer

Responsibilities:

•Installed SQL Server 2008/2005 on windows 2003 and 2008 servers, applied service packs and security fix for all servers.

•Installation and configuration of SQL Server 2000, 2005,2008r2 on Window 2000/NT,2003 OS.

•Written complex stored procedures and functions according to business requirements.

•Implementing Backups and restoring when necessary.

•Creation and management of Database maintenance plan for various database consistency checks.

•Testing backups to ensure business recovery time objective(RTO).

•Used star schema in designing DataMart’s for creating SSIS ETL packages.

•Extensively working on performance issues like update statistics, Auto Stats.

•Managing of database objects like Tables, views, stored procedures, indexes etc.

•Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.

•Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.

•Implement and manage the clustering environment like Active/Passive and Active/Active.

•Expert in using and implementing DMV's, DMF's, data partitioning, DDL triggers, mirroring, online indexing and managed error handling using try catch Block.

•Reports were developed using Crystal Reports utility.

•Involved in analysis, development and maintenance of backup plan, disaster recovery plan, procedures and strategies using maintenance plans.

•Managing of users including creation/alteration, grant of system/db. Roles and permission on various database objects.

•Used SSIS 2012 to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.

•Designed and Implemented Reports using Business Objects Full Client.

•Designed T-SQL scripts to identify long running queries and blocking sessions.

•Creating monthly transaction report for all sections. Developing of Multi-Lingual Reports using Crystal Reports.

•Developed Backup and Restore scripts for SQL Server 2005.

Environment: MS SQL Server 2008/2005 Windows 2008/2003, Performance tuning, query optimization, T-SQL, RTO, SAN, DTS VB Script, Query Analyzer, SSIS, Enterprise Manager.

Contact this candidate