Amit Kumar Garg Email & Phone Number

Bangalore

Bengaluru Area, India

•Part of Core Technology group and are responsible of designing backend database system solutions for new services and managing a bag full services in Intuit. •Work closely with Development team and architects to design and implement for new features and document Runbooks for each service in production system. •Responsible for requirement gathering, effort sizing, architecting and dement it for discussion and rolling-out the multi environment deployment plan as part of Sprint planning. •Follow regress Agile Scrums with Jira Boards and burnout charts. •Very recently are engaged in designing and implementing data persistence over cloud. •Implemented multi swimlane AWS RDS and supported intense FMEA testing, traffic dialing for application traffic. Performed data migration over cloud. •Performed data migration from hosting platform to cloud and setup data replication (Oracle Golden Gate or MySQL) for continuous data sync.•Innovate for customer delight. Worked on multiple ideas to create POCs.•Create various dashboard and alerts for different Database metrics. •Implemented CICD to automate database deployments.•Worked on Data Encryption, and data modeling to migrate the database over Cloud. •Maintenance of the existing backup and recovery strategy, export-import for high OLTP tables, monitoring and tuning the hardware and OS configurations.•Monitoring growth of the tables and undertaking necessary re-organization procedures, including index-rebuilding and tablespace management.•Taking and analyzing AWR Report and making necessary configuration changes & tuning.•Performed several tasks in the application development: helping for coding with database packages in PL/SQL used for developing complex financial reports using Java Servlets. •The experience gained in this role provided me with the ability to communicate at different levels within an organization and to take in a wide range of new information very quickly.

• Worked as high availability and Replication SME and were responsible for supporting customer for their issues on stand alone or RAC specific replication. • Responsible for understanding customer issue and provide viable solution. • Maintained high CSAT score with customers feedback.• Conduct remote sessions to help customer to setup multi-site Goldengate Replication.• Support data migration and setting up disaster sites.• Support critical production releases and cutovers• Written several Notes and whitepapers over oracle Metalink site for different issues.

Raffles Software works for IBM clients.I was working onsite as Database Engineer for Toyota Kirloskar (IBM Client) on payroll of Raffles Software.• Maintenance of Oracle production and development databases including database Backups using RMAN.• Managing Database storage options like ASM.• Managing Database Structure, Storage Allocation, Table/Index segments, and Rollback segments, Constraints, Database Access, Roles and Privileges.• Developed shell scripts for performing file transfer from different sites and starting the Aggregation process on the Application Server.• Creation of Users under the Security Management. • Automating DBA tasks using shell scripts. • Planning and scheduling backups using Cron jobs.• Backup, Export/Import and various database issues. • Testing Recovery Strategies by Simulating Database Crashes on Test Systems.• Computing the statistic of database through monitoring dynamic and performance tables regularly & Implemented SQL scripts to monitor & to get information on Freespace, Extents, Tablespaces.• Tuning database, applications, memory, and disk usage.• Monitoring and optimizing the performance of the Database• Capacity Planning, Minimize the database down time.

M.C.A, Computer Application, First Class With Distinction

Visvesvaraya Technological University

Master Of Business Administration - Mba, Information Technology

Bca, Computer Scence & Application

Guru Nanak Khalsa College, Yamuna nagar (Haryana)

Master Of Business Administration - Mba, Information Technology

Master Of Business Administration - Mba, Information Technology