Database Administration Performance Tuning Monitoring & Maintenance
Patch Management Planning & Implementation Performance Analysis
Upgrades & Migrations.
Database upgrades from 12C to 19C.
Database migrations from 11G non-exadata to 12C Exadata.
ASM migration from old storage to new storage.
Configured Transparent Data Encryption on multitenant database.
Multitenant activities: Clone, Plug & unplug.
Addressing all the important issues & defining best practices for project support and documentation.
Migrated Non RAC database to RAC database.
ASM - Configuration, maintenance and administration (adding disks, DG free space, etc…).
Database clone – Manual & RMAN.
Database performance tuning.
DB restoration, Backup, Recovery.
Database refresh using traditional as well as Data pump export and import.
Experience on Oracle utilities - CRSCTL, ASMCMD, CLVUFY, RCONFIG, SRVCTL.
Preparation of quarterly health check reports of databases.
Cloning of a PDB in ODG environments.
Data center migration – Migrated 200+ database.
Managing overall operations for executing projects involving scoping, design, architecture, sourcing and process setup & development.
Managing a team of 15 members with the 200+ production databases.
Addressing all the important issues & defining best practices for project support and documentation.
Mentoring and training project members to enable them to perform their activities effectively.
Interacting with the client & system engineering team for requirements gathering & scoping.
Handling architecture and designing the solution for the product.
DBA core involvement into project planning Software installation, db structuring, performance tuning and optimizing operational processing meeting banks TAT.
Involving with senior management team for decision process for any planning in new technology implementation and DBA consultancy.
On-going proactive database tuning with good work knowledge
Oracle Installation: - Installed Oracle 10g, 11g, 12c on UNIX server & windows server.
Database up-gradation: - Upgraded Oracle databases from 10g to 11g.
RAC – Installation, Configuration, maintenance and administration.
Node Addition in RAC, Node deletion from RAC.
Migrated Non RAC database to RAC database.
ASM - Configuration, maintenance and administration (adding disks, DG free space, etc…).
Upgraded RAC database from 11G to 12C.
Database creation: - using DBCA and Manual.
Database patching: - Applying CPU, PSU patch in every quarter as and when released by oracle.
Database clone – Manual & RMAN.
Database performance tuning.
DB restoration, Backup, Recovery.