$75

Hourly Consulting Rate

Srinivasa obulapu

Independent Consultant

Industry Experience

Financial Services

Information Technology/IT

Location Supported

Australia

India

Languages Supported

English

Skills

  • Technical consultant
  • Functional consultant
  • Managed services
  • Database administration
  • Business intelligence
  • CRM
  • +2 more

Product Specialization

  • Microsoft Dynamics 365 CRM
  • Oracle E-Business Suite

About

I am Srinivasa Obulapu, working as Senior Consultant for the last ten years in Oakton (now NTT). My expertise includes database administration Oracle, Oracle EBS, MS SQL as well as MongoDB. I have extensive experience in setting up High Availability as well Disaster Recovery for the organizations which we are supporting.
I have installed Oracle RAC , MS SQL Mirroring, Availability Groups and Distributed Availability Groups across data centers. Last year successfully completed Oracle RAC database migration from one Data Center to another data center.

Apart from database administration and day today support, have knowledge in Microsoft Business Intelligence like SSRS, SSIS and successfully completed a migrating data from Access to MS CRM.

For the last couple of years I have been working with AWS and Azure

Previous to Oakton (NTT), worked with IBM,GENPACT and HCL Perot and my total IT experience is about 16 years.

Top Project Highlights

Oracle Database Migration

There were around 40 Oracle instances (9i,10g,11g) which were to be migrated from one data center to antother as data center.  There were Oracle RAC instances with DR setup which were to be migrated. We started migrating with non prod and once we migrated the non production Oracle instances, the application team confirmed that all application were working as per expectations. After getting the Client confirmation we migrated the Production Oracle databases with least outage using Data Broker techinique.

MS SQL Setup in Azure

The requirement for this client is to setup MS CRM 365 on Azure virtutal machines. We are responsible for installing and confiuration of MS SQL servers in Azure Virutual Systems in different Regions. We have configured Avaiability Groups for HA and Distributed Avalability Groups for DR across data centers.  As per client requiremnet we tested multiple failover and failback to check RPO/RTO.

Data migration from Access to MS CRM

This client has a MS Access database from their legacy system and the requirement is to migrate this data to MS CRM on premises. We developed SSIS packages to migrate the data to CRM from source. The data is successfully migrated.

Employment

Senior Consultant (Australia)

2017 - Present
    • Configuration of High Availability for MS SQL
    • Maintenance of SQL/DB2/Oracle/MySQL/DynamoDB/MongoDB Databases
    • Performance tuning of databases.
    • Provision of Infrastructure in the cloud.
    • Database migration of Oracle databases across data centers(Oracle 9/10/11g)

As Lead DBA in Oakton (India)

2010 - 2017
    • Currently working as Senior DBA(Apps DBA) for 24 X 7 production support
    • Configured Standby Databases in RAC environment
    • Upgrading RAC GRID cluster as well databases
    • Trouble shooting RAC issues at cluster and OS level.
    • Working on Oracle Web Logic, Fog light and Golden Gate.
    • Cloned R12 Applications and applied patches in R12.
    • Installation and configuration of OBIEE/DAC/Informatica on Linux
    • Trouble shooting DW database issues (performance)
    • Installation and configuration of Discoverer with EBS R12 (Oralce Apps)
    • Configured High Availability for Business Intelligence
    • Restore and Recovery of databases as per SLA
    • Good knowledge in working with SAN
    • Installation and Maintenance of 2005/2008 SQL Servers
    • Configuring and Monitoring databases through 12c OEM.
    • Scheduling in House maintenance scripts
    • Knowledge in BI/Informatica mapping and developing cycles.
    • Configuring Domains for Informatica repository and integration services.
    • Working on SQL Administration.

Senior Database Admin at SumTotal

2008 - 2010
    • Responsible for 24X7 for support of Oracle and SQL 2005 Servers in Data Center
    • Resolving ORA-7445 and ORA-600 issues.
    • Developed DR plans for databases with Data Guard
    • Up gradations of oracle 10g and applied patches to Oracle databases
    • Migrated database from Linux to Windows systems
    • Prepared SOPs for day to day operations and for all database activities
    • Scripts to monitor Standby Databases Data Guard
    • Performance Tuning of Databases for better response time.
    • Configured 10g Grid for all Databases (Oracle 10g & SQL2005)

Consultant at GENPACT

2005 - 2008
    • Given DBA support to Form Tool Line Tool project for GE Plastics
    • Wrote scripts for remote database connectivity both in UNIX and DOS as oracle databases were on both platforms.
    • Installation of Oracle Software and creation of databases according organization standards.
    • Trouble shooting the issues
    • Installed 10g Grid for central monitoring/administration of all 250 + databases both oracle as well as MS SQL databases.
    • Responsible for Disaster Recovery testing.
    • Installed SAP application on SUN SPARC systems.
    • Installed and configured Redwood systems which are used for BW monitoring and job scheduling.
    • Participating in tech window where we test for failover of systems and databases.
    • Monitored all Oracle and Non Oracle databases and applications from 10g Grid. We are able to remove L1 support by using grid.

Associate in Perot & System Operations Lead Analyst at IBM

2005 - 2005
  • We are responsible for 24 X 7 Monitoring and Maintenance of Customer Databases (Capital One), physically located in the U.S. and Remote Administration of Production Databases in HP using tools provided by the client. Apart from the regular activities we have up gradation and migration of the databases from Oracle 7.4 to 9i.

Education

Executive Program in Business Management Indian Institute of Management from Indian Institute of Management
2014-2015

Finance

Marketing

Operational Methods

 

Post Graduate Diploma in Software Engg.,(Specialization in OOAD & RDBMS)
1992-1993

Orcle

RDBMS

OOAD

Post Graduate Diploma in Software Engg.,(Specialization in OOAD & RDBMS)
1990-1991

FoxBase and C

Graduation from OSMANIA UNIVERSITY
1986-1989

Mathematics

Physics

Geology

Certification

Oracle 9i OCP
2005-2005

Oracle Certified Professional

Microsoft Certified Solution Expert MS SQL
2017-2017

MS SQL Administaration

T SQL

AWS Certified Solution Architect - Associate
2018-2018

AWS Certified Solution Architect - Associate

Ooops!

Maximum of Three products are allowed for comparision