SUMMARY

• 7+ years of experience in Database Administration and Development for very large and complex databases in SQL Server 2012/2008 R2/2008/2005/2000 in OLTP and OLAP environments.
• Expertise in installing MS SQL Server 2000, 2005, 2008 and 2012 updating with latest service packs, hot fixes and security patches.
• Extensively worked on 32 bit, x64 bit clustered and standalone server environments.
• Hands on experience in working with System Center Operations Manager (SCOM) 2007 R2.
• Hands on experience in Migration of SQL Server 2000/2005 to SQL Server 2008 and from sql server 2008 to sqlserver 2012.
• Administered windows server 2003\2008 R2\2012 and managed server level security.
• Proficient in SQL Server 2012\2008 new features like Always on, contained database, Activity Monitor, Filtered Indexes, Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE), Backup compression, Lock escalation and new data types.
• Implementedand monitored different types ofHigh Availability & Disaster Recovery scenarios like Replication models (Snapshot, transactional), Log Shipping,Database Mirroring and Clustering.
• Expertise in Performance Tuning, Index Tuning Wizard, Maintenance, Troubleshooting, Query Optimization, Client/Server connectivity, and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
• Exquisite skills in SSMS - Creating and scheduling jobs, alerts and operators withSQL Server Agent, handling Backup(warm, hot and cold backups)/Recovery of databases, Replication, Linked Servers, Database Maintenance Planning.
• Expertise in resolving locks, deadlocks, handling Isolation level and concurrency effects, detect CPU, I/O, Memory bottlenecks.
• Very good T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Proficient in high level design ofETL, DTSPackagesandSSISPackagesfor integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multipletransformationsprovided bySSISsuch asAggregate,Data Conversion,Conditional Split,Bulk Insert Fuzzy Grouping, Fuzzy Lookup, OLEDB Command andMerge.
• Experience in CreatingReport Subscription,Data Driven Subscription, Report Snapshotsand caching, linked, cascadedandparameterized reports, complex drill down reportsusingSQL Server reporting services (SSRS). Configuring and maintainingReport ManagerandReport Server.
• Created complex DTS Packages for Data Migration and Transformation. Experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2012/2008/2005/2000
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Good understanding withSQLbasedreportingtoolslikeCrystal Reports.
• CreatedLinked ServersbetweenSQL Server & Oracle 9i and 10g. Also createdDTS packagefordata transfer between the two environments.
• Handled numerous Change Management requests on production servers
• Explicitly used Litespeed, Foglight, Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas.
• Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
• Has the ability to work in a fast paced environment, Good team player and can work independently. Helped the database developers on technical issues.

TECHNICAL SKILLS

Operating Systems: Windows Vista/XP/ 95/98/2000/2003/2008/2012, Server 2003, Exchange 2003, Linux, Unix.

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

ETL 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

Data Modeling Tools: Erwin, Red gate, Light speed.

Languages: T-SQL, C/C++,C#, Visual Studio2005/2003, ASP.NET, VB.Net.

Applications: Microsoft Office Suite, Adobe Photoshop, Acrobat Reader/Writer.

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Senior SQL Server DBA

Responsibilities:

• Involved in Administration, Database Design, Performance Analysis, and 24X7 Production Support for Large (VLDB) and Complex Databases up to 3 TB.
• Rich exposure on analyzing bottlenecks and performance issues with large datasets.
• Good troubleshooting skills in production environment.
• Coordinating and training work items with separate teams and production issues to get resolution on time
• Debugging complex and long stored procedures and workflow packages.
• Installed SQL Server 2012/2008/05 on Windows Server Clustered environment.
• Upgraded/Migrated about 250+ servers from SQL Server2008 to SQL Server 2012 databases.
• Administered windows server 2003\2008 R2\2012 and managed server level security.
• Good exposure on sqlserver 2012 always on, contained database features.
• Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
• Performed backup using backup compression and Data compression in SQL Server 2008 on clustered environment and SQL Server 2005 security Audit.
• Hands on experience in working with System Center Operations Manager (SCOM) 2007 R2.
• Created/altered/modified and tuned T-SQL Stored Procedures, Complex Queries, views, tables, and functions on OLTP and OLAP environments like Data warehouse and reporting.
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Managed Security using SQL Logins, Roles and Security Modes for various users.
• Developed Automated Backup jobs and DBCC scripts for databases and transaction logs.
• Responsible for Monitoring and Troubleshooting SQL Jobs, Scheduled Tasks, Disk spaces, error logs and making recommendations for performance improvement in hosted databases which involved index creation, index removal, file group modifications, and scheduling jobs to rebuild/reorg indexes and update statistics.
• Responsible for Application support for front end feeds and Resolved Application connectivity issues like connection time-outs, connection pooling issues and memory leaks.
• Migrated DTS to SSIS packages.
• Designed and developed SSIS packages using different control flow tasks, Transformations and dataflow tasks.
• Created SSIS packages to load robust data from different Heterogeneous data sources like Oracle, DB2 to SQL server.
• Created, deployed and managed reports using SQL Server Reporting Services(SSRS)
• Deployed database objects from development/testing environment to production environment.
• Extensively worked on Profiler, Perfmon, and DTA to tune the databases, servers and query tuning.
• Configured IIS and Report server using Reporting services configuration.
• Worked on MS-DOS BATCH FILE programming and commands.
• Documented Trouble-shooting guide for various issues.

Environment: SQL Server 2012/2008/05/00, Advanced Windows 2012/2008/03 server, SCOM 2007 R2, VSS, BIDS, SQL Profiler, Perfmon, T-SQL, TFS, SQL*Loader, SSIS, SSRS, VB.NET, ASP.NET, C#.NET, TSM, Litespeed, MS- Excel, SQL Mon, MS-DOS

Confidential, TX

Senior SQL Server DBA

Responsibilities:

• Managed and Administrated the SQL Server 2008/05/00 production and Non-production servers.
• Installation of SQL Server 2008/05 on Windows Server Clustered environment.
• Worked on Conceptual, Logical, Physical data modeling and Performance Analysis.
• Handled upto 1.5 TB Size databases with clustered environment.
• Setting up and Monitored transactional replication, Database mirroring on Production, QA and Dev servers.
• Monitored Log shipping/ Transactional Replication and trouble shooting of errors.
• Configured data partitioning/table partitioning on huge tables containing millions of rows for better performance.
• Migrated SQL Server 2000 databases to SQL Server 2005 databases including DTS to SSIS packages.
• Upgraded/Migrated SQL Server 2005/00 databases to SQL Server 2008 databases and mentored Jr.DBAs and other technical staff.
• Used VB code in script Task for developing SSIS packages.
• Designed and developed SSIS packages using different control flow tasks, Transformations and dataflow tasks.
• Created, scheduled database maintenance plan using SSIS Maintenance plan task.
• Configured and deployed SSIS Packages from Test to Production Environments.
• Created, deployed and managed reports using SQL Server Reporting Services(SSRS).
• Developed and deployed OLAP cubes for reporting purpose using SSAS.
• Deployed database objects from development/testing environment to production environment.
• Reviewed stored procs developed by the developers and given recommendations for the code modifications for production.
• Managed Security using SQL Logins, Roles and Security Modes for various users.
• Ensured security logins and database access permissions to users.

Environment: SQL Server 2008/05/00, Advanced Windows 2008/03 server, XML, VSS, BIDS, SQL Profiler, Perfmon, T-SQL, PL/SQL, TFS, SQL*Loader, SSIS, SSRS, SSAS, VB.NET, ASP.NET, C#.NET, VM ware, TSM, Litespeed, ERWIN, ER/studio, Spotlight, Redgate, MS- Excel, SQL Mon

Confidential, Fort Worth, TX

SQL Server DBA

Responsibilities:

• Administrated the SQL Server 2008/2005 and 2000 servers and production, pre-production, non-production databases, Front end Application support and Performance Analysis/tuning.
• Created Documentation, schema designing, ER Diagrams using Erwin and MS Visio and involved in architecture.
• Installation of SQL Server 2008/05 and on Windows Server Clustered environment.
• Handled up to 1.5 TB Size databases with clustered and Log shipping environment.
• Migrated/Consolidated from Two Data centers into one Data center.
• Migrated SQL Server 2000 databases to SQL Server 2005 databases including DTS to SSIS migration and migrated SQL Server 2005 to VMware and SQL to Oracle using SSMA.
• Configured IIS and Report server using Reporting services configuration.
• Developed SSRS custom reports, Ad-hoc reports, sub reports.
• Extensively worked on snapshot and merge replication.
• Extensively worked on Log Shipping and Database Mirroring for 2000 and 2005 Production servers and SQL server 2005 security Audit.
• Used DMVs, DMFs for Identifying missing indexes and Index usage stats, Fragmentation levels of Indexes etc for query/stored procs tuning.
• Managed Security using SQL Logins, Roles and Authentication Modes for various categories of users.
• Involved in configuring table/data partitioning on huge tables for better performance.
• Troubleshooted and resolved Application issues, database performance and deadlocking issues.
• Reviewed and approved stored procs developed by the developers and data modification SQL script for production.
• Resolved database space issues by sizing Table spaces, data files, and log files in Oracle.

Environment: SQL Server 2008/05/00, SQL Profiler, T-SQL, SSIS, SSRS, SSAS, VB.Net, C#.Net, ASP.Net, ERWIN, Litespeed, MS-Excel.

Confidential, Phoenix, AZ

SQL Server DBA

Responsibilities:

• Created all administration tasks of SQL Server and designed database.
• Created and modified procedures, triggers and functions.
• Used System procedures and DBCC commands.
• Active Directory Administration, user logon scripts.
• Implemented various levels of constraints and triggers to preserve long term database consistency and accuracy.
• Created automatically running stored procedures for day-end operation using SQL Server Agent.
• Created DTS packages to export and import data from SQL Server to Access, text files and Excel files.
• Created DTS packages for migration of data from SQL Server to MS Access or Oracle Databases.
• Planned Replication set up for banking software between SQL Server 2000 and local Access database.
• Identified, tested and resolved database performance issues (monitoring and tuning) to ensure data optimization.
• Developed automated backup and DBCC scripts for databases and transaction logs.
• Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statistics and Re-indexing.
• Created and supported complex database schemas.
• Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.

Environment: Windows 2003 server, ASP, XML, MS SQL Server 2000 (Enterprise Manager, Query Analyzer), T-SQL, MS Access, MS Excel, Oracle.

Confidential

Jr.SQL Server DBA

Responsibilities:

• SQL Server 2005 Database Administration.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005
• Deployed and Administrated SQL 2005/2000 Enterprise servers on production environment.
• Involved in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 1.5Terabytes.
• Developed, implement and monitor a large-scale and time-sensitive production loading processes
• Develop and implement replication, archiving and backup and recovery strategies
• 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.
• Expert in Using DMV’s, Performance dash board, Mirroring, database snapshot.
• Worked on Client/Server tools like SQL Server Management Studio to administer SQL Server.
• Evaluated data storage considerations to store databases and transaction logs.
• Created databases using SQL Server Management Studio, Database Wizard and Transact SQL Statements.
• Expertise in trouble shooting of Client connections, viewing error log and applications.
• Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Expert in implementing the snapshot isolation and DDL triggers.
• Implemented Snapshot replication.
• Analyzed long running slow queries and tune the same to optimize application and system performance.
• Used Log shipping for synchronization of database.
• Involved in generating various reports using the SQL Server Reporting Services.

Confidential

SQL Server Developer/DBA

Responsibilities:

• Installation of SQL Server 2000/7on Windows 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.
• Configured and managed merge replication database articles.
• 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 2000/7.0.
• Created Triggers to enforce data and referential integrity.
• Designed and developed Stored Procedures, functions and DTS packages and error handling using T-SQL for SQL Server 2000.
• Created stored procedures/Packages using Pl/SQL programming according to the business requirements.
• Performed Query Optimization by extensive use of Index implementation and Index Tuning Wizard.
• Implemented and maintained industry standards in database management.
• Monitored SQL server performance using profiler, Index tuning advisor for query tuning, stored procs.
• Maintained the database consistency with DBCC commands at regular intervals.
• Ensuring that the backups are running fine for various databases on different servers.
• Dropped and recreated the indexes on tables for performance improvements.

Environment: SQL Server 2000/7.0, Oracle 8i, Informatica, Ms-Access, Windows 2000, Linux, C++, T-SQL, Enterprise Manager, Query Analyzer, SQL Profiler, BCP, OSQL, DTS.