Sql Server Manager

ROLES:

Senior SQL Server DBA

Oracle Database Admin

Senior SQL Server Developer

SSIS Developer

SSRS Developer

Data Modeler

TOOLS/METHODS:

RedGate

Litespeed

Bladelogic

Nimsoft

RMAN

IDERA Diagnostic

FOGLIGHT

SQL Compare

ERWIN

VISIO

INDUSTRY APPLICATION:

Inter-Dealer Brokers

Banks

Insurance

Healthcare

EDUCATION:

Bachelor Of Engineering

EXPERIENCE SUMMARY

Results-driven software professional with a demonstrated ability to successfully architect and implement complex large-scale, N-tier, distributed, real-time Database Environment. Outstanding track record of driving the project to success through various phases of Software Development Life Cycle. Deep desire to solve problems with persistence and pays meticulous attention to details.

Achievements:

Over (10+) years of IT experience with Database Administration on MS SQL SERVER 2016/2014/2012/2008 R2/2005/2000 in Production, Development and Testing Environments.

Hands-on experience with Installation/Troubleshooting, Managing and Configuration of MS SQL Server 2016/2014/2012/2008 R2/2008/2005 on Windows 2012/2008/2003 server.

Implemented MS SQL Server 2014 on Development and Test Environment

Experience with SQL server 2014 (testing and development for new Environment setup as well migration from SQL 2012)

5+ Years’ experience in Migrating Data Centers from one location to other for SQL

Maintained databases with sizes ranging from Large to Very Large Databases (3-12 terabytes).

Worked on Oracle 11/10 versions and as database administrator managing servers

Strong experience with T-SQL, Stored Procedures, Functions and Excel macros

Excellent Experience in Managing Security through Logins, Users, Permissions, Certificates, Credentials, Encryption Schemes per Company’s Security Policies

Extensive knowledge with Backups, Restoration and Disaster Recovery Planning.

Extensive experience in developing Stored Procedures, Views, Triggers, and Complex Queries on SQL Server 2012/2008 R2.

Experience in Upgrading of SQL Server from version 2005/2008 to SQL Server 2012/2014.

Highly Proficient in migration of Databases, packages and Job activities from MS SQL Server 2008 to MS SQL Server 2012/2014/2016 also migrating the database from development to production, and migrate the data between the databases.

Excellent knowledge of Database concepts such as Entity-Relationship Modeling, Transactional Management, Normalization, Indexes etc.

Extensive experience in Installing, configuring and maintaining SQL Server Active/Active and Active/Passive cluster.

Experience in Constructing Server Baselines and Performance Tuning using tools like Windows System Monitor, SQL Profiler, DMV's, and SQL Query Analyzer and performed Query Optimization.

Hands-on experience with SSIS (SQL server Integrated Services), SSRS (SQL server Reporting Services).

Experience in designing & implementing high availability, clustering, log shipping and/or mirroring standby, large database management, and partitioning.

Experienced in Data Migration between Homogeneous & Heterogeneous Systems using various tools (SQL Server Upgrade Advisor, DTS Package Migration Wizard, Import Export Data, DTS Packages, Bulk Insert, BCP and SSIS).

Automated Database Consistency Checks, Fragmentation checks and Index Reorganization/Rebuilding Operations.

Hands on experience in creating database maintenance plans monitored the jobs by generating alerts to be sent to the operators via email & Pager notifications using SQL Server Agent.

Recommended automated testing tools and continuous Build integration procedures.

Eliminated DB access bottleneck to significantly improve response time to client queries.

TECHNICAL SKILLS:

Windows Server 2012 R2, Windows Server 2008 R2, Windows Server 2003, MS SQL Server 2016/2014/2012/2008 R2/2008/2005/2000, Enterprise Manager, Query Analyzer, Oracle 10g/11i, DTS, MS SQL SSRS, SSAS, SSIS, SQL Profiler, DB2,AIX,ASP.Net 2.0, SQL, PL/SQL, Visual Studio 2008/2005, T-SQL, ERWIN, Database Modeling, Microsoft VISIO, IDERA SQL Diagnostic Manager, SQL LiteSpeed, IDERA, Lumigent Log Explorer, Dell PowerEdge, HP Bladelogic, VMware/Vsphere,.

CHRONOLOGICAL SUMMARY OF EXPERIENCE

Deutsche Bank, Jersey City, NJ Sept 2014 – Present

Senior MS SQL Server DBA

Roles/Responsibilities

24/7 Production support for a Global team including Production UAT and development environments.

High level L3 support for major escalations.

Migration of SQL server from SQL 2000 to SQL 2005 as well SQL 2008 to SQL Server 2012 and SQL Server 2014.

Actively involved in Data Centre relocation/migration from One Data Centre to other

Migrated and moved large size database servers from one location to other

Setting up Always-on Availability Groups for SQL server 2014.

Implementation and support for Clustered environment for Active/Active and Active/Passive cluster on SQL Server 2012.

Migration from Windows 2003 to Windows 2008 R2 for out-of-support windows migration.

Extensive Patching support for yearly Patching cycle for SQL 2014/2012 servers

Patching support using Bladelogic application for multiple Batches.

Experience with setting up Nimsoft Alerting system with Windows and SQL server.

Extensive DHS and VHS support for Windows team for migrations of SQL server.

Worked on SAN based Drives and replication with SRDF and Double take services.

High Level Database Planning and structuring for the organization on a global basis.

Troubleshooting and extensive support for Performance Tuning as well as Error Handling.

Extensive Documentation of Troubleshooting Fixes as well as Processes for the organization.

Working knowledge TCP/IP on the Windows level.

Created Powershell Scripts for Autonomous processes.

Extensive support for DR Tests on a Global level with technologies including Log shipping, Mirroring (with and without certificates) as well as Always-on Availability groups.

Creation and deployment of SSIS (ETL/DTS) packages in production environment.

Configuring SSRS services and providing support for intermediate issues.

Managing High level Security Analysis including but not limited to, logins, users and groups (Domain/Windows/SQL).

Space management on Database and OS level.

Involved in managing Oracle Database Instances and servers

Worked with Vendor supported applications to better manage and troubleshoot issue relating to application.

Extensive work with Microsoft Support team for Sev A critical issues.

Litespeed backups for SQL 2005 and lower configured for the SQL server database servers.

Setting up in-house utility for Maintenance of global SQL servers and deployment over all servers.

Environment: Windows 2016/2012 R2/2008 R2/2003 Server, VMWare/Vsphere, Excel, SAN, MS SQL Server 2016/2014/2012/2008 R2/2005, Oracle 11/10, RMAN, Data guard, Business Intelligence Development Studio, DTS, T-SQL, SSMS, SSIS, SSRS,VB Script Performance Monitor, SQL Profiler, Nimsoft, SRDF, Double-Take, batch file processing, Windows Powershell.

SAFEGUARD PROPERTIES, Brooklyn Heights, Ohio March 2011 – Sept 2014

Senior MS SQL Server/Oracle DBA

Roles/Responsibilities

Extensively worked in OLTP & OLAP environments that include Production, UAT and Development databases in SQL Server.

Provided 24/7 production support on a rotating roster schedule.

Involved in Migrating Data center move from one location to other

Planning and documenting data center migration

Worked extensively on VMware and Virtual instances of MS SQL Server

Worked extensively with writing T-SQL, Stored Procedure, Functions, Views, Triggers and Excel Macros

Implemented SQL Server 2008R2 Active/Active cluster setup on Windows 2008 R2 servers.

Administered Oracle Database Instances and used RMAN for Backup/Recovery

Managing and Administering Oracle database instances

Implemented SQL Server 2012 on Development and QA Environment

Good exposure on Cluster environment servers, to failover/failback (Automatic/Forced) to the cluster nodes.

Configured and Monitored MS SQL Server 2008 R2 in Log Shipping for Disaster Recovery.

Installed and configured SQL Server 2008R2 with Service Packs in UAT, Development & Production environments

Worked with SAN Technology and SAN boxes.

Created Maintenance Plans for checking database integrity, rebuilding indexes and updating statistics.

Designed and implemented high level backups/restore strategies for point in time recovery purposes.

Used Idera SQL Safe backup tool to backup databases.

Used Performance Monitor and SQL Server Profiler to optimize long running queries and improved the performance of the queries.

Worked with different teams to deploy projects to UAT (Testing), Development, and Production environments.

Migrating SQL Server 2005/2008 servers to SQL Server 2012/2014.

Used SQL Server Upgrade Advisor to analyze SQL server 2008/2005 in the process of migration.

Converted DTS Packages to SSIS Packages using DTS Package Migration Wizard

Created solid ETL packages with SSIS using various transformations, sources and destinations

Created packages in SSIS with solid error handling, logging and error re-direction

Used VB Scripting in SSIS transformations

Deployed SSIS packages from one server to another and scheduled the packages for automation

Created heavy duty reports with SSRS, parameterized and drill down reports

Configured SSRS report server

Created packages successfully using SSIS to transfer large volume of Data.

Monitoring SQL Server Instances with IDERA diagnostic Manager

Environment: Windows 2012/2008 R2/2003 Server, Oracle 11/10G, VMWare, Excel, SAN, MS SQL Server 2012/2008 R2/2005/2000/7.0, Business Intelligence Development Studio, DTS, T-SQL, SSMA, IDera SQL Safe backup, IDera Diagnostic Manager and other IDera tools, DTS, SSIS, SSRS,VB Script Performance Monitor, SQL Profiler.

PNC Financial Services, Pittsburgh, Pennsylvania, U.S April 2008 – Feb 2011

MS SQL Server/Oracle DBA

Roles & Responsibility

Installed Standalone and Clustered SQL Server 2005/2008 R2 instances in Production, Development, Test, Staging environments.

Experience in setting up High Availability environments like Active-Active and Active-Passive Clustering.

Managed Oracle Instances on development and production

Created and monitored Database maintenance plans for checking database integrity, data optimization, rebuilding indexes and updating statistics.

Worked extensively on Database space management, performance monitoring and alert management.

Configuring, administration and troubleshooting multiple databases which include databases in QA and Production environments in clustered and stand-alone environments.

Administered the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

Managing Security of SQL Server Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements

Suggested backup strategies, Scheduled backups and Performed restoration operations.

Worked with migrating data from SQL Server 2000 and 2005 to SQL Server 2008.

Created Jobs and scheduled jobs according to the requirements.

Created linked server between SQL servers.

Designed and created ETL process and design in SSIS

Implemented various transformations and created SSIS packages

Created SSRS simple and Drill-down reports depending on client requirement

Dropped and recreated the indexes on tables for performance improvements.

Written complex stored procedures and functions and integrated it with the front end application.

Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler.

Data transfers between various servers using BCP and DTS.

Extensively used SSIS to move data from text files to SQL Server.

Created packages successfully using SSIS to transfer large volume of Data.

Environment: Windows 2008/2003 Server, MS SQL Server 2008/2005/2000, Business Intelligence Development Studio, T-SQL, SSMA, Lite Speed, DTS, SSIS, SSRS, BCP, SQL Profiler.

Johnson & Johnson, Bridgewater, NJ Jan 2006 - Apr 2008

MS SQL Server DBA

Roles and Accomplishments

Provided 24/7 on call production support.

Installed SQL server 2008 and Migrated SQL Server 2005 databases to SQL server 2008 by using Backup-Restore, Detach-Attach, Management Studio Wizards and custom scripts on a test environment to be the future production environment.

Worked on installing, configuring and maintaining of SQL Server 2000 and 2005 on Windows server 2003.

Configured the Log shipping and scheduled jobs to setup log shipping between production servers.

Implemented and tested the point in time recovery of the production databases.

Implemented Transactional Replication between Primary Server and Sub Systems.

Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, and database integrity verification and indexing updates.

Created Users and Roles, and managed security and permission of different SQL Server objects.

Exported and imported data from text files and Excel to SQL Server using bulk copy insert and BCP utility.

Running DBCC consistency check, and fixing data corruption in user databases.

Experience in Tuning Databases using Performance Dashboard.

Developed several reports using SQL server Reporting services (SSRS).

Running Index tuning wizard and rebuilding indexes for faster query response.

Maintained stand by servers using log shipping and replication concepts.

Prepared the coding guideline documents for SQL server developers.

Extensively used SSIS to move data from text files to SQL Server.

Environment: Win 2008 Server, MS SQL Server 2008 R2/2005/2000, Visual Basic 6.0, JavaScript, HTML and Crystal Reports.

Contact this candidate