Key Responsibilities:• Member of Rogers DBA team and was part of Oracle 12c/11g/10g/9i RAC and Standalone support of DEV/UAT/PET/PET/PROD databases running on AIX, Solaris, HP and Exadata boxes.• Implemented High availability using Golden Gate Replication. • Having knowledge about oracle cloud • worked on migration of databases using oracle golden gate with low downtime for applications• Responsible for SQL query tuning optimization, index rebuild , performance tuning using tools such as AWR, ADDM• Resize database by reorganising the schemas• Provided extended support whenever required and during planned activities.• OEM and DBMCLI email alert monitoring setup for Exadata rack, Cluster, ASM, DB and listener resources.• Analysis of AWR and ADDM reports for different times of the day for analysis of wait events and identify poorly performing SQL statements• Performance tuning of application by identifying the SQL, which are not written well providing inputs to the application programmer correcting and implementing the right components.• Experienced in assessing patch requirements for upgrade and security patch with Opatch and patch set• Creation of database monitoring alerts on Grid Control / CRON • Hands on experience of Maria DB administration (create users, import/export with Maria DB)• Recovered and restored Database, tables dropped accidentally, data files, and recovered database from Block Corruption• Created technical documentation of DBA procedures on various database activities• Providing application DBA support by coding utilities, responding to user questions, and resolving problems.• Created database schemas, tablespaces, users, tables, PL/SQL stored procedures as per user request.• Undertook periodic data refresh of DEV/UAT/PET/PROD databases from production using datapump and traditional export/import utility.

Key Responsibilities: Administer Databases of various sizes up to 1TB, Production Database Administration support (24x7) Implemented Oracle Databases and related infrastructure across various platforms including AIX, HP-UX, Sun, Linux, and Microsoft Windows.  Migrated Production database from 11.2.0.3 to 12c, and 10.2 to 10.4 Converted Databases to ASM. Also converted Tablespaces to ASM Configured Oracle Enterprise Manager/Grid Control to generate alerts for critical thresholds Automated hot backups using a combination of incremental and full RMAN and Data pump backups Monitored and troubleshoot database using OEM and Toad, Enabling and analyzing trace files Responsible for SQL query tuning optimization, index rebuild , performance tuning using tools such as AWR, ADDM Exports, refresh test DB from production site to build development, testing, staging DB’s Capacity planning of databases and creation of databases  Administration and support for Production/Developments/QA environments. Complete the Life Cycle procedures for Oracle database (Installation, Patching/Upgrading, Monitoring, Backup and Recovery, and Decommissioning)  Supported Security User Management, grant and revoke privileges, Roles, Auditing, Profiling, Authentication Query tuning using Explain Plan / Stats Pack/ AWR / SGA tuning  Recovered Database(Recovered from Media Failure, Recovered tables dropped accidentally, data files, and from Block Corruption) Installed and configured Grid Control to monitor all databases centrally Worked with Performance issues with RAC environment