Sql Server Data

Suresh Kumar Gopalan Mobile No : 650-***-****

Sr SQL Server DBA E-mail: **************@*****.***

Professional Summary

I have 11 years of experience in Database Administration & Architect, working as Production/Engineering DBA. Expert in 24x7-production support, MS SQL Server versions 2000 to 2016 in Prod/Dev/Stg environments, Data Compression, Backup compression, Resource Governor, Performance Data Collector, Policy based management system and Transparent Data Encryption, Query Performance and Disk usage activity statistics via Performance Data Collection. Implemented SQL Server new concepts like Online Index-ing, Dedicated Admin Connection(DAC), Performance Dashboard, Data Base Snapshot, Common Table Expression (CTE), DDL Triggers and DMV & DMF. Expert in modeling/building High availability Clusters, SQL Server log shipping, Database Mirroring, Backup/Recovery, Replication & Disaster recovery solutions across datacenters, Always On & Availability groups configurations. Experience in Managing SharePoint SQL server databases. Expertise in Database Design, Performance Analysis, and Production Support for huge databases (VLDB) and handled Complex Databases up to 5 Terabytes sizes.

Extensively used SSIS, SSAS & SSRS for various BI requirements. Experience in data migration (using tools like DTS, BULK_INSERT, BCP) between different homogeneous/heterogeneous systems and SQL Server as a part of data Migration.

Experience in Migrating SQL 2000 to SQL 2005 & SQL 2005 to SQL 2008, SQL 2008 R1 to R2 upgrades, and SQL 2012 to SQL 2016 using suitable approach.

Very good in automating process using Powershell, SSIS, SSRS & SSAS data driven alerts.

Developed remarkable tools and processes for various projects.

Worked as a Technical Lead for Onshore/offshore (24x7) team consisting of 20+ members, which earned me good experience in managing/documenting every piece for long-term stability. I was part of database hosting company, which owns 2000+ servers in its private cloud.

Oracle DB & Bi-directional Golden Gate Replication (Active –Active)

I am having hands-on experience in setting up, managing and configuring Oracle golden gate replication between SQL servers, tandem. Currently I am primary DBA for large-scale commercial systems where bi-directional golden gate replication has implemented.

Have strong skills on all the tasks like adding table, column, and filters tuning parameters

Have good experience in managing the replicated DBs, fixing the data issues and supporting Zero downtime with application release process.

Certification

Completed Oracle 11G SQL fundamentals certification and working on further certifications to strengthen my skills.

Mango DB & PostgresDB

I have midlevel experience in managing 50+ MongoDB’s. Completed MongoDB M102: MongoDB for DBAs certification. Working to complete the below two certifications,

M101P: MongoDB for Developers

M034: New Features and Tools in MongoDB 3.4

Have good experience in the below tasks,

1)Mongo db installation & configuration on Windows & Linux

2)Creating Database, user, collection

3)Creating Index/Configuring replica set & Sharing /Creating, reading and updating data

4)Backups /Data imports

I have mid-level experience with managing Postgres database, as I play a major role in migration project within VISA to migrate from Postgres to SQL server.

Current Professional Experience:

1/15/2014 to Present

VISA Inc

Staff Database Engineer

VISA is one of the largest financial operations corporations. I am part of DBE (Database Engineering /Operations) team, working as Sr SQL Server DBA. DBE team works with global internal VISA clients to implement solutions, applications across the enterprise including the below tasks,

SQL Data Architecture preparation for implementing tools/Applications

Highly Secured Database server support and configurations

Always on solutions for disaster recovery & availability

VBlock VMware SQL clusters and Latest storage technology

1000+ Servers, Encrypted n/w and security best practices for SQL Servers

Huge Databases up to 2 TB

Critical Bi-directional Golden gate replicated Databases

ARX encryption /decryption tasks on the database tables

Large Physical servers for active-active implementation

SQL Azure & cloud DB

Working with application team to implement database solutions

Always on configurations and server setup on windows standalones/VM wares

Availability groups configurations on SQL server

Server /Database level CPU,memory performance tuning

Capturing Perfmon counters and providing performance reports

Implementing security and monitoring tools for databases

Engineering and designing solutions for all applications

AVAMAR backup configuration and management

SQL server services and functionalities best parties research

Security and compliance policies implementation on SQL server

Data protection & privacy configurations on sensitive databases

Availability groups configurations on SQL server

07/23/2008-01/14/2014

CHEVRON CORPORATION /Tech Mahindra

Sr SQL DBA

Chevron is one of the largest integrated energy OIL companies in the world. Headquartered in San Ramon, California, they conduct business in approximately 180 countries, and are engaged in every aspect of the oil and natural gas industry, including exploration and production, refining, marketing and transportation, chemicals manufacturing and sales, geothermal and power generation.

I was part of team, which manages SQL Server environment with,

1000 VM SQL Server standalones

400 Physical clusters

80 VM clusters

1000 Mirror Databases

100 Transaction replication

15 Worldwide Data centers

5TB Database

I have handled the below tasks,

Building SQL Server 2008/2012/2014 Failover clusters/ non clusters /AG clusters

Installing and configuring SSRS Scale out sites

SQL server 2008R1 to R2 in Place upgrade

Rollout Patching process for clusters

Implementing and maintaining SOX and IP compliance controls

Applied latest SQL hot fix and Services pack on active/active and active/passive clusters and multi instance stand-alone server and lab environments.

Setting up database mirroring for high availability of data and disaster recovery.

Setting up, monitoring and troubleshooting Merge and Transactional Replication

DTS package Migration to SSIS

Analysis of the existing setups and specifications of the Project and documentation of processes.

Executing DBCC commands periodically to check database consistency, and rectifying the errors reported.

Migration, In place upgrade

Automation

I had developed new innovative tools using OSQL, Robocopy, T-SQL scripts and deployed successfully across Chevron environment which reduced manual work and was fully automated,

Auto Refresh: A solution for restoring databases in various environments like dev, QA, with production database.

Audit Compliance Report (SSRS): Report about servers compliance, which will send e-mail if any control fails.

Disaster Recovery Process: SP generates restore script, login and users script which will be shipped to DR location.

Evergreen Inventory process: SSIS packages and SSRS dashboards developed to maintain all supported servers list

02/13/2008 to 07/14/2008

Sryas Software Pvt Ltd

Sr SQL DBA

Sryas is a global provider of Information Technology services and Business solutions and is among the fastest growing IT services companies. Sryas growth powered by deep understanding of business and technology and our passion for innovation. Sryas understands the importance of leveraging IT not just as a Business utility, but also as a strategic driver to gain competitive advantage. As a diverse end-to-end IT solutions provider, Sryas offers a wide range of expertise, aimed at helping customers re-engineer and add value to their businesses. Sryas ubiquitous expertise combined with extensive experience in creating seamless solutions will help organizations emerge successful in the ever-evolving age of business dynamics.

I had performed the below tasks,

Performance Tuning - Tune, analyze and optimize costly queries to reduce logical disk I/O for effective performance.

Create and re-evaluate Indexes and make needed modifications for better performance.

Creating and Reviewing Security features for all the servers.

Designing demoralized database warehouse tables by analyzing the clients data design and model

Creating tables base on Facts and Dimension required for Cube development.

Creating SSIS packages for the ETL operations to push data inside warehouse

Performance Tuning of SSIS packages and Cleaning Data and validating data inside packages.

Maintaining and Monitoring SQL Jobs

Disaster recovery plans

Migration from sql 2000 database to sql 2005 and 2008

Implementing effective coding standards in development teams

10/18/2007-02/08/2008

Ramco Systems Limited

Analyst Programmer

Ramco, part of the Ramco Group, has delivered enterprise software and services since 1989. Today, Ramco is a global provider with customers in 35 countries and more than 1,800 employees in nine countries. Ramco provides ERP solutions, on demand ERP, support and consulting. Ramco has been delivering ERP solutions to customers around the world for over a decade. Built using leading edge technology, the ERP products represent years of accumulated industry knowledge and expertise captured in an integrated application. Ramco ERP products based on Ramco Virtual Works to provide companies with the flexibility they need to rapidly respond to evolving corporate imperatives, regulatory changes, and market conditions. Rather than re-deploy enterprise systems as the company reacts to these changes, the underlying platform can leverage business process models to quick new business assets for true “change on demand.”

In Ramco Aviation project, my responsibilities include,

Maintaining 10 Servers for different applications and environments

Setting up log shipping and troubleshooting.

Creating and managing DTS (Data Transformation Services) and Jobs.

Routine DBA activities like analysis of Space Availability, Backups.

Analysis of the existing setups and specifications of the Project.

Installing and configuring SQL server 2005 on windows server 2003 EE & Evaluation Edition on windows XP and setting up client /server connectivity.

Creating different instances and databases of sql server 2005 corresponding to the applications.

Migrating database from 2000 to 2005 using copy database wizard.

Migrating the existing internal audit application from Sql server 2000 to Sql server 2005

Migrating the DTS packages to SSIS.

Creating a backup strategy.

Performance Tuning of Huge Stored Procedures containing thousands of lines

Creating jobs, logins. Schemas and assign users permissions etc.

05/09/2006–10/17/2007

Meridian Apparels Limited

PROGRAMMER

Meridian Apparels Limited leading garment manufacturing company. It has business across all global customers. Implementation of Ramco ERP, development using Ramco’s E. Application (3.1) Extensible Development Kit for the front end screens, Ramco’s Report Writer 3.1 for creating reports and MS SQL Server 2000 as back end. Data drill down created with Ramco’s Dcube. Administration activities Like Back Up, Restore, Index Tuning, Creating Jobs, Data Transformation Services, and Trouble Shooting

Responsibities

MS SQL Server 2000 & RAMCO Marshall ERP

Perform backup, recovery procedures for SQL server databases

Create and Manage SQL server database users and security.

Manage Jobs, alerts and operators in SQL

Tuning the SQL Server for optimal performance

Import and Export Data.

Trouble shooting SQL Server Problems.

Creating EDK for GAP Analysis with Client for RAMCO ERP.

Report generation for the Ramco ERP using Ramco Report writer or Crystal Reports

Implementation of Ramco’s E. Application (3.1)

Developing new screens in various Modules Using Extensible Development Kit.

Customizing base screens according to the functionality of the client.

Performance Tuning Of MS SQL SERVER

Creating relevant Reports.

Customizing base screens according to the functionality of the client.

Functional Support in All Modules for End users like Bill Accounting, Inventory management

HR and Payroll Processing, Accounts Related issues

Technical Skills

Operating System : Windows 2003, Windows 2008 &R2, Windows 2012, Linux/Unix

Virtual Environment : VM ware, Hyper V,

Database Systems : MS SQL Server 2000, 2005, 2008, 2012, 2014 & 2016

Oracle Database 11g, Oracle Golden gate replication

Beginner : Mango DB 2.6, 3.4, Postgress DB, MySQL

Development : T-SQL, SQLCMD, OSQL, VBScript, Powershell.PL/ SQL

SQLPLUS

Business Intelligence : DTS, SSIS, SSAS, SSRS.

GUI Tools & Utilities : SSMS, BIDS, Enterprise Manager,

Query Analyzer, DTS Package, SQL Server Profiler,

SQL Litespeed, SQL Compare, Visual Studio 2005,

Toad for oracle, SQL developer

SQL Monitoring & Tools : IDERA monitoring, SQL Red gate, Litespeed, Quest tools

Education

Bachelor of Engineering (Computer Science)

Certification

Completed oracle 11 G SQL fundamentals certification

M102: MongoDB for DBAs certification

Current Learning

Preparing for remaining OCP exams

Training on Windows Server Core & SQL Server 2016

Contact this candidate