SUMMARY

• Over 8 years of IT experience which includes Experience in SQL Server Database Administration, Design, System analysis, Testing, Development and Support of MS SQL server 2012/2008R 2/2008/2005/2000.
• Manage and maintain database changes in Development, QA, Staging and Production.
• Experience in Installing and configuring SQL Server Active/Active and Active/Passive clusters with multi - instances.
• Implemented Database Mirroring with high-performance and high-safety mode.
• Extensive experience in controlling the user privileges, monitoring the security and Audit issues.
• Extensive experience in creation and maintained of PL/SQL Procedures, Triggers, Cursors, Views, Functions and Packages and created Cluster/Non-Cluster Indexes, join statements for applications
• Experience in Analysis, Design, Development, Testing and Maintenance, Capacity Planning, Performance support of application systems of OLTP and OLAP databases in the client-server, intranet\internet environments.
• Experience in INSTALLING, UPGRADING and MIGRATING databases in and from SQL SERVER 2008\2005\2000.
• Hands on experience in Planning and Scheduling Maintenance Tasks and Scheduling Jobs and Alerts using SQL MAIL.
• Good knowledge on new features DATA COMPRESSION, RESOURSE GOVERNER etc... In SQL SERVER 2008.
• Expert in Disaster Recovery plans by configuring CLUSTERING, LOG-SHIPPING, MIRRORING and REPLICATION.
• Handled up to 1.8 TB databases in Clustered environment with good Physical storage configuration and Optimizing of SAN with different RAID LEVELS.
• Hands on experience in configuring CLUSTERING in ACTIVE-ACTIVE and ACTIVE-PASSIVE nodes.
• Expert in configuring TRANSACTIONAL LOG-SHIPPING for Disaster Recovering Process and for HIGH AVAILABILTY of DATA.
• Expert in configuring DATABASE MIRRORING by placing Physical data storage on RAID LEVEL 10 for better Performance.
• Excellent skills in database Back Up, Restore, Recovery, Updating statistics, Rebuilding and Reorganizing indexes, Defragging Tables, Replication, Linked Servers and Database Maintenance Plan.
• Maintained USER PERMISSIONS, LOGINS and SECURITY Issues. Monitored Event Viewers, SQL Error logs and Log Files Viewer for S/W and H/W errors.
• GOOD TEAM PLAYER, STRONG COMMUNICATION SKILLS AND INTERPERSONAL with SELF-MOTIVATION.

TECHNICAL SKILLS

OPERATING SYSTEMS: WINDOWS 2008 R2/2000/NT, server 2003, Linux, Unix and Exchange 2003.

DATABASES: MS SQL SERVER 2008 R2/2008/05/00, MYSQL, Oracle, MS OFFICE ACCESS 2003/2000/97.

ETL TOOLS: SSAS, SSIS, SSRS and DTS.

THIRD PARTY TOLLS: SOLARWINDS Monitoring, IGNITE 8.0, Tivoli Storage Management, SQL LITESPEED, VERITAS, TOAD, SQL COMPARE, Visual Source Safe and Crystal Reports.

LANGUAGES: T-SQL, C, C++, JAVA SCRIPT, VISUAL STUDIO 2008/2005, ASP.NET, VB.NET.

APPLICATIONS: MS OFFICE SUITE, ADOBE PHOTOSHOP, ACROBAT READER/WRITER.

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr. SQL Server DBA

Responsibilities:

• Upgrading and Migrating SQL Server 2008R2, SQL Server 2012 on WINDOWS 2008/2008 R2 servers, applied service packs and security fixes in Clustered and Standalone environments.
• Configure, patch, test, monitor, and support multiple heterogeneous database instances, maintaining the databases at current release and maintenance levels.
• Experience in Installing and configuring SQL Server Active/Active and Active/Passive clusters
• Configured Transactional replication between primary servers and read only server, with separate Distributor server and experience in troubleshooting replication problems.
• Fixed several SQL Query performance issues by examining execution plans, tuning indexes, creating plan guides, adding hint words.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Troubleshoot Blocking and Deadlocking issues by making appropriate changes to Transaction Isolation levels and the types of locks being held; avoiding keeping transactions open for long durations, breaking large transactions to smaller ones.
• 24 X 7 Production Database On Call Support.
• Involved in Data Center Migration and Consolidation Project
• Designed and populated reporting tables, views and stored procedures.
• SQL Query Performance Tuning, system Performance Analysis, analyzing the Query Execution Plans, Used SQL Profiler for optimizing the store procedure.
• Work with responsible applications personnel, coordinate testing of new releases and upgrades from applications perspective.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Developed SSIS packages to export data from OLTP database to OLAP database.
• Involved in maintenance and configuration of Database Servers to connect with SAN Storage Environment.
• Worked in implementing yearly password changes on the production in updating passwords for SQL Services, replication, Reporting services database connection strings
• Helping Development Team in deploying and testing the application, which uses SQL Server as a database.

Environment: SQL Server 2012, 2008/2008R2, Visual Basic, .net, Windows 2008 data centre/advance server, SQL Server integrated services, SQL Server Reporting Services, Internet Information Server 6, HTML, .Net Framework 2.0, VB.Net.

Confidential, Pittsburgh, PA

SQL DBA

Responsibilities:

• Effectively interacted with Business analyst, technical leads & architects, system sponsors and users to understand the business requirements, system specifications.
• 24/7 Production support to around 300 databases setup on more than 100 database servers in production and same number for development and testing efforts.
• Analyzed 4 Terabytes of database to enhance the performance. Increased the performance by 28%. Fine-tuned their Enterprise data ware house.
• Setting up Multi-Node and Multi-Instance Active-Active Cluster for High Availability.
• Planning of latest SQL Security Patches for SQL 2008 R2/2008/2005 in all environments with minimum customer impact.
• Planning Litespeed Maintenance for disk space savings and setting up backup strategy templates using Avamar Backup Tool.
• Escalation level support for critical applications.
• Capacity Planning and DR Set-up for critical applications. Scheduling quarterly Disaster testing.
• Worked with Gatekeeper coordinator for Shared Server Consolidation for multiple applications with no performance impact.
• Planned SQL Upgrade efforts for migration of application databases from SQL 2000-SQL 2005 to SQL 2008 R2.
• Monitoring databases with BMC Patrol Agents\Net-IQ \Ignite 8 \OEM and creating Knowledge Modules for any failures on servers.
• Installation & Configuration of SQL Server 2008/2008 R2 Enterprise Edition on new DELL Servers.
• Responsible for planning and implementing the Fail-Over Clustering and Database Mirroring to maintain highly reliability and availability.
• Responsible for capacity planning, resource management such memory management, disk management etc. also responsible for back up, recovery and disaster recovery.
• Weekly and daily performance monitoring. Responsible for Data base fine tuning, query optimization, including Query execution plans, SQL Profiler traces, and indexing strategies, Troubleshooting, Transactions and locking issues
• Extensively worked with DTS (Data Transformation Services), BCP, and SQL Server Import/Export Utilities. Migration and transformation of data to different SQL Server
• Executing Database Consistency Checks on routine basis, Placement of Primary & Secondary file groups on partitioned drives for faster access of data
• Creation and management of constraints, indexes, stored procedures, trigger and views, Migration of development databases to production Servers
• Developed complex stored procedures to perform ETL tasks to load data warehouse

Environment: MS SQL Server 2008/2008 R2/2005, IIS, VB.NET, ASP.NET, C#, Windows 2003

Confidential, Bridgewater, NJ

SQL DBA

Responsibilities:

• Installing, configuring and deploying SQL Server 2005 and 2008 in Clustered and non-clustered environment.
• Migrated from SQL Server 2000/2005 to SQL Server 2005/2008.
• Responsible for creating, maintaining and monitoring mirrored servers, configured using Synchronous and asynchronous updates with witness server.
• Created alerts, notifications and emails for system errors, insufficient resources, fatal database errors, hardware errors, alerts, activity logs, error logs to capture any possible errors.
• Used 3rd party tools like Quest Lite Speed in taking the backups to optimize performance and restoring.
• Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
• Monitor database status including CPU, Memory, I/O, Space and dead lock using SQL Server Utilities.
• Running DBCC consistency checks, and fixing data corruption in user databases.
• Used SQL Profiler, Windows Performance Monitor for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Implemented and Monitor the Replication between two sites, support and maintenance of MS SQL Server Transactional Replication.
• Worked on fail over clustering and mirroring.
• Documentation of daily tasks and scripting them.
• Worked in 24X7 production support with a rotation basis.
• Involved in loading the Warehouse databases and performing maintenance tasks on these databases.
• Setup log shipping and troubleshooting log shipping errors when arises.
• Experience in implementing Failover Support for SQL Server with Active/Active Cluster configuration.
• Built SSIS Packages to transfer data in and out of the Extract, Stage and Production Servers.
• Updated the multi-dimensional cube data using SSIS- Import/Export wizard.
• Used SQL Profiler to find badly performing queries and deadlocks.
• Developed SSIS packages to export data from OLTP database to OLAP database.
• Configured and worked on SSRS.
• Created Indexes to speed up the queries and Performed Database Normalization.

Environment: MS SQL Server 2000/2005/2008 , Windows Enterprises 2003/2008 servers, IIS Web server, Toad for SQL Server, Litespeed, JavaScript, CSS, HTML, SSIS, SSRS, NetBackup,C#,VB.Net, ASP.Net.

Confidential, Atlanta, GA

SQL Engineer

Responsibilities:

• DBA Related Tasks:
• Installed, Configured, and Managed SQL Server 2000 and 2005 in development, test, and production environment
• Installed, Configured VM Ware server and System running on VM Ware
• Installed and Configured Operating Systems, Windows Server 2000 Enterprise Edition
• Installed and Configured SQL Server Reporting Services (SSRS)
• Configured and Maintained Replications (Transactional)
• Configured Log Shipping as Standby database from Production database
• Upgraded databases from SQL Server 7.0 to 2000 in testing and production environment
• Applied Patch on Windows Server 2000 Enterprise Edition
• Expertise in database Performance tuning
• Backward & Forward Engineering with data modeling tools mentioned above
• Strong knowledge and working experience in Database Backup, Restore and Point-in-Time Recovery

Environment: SQL Server 2005, SQL Server 2000, T-SQL, Oracle, MS Access, Windows 2000/NT/XP, MS Reporting Services, DB2, Microsoft Visual Source safe

Confidential

SQL DBA

Responsibilities:

• Involved in Installation and configuration of SQL server 2000 on Servers.
• Maintaining User account administration for Different domains.
• Applied patches and service packs to keep the database at current patch level.
• Setup and troubleshoot for Active/Passive Clustering in SQL Server2000.
• Monitor failed and long running MS SQL Server jobs.
• Created Scheduled maintenances and backup procedures to the database as a DR method.
• Involved in Configuration, Administration, and Implementation with Log Shipping mechanism.
• Configured Disaster Recovery solution with Transaction and Merge Replication from Production to Development Server for multiple subscribers with Non-Updatable subscriptions.
• Scheduled Backup/Recovery jobs, creation of Logins, Users, and Permissions.
• Up gradation of existing Servers from SQL Server 7.0 to SQL Server 2000.
• Implemented database standards and naming convention for the database objects.
• Implement and maintain database security.
• Implemented trigger and stored procedures and enforced business rules via checks and constraints.
• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Going through the clients' requirements and coming up with database design and application Architecture.
• Designed new job process, new database maintenance plans, DTS programs and did Performance tuning of the existing processes.
• Data conversions and data loads from various databases and file structures.
• Generated reports using Crystal reports.
• Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.

Environment: SQL Server 2000, DTS, T-SQL, Crystal reports7, Windows 2000 Server.