SUMMARY:

• 8+ Years of total IT experience including SQL Server Database Administration for very large and complex databases in MS SQL Server 2005/ 2008/2008R 2/2 .
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Implemented "Always On Availability groups " in SQL 2012 on multi - subnet/Geo Cluster environment .
• Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals.
• Expertise in SQL Server Cluster Implementation (Active-Active / Active-Passive).
• Having hands on experience working with HA/DR techniques like Clustering, Mirroring, Log Shipping, & Replication.
• Experience in implementation of SQL Server 2008 new features like Always On Availability Groups (AAG), In-Memory OLTP, Online Index Rebuilds, Central Management Server (CMS)
• Transparent Data Encryption (TDE), User-Defined Server roles.
• Experience on disaster recovery planning and implementing Security Management operations.
• Experience with Storage Area Networks (SAN) and utilizing SanDisk space in a Windows Environment .
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization of Databases and building Referential Integrity Constraints.
• Analyzing and meeting SLAs as per the severity.
• Proficiency and expertise in migrating Database from MS SQL Server 2005/2008/2008 R2/2012/2016 under various process like Backup/Restore; Detach/Attach, import/export etc .
• Experience to recover data in case of disaster of server.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Online Restore, Fast Recovery, Database Snapshot, DDL triggers, Online indexing, DMV’S SQLCMD, T-SQL debugger, CTE, Secure Sockets Layer, certificates, and symmetric /asymmetric key and dedicated admin connection.
• Creating and managing of multiple Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g, 11g with all required accessibility for Data pull through SQL Jobs .
• Worked on fine-tuning databases, created Clustered and Non-Clustered Indexes for tables , identified Fragmentation.
• Experience in creating cubes using MS SQL Analysis Services .
• Worked in OLTP & OLAP environment that includes Production (24x7 ), QA and development databases in SQL Server.
• Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE).
• Experience using SQL Server 2008 features like Policy Based Management , Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Experience and proven understanding of managing database audit events and audit records.
• Expertise in creating, implementing and monitoring Maintenance Plans/SQL Jobs, job scheduling .
• Expertise in Migrating SQL Server 2000 databases into SQL Server 2005 and SQL Server 2008 and also expert in migrating DTS packages to SSIS Packages .
• Experience in using the DMVS, DMFS, INFORMATION SCHEMA, SYSTEM VIEW and in-built Global variables for the instant analysis.
• Administering Database security by creation of SQL logins/users and granting of roles. Implemented Rev Login scripts while creating logins.
• Expert in Data Integrity and Query Optimization and tuning complex queries .
• Expert level skills in creating objects like Tables , Views, Normalization, Indexes, Stored Procedures, Functions, Cursors, Triggers and other SQL joins and query writing using T- SQL statements .
• Involved in Huge data migrations and transfers using utilities like SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Deep understanding of the Data Warehousing SDLC and architecture of ETL, reporting and BI tools .
• Performing Online/Offline database DR Drills.
• Experience in using third party tools like spotlight, TSM, light speed, HTTP Watch, Fiddler, Wireshark.

TECHNICAL SKILLS:

Operating System: Windows 2012R2, 2008R2, 2003SP2, 8.1, 7 Server, Windows 95/98/XP/NT, Linux, Solaris, Unix

Databases: MS SQL Server 2000/ 2005/2008/2008 R 2/ 2012/2014/2016, Oracle 8i,9i, Sybase, Teradata, Cassandra

SQL Server Tools: Management Studio, Business Intelligence Development Studio, Visual Studio 2005, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, Log Shipping, Microsoft Clustering Services (MSCS), PowerShell.

BI Tools: SSRS, SSIS, DTS, PowerPivot, SSAS

Performance Tools:: MS Profiler, SQL profiler, PSSDIAG, DMV s

Scripting: PowerShell 3/2/1, VBScript, Windows Scripting

Monitoring Tools: SCOM, MS MDW, MS PerfMon, Spotlight, Solarwinds DPA

Data Migration: SSIS, BCP, Data Migration, Import/Export Wizard

Programming: : T-SQL, PL/SQL, HTML, HTML5, XML, CSS, C, C++

Backup & Recovery Tools: LiteSpeed 5.2, VERTIAS NetBackup

MS Office Suite: MS Word, MS Excel, MS PowerPoint, MS Visio.

Web Servers: IIS 8.0/7.5/6.0Tomcat.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Senior SQL Server DBA

Responsibilities:

• Installed & configured 64/32bit versions of SQL Server 2016/2014/2012/2008 R2 on Windows 2012 R2/ 2008 R2 servers on Enterprise Systems comprising of Multi Node Failover Clustering Servers.
• Migrated MS SQL Server 2008 R2 to MS SQL Server 2012 R2 across all environments like Dev, Test, Production, and DR environments.
• Upgraded/Rewrote SSIS packages from SQL 2005/2008 to SQL 2012/2014/2016 using Business Intelligence Studio and SSDT.
• Configured Always ON high availability groups on Multi Subnet Servers for High Availability (HA), Scalability of the database resources and Disaster Recovery purposes.
• Good Experience in high availability and recoverability of databases in 24/7 environment by using clustering, replication, mirroring, log shipping, backup and restore to meet RTO/RPO objectives.
• Developed T-SQL packages, pivot tables and SQL reporting services reports.
• Experience in Writing Complex T-SQL Queries, Dynamic-queries, Sub-queries, Co-related sub queries, Complex joins.
• Created and implemented ER models and dimensional models (star schemas).
• Continuously monitoring and updating Backup and Recovery strategy to recover data based on RPO and RTO requirements.
• Implemented database reports and alerts to keep track of the database backups and insure that backup happens on schedule.
• As per Business Requirements, Wrote PL/SQL package to log exceptions.
• Extensive usage of SQL Server tools and 3rd party tools like Litespeed, Veritas NetBackup and ESP.
• Involved in SSRS Installation, Deployment, and configuration, and Support various business units and systems.
• Designed the SQL Database Disaster Recovery solution across the enterprise in a cost effective manner meeting the proposed RPO and RTO per SLA.
• Configured Database Mirroring for Disaster recovery.
• Implemented transactional replication as per the requirement to push the data to different databases including SQL and Oracle databases.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Done migration/upgrade projects to latest versions of SQL Server (SQL 2008/2008 R2 to SQL 2012 and 2014) using web services like Azure, AWS (Amazon), Rackspace.
• Experienced in AWS EC2\RDS and Windows Azure.
• Analyzing and meeting SLAs as per the severity.
• Worked with global monitoring team to setup SCOM alerts with optimized SQL Server Objects for monitoring all production environments.
• Designed and implemented a standard weekly database maintenance job to all databases using Total Production Maintenance (TPM) plan which involves DBCC Checkdb, Rebuild\Reorganize indexes based on index fragmentation.
• Experience in COM to create re-usable software components, link components together to build applications, and take advantage of Windows services.
• Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
• Involved in Hardening of Windows\MS SQL Servers to comply audit standards to avoid potential security breaches.
• Created COM objects with Object-oriented languages, such as C++ to provide programming mechanisms that simplify the implementation of COM objects.
• Worked on server maintenance activities like applying Servers patches, hot fixes, scheduling change for downtime, co-ordinate Server/Database related tasks
• As a Database administrator responsible quickly track down problems that could be causing performance degradation by using SCOM.
• Written T- SQL Scripts to Verify all scheduled jobs have run successfully
• Developed PowerShell scripts to make automate installation process across multiple servers.
• Involved in scheduling and maintaining batch jobs thru SQL Server Agent and thru various Shell scripts, VB script, .bat files, ESP.
• Involved in configuration of Raid Levels, Files and File group placements for VLDB’s up to 2 Terabytes to achieve maximum performance and uptime.
• Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and scorecard / dashboards on SQL Server 2008 using SSAS, SSIS/DTS, SSRS.
• Adhere to SOX regulations and followed Change Control procedures and tickets for DB Changes.
• Performance Tuning the database using tools like Dynamic Management Views (DMV’s), SQL Server Profiler, SQL Server Extended events, MS PerfMon
• Developed a process using PowerShell script to automate servers’ maintenance and monitoring tasks.
• Extensively worked on SQL Server Integration Services (SSIS). Designed and built SSIS packages and ran several scripts for implementing changes in the backend for applications.
• Used Integration services (SSIS) to migrate data from one system to another and performed several transformations to ensure data integrity and validity.
• Using SSAS created OLAP cubes for data mining and created reports from OLAP cubes using SSRS.
• Involved in Installation, Configuration and Deployment of Reports using SSRS with Scale-Out topology.
• Developed PowerShell scripts and T-SQL scripts to perform DBA’s day-to-day activities. PowerShell scripts are developed mainly for automate the Installation and executing bulk tasks.
• Used expressions to setup standard Logging in all SSIS packages for troubleshooting errors.
• Created several database objects including Tables, Stored Procedures, Functions, Triggers, User Data Types, Indexes, Synonyms, and Views.
• Implemented SQL 2014 clustered column store indexes in Data Warehouse system.
• Responsible for capacity planning, monitoring Disk I/O, CPU and memory

Environment: MS SQL Server 2016/2014/2012/2008 R2/2008/2005, SSRS 2014/2012/2005/2000 DTS/SSIS, IIS 8.5/7.5/6.0, Windows 2012 R2/2008 R2/ 2003 R2/Server, PowerShell 4.0/3.0, SCOM, T-SQL, PL/SQL, VB.Net, VB Script, and Windows Script, VERTIAS Net Backup, VSS, PSSDIAG, SQL Profiler, T-SQL, LiteSpeed 5.2, Spotlight.

Confidential, West Des Moines, IA

Sr. SQL Server DBA

Responsibilities:

• Installed & Configured SQL Server SQL 2014/2012/ 2008 R2/ 64/32bit versions on Windows 2008/ 64/32-bit servers on Enterprise systems comprising of clustered and standalone enterprise Data Centers.
• Responsible for the day to day operations of all production SQL server clustered instances and physical database servers.
• Documented and maintained the database instances across the environment.
• Involved in creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers, Rules and Defaults.
• Monitored 24/7 production operations management (incident break/fix, change, service requests and vulnerability management).
• Wrote a batch script to automate the desktop SQL client tool installations as per the client’s standards.
• Developed a process using PowerShell script to automate servers’ maintenance and monitoring tasks.
• Designed different database backup strategies for effective use of space and minimum time to recover when needed.
• Modified Stored Procedures and complex T-SQL queries to improve query execution Process.
• Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing.
• Automated database refresh from production to test servers using SSIS and scheduled in VisualCron scheduler
• Migrated MS SQL 2008/2005/2000 to MS SQL 2012 as part of decommissioning end of life support hardware and software.
• Written T-SQL scripts to perform a wide range of tasks like Verify Success of DB backups, Review DB Sizes and Growth settings.
• Developed and created the new database objects including tables, views, index, stored Procedures, functions, triggers, advanced queries and also updated statistics.
• Experience in T-SQL (DDL and DML)
• Responsible for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes and fine tuning Stored Procedures).
• Exposure to cloud technologies like AWS and Microsoft Azure.
• Respond to the database related tickets raised by various IT and Business teams.
• 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.
• Responsible for data integrity, user security, daily monitoring for production and non-production systems.
• Query level Performance analysis and tuning with the help of DMV’s, Query plans, Database tuning advisor and SQL Server Profiler.

Environment: SQL Server 2104/2012/ 2008 R2/2008/2005, SSRS 2005/2000/DTS/SSIS, Windows 2012 R2/2008/ 2003 R2/Server, PowerShell 4.0/3.0, SQL Profiler, T-SQL, DB2, TFS, VisualCron, EventSentry

Confidential, Des Moines, IA

SQL Database Administrator

Responsibilities:

• As a member of Database and BI team, extensively worked on Database Administration activities and BI Support activities.
• Migrated multiple financially significant applications from MS SQL Server 2000 to SQL Server 2005.
• Involved in Database Administration activities like Installation, Configuration, Backup, Security, Replication, and Data Migrations across all the servers.
• Created Logins, Roles, Schemas and other Security related activities for various groups accessing the systems.
• Created all the required Databases and objects like Tables, Indexes, and Constraints and maintain source control versions.
• Implemented Full, Bulk-Logged and Simple recovery models according to requirements.
• Involved in writing stored procedures for both Online and Batch requests handling business logic and functionality of various modules.
• Responsible for monitoring and making recommendations for performance improvement in databases by proactively involving in index (Defrag, Rebuild, Alter), DBCC maintenance jobs, file group modifications.
• Involved in writing various DB Objects like User defined functions, Instead of triggers, Usage of Indexes for accomplishing various tasks.
• Worked on analyzing and Performance tuning queries by looking at the Indexes, appropriate joins, Query Statistics and Execution plans using SQL Profiler /Query Analyzer/SSMS.
• Used SQL Server Profiler to determine deadlocks and identify possible causes.
• Involved in ETL Loads using SSIS/DTS Packages from various heterogeneous source systems into the databases for Dashboard Reporting on a daily basis.
• Involved in package migration from DTS to SSIS, running upgrade advisor against DTS Packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually
• Involved in Table partitioning to improve I/O access.
• Handled the database components (Code migration, Change control) for application releases.
• Created technical specifications, test plans and test data to support ETL processes.
• Created stored procedures to use as the datasets for the Report Design.
• Configured Subscriptions and Security for all critical reports.

Environment: MS SQL Server 2012/2008, 2005/2000, SSRS 2005/2000, SSIS/DTS, Visual SourceSafe, OLAP, Enterprise Manager, Query Analyzer, SQL Profiler, Active Directory and Windows XP platform, DB2 (Main-Frame), VB Script, MS Visio.

Confidential, Lakeland, FL

SQL Server Consultant

Responsibilities:

• Involved in installing and maintaining MS SQL Server 2000/2005.
• Created Data Model or the Marketing Information System Team using Erwin.
• Created SSIS package for loading the data coming from various interfaces like OMS, Orders, Adjustments and Objectives and also used multiple transformation in SSIS to collect data from various sources.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Scheduled and maintained daily and monthly loads of OMS, Orders, Objectives and Adjustments data through jobs, tasks, and alerts.
• Created stored procedures to build Fact tables in data mart for Multi-Dimensional analysis using (SSAS) and produced ad-hoc, standard and create super user reports using (SSRS).
• Using SSAS created OLAP cubes for data mining and created reports from OLAP cubes using SSRS.
• Created components, tools, techniques, methods and procedures used in an on On-Line Analytical Processing (OLAP) environment for accessing and translating data into understandable and usable business information using SSAS.
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Created Database Objects - Tables, Indexes, Views, Stored Procedures and User defined functions according to the requirements of the project.

Environment: Windows 2003/XP, Terminal Server, T-SQL, BCP, SQL Jobs, SQL Server Management studio, SQL Server 2005, SSIS, SSRS, SSAS, ERWIN