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 updating with hot fix and service packs.
• 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 to 2008R2.
• Worked on High Availability 2012 Solutions Always On
• Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
• Good at SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption TDE .
• Good Knowledge about the newly added features DATA QUALITY Services, Master Data Services in MSSQL 2012
• Dexterous developer in creating Constraints, Defaults, Tables, Indexes, Views, Stored Procedures, Functions, Triggers and Dynamic SQL queries.
• Expertise in using Temporary Tables, Table Variables, CTEs.
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Experience in logical and physical data modeling of the database in ERWIN and MSVISIO.
• Experience in Normalization, Database design, Performance Analysis and Production Support for very large VLDB and Complex Databases.
• Deployed and Debugged SSIS packages for import, export and bulk insert data with transformations from various data sources.
• Extensively used the XML, FLAT FILE, BULK INSERT AND FILE SYTEM control flow tasks and data flow tasks SSIS.
• Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Extensively used the native tools like index tuning wizard or database tuning advisor, profiler, performance monitor, activity monitor, Event viewer for performance analysis.
• Experience in comprising Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, Updating Statistics.
• Experience in Backing up, restoring the data base manually and also by scheduling the jobs and Maintenance Plans.
• Expert in analyzing the execution plan and index management for better Query Optimization.
• Expertise in Identifying the bottlenecks caused by complex queries using Activity Monitor/SQL Profiler and handling them by implementing better Query Execution plans
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Auditing of database for users transaction, login and database action and removing orphan users
• Worked with a team of business analysts, data architects, application developers, ETL developers and testers.
• Experience in Software Development Life Cycle SDLC , Analyzing and Designing systems using Structured Methodologies ERD, DFD along with extensive knowledge of Relational Database Management Systems with in-depth of T-SQL.
• Actively involved in management of Change Control Requests.
• Excellent Problem Solving Skills, Communication, presentation and interpersonal skills. Strong troubleshooting and organizational skills.

TECHNICAL SKILLS:

PROFESSIONAL SUMMARY:

Confidential

Sr. SQL Server DBA

Responsibilities:

• Installed, managed and administrated the MS SQL Server 2012/08/05 Production and Non Production Servers.
• Setup development, testing and production environment with SQL Server 2012 and 2008 R2 Enterprise edition.
• Handled up to 1.8 TB size database in Active Passive clustered Environment.
• Involved Upgrade and Migration of SQL Server 2005/2008 in placed, side by side to MS SQL Server 2012.
• Worked in huge Replication Environment.
• Configured and worked on Database Mirrored Environments.
• Performed Failover drill tests to check the High Availability during disasters
• Worked on High Availability 2012 Solutions Always On
• Used Red Gate for backups and maintenance jobs which includes updating statistics, database integrity checks
• Day-to-day activities like taking backup or schedule the backups daily for database and transaction log on disk and restore the databases.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Used Bulk insert to load huge tables.
• Worked in setting up the SQL Server configuration settings to resolve various resource allocation memory issues for SQL Server databases and to setup ideal memory, min/max server options
• Developed and created the new database objects including tables, views, index, stored procedures, functions, triggers, advanced queries and also updated statistics
• Modified Stored Procedures and complex T-SQL queries to improve query execution process
• Experience in SQL Server security and maintenance of security objects
• Created Logins, Roles and Proxy accounts with appropriate permissions and maintaining Database Maintenance Plans
• Configured DB mail by creating accounts and profiles.
• Provided On call Production support. Ticketing Tool Remedy was being used
• Implemented partitioning on large table to get the performance.
• Worked extensively on third-party tools like RedGate for backup and restore.
• Used table hints in the queries to avoid locks in the server.
• Created missing indexes on the tables by running Data Base Engine Tuning Adviser.
• Installed and configured MySQL on Linux and Windows environments.
• Finding and solving locks and Deadlocks by using DMV's and DBCC commands.
• Executed and performed Product support and installation documentation

Environment: MS SQL Server 2005, 2008 R2, 2012, Windows 2003 Server, Windows 2008 R2 Server, ERWIN, MS Visual Studio 2010, SSIS Packages, Excel, HTML, Idera, Red Gate.

Confidential

Sr. SQL Server DBA

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.
• 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
• 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 2000/2005 7.0 databases to SQL Server 2005 and then to 2008R2.
• Used SQL Server Upgrade Advisor to analyze SQL server 7.0 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
• 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 2008 R2/2003/2000 Server, Oracle 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.

Confidential

SQL Server DBA

Responsibilities:

• Managed and Administrated the SQL Server 2008/2005/2000 production and Non-production servers.
• Tuned aggressively stored procedures in order to increase the performance with no cost effective.
• Worked as a team following Agile/SCRUM methodology for iterative and incremental development.
• Administered and maintained production/Development servers with more than 2 TB of database size with complex structures.
• Performance metrics reports daily, weekly and monthly.
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
• Installed couple of SQL Server 2005/2008 on cluster environment.
• Integrated SQL server profiler traces with Performance monitor to have better graphical analysis to find system bottlenecks.
• Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2005.
• Expertise in setting up and troubleshooting Database mirroring.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance based on level of fragmentation.
• Extensively working on performance issues like update statistics, Auto Stats.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• 24/7 on call support, created various jobs to check health of the server and to troubleshoot.
• Developed SSIS packages, stored procedures, functions, triggers.
• Tuned servers to the peak for maximum performance by configuring memory and various server level parameters.
• Extensively worked on extraction, transformation and loading of data from various data sources to SQL Server.

Environment: MS SQL-Server 2008/2005, DTS, SQL Diagrams, Erwin, Windows 2000 Server, MS Access, MS Excel, MS Analysis Services, MS Reporting Services, HTML 4.0.

Confidential

SQL DBA

Responsibilities:

• 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.
• 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

Confidential

SQL Engineer

Responsibilities:

• Written T-SQL scripts, Designed and created Databases, tables, views, indexes, stored procedures, functions, triggers, batch jobs, created complex reports using crystal report, error handling mechanism as per the business requirements.
• Handled various requests/issues of users related to applications, production servers and databases.
• Performed daily DB activities on various servers which include Database consistency, Integrity health checks, Index tuning, backup and restore strategies etc.
• Performed the deployment activities in different client place remotely and solved the issues during deployment phase.
• Migrated the databases from various systems SQL Server 2000, Oracle, and MySQL .
• Installed and configured SQL Server 2000, Software, Tools Utilities in Development and Production servers.
• Involved in Requirement Analysis, Design, Development and Testing phase.
• Created DDL and DML commands through command line tools OSQL as well as GUI tools Query Analyzer, Enterprise Manager, Management Studio, etc.
• Managed SQL databases, security, created user accounts / logins for development purpose and implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Used Performance monitor, SQL Profiler and Execution plan to optimize queries and enhance the performance of database servers and to solve long/slow running Queries.
• Involved in optimization fine-tuning , debugging the database objects.
• Visual Source Safe VSS 6.0 Administration.

Environment: Windows Server 2000, MS SQL Server 2000, T-SQL, DTS, Oracle, MySQL, Crystal Report, IIS 6.x, .Net framework, Asp.net, C , XML, VSS