SUMMARY

• 7+ years of IT experience and extensive experience in MS - SQL Server Development and Administration including Design and implementation of Distributed/ Replicated Databases, planning/ implementing backup/ recovery strategies and Performance tuning.
• Experience in Database Administration, Supporting, MS SQL Server 2000/2005/2008/2012 Production/ Replication/Mirroring & Cluster Server Environments.
• Expert in data migration from MS SQL Server, including Replication and clustered SQL Servers.
• Experience in MS SQL Server Installation, Performance Tuning, Client Server Connectivity, Building Servers, Troubleshooting, Clustering, Query optimization, back-up/recovery, running Database Consistency Checks using DBCC and Troubleshooting on large databases, maintaining and supporting, monitoring production and test environments.
• Experience in Upgrading, Service Packs and Migrating SQL Server 2005 databases to SQL Server 2008.
• Experience on SQL Server 2005/2008 tools like SQL Server Management Studio (SSMS), SQL Server Profiler, SQL Server Agent, Execution Plan, Performance monitor, DBCC commands and troubleshooting and SQL Server Surface Area Configuration, Database Engine Tuning Advisor.
• Managed day-to-day User activities like creating logins, granting permissions, applying security for new users, manually running the jobs etc.
• Expert Knowledge of Integration Services (SSIS), Analysis Services (SSRS) and ProClarity.
• Proficient with T-SQL, SSIS including developing and maintaining packages, developing connectivity to QlikView, SSRS, using SOAP, XML, etc., as well as having prior experience with DTS/SSIS and other ETL tools.
• Creating and managing Data Warehouses Using SQL Server.
• Excellent troubleshooting techniques and experience with Replication, Migration and DTS
• Automating the Database Maintenance tasks by creating Jobs and Alerts using the Database Mail and SQL Server Agent
• Experience in data migration from existing databases to remote data centers.
• Intensive experience in monitoring/tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
• Expertise in developing drill-through, drilldown reports using SQL Server 2008/12 Reporting Services (SSRS)
• Experience in working with 24/7 production Environment with thorough understanding of Standard Operation Procedures (SOP) and Service Level Agreements (SLA).
• Expert in using different Transformation tools like SSIS, DTS packages, BCP, DTEXEC, DTUTIL and BULKINSERT.
• Involved in design and development of DTS and SSIS packages to load and process the data from Oracle, Excel, Access and flat file feeds to SQL Server and vice versa.
• Expert at Dimensional Modeling and ETL design
• Worked Clustering environment and configures SQL server cluster groups as a High Availability Solutions.
• Experience in Installation of SSRS 2005/2008/2012. Hands on generating different types of Reports using SQL Server Reporting Services (SSRS)
• Experience in performance tuning of very complex SQL statements and procedures using show plan.
• Expert in performing database consistency checks and planning and scheduling, Backup & Recovery.
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional
• Knowledge in Third party tools like TOAD, Lite Speed, Auto Sys and Fog light.
• Self-motivated, creative team player with effective communication and Leadership qualities.

TECHNICAL SKILLS

Programming Languages: T-SQL, PL/SQL, C, C++,C#.

Application Software: SQL Server 2000/2005/2008/2012 , MS Access, Oracle

DB Utilities: SQL Server Management Utilities, Query Analyzer.

GUI: DTS Import/Export, SQL Server Integration Services.

Reporting: MS Access, Excel, MS SQL Server Reporting Services 2000/2005, SSRS, and SSMS, QlikView, SOAP.

ETL Tools: SSIS, DTS

Application Software: Microsoft Office, macros

Change Management Tool: Visual Source Safe (VSS), Team Foundation Server (TFS)

Operating Systems: Windows Server 2000/2003, Windows NT 4.0Windows XP/98/95, MS DOS, Linux.

Third Party Tools: Lite Speed, Performance Dashboard, TOAD, Fog light.

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OH

Sr. SQL DBA

Responsibilities:

• Installing SQL Server 2012 and administration of nearly 120+ servers ensuring zero downtime.
• Principal responsibility is to implement, support, maintain, monitor & tune highly available and clustered database systems.
• Manage Bulk Inserts, BCP. Script batches. Create and maintain SSIS packages (for data transformation).
• Managed 120+ SQL servers including Prod, Dev and QA.
• Worked with 1.5 Terabytes of Data with over 3000 databases.
• Planning the location of Data, Index, and Transaction log files on the disk.
• Post deployment Installations on SQL 2012 servers on Windows 2008 servers.
• Migrated Databases from SQL 2008 to SQL 2012.
• Manage SSRS subscriptions and security, Set cube processing
• Installed, configured and managed MS SQL 2008 and 2012 fail over Clustering for production servers on 64 bit platforms to provide high availability.
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views.
• Involved in General Database Administration, Query Performance tuning, and validated some of the existing schema.
• Expert in performing multiple SSIS packages migration from SQL server 2005 to SQL server 2008R2.
• Extensively worked on SSIS for data manipulation and data extraction, ETL Load. Created extensive reports using SSRS (Tabular, Matrix).
• Data conversions. DB Modeling. Create ETL processes & OLAP.
• Used SSIS, Import/Export to Copy, move Data from one server to another, Excel to SQL Server
• Extensive knowledge in Data Modelling and deploying ETL packages using, DTS, SSIS for accessing heterogeneous data, data cleansing and auditing
• Actively involved in data warehousing of the XML onto SQL SERVER 20012.
• Created Transactional Replication, Pull Subscription and defined editions to transfer data from branch to head office and vice versa.
• Involved in Creation of Dimensions using STAR Schema
• Generating complex T-SQL procedures and transactions for programming purposes. Setting database connection strings, modifying ASP pages.
• Installed and configured 2-node Cluster Configuration (Active/Passive) in SQL Server 2005/2008/2008 R2
• Thorough understanding of standard SOP’s, SLA’s and change control management process.
• Extensively used Remedy Ticketing and CAMS (internal application) for change requests.
• Generated Performance analysis reports for all the prod servers on a weekly basis using third party tool Quest Fog Light.
• Experience with third party tools like Fog Light and Veritas Netbackup.
• Configured 43 Production servers using Foglight monitoring tool.
• Created Linked Servers between SQL server 2008/2012 and Oracle servers in the environment
• Created batch files for Veritas Netbackup and scheduled them with SQL Job for both system and User Databases.
• Modified some of the Jobs which have the steps to truncate backup log for the database which is in simple recovery mode as this option is now not supported in SQL server 2012
• Created and modified stored procedures, triggers, views and indexes to provide best performance.
• Conversion of the legacy systems data into MS SQL server using SSIS packages.
• Designed databases for different projects and resolve database issues.
• Created SSIS / DTS packages to pull data from Oracle and Flat Files.
• Running DBCC consistency checks, and fixing data corruption in user databases.
• Performed Database refreshes from Prod to UAT and Dev servers
• Reviewed and deployed the code provided by developers in Prod and QA servers.
• Responsible for Query optimization and Performance tuning, tuned SQL queries using Show Plans and Execution Plans.
• Experience in using Citrix software application.

Environment: SQL Server 2008/2012, Windows Enterprise Server 2008/2012, SSIS, SSRS, SSMS, Microsoft Visio 2003, Microsoft Integration Services, T-SQL, IIS Web Server, SharePoint, SAN, Query Analyzer, QlikView, SQL-Profiler, Fog light, Citrix application, IIS and Oracle, Sybase.

Confidential, Chicago, IL

Sr. SQL Server DBA/Developer

Responsibilities:

• Responsible for application configuration and migration between development, test, and production environments.
• Primary responsibilities include profiling, performance tuning & redesign, high availability server network and disaster recovery.
• Helping application teams in query analyzing and its optimization. Coordinating with users for downtime and maintain the system 24X7 running
• Involved in designing the logical and physical architecture for database.
• Created new tables wrote stored procedures for application developers and some user defined functions.
• Performed data conversions from flat files into a normalized database structure.
• Created and managed users, roles and groups and handled database security..
• Create new SSIS Packages to extract date from Legacy to SQL Server Objects.
• Installation and configuration of the reporting server.
• Developed connectivity to QlikView, SSRS, using SOAP, XML.
• Modified DTS to SSIS packages to accomplish critical business logic.
• Develop SQL applications, procedures queries, SSIS packages, transactions to support business requirements and applications. Work with developers, support QA, and publish projects to production.
• Migrated SQL server 2005 to SQL Server 2008 in Microsoft Windows Server 2003 R2 Enterprise Edition SP2.
• Installed and administered two node cluster Active/passive on Microsoft Windows Server 2003 R2 Enterprise Edition SP2 on SAN environment
• Migrated DTS packages from SQL Server 2005 to SSIS SQL server 2008.
• Extensively worked on SQL Server Integration Services (SSIS).
• Extensive knowledge in developing and deploying ETL packages using, DTS, Informatica, SSIS for accessing heterogeneous data, data cleansing and auditing
• Expert in Using DMV’s, Performance dash board, Mirroring, database snapshot.
• Solving the Bugs Reflected by the Testing team.
• Create Reporting Data-base by MS Reporting Services.
• Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Oracle and Text format data) to SQL Server.
• Designed data models using Erwin.
• Data migration (import & export - BCP) from Text to SQL Server.
• Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and Networking)
• Rebuilding the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• 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.
• 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.
• Expert in implementing the snapshot isolation and DDL triggers.
• 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.
• Implemented in new T-SQL features added in SQL Server 2008 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• SQL 2005, 2008 - Performed installation of SQL Enterprise bit version on Windows 2003 servers on Enterprise systems of clustered and standalone HP servers in enterprise Data Centers. Patch applications.

Environment: SQL Server 2005/2008 Enterprise, SSIS, SSRS, SSMS, IIS Web Server, SharePoint, SAN, Windows Enterprise Server 2003,IIS 6.0, Qlikview, .NET, SAN, Microsoft Visio 2003, SFTP, Microsoft Integration Services, IIS and Oracle, Sybase.

Confidential, Lake City, UT

Sr. SQL server DBA

Responsibilities:

• Installation, configuration of MS SQL Server 2000, 2005, 2008 for development and testing purpose.
• Migration of SQL server 2000 to SQL server 2005 and monitoring and solving the issues after migration.
• Migrated and dealt with 2 Terabytes of Data.
• Setup, configure and monitoring Transaction Replication, snapshot Replication on remote servers.
• Created and monitored database maintenance plans for checking database integrity
• Creating databases, logins and Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server’s logins (Windows and SQL Accounts).
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Created DTS packages to export and import data from SQL SERVER to Access, text and EXCEL files.
• Responsible for database backups & restoration and scheduling backup strategies.
• Implemented Disaster Recovery Plan using Log shipping, Mirroring and Replication.
• Running Trace from the Profiler to trouble shoot database and running DBCC consistency checks for other database maintenance aspects.
• Planning, implementing and troubleshooting Snapshot and Transaction Replication.
• Prepared Estimates for Database, table size growth.
• Worked with SQL Server Reporting Services (SSRS), implemented report builder to allow customers build their report.
• Generated reports using SQL server report manager and published as PDF formats.
• Created report models for Report Builder and managed reports using Report manager.
• Migrated report system from a custom Crystal Reports system to SQL server 2005 Report Services.
• Responsible to bring the awareness of the importance and techniques involved in DB tuning and Performance, to the developers.
• Implemented Transactional Replication for Real time Reports (Database Server as Publisher and Reporting Server as Subscriber).
• Expertise in Security Issues such as creation and granting permissions on various Objects.
• Involved in migration of SQL Server Cluster.
• Monitoring the event logs and server error logs for troubleshooting.
• Created and modified stored procedures, triggers, views and indexes to provide best performance.
• Performance tuning, finding the CPU Bottlenecks, SQL Server Bottlenecks.

Environment: T-SQL, Query Analyzer, SQL-Profiler, SQL-Agent, Windows 2000, SQL Navigator. SQL Server 2000/2005 Enterprise Edition, Windows 2000 advance server, SAN, IIS Web Server, Crystal Report 11.0 SQL Server Reporting services (SSRS) SQL Server Management Studio (SSMS), IIS and Oracle.

Confidential, Plano, TX

Sr.SQL SERVER DBA

Responsibilities:

• Group sells a wide variety of financial products and solutions through financial advisors (LFA). Installed SQL server 2000 on windows 2000 advanced servers, applied service packs and security fixes.
• Imported Data from text files and excel spread sheet into SQL Server 2000 database using DTS package.
• Setup database mirroring in SQL Server 2005.
• Installed and configured 2-node Cluster Configuration (Active/Passive) in SQL Server 2005.
• Configured transactional replication between primary Server and Read-Only servers with separate distributed servers.
• Created backup strategies and scheduled them for execution.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications
• Configured the database maintenance plans for database optimization.
• Experienced in performance tuning using windows performance monitor and SQL profiler of SQL server
• Creating the users, user groups and maintains the access permissions
• Configured Log shipping server to create stand by environment
• Configured Replication methods like snapshot, transactional replications.
• Worked on DTS packages for transferring data from various data sources like Oracle, MS Access, Excel, *.Txt file, *.CSV files.
• Worked with developers to tune the queries, run scripts and move the database from production to development servers.
• Setting up database backup and recovery procedures for production, quality and development servers
• Developing triggers, stored procedures and enforcing business rules via checks and constraints.
• Daily checks for server includes - Disk Space, Event log, SQL logs, major activities include monitoring logs to ensure jobs are successfully completed.
• Performance tuning and optimization of procedures and queries.
• Worked with SQL server profiler to generate traces

Environment: Windows 2000 Advanced Server, MS SQL Server 2000/2005, ASP 3.0, VB 6.0, SQL Server Integration services(SSIS), MS Access, Excel, SQL Server Management Studio (SSMS), SQL-Server Agent.

Confidential

SQL Developer/DBA

Responsibilities:

• Installation and configuration of SQL Server 2000/7.0 on Window 2000/NT OS.
• Managing of database objects like Tables, views, stored procedures, indexes etc.
• Written complex stored procedures and functions according to business requirements.
• Implementing Backups and restoring when necessary.
• Used BCP utility to publish table output to text files.
• Developed DTS Packages to transfer the data between SQL Server database and files.
• Creation and management of Database maintenance plan for various database consistency checks.
• Developed original system for tracking database objects (tables, views, procedures, etc.) over multiple Sybase servers using Unix Shell Scripting.
• Creating/deleting/modifying user’s login, groups, users, roles, checking for database consistency running DBCC consistency checks, if generated, fixing data corruption in application databases.
• Creating monthly transaction report for all sections. Developing of Multi-Lingual Reports using Crystal Reports
• Designed and Implemented Reports using Business Objects Full Client.
• Reports were developed using Crystal Reports utility.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Worked on monitoring and tuning of SQL scripts. Created upgrade scripts for production database and supported it.
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
• Troubleshooting SQL Server production issues.
• Monitoring database growth, managing Databases, data files, log files.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Extensively Developed SQL scripts for maintaining administration tasks.
• Develop documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.

Environment: SQL Server 2000, Enterprise Manager, Windows 2000, SQL Profiler, DTS, Crystal Reports, Business Objects, T -SQL, BCP, Replication.