Senior Consultant - Compusys System Limited - Bangalore
(2022-11)
Working as a Core DBA/GoldenGate as migration specialist on Oracle 12cR1, 11gR2, RAC, Golden Gate, Data Guard, Linux. L2 Support responsible for 24x7 operational support.
- Working as a Core DBA/GoldenGate at Confidential as migration specialist on Oracle 12cR1, 11gR2, RAC, Golden Gate, Data Guard, Linux
- Installed and configure extract, pump, replicate, manager parameter file of GoldenGate
- L2 Support, Responsible for 24*7 operational support involving - Support Incidents which are relatively less complex, requires basic level of knowledge on Database (Oracle) to resolve such cases - Database Servers and environments, monitor queues, Change Management, Task Management under supervision
- Experience working on Tech refresh projects to perform end to end Production DB migrations with ASM, GI/DB upgrades, DB recovery, Data guard builds, DB and SQL performance tuning
- Capacity planning, designing and implementing of enterprise solutions using Oracle Database Technology
- Experience in Oracle Database Administration 10g, 11g, 12CDB Architecture experience in Oracle 10g, 11g, 12c
- Oracle 10g, 11g, 12C RAC on Multinode clusters implementation Data guard implementation in physical and logical standby mode (RAC)
- Managed database on 12c RAC, 11g R2 RAC and 10g. Configured databases with 2 node RAC clusters
- Installation & configure of Oracle Enterprise Manager 12c and Oracle Enterprise Manager Working, Setup Data Guard between multiple data centers. Update existing 10.2.0.4 to 11.2.0.3 then to 12.1.0.2
- Database patch set upgrades from Oracle 11.2.0.2 to 11.2.0.3 & from 11.2.0.3 to 11.2.0.4. Installation, Creation of the Oracle Database on server etc
- Upgraded more than 13 databases from 10.2.0.1 to 11.2.0.1 and then 11.2.0.1 to 11.2.0.2 including patchset updates using opatch
- Managing database on 12c RAC and 11g R2 RAC. Created OEDA requirement document for Oracle to setup the new Exadata X6 machines
- Working with network and linux teams to configure the network on the Exadata x6 machines so Oracle ACS can install Grid infrastructure 12cR2 and Databases 11g R2 and 12cR1
- Configured and modified Exadata x6 machines as per Confidential requirement and specifications after Oracle handed over the standard Exadata machines
- Migrated using Datapump Export/Import for small databases and non-critical databases and used DataGuard to Migrate huge and critical databases with 99% uptime
- Setup DataGuard between multiple datacenters for 12 production databases. Planed and documented all migration steps and coordinated with different teams during the deployments
- Software and firmware maintenance of the Exadata storage servers in the Database machine including routine health check, patching and upgrades according to the suggestions from Oracle support department
- Perform Linux administration and monitoring tasks include crontab scheduling, user creation, permission, CPU, memory monitoring etc
- To upload forms, reports on the application servers. Database Tuning & Performance Management Experience Performing database installation
- To manage logical and physical storage of Database like table spaces, data files etc. Work with functional end users to fix any issues related to applications. Performance tuning was an on going process, tuning queries
- As per requirement we work on installing software and creating database. To check oracle RAC database health, RMAN backup logs, cluster services etc
- To cloning production database data to test, development environment using RMAN utility. To Create users, table spaces, roles, functions, procedures, synonyms and databases as needed Provide DBA support to escalate TARs with Oracle Support
- Configuring the Load balancing at the server side & Client Side and TAF (Transparent Application failover) for RAC database. Involved in Rolling Patch for 4-node RAC databases. Monitoring the ASM diskgroup and adding the disk to the diskgroup when required
- Experience in Migrating database from Non-ASM to ASM. Creating the disk group like External, Normal, and High according to requirement
- Experience in RAC to Non-RAC cloning. Troubleshooting the cluster database using command line utilities CRSCTL and SRVCTL utilities. Performed backup creation tasks of OCR (OLR) and VOTING (GPNP) disks
Senior Consultant - Compusys System Limited - Bangalore
(2022-11 - 2024-12)
Senior Consultant for HAVI client working on Oracle database administration, maintenance and support activities.
- User management, Table space Management and regular maintenance activities
- Network configuration like Listener, Tnsnames. Database Replication (Db links and Materialized views and downstream captures, Streams)
- Monitoring growth of tables and undertaking necessary re-organization of tablespaces and indexes when required. Space management of data files according to Tablespace growth. Creating Users and Profiles, roles. Managing object and system privileges, granting, revoking privileges
- Created tables, indexes, back-end triggers, stored procedures, and functions. Checking of Alert log and Trace files to monitor the database on a daily basis
- Experience in working on tickets as part of regular database administration in Remedy tool
- Checking CRON Jobs and rescheduling process and monitoring. Experience in vulnerability and remediation. Provided end to end administrative support on applications which involves Oracle databases
- Experience on Database level and object level Reorganization. Coordinating with Application team on a daily basis for the implementation of production and non-production changes
- Implemented and maintained database through DBA activities include database backup (Cold, Hot and Import/Export)
- Setup backup recovery procedures using RMAN. Performed hot and cold backups using RMAN
- Experience in cloning/duplicate databases and restorations through RMAN, Hot and Cold backups
- Handled Severity1, Severity2 and Severity3 issues to fix the database issues through Bridge/conference call
- Good Experience in Dataguard Disaster Recovery (standby testing) and Configuration of Standby Databases (Dataguard), Active Dataguard and Snapshot
- Performed Standby Rebuild activity using RMAN. Experienced in migrating database from non ASM to ASM
- Experience in administration of Oracle 10g RAC Database in 5 node cluster
- Experienced in RAC database Patchset and Upgradations. Conversion of non RAC database to RAC database in 10g
- Monitoring CRS components like CRSD, OCSSD and EVMD for any kind of cluster related exceptions/errors at synchronization level. Monitoring load on the server, memory usage, disk space etc
Senior Oracle DBA - Softalk Technologies Limited (Cognizant Technologies) - Bangalore
(2019-09 - 2022-10)
Senior Oracle DBA supporting AIRBUS (France) client on Oracle 9i/8i database administration and support.
- Provided end to end administrative support on applications which involves Oracle databases
- Experience on Database level and object level Reorganization. Coordinating with Application team on a daily basis for the implementation of production and non-production changes
- Implemented and maintained database through DBA activities include database backup (Cold, Hot and Import/Export)
- Setup backup recovery procedures using RMAN. Performed hot and cold backups using RMAN
- Experience in cloning/duplicate databases and restorations through RMAN, Hot and Cold backups
- Handled Severity1, Severity2 and Severity3 issues to fix the database issues through Bridge/conference call
- Good Experience in Dataguard Disaster Recovery (standby testing) and Configuration of Standby Databases (Dataguard), Active Dataguard and Snapshot
- Performed Standby Rebuild activity using RMAN. Experienced in migrating database from non ASM to ASM
- Experience in administration of Oracle 10g RAC Database in 5 node cluster
- Experienced in RAC database Patchset and Upgradations. Conversion of non RAC database to RAC database in 10g
- Monitoring CRS components like CRSD, OCSSD and EVMD for any kind of cluster related exceptions/errors at synchronization level. Monitoring load on the server, memory usage, disk space etc. Implementing and maintaining database security (create and maintain users, roles and assign privileges)
- Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters
- Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed
- Monitored the production Oracle alert logs for database errors and system resource availability and responded to system memory and data issues
- Expert with OEM Event and Job Managers, Change Manager, Diagnostics & tuning Packs
