Mohd Arshad Khan
Madrid,M
Summary
Oracle DBA with10+ years’ experience having worked for Global clients in banking, life sciences domain. Core Oracle DBA having experience of working on Oracle12c,19C, RAC cluster environment, Golden gate, Active Data guard. Provides consultancy for effective database solutions to support critical business applications ensuring system availability, scalability, security, and performance. Having exceptional and proven database management skills with expertise in database creation, configuration, upgrade, migration, patching, cloning, refresh, decommissioning, performance tuning, backup & recovery, software installation etc. across platforms. Preparation/ update of the new and existing Standard Operating Procedure (SOP) documents on servers & applications deployment and hardening. Well versed in performing database migrations and upgrade from Oracle12c to19c. Performing DR exercise for critical production environment for disaster recovery response. Possess excellent interpersonal, communication and analytical skills with demonstrated abilities in customer relationship management across different geographies. Currently associated with Tata Consultancy Services Madrid, Spain as an Assistant Consultant since July-2022. Managed Large banking customer as core DBA in Sydney Australia.
Overview
14
14
years of professional experience
Work History
Technical Architect
Tata Consultancy Services
07.2022 - Current
- Led a successful Data Center (DC) migration project for a critical Oracle Database infrastructure, ensuring minimal downtime and seamless transition to a more scalable and cost-efficient environment
- I managed the entire lifecycle of the migration, from initial assessment and planning to execution and post-migration optimization. I worked closely with cross-functional teams to ensure data integrity, security, and high availability during the transition.
- Ownership of delivery & operations from Infrastructure side
- Performing Oracle CPU patching on standalone as well as cluster environments
- Performing database migrations and upgrade from Oracle12c to19c
- Design, develop, implement, management and consulting effective databases solutions to support business applications, ensuring system availability, scalability, security, and performance
- Database Upgrades, Migration, Refresh, Cloning, Backup & Recovery, Patching, S/W installation, Performance Tuning, managing RAC, Data Guard, and OS clustering systems for high availability
- Planning and executing DRP activity half yearly on customer demand
- LCM of databases (Upgraded databases from11g/12c to19c)
- Applying security & Bug fixes patches (PSU/RUR) quarterly to avoid vulnerability and keeping the databases secure
Database Architect
Leading EU Pharma Company
04.2019 - 06.2022
- Database Upgrades, Migration, Refresh, Cloning, Backup & Recovery, Patching, S/W installation, Performance Tuning, managing RAC, Data Guard, and OS clustering systems for high availability
- Involvement in Hardware sizing, resource and capacity planning etc
- Discussions
- Planning and executing DRP activity annually
- Part of Data Center Migration Team (Migrated databases from client DC to TCS DC)
- Role changes of Primary and Standby databases in DR configuration
- LCM of DBs and servers (Upgraded databases from11g to12c)
- Migrated databases across platform from MS Windows12 to SLES15
- Refresh of non-prod databases from its production database as per project/application requirement
- Applying security & Bug fixes patches (PSU/RU) quarterly on databases to avoid vulnerability
- Performance tuning for databases and SQL Queries using Explain Plan, SGA/PGA Advisory, ADDM, ASH, AWR, OEM, SPM, TKPROF and SQL Tuning Analyzer
Database Architect
Leading US Pharma Company, Large Australian banking customer
12.2010 - 03.2019
- Database Upgrades, Migration, Refresh, Cloning, Backup & Recovery, Patching, S/W installation, Performance Tuning, managing RAC, Data Guard, and OS clustering systems for high availability
- Planning and executing DRP activity annually
- Moved databases from filesystem to ASM storage for better performance
- Role changes of Primary and Standby databases in DR configuration
- LCM of databases and servers (Upgraded databases from9i/10g to11g/12c)
- Database Designing/Creation/Consulting for new application setup
- Applying security & Bug fixes patches (PSU/RUR) quarterly on databases to avoid vulnerability
- Retirement of unused databases, software, and servers
- Database Creation, S/W Installation, Patching, Upgrade, Cloning, Backup & Recovery
- Managed ASM & RAC databases using Grid Control
- Data Guard Setup and managing DG configuration via DG Broker
- Resolving GAP issues between Primary and its Physical/logical standby databases
- Applying security & Bug fixes patches (PSU/RUR) quarterly on databases to avoid vulnerability
- Decommissioned the databases and servers
- Performed database recovery using flashback database technology
Education
Bachelor of Technology -
Skills
- RDBMS: Oracle9i/10g/11g/12c/18c/19c
- Client communications
- Client engagement
- Database administration
- Performance optimization
- Technical leadership
- Multitasking
Hardware
HP, IBM, SUN Enterprise, Microsoft
Tools & Utilities
- RMAN, SRVCTL, OEM Grid Control, AWR, ASMCMD, ASH, SPM, Logminer, Toad, SQL Developer, OpenView, Remedy, ServiceNow, Assist, Data Pump, exp/imp, DMU, TKPROF, DG Broker, ADDM, SQL
- Loader, Veritas NetBackup, Commvault, DBCA, NETCA, ASMCMD, ASMCA, BRTOOLS, CRSCTL
Cloud Computing
AWS, Azure
HA Technologies
Data Guard (Physical/Logical/snapshot), RAC, Golden Gate, OS clustering
Application Servers
Oracle9iAS,10gAS,11g,12c
Operating Systems
Linux(RedHat/SUSE/OEL), Sun Solaris, HP-UX, AIX, Windows Families
Areas of Expertise
- Designing, implementing and managing High Availability systems using Data Guard, RAC, & OS Clustering
- Performing Disaster Recovery exercise annually for critical applications on customer demand
- Database Patching (PSU/RUR) and applying Interim Bug Fixes to avoid vulnerabilities and keeping them secure
- Database Cross Platform Migrations using RMAN and Data Pump utilities
- Database Upgrades from Oracle versions9i up to19c
- Database Backups & Recovery using traditional Hot/Cold, Data Pump, and RMAN backups
- Oracle Software Installations and de-installations
- Database creation and configuration of SGA/Memory parameters for optimal performance
- Database Cloning/Refresh/Renaming/Decommissioning
- Database Defragmentation for better performance
- Performance Tuning includes Database and SQL Tuning using Explain Plan, SGA/PGA Advisory, ADDM, AWR, ASH, OEM, SPM, TKPROF
- Excellent troubleshooting and problem-solving skills
- Good understanding of AWS (Amazon Web Services)
Languages
SQL, PL/SQL, Unix Shell Programming
Timeline
Technical Architect
Tata Consultancy Services
07.2022 - Current
Database Architect
Leading EU Pharma Company
04.2019 - 06.2022
Database Architect
Leading US Pharma Company, Large Australian banking customer
12.2010 - 03.2019
Bachelor of Technology -
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Aaliyah BufordAaliyah Buford
Model at NEXT MadridModel at NEXT Madrid