SUMMARY:

• 9 years of experience as SQL Server DBA (2014, 2012, 2008, 2005, 2000) in Production, Development and Staging, Data Warehouse Environments (OLTP and OLAP).
• 24/7 on Call Support for Production Databases.
• Experience in configuring Merge Replication on database that is part of AlwaysOn by enabling Replication agents running all the times in failover events.
• Extensive experience in Configuration, Implementation and Maintenance for Disaster Recovery solutions Using Log Shipping, Mirroring and AlwaysOn in SQL Server 2012/2014.
• Extensive experience in Deploying and Consolidating Remote Instances.
• Experience in implementation of SQL Server new features like Always On Availability Groups, Contained Databases, Change data capture (CDC), online index rebuilds, Central management server, Transparent Data Encryption (TDE), User - Defined server roles.
• Extensive experience in Installation, Configuration, Patches, Upgrades and Administration for SQL Servers in Clustered (Failover) and Non-Clustered Environments.
• Experience in scheduling Backups and Restore, Log Shipping and Maintenance plans using Native & Third-party tools (SnapManager, LiteSpeed and Red Gate SQL Backup).
• Expertise in Scheduling Database tasks - Jobs, Alerts, Emails, Notification.
• Experience in Configuring and Maintaining Database Mirroring and Database Snapshots.
• Experience in migrating SSIS packages from lower versions to higher versions of SQL.
• Experience in BI Development and Deployment of SSIS packages from Flat files, Excel, Oracle, and DB2.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and partial blocking Transformations.
• Experience in configuring and administering Reporting Services.
• Extensive experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Enterprise Standards.
• Experience in doing Automation tasks like monitoring Disk Space, Server Ping Status, Database health checks using customized SQL scripts, batch file and Power shell.
• Experience in solving Database issues with Index fragmentation, Integrity checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Error and Event Handling.
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and DB Engine Tuning Advisor.
• Experience in analyzing SQL wait types, execution plans for troubleshooting performance issues.
• Object Level Audits using Change Data Capture (CDC).
• Managing database systems using Query Governor and Activity Monitor.
• Expertise in SQL Server Storage Structures and Security Architecture for databases residing on SAN storage on distributed systems.
• Experience in programming tasks like developing Stored Procedures, Functions, and Triggers, ad-hoc queries for reports, TSQL batches, PL/SQL packages and procedures, PowerShell scripts.
• Provided extended support for business critical applications like CRM, SharePoint, Project Financial, Data hub and SCOM.
• Designing and Deployment of Reports for the End-User requests using Web Interface and SSRS (Ad-hoc Reporting).
• Implementing efficient Database Design principles including Partitions and Compression techniques.
• Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models, E-R Diagrams.
• Good knowledge in OOP’s concepts and Business Objects & Database analysis and design experience using Erwin.
• Strong T-SQL Developer skills including stored procedures, Indexed views, User Defined Functions (UDL), Triggers, and Distributed Queries.
• Working knowledge of .Net Framework 2.0 (VB.Net, ASP.Net, ADO.Net), IIS 6.0
• Testing methodologies and tools - Automation and Performance testing.
• Strong Communication & Management skills and Excellent Team player.

TECHNICAL SKILLS

Databases: SQL SERVER 2014/2012/2008R2/2008/2005/2000,MS-Access, DB2, Oracle Database 10g and 11g.

Operating System: Windows Server 2003 / Server 2008 / Server 2008R2/ Server 2012, Server 2014, Unix, Linux.

Programming Languages: TSQL, PL/SQL, Power Shell, C, C#, VBScript, HTML, XML.

Network Topologies: Asp.Net, HTML, DHTML, XML, IIS 6.0/7.0/8.0, Java Script, TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

3rd Party Tools: Idera SQL Diagnostic Manager, Qwest LiteSpeed, Service-Now Management, SharePoint, Pass Pro Manager, VmWare, SnapManager, SCOM, Erwin, MS Visio, Quest LiteSpeed, Active Directory,Spotlight for SQL Server, red-gate SQL monitor, SCOM.

SQL Tools: SQL Server Management Studio, SQL Navigator, Microsoft Visual Studio 2008/2010/2012,SQL Server Enterprise Manager,BIDS, Sybase Data Tools, SQL Profiler, SQL Networking, Activity Monitor, DTA, PerfMon, SQL Configuration Manager.

PROFESSIONAL EXPERIENCE:

Confidential,Chicago, IL

Sr. SQL DBA

Responsibilities:

• Installed and configured SQL Server 2012/2014 on clustered (active-active environment) and non-clustered environments.
• Applied latest service packs and patches on SQL Servers.
• Responsible for whole project servers for Data Hub.
• Worked closely with Storage and System team to migrate all SQL servers underlying storage.
• Deployed release scripts and ISPAC packages onto UAT/Production Server.
• Automated SSIS packages and Process related jobs on all AlwaysOn nodes and configured to run
• Implemented and tested all the Microsoft recommended best practices and configurations during pre and post migration steps at instance and database level before going to production.
• Migrating databases from SQL Server 2005/2008 to SQL Server 2012/2014 as part of Data Center migration.
• Resolved the Memory/IO/CPU/TempDB bottlenecks to achieve performance by making use of Windows
• Performance counters, SQL traces and DMVs.
• Extensive testing on AlwaysOn and Replication functionality on SQL 2012.
• Migrated the Data from an External Oracle MS SQL Database by using SSIS.
• Developed scripts to script out existing replication topology in old data center.
• Implemented and monitored Merge replication for DR and reporting purposes.
• Setup and configured AlwaysOn Availability Groups for DR and Reporting.
• Worked with Disaster Recovery Team to define, implement and maintain global disaster recovery plans.
• Implemented User-Defined server roles in SQL Server 2012, default schemas for groups.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Responsible for the implementation, documentation, and day-to-day support of the Data Hub Servers.
• Performed data analysis for designing, developing data marts, cubes for BI Reports and analytical purposes.
• Created and designed data models using Erwin data modeling tool.
• Developed PowerShell scripts in place of TSQL batch script for daily maintenance activities to improve performance and scheduled scripts in central management server.
• Responsible for the Design and development in PL/SQL and stored procedure.
• Used SnapManager for backups and restore of very large databases.
• Developed database administration reports for disk utilization, backup check, daily Replication status check, Job status and other daily monitoring tasks.
• Created maintenance plans for database consistency and integrity checks, resolved issues related to database consistency and integrity.
• Deployed reports in native mode and SharePoint portal and scheduled reports to run on daily basis to send e-mails.
• Migrated 2008 SSIS packages to SQL 2012 project deployment model and configured SSIS Catalog, environments.
• Experience with SCOM to monitor and manage critical database servers from a centralized location.
• Worked extensively on data refreshes from production to test environments, automated the whole data refresh process at database level using PowerShell scripts, storedprocedures, Backups and SQL Agent jobs without having any performance impact on Production server.
• Used SQL Profiler, Server side trace to identify performance issues on the server.
• Improved query performance by analyzing the stats, Query Execution Plans, system performance by system Performance Analysis, and used SQL Profiler for optimizing stored procedures.
• Monitored production servers using Idera Monitoring tool and resolved database tickets that are assigned.
• Resolved issues related to blocking, deadlocks, connectivity issues, replication issues.
• Performingrootcauseanalysis on the production issues.
• Performed capacity planning by analyzing the perfmon data and preparing charts for applications owners.
• Involved in virtual team to enhance the On/Off-Shore Management of activities between core and flex teams which are spread across globally and keep the stake holders up to date.
• Followed ITIL process like working on tickets change requests, root cause analysis, incident management and problem management.
• Having onsite experience at Confidential London (UK) for project planning and discussions with clients and Microsoft Engineers.
• Providing global support to other regions like Australia, Europe and Africa Servers.

Confidential

Sr. SQL DBA

Responsibilities:

• Installed and configured SQL Server 2008R2/2012 on Clustered and non-clustered environments.
• Migrating databases from SQL Server 2005/2008 to SQL Server 2012.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Implemented AlwaysOn setup on pilot servers to test the functionality along with maintenance plans.
• Responsible for the implementation, documentation, and day-to-day support.
• Prepared SQL Server repository for all Prod & Non-Prod Servers and uploaded onto SharePoint Site.
• Implemented Ola Hallengren scripts on all servers to automate Backups, maintenance plans.
• Used Snap Manager for backups and restore of very large databases.
• Developed database administration reports for disk utilization, backup check, daily Replication status check, Job status and other daily monitoring tasks.
• Created maintenance plans for database consistency and integrity checks, resolved issues related to database consistency and integrity.
• Deployed reports in native mode and SharePoint portal and scheduled reports to run on daily basis to send e-mails.
• Migrated 2008 SSIS packages to SQL 2012 project deployment model and configured SSIS Catalog, environments.
• Worked extensively on database refresh from Production to UAT and DEV databases.
• Rebooting SQL servers with agreed downtime on weekends for MS Security patches.
• Used SQL Profiler, Server side trace to identify performance issues on the server.
• Improved query performance by analyzing the stats, Query Execution Plans, system performance by system Performance Analysis, and used SQL Profiler for optimizing stored procedures.
• Monitored production servers using Idera Monitoring tool and resolved database tickets that are assigned.
• Resolved issues related to blocking, deadlocks, connectivity issues, replication issues.
• Performingrootcauseanalysis on the production issues.
• Performed capacity planning by analyzing the perfmon data and preparing charts for applications owners.
• Followed ITIL process like working on tickets change requests, root cause analysis, incident management and problem management.
• Providing global support to other regions like Australia, Europe and Africa Servers.

Environment: Windows Server2008 R2 and 2012, SQL Server 2014/2012/2008 R2/2008/2005,SQL Query Analyzer, Sybase, SSRS, SSIS, SSMS, SCOM, Data Tools, Internet Information Server 6/7.5, JavaScript, CSS, HTML, .Net Framework 3.5/4.5, SnapManager, Service-Now SharePoint 2010 and SSAS.

Confidential

SQL Server DBA

Responsibilities:

• Design, develop and maintain database administration tasks for administering SQL Server 2005/2008/2008 R2
• Installation and configuration of SQL Server 2000/2005/2008.
• Designed and developed DTS packages.
• Migrated DTS packages from SQL 2000 to SQL 2005.
• Worked on SQL server upgradation from SQL Server 2000 to SQL Server 2005/2008.
• Worked on ETL migration with required transformations like Derived Column, Data Conversions, Sort and Union.
• Designed, Configured and automated SSIS packages as per Business (LOB) requirement.
• Create and maintain various databases for development, testing, staging and production environments using SQL Server 2005/2008.
• Monitoring and Troubleshooting SQL Cluster.
• Hands on experience on SQL Server Log shipping, Replication and Mirroring.
• Written Stored Procedures, Functions, and Views as per DBA requirement.
• Troubleshooting query performance.
• Manage users including creation/alteration, grant of system / db roles and permissions on various database objects and object level permission.
• Creating & scheduling the maintenance plans.
• Developing the successful Backup strategies based on Recovery models.
• Performing SQL Server database performance analysis and ongoing maintenance/tuning to ensure maximum performance.
• Synchronizing Production and UAT environments.
• Installed IBMDB2 Client tool and configured DB2 Databases in SQL Server environment.
• Automated OLAP reports using Dimensions and Cubes (SSAS) in IS.
• Hands on experience in IIS.
• Installed and worked on F-Secure SSH Server, generating keys and exchanging with other teams to establish the connectivity for file transfer on daily basis.
• Automated the process of creating Data Feed using SSIS and sftp the same to unix/linux servers using batch files and windows utilities.
• Worked closely with LOB in BLs to achieve the project requirements and fixing issues.
• Shrinking the Data files and log files if more free space is available.
• Monitoring Database server, performing health check, SQL Jobs on day to day basis
• Creating and Scheduled SQL jobs as per the business requirements.
• Maintaining and Monitoring Production, Pre-Production and Development database server environment.
• Perform Import/Export tasks using SSIS from different data sources like Flat file, Excel and DB2.
• Configured complete existing project setup in new servers and provided support for few months and upon handed over to Frontier as a part of Verizon landline Spinoff to Frontier.

Environment: Windows Server 2008R2/2008/2003,SQL Server 2008R2/2008/2005, SSRS, SSIS, SSAS,SCOM,SQL Query Analyzer, Data Tools, BIDS, TFS, SharePoint 2010, Crystal Reports, SSMS, PLSQL Developer, Oracle SQL Developer, Oracle 10g, Internet Information Server 6.0,7.0, Elite Enterprise, JavaScript, CSS, HTML, .Net Framework 3.5, SSH Server client, DB2.

Confidential

Tech Support Executive

Responsibilities:

• Planned and Successfully Installed SQL Server 2000, 2005 on the Production and Development Servers.
• Developing the successful Backup strategies based on Recovery models.
• Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases and transaction log on production/development servers as per requirement.
• Involved in creating Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Involved in DTS/SSIS Package, DTS Import/Export for transferring data.
• Involved in implementation of replications like Transactional.
• Implementing Database maintenance plan for Database consistence & Integrity.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• Ensured proper backup and recovery by maintaining DB2 image copies and recovery JCLs Efficiently carried out DBA responsibilities in planning DB2 version migration activities, in migration phases and in performing post migration tasks..
• Monitoring SQL server performance using profiler to find the performance and deadlocks.
• Creating the Jobs using maintenance Plans for Full, Differential and transactional log backups.
• Maintaining and Monitoring Production, Pre-Production and Development database server environment.
• Having good knowledge on creation and scheduling of T-SQL jobs to run daily.