SUMMARY:

• Over 10+ years IT experience as SQL Server Database administrator, especially in tuning and optimization of database, providing 24/7 support of both development and production databases.
• Extensive experience in Database administration, maintenance and support of software systems in significant large and medium sized projects using technologies MS SQL Server 2016/2014/2012/2008 R2/2005/2000, Windows 2012/2008/2003/2000 server.
• Hands - on working experience in Installing, configuring, Patching, upgrading and managing SQL Server 2008-R2/2012/ 2014 and required Service Packs. Proficient in creating maintenance plan to automate backup
• Experience in installing and migrating SQL Database on could technology (AWS and Azure).
• Experience on different version SQL Databases upgradation from 2000,2005 to 2008/2008R2, 2012, 2014 and 2016.
• Expertise in Windows Cluster Management with SQL Server Failover Clustering.
• Experienced on Windows servers Patching.
• Hands-on in in-place and side-side upgrading in all version of SQL server.
• Implemented Database Mirroring with high-performance and high-safety mode.
• Configured and maintain High Availability Techniques like Log shipping, Mirroring, Replication, Clustering (Active/Passive) and Always-on.
• Experience in different BI and reporting related tools.
• Experience in deployed, Upgraded, and maintained SSIS, SSRS, and SSAS in the Production server.
• Experience on VMware servers.
• Experience in alterations, backup/recovery, database restores to test environments on DB2 database.
• Experience in writing T-SQL, Stored Procedures and Functions
• Worked on installs triggers, stored procedures, and business logic.
• Have exposure in RDBMS concepts, database architecture and SQL/T-SQL.
• Experience in Debugging Stored Procedures, triggers and troubleshooting database issues.
• Experience using database tuning adviser to get index recommendation for complex database queries, jobs, check database integrity, reorganize and rebuild indexes.
• Test backups to ensure we can meet the business Recovery Time Objectives (RTO). Experienced in implementing efficient Disaster prevention and Recovery Strategies by creating backup and restore plans according to business RTO and RPO.
• Knowledge on UNIX or Linux system administration.
• Experience on Power shell, VB and .net scripting.
• Hand-on Oracle databases.
• Have exposure on installing and using of Team Foundation Server(TFS).
• Performed administrative activities like creating User logins with appropriate roles, granting and denying login privileges, granting database and application roles to users and groups (SQL Security).
• Involved in automation of administrative tasks like creating jobs, schedules, alerts using SQL Server agent and created database mail using SQL Server database mail configuration.
• Involved in Data Centre Migration and Consolidation Project.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Experience in implementing/troubleshooting all types of Replication Models like Snapshot, Merge and Transactional on basis of business specification.
• Experience handing Batch processes using BCP, SSIS packages, Import & Export wizard.
• Configured and deployed SSIS and SSRS packages from development to the production environment.
• Have exposure to Light Speed and Spotlight as a third-party backup and monitoring tool. Experience using spotlight to troubleshoot database performance issues like blocking, deadlocks and long running queries.
• Worked in an AGILE development team to deliver an end to end support.
• Experience in report building using SQL Server Reporting Services (SSRS). Hands on experience in creating parameterized reports, Drill down, Drill through, Sub reports, Linked reports, Snapshot, Cached, Ad-hoc reports using SSRS.

TECHNICAL SKILLS:

DataBases: MS SQL 2000/2005//2008/2008- R 2/2012/2014/2016, Oracle

Operating systems: Win NT, XP, Win-7, Win-8, Win 8.1, UNIX, Linux

Windows Servers: Windows 2000, 2003, 2008R2, 2012R2

Monitoring Tool: Site Scope, Foglight, Red-gate, SCOM 2007 R2

ETL Tools: SSIS, Informatica, Ab Initio, Oracle Warehouse Builder

Reporting Tools: SSRS, Business Objects, Cognos, Tableau, Micro Strategy

Backup Tools: EMC Avamar, DDBoost, Spotlight, LightSpeed, Redgate

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

Sr. SQL Database Administrator

Responsibilities:

• Installing SQL Server using slipstream and Configuring SQL Server including service pack deployments on both cluster and Standard-alone.
• Upgradations of SQL Server version 2000,2005,2008/2008 r2 to 2012, 2014 and 2016.
• Implemented on in-place and side-side upgradation of SQL Server version 2008/2008 r2 to SQL 2014 and 2016.
• Performed Windows Server Patching.
• Implementing disaster recovery plans such as Log Shipping, mirroring, Replication and Always-on.
• Knowledge on troubleshooting High Availability issues.
• Proficiency and expertise in SQL Server Replication (Transactional, Merge & Snapshot).
• Implemented High Availability Solutions such as SQL Clustering on Windows Failover Cluster.
• Implement Always-on Availability Groups in a 4 node Windows Server Failover Clustering (WSFC) cluster.
• Managing Security (Creating users, logins and roles, granting permissions)
• Experience in implementing SQL server security encryption.
• Performance Monitoring and tuning.
• Performed Data Masking using custom rules defined by security and access management team.
• Developed/maintained SQL Server code (stored procedures, user-defined functions, triggers).
• Involved in build and migration of SQL Server database to AWS.
• Configured database backup on cloud (Azure).
• Worked on migration/deployment SQL server on VMWare environment.
• Experienced on handling and troubleshooting issue on VMWare servers.
• Deployed SSIS packages, SSRS reports on SQL Server using BI, SSMS and ETL jobs.
• Involved in configuring SQL Server Analysis Services.
• Worked on data migration to and from Oracle and MySQL.
• Assisted in database technical design and development T-SQL code reviews.
• Fine-tuned and Monitored SQL Servers in Web based and Transaction intensive environments.
• Extensively worked on Dynamic Management Views (DMV’s).
• Worked with UNIX or Linux system for migration database from Oracle to SQL platform.
• Worked as a SCOM ADMINISTRATOR in this project, had to verify the working of SCOM on application hosted servers, enhance new rules and monitors with which the application functionality is tracked and the health of the servers hosting the application is also known.
• Ensuring Data consistency in the database through DBCC commands.
• Adding users in the Database and granting permissions.
• Creating & Scheduling jobs in Sql server.
• Worked on installs triggers, stored procedures, and business logic.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.
• Configured database between Oracle and SQL.
• Worked on backup encryptions.
• Involved in configuring Team Foundation Server on SQL Server for reporting.
• Experienced in writing VB and PowerShell scripting for running and handling few SQL server related services.
• Created few script using PowerShell as a part of automation.
• Performed Server & Application fine-tuning & troubleshooting.
• Creating Index & managing other objects of Database.
• Automated few jobs that spoke about server state from Database perspective and its performance, majorly used to gauge server state based on Disk Space\Ram\CPU Utilization
• Automated few daily jobs using .net programming.
• Involved in migrating share point from one server to the other.
• Troubleshooting the various Network, Domain, Firewall, and Security related issues concerning to applications hosted on IIS, Terminal Servers and Smart Clients gaining good exposure to Infrastructure and application architecture.
• Was a part of SOX audit team which would analyse user logons and access rites on a quarterly basis.
• Worked on monitoring and tuning of SQL scripts. Created upgrade scripts for production database and supported it.
• Helped Development Team in deploying and testing the application, which uses SQL Server as a database.

Environment: T-SQL, MS SQL Server 2000\2005\2008\2008R2\2012\2014\2016, Windows 2003 Server, Windows 2008 R2 Server, Windows 2012 Server.

Confidential

Sr SQL Database Administrator

Responsibilities:

• Monitored the complete environment for resource utilizations and to avoid any bottlenecks.
• Creating and maintaining various databases on Production and development environments using SQL Server 2008/2012.
• Created jobs to import/ export data obtained from various States to update the GIS servers.
• Installed and configured SQL Server Reporting Services. Installed necessary Service Packs for SQL server 2005.Installed SQL server 2005, 2008 and 2012 on a test environment to be the future production environment. Upgraded legacy 2000 databases to SQL server 2005/2008.
• Involved in Database Backup and recovery.
• Performed Windows and SQL Server Patching.
• Implemented high availability on the various servers using replication/mirroring.
• Tuned databases for better performance using SQL Profiler.
• Created and maintained various logins and managed security based on the required access.
• Implemented and tested the point in time recovery of the production databases.
• Involved in migrating share point from one server to the other.
• Created various jobs to monitor resources on various servers and to mail the necessary information when threshold was reached.
• Implemented high availability and disaster recovery using database mirroring with log shipping and Clustering.
• Experienced in writing VB and PowerShell scripting for running and handling few SQL server related services.
• Created few script using PowerShell as a part of automation.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Loaded the data into another data sources (Oracle, SQL Server) using SSIS.
• Support and administer BI suite SSAS/SSRS/SSIS
• Created various SSIS packages based upon the requirement. Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Created various reports using SSRS. Standardized company reports by implementing SQL Server Reporting Services (SSRS).
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Responsible for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes and fine tuning Stored Procedures).
• Data migration using DTS services across different databases like Oracle, MS access & flat files.
• Contacted various users in gathering the requirements and documented the necessary changes.
• Analysed various backup compression tools available and made the recommendations

Environment: T-SQL, SQL Server 2000/2005/2008 R2/2012 SSRS, SSAS, TCP/IP, SSIS, ETL, DTS, Windows 2005, 2008, Red gate, Spotlight.

Confidential

SQL Database Administrator/Developer

Responsibilities:

• Installed, configured SQL Server for both development and production environment and applied necessary hot fixes.
• Setting up database Backup and Recovery procedures for development and production servers.
• Configured Database Mail Agent for sending Automatic emails on Errors to designated individual.
• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log issues, connectivity issues, security issues etc.
• Identified and resolved the query performance using SQL Profiler and Index tuning wizard.
• Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
• Worked closely with developers to recommend indexes to improve query optimization and performance.
• Configured linked servers to enable the SQL server Database Engine to execute commands against OLE DB data sources outside of the instance of SQL Server.
• Setup, configure and administer Snapshot and Transactional Replication on MS SQL Servers.
• Participated in project team activities prior to release and contributes to documentation requirements consistent with methodology.
• Worked with the transaction processing area to develop both the physical and the logical database administration functions and assists in the development of our processing database and computing environments.
• Participated and worked with Data Center teams on the infrastructure, network and storage issues while defining database maintenance windows.
• Provide off hour support during peak business activity period and during application deployments.
• Fixing Orphaned users through SSIS package.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2005 Integration Services (SSIS)
• Helping application teams in query analyzing and its optimization. Coordinating with Users for downtime and maintain the system 24X7 running.

Environment: SQL Server 7.0, 2005/2008/2008 r2, Windows 2000/2003/2008, SSIS and SSRS

Confidential

SQL Database Administrator/Analyst

Responsibilities:

• Installed, configured SQL Server for both development and production environment and applied necessary hot fixes.
• Migration of SQL Server databases.
• Assisted in database technical design and development T-SQL code reviews.
• Provided production support for business units (including adhoc T-SQL querying, reporting and process monitoring).
• Worked with the development team to program and integrate database features in the web application.
• Developed quantitative analyses and custom models for performance monitoring.
• Documentation for best practices, policies, procedures and standards.
• Developed/maintained SQL Server code (stored procedures, user-defined functions, triggers).
• Worked on SSIS packages (Imports and Exports).
• Managing Security (Creating users, logins and roles, granting permissions).
• Adding users in the Database and granting permissions.
• Scheduling jobs in SQL server.

Environment: Windows Server 2003, MS SQL Server 2000/2005 Enterprise Edition, Enterprise Manager, SSMS, SSIS, DTS, Query Analyzer, SSRS.