Post Job Free
Sign in

Manager Support

Location:
Antioch, CA
Posted:
August 06, 2020

Contact this candidate

Resume:

GURUDUTT G. DHARESHWAR***-***-**** ********.**********@*****.***

SUMMARY:

** **** ***** ** ** experience spreading across Food and Beverages, Banking and Insurance Industries in 24X7 environment

Strong skills in MS SQL Server database installation and administration.

Strong skills in Sybase ASE, Sybase Replication Server, database installation and administration.

Extensive experience in Banking industry - Possess good knowledge on Foreign Exchange, transaction Services, Fixed Income and Money Market.

Areas of Expertise:

Database Administration

Operations Management

Troubleshooting

Process Optimization

Research & Analysis

Strategic Planning

Interpersonal Skills

Mentoring & coaching

Organizational Skills

Detailed Documentation

Change Management

Synthesize diverse ideas

Technical Knowledge

Performance Testing

Client Support

Unique blend of technical &

business knowledge

Project Management

Personnel Management

DBA Skills

Installation and configuration of Sybase 15.0/12.5/11.9.2 in UNIX (Sun, AIX) and Windows NT 2000.

Installation and Administration of Sybase Replication Server 12.6

Database Administration tasks - User Management, Security, Backup/Recovery, Performance Tuning, Migration, up-gradation and Log shipping setup

Capacity Planning.

MS SQL Server 2016/2014/2012 design and administration.

Postgres administration

Resource & Cost estimation.

Negotiation skills on SLA with business.

Risk identification and Mitigation.

TECHNICAL SKILLS:

Hardware Platforms: HP 9000, Sun E4800, IBM R30, NCR S26/S40, Compaq Proliant 2000 in RAID, Micron PC Server, Dell PowerEdge.

Operating System: HP UNIX 10.20, NCR (AT&T) UNIX Release 4 System V, AIX 4.2 SCO UNIX 3.0/5.0.5, Sun OS 5.7, Linux 7.1, Windows 2003, Windows 2012

Cloud Technologies: AWS - Amazon RDS

RDBMS: Sybase 11.9.2/12.5/15.0,15.7,Replication Server ASE 15.0, MSSQL Server 2012, 2014, 2016. Postgres 9.6, 11.1

SQL Server Tools: SQL Server Manager, Sybase Central, SQL Advantage, Enterprise Manager, DB Artisan, Sysmon, BMC SQLBackTrack.

Development Tools: PowerBuilder 6.5//5.0/4.0, Visual Basic 6.0/5.0

Languages: T-SQL and UNIX Shell Scripts.

PROFESSIONAL EXPERIENCE

Client: Bay Alarm, California November 2019– Present

Designation - Database Administrator.

Role and Responsibilities include:

Production DBA supporting SQL server.

Planning and Designing HA and DR depending on application criticality

Planning for migration/upgrades with system architects and application team

Troubleshooting performance issues.

Architecture level designs for critical application database environments

Understanding business criticality and defining the high availability strategies

Planning and implementing backup strategies considering the Recovery Point Objective

Troubleshooting SSIS,SSRS and SSAS issues

Point-In time Recovery

Environment: SQL SERVER 2017/2012, SSRS, Shell Script, Postgres 9.6,

Client: Element Fleet, Maryland October 2017– October 2019

Designation - Database Administrator.

Role and Responsibilities include:

Project and Production DBA across the US\Canada region.

Planning for migration/upgrades with system architects and application team

Designing new Database environment depending upon business requirements

Planning and Designing HA and DR depending on application criticality

Coordinating the work with offshore.

Defining scope of project works

POC for new project discussions

Planning for migration/upgrades with system architects and application team

Coordinating the work with offshore

Troubleshooting performance issues.

Architecture level designs for critical database environments

Understanding business criticality and defining the high availability strategies

Planning and implementing backup strategies considering the Recovery Point Objective

Database upgrades- In-Place and Side-by-Side

Troubleshooting Transactional Replication and Log Shipping

Coordinate and drive DR drills

Troubleshooting SSIS,SSRS and SSAS issues

Point-In time Recovery

Client: United Health Care, Las Vegas, NV August 2016 – October 2017

Designation - Database Administrator.

Role and Responsibilities include:

Providing Prod Support for SQL Server Env.

To install new MSSQL server.

Designing new Database environment depending upon business requirements

Co-ordination with Developers to include modifications in the D/b in the form of deployments in the form of Fixes and builds for performance enhancement.

Monitoring and Maintaining the Replication/Log Shipping Services.

To interact with App Support to solve performance related problems and ensure smooth running of system.

Installing service patches.

Database performance/activity monitoring using internal tools.

Client: TIBCO Software Inc, San Francisco December 2015 – July 2016

Designation - Database Administrator.

Role and Responsibilities include:

Production DBA for TIBCO SQL support.

Designing new Database environment depending upon business requirements

Setting up SQL server on Cloud Env (AWS)

Design, implementation, and migration of databases to AWS.

Planning and Designing HA and DR depending on application criticality

Defining scope of project works

Planning for migration/upgrades with system architects and application team

Monitor virtual servers using vSphere

Architecture level designs for critical application database environments

New SQL instances installation/service pack installation using Internal Tools

Database performance/activity monitoring using SQL native tools, Toad, SCOM

Troubleshooting CDC (Change Data Capture)

Troubleshooting SSIS, SSRS and SSAS issues

Planning Database Maintenances

Client: Novartis Irving TX. October 2015 – December 2015

Designation - Sr. Database Administrator.

Role and Responsibilities include:

Production DBA for Novartis SQL support across the Globe

Database performance/activity monitoring using SQL native tools, Toad, SCOM

Troubleshooting Transactional Replication and Log Shipping

Planning Database Maintenances

Client: PEPSICO, Irving TX. October 2014 – October 2015

Designation - Sr. Database Administrator.

Being a team member of [BIS] at PepsiCo we provide 24 X 7 comprehensive Database Architecture and Administration support for MS SQL Server and Sybase applications. Its Service facilitates the implementation and maintenance of production database environments for the new and existing applications. BIS supports over 5000 servers globally and more than 30,000 databases.

Role and Responsibilities include:

Project and Production DBA for PepsiCo SQL support across the Globe.

Escalation DBA

Planning for migration/upgrades with system architects and application team

Designing new Database environment depending upon business requirements

Planning and Designing HA and DR depending on application criticality

Coordinating the work with offshore

Defining scope of project works

Transitioning SQL server legacy environment across to worked to Global Support

POC for new project discussions

Primary point of Contact for 600 plus instances

Planning for migration/upgrades with system architects and application team

Coordinating the work with offshore

Troubleshooting performance issues using SQL Profiler/Toad

Remediating vulnerabilities on the basis of Guardium Report

Monitor virtual servers using vSphere

Configuring and monitoring using MDW

Frequent Access validation

Architecture level designs for critical application database environments

Approving access requests on the basis of business requirements

Understanding business criticality and defining the high availability strategies

Planning and implementing backup strategies considering the Recovery Point Objective

New SQL instances installation/service pack installation using Internal PepsiCo Tools

Database performance/activity monitoring using SQL native tools, Toad, SCOM

Database upgrades- In-Place and Side-by-Side

Troubleshooting Transactional Replication and Log Shipping

Coordinate and drive DR drills

Working on replication, SRDF and Log shipping for Sybase Env.

Troubleshooting SSIS, SSRS and SSAS issues

Point-In time Recovery

Planning Database Maintenances

WIPRO TECHNOLOGY SERVICES, Mumbai, India October 2005 - October 2014 [Previously known as CITI Technology services, Citigroup Entity]

Sr. Database Administrator

Wipro Technology Services provides critical technology infrastructure support, development and deployment of strategic software applications to Citigroup. We provide 24/7 comprehensive Database Architecture and Administration support for Sybase, MS SQL Server, and Oracle applications. The Service facilitates the implementation and maintenance of production database environments for the new and existing applications. CMBIS and supports over 4500 servers and more than 30,000 databases.

Role and Responsibilities include:

Created detailed spreadsheets for tracking DBA build workflows and projects then relayed to the DBA team.

Identified risks related to server changes, incorrect collations, security, maintenance jobs and scheduling.

Responsibilities include builds, maintenance, business continuity, and troubleshooting of production SQL Server environments.

Managed database migrations for several datacenter server relocation projects.

Providing technical knowledge and support for application, developer, and project teams.

Isolated and resolved issues improving overall performance and stability.

Troubleshooting with vendors and application teams.

Troubleshoot and installed SSIS packages for developers in all regions.

Replication setup from 2005 to a 2008 instance

Server to the new version.

Also perform Activities like install the SQL Server Security Hot fix, Patch to the SQL server.

Setting up Log shipping/Mirroring from PROD to COB servers.

Monitoring Error logs and taking preventive measure thereon.

To perform various administrative activities pertaining to Databases and Performance like Setting up DBCC and running Update statistics and REORG.

To co-ordinate with Data center Operators to monitor the database jobs (AutoSys, Crontab jobs) and solve them in Case of Error’s.

Installation of Replication Server and setting up Database Level replication.

Monitoring and Maintaining the Replication Services 12.5 & 12.6 Version.

To install new ASE server’s and to upgrade the ASE to new version.

Coding & fine-tuning as Quality Check for the best results.

Co-ordination with Developers to include modifications in the D/b in the form of DDL Deployments for performance & Business enhancement.

Creating and maintaining various DB maintenance jobs for smooth working of DB/Servers through SQL agent/AutoSys and Crontab for Sybase.

Dump and load of databases using SQL Backtrack, troubleshooting for Database Objects

Db Syncing Activity for BCP and Disaster/recovery test.

Generating Report for Audit Purpose using (ISScanner Tool)

Also monitoring the alerts and solving the Alert’s Through BMC Patrol and other 3rd party Software’s.

CMS Computers Ltd. May 2004 – October 2005

Working as Database Administrator for TATA-AIG Insurance Company Limited (client of CMS Computers) taking care of their database related activities. Main activities include creation, maintenance of Databases in Sybase / SQL Server 2000.

Role and Responsibilities include:

Created databases and devices; monitored error logs and took preventive measure thereon.

Coordinated with Developers to include modifications in the D/b in the form of DDL Deployments (SQL statements, Procedure, Indexes) in the form of fixes and builds for performance enhancement.

Performed various administrative activities pertaining to databases and performance, such as running DBCC and updating statistics and REORG.

Coordinated with Data Center Operators to perform weekly/monthly DB maintenance activities like DBCC

Created User ID’s through DB Artisan and other Front-End Tool to interact with users to solve performance related problems and ensure smooth running of system

Performed coding & fine-tuning as Quality Check for the best results

Created and maintained various DB maintenance jobs for smooth working of DB/Servers

Monitored and maintained the Replication Services 12.6 Version

Creation /modification of users, granting and revoking rights on DB level

Interacted with the Application person for designing the database as per the application

PEST CONTROL INDIA Pvt Ltd. August 2003 – March 2004

Trainee System Administrator

Took care of system related activities and conducted training for all users

Installed Linux O.S Performance and setup of Proxy Server, network and created and configured User ID’s

EDUCATION:

COLLEGE OF HI-TECH ENGINEERING, Mumbai India (Affiliation with Dnyaneshwar Vidyapeeth India)

Bachelor’s Degree in Computer Science - 2003



Contact this candidate