PROFESSIONAL SUMMARY:

• 8+ years of experience with the 32bit, 64 - bit Microsoft SQL Server in Production, Development and Testing in Clustered and Stand - alone Server Environment.
• Experience installing MS SQL SERVER 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016 updating with hot fix and service packs.
• Helping support team to understand the functionality of Solr server by giving KT sessions and documentation
• Experience as SQL Server DBA (2016, 2014, 2012, 2008, 2005, 2000) in Production, Development and Data Warehouse Environments (OLTP and OLAP).
• Domain knowledge in multiple industries, such as Healthcare, Banking, Insurance, Manufacturing and Software. 24/7 on Call Support for Production Database.
• Implemented Side by Side Migration and in-place upgrade of MS SQL SERVER 2000/2005/2008 to 2008R2, 2012 to 2014.
• Experience in Migrating DTS 2008 and 2012 packages to SSIS packages in 2012 and 2014 using Migration Wizard.
• Good at SQL Server 2008 new features like Policy management, Data Compression, Resource Governor, Performance data collector and Transparent Data Encryption (TDE).
• Extensive hands-on experience on 2012/2014and 2016 with MS SQL Server upgrades/migrations and VMWare environments.
• Knowledge On solr In different projects .
• Experience in working with Information Technology Infrastructure Library Processes (ITIL) methodologies and Change controls regards to ITIL Service Management.
• Experience in creating Constraints, Tables, Indexes, Views, Stored Procedures, Functions, Triggers and Dynamic SQL queries.
• Experienced in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS, SSRS, Bulk Insert, BCP, Mirroring and Replication.
• Having experience in backup tools LiteSpeed and RedGate.
• Creating Conceptual/logical/physica l data model level using Erwin tool.
• Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Experience in analyzing Locks, Dead Locks and Handling the Isolation Level.
• Experience in Backing up, restoring the data base manually and using Tivoli Storage manager (TSM) also by scheduling the jobs and Maintenance Plans.
• Extensive experience in implementing High Availability Solutions like Replication, Log shipping, Clustering and Mirroring on physical and virtual machines.
• Extensively worked on Active-Active and Active-Passive Clustering.
• Worked on High Availability 2012 Solutions Always On.
• Deployed and Debugged SSIS packages for import, export and bulk insert data with transformations from various data sources.
• Studied and stayed current on features and functionality of PostgreSQL.
• Scripted VB.net in the script task for data conversions in XML file in SSIS packages.
• Created Packages and Procedures to automatically drop/create indexes for the tables.
• Configured SMTP Server for DB Mail setup and received Alerts for Threshold values.
• Handled multiple SQL Instances on Cluster built on SAN using RAID levels.
• Explicitly used third party tools like Lite Speed, Data Mirror, Fog light and Red gate.
• Auditing of database for user’s transaction, login and removing orphan users.
• Actively involved in SLAs and management of Change Control Requests.
• Strong experience in mentoring with team members, documentation.
• Excellent Problem Solving Skills, Communication, Strong troubleshooting and Organizational skills.

TECHNICAL SKILLS:

Languages: C# ASP. NET, T-SQL, My SQL, VB.NET, HTML, XML, CSS, Java Script

Operating Systems: Windows 95/2000/2003/2008/ XP/VISTA/7, Sun Solaris 9, LINUX, VMware ESX servers, ERP SAP

Databases: Microsoft SQL Server 2014,2012/2008R 2/2008/2005/2000, Oracle 11g/12c, MYSQL, DB2, MS Access

ETL & Reporting Tools: DTS, SSIS, SSRS, SSAS, Crystal Reports

DB Utilities: SQL Server Management Utility, Query Analyzer

Application Software: Visual Studio 2005/2008, Visual Source Safe, TFS, MS Office Suite

Tools: SQL DB Access, Performance Monitor, Backup Utility, Idera, SQL LiteSpeed, Visio 2000, RedGate, FogLite, Erwine 9.5, Data mirror,, PostgreSQL 9.0/9.1.

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Sr. SQL Server DBA

Responsibilities:

• Installation & configuration 2008/2008 R2/2012/2016 Enterprise & Express Editions.
• Working on MS SQL Server 2016, 2012/2008R2/2008/2005 and responsible for installation, configuration and provided 24 X 7 support to all production Servers.
• Security issues dealing related to logins, DB users, application roles and linked Servers.
• Migrated SQL data from SQL Server 2000, 2005 and 2008 to 2012. Resolved the issues after migration of the Database.
• Configuring high availability multi-core solr servers using replication, request handlers, analyzers and tokenizers
• Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases.
• Proactive in updating the latest security patches to database, which are provided by PostgreSQL open source community
• Implementing Load Balancing Replication across the Databases.
• Handled the upgrading, patching and troubleshooting of the PDW APS, as well as user access and creation of new databases, schemas and deployments.
• In-place and side-by-side Migration from SQL Server 2005, 2008 and 2008R2 to 2012.
• Efficiently carried out DBA responsibilities in planning migration activities from DB2 to SQL server and SQL to ORACLE/MY SQL (RDBMS Databases) in migration.
• Build and support Data Sync job on Windows Azure to synchronize data from SQL 2012 databases to SQL Azure.
• Involved in working with Redgate tool for SQL compare & SQL Data compare between the databases and tables.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
• Experience in analyzing Locks, Dead Locks and Handling the Isolation Level.
• Experience in writing automated Test scripts, designing stored procedures.
• Planning for manual failover and Automatic failover for checking the failover test.
• Expert in analyze execution plan and index management for better Query Optimization.
• Extensive experience in implementing High Availability Solutions like Replication, Log shipping, Clustering and Mirroring on physical and VM’s.
• Designed products, offerings and technologies relating to cloud computing and virtualization along with IT engineering teams.
• Created Database Maintenance Plan for the Performance of SQL Server this includes Database Integrity Checks, Update Statistics and Re-indexing.
• Expertize in taking SQL server Backup/Restore using Tivoli storage manager (TSM).
• Taking Database Full Backup, Transaction log backup & differential backup as per backup strategy daily/Weekly Routine.
• Maintained the database consistency with DBCC commands at regular intervals.
• Extensive experience in utilities and tools used for database monitoring (SQL traces, online performance monitors, reports and catalog queries).
• Excellent Communication, Strong troubleshooting and Problem Solving Skills. Able to work with all type of people and Organizational skills.

Environment: SQL Server 2000/2005/2008 /2008 R2, 2012, Oracle 12c, MS-Access, DB2, Windows 2008, T-SQL, HPQC, SSIS, Query Analyzer, SQL Profiler, BCP, DTS.

Confidential, Los Angeles, CA

SQL Server DBA

Responsibilities:

• Installed, configured and maintained SQL server 2008/2012 enterprise Edition.
• Working as a MS SQL Server Administrator and responsible for installation, configuration, tuning and provided 24 X 7 support to all production Servers.
• Strong experienced in all insurances such as Property and Casualty Insurance including Auto, Home and Marine.
• Resolved the issues after migration of the Database. Migrated the SQL 2000, 2005 and 2008 to 2012.
• Expertise in Administration, Database Design, Performance Analysis, Production Support for Large (VLDB) and Complex Databases up to 5 Terabytes.
• Converting DTS packages to SSIS packages.
• Project DBA for database applications. Activities - Installing/configuring SQL server, patching, troubleshooting, performance tuning.
• Transformation of data (Millions of records) to SQL server by SSIS, DTS, BCP.
• Rebuilding the indexes at regular intervals for better performance.
• Hands on experience and outstanding knowledge of High availability SQL Server solutions, including replication and SQL Server clustering.
• Maintaining the database consistency with DBCC at regular intervals.
• Generated Script files of the database changes are made to stored procedures or views.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
• Performance tuning and optimization of Query of SQL server.
• Converted and imported data from an Oracle/DB2 to a SQL Server Database.
• Worked in tune with strategic planning for improving the mapping and data migration.

Environment: SQL Server 2000/2005/2008 Enterprise, Windows Enterprise Server 2003, T-SQL, DB2, VMware, SQL Server Reporting Services and Integration Services.

Confidential, Louisville, KY

SQL Server DBA and Developer

Responsibilities:

• Planned, installed, configured and maintained the SQL Server 2008/2012 in Environment of Active/Active Cluster.
• Implemented and maintained Database mirroring as a Disaster Recovery solution.
• Involved in Migrating data from DB2 to SQL Server and SQL Server to DB2 through import/export and BCP utility.
• Hands on experience as DB2 DBA for mainframes. Provided mentoring services in DB2 DBA, Data Modeling and Development.
• Extensively worked on migrating the databases from SQL Server 2005 to 2008 and also SQL Server 2005 / 2008 to SQL 2008 R2.
• Implemented new features in SQL 2008 like Table Compression & backup compression, SQL Server Auditing, Resource Governor in T-SQL.
• Extensively worked on Profiler, Perfmon, DMVs, DMFs and DB and query tuning.
• Developed SSIS packages, scheduled them as jobs and deployed packages in SQL Server Integration Services.
• Planned and worked on Table Partition setup for rebuild and update statistics.
• Extract, Transform and Load data from heterogeneous data sources to SQL Server using the SSIS Packages.
• Plan, analyze and develop Ad-hoc Reports using the SSRS and Report Manager to support various user requirements.
• Involved in physical storage configuration of SAN with different RAID levels.
• Worked with TDP and TSM tool for backup and recovery and also written SSIS packages for the backup and restores for few applications
• Developed and optimized database structures, stored procedures, DMVs, DDL triggers and user-defined functions.
• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach.

Environment: MS SQL Server 2008R2/2008/05/00, Windows 2008 Server, SSRS, SSAS, SSIS, Microsoft Visual Studio, DB2, MS BI Studio 2008, Fog light.

Confidential, NEW YORK

SQL Server DBA

Responsibilities:

• Install and configure SQL Server Instances and Management tools using SQL Setup.
• Administer SQL Server using Client/Server tools like SQL Server Enterprise Manager and Query Analyzer.
• Create Database Maintenance Plans for the Performance of SQL Server which covering Database Integrity Checks, Update Database Statistics and Re-indexing.
• Complete Back-up and Restore for Disaster Recovery. Manage replication servers.
• Worked on DTS Package, DTS Import/Export for Transferring data from Heterogeneous Databases.
• Experienced in Data Extraction, Transforming and Loading (ETL) using various tools like Data Transformation Service, SSIS, SSRS, Insert, BCP, Mirroring and Replication.
• Data migration (import & export - BCP) from Text to SQL Server.
• Used DTS to migrate the tables to the Data Warehouse. Handled Different DSS (Decision Support System) for various applications.
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Recovering the databases from backup in disasters.
• Maintaining the database consistency with DBCC at regular intervals.
• Monitoring SQL server performance using profiler to find performance and dead locks.

Environment: SQL Server 2005/2008, Transact- SQL, Query Analyzer, SQL Profiler, BCP, DTS, MS-ACCESS

Confidential

SQL Server Developer/DBA

Responsibilities:

• Installation of SQL Server 2000/2005 on Windows 2000 environment.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Created Database Maintenance Plan for the Performance of SQL Server this includes Database Integrity Checks, Update Statistics and Re-indexing.
• Developed DTS packages to transfer data from heterogeneous data sources and different files like Flat Files, Spread Sheets to SQL Server.
• Data migration (import & export - BCP) from Text files to SQL Server 2005/2008.
• Created Triggers to enforce data and referential integrity.
• Developing SQL scripts for maintaining administration tasks. Tuned the SQL queries using SQL profile.
• Involved in developing stored procedures, triggers for the application.
• Designed and developed Stored Procedures, functions and DTS packages and error handling using T-SQL for SQL Server 2000, 2008.
• Created stored procedures/Packages using Pl/SQL programming according to the business requirements.
• Performed Query Optimization by use of Index implementation and Tuning Wizard.
• Dropped and recreated the indexes on tables for performance improvements.

Environment: SQL Server 2000/2005/2008, Oracle 9i, Informatica, MS-Access, Windows 2003, T-SQL, Enterprise Manager, Query Analyzer, SQL Profiler, BCP, DTS.