SUMMARY

• Around 8+ years of Database Administration and Development experience on MS SQL Server 2014/2012/2008 R 2/2008/2005/2000 /7.0 in Very Large Data bases.
• Expertise and Interest include Administration, Database Design, Performance Analysis, configuring more than 2GB ram, highly transactional servers and Production Support for Large (VLDB) and Complex Databases.
• Experience configuring and working with Microsoft SQL server 2005, 2008/R2, 2012, 2014 on VMware/Hyper - V Environment
• Experience in Migrating SQL servers from R2 and 2008R2 to 2012
• Experience on Always on availability groups in SQL 2012.
• Experience on setting-up Windows Fail-Over Clustering and SQL Clustering on Multi Subnet Cluster.
• Extensive experience with configuring high availability and Disaster recovery scenarios like clustered environments, Set up diff topologies in replication, Log- shipping and Mirroring.
• Implemented Transactional Replication as a part of DR solution.
• Worked extensively on Clustering (Active-Active/Active-Passive) and server consolidation.
• Worked with Transparent Encryption, table compression, database compression and merge statements using SQL server
• Migrated from a SQL2008 virtualized Platform to a highly automated, virtualized SQL Hybrid Cloud Platform utilizing the latest compute and storage technology to offer maximum performance, availability and security
• Documented Disaster Recovery plans and participated in DR drills.
• Troubleshooting production issues and raising high availability
• Experience in implementing features of SQL Server 2008 like Policy Based Management, Resource Governor, Data Collector sets and Backup Compression Techniques.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot isolation, Database Mirroring, Database Snapshot, Online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, SQLCMD
• Experience in Creating Cubes using MS SQL Analysis Services. Developed star and snowflake schemas. Working in both MOLAP and HOLAP environments.
• Querying the databases using the Power-shell scripts.
• Experience in working with Agile/SCRUM based product development teams, collect database requirements and provide solutions and recommendations for new schema, infrastructure or architecture.
• Good experience in resolving SQL Server blocking and Dead Lock Issues.
• Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, Index rebuild, reorg, horizontal and vertical partitioning.
• Experience working with server side trace and trace Replay. Also have good knowledge on SQL Distributed Replay.
• Expertise in reading and understanding execution plan and fixing query to execute with low cost using joins like merge, nested loops, hash join etc. depends on scenarios.
• Created effective Backup and Recovery plans based on RPO.
• Experience on Point in time restores to recover data in case of disaster of server.
• Adequate knowledge of ITIL Methodologies in regards to IT Infrastructure Management.
• Thorough Understanding of different RAID levels implementation.
• Experience in configuring & managing Linked Servers for data transfer between SQL Server & other heterogeneous relational databases such as Oracle and DB2.
• Upgraded databases from MS SQL Server 2008 to MS SQL Server 2012/2014, MS SQL Server 2005 to MS SQL Server 2008 and MS SQL Server 2000 to MS SQL Server 2005.
• Expert in extracting from different sources, transforming and loading data using transformation services like data transformation services like Batch processes, Import/Export, SSIS, DTS, BCP and Bulk Insert.
• Experience with using Data Modeling Tools such as Erwin and MS Visio.
• Extensive experience in Capacity Planning, Performance Tuning, Disaster Recovery, Troubleshooting, Backup and Restore Procedures.
• Overall database design thatinvolvescreating normalized databases, user authentication, query tuning, assigning proper indexes, creating stored procedures, functions, triggers and data types.
• Experience in upgrading SQL Server software to new versions and applying Service packs and hot fixes and Unattended Installations.
• Experience in creating Packages, Jobs, sending alerts using SQL Mail and custom extended procedures.
• Experience in using DMV and Dynamic Management Functions (DMF) Of Tables, Triggers, Store Procedure etc. for finding out long running queries.
• Explicitly used third party tools like Lite Speed, Fog light and Red gate.
• Creation and maintenance of Databases, creating Roles and managing user permissions.
• Experience in Troubleshooting and documenting root cause analysis.
• Hands on experience in writing and debugging Stored Procedures, Triggers, Cursors, Complex queries using T-SQL Scripts and Batch files.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Develop and manage reports on SharePoint Server.
• Monitoring Dashboard Reports for Performance Tuning and finding bottleneck in database.
• Worked with Third Party Backup solutions like SQL Lite-speed, Red-Gate, and Commvault for MS SQL Server and data modeling tools like Erwin.
• Provide 24/7 production support for mission critical systems.
• Experience in creating documentation for all the DBA activities.
• Flexible, Enthusiastic and project oriented team player withexcellent communication skills and analytical skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS

Operating Systems: Windows NT/2003/2008R2/2012/2014, Linux, Unix.

Databases: MS SQL Server 2014/2012/2008 R 2/2008/2005/2000, MS Office, Access 97/2000/2003.

ETL and REPORTING Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Integrator, Data transformation services (DTS)

Database Tools: SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio, perfmon counters.

Third Part Tools: Fike Maker Pro, Idera V5.2\7.1\7.2.2, Companion, lite speed, Red gate, VERITAS net backup, Erwin r7, TSM\TDP, Guardium.

Languages: T-SQL, XML, Pearl, Shell

PROFESSIONAL EXPERIENCE

Confidential, Summit, NJ

SQL Server DBA

Responsibilities:

• Managed and Administrated theSQL Server 2014/2012/2008/2005 production and Non-production servers.
• Extensive experience in implementing High availability solutions like Replication (Snapshot and Transactional), Log shipping, Clustering and Mirroring on physical and virtual machines.
• Extensively worked on Active-Active and Active-Passive Clustering.
• Implemented Side by Side Migration and in-place upgrade of MS SQL SERVER 2000/ 2005/2008/2008 R 2/2012/2014.
• Worked on High Availability 2012 Solutions like Always On
• Involved in the migration ofSQL Server 2008 databases to SQL Server 2012.
• Responsible for monitoring and makingrecommendationsforperformance improvementin hosted databases. This involvedindex creation, index removal, index modification, file group modifications, and addingscheduled jobstore-indexandupdate statisticsin databases.
• Evaluated data storage considerations to store databases andtransaction logs. Implemented newT-SQLfeatures added inSQL Server 2008that areData partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE), Data Partitioning, Snapshot Isolation
• Performed daily tasks includingbackupandrestoreby usingSQL Server 2012tools likeSQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• CreatedDatabase Maintenance Plansfor the performance of SQL Server which coversDatabase Integrity checks, update database Statistics and Re-indexing.
• Developed and optimized database structures,stored procedures, Dynamic Management views,DDL triggersanduser-defined functions.
• Identified, tested and resolveddatabase performance issues (monitoring and tuning)to ensuredata optimization.
• Involvedin trouble shooting and fine-tuning of databasesfor itsperformance and concurrency.
• Managed trouble shooting ofClient connections, viewing error log and applications.
• Developedautomated backup and DBCC scriptsfor databases and transaction logs.
• Maintaining the databaseconsistencywithDBCCutility at regular intervals.
• Worked on log shipping for synchronization of database.
• Authenticated logins and validated permissions.
• Writingstored procedures, triggers, and functionsand maintained coding standards.
• Involved indatabase Normalization, logical and physicaldata modelingusingERWIN.
• ManagedVERITAS net backups and Litespeed backups.
• Used SQLProfiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Advisor for index recommendations.
• Transferred data (ETL) toData warehouse Environment using SSIS.
• Design and Development of SSIS Packagesto load the Data from various Databases and Files.
• Worked onDTS, Import and Exportutility, for transferring data.
• Installed, authored, andmanaged reports using SQL Server 2005 Reporting Services
• ConfiguredIIS,Report manager, Report serverand implemented role based security to end users and developed report models for creating Ad-hoc reports using SSRS.
• Worked withApplication Developersto design databases and tables to supportDevelopment activitiesand achieveoptimal efficiency.
• ConfiguredSQL Server settingsusing configuration manager.

Environment: Windows 2003 server, ASP, XML, MS SQL Server 2014/2012, T-SQL, MS Access, MS Excel, Oracle

Confidential, New York City, NY

SQL SERVER DBA

Responsibilities:

• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
• Experience in logical and physical data modeling of the database in ERWIN and MSVISIO.
• Experience in migrating SYBASE database to SQL SERVER by using SQL SERVER MIGRATION ASSISTANT(SSMA)
• Knowledge of SQL Server database architecture (components and processes of the database) for SQL Server 2000, 2005, 2008, 2012, 2014.
• Experience in SQL developing and maintaining Stored Procedures and triggers.
• Experience with Data Warehousing, and ETL (SSIS,SSAS,SSRS & DTS).
• Knowledge of data modeling and database design concepts for OLTP applications and working knowledge of database modeling tools (Erwin, etc.)
• Advanced SQL and T-SQL skills (complex Stored Procedures, triggers, looping constructs etc.
• Ability to do database and SQL performance analysis and make tuning changes.
• Advanced experience with data analysis, data validation and data conversion.
• Experience in converting MS Access databases to MS SQL Server.
• Understanding of SQL Server technology on Windows OS.
• Hands on experience on Oracle e-Business Suite EBS R12/11i Installation, configuration, maintenance troubleshooting and support
• Good knowledge of 11g features as OEM, Data Pump, ASM and Flash back recovery.
• Upgrading Oracle software version from 10g to 11g and 12
• Oracle Enterprise Management Grid Control 12c installation and administration experience.
• Oracle BI reporting services.
• Experience with SQL Server Reporting Services (SSRS) and reporting technologies.
• Web development knowledge.
• Data warehousing design understanding.
• Experience in using Perfmon and found out Memory, disk, IO and network related issues by using the various counters and relate them with the thresh hold values and also having good experience in gathering all the perfmon values, slice and dice them with excel for comparison.
• Maintain ESRI ArcGIS Server GeoSpatial environments including installation, configuration, patching, upgrades, monitoring and backups.
• Plan and perform environment consolidation, reduction, and/or optimization.
• Complete service requests and problems resolution.
• Manage and track GeoSpatial and associated tool license usage and provide long range licensing plans.
• Monitor and maintain ArcSDE performance and tuning as needed.
• Partner with application teams to provide ArcGIS or other GIS application solutions.
• Measures performance of solutions against desired results and recommends improvements.
• Prepare technical documentation
• Experience in creating SQL Server profiler for gathering the information about deadlock graphs and also having experience in adding more profiler parameters to get the information about how SQL Server is behaving.
• Data warehouse ETL design and development skills.
• Knowledge of developing with MS .NET
• Development experience using SQL Server Analysis Services.
• Utilized strong writing skills to draft System Support Documentation as needed
• Experience with full software development life cycle; including technical design and specifications determined from business requirement documents.
• Ability to translate business requirements into a technical design and specifications.
• Self-motivated and highly professional with ability to take on responsibility and also to work independently or within a team environment
• Ability to work under pressure and tight deadlines.
• Ability to take direction, constructive criticism and work to specified deadlines.
• Performed research and analysis for problem resolution using strong written and verbal communication skills to produce System Support Documentation.

Environment: SQL Server 2005/2008/2008 R2/2012, T-SQL, Windows Server 2003/2008/2008 R2, Report Builder 3.0, VSS, Oracle

Confidential, Long Beach, CA

SQL Server DBA

Responsibilities:

• Migrated SQL server 2005 databases into SQL server 2008 and SQL server 2008 databases into SQL server 2012 databases by In-place upgrade process and also used upgrade advisor tool in upgradation process.
• Setting up and Monitored Clustering, transactional replication, Database mirroring on Production environments.
• Migrated DTS packages into SSIS packages.
• Handled up to 2 TB Size databases with clustered and standalone environment
• Configured Transactional replication on migrated server.
• Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Integrated SQL traces with Perfmon log to have better graphical analysis to find system bottlenecks.
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).
• Experience in SQL developing and maintaining Stored Procedures and triggers.
• Experience with Data Warehousing, and ETL (SSIS,SSAS,SSRS & DTS).
• Experience working with MS SCOM and MS SCCM.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
• Used DTS packages to move logins and jobs from one server to another server.
• Used log shipping for synchronization of database.
• Good experience in data modeling and metadata services.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Created Stored Procedures, Triggers, Views and Functions for the Application.
• Extensive testing on the Performance of the Stored Procedures.

Environment: SQL Server 2005/2008/2012, T-SQL, Excel, Windows 2003/2008 Server

Confidential

SQL Server 2005 DBA/Developer

Responsibilities:

• Worked on Client/Server tools like SQL Server Management studio (2005), SQL Server Enterprise Manager (2000) and Query Analyzer to Administer SQL Server.
• Migrated SQL server 2000 databases into SQL server 2005 databases by In-place upgrade process and also used upgrade advisor tool in up-gradation.
• Migrated DTS packages into SSIS packages.
• Handled up to 2 TB Size databases with clustered and stand-alone environment
• Configured Transactional replication on migrated server.
• Wrote the packages using SSIS in SQL2005.
• Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Integrated SQL traces with PerfMon log to have better graphical analysis to find system bottlenecks.
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
• Used DTS packages to move logins and jobs from one server to another server.
• Used log shipping for synchronization of database.
• Good experience in data modeling and metadata services.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Created Stored Procedures, Triggers, Views and Functions for the Application.
• Extensive testing on the Performance of the Stored Procedures.

Environment: TSQL, MS SQL SERVER 2000/2005,SSRS, QUERY ANALYSER, VISUAL STUDIO 2005, VB.NET,C#,WINOWS SERVER 2008,IIS

Confidential

SQL Server Developer/DBA

Responsibilities:

• Installation and configuration of MS SQL Server 2003/2000/7.0
• 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 configured IIS and Worked on Index tuning, stored Procedure tuning.
• Involved in Optimization and normalization of database and tables.
• Involved in conceptual and physical modeling of data using Erwin tool.
• Developed stored procedures, triggers and functions and added/changed tables for data extraction and transformation, and data loading (ETL).
• Part of team for analyzing and implementing the physical design for database.
• Writing complex Stored Procedures to meet the business requirements.
• 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.
• Wrote DTS ActiveX scripts that extract data from database tables and write the data to text files
• Responsible for transferring of database and database objects from Development to Production Server v
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
• Involved in Analysis and tuning complex Queries/Stored Procedures in SQL Server 2000 for faster execution and developed database structures.

Environment: MS SQL Server 2000/2005, T-SQL, Windows NT/2000/ 2003