Devbrat Chauhan

Senior Oracle Database Administrator | Sr Database Migration Consultant | Sr Cloud DBA | Sr
Database Administrator | Database Lead | Database Architect | Data Analyst
Database and Analytics Professional with extensive years of experience offering a unique combination
of technical, analytical and leadership skills. Known for designing cost effective Database solutions.
Designed various DB architectures in AWS Cloud/Physical Datacenter for multiple customers across
22 countries and 8 business industries. Expert in designing/execution of Zero-Downtime Migration
strategy for large database estate (size upto 150TB) from on-premises to Public/Private Cloud and
migration across datacenters. A self-motivated and committed team player with excellent Problem
Solving and Multitasking skills.
● Specialist in Oracle RAC/Exadata, DB performance tuning, DB Migration and Administration
● Experience of leading a team of DBAs to support 24*7*365 prod environment with 6000 Databases
● Managed large DB estate across diverse industry verticals like Banking, Finance, Telecom,
Manufacturing, Healthcare, Life Sciences, Transportation and Energy etc.
● Familiar to implement and use Agile and DevOps methodologies/tools to plan and execute complex
projects.
● Experience consulting and collaborating with client’s senior management to develop IT Architecture
and Database Migration Strategies.

Sr Oracle,SQL Server Database Administrator , Database Architect , Sr DB Migration Consultant
Imperial College London , London, United Kingdom 09/2023 to Current
● Collaborated with researchers, scientists and doctors to design the database system to help in
various clinical/civil researches. Understanding customer requirements and their existing database
environment and designing solutions to accommodate DB workload in AWS cloud.
● Designed analytical solutions to help customers make datadriven decisions and improve their
processes through automation. Visualising the data and deriving meaningful outputs which in turn
helped customers in decision making.
● Administration of Oracle (11g, 12c and 19c) on AIX, Linux and Windows environments,
● Installation, administration and performance tuning of Oracle RAC 11g, 12c, 19c
● Installation and configuration of Oracle DataGuard
● Database Administration of SQL Server 2014, 2016, 2017, 2019 databases
● Performed Oracle, SQL Server DB migration in across servers (within datacenter) and On-prem to
cloud environment
● Designed and implemented Disaster recovery solution and performed regular DR testing activities
● Creation is SOP/documents for activities and process in DB domain
● Configured Oracle Golden Gate for the replication across OLTP databases to datawarehouse for
business analytics purposes
● Experience in other DB technologies (Postgres, Mysql, AWS RDS, Aurora, Redshift, DynamoDB)
● Automation of frequent and regular DBA tasks through shell script and terraform (in AWS cloud)
● Provided training to customers to learn to use Amazon Databases – AWS RDS, Aurora, Redshift,
DynamoDB, NeptuneDB, DocumentDB (Mongo DB)
● Maintained and tailored of the databases, Study team databases, and their associated application
tools according to the requirements of the Register and Study teams.
● Performed all the SQL Server DB administration tasks like installation, DB creation, proactive
Performance monitoring, SQL profiler to investigate execution plan, tuning T-SQL queries, Backup,
disaster recovery strategy, SQL server database, mirroring and replication operations, security and
troubleshooting major incidents around SQL server database
● Optimisation the coordination of all data management and processing activities with the clinical
team. The team consists of research facilitators, coordinators, study doctors, nurses, psychologists
and assistant psychologists
● Database Migration planning and execution. Migrated 2 Oracle Exadata/RAC DBs to different DC
● Production of data summaries and custom data exports at the request of the management team.
● Resolved multiple Database Performance tuning issues and derived RCA to apply permanent fix

Database Migration Consultant | Database Architect | Sr Database Administrator
AWS (Amazon Web Services) – London, United Kingdom 06/2022 to 09/2023
(Application Migration, Modernization and Management Team)
Role: Understand customer requirements and their existing database environment and translate these
to design solution in AWS that meets DB performance, scalability, availability, backup, security,
monitoring and disaster recovery, RTO/RPO needs within AWS well-architected framework
Designing analytical solutions to help customers make data-driven decisions and improve their
processes through automation. Visualising the data and deriving meaningful outputs which in turn
helped customers in decision making.
DB Administration/Designing/Architecting:
● Designed DB Solutions, trained customers to learn to use Amazon Databases, successfully
supported 6 customers achieved 98% on their accreditation
● Partnered with development, account management teams and business partners to migrate 160
databases successfully from On-prem to AWS cloud DB platform for 4 different banking/finance
customers
● Derived business intelligence results and visualised through AWS Data Analytics services like
Amazon Redshift, Athena, Glue, SageMaker, Kinesis, S3, Quicksight.
● Designed solution to re-architect complex DB env in AWS for large Financial firms with CSAT 10
● Database cost optimization with licence consolidation and right-sizing.
● Documented 6 best-practice knowledge and patterns with learning from customer engagements and
shared with AWS community and produced customer facing reference architectures
Database Migration :
● Designed migration strategy for large financial customer and migrated 42 on-prem databases
(including Oracle RAC, Exadata, SQL Server, Warehouse databases) to AWS cloud DB services
like AWS RDS for Oracle, SQL Server, MySQL, PostgreSQL, Amazon Aurora, Amazon Redshift,
DynamoDB using AWS DMS (Database Migration Service), GoldenGate and SCT with Zero
downtime on right-sized (to eliminate compute/license over allocation) landing platform in AWS
which helped customer to reduce TCO by 58% in first year post migration
● Designed and Implemented DB Migration/Replication solution through GoldenGate, Qlik (Attunity),
Oracle Dataguard, MS SQL Server replication, AWS DMS and AWS DRS for multiple customers
● Developed Oracle RAC Migration Lab in AWS cloud to demonstrate Oracle RAC hosting capability
in AWS RDS platform and won the dollar 2 million Oracle RAC migration deal from Telecom giant
● Designed Infrastructure as a code (with Terraform) to setup Infra in AWS cloud environment with one
click reducing deployment time by 80% for non-prod environment post migration of a financial client
● Trained different customers and AWS partners with 28 KT sessions on AWS DB services

Database Lea, Database Architect, Senior Database Administrator, Cloud DBA
TATA Consultancy Services - Leamington Spa, United Kingdom 08/2014 to 06/2022
DB Architecture Design/Migration/Projects:
• Designed and implemented database architecture and disaster recovery solutions. Designed
strategy to migrate on-premises databases to Public/Private Cloud or VMWare ESX clusters
• Managed Oracle RAC/Standalone, Exadata, SQL Server, MySQL, PostgreSQL, AWS RDS
Databases in Six different geo-locations (Datacentres) and AWS cloud
• Migrated 200 on-premises Oracle, SQL Server databases to AWS cloud RDS/Redshift and Oracle
Cloud platform to reduce total cost of ownership by 26%
• Designed and implemented solution to migrate and consolidate 76 Oracle RAC Databases across
Datacentres with Oracle Dataguard and GoldenGate with near zero downtime helped customer to
reduce total infrastructure cost by 55%
• Migrated and consolidated 2000 databases across 2 datacentres to reduce license cost by 32%
DB Administration/Performance Tuning:
• Automated DB refresh operation (prod to UAT) for business-critical databases with shell scripting to
reduce manual efforts and activity time by 70%
• Resolved many database performance issues using OEM, AWR, ADDM, ASH, TOAD. Performed
tuning of slow SQLs with Profiling, Baselining and SQLT to reduce execution time by 80% and
benefited to get critical BI reports on time with commencement of business
• Performed crash recovery of many critical databases with RMAN point-in-time-recovery feature
• Deployed OEM 13c and configured metrics to monitor 2400 databases to handle alerts on time
• Designed and Implemented DR managing Corporate Critical policies along with defined RTO/RPO
• Performed DR testing activities with SAN flash copy and Oracle Dataguard switchover and failover
• Databases capacity planning, growth forecasting, documentation and SOP creation
• Designed Backup Solution for entire DB estate through Commvault/Netbackup
• Implemented SOX policies and supported DB security audits
• Lead the team of 24 members and extended 27 DB training sessions to team members
• Attended Customer meetings and handled various Major Incidents in domain
DB Performance Tunning Specialist| Consultant Oracle Database Administrator
NIIT Technologies Limited – Greater Noida, India 04/2013 to 08/2014
• Handled multiple Performance issues in Oracle RAC Databases with OEM, AWR, ADDM, ASH,
TOAD and SQL tuning through profiling, baselining, TKPROF and SQLT
• Automated tablespace resizing/addition through Shell Scripting which reduced efforts by 80%
• Automated regular table re-org, index rebuilding, stats gather of top tables/schemas
• Managed Oracle database quarterly patching (Bug fix) activities, upgrades and Encryption (TDE)
• Implemented replication through Oracle Streams and CDC for reporting purposes
• Performed crash-recovery of multiple databases using Oracle RMAN, Export/Import Datapump

DB Lead , Senior Oracle Database Administrator , Automation SME 04/2011 to 04/2013
Wipro Infotech Limited , Gurgaon, India
• Managed the team of 20 DBAs in 24x7x365 production environment
• Planned and upgraded 26 Oracle RAC clusters from 10g to 11g in-place to reduce cost by 50 percent
• Mentored team to perform DB administration activities like RMAN, Flashback Recovery, partitioning, encryption, compression, shrinking, DR Testing, Capacity planning and Documentation
 

EARLIER ROLES
Senior Oracle Database Administrator, HCL Technologies Limited, Noida, India
Senior Oracle DB SME, IBM India Private Limited, Noida, India
Oracle DB Consultant, Datacenter Operations Engineer, Adecco Flexi Limited, Delhi, India
Oracle Database Administrator, Sark Systems India Limited, Delhi, India

• B.E, Computer Science and Engineering from Dr. A.P.J Abdul Kalam Technical University, India
• Oracle Database 11g Administrator Certified Professional
• AWS Certified Solution Architect Associate [Credly Certification verification link]
• AWS Certified Database Specialty [Credly Certification Verification Link]
• Oracle Cloud Infrastructure 2019 Certified Architect Professional
• Oracle Autonomous Database Cloud 2019 Certified Specialist
• Linux Administration training, CDAC India.
• Hashicorp Certified: Terraform Associate (003) [Credly Verification Link]
• AWS Security Governance at Scale
• Advanced Architecting on AWS
• Certification in Data Analytics through SATA from Imperial College London
• Professional Certification in Data Analytics from Imperial College London from Jan’24 to Aug’24. [Imperial College London Certificate Link]