Database Administrator
Send a job offer directly to this candidate
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
● 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:
Databases in Six different geo-locations (Datacentres) and AWS cloud
Cloud platform to reduce total cost of ownership by 26%
Datacentres with Oracle Dataguard and GoldenGate with near zero downtime helped customer to reduce total infrastructure cost by 55%
DB Performance Tunning Specialist| Consultant Oracle Database Administrator
NIIT Technologies Limited – Greater Noida, India 04/2013 to 08/2014
TOAD and SQL tuning through profiling, baselining, TKPROF and SQLT
DB Lead , Senior Oracle Database Administrator , Automation SME 04/2011 to 04/2013
Wipro Infotech Limited , Gurgaon, India
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
