SUMMARY

• 8 Plus years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2017, 2016, 2014/2012, SQL Server 2008 R2, 2008 and 2005.
• Extensive knowledge of Relational Database Management Systems (RDBMS).
• Experience in MS SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, backup/recovery, Database Maintenance plans, and Database Consistency Checks using DBCC commands.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Successfully tested and implemented Log Shipping Technique used for warm backup solution for MS SQL Server 2017/2016/2014/2012/2008R2/2005/2000 databases.
• Experience in developing, deploying and monitoring packages for ETL tasks using SQL Server Integration Services (SSIS), DTS Import/Export Utility, BCP and DTS package
• Experience in Online Analysis Processing (OLAP), created SQL Server Analysis Services (SSAS) cubes,.
• Expert in providing logging, error handling by using event handler and break points for SSIS packages
• Involved in configuring the reporting services (SSRS) and creating the reports in SQL server 2008/2005.
• Experience wif Database Backup, Recovery and Disaster recovery procedures.
• Experience wif SQL Server 2005/2008/2012 /2014 Database Mirroring (AG), Migration, Upgrading.
• Experience in using Data modeling tools like SQL Diagrams, ERWIN and Visio.
• Data migration using ETL tools like DTS services/SQL Server Integration Services (SSIS) across different databases like Oracle, MS access & flat files.
• Experience in using Microsoft's in built tools like SQL Profiler, Windows Perfmon and DTS, SSIS, SSRS for Monitoring, Developing and Tuning MS SQL Server applications.
• Experience in solving Database issues wif Index fragmentation, DBCC checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Errors, and Event Handling.
• Hands on experience in writing and debugging Stored Procedures, Triggers, Cursors, Complex queries using T - SQL, SQL Scripts and Batch files.
• Creation and maintenance of Databases, creating Roles and managing user permissions.
• Good experience in resolving blocking and Dead lock Issues by using SQL commands.
• Experience in Installing and configuring SQL Server Active/Active and Active/Passive clusters.
• Expert in Configuring, Managing and optimizing transactional replication in OLTP environments.
• Experience in using DTS Import/Export utility, BCP and DTS Packages.
• Worked wif Popular monitoring solutions such as SQL Diagnostic Manager, FogLight, Quest Spotlight.
• Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Monitoring Dashboard Reports for Performance Tuning and finding bottleneck in database.
• Developed backup and recovery strategies for SQL Server databases.
• Documented disaster recovery plans and participated disaster recovery (DR) drills.
• Experience in working wif Reporting tools like Business Objects, Crystal Reports, and Microsoft Reporting services (SSRS).
• Experience in monitoring the disk usage and the memory usage of the servers.
• Flexible, enthusiastic and project oriented team player wif solid communication and leadership skills to develop creative solution for challenging client needs.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.
• Having experience in third party tools LiteSpeed, Idera and Red Gate.
• High level plan for securing all the databases and better control on all SQL Servers.
• Involved in creation of linked servers using remote user account.
• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
• Strong experience in mentoring team members and writing documentation.
• 24 X 7 Production Database on Call Support.

TECHNICAL SKILLS

Programming Languages: C, C++, SQL, T-SQL,ASP .Net

RDBMS: MS-SQL Server 2000/2005/2008/2008R2/2012, Microsoft Access

ETL Tools: SQL Server Integration Services (SSIS) 2005/2008/2008R2/2012, DTS

OLAP Tools: SQL Server Analysis Services (SSAS) 2005/2008/2008R2/2012

Reporting Tools: SQL Server Reporting Services (SSRS) 2005/2008, Crystal Reports

Database Tools: SQL Server Management Studio(SSMS),Toad, Data Studio, SQL Server Business Intelligence Studio(BIDS), Enterprise Manager, SQL Profiler, Query Analyzer

Operating Systems: Windows 98, Windows 2000 Advanced Server/Professional, Windows Server 2003/2008/2008R2/2012

Data Modeling Tools: Erwin, Red gate, Lite Speed, Idera, DD Boost.

PROFESSIONAL EXPERIENCE

Confidential, Riverwood, IL

Sr. SQL Server DBA Lead

Responsibilities:

• Converted Oracle server databases to SQL Databases using SSMA to reduce maintenance cost.
• Worked on OLTP for optimization and to facilitate the processing of large numbers of concurrent updates
• Expertise in monitoring performance using SQL Profiler, Activity Monitor, Perfmon to find locking, blocking and deadlock issues.
• Worked on migrating 5 mainframe DB2 databases to DB2 on LUW and SQL Server. Modified and re-wrote some SP to make them compatible.
• Worked on configuration DB2 databases.
• Worked closely in Development/UAT/SIT environments.
• Rewrote old, stored procedures (since their were inefficient after the migration from the DB2 mainframe) and created new ones to meet business requirements.
• Experience on repository service tools like Rational Team concert and Git hub.
• Updated database systems by reviewing, managing Database administration projects including patching, hot fixes and service pack upgrades.
• Expertise in recovering the databases from disasters and implemented Point-In-Time Recovery solution.
• Creating standard procedure for internal usages for other team members.
• Strong experience in Database Normalization, Optimization and Tuning, Backup/Restore, Troubleshooting, and Data Import/Export.
• Expertise in troubleshooting SQL Server Agent jobs, Error Logs, Windows Logs to resolve failure job component.
• Expertise wif High Availability solution such as Always On, Cluster, Mirroring and Log Shipping.
• Rebuild/reorganize indexes and monitor proactively at regular intervals for performance enhancement.
• Create login, user and grant access to group, role or individual accounts as per the approved request from system access
• Experience in Database of OLAP/OLTP and Mirroring as disaster recovery solution
• Processed Daily Data Migration through SSIS jobs by collecting data from different servers
• Upgraded SQL Databases and changed compatibility levels, configured and implemented AlwaysOn availability. Generated Scripts for lower version of SQL Server, Changed Compatibility level and data and log file location, executed the scripts using cmd commands
• Implemented Data security wif Data Masking on SQL 2016 after upgrade.
• Created builds in Team foundation Servers (TFS) for deploying Master scripts in UAT ad Production environments.
• Monitored Log shipping/ Transactional Replication and troubleshooting of errors wif LS job failures, Agents warnings and failures and data lag issues.
• Configured data partitioning/table partitioning on huge tables containing millions of rows for better performance.
• Setup the performance counter by using performance monitor to identify the bottleneck of windows server such as CPU, memory, IO, paging and SQL Server and bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
• Worked on Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT etc. and used configuration files and variables for production deployment.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Experienced in extracting data from Development / UAT / Production servers by using SSIS.
• Upgraded SQL servers from 2005 and 2008 versions to SQL 2014 and SQL Server 2016.
• Provide database coding to support business applications using PL SQL, T-SQL.
• Migrated databases among the servers using copy, attach/detach, copy/restored utilities. Worked on SQL Server Integration Services (SSIS) for data integration from heterogeneous data sources, Adhoc request and ETL related operations.

Environment: Toad for DB2, Data Studio, Windows Server 2012 Enterprise Edition, SSMA, MS-SQL Server 2017/2016/ 2014 / 2012 / 2008 R2 / 2005, IIS, SharePoint, Tableau Desktop/Server9.3, Clustering, Power BI, Netezza, VB.Net scripting, SSIS, SSRS, PL SQL, T-SQL, Azure, Visual Studio 2012, 2013, Toad, Indexes, Cluster, .Net Framework 3.5, 4.0, snapshot, backup/restore, MS Office suite 2010

Confidential, Chicago

Sr. SQL Server Lead DBA / Architect

Responsibilities:

• Experienced wif third party tools like Fog Light, Avamar, Delphix, NetApp, DNT, SSC, BDA, DBaaS SQL Servers.
• Expertise in recovering the databases from disasters and implemented Point-In-Time Recovery solution.
• Creating standard procedure for internal usages for other teams.
• Strong experience in Database Normalization, Optimization and Tuning, Backup/Restore, Troubleshooting, and Data Import/Export.
• Expertise in troubleshooting SQL Server Agent jobs, Error Logs, Windows Logs to resolve failure job component.
• Expertise wif High Availability solution such as Always On, Cluster, Mirroring and Log Shipping.
• Rebuild/reorganize indexes and monitor proactively at regular intervals for performance enhancement.
• Create login, user and grant access to group, role or individual accounts as per the approved request from system access
• Experience in Database of OLAP/OLTP and Mirroring as disaster recovery solution
• Processed Daily Data Migration through SSIS jobs by collecting data from different server
• Upgraded SQL Databases and changed compatibility levels, configured and implemented AlwaysOn availability.
• Generated Scripts for lower version of SQL Server, Changed Compatibility level and data and log file location, executed the scripts using cmd commands
• Implemented Data security wif Data Masking on SQL 2016 after upgrade.
• Created builds in Team foundation Servers (TFS) for deploying Master scripts in UAT ad Production environments.
• Monitored Log shipping/ Transactional Replication and troubleshooting of errors wif LS job failures, Agents warnings and failures and data lag issues.
• Configured data partitioning/table partitioning on huge tables containing millions of rows for better performance.
• Setup the performance counter by using performance monitor to identify the bottleneck of windows server such as CPU, memory, IO, paging and SQL Server and bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.

Confidential, Menlo Park, CA

Sr. SQL Server Lead DBA / Architect

Responsibilities:

• Processed Daily Data Migration through SSIS jobs by collecting data from different servers.
• Managed DB2 table changes to support application design and development efforts.
• Planned and implemented HADR High Availability Disaster Recovery environment by preparing Primary database and Standby database, configuring parameter and cloning the primary database to Standby.
• Setup and maintained db2 udb data replication from Linux boxes to SQLServer 2005 boxes.
• Changing instance level and database level configuration parameters for database concurrency, authentication, performance and allowing remote clients accessing server.
• Experience in application database backups, reorgs, migration between environments.
• Converted Oracle server databases to SQL Databases using SSMA to reduce maintenance cost.
• Maintaining the AWS portal in creating the databases and archiving the logs and data in AWS.
• Participated in Maintenance activities of AWS cloud. Writing stored procedures, functions and complex T-SQL queries in AWS Cloud.
• Handled Performance Tuning and Optimization of slow running queries.
• Detected and resolved CPU, memory, I/O, disk space and other resource contention issues.
• Performing routine tasks like disk space check, Consistency checks, looking for slow/long running queries and hung jobs.
• Experience in SQL joins, sub queries, tracing, usage of Table Variables, Temp tables etc.
• Maintained the table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans, SQL Server Profiler and Database engine tuning Advisor.
• Experience in installation and implementing OEM and TOAD and setup of Oracle Grid Control
• Implemented Encryption of data on stand-alone instances and AOAG instances using Master Keys, TDE and Certificates.
• Performed Backup compression using third party tool Delphix and EMC DDBoost.
• Performed database maintenance tasks using Third part tool Idera and SQL Monitor.
• Upgraded SQL Databases and changed compatibility levels, configured and implemented AlwaysOn availability. Generated Scripts for lower version of SQL Server, Changed Compatibility level and data and log file location, executed the scripts using cmd commands.
• Created Shared storage, created machine user names to resolve configuration issues in AlwaysOn availability setup.
• Worked on SAP HANA data migration and Oracle Server Data Migration to SQL Servers and Azure Data warehouse using SSMA, SSIS and Data Factory.
• Involved in Migrating data to target databases and capturing changes during Migration through AWS DMS.
• Upgraded/Migrated SQL Server 2008/2005 databases to SQL Server 2014/ SQL 2016 databases and mentored Jr.DBAs and other technical staff.
• Implemented changes on C#.net applications for functional changes along wif database SP changes.
• Replicating only data changes on source databases using AWS DMS and DBMS.
• Implemented Data security wif Data Masking on SQL 2016 after upgrade.
• Implemented Column Stored indexes, Temporal Tables and Memory Optimized tables of SQL 2016.
• Involved in Creating the Tableau reports using Tableau Desktop Tool.
• Designed views in Tableau Desktop dat were published to internal team for review and further data analysis and customization using filters and actions. Generated report schedules on Tableau server.
• Worked as Tableau architect in standardizing Tableau for enterprise wide deployment.
• Created builds in Team foundation Servers (TFS) for deploying Master scripts in UAT ad Production environments.
• Monitored Log shipping/ Transactional Replication and trouble shooting of errors.
• Configured data partitioning/table partitioning on huge tables containing millions of rows for better performance. Trouble-Shooting Performance issues wif Jobs, Stored Procedures and queries.
• Setup the performance counter by using performance monitor to identify the bottleneck of windows server such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
• Captured changes from logs into CDC change tables by enabling CDC stored procedures.
• Worked on Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT etc. and used configuration files and variables for production deployment.
• Implemented AlwayOn Availability between Primary and secondary Production servers wif configuring Shared Witness server and Windows Failover cluster.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Determined user/business/functional requirements. Created vision, scope, and use case documents; business process models, use case diagrams, activity diagrams, and state chart diagrams.
• Configured and implemented SAVIOM project management, after testing Change Point and NetSuite Project management and Resource Management.
• Responsible for creating and maintaining API interfaces between applications and databases.
• Experienced in extracting data from Development / UAT / Production servers by using SSIS.
• Upgraded SQL servers from 2005 and 2008 versions to SQL 2014.
• Provide database coding to support business applications using PL SQL, T-SQL.
• Design and develop reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
• Migrated databases among the servers using copy, attach/detach, copy/restored utilities. Worked on SQL Server Integration Services (SSIS) for data integration from heterogeneous data sources, Adhoc request and ETL related operations.
• Implemented Windows jobs using shell scripts SSIS transformation using VB.Net.
• Supported 24X7 in production issues and User’s issues on applications.

Environment: Toad for data modeler, Windows Server 2012 Enterprise Edition, SSMA, MS-SQL Server 2016/ 2014 /2012 / 2008 R2 / 2005, IIS, SharePoint, Clustering, VB.Net scripting, Tableau Desktop/Server9.3, SSIS, SSRS, PL SQL, T-SQL Visual Studio 2013, SSAS, SSIS, Toad, Indexes, Cluster, .Net Framework 3.5, 4.0, snapshot, backup/restore, MS Office suite 2010

Confidential, Lees Summit, MO

SQL Server DBA

Responsibilities:

• Create and maintain various databases for Production, Development and UAT Testing environments using SQL Server 2008/2012/2014
• Created, scheduled and managed all the database maintenance plans using SSIS packages in all the SQL servers across the environment.
• Proficient in Data Migration from sources like MS Access, SQL server, Text Files, Excel to SQL server 2014/2012/2008R2 using SQL Server Integration Services (SSIS)
• Well-versed wif database Installation, configuration, maintenance, monitoring, backups and recoveries, develop and debug Stored Procedures and Triggers
• Experience in creating SQL Logins, Roles and Authentication modes as a part of security policies for various categories of users.
• Created Shared storage, created machine user names to resolve configuration issues in AlwaysOn availability setup.
• Created reports and deployed on SharePoint Servers. Created users and User roles on SharePoint servers.
• Implemented AlwayOn Availability between Primary and secondary Production servers wif configuring Shared Witness server and Windows Failover cluster.
• Experience in using BCP and Bulk Insert commands while working wif Flat files
• Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexing updates
• Used SSRS for creating various reports in the company in a daily basis on DEV and the production databases.
• Good knowledge in developing and designing reports through SSRS and Excel.
• Involved in migrating the databases from SQL server 2005/2008 to SQL server 2014.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Created logical and physical databases for various applications.
• Involved in creating scheduled full and transactional log backups in all the test and Development environments.
• Involved in monitoring the proper usage of the disk space on the physical drives of the server and provide the management as of utilization (space, Performance and capacity).
• Used DBCC commands to check physical and logical consistency of the databases and to rebuild indexes.
• 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.
• Create new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2008
• Generated reports using SSRS, Excel (Pivot) dat could be used to send information to diverse group of users, clients, and managers
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases
• Responsible for creating the reports basing on the requirements using SSRS 2013.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way dat they can be dynamically deployed into Dev, Test and Production Environments
• Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS). Involved in Deployment and Administration on SSIS packages wif Business Intelligence development studio. Developed, monitored and deployed SSIS packages.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. dis involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Environment: SQL Server 2008/2012/2014 Enterprise, Windows Enterprise Server 2012, .NET, Microsoft Visio, SFTP, Microsoft Reporting Services, SSAS, SSIS Packages, SSRS

Confidential, San Francisco, CA

SQL Server DBA

Responsibilities:

• Perform business analysis, technical analysis, systems design, application software programming.
• Prepared DFD's & Entity Relationship(ER) diagrams.
• Restructuring the stored procedure, designing, coding and developing the same using the T-SQL Programming. Transferring the data (ETL) to Data warehouse using Informatica and SSIS.
• Extensively worked on Dynamic Management Views in SQL Server 2008 R2.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• Managed the migration of SQL Server 2000/2005 databases to SQL Server 2012.
• Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Performed daily tasks including backup and restore by using SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, Extended Events, SQL Server Agent, and Database Engine Tuning Advisor.
• Extensively worked on Data Partitioning and Snapshot Isolation in SQL Server 2012.
• Re-engineering Customer Cognos and People Soft modules into SQL Server 2005 Integration Services.
• Prepared the project management and technical documentation.
• Unit Testing the SSIS packages wif respect to its flow and performance issues. Solving the Bugs Reflected by the Testing team.
• Monitored and modified Performance using execution plans and Index tuning. Rebuilding the indexes at regular intervals for better performance. Managing the VERITAS net backups.
• Extensively worked on DBCC commands and Dynamic Management Objects.
• Expertise in SQL Server Reporting Services and SQL Server Analysis Services.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Complete documentation about the database. Recovering the databases from backup in disasters.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.

Environment: SQL Server 2012/2008/2005, Oracle 10g/ 9i, .Net Framework 2.0, C#.Net, Asp.Net2.0, JavaScript, VSS, Windows 2000, Windows 2003 Server, MS TFS, MS-Access.

Confidential, Indianapolis, IN

SQL Server Database Administrator

Responsibilities:

• Handling roles of Database Administrator, T-SQL Programming, VB.Net, SSIS, SSRS, SSAS and application Support.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Monitored and modified Performance using execution plans and Index tuning.
• Supported Kronos and Concur application, created Root cause Analysis documents for priority tickets
• Deploying new code release to UAT and Production Environments using Team Foundation Servers (TFS).
• Perform SQL Server service pack and Windows Service pack upgrades.
• Working wif customers on Application rollouts and server migrations.
• Extensively worked on Enterprise Manager for managing the database.
• Troubleshoot performance problems and fine-tuning of databases.
• Involved in Index Analysis and Performance Tuning.
• Worked wif different upstream team for downloading ETL DATAMART data.
• Recovering the databases from backup in disasters.
• To analyze long running slow queries and tune the same to optimize application and system performance.

Environment: SQL Server 2008 R2/2005, SQL Server 2000, Windows 2003/2000 Server, SQL LiteSpeed 4.5, MSE, ME Change Request, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler.

Confidential

SQL Developer/DBA

Responsibilities:

• Performed extensive data extraction from web and other sources and handled data
• preparation - missing values, formatting, transformations using SSIS.
• Handled migrations from DTS to SSIS 2005 and 2005 to 2008.
• Written Stored Procedures and SQL scripts both in SQL Server and Oracle to
• implement business rules for various clients.
• Designed T-SQL scripts to identify long running queries and blocking sessions.
• Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions.
• Data migration (import & export - BCP) from Text to SQL Server
• Implemented Error handling using Try-Catch Block in stored procedures.
• Developed Backup and Restore scripts for SQL Server 2005
• Installed and Configured SQL Server 2005 wif latest service packs.
• Created database objects like tables, views, indexes, stored-procedures, triggers, and user
• defined functions
• Developed administrative tasks of SQL Server of performing daily Backups and
• Recovery procedures.
• Worked wif the developing team in the Writing functions in Visual Basic 6.0 for Upload
• download functionality, Data transfer and migration.
• Prepared daily and weekly status reports and collaborated wif other team members
• Created and managed schema objects such as tables, views, constraints, indexes,
• functions, procedures, and triggers and maintained Referential Integrity.
• Customized the stored procedures and database triggers to meet the changing
• business rules.
• Implemented indexes for performance tuning.
• Data loaded into the database using SSIS 2005 from flat files.

Environment: SQL Server 2005, SQL Server 2000, Oracle 9i, Visual Basic, Windows 2005SSIS, SSRS.