SUMMARY

• Over 8+ years of IT experience which includes System Analysis and Design, Development, Support & MS SQL Servers 2000/2005/2008/2008 R2/2012 Production, Development and Testing in Clustered and Standalone Server Environment.
• Experience in installing MS SQL SERVER 2000, 2005, 2008, 2008R2 and 2012 updating with the hot fix and service packs.
• Migrating and new installations of SQL Server on Hyper - V & VMWARE environments and Supporting the SQL Server instances, which are lying on the Windows Hyper-V servers.
• Knowledge on installing and using the new features of SQL 2012.
• Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
• Good at SQL Server 2008 new features like Changed Data Capture (CDC), Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot Isolation, Database Mirroring, Database Snapshot, DDL triggers, try-catch blocks, Online indexing, DMV’s, DMF’s, SQLCMD and dedicated admin connection.
• Experience in analyzing and Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Hands-on experience on Cloud Computing on Microsoft Windows Azure.
• Suggesting the rite hardware for hosting SQL Server on Hyper-V like suggesting the different types of VHD’s supporting Dynamic, Virtual, and Pass through.
• Database administration experience on SQL Azure
• Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, perfmon, activity monitor, Event viewer for performance analysis.
• Experience in administrative activities comprising Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, Updating Statistics.
• Expertise in Configuring and managing Database Mirroring, Log Shipping and Replication.
• Well Knowledge on SQL Server Consolidation & Virtualization (VMWare, Hyper-V)
• Experience in Backing up, restoring the data base manually and by scheduling the jobs and Maintenance Plans.
• Configured Security at ACTIVE DIRECTORY AND SQL SERVER LEVEL by Creating Principals (logins) and Mapping users to roles. (Securables and Permissions).
• Experience in using the DMVS, DMFS, SP PROCS, INFORMATION SCHEMA, and SYSTEM VIEWS AND in built GLOBAL VARIABLES for the instant analysis.
• Dexterous developer in creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors and Dynamic sql queries.
• 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.
• Expertise in analyzing and estimating the Execution Plan for better Query Optimization.
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
• Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
• Deployed and Debugged SSIS packages for import, export and bulk insert data with transformations from various data sources.
• Experience in generating Reports (SSRS) in Business Intelligence Development Studio (BIDS).
• Experience in handling Partitioned cubes in SSAS both in star and snow flake schema.
• Experience in creating CUBES in BIDS with Fact and Dimension Tables.
• Explicitly used third party tools like Litespeed, Foglight and Red gate.
• Created linked servers between Oracle 10g and MS SQL SERVER 2005 and also deployed SSIS packages for data transfer.
• Good knowledge of Oracle Database 10g Administration and Creating pl/sql packages, procedures and functions.
• Capable of scheduling jobs, backup and restore in Oracle 10g using isqlplus(html mode)
• Good knowledge in handling files system in UNIX OS.
• Worked with a team of business analysts, data architects, application developers, ETL developers and testers, My objective was to deliver projects within scope, time and costs while following department standards, methodologies and guidelines
• Involved in all phases of the SDLC (software development life cycle).
• Strong experience in mentoring with team members, documentation and 24/7 on call production support.

TECHNICAL SKILLS

Databases: MS SQL Server Azure/2012/2008R 2/2008/2005/2000 & 7.0, oracle8i.

Programming: Visual Basic 6, Visual Basic 5, C, C++, JAVA, .NET & SQL

Operating System: Windows 2008 R2/2003/2000 Advanced Server, NT & Windows 9x, Linux, VMware (VMware Servers, Work Stations), Microsoft Hyper-V Servers

Other Software: Active X, IIS, Microsoft Transaction Server, VBScripts, HTML, XML, Microsoft Cloud Services (Windows Azure Platform).

Tools: SQL DB Access, Performance Monitor, Backup Utility, SQL LiteSpeed, Visio 2000, Red Gate, Fog Lite, Remedy, VSS, TFS

Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. SQL DBA

Responsibilities:

• Installed and Upgraded from SQL Server 2000, 2005 and R2, 2012.
• Migrated Databases from SQL Server 2000, 2005 and R2, 2012 and SQL 2008r2 to SQL 2012.
• Installed and configured SQL 2012 AlwaysOn Availability Groups.
• Installed and Configured Active-Passive, and AlwaysOn Availability Groups environment as a High availability DR solution.
• Migrating and new installations of SQL Server on Hyper-V & VMWARE environments and Supporting the SQL Server instances, which are lying on the Windows Hyper-V servers.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environments.
• Upgraded SharePoint 2007 to SharePoint 2013 (SQL server 2005 to SQL Server 2012)
• Performing Backup/Restore to/from Legato server (Tape) and Disk
• Tuning queries which are running slow using Profiler and Statistics IO by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Expert in configuring TempDB.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Checking Database Health by using DBCC Commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning.
• Experience in Database security and integrity planning
• Prepared Documentation for the Disaster Recovery plan
• Designed Data Integrator jobs with Error Handling and email notifications.
• Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Routine DBA jobs like Backups and Restores.
• Good experience in data modeling and metadata services.

Environment: MS SQL Server 2012, 2008 R2, 2008, 2005 and 2000, T-SQL, Erwin, ASP.Net 3.0, SSAS, SSIS (ETL), SSRS, SharePoint Server 2007, 2010 and 2013, Windows 2003, 2008 and 2012 Servers.

Confidential, New York, NY

Sr. SQL DBA

Responsibilities:

• Installing and managing SQL Server 2008/2008 R2 server and Service Packs.
• Implemented aliasing same as the Production on the Development servers.
• Monitored Log shipping Servers and generated the reports with Stand by Server.
• Involved in implementing Transactional Replication on Clustered environment.
• Extensively involved in data modeling by using Erwin tool.
• Implemented Linked Servers accordingly the work flow.
• Worked extensively on Optimization and Tuning for increasing Query and Database performance.
• Implemented partitioning on large table to get the performance.
• Tuned stored procedures by using execution plans.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Implemented FTP for transferring files over the servers.
• Created missing indexes on the tables by running Data Base Engine Tuning Adviser.
• Finding and solving locks and Deadlocks by using DMV’s and DBCC commands.
• Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases.
• Configured Policy Based Management on standby servers to maintain consistency.
• Used Change Data Capture to populate external tasks on Financial Tables.
• Used Red gate Tools to compare data, Roll Back and Version Control.
• Created Logins for the users and manage their permissions.
• Created Regular Jobs, Maintenance Jobs and managed the schedules as per the requirement.
• Supported 24/7 on call during week days as well as Weekends.
• Generated the reports so often accordingly to the requirement.
• Application support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.
• Used Bulk insert to load huge tables.
• Written stored procedures and functions and integrated it with the front end application.
• Used table hints in the queries to avoid locks in the server.
• Expert in writing Cursors on the way implementing the business logic.
• Implemented Views and Triggers to keep track of the product purchases.
• Removed expensive operator’s usage in stored procedures and regular statements to increase the database performance.

Environment: MS SQL Server 2005,2008 R2,2012 Windows 2003 Server, Windows 2008 R2 Server, ERWIN, MS Visual Studio 2010, Excel, HTML,JIRA 4.3.

Confidential, Detroit, MI

SQL DBA

Responsibilities:

• Installing, configuring and maintaining SQL Server 2005 and 2008.
• Involved in migrating the SQL server 2005 from SQL 2000.
• Implemented Mirroring with Synchronous mode with automatic failover.
• Tuned complex SQL Queries.
• Provided day-to-day administration tasks like space and log management.
• Responsible for fine tuning of the database, troubleshooting, memory management.
• Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)
• Created reports based on database usage and perform capacity planning.
• Responsible for creating user groups and assigning permissions.
• Developed stored procedures for generating Reports as per management requirement.
• Optimized stored procedures and indexed query using Index Tuning Wizard.
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
• Setup and maintained Linked Servers.
• Solving the Bugs and issues reflected by the Testing team. SQL Server 2005/2000 Database Administration.
• Migrated databases from SQL Server 2000 to SQL Server 2005.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
• Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2005.
• Daily routine Developer/DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Designed and facilitated the implementation of data warehouses required by application systems
• Supported OLAP team to providing data from SQL Servers.
• Assisted with various ad hoc query requests.
• Provided back-end support for functional testing and performance testing.

Environment: MS SQL Server 2000/2005 ETL, DTS, SSIS, Windows 2003 Server, ERWIN, MS Access, Toad, Excel.

Confidential, New York, NY

SQL Server DBA/Developer

Responsibilities:

• SQL Server 2005 Database Administration.
• Installed and configured more than 2GB RAM in SQL Server 2005.
• Performed the migration of SQL Server 2000 to SQL Server 2005.
• Configured the servers on 32 bit and 64 bit clustered and standalone server environments
• Installed and maintained 2-Node (Active-Active) Clustering as a High availability solution.
• Responsible to Monitor and troubleshooting Log Shipping.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Implemented and maintained Database mirroring as a Disaster Recovery Solution.
• Setting up and Monitoredtransactional replication, Database mirroring on Production and QA servers.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services
• Experience in trouble shooting Client connections, viewing error logs and application logs.
• 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.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Experience in implementing and maintaining new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Transferred data (ETL) to Data ware house Environment using SSIS.
• Used Data Partitioning, Snapshot Isolation in SQL Server 2005.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 2.5 TB.
• Expertise in SQL Server Analysis Services.
• Managed VERITAS net backups.
• To analyze long running queries and tune the same to optimize application and system performance.
• Maintaining the database consistency with DBCC at regular intervals.
• Involved in creating and supporting in OLAP Cubes Involved in development activities included hardware and network specification, installation and configuration, and participation in database design, architecture and SQL scripting.

Environment: MS SQL Server 2005, ANSI SQL, SSAS, SSIS, BO XI, Informatica, MS SQL Server Reporting Services 2005 (SSRS), COGNOS, DDL, Erwin, SharePoint Moss Server, ASP.Net, ETL, Erwin, C#.Net, SAP, CSS, Java Script, XML, HTML

Confidential

SQL Developer

Responsibilities:

• Applied Normalization rules in designing the database.
• Created Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints.
• Developed database objects like Tables, views, stored procedures, indexes etc.
• Tuned SQL statements using views and Stored Procedures.
• Implement the connection between the Java and Sql with JDBC.
• Wrote queries in java to retrieve data from SQL server.
• Involved in writing jsp’s to present the SQL information.
• Designed Database objects including tables, procedures, views and triggers on SQL Server Database.
• Rebuilding the indexes at regular intervals for better performance.
• Wrote various stored procedures for the purpose of application development.
• Wrote SQL Scripts to select the data from the source.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Created many complex Stored Procedures and used them in Crystal Reports.

Environment: SQL Server 2000, java1.3 and Windows 2000.