Installed and configured Oracle 10g, 11g, 12c, RMAN, data Guard, Oracle 10g, 11g, PL/SQL, UNIX, Linux, AIX, HP-UX, AIX, and C.
Performed Oracle DBA duties including creating and managing table spaces, tables, indexes, views, sequences, Triggers, procedures, functions, Cursors, and packages using Oracle enterprise Manager (OEM).
Worked on creating and managing Oracle data Guard, RMAN, and cloning of databases. Involved in the development of SQL, PL/SQL, and shell scripts.
Work with Oracle DBA to create and maintain database tables, views, indexes, synonyms, sequences, and triggers.
Manage and maintain the OLTP database and data warehouse using Oracle 11g and DB2. Experience in working with the team to develop the application.
Provide programming support to the team and ensure that the system is functioning as per the requirements. (i.
Senior Oracle Database Administrator
Preschool of America
Performed database administration and migration of Oracle databases from 9i to 10g and 11g on Windows server. Worked on software installation and upgrades.
Performed database administration tasks like creating and maintaining users, roles, profiles, and assigning the required privileges to the Oracle RAC server.
Managed the DBA team to design and implement Oracle 12c databases, including installation, configuration, and administration of the Oracle 10g database.
Responsible for the development, maintenance, and administration of Oracle database and RDBMS databases. This includes installation, configuration, patching, cloning, and performance tuning.
Created and maintained Oracle RAC databases and UNIX shell scripts for the organization. This includes installation of database, application Server administration, and documentation.
Installed and configured Oracle 10g RAC and HP-UX on Redhat Linux server. Implemented database design and administration.