Summary
Overview
Work History
Education
Skills
Expertise
Timeline
Generic

Vinod Vohra

Cypress,TX

Summary

Seeking a challenging and responsible role in IT industry for a Team Lead for Application Development as well as Sybase, Oracle DBAs and PostgreSQL on AWS cloud env with opportunity of professional growth.

A Software Professional with 20 years of IT experience, specifically in the area of Database Administration, Replication Technology and Application Design, Development and implementation under Client Server Technology.

Overview

29
29
years of professional experience

Work History

Senior-Database Administrator

Macquaire Global Services
Houston, Tx
09.2018 - 07.2024
  • Supporting of Sybase/Oracle/MS SQL /AWS Aurora
  • Worked on on-prem to AWS Cloud Migration
  • On-prem SQL Servers to RDS SQL
  • On-prem Sybase Instances to Aurora PostgreSQL
  • On-prem Oracle to AWS RDS Oracle
  • On-prem Oracle 19 instance to Aurora PostgreSQL
  • Monitor / Work on Alert Reduction for DBA Operation group to improve group efficiency
  • Manage /Work on High Impact Sybase Issues.
  • Manage Sybase Vulnerabilities for Organization
  • Coordination of Sybase Patching with Application and Security group
  • On-Call as Level 3 (SME) for Sybase
  • Managing Performance & tuning - SQL Tuning and re-indexing/re-org of tables and Indexes.
  • Optimization of Sybase resources to improve performance
  • Diagnosing System problems
  • Tuning System parameters to optimize performance
  • Executing monitoring tools and analyzing output to improve performance.
  • Perform Yearly DR drills
  • Involved in Automation of DBA activities
  • Automated Sybase Data Assurance Install using Arturo/JSON

Senior-Database Administration – Team Lead

AT&T/Tech Machindra ( SouthEast, Old BellSouth)/EDS
Atlanta, GA
02.1998 - 09.2018
  • Maintain / Support Sybase environments for Internal AT&T Customers.
  • Maintain / Support Sybase and Oracle Databases including Mission Critical Applications
  • Installing/Configuring Database Servers/Instances.
  • Perform Upgrades to Servers/Instances
  • Managing User and Server Security, to meet company’s Security audit requirement
  • Managing /Monitoring disk space usage and memory.
  • Managing Performance & tuning - SQL Tuning and re-indexing/re-org of tables and Indexes.
  • Diagnosing System problems
  • Tuning System parameters to optimize performance
  • Executing monitoring tools and analyzing output to improve performance.
  • Automated Backup, recovery plan and disaster recovery plan for all the Database servers.
  • Perform Yearly DR drills
  • Monthly/Weekly maintenance-run Database Consistency checks, updating statistics etc.
  • Develop/Maintain various jobs to check system health and alarm DBA on regular basis
  • On-Call 24x7 support .
  • Support Replication for Sybase and Oracle.
  • Manage Sybase Replication Servers with different strategies
  • Sybase to Sybase (One way)
  • Sybase To Sybase ( Warm Standby and Multi-directional)
  • Sybase To Oracle
  • Also, manage different Oracle Replication strategies
  • Oracle Advance Replication.
  • Oracle Gateway for Sybase
  • As Information Specialist, Senior/Team Lead
  • Supporting CRM(Ticketing System) and Asset Management Systemd
  • Supporting 1000 concurrent Users and 5000+ total users.
  • Including Client Level Enhancements.
  • Maintain 4 Vantive Application Servers.
  • Maintain/Support Telalert Paging servers.
  • Maintain/Support Jaguar Server(Sybase product).
  • Tuning/Modification of Stored Procedures ,Triggers and SQL queries for better performance
  • Develop and Maintain interfaces to different ATT(Old BellSouth) systems.

Sybase Database Administrator

EDS
Plano, Tx
07.1997 - 02.1998
  • Supported Sybase Database Servers for EDS in-house developed application
  • Responsibilities included
  • Provide support to Production ,Reporting and test Databases
  • Perform Upgrades to Servers.
  • Managing User and Server Security
  • Managing /Monitoring disk space usage and memory.
  • Managing Performance & tuning
  • Diagnosing System problems
  • Tuning System parameters to optimize performance
  • Executing monitoring tools and analyzing output to improve performance.
  • Automated Backup, recovery plan and disaster recovery plan for all the Database servers.
  • Monthly/Weekly maintenance-run Database Consistency checks, reorganization of tables, updating statistics etc.

Database Administrator(Application Development and Support)

EDS , Xerox Account.
Rochester, NY
07.1995 - 07.1997
  • Designed and developed, C++ /Sybase Open Client/Remedy API interface to move data between different databases and application.
  • Member of Design and Development team for database design.
  • Coding of Stored Procedures and Triggers under Sybase SQL server environment.
  • Implemented and Supported Application for Rank Xerox( Europe) from Rochester.
  • Generated Reports for Billing System.

Education

Post Graduate Diploma in Computer Programming -

BRC Institute Chandigarh, India
01.1983

Bachelor of Science -

University of Delhi (India)
01.1981

Skills

  • Sybase 160/157/150/1254/1250
  • Sybase Replication Server 160/155/150/126/125
  • ECDA -Sybase Réplication Agent for Oracle/SQL
  • SAP Data Assurance (For Replaçâtes env)
  • Oracle 11g/10g/9i
  • MS SQL Server
  • Maria DB/MySQL
  • PostgreSQL
  • AWS SCT
  • DMS
  • Gutbucket
  • JSON
  • Remedy(AR System 8x)
  • Remedy ITSM 63
  • Remedy CMDB 11
  • Peoplesoft Vantiv 85
  • Visual Basic
  • Remedy Migrator
  • Unix
  • Linux
  • Windows
  • Oracle PL/SQL
  • Sybase T-SQL Programming
  • Unix Shell Scripts
  • C
  • YAML
  • Power Designer
  • Erwin
  • Toad

Expertise

Sybase 16.0/15.7/15.0/12.5.4/12.5.0, Sybase Replication Server 16.0/15.5/15.0/12.6/12.5, ECDA -Sybase Réplication Agent for Oracle/SQL, SAP Data Assurance (For Replaçâtes env), Oracle 11g/10g/9i, MS SQL Server, Maria DB/MySQL, PostgreSQL, AWS SCT, DMS, Gutbucket, JSON, Remedy(AR System 8.x), Remedy ITSM 6.3, Remedy CMDB 1.1, Peoplesoft Vantiv 8.5, Visual Basic, Remedy Migrator, Unix, Linux, Windows, Oracle PL/SQL, Sybase T-SQL Programming, Unix Shell Scripts, C, JSON, YAML, Visual Basic, Power Designer, Erwin, Toad

Timeline

Senior-Database Administrator

Macquaire Global Services
09.2018 - 07.2024

Senior-Database Administration – Team Lead

AT&T/Tech Machindra ( SouthEast, Old BellSouth)/EDS
02.1998 - 09.2018

Sybase Database Administrator

EDS
07.1997 - 02.1998

Database Administrator(Application Development and Support)

EDS , Xerox Account.
07.1995 - 07.1997

Post Graduate Diploma in Computer Programming -

BRC Institute Chandigarh, India

Bachelor of Science -

University of Delhi (India)

Similar Profiles

  • JULIA BOLOTBAEVA

    JULIA BOLOTBAEVAJULIA BOLOTBAEVA

    Guest Relations Manager at CBRE/MacquaireGuest Relations Manager at CBRE/Macquaire

  • Anirudha Kuppalli

    Anirudha KuppalliAnirudha Kuppalli

    Manager of Wealth Management Operations at Standard Chartered Global Business Services, Global Business ServicesManager of Wealth Management Operations at Standard Chartered Global Business Services, Global Business Services

  • Anand Rishav

    Anand RishavAnand Rishav

    Senior Software Engineer at Fidelity Information Global Services, FIS Global ServicesSenior Software Engineer at Fidelity Information Global Services, FIS Global Services

  • Osvaldo Segovia

    Osvaldo SegoviaOsvaldo Segovia

    Fire Alarm Technician at American Fire SystemsFire Alarm Technician at American Fire Systems

  • Dallas Brown

    Dallas BrownDallas Brown

    Coordinator I, Student Life at Lone Star College – CyFairCoordinator I, Student Life at Lone Star College – CyFair

CREATE PROFILE
Vinod Vohra