SUMMARY

• Over 8+ years’ experience in Database Administration, System Analysis, Design, Development and Support of MS SQL Servers 2014, 2012, 2008 R2, 2008, 2005 & 2000 in various domains like Health, Finance, Manufacturing.
• Experience in Database administration activities like Installation, Configuration, Backup & Recovery, Database Security, Data Transformation Services, Database design and Query optimization.
• Experience of VMware in designing, implementation and supporting large VMware infrastructure environments
• Experience in Installing, configuring and maintaining SQL Server Active/Active and Active/Passive cluster in Windows 2008 R2 Datacenter, Windows 2008 R2 Enterprise, Windows Server 2008 Datacenter, Windows 2008 Enterprise, Window 2003 Enterprise Server and Windows 2000 Advanced Server.
• Experience in Upgrading from MS SQL Server 7.0 to MS SQL Server 2000, MS SQL Server 2000 to MS SQL Server 2005, MS SQL Server 2005 to MS SQL Server 2008 and MS SQL Server 2005 to MS SQL Server 2008 R2.
• Experience with SQL Server 2008 DDL/DML Triggers, Database Mirroring, Migration, Upgrading.
• Experience in migration of Data from Excel, Flat file, Oracle to SQL using BCP, DTS and SSIS utilities.
• Successfully tested and implemented Log Shipping Technique used for warm backup solution for MS SQL Server 2000, MS SQL Server 2005 databases and MS SQL Server 2008 R2 used as DR solution.
• Hands on experience in writing and debugging Stored Procedures, Triggers, Complex queries using T - SQL.
• Extensive experience in Capacity planning, Performance Tuning, Disaster Recovery, troubleshooting, backup and restore procedures.
• Experience in configuring and managing Linked Servers, data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
• Extensive knowledge in Tuning SQL queries & improving the performance of the Database.
• Experience in working with Reporting tools like Crystal Reports, SQL Server Reporting services.
• Experience in Larger Database 1 TB and 2TB.
• Creation and maintenance of Databases, creating Roles and managing user permissions.
• Pleasant experience in resolving blocking and Dead Lock Issues by using SQL commands.
• Documented disaster recovery plans and participated in disaster recovery drills.
• Experienced in using Microsoft's in-built tools like SQL Profiler, SQL DTA, Windows Perfmon and DTS for Monitoring, Developing and Tuning MS SQL Server applications.
• Experience in implementing Various RAID technologies.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Good knowledge of Relational Database Management Systems (RDBMS).
• Experience in providing 24x7 Production Support.

TECHNICAL SKILLS

Databases: MS SQL Server 2014, 2012, 2008R2,2008, MS SQL Server 2005, Oracle 11g 2000/7.0, Teradata

Programming: Visual Basic 6, Visual Basic 5, C, C++, Pl/SQL, SQL, T-SQL, HTML, XML

DBA: Database administration of MS SQL Server 2014, 2012,2008,2005,2000

Operating System: Windows 2012/2008/2003 Advanced Server, NT & Windows 9x, Linux

Tools: Backup Utility, VMware, SQL LightSpeed, Visio, Jira (Ticketing Tool)

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

PROFESSIONAL EXPERIENCE

Confidential, Harlingen, TX

Sr. SQL Developer/DBA

Responsibilities:

• Installation and Maintenance of SQL Server 2008R2/2012 on Production and Non-Prod environments.
• Experience in migration of databases from SQL Server 2008 R2 to SQL Server 2012 and updating the compatibility level of each database.
• Upgrading SQL server 2008R2 /2012 and applying Service packs wherever needed.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Creating and Maintaining Database Maintenance Plans. Creating maintenance plan tasks to rebuilding of indexes
• Configured Database Mail and Profile accounts which helps for failure Job notifications.
• Performed database refreshes from prod to non-prod environments.
• Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
• Tune slow running queries using SQL Server Profiler.
• Played a crucial role in creating the Logins of service groups and user groups. Also created the credentials and proxy account from the scratch as per business requirement.
• Involved in Logical and Physical Data Modelling process using MS Visio
• Disaster Recovery Planning, Testing and analyzing, preparing continuous updates of documentation
• Performed bulk of loads from Teradata environment to the SQL server databases using ETL process. Extracted large volumes of data from various data sources and loaded the data into target data sources by performing various kinds of transformations usingSQL Server Integration Services (SSIS).
• Generated Reports using Global Variables, Expressions and Functions for the reports usingSSRS2012.
• Migrated almost 800+ SSIS packages from SQL Server 2008 R2 environment to SQL Server 2012 environment
• Moved the 1200+ RDL’s from 2008R2 Reporting server to 2012 Reporting server and Played a crucial role in making an ad-hoc of data sources and pointing them to the RDL’s and validating them with proper security to access the database from SQL Server.
• Worked with almost 10 teams in moving their DEV, UAT and PROD stuff from Old servers to New servers
• Resolved almost 900+ Jira tickets in the process of migration (SQL Server 2008 R2 to SQL Server 2012)
• Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.
• Mentoring junior team members and creating documents on daily basis and Performing 24*7 on-call productionsupport.
• Changing the configurations and validating all the SSIS jobs from 2008 R2 to 2012 server and moving to appropriate shared drives of the server.

Environment: SQL Server 2012/2008R2, OLTP, OLAP, SSIS, SSRS 2008R2, 2012, Windows Server 2008, Visual studio 2008R2/2010/2012, T-SQL and Excel.

Confidential, Atlanta, GA

Sr. SQL Server DBA

Responsibilities:

• Production DBA for SQL Server Environment with over 50 Production Servers and 100 Development/ Test Servers and more than 1000 Databases.
• Install and configure SQL Server Troubleshooting Performance issues and database issues.
• Install and configure latest Service Packs/Hot Fixes on SQL 2008R2, 2012 and 2014 servers.
• Installed, authored, and managed reports using SQL Server 2008 Reporting Services (SSRS).
• Created SSIS packages to extract data from OLTP sources like MS SQL Server 2012, Text Files, Excel and Access to OLAP systems (SQL Server 2012).
• Create documentation for steps that need to be taken while upgrading the SQL server 2012 to SQL server 2014.
• Design and develop SSIS packages using different control flow tasks, data flow task and data transformations.
• Create and maintain Transactional, and Merge Replication environments.
• Implement Database mirroring. Configured Principal, witness and mirror on the 2008R2 SQL Servers.
• Design and implement comprehensive Backup Plan and Disaster Recovery strategies.
• Extensively worked on setting up Always on Availability Groups on a Multi-subnet failover network. Worked with the Windows team to configure Windows Failover Cluster on which the Always-On setup was done.
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
• Maintain the database consistency by checking with DBCC Utilities at regular intervals.
• Use Resource Governor to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• Maintain Active/ passive and Active/ Active cluster environment with Virtual Machines using Hyper V.
• Used DMVS, DMFS, and SP PROCS for the instant analysis.
• Implement Asynchronous mode for Database mirroring in Staging Environment.
• Use Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers and uptime in production environment.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Understanding the OLAP processing for changing and maintaining multi dimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes.
• Developed data conversion procedures in PL/SQL. Involved in maintaining batch processing PL/SQL procedures for data extraction for feed creation.
• Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
• Implemented partitioning for both tables and Indexes
• Used Online Indexing and online Restoring in SQL Server 2008.
• Applied changes on Production through Change management after thoroughly testing on development servers.
• Successfully negotiated significant cost reductions with various vendors and utilities
• Experience in migration of databases from SQL Server 2012 to SQL Server 2014.
• Involved in normalization of the Database in OLTP.

Environment: SQL Server 2014/2012, OLTP, PL/SQL, OLAP, SSIS, SSRS 2008R2, 2012, 2014 Windows Server 2008, VS 2010/2012, T-SQL, and Excel.

Confidential, Oklahoma City, OK

SQL Server DBA

Responsibilities:

• Responsible for Data mapping and data dictionary document from Staging/Data warehouse/Report-Data mart.
• Used UML to create the Windows system client application which is used to interface with custom Web services.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Created Tabular reports, Cross Tabs, Drill down, Charts, Functions and Maps using SSRS.
• Experience configuring and working Microsoft SQL server 2008, Microsoft SQL Server 2005 on VMware Environment and maintaining threshold values, baselines and monitoring in Perfmon.
• Created SSIS package to extract, transform and load data into the Data warehouse and Report-Data mart.
• Created SSIS package to load data from Flat File to Flat File and Flat File to Data warehouse and Report-Data mart using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Experienced working with Trillium Software to create data profiling report for business user to validate business requirements and data quality.
• Experience in migration of databases from SQL Server 2008 R2 to SQL Server 2012.
• Implemented SQL Server Clustering on VM Ware.
• Created persistence lookup (reference data) using SSIS cache for optimal performance.
• Created VB.Net Script for Data Flow and Error Handling using Script component in SSIS.
• Created complex store procedure for handling late arrival scenarios using set base update.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Sound Experience and understanding of SSRS, OLAP and OLTP cube, Data mining and Architecture.
• Writing validation packages using PL/SQL and tuning them for performance.
• Created complex script to load operational data to Support Direct Mail and Email Campaigns.
• Developed XML objects using SQL Server XML features such as RAW, AUTO, and EXPLICIT modes.
• Defined referential relationships with the measure groups and fact tables.
• Implemented perspectives, partitions, aggregations, roles, calculated members, calculated measures.
• Migrated DTS packages from SQL Server and scheduled their execution time.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Created/Updated Stored Procedures, Triggers, Functions, Cursor, Views, and Indexes with extensive use of T-SQL.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server.
• Developed reports using business object such as crystal reports and SSRS.
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Responsible for maintaining documentation for ETL mappings and business logic.

Environment: Microsoft SQL Server 2012/2008 R2, PL/SQL, SSIS, SSRS, BIDS, T-SQL, OLAP, OLTP, PL/SQL, Crystal Reporting Services v10, VMware, Office 2003.

Confidential -Virginia Beach, VA

SQL Server DBA

Responsibilities:

• As a Production and development support DBA responsible for maintaining SQL Servers database servers in production, Development and QA Environments.
• Installed SQL Server 2008 R2 and SQL Server 2005 on windows 2008 R2 and 2003 servers, applied service packs and security fix for all servers.
• Performed installation of SQL Enterprise bit version on Windows 2003, 2008 servers and VM ware servers on Enterprise systems of Clustered and standalone servers in enterprise data centres. Patch applications.
• Implemented Failover clustering for Active/Active and Active/Passive for HA.
• Managed SQL Server Clusters in a SAN environment.
• Implemented Database Mirroring on SQL Server 2008 environments for DR/HA.
• Configured and maintained Log shipping architecture to provide backup server solution for 4 environments in a DR. Managed and Administered database in SCOM.
• Managed all Publisher, Distributor and Subscriber database environments for the replication.
• Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries.
• Upgraded server from MS SQL Server 2005 to MS SQL Server 2008.
• Implemented Database Mirroring on SQL Server 2008 environments.
• Installed, configured and maintained MS SQL Fail over clustering to provide server high availability solution for 6 different environments.
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Created the standard documents for Disaster recovery testing and implemented the documents.
• Experienced with database sizing and capacity planning for production servers.
• Experienced with creating logical and physical database design for development projects.
• Experienced with improving SQL Server using windows performance monitor to improve the server performance.
• Created the DTS, SSIS packages to import the data from MS Access and Oracle server to SQL Servers. Created extensive reports using SSRS (Tabular, Matrix).
• Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle). Scheduled package execution in SSIS.
• Created the backup schedule for production, test and development servers.
• Worked with Developers to create database schema changes and database restore requests.
• Involved in restore operations to refresh the data from production to test servers.
• Experienced in troubleshooting production servers and fixed the user and application issues.

Environment: MS SQL Server 2008/2005/2000 , SSIS, SSRS, SSAS, Windows Server 2008, 2003, VMware.

Confidential - Minneapolis, MN

SQL Server DBA

Responsibilities:

• Administrated and Managed SQL Server databases in Production, Staging, QA and development environments.
• Responsibilities include the Production and Application Support for the Database and Application Servers.
• Involved in implementation of Always on Availability Group as a High Availability solution on SQL Server 2012.
• Experience in migration of databases from SQL Server 2005 to SQL Server 2008.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Resolving performance issues using DMVs (Dynamic Management Views).
• Used native monitoring tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning.
• Installing, Configuring and Maintaining SQL Server (64 bit) on Active/Active Cluster with latest Service Packs, Hot Fixes.
• Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.
• Troubleshooting blocking issues, deadlocks using trace flags and activity monitor.
• Extensively worked on Log shipping for synchronization of databases for SQL Server High Availability.
• Implemented new features in SQL Server 2008 like Policy based Management, Table Compression, Backup Compression, SQL Server Auditing and Resource Governor.
• Performed data partitioning for efficient management of database tables and indexes.
• Extensively working on performance issues like update statistics, Auto Stats.
• Involved in Change Data Capture process.
• Participated in the designing and development of software using agile development practices.
• Involved in Analysis, Development and Maintenance of Backup Plan, Disaster Recovery Plan, Procedures and Strategies using Maintenance Plans.

Environment: MS SQL Server 2005/2008 R2, Windows 2003 Server, windows 2008 R2 Server, MS Visual Studio 2010.

Confidential

SQL Server Developer

Responsibilities:

• Involved in Administering MS SQL Server, performing day-to-day tasks such as Database tuning by checking indexes and modifying procedures, creating users, assigning roles, etc.
• Gathered the requirement from the client and translated the business details into Technical design.
• Worked on Performance tuning servers, stored procedures, queries, index tuning and query optimization using SQL Server Profiler, NT Performance monitor, Query Analyzer.
• Involved in utilizing PL/SQL, T-SQL and Visual Basic Programming to write program units for conversions.
• Involved in Data Mapping, writing stored procedures for conversion and performing quality testing before the sign off.
• Setting up security, creating groups, user defined roles, logins, granting permissions.
• Planned and implemented various SQL, T-SQL statements, stored procedures and triggers according to the requirements of the projects for the OLTP database systems.
• Involved in writing T-SQL programming to implement stored procedures and Functions for different tasks.
• Worked on DTS, Import & Export Utility, BCP Utility and Replication tool for transferring data.
• Worked on Maintenance, installation, performance monitoring and tuning.

Environment: MS SQL Server 2005/2008, T-SQL, MS Access 97/2000, MS Visual Studio Windows NT.

Confidential

SQL Server Developer

Responsibilities:

• Creating logins, groups, users, roles, database devices, databases, mirroring devices, checking for database consistency, fixing DBCC errors, monitoring error logs, database space allocations, transaction log space allocations, fine tuning SQL performance.
• Writing stored procedures and DTS packages for maintenance tasks in Production environment.
• Created Alerts and Notifications for system errors, insufficient resources, fatal database errors, hardware errors, security breach, etc.
• Performance tuning of the SQL 2000 servers to reduce I/O and Memory contentions.
• Reviewed and offered recommendations for Database system configurations, responsible for tuning data, indexes, and queries as well as providing assistance on these areas to development teams.
• Troubleshoot SQL Server performance issues for internal and external customers.
• Deployed the SSIS Packages and created jobs for efficient running of the packages. Import/export packages.
• Monitored and tune databases, indexes, stored procedures and Server Performance using Performance Monitoring tools for Microsoft SQL Server 2000.
• Involved in scheduling, creating snapshots and subscriptions for the reports (SSRS).
• Export or Import data from other data sources like flat files using Import/Export of DTS
• Recovering the databases from backup in disasters

Environment: SQL Server 2005, Windows 2000, SQL Profiler, SQL Profiler