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