Ranganathan Shivraman

Experience

• 

  International Systems Technologies

  Mar 2007 - Apr 2011

  Project Manager/Oracle database administrator

  Projects Undertaken:Oracle Database AdministratorClient: IBM, Springfield, VAApril 2010 to April 2011Oracle Database AdministratorClient: Federal Department of Veterans Affairs, Hines, ILJul 2009 to Mar 2010 Oracle Database AdministratorClient: Client Network Services, Lansing, MIJul 2007 to Jun 2009 Oracle Database AdministratorClient: Hewlett Packard, Houston, TXApr 2007 to June 2007Major Responsibilities:· Setup RMAN/Export backups in Oracle 8i,9i,10g database· Providing closing report to the stakeholders upon successful completion of the project.· Worked with the stakeholders to establish requirements and constraints· Generate/Analyzed AWR and ADDM reports for performance tuning of the database in ORACLE 10g· Worked with an OEM Grid Control on an Oracle 11g database· Configured and operated OEM for Oracle 10g/Oracle 11g databases· Involved in DISASTER RECOVERY planning· Migrated a Oracle 10g database to Oracle 11g on a HPUX platform· Designed and Deployed Oracle Database Solutions· Created indexes for SQL Tuning· Setup the ORACLE WALLET MANAGER and ORACLE ADVANCED SECURITY for the databases· Provided 24/7 production support in the middle phase of Medicaid provider enrollment· Worked with installing a RAC setup in the production environment on a Sun Solaris 64bit cluster Show less

• 

  Tcs canada

  May 2011 - Jun 2012

  Project Coordinator/Oracle Database Administrator

  Tata Consultancy Services CanadaOracle Database Administrator/Sql Database AdministratorClient: Rogers CommunicationsMay 2011 to present· Setup RMAN/Export backups in Oracle 10g database· Generate/Analyzed AWR and ADDM reports for performance tuning of the database in ORACLE 10g· Worked with an OEM Grid Control on an Oracle 11g database· Configured and operated OEM for Oracle 10g databases· Documenting time estimates, documenting stakeholder's interests and potential influences on the project developing status reports Show less

• 

  Cogeco Cable

  Jul 2012 - Apr 2015

  Oracle Database Administrator

  Setup RMAN/Export backups in Oracle 8i/10g/11g databases.Generate/Analyzed AWR and ADDM reports for performance tuning of the database in ORACLE 11gR2Created indexes for SQL TuningCoordinate/Perform migration of the databases from the Non ASM to ASM.Coordinate/Perform storage move to the new racks as per the business requirements.Lead high-level design walkthroughs.Document and Develop test plans and test cases.Effectively coordinated and negotiated the change management process. Involved in performing DISASTER RECOVERY for the databases.Coordinate/Perform all the tuxedo related downtime activities.Performing project risk assessments and managing communications.Coordinated all the database load related testing activities.Worked on the architectural design of the database environment and provided the necessary design documentation upon need.Produce project plans and schedules for application systems development efforts for small and medium size projects.Worked on configuring the TSM parameters on the new servers to setup RMAN Tape backups. Show less

• 

  Quickplay

  May 2015 - Jun 2016

  Oracle/Mongo/Cassandra Database Administrator

  Worked on installing a Oracle 11g RAC.Worked on taking expdp/RMAN backups on Oracle 11g RAC databases.Worked on performance tuning and indexing the long running high optimizer queries.Worked on installing the Mongo 2.4.14 databases on Microsoft Azure Cloud.Worked on upgrading the Mongo databases from 2.4.14 to 3.2.9.Worked on performing Mongo database migrations and backups using Mongodump and Mongorestore.Worked on installing Datastax Cassandra 4.8.7 databases.Performed backups and migrated data in DSE Cassandra 4.8.7.Worked on the nodetool repair and the snapshot fuctionalities. Show less

• 

  AT&T

  Jun 2016 - Dec 2018

  Senior Technical Specialist, Database Administration
• 

  Sun Life

  Dec 2018 - now

  Worked on creating the cloud formation templates to install rds aws instances in Postgres, redshift, MySQL, neptune, oracle and dynamo.Worked on installing MongoDB in containers.Used Jenkins pipeline to deploy mongo in containers & use Kubernetes to manage the container pods. Created and documented cf templates for backups and restore of the aws rds, aws nosql & aws neptune instances.Performed migrations from aws aurora to aws Postgres rds.Worked on creating the postgres rds and redshift databases on aws. Created the dynamo tables on the aws dynamo instances.Worked on upgrading the mongo databases to version 3.6.6. Used ops manager for the upgrade.Worked on the mongodump and mongorestore utilities to take backups and restore the mongo databases.Worked on tuning the mongo queries with index recommendations. Show less

  • Technical Director, Database Engineering

    Jul 2022 - now

  • Principal Database Engineer Nosql/AWS RDS/Postgres/Neptune

    Dec 2018 - Aug 2022