Sureshbabu Babu

Mobile: 267-***-****.

Lawrence Township, NJ – 06948.

Email Id : adgxtr@r.postjobfree.com

Skype ID : Sureshbabu.babu

Linkedin Profile: www.linkedin.com/in/sureshbabu-babu-89b48a1a

PROFESSIONAL SUMMARY:

Having over 10+ years of experience in database administrator, Consultant, architecture by focusing on Database (Microsoft SQL Server) as my core expertise. I have reduced the SQL Server build/ license cost by implementing the Multi-tenant database architecture and other service improvement plans in my current organization.

EDUCATION – MASTERS IN COMPUTER APPLICATIONS

TECHNICAL SKILLS:

SNO

Skill

Detail

1

Operating System

MS-DOS, Windows 95/98, NT 4.0, Windows XP, Windows 2000, Windows 2003 /2008,2012/2016 Linux

2

Database Versions

SQL Server 2000/2005/2008/2008R2/2012/2014/2016/2017.

MySQL 8.0.

3

Web Servers

PWS,IIS.

4

Development expertise

Visual Basic 5.0/6.0, HTML, VBScript, XML and ASP, Power Shell.

5

Tools Used

SQL Server Management Studio, T-SQL, Query Analyzer, SQL Profiler, Replication, Clustering, Database Tuning Advisor, Upgrade Advisor, SQL Configuration Manager and Service Manager, Activity Monitor, Performance Monitor, Resource monitor, SSIS, SSRS, SSAS

6

Monitoring Tools

Tivoli, MOM,BPPM, Idera

7

Backup Software

Lite Speed, Net backup, Commvault

8

SQL Server Patching

SCCM

9

Ticketing

Hp- Service Center, Remedy, Service now.

PROFESSIONAL EXPERIENCE

• Installation, configuration and maintenance of database systems and associated technologies.

• Architecture support for database server installation and configuration.

• Database high availability setup like SQL clustering / always on / database mirroring / replication and log shipping.

• SQL Server consolidation – by migrating SQL 2000/2005 Server to SQL 2008 / 2012 Shared Servers.

• Mysql 8.0 version database server installation and support on cloud as well as on premises databases .

• Commvault backup configuration for SQL Servers by backup policy definitions.

• Idera, SCOM monitoring configuration for SQL Server monitoring and integration with service now ticketing tool.

• Multi-Tenant architecture database model has been implemented and saved around 300K to organization.

• Capacity and resource planning for database server’s infrastructure.

• SQL Server Patching through SCCM tool.

• Performance tuning of database servers and its related issues.

• Database auditing, security and integrity configuration / verification.

• Supports for development projects throughout the project life cycle.

• Automation of database maintenance by power shell scripting.

• Plan and implementation of physical to virtual (P2V) of database servers.

• VM- Console administration, like taking the VM snapshot etc.

• MS SQL Server License optimization.

• Planned for database server license management.

• SharePoint site has been designed and created for documentation.

• Created Database standards and work instructions, IQ’s, WPD’s.

• Created DR- Plan and executed in specific interval based on RPO and RTO.

• Proficient in designing & implementing various solutions for effective SQL server administration.

• Performed migrations from SQL Server 2000 to 2005 and 2008 R2, SQL Server 2005, SQL Server 2008 to SQL Server 2012.

• Expertise in applying Service Packs, Hotfixes and any Critical Security Updates released by Microsoft.

• Experience in Database Backup, Recovery and Disaster Recovery procedures.

• Strong experience in monitoring database performance and tuning using various native tools namely Performance Monitor, Activity Monitor, SQL Profiler, SQL logs and Third Party Tools like Idera.

• Experience in Query Optimization techniques using DMV's and DMF's, DBCC commands, Index Rebuild / Reorganizing and also used tools to identify slow running queries using Server-side tracing.

• Worked on SQL Server Replication that is Snapshot, Transactional &Merge.

• Experience in controlling the user privileges, monitoring the security and Audit issues.

• Experience in deploying reports in a reporting server and providing required permissions to users on the reports in reporting server.

• Experience in implementing SSIS packages, Scheduling Jobs, Setting up Alerts & notification using Database Mail.

• Performed Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, and BCP.

• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.

• Built effective queries for high-performance reports and rendered them to HTML, XML, PDF and Excel formats using SSRS.

• Worked in designing of SSIS packages for integrating data using OLE DB connection from heterogeneous sources(Excel,CSV,Flatfile,Text format data) by using multiple transformations provided by SSIS such as Aggregate, Data conversion, conditional split, bulk insert, fuzzy grouping.

• Designed scripts using T-SQL for getting information about history of backups and restoration, database space utilization, alert for critical errors or events, resource intensive queries and general monitoring and maintenance tasks.

• Experience in creating the stored procedures, triggers, tables and other sql joins and statements for applications by using T-SQL.

• Experience in writing T-SQL (DDL, DML, DCL and TCL).Reviewing T-SQL code, maintaining coding standards across the board in all SQL server environments.

• Review of physical and logical database design, promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.

• Involved in various projects from start to production deployment, guiding development team for efficient performance and planning capacity.

• Implementation of database servers (P2V) for Data Center Movement.

Work Experience

Database Admin Professional – TEVA Pharmaceuticals Inc, US Sep 2016 - Till Date

TEVA Pharmaceuticals Inc is an international pharmaceutics company is ranked among the 10 top pharmaceuticals companies in the world., TEVA develops, produces and markets affordable generic drugs as well as innovative and specialty pharmaceuticals and active pharmaceutical ingredients. TEVA is active in 80 countries with 58000 dedicated employees worldwide.

Responsibilities:

Working as Database administrator supports over 1200 - MSSQL Database Servers . Installation, configuration and maintenance of database systems and associated technologies. Database supports as follows: Architecture support, standard and documentation, high availability setup, upgrades, resource management, schema management, capacity planning, performance tuning, applying service packs, auditing, security and integrity verification, code promotion, supports for development projects throughout the project life cycle. Maintenance by Powershell and UNIX scripting. physical to virtualization of database server, license management, SQL Server Patching through SCCM, configuration of commvault backup for database servers.

Primary job responsibilities are providing technical support for databases that includes MS SQL databases as installation, configuration and maintenance of database systems and associated technologies (including SQL Server 2005, 2008, 2012, 2014, 2016, 2017).

Other responsibilities include; Database architecture support, applying optimum access techniques, database standard and documentation, database high availability setup (Clustering, DB Mirroring, Replication, Log shipping), database upgrades, resource management, database schema management, capacity planning, performance tuning, applying patches, database auditing,security and integrity verification, database code promotions.

Department project planning and management, Database supports for development projects throughout the project life cycle, coordination of internal teams (server, storage, backup and network administration with developers) to troubleshoot database infrastructure related issues; database backup recovery plans, automation of database maintenance functionality by power shell and UNIX scripting. Planning and implementation for physical to virtualization of database server.

Disaster recovery plan based on RPO and RTO. Database inventory update and maintenance.

Database license management, database analysis, modeling and reporting services, Implementation of Multi-Tenant Architecture database model.

Review of physical and logical database design, referential data integrity,

Configuration of commvault backup, Idera monitoring, OEM 12C monitoring .

Providing on-call support and implementing the service improvement plans.

Technical environment / Tools (MS SQL Server, Windows, Oracle, Linux, Service now, Commvault backup, Idera Monitoring, Key Pass, SQL Management Studio, T-SQL,SQL Profiler, Activity Monitor, Data Collector,Performance Monitor, Database tuning advisor, SCOM, SSRS,SSIS and SSAS).

SQL Server database administrator – HCL America, Inc, US.

CLIENT: SHIRE PHARMACEUTICALS, CHESTERBROOK, PA Nov 2011 to Sep 2016

SHIRE is a global specialty biopharmaceutical company listed on the London and NASDAQ exchanges, with major operations in Basingstoke, UK, Wayne, PA and Lexington, MA and a network of offices and distribution channels throughout Europe, South America, Canada, and the Pacific Rim. Shire Organization of 5,000 Employees in more than 25 countries.

SHIRE has 4 datacenters spread across USA & UK: Basingstoke – UK, Cambridge – UK, Chester brook – US, Lexington – US.

Responsibilities:

Worked as Senior DBAs responsible for 350+ SQL Servers in OLTP and BI/warehouse environments. Managed staff priorities and represented IT operations as member of change control Board and Crisis Response Team. Status report to executive team and served as a liaison to other IT groups in planning, budgeting, deployment, and production support.

• Multi-Tenant Architecture database model has been implemented and saved operation and maintenance cost to organization..

• Created Database standards and work instructions.

• Created DR- Plan and executed in specific interval based on RTO and RPO.

• Created Health – Check reports to monitor the server health checks and database backup’s status.

• Performed migrations from SQL server 2008R2 to SQL server 2012

• Implemented and Maintained Clustering (active/active, active/passive) as a high availability procedure.

• Implemented and Maintained Database Mirroring.

• Involved in troubleshooting and fine-tuning of databases for its performance and concurrency.

• Performing query optimization and performance tuning using native tools like performance monitor, resource monitor, profiler, DMV'S and built in performance reports.

• Resolving blocking and deadlock issues using activity monitor and system stored procedures.

• Applying required Service Packs, Hotfixes and any Critical Security Updates in clustered and standalone servers.

• Created and deployed reports in reporting servers.

• Worked in designing of SSIS packages for integrating data using OLE DB connection from heterogeneous sources(Excel,CSV,Flat file,Text fomat data) by using multiple transformations provided by SSIS such as aggregate, data conversion, conditional split, bulk insert, fuzzy grouping.

• Moving/Copying of databases from one server to another server using Backup-restore, Attach and detach methods and refreshing databases in development, QA and stage environments using production backup.

• Designed scripts using T-SQL for getting information about history of backups and restoration, database space utilization, alert for critical errors or events, resource intensive queries and general monitoring and maintenance tasks.

Technical environment / Tools (MS SQL Server, Windows, Oracle, Linux, Remedy, Service now, Symantec NetBackup, Commvault backup, BPPM Monitoring, Management Studio, T-SQL,SQL Profiler, Activity Monitor, Data Collector,Performance Monitor, Database tuning advisor, SCOM, SSRS,SSIS and SSAS)

SQL Server Database administrator - HCLTechnologies Ltd

Chennai, India.

CLIENT : RBS (Royal Bank of Scotland), UK Nov 2010 to Nov 2011

RBS (Royal Bank of Scotland) is one of top banks in UK, Maintained and supported for around 2000 production SQL Database Servers.

Responsibilities:

• Responsible for installing and maintaining SQL Server 2005, SQL 2008 R2 Cluster environment.

• Performed migrations from SQL server 2005 to SQL server 2008,2008R2.

• Applying existing servers with relevant Service Packs, Hotfixes and any Critical Security Updates released by Microsoft.

• Implemented High availability & Disaster Recovery procedures, Cluster (active/active, active/ passive), DB Mirror, Replication and log shipping.

• Configured the Transactional, Merge and Snap shot replications.

• Implementing backup restores and logs shipping.

• Managing alerts, managing security, Re-indexing/Reorganizing Indexes, performing DBCC checks.

• Monitoring locking/blocking and space management issues

• Scheduling jobs and monitoring and troubleshooting them.

• Moving/Copying of Databases from one server to another server using Backup-restore, Attach and detach methods.

• Involved in troubleshooting and fine-tuning of databases for its performance and concurrency.

• Implementation of SQL Logins, roles and Authentication Modes as a part of Security Policies for various categories of users.

• Scheduled Backup/Recovery jobs and developed Disaster Recovery Plans.

• Expert in Using DMV's, Performance dash board, Mirroring, database snapshot.

• Analyzed long running /slow queries and tune the same to optimize application and system performance.

• Created and maintained data objects such as tables, views, indexes, referential integrity depending on user requirements and converting them to technical specifications.

• Involved in various projects from start to production deployment, guiding development team for efficient performance and planning capacity.

Environment: SQL Server 2012/2008R2/2008/2005, Windows 2008 server, Windows Server 2008(x64), SQL Server Management Studio, T-SQL,SSRS,SSIS,SQL Profiler, Activity Monitor, Data Collector,Performance Monitor, Database Tuning Advisor,Tivoli storage manager, litespeed etc.

SQL Server Database administrator - IBM India Ltd, Chennai, India

Client: Anthem Inc, US (Previously known as WellPoint, Inc.) June 2009 to Nov 2010

WellPoint is the one of leading insurance company in US (currently Anthem Inc), Maintained around 350 production servers and 700 SQL Database instances.

Responsibilities:

• Experience in SQL Server 2005/2008/2008R2 installation, Configuring, Deploying applying patches, upgrade, troubleshooting and operations.

• Experience in database backup and disaster recovery procedures.

• Created and maintained the SQL 2008 R2 Cluster environment.

• Perform Database upgrades from SQL server 2005 to SQL server 2008/2008R2.

• Experience in High availability & Disaster Recovery procedures, Cluster (active/active, active/ passive), Replication and log shipping.

• Managing alerts, managing security, Re-indexing/Reorganizing Indexes, performing DBCC checks.

• Monitoring locking/blocking and space management issues

• Scheduling jobs and monitoring and troubleshooting them

• Monitoring SQL/Windows/application/security event logs, Monitor and support client server databases on Windows 2003/2008 R2 servers.

• Moving/Copying of Databases from one server to another server using Backup-restore, Attach and detach methods.

• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency

• Experience in query optimization and performance tuning.

• Implemented SSIS (SQL Server Integration Services) packages .

• Maintaining high availability of SQL servers by proactively monitoring the critical services in a 24*7 support environment.

Technical Environment / Tools ( MS SQL Server, MS - Windows, Management Studio, SQL Profiler, Activity Monitor, Data Collector, Performance Monitor, T-SQL, Data Compression, Resource Monitor, Tivoli Monitoring, HP – Service center, Symantec net backup )

SQL Server database administrator - Satyam computers Ltd (Acquired by Mahindra Satyam)

Chennai, India.

CLIENT: Verizon Data Services, US Feb 2008 to June 2009

Verizon Communications, Inc., is a broadband telecommunications company and the largest U.S. wireless communications service provider

Responsibilities:

• Worked in creating the database based on modeling and normalization.

• Working with application team to create the stored procedure, functions and queries.

• Working with application team to create DTS packages based on application requirement.

• Creating and managing Transactional, snap – shot replications.

• Creating and deploying the coding (Contains new latest updates new enhancement of the releases).

• Fine tuning DTS packages and procedures and quires.

• Managing alerts, managing security, Re-indexing/Reorganizing Indexes, performing DBCC checks.

• Troubleshooting locking/Blocking issues.

• Monitoring and resolving space management issues.

• Scheduling jobs and monitoring and troubleshooting them.

• Exporting and importing databases using attach/detach or backup and restore.

• Experience in controlling the user privileges, monitoring the security and audit issues.

• Monitoring SQL/Windows/application/security event logs Monitor and support client server databases on Windows 2003/2008 R2 servers.

• Applying patches/hotfixes to SQL server.

• Performing query optimization and performance tuning using native tools like performance monitor, resource monitor, profiler, DMV'S and built in performance reports.

• Performed both in place and side by side database migration from SQL server 2005 to SQL server 2008/2008 R2.

Technical Environment / Tools ( MS SQL Server, MS - Windows, Management Studio, SQL Profiler, Activity Monitor, Data Collector, Performance Monitor, T-SQL, DTS,SSIS, SSRS, Transactional Replication )

SQL Server database administrator - Citi Technology Services Ltd, (Citigroup)

Chennai, India.

CLIENT : CITIBANK, US Feb 2006 to Feb 2008

Citi Technology Services was providing infrastructure support for the world’s largest banking and financial sector – Citibank.

Responsibilities:

● Maintained and supports around 250 SQL database servers.

● Migrated several PROD database servers with minimal downtime.

● Supported reporting applications, and other sub systems dependent on SQL server.

● Monitor production databases for performance, availability and data integrity.

● Configuration and maintenance of database mirroring.

● Scripted several database maintenance tasks reducing manual processes and related overheads .

● Performed data recovery from corrupt databases by restoring the backup .

● Set up SQL/database mail to produce database health reports and other alerts.

● Managed production deployments of schema changes and data conversions .

● Created SSIS packages for data transfers, Import/Export and migrations .

● Recreated indexes, optimized queries, memory management to improve performance .

● Database space management, log files and data integrity.

● Created and managed full-text server, linked servers .

● Administered SQL server security and kept up-to-date through frequent audits of SQL logins .

● Tested and installed latest SQL server / Windows server service packs on all SQL servers .

● Integrated SQL Server with Windows Active directory security for database/table level permissions.

● Created strong passwords for SA account, sometimes disabled it, remove sample databases .

● Ran Microsoft Baseline security analyzer periodically to check for SQL server security issues .

● Worked on database maintenance (including DB changes, DB patch, DB index tuning) .

● Managed SAN storage system .

● Monitored and configured the database backup by using Light speed backup tool.

● Documented DB structures and functionalities.

Technical Environment / Tools ( MS SQL Server, MS - Windows, Management Studio, SQL Profiler, Activity Monitor, Data Collector, Performance Monitor, Light Speed backup tool, T-SQL, DTS,SSIS, SSRS )

SQL Server database administrator – Manipal Hospital

Bangalore, India.

CLIENT : Manipal Hospital. Mar 2005 to Feb 2006

Manipal Hospitals is part of the Manipal Education and Medical Group (MEMG), which pioneers in the field of education and healthcare delivery.

Responsibilities

• Exporting and importing databases using attach/detach or backup and restore.

• Controlling access permissions and privileges.

• Implementation of SQL logins, roles and authentication modes for various categories of users.

• Managing alerts, managing security, Re-indexing/Reorganizing Indexes, performing DBCC checks .

• Monitoring Server capacity and Daily health checks for the Database servers.

• Troubleshooting Locking/Blocking issues.

• Troubleshooting space management issues.

• Created queries and store procedures and generate the output to excel file.

• Applying update/patch to SQL server.

Technical Environment / Tools ( MS SQL Server, MS - Windows, Management Studio, SQL Profiler, Activity Monitor )

Contact this candidate