Deep Barot
Ahmedabad
Summary
Results-driven Database Administrator with expertise in managing and optimizing database systems. Proven track record of enhancing system efficiency and data accuracy, significantly reducing downtime through strategic database management initiatives. Strong problem-solving abilities complement a solid foundation in database design and data security measures. Committed to leveraging skills to drive organizational performance and innovation.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Database Administrator
TATA Consultancy Services
Ahmedabad
11.2014 - Current
- Working with management, developers and end-users participated in the design and implementation of databases to support the commercial side of the business
- Designing, implementing and supporting high availability and disaster recovery solutions for mission-critical 24x7x365 environments
- Managing 12c,19c RAC DBs which includes Production DB, Production Support DB, DR/TEST DB
- Creating AWS RDS Instance database; managing AWS RDS DB
- Experience in Performance tuning using Explain Plan, SQLTRACE,TKPROF,AWR and ADDM
- Migrating Oracle, MS-SQL, MySQL On-Premise database into AWS Cloud RDS DB
- Ensuring Governance, Risk Management, and Compliance (GRC) compliance in Oracle Systems through DB Vault and Control Objectives for Information and Related Technology (COBIT) procedures
- Providing updates on availability, database usage, growth and performance metrics to the organization's senior management
- Designing new as well as improved existing processes to reduce Mean Time to Recovery (MTTR) and ensure database availability
- Supervising technical planning and analysis of critical issues to ensure that these are resolved within SLA; working with Support and Account Managers during critical failures
Assistant Manager-IT
The Gujarat State Coop. Bank Ltd.
Ahmedabad
09.2012 - 10.2014
Database Administrator
TATA Consultancy Services
Ahmedabad
07.2011 - 08.2012
Education
M.SC(CA & IT) - Information Technology
KS School of Business Management
Gujarat,India06-2010
Skills
- Databases: Oracle (12c, 19c, RAC, ASM, Data Guard), PostgreSQL, MySQL, MongoDB, MSSQL, Couchbase
- Operating Systems: Windows Server, Red Hat Linux
- Automation & DevOps: Jenkins, Ansible, Puppet
- Monitoring & Security: Grafana, Icinga, OEM 13C, Solace
- Scripting & Tools: Python, Shell, RMAN, SQL Loader, Toad, SQL Developer
Certification
- Oracle SQL Expert (IZO-047)
- Oracle Database 10G Administration (IZO-042, IZO-043)
- Microsoft Azure Administrator Certified (AZ-104)
Languages
Gujarati
First Language
English
Proficient (C2)
C2
Hindi
Proficient (C2)
C2
Timeline
Database Administrator
TATA Consultancy Services
11.2014 - Current
Assistant Manager-IT
The Gujarat State Coop. Bank Ltd.
09.2012 - 10.2014
Database Administrator
TATA Consultancy Services
07.2011 - 08.2012
M.SC(CA & IT) - Information Technology
KS School of Business Management