Gautam Saini

About Gautam Saini

Working as a DBA and here are some of my roles and responsibilities-PROFESSIONAL SUMMARY14+ years of experience in the IT industry with expertise in database administration and production support.4+ years of hands-on experience in Oracle RAC.7 years as a MySQL Database Administrator, managing database performance, replication, backups, and upgrades.3 years as a Production Support Analyst for Java-based applications.Proficient in AWS disaster recovery (AWSEDR), Terraform, and EC2 instance management.Skilled in database technologies: Oracle, MySQL, PostgreSQL.Adept at database space management, ASM diskgroups, tablespaces, and user management.Expertise in query optimization, stored procedures, functions, views, and triggers.Managed and monitored 250+ databases, ensuring uptime and performance.CERTIFICATIONS & TRAININGGCP Cloud Digital Leader (Google)HIPAA CertificationAWS Basics (Udemy)PostgreSQL, Oracle, Terraform, MSSQL (Udemy)YouTube Channel: DB_knowledgeGCP Trainings: View ProfilePublished Courses at Udemy: 1.) Master PostgreSQL: From Basics to Advanced Management2.) Oracle: A complete guide - From beginner to Master3.) MongoDB Masterclass -The NoSQL Powerhouse for Scalable Databases

Experience

1. Tech Architect - Dba

   Damco Solutions

   Aug 2013 — Present · Faridabad, IN

   Project Title: GSI Health LLCProject Detail: GSI Health delivers ACO software and technology solutions that help care networks and Medicaid Health Homes deliver whole patient care.We manage GSI Health Customers data and their records in Database. Also if there is any issue from users while using GSI Health Applications we provide support and solution to them and try to resolve their issues as soon as possible. We manage GSI Health servers issues and try to find the exact reason by checking logs and if required we restart servers and provide appropriate resolution.Client GSI Health LLC Employment Type: Full-TimeProject Location: OffsiteRole: DBA, Production Support EngineerSkill Used: MySQL, Bitbucket, GitHubTeam Size: 15Role Description As a DBA: Providing Database access to different users, restricting their access level, IP based restriction and access for different Database schema.Monitoring Database Master servers and Slave servers.Making and running various queries for Database, creating views and triggers.Taking backups of Database and tables during Deployment and patching of new releases.Discuss the issues in Environments with Team members.Making changes in Client data as requested by the Client Team.Taking care of new changes in a test environment first, so we can put them on Production servers.Discuss the impact and functions of new things that we going to add to the environment.Upgrading Database to the latest version.Working on Cross-Platform(Federated) database servers.Creating Trigger and events to run the database processes smoothly.Setting up of Slave Database Server.Using Information Schema to access Metadata.

Education

• Govt. Polytechnic College

  Diploma

  2005 — 2008

• Maharshi Dayanand University

  Bachelor's degree

  2008 — 2011

Skills

• C++
• Html
• Software Development
• Wireless Networking
• Telecommunications
• Sql
• C
• Java