Be real like life.
Hi There! I’m Deep Barot
Explore and Enjoy
About
My Background
As a natural born go-getter, my passion has continuously driven me to expand my knowledge, experience, and relationships. With a strong background and diverse skill set, I’m confident in the creative ideas and successful solutions I bring to the table. Keep exploring my site to learn more information about me, and reach out directly with any questions.
My Experience
Background & Expertise
Oracle DBA At Tata Consultancy Services
July-2011 to Aug-2012
Responsibilities :
Work as part of a team and provide 7x24 supports when required
Installing and upgrading the Oracle server and application tools.
Allocating system storage and planning future storage requirements for the database system
Creating primary database storage structures (tablespaces) after application developers have designed an application
Creating primary objects (tables, views, indexes) once application developers have designed an application.
Modifying the database structure, as necessary, from information given by application developers.
Enrolling users and maintaining system security.
Controlling and monitoring user access to the database.
Monitoring and optimizing the performance of the database.
Planning for backup and recovery of database information.
Backing up and restoring the database.
Assistant Manager - IT At GSCB Bank
Sept-2012 to Oct-2014
Responsibilities :
Managing day-to-day activities and database maintenance
Having experience in creation and maintenance of the users along with security roles and privileges
Taking Backup of the database (Physical & Logical), RMAN Backup.
Modifying the database structure, as necessary, from information given by application developers.
Providing support to client and vendor on TCS BαNCS Solution.
Increased operational efficiency and agility.
Maintaining and support TCS BαNCS Solution.
Knowledge of all type of troubleshooting of B@NCS Software. Knowledge of server installation and maintenance.
Providing technical support for implementation of CBS.
Maintaining Daily operation of CTS.
Ensuring smooth operations at all times & maintaining proper decorum & discipline by implementing the policies & procedures.
Oracle DBA At Tata Consultancy Services
Nov-2014 to Present
Responsibilities :
Experience in designing, implementing and supporting high availability and disaster recovery solutions for mission-critical 24x7x365 environments.
Managing 10g,11g and Exadata Environment which includes Production DB, Production Support DB, DR/DT/DC DB.
Supported in performing goldengate configuration, administration, installation, also configuring pumps and managing trail files by purging old extract files and log files.
Migrate database across different servers and platforms using transportable tablespaces and data pump export/import and perform database refresh
Analyze performance issues. Verify and tune sql, plans, queries as needed.
Supporting multiple databases for production, development, test and staging purposes on linux environments.
Migrate database across different servers and platforms using transportable tablespaces and data pump export/import and perform database refresh and RMAN cloning.
Rebuild indexes, table partitioning, tuning memory usage and SQL tuning using explain plan, SQL trace, tkprof and statspack for best performance.
Creating AWS RDS Instance database. Manage AWS RDS DB.
Migrating Oracle,Ms-sql,MySQL On-Premise database into AWS Cloud RDS DB.
Education
What I’ve Learned
B.Sc(CA & IT) from Gujarat University
July 2005 - July 2008
B.Sc. (Computer Application & Information Technology) from KS School of Business Management, Gujarat University with secured 61.04 % marks and CGPA - 7.0 .
M.Sc(CA & IT) from Gujarat University
Aug 2008 - Aug 2010
M.Sc. (Computer Application & Information Technology) from KS School of Business Management, Gujarat University with secured 60.87% marks and CGPA - 6.9 .
My Skills
What I Do
No matter the role or project, I’m confident in the skill set I bring to the table. Take a look below to learn more about my specific abilities, and feel free to get in touch if you’d like to know more.
Database Administration
Supporting multiple databases for production, development, test and staging purposes on linux environments.
Worked on new features on 12c databases such as recovering tables, masking the fields, using advanced optimization parameters for good performance of 12c databases.
Experience in troubleshooting RAC databases and engaging with the application team for gaining performance enhancements for application in a clustered environment.
Knowledge on clusterware architecture .
Knowledge on Creation and Administration of Physical Standby Databases.
Collecting performance statistics using Statspack/AWR(Automatic Work Repository).
AWS Cloud RDS DB migration from on-premise database.
Tools and Utilities
Tools and Utilities :- RMAN, SQL Loader, Toad, SQL LOB EDITOR,Oracle SQL Devloper,Citrix Jump Box,Putty,AWS Console.
Operating Systems :- Microsoft Windows Servers and Red Hat Linux.
System Hardware :- Intel based servers, PCs and workstations.
Resume Download
Click on link below.
Contact me directly to know more specifics about my skill set.
"Do not go where the path may lead. Instead, go where there is no path and leave a trail"
Quote By
Ralph Waldo Emerson
