PROFESSIONAL SUMMARY:

• Around 8+ years of experience in Administration, Analysis, Development, Debugging, testing of software applications to support reporting and Business intelligence services.
• Strong knowledge in working on Very Large databases OLTP, OLAP and involved in troubleshooting the problems and dealing with complex databases.
• Expertise in migrating/upgrading SQL Server 2005, 2008/2008R2 to SQL Server 2012 and 2014 versions and applying service packs.
• Expert in handling production systems in 24/7 environment.
• Experience in Software Development Life Cycle (SDLC), Analyzing and Designing systems using Structured Methodologies (ERD, DFD) along with extensive knowledge of Relational Database Management Systems with in - depth of T-SQL.
• Expertise in High Availability Disaster Recovery Solutions like Log shipping, Mirroring, Replication, SQL Server clustering (Active/ Active, Active/Passive) and Always ON technologies.
• Experience in installing, configuring, patching and updating the 2014/2012/2008 r 2/ 2008/2005/2000 Server versions.
• Experience in using native tools like SQL Profiler, DTA, DMV, Perfmon, SQL Diag and Third-party tools like Spotlight, Red gate, Foglight, Litespeed, PATROL Tools to troubleshoot performance issues in production environment.
• Migrating and configuring SQL servers to AWS (AMI, RDS, ELB, EC2, and S3) and also from physical disks to Azure.
• Expert in using Index fragmentation, Index integrity, Index tuning, Query Optimization, DBCC checks, Error and Event handling to reorganize the unstructured data.
• Involved in partitioning (Horizontal and Vertical) large tables to improve performance.
• Network connectivity troubleshooting such as DNS name resolution, WINS name resolution, TCP\IP, IP subnet, IP routing.
• Dashboard Reports are designed by using SQL Server Reporting Service (SSRS), Report Models and Ad-hoc Reporting using Report Builders.
• Expertise in working on Virtual Machines with SAN and NAS Storages.
• Experience in gap identification and controls improvement process by using SOX.
• Working Knowledge on AWS and Azure cloud technologies.
• Experience working on Hyper-V and VMware environments.
• Expertise in Designing SAN storage with different RAID levels to improve the Performance of the system.
• Experience in Database Tasks like Scheduling backup jobs, creating Alerts and providing Email notifications.
• Scheduled Reports to be delivered to SharePoint Document Library.
• Published Reports to SharePoint Server utilizing Business Intelligence Development Studio.
• Created Linked Servers between SQL Server & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.
• Having strong knowledge in creating and assigning user permission, logins and maintaining security according to business standards.
• Experience in working on Transactional Replication, Snapshot Replication and Merge Replication.
• Expert in using Joins and Sub-Queries to simplify complex queries involving multiple tables and optimized the procedures and triggers to be used in production.
• Expertise in writing UNIX Shell scripts and SQL/PL/SQL scripts for database monitoring and administration.
• IBM Tivoli tool used in monitoring the status of Jobs, Errors, Locks, Space Usage and Availability of Databases.
• Experience in ETL tool Mapping, Transformations, Lookups and Aggregations.
• Designed effective Backup and Recovery plan by Transactional, Differential and Full Database Backups to recover data in point in time in case of disaster of the server.
• Experience in transferring data from and to SQL Server Databases involving SSIS, DTS, BCP and BULK INSERT.
• Involved in using ERWIN and VISIO models for Database Design.
• Experience in working on Postgre SQL and Oracle database.
• Experience in Microsoft Postgre SQL technologies using C#, ASP.NET 1.1/2.0/3.0/3.5, Language integrated Query (LINQ), and Visual Studio.NET2005/2008.
• Expertise in finding Missing, Unused and Excess Indexes and Update Statistics on databases could improve performance.
• Used Power Shell script for SQL Server Maintenance activities.
• Intermediate level experience in Oracle8i/9i, 11g architecture and silent installation process.
• Experience in 24x7 support for production environment in order to monitor and tune the performance of Oracle 10g and 11g databases.
• Experience in writing T-SQL Stored procedures, Triggers and Functions.
• Experience in writing Complex Multi-Dimensional (MDX) queries, Data Mining Extension Queries (DMX), XMLA Queries.
• Having excellent inter-personnel communication skills and good at team work.

TECHNICAL SKILLS:

Databases: MS SQL Servers 2000, 2005, 2008, 2008r2, 2012 and 2014, Oracle 11g, 10g, 9i, Postgre SQL, SQL Azure and AWS.

Languages: SQL, T-SQL, PL/SQL, SQL*Loader, HTML, XML, Shell scripting, Visual Studio, ASP.NET, LINQ, VB.NET, C#.

SQL Server Tools: Management Studio, Enterprise Manager, Index Tuning Wizard, Database Tuning Wizard, Profiler, Query Analyzer, Export & Import, Precise i3 for SQL Server.

Operating system: Windows 2012/2008/ 2003/ 2000/ Professional/ NT 4.0 Advanced Server, Linux, Ubuntu

OLAP Tools: SQL Server Analysis Server 2008, 2005, SSIS (as ETL).

ETL Tools: SQL Server integration services (SSIS), SQL Server reporting services (SSRS), SSAS, and Data Transformation Services (DTS).

Design Tools: Magic Draw, Rational Software Architect, Visio, Erwin.

Load Test Tools.: WAPT 7.5, WAPT Pro 3.1.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago-IL

Sr. SQL Server DBA

Responsibilities:

• Working as a Production DBA and Responsible for performance of the SQL Server instance and safety of the data in database.
• Installed and Configured SQL Server 2014, 2012 and 2008r2 in enterprise cluster and standalone environments.
• Migration of databases from SQL Server 2005 to SQL Server 2008r2 and SQL Server 2012.
• Working Knowledge on AWS and Azure cloud technologies.
• Used the Agile Methodologies for the Software Development Life Cycle (SDLC)
• Configured, tuned and maintained MySQL database servers.
• Solid hands-on skills in migrating/upgrading SQL Server /2008R2 &SQL Server 2005, 2008/2008R2 to 2012 and .2014 and applying service packs, extensive experience in migrating and new installations of SQL Server on Hyper-V and VMWARE environments.
• Responsible for working on different kinds of Replication on the Production Servers.
• Involving in Database creation, Backup, Restoration, Recovery and Space Management.
• Creating SQL jobs to extract data from available databases to tables and flat files.
• Performing various points in time recoveries of various SQL Server databases in production and test environments.
• Experience in working with windows team to failover the cluster if needed after windows patching.
• Experience in working with developers to tune SQL queries to improve the performance.
• Working on LINQ for query the data objects in C++, C#, VB.net.
• Distributing huge tables to different file groups to maximize the performance.
• Monitored and modified performance using execution plans with query hints and index tuning.
• Migrated Oracle databases to SQL Server for SAP migration.
• Worked on High Availability Disaster Recovery during SQL 2014 migration.
• Frequently maintaining the databases and reorganizing the defragmented the data.
• Created SSIS packages to load robust data from different Heterogeneous data sources like Oracle, DB2 to SQL Server.
• Involved in writing user-defined functions (UDFs), user-defined types (UDTs), and queries using T-SQL and SQL server analyzer.
• Creating views, store procedures and optimizing them as required by the front-end developers for easier implementation on web pages and performance testing on store procedures, indexes, and triggers.
• Performing database consistency checks with DBCC, Defrag, Index tuning and monitoring error logs.
• Configured and managed virtual servers.
• Experience in implementing and migration databases to Microsoft Cloud Environment.
• Created DB master key, symmetric keys, asymmetric keys and certificates for encryption.
• Scheduling the jobs using SQL Server agent and providing the security to databases.
• Maintaining database consistency with DBCC at regular intervals, Managed Disk space and memory, User connections and Monitored SQL Server performance using profiler to find performance and deadlocks.
• AWS migration- RDS and EC2 instance creation and administration.
• Troubleshooting the issues using outputs of SQL Trace, SQL Diag, error log, Blocker script and event log.
• Performing partition for efficient management database tables and indexes.
• Utilizing the SQL Server tools like SQL Server Profiler, Perfmon, and Index tuning wizard, Database tuning advisor and Activity monitor to optimize the queries and improve the performance of database servers.
• Created a dimensional data warehouse and converted the Oracle database to Amazon AWS Redshift cloud environment due to enterprise data move to cloud solution.
• Scheduling and Maintaining FULL, DIFF, and LOG database backups as per the company strategy to meet the recovery point objectives.
• Providing 24/7 support for critical production databases (OLTP and OLAP).

Environment: SQL Servers (2014, 2012 and 2008r2), DBCC, Defrag, SQL Server profiler, Perfmon, SQL Diag, SQL Trace, VMWare, Index Tuning Wizard, DTA, MS AZURE, AWS, Oracle, OLTP and OLAP.

Confidential, Louisville- KY

Sr. SQL Server DBA/Developer

Responsibilities:

• Installed, Maintained, and Configured SQL Servers 2008, 2008R2, 2012 on Test, Development and Production Environments.
• Used new compression techniques in SQL 2005 and 2008 to increase performance by reducing the I/O and increasing the buffer rates.
• Involved in migration of SQL R2 and 2012.
• Involved in migration of the data.
• Expertise in Designing SAN storage with different RAID levels to improve the Performance of the system.
• Windows security patching for more than 200 servers.
• Modified store procedures and complex queries to enhance the execution process.
• Used native tools like Database Tuning Advisor, SQL Profiler, Performance Monitor and Activity Monitor performance tuning.
• Involved in writing VB.NET code in script components in SSIS to validate the data from database sources.
• Implemented and maintained SQL Server replication.
• Experienced in working on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
• Created views as per the requirements of front-end developer for easier implementation ASP.NET pages.
• Installation, configuration and supporting of IIS servers.
• Experience in installing and configuring MS SQL Server Database Engine on physical and virtual servers (VMWare).
• Worked closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts etc.
• Installed and configured third party tools like Diskeeper, Idera SQL Diagnostic manager, and Red gate tools to monitor SQL Server regularly.
• Implemented and controlled the flow of data to and from AWS and Azure.
• Deployed, managed, and operated scalable, highly available, and fault tolerant systems on AWS and Azure.
• Experience in gap identification and controls improvement process by using SOX.
• Implemented Kerberos delegation with SSRS.
• All schema migrations via SSMS and migrated data through SSIS package to SQL Azure.
• Troubleshoot performance issues such as locking, blocking and deadlocks on production database using tools like SQL Server profiler, SQL Server DMV’s and precise i3.
• Review the Design document provided by the onshore/offshore development teams for the future enhancement upon the requirements.
• Created login and passwords will restrict the access to database objects.
• Created Clustered and Non-Clustered Indexes to improve the performance of the database access.
• Created jobs for rebuilding/reorganizing of indexes and updating statistics.
• Created Ad hoc reports using report builders.
• Involved in change data capture (CDC).
• Created several MDX queries according to business requirements.
• Extensively worked on high availability SQL Server solutions including Log shipping and mirroring.
• Used Replication models (Transactional and Snapshot) to recover the databases.
• Worked on Capacity Planning, Database Normalization and De-normalization process.

Environment: SQL Servers 2008, 2008r2 and 2012, DTA, SQL Profiler, Perfmon, Diskeeper, Idera, MDX, precisei3, SSMS, SSIS, SQL Azure, AWS, VMWare, Agile Methodology, ASP.NET, DMV and DMF.

Confidential - Bridgeport, CT

SQL DBA/Developer

Responsibilities:

• Installed stand-alone and clustered SQL Server 2008 R2 and 2012 on 64-bit systems.
• Performed in-place upgrade from SQL Server R2.
• Implemented and maintained Log shipping and Transactional Replication as Disaster Recovery solution.
• Implemented and maintained Always on Availability Group as Disaster Recovery solution on SQL Server 2012.
• Managed and administrated SQL Server 2008R2/2012 on production and non-production server.
• Performed Failover drill tests to check the High Availability during disasters
• Used LiteSpeed for backups and maintenance jobs which includes updating statistics, database integrity checks.
• Attended and facilitated Agile Scrum meetings to discuss project progress and plan.
• Configured DB mail by creating accounts and profiles and Worked on Linked servers.
• Worked in setting up the SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options
• Modified Stored Procedures and complex T-SQL queries to improve query execution process
• Created Logins, Roles and Proxy accounts with appropriate permissions and maintaining Database Maintenance Plans
• Used Red Gate to compare and synchronize data and database object structures.
• Developed and created the new database objects including tables, views, index, stored procedures, functions, triggers, advanced queries and also updated statistics
• Monitored alerts using FogLight and Spotlight and also looked into Event Viewer, SQL Error logs and Log File Viewer for software and hardware related errors.
• Provided on Call Production support.
• Tuned stored procedures by using execution plans.
• Performance analysis and production support for very large (VLDB) in OLTP, OLAP Database.
• Used table hints in the queries to avoid locks in the server.
• Created missing indexes on the tables by running Data Base Engine Tuning Adviser.
• Finding and solving locks and Deadlocks by using DMV’s and DBCC commands.
• Worked on CDC (Change Data Capture) to track DML activities in user-created table.
• Created Logins for the users and manage their permissions.
• Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Used Bulk insert to load huge tables.

Environment: MS SQL Server 2008/2005/2000 Windows 2000/2003/2005/2008/2012, SSRS, SSIS, MS Access, MS Excel.

Confidential

SQL Server DBA

Responsibilities:

• Worked on installation and maintenance of SQL Server 2008r2/2005 in all environments.
• Involved in upgrading the SQL Server service packs in test, developments and production environments.
• Collected data from different kind of sources to SQL Server using SQL Server integration services (SSIS).
• Imported data across multiple instances using BULK INSERT and BCP utility.
• Used work with Active Directory Tickets.
• Co-ordinated with development team in writing T-SQL queries to optimize the performance.
• Performed tuning and optimization of SQL Server databases.
• Implemented Disk mirroring and RAID technology to manage databases on SAN devices.
• Worked on VIRTUAL and PHYSICAL environments in managing the production SQL Servers.
• Hands on experience in troubleshooting database issues, update statistics, backup and restore operations.
• Maintained database response times in 24/7 Production environments, proactively generated performance reports. Automating most of the DBA jobs and monitoring stats.
• Expertise in Microsoft Reporting Services (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Implemented database mirroring and transactional replication as part disaster recovery plan.
• Configured servers for sending automatic mails to respective people when a SSIS process failure or success.
• Monitored SQL Server performance using profiler for identifying performance issues and deadlocks.
• Worked on maintaining different backup plans and restore strategies to recover the databases.
• Co-ordinated the offshore and onshore teams.

Environment: SQL Servers 2008r2 and 2005, SQL server Integration and Reporting Services, T-SQL, RAID, BULK INSERT and BCP.

Confidential

Jr. SQL Server DBA

Responsibilities:

• Worked in Active/Passive Clustered Environment.
• Writing stored procedures for report generation in migration process and replication.
• Implemented the migration of SQL Server 2005, 2008.
• Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
• Experience in monitoring software tools used to monitor the environment effectively.
• Successfully implemented Database Mirroring in SQL Server 2005 for high availability.
• Maintain both DEVELOPMENT and PRODUCTION server in sync.
• Involved in Log Shipping.
• Migrate Data from SQL 2005 to SQL 2008
• Monitoring various types of scheduled backups
• Extensively involved in replication and implemented Snapshot, Merge and Transactional Replications.
• Involved in Monitoring Performance of different production servers.
• Worked in 24x7 production environment.
• Working with the end user gathering requirements for the system.
• Disaster Recovery Plan, Testing and analyzing and continuous update of documentation.
• Creating Logins and Roles with appropriate permissions.
• Prepared and documented Backup & Restore Plans.
• Creating and Maintaining Database Maintenance Plans.

Environment: SQL Server 2000/2005/2008 with Clustering, MS Access, VMware ESX, Windows 2000/2003, DTS, Lite speed 5.0, TSM, RML Utility, T-SQL, SSIS, SSAS and SSRS.

Confidential

SQL Developer

Responsibilities:

• Actively involved in analysis, design, and development and testing with team.
• Performed SQL Database Development tasks - Creating database, tables, views, stored procedures, triggers, user defined functions, index and other database objects, based on business requirements and provided documentation.
• Involved in providing database coding to support business applications using T-SQL.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Identified and defined datasets, added parameters for the report generation and wrote the queries for the drill down reports.
• Uploaded reports on to the report manager and organized them in folders.
• Delivered the reports using 'pulled' and 'pushed' methodologies and formatted them using Global variables and expressions.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Implemented SSIS Packages to migrate data into new database from various data sources, for example flat file, excel file, SQL Server
• Monitored performance and fine-tuned the database objects and server to ensure efficient data retrieval.
• Used various transformation components in the data flow task to implement business logic to merge data from different sources.
• Used SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries.
• Responsible for Query optimization and Performance tuning.
• Used SSIS to extract and load data from different sources.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Developed several reports using reporting services.
• Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.
• Maintained the table performance by following the tuning tips like Normalization, Creating Indexes etc.
• Managed index, statistics and optimizing queries by using execution plan.

Environment: MS SQL Server 2005/2008, Query Analyzer, SSIS, SQL Profiler, MS SQL IntegrationServices2005, MS SQL Reporting Services 2005, MS Excel.