SUMMARY

• Around 8 years of professional experience in IT industry as a SQL Database Administrator in windows platforms.
• Experience includes System Analysis, Design and Development and Support of Microsoft SQL Server 2017/2016/ 2014/2012/2008 R 2/2008/2005/2000 on various business domains like Banking, Financial and Health.
• Expertise in installation of MS SQL Server 2017/2016/ 2014/2012/2008 R 2/2008/2005/2000 and updating wif latest Hot fixes, Security Patches, Service Packs.
• Proficiency and expertise in migrating Database from SQL Server 2000/20 R 2/2012/2014/2016/2017 using side by side and in place migrations.
• Experience in SSIS, SSAS and SSRS of MS SQL Server tools.
• Worked to convert the DTS packages over to SSIS in SQL Server.
• Executed data modeling using Erwin data modeling tool.
• Excellent backend skills in creating SQL objects like Tables, T - SQL, Stored Procedures, Views, Indexes, Triggers, user defined data types, Cursors and functions using MS SQL Server 2017/2016/ 2014/2012/2008 R2/2008.
• Hands on experience and outstanding noledge on High availability &Disaster recovery solutions-Log Shipping, Mirroring, Replication and Clustering.
• Worked on fine-tuning databases, created Clustered and Non-Clustered Indexes for tables, identified Fragmentation.
• Implemented "Always on Availability groups" in SQL Server 2012.
• Expert in Data Integrity, Performance Tuning, Query Optimization.
• Experience in regular maintenance activities like Query Tuning, Index rebuild/reorganize log file monitoring, temp Data Bases monitoring, handling blocking, deadlock resolutions, and fragmentation issues.
• Strong in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency TEMPEffects.
• Experience in Database administration activities for DB Security (creating logins, users, roles, and assigning permission to them and implemented the security policies.
• Experience in database upgrades and applying software patches to databases as per application/client requirements.
• Closely worked wif development team to assist them in various problems solving and troubleshooting applications and Database objects like stored procedures, functions, triggers.
• Experience in developing T-SQL (DDL, DML, and DCL) statements.
• Extensively used third party tools like Erwin, Lite Speed, Fog light and Red gate.
• Using DBCC Commands ensuring integrity of the databases.
• Proficiency on design, construction and implementation of Business Intelligence tools (Star schema and snow flake schema).
• Data-Warehouses, OLAP, OLTP, ETL Process (Data Extraction, Transformation layer) wif DTS/SSIS, Data Cleansing, MSSQL Databases, Reporting Services (SSRS) and SSIS.
• Discussed the Data model, data flow and data mapping wif the application development team.
• Provided on-call support 24x7 on a weekly rotational basis.
• TEMPEffective communication, presentation and interpersonal skills and good experience in handling Team as well as end users.

TECHNICAL SKILLS

Databases: MS SQL Server 2000/20 R 2/2012/2014/2016/2017, Oracle 12c.

Database Tools: Query Analyzer, SQL Profiler, Data Transformation Services, Performance Monitor, Tuning advisor, Replication, BIDS (SSIS/SSRS/SSAS)

Operating System: Windows 98, Windows 2000 Advanced Server/Professional, Windows Server 2000/2003/2008/2012/2014.

Languages: PL/SQL, T-SQL, C, C#, Power shell, BIML scripting.

Tools: & Utilities: SQL Trace and SQL Tuning Advisory, SQL plus, ETL, MS- Excel, Visual studio, Erwin data modeler, Power BI, SQL Developer, Toad.

Third party tools: Spot Light, Red gate, Idera, Light speed, Fog Light, SQL sentry

PROFESSIONAL EXPERIENCE

Confidential - Columbus, Ohio

Database Administrator /MSBI Developer

Responsibilities:

• Administrated SQL Server 2017/ 2014/2012/2008 R2/2008 databases in Production, Staging, QA and development environments.
• Upgraded/Migrated SQL Server 2014 to SQL 2017 and migrated SQL databases to Azure SQL database in test and Dev environments.
• Worked on migrating Oracle database to Azure SQL.
• Experience working on converting Oracle functions to SQL function and using in SSIS packages for migrating SQL databases into Azure SQL.
• Communicating TEMPeffectively wif different teams involving Business Analyst, Reporting team and SQL Developers for gathering requirement and working on Data warehouse.
• Data validating prior sending data to production server or creating reports from dimensions and facts tables which are created in Azure.
• Also involved in working on Deploying SSIS packages to Production Server, and scheduling the Jobs and monitoring if the jobs are running as being scheduled.
• Designed and implemented Data Integration and ETL processes wif SSIS packages to make data available for reporting purpose wifin a data warehouse.
• Experience in planning, creation, administration and troubleshooting of Oracle 12c/11g/10g OLTP/OLAP database systems.
• Performed and maintained basic Oracle 12c tasks.
• Responsibilities include the Production and Application Support for the Database and Application Servers.
• Experience on writing queries in SQL Developer (PL/SQL).
• Great experience on working wif long running queries and performance tuning.
• Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting
• Used native tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning.
• Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.
• Designed and implemented Data Integration and ETL processes wif SSIS packages to make data available for reporting purpose wifin a data warehouse.
• Troubleshooting blocking issues, deadlocks using blocker scripts, trace flags and activity monitor.
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Actively involved in regular stand-up and weekly meetings and updating the work progress to the team Lead and Colleagues.
• Involved in Production Support call 24/7 for client.

Environment: MSSQL Server 2017, 2014, 2012, 2008 R2, 2008, T-SQL, SSIS (ETL), SSRS, SSAS, Erwin, PL/SQL Developer, Sales Force, Azure, Power BI, Toad, BIML Scripting

Confidential, Edison, NJ

Senior SQL DBA

Responsibilities:

• Administrated SQL Server 2014/2012/2008 R2/2008databases in Production, Staging, QA and development environments.
• Upgraded/Migrated SQL Server 2008 databases to SQL Server 2008R2/2012 using side by side migration.
• Responsibilities include the Production and Application Support for the Database and Application Servers.
• Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting
• Used native tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning.
• Installing, Configuring and Maintaining SQL Server 2012/2008R bit) on Active/Active Cluster wif latest Service Packs, Hot Fixes.
• Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.
• Configured Always-On wif synchronous and asynchronous secondary replicas.
• Tune slow running queries using SQL Server Profiler.
• Involved in the creation and deployment of the reports using SSRS, SSIS and configuring the SQL Server Reporting Server
• Designed and implemented Data Integration and ETL processes wif SSIS packages to make data available for reporting purpose wifin a data warehouse.
• Implemented and monitored diverse types of High Availability &Disaster Recovery scenarios like Always on Availability Groups, Replication models (Snapshot, transactional), Database Mirroring and Clustering (Local & Geo\Multi Site).
• Troubleshooting blocking issues, deadlocks using blocker scripts, trace flags and activity monitor.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Designed the Database Recovery plan and implemented the Database Mirroring in SQL Server 2012/2008.
• Extensively worked on Log shipping for synchronization of databases for SQL Server High Availability.
• Configured Active- Active, Active- Passive clustering (two node and multi node) on physical and virtual environments.
• Configured Transactional replication from multiple publishers to one subscriber.
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Optimized the database server using DMV’s and DMF’s and performed a code review and tuning for the best performance of the application.
• Strong understanding of MS SharePoint Architecture.
• Good Understanding in Planning, operations, optimization and maintenance SharePoint Farm.
• Transferred data (ETL) to Data ware house Environment using SSIS.
• Provided 24/7 on call support on a weekly rotational basis.

Environment: MS SQL Server 2008/2008R2/2012/2014, SQL Sentry, Service Now, Profiler, Visual Studio Management, Erwin, SSIS, SharePoint.

Confidential - Broadview, IL

Senior SQL DBA

Responsibilities:

• Managing and administering SQL server instances which include2008/2008 R2/2012.
• Migration and up gradation of databases from old versions to SQL Server 2008 R2 and SQL Server 2012.
• Performed database backups and restoration as needed.
• Created SQL jobs for the backups on all the servers using a script.
• Implemented partitioning on large table to get the performance.
• Used table hints in the queries to avoid locks in the server
• Configured and worked on Database Mirrored Environments.
• Involved in configuring Always On availability groups in SQL 2012.
• Created database users same as login as well as different when requested.
• Find and fixed Orphan users during the restoration of the database.
• Created SSIS new packages and modified existed packages.
• Involved in designing cubes in SSAS environment using Snowflake and Star Schemas.
• Upgraded few of the SSIS packages from SQL 2008 to SQL2012.
• Gather requirements and design of data warehouse and data mart entities.
• Created missing indexes on the tables by running Data Base Engine Tuning Adviser.
• Optimized stored procedures to get the optimal performance.
• Created Logins, Roles and Proxy accounts wif appropriate permissions and maintaining Database Maintenance Plans.
• Developed and created the new database objects including tables, views, index, stored procedures, functions, triggers, advanced queries and updated statistics.
• Created Reports through Reporting server (SSRS) accordingly the business requirement.
• Deploy the reports on the servers where users can use.
• Created stored procedures and Functions accordingly the requirement.
• Implemented installation documents for the future .
• Administered SharePoint using the Central Administration, IIS and Windows Power Shell.

Environment: MSSQL Server 2012, 2008 R2, 2008, 2005 and 2000, T-SQL, SSIS (ETL), SSRS, Erwin, Windows 2008 R2 Server, SharePoint.

Confidential, WA

SQL DBA

Responsibilities:

• Managing and administering SQL server instances which include 2005/2008/2008 R2.
• Managing all aspects of physical SQL Server database administration which includes security setup and enforcement, installations, upgrades, patching, troubleshooting and tuning.
• Implement and maintain database security (create and maintain logins, users, roles, assign privileges)
• Configured, monitor and troubleshoot efficient Disaster Recovery Strategies and High availability solutions include Clustering, Log shipping and Database Mirroring.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Successfully maintain peak performance of all primary databases by providing advanced tuning methods, customized scripts.
• Troubleshooting of site issues, DB Performance issues and long running queries.
• MS SQL Server database administration, configure Scheduled Tasks for regular Database Backup and Maintenance Activities.
• Planning, implementation and support of database backup, database recovery and disaster recovery policies of databases in a highly availability environment.
• Expert in Performance Tuning of the Stored Procedures.
• Checking Database Health by using DBCC Commands and DMVS.
• Monitored and modified Performance using execution plans and Index tuning.
• Experience in Database security and integrity planning.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Manage regularly scheduled backups and occasionally a database recovery.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Supports several application and support teams wif numerous on-going projects to create or improve application environments.
• Participating in 24x7 on call primary pager support.

Environment: SQL Server 2000, 2005 and 2008, Windows Server 2000\2003\2008, SQL Sentry, SQL Profiler, Lite Speed Backup software, SSRS, SSIS.

Confidential

SQL DBA

Responsibilities:

• Controlling day to day activities of Production database and troubleshooting the issues.
• Performance tuning operations like Load balancing, Archiving, Indexing, Query optimization, performance monitoring.
• Index Defragmentation by Rebuild/Reorganize of Indexes across all Databases.
• Migrated/Upgraded SQL Server 2000 databases to SQL Server 2005, 2008 databases including DTS to SSIS migration.
• Archive & drop the decommission application related databases, jobs, packages wifout TEMPeffecting other applications to compliance wif bank policies.
• Strong understandings of database schema object management.
• Performance monitoring, Database and SQL tuning.
• Performed database Backups and Recovery, as needed.
• Provided in-depth consulting services in the identification and resolution of database issues in a timely and professional manner.
• Provided support to development team on infrastructure and DBA Support.
• Excellent communication skills, as needed to communicate TEMPeffectively wif different groups.
• Designed and implemented Disaster Recovery sites using Mirroring and Log Shipping.
• Resolved database performance issues, database capacity issues, replication, and performance tuned the stored procedures for optimal efficiency using execution plans, profiler traces and database engine tuning advisor
• Created and implemented best backup, recovery strategies and re-indexing process Online banking servers.
• Performed DBCC and DMV commands to troubleshoot issues related to database performance consistency.
• Developed and assisted in Analysis services cubes, stored procedures, user defined functions, indexes and indexed views.

Environment: SQL Server 2000/2005/2008, T-SQL, Windows 2003/2008 server, Oracle 10g, Power Shell, SSIS.

Confidential

SQL Developer/ DBA

Responsibilities:

• Developed stored procedures, triggers and functions and added/changed tables for data extraction and transformation, and data loading (ETL).
• Created Stored Procedures, User defined functions, Views and Wrote T-SQL codes maintaining query standards for the project.
• Created ER diagrams
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables, added Columns, triggers and Worked on Index tuning, stored Procedure tuning.
• Involved in Optimization and normalization of database and tables.
• Part of team for analyzing and implementing the physical design for database.
• Designing logical and physical database structure to facilitate analysis of data from both operational and customer perspectives.
• Created new database objects like Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.
• Designing and building data load procedures, using MS SQL Server.
• Tune the SQL queries using SQL Profiler.
• Involved in Analysis and tuning complex Queries/Stored Procedures in SQL Server 2000 for faster execution and developed database structures.

Environment: SQL Server 2000, Visual Studio Management, Transact-SQL, Query Analyzer, MS Access and Windows 2003.