Description :

1. Implemented data guard with maximum availability, protection and performance configurations and worked with data guard fail over and switch over cases at the times of up gradation and migration.
2. Taking backups on scheduled time and monitoring scheduled backups performing backups and recoveries using rman hot backups.
3. Experienced in data center migration of databases to prepare the proof of concept, db migration procedures and scripts, developed templates that include check list for migrating the databases.
4. Configured repository and clients for grid control and also implemented db control for some databases.
5. Utilized oracle streams to capture, propagate and apply the transfer of data, transactions and events within managed databases.
6. Perform database upgrades, migrations; take logical exports from the qa, dev etc instances and importing the data on to the production systems etc.
7. Diagnosed oracle bugs and coordinating with oracle support to resolve them in timely manner.

Experience

5-7 Years

Level

Consultant

Education

B.Sc. CS

Description :

1. Installation and configuration of 12c container databases on standalone servers and clusters on Windows and Unix platforms.
2. Upgraded multiple single-instance databases and grid infrastructure from 11gr2 to 12cr1.
3. Worked on new features on 12c databases, such as recovering tables, masking the fields, and using advanced optimization parameters for good performance of 12c databases.
4. Experience in troubleshooting RAC databases and engaging with the application team to gain performance enhancements for the application in a clustered environment.
5. Applied PSU on a standalone test environment using opatch and the same PSU (grid and rdbms patching) on the production cluster using opatch auto.
6. Supported in performing GoldenGate configuration, administration, installation, also configuring pumps and managing trail files by purging old extract files and log files.
7. Implemented physical standby databases on a 2-node 11gr2 real application cluster and automated scripts to delete archive logs that have already been applied to the standby.

Experience

7-10 Years

Level

Management

Education

B.Sc. CS

Description :

1. Performed replication using materialized views with a complete refresh/fast refresh.
2. Development of policy and procedures as they relate to database maintenance, security and archiving.
3. Providing support to the development team and handling release schedules.
4. Maintaining sound backup and recovery policies and procedures using rman.
5. Monitoring the scheduled backup procedures for daily basis using crontab.
6. Creating, granting and monitoring user access rights and privileges through roles and profiles.
7. Providing instance level performance monitoring and tuning for event waits, sessions, physical and logical io and memory usage with the help of awr and addm reports.

Experience

7-10 Years

Level

Management

Education

B.Sc.

Description :

1. Set up auditing/Oracle transparent data encryption (TDE) for security management.
2. Tuning and troubleshooting databases (improving existing SQL and pl-sql code, creating triggers, procedures, and packages) - tuning instances for optimal performance.
3. Tuning database for better performance using awr/addm/oem report and manual scripts.
4. Use the dbms_sqltune, dbms_sql_monitor packages for real-time SQL monitoring.
5. Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability involved in the installation/configuration/maintenance of Oracle RAC/asm databases and troubleshooting rac performance issues.
6. Troubleshooting replication and other Oracle-related issues and implementing resolutions.
7. Performing day-to-day database administration tasks including installation, upgrades, backup/recovery, monitoring, disaster recovery procedures (switchover/failover), and database cloning across environments, patching.

Experience

5-7 Years

Level

Consultant

Education

B.S. in CS

Description :

1. Implemented switchovers on primary and standby databases as a part of planned maintenance activities.
2. Implemented dataguard, creating both logical and physical standby databases in 10g and 11g RAC environment for a production database.
3. Installing Oracle golden gate on rhel and setup table level replication as well as ddl replication too.
4. Migrate database across different servers and platforms using transportable tablespaces and data pump export/import and perform database refresh and RMAN cloning.
5. Planned and implemented disaster recovery solutions using Oracle standby database/data guard and performed data replication using golden gate technology.
6. Rebuild indexes, table partitioning, tuning memory usage and SQL tuning using explain plan, SQL trace, tkprof and statspack for best performance.
7. Automated the data replication process using materialized views for reporting databases.

Experience

7-10 Years

Level

Management

Education

BSc in CS

Description :

1. Cluster-wide resource management such as create resource plan, service configuration, parallel instance group, application isolation.
2. Installation and creation of 11g databases for testing & development on both IBM-Aix and the linux environment in OLTP, decision support system data warehousing environment.
3. Work with Oracle data pump which provides high speed, parallel, bulk data and metadata movement of Oracle database contents.
4. Management of schema objects, partitioning of tables & indexes and performing sqlloader jobs for loading data from flat files (ETL) and Oracle database monitoring, troubleshoot and resolve the issues.
5. Monitoring growth of tables and undertaking necessary re-organization of a database, capacity planning.
6. Designed the logical and physical database structure and involved in logical, physical data modeling.
7. Provide support to developers to enhance their SQL, Pl/SQL code and responsible for setting up new user accounts, schema deployments, and related user administrative tasks.

Experience

7-10 Years

Level

Management

Education

BSc

Description :

1. Monitored different databases and application servers using oracle enterprise manager 10g grid control.
2. Design, document, implement and maintain all disaster recovery procedures which result in no data loss.
3. Provided assistance to memory corruption and dictionary corruption errors.
4. Database tuning by generating explain plans for long-running queries, creating indexes on columns to improve performance.
5. Tested and implemented restore procedures for complete and incomplete recovery using RMAN.
6. Set up and manage database security by creating new users, roles, profiles, and provide required user privileges in development and production environments for implementation and maintenance of user security.
7. Perform daily monitor of real-time replication as well as detailed reports database links, creating, managing table-spaces and data files.

Experience

7-10 Years

Level

Management

Education

M.S. CS

Description :

1. Performed database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, and cloning on the above said versions.
2. Creating the database, table spaces, tables, indexes, setting privileges and user logins.
3. Data refresh of large production data warehouse environment to setup test, development environments using san level storage mirroring: gold image copy and cloning.
4. Handled high volume production databases around 25 tb size along with physical standby databases proficient in oracle high availability features like rac, data guard, grid control and oracle performance tuning utilities like addm, awr, ash, sql-tuning advisor, explain plan, tk prof, dbv.
5. Performed data file recovery from logical and physical block corruptions good understanding and implementation expertise in rac, asm, data guard like remedy change and user tickets, frequently communicate effectively with technical and non-technical customers.
6. Continuous monitoring of performance during peak and non-peak loads using awr reports, ash, addm and optimization SQL code using SQL trace, tkrpof, explain plan.
7. Implemented security measures, achieving compliance with industry standards and reducing unauthorized access incidents.

Experience

5-7 Years

Level

Consultant

Education

B.Sc. CS

Description :

1. Monitoring and optimizing the performance of the database/application using OEM along with homespun scripts.
2. Involved in the installation, configuration and extended support to oracle 11g, 10g two node rac with asm file system on sun solaris platform.
3. Implementing data pump, conventional export/import utility of oracle 11g, 10g for re-organizing databases/schemas/tables to improve the performance.
4. Database monitoring/maintenance, replication process and performance tuning using oem automated the processes like moving files, managing alert log, efficient backup by developing unix scripts.
5. Installed oem grid control that includes oracle agent, management repository and management service on vmware red hat linux virtual machine.
6. Applied patch set to upgrade software and use database upgrade assistant, export/ import and manual scripts to upgrade databases.
7. Automated routine database tasks, increasing operational efficiency by 40% and reducing manual errors.

Experience

7-10 Years

Level

Management

Education

BSc CS

Description :

1. Supporting multiple databases for production, development, test, and staging purposes on Sun Solaris and Windows environments.
2. Applying upgrade patch, maintenance and interim (opatch) patches on all the databases. Refreshing dev and test instances with data from production regularly.
3. Developed pl/SQL packages, DML, DDL, Oracle tables, stored procedures, functions, cursors, triggers, and UNIX shell scripts.
4. Thorough knowledge of setting up infrastructure for databases in huge data centers.
5. Scheduling repetitive activities like gathering schema statistics, exports, and table space usage report using crontab.
6. Installed and configured Oracle 11g database on a test server using Oracle standard procedures of, for performance testing and future 10g production implementation.
7. Develop data warehouse process models, including sourcing, loading, transformation, and extraction.

Experience

7-10 Years

Level

Management

Education

B.Sc. CS

Description :

1. Worked in MasterCard International as an Oracle Database Administrator.
2. Distributed by the company are done so under the MasterCard brand, which is one of the three major credit cards accepted at vendors across the world.
3. Provided to card holders is controlled by the financial institution that issues the card and not MasterCard.
4. Decided database server as part of Cost Analysis and Performance.
5. Setup Oracle Golden Gate with classic & integrate capture and upgrade.
6. Designed database architecture with installation Oracle 11g on Linux.
7. Migrated/Upgraded OLTP/OLAP database to the new Linux Oracle RAC and RacOne.
8. Expert in implementing complete setup and support of RAC environment with major components like ASM, DIAG, RDBMS, Services, Patches, Disks, Grid Control, EXADATA update/upgrade etc.

Experience

10+ Years

Level

Senior

Education

B.Sc. CS

Description :

Experience

2-5 Years

Level

Junior

Education

B.Sc. CS

Description :

1. Managed 1500+ databases in production support for large-scale Oracle databases, which includes both Production and Non-production.
2. Installed, configured, patched, and upgraded database versions 10.2 and 11.2.
3. Involved in designing and implementation from scratch in Oracle 11gR2 RAC on RHEL and Have a good experience in Grid infrastructure home (11gR2) for standalone server / RAC with ASM.
4. Involved in database migration activities, Oracle Database Cloning and Implemented Data guard Oracle 10g for High-Availability Managed OEM Grid Control/12c Cloud control
5. Extensively worked in designing, implementing and integrating of multiple application databases & Good experience in Data migration using the exp/imp and Data pump export/import utility.
6. Managed in production support for Large Scale Oracle databases with SAP environment.
7. Installed patch/Patch set/Bundle patch (SBP) for SAP and Non-SAP databases.

Experience

2-5 Years

Level

Junior

Education

BSc CS