Oracle Certified Expert 10G RAC

Oracle Certified Professional 10G DBA

Oracle Certified Professional 8i DBA

Profile

• Having 15.5 years of strong experience in Oracle 8x, 9i, 10G R2, 10G R2 RAC, 11G R2 Grid control, 12C CLOUD Control, 11G R2, 11G R2 RAC, 12C, Exadata Database Machine X2,X3 and X4 Database Administration, proficient in managing Development, Test and production environment.
• Provided technical support for various databases and Applications to assure ongoing, 24/7, fully operational conditions.
• Monitored database activity and database space usage and ensured necessary resources are adequate and present. Investigated and resolved critical database issues of significance. Having good knowledge of various Oracle database administration tools and must be adept at devising solutions for database issues.
• Experience as a technical project leader and provided leadership role for less experienced personnel on a portfolio of databases, including installations and upgrades of DBMS software and backup/recovery strategies. Reviewed and approved database designs to ensure that application solutions exhibit high levels of performance, security, scalability, maintainability, and reliability upon deployment.
• Designed and tested database installation, implementation and recovery scenarios. Determined the test to use and collects appropriate data according to established guidelines. Participated in analysis, development and implementation of unique database recovery plans in response to client-impacting outages.
• Planned and installed upgrades of database management systems DBMS software as necessary to enhance database performance. Researched various and software products Recommended solution and implemented approved products.
• Expertise in implementing and supporting database security regulations, policies, and guidelines. Monitors security bulletins to obtain information of potential threats installs necessary security patches to ensure ongoing database security.
• Optimized database accessibility by developing process to eliminate down time for backup processes. Implemented limitation to database accessibility based upon information security level and ensures data spillage from more secure to less secure databases does not occur.
• Expertise in monitoring of database activity and file usage, and ensured necessary resources are present. Determined data to collect and analyzed information as appropriate. Investigated and resolved technical database issues of significance.
• Expertise in analysis and determination of database performance characteristics, informational needs and elements, data relationships and attributes, proposed manipulation, data flow and storage requirements, and data output and reporting capabilities for more complex databases. Recommended and implemented tuning opportunities to improve system response and run times.
• Integrated databases and commercial backup software resolved conflicts between databases and of the commercial backup software and operating systems.
• Provided Database Administration services for the database size varying from Medium to Large 100 GB to 3 TB .
• Excellent communication skills, Problem solving skills on any business issue and also a good team player.

WORK EXPERIENCE:

Confidential

Role : Sr. Oracle Database Administrator

Responsibilities: Oracle DBA

• Responsible for handling, troubleshooting and supporting the production, development, testing and QA environments on IBM AIX, Solaris, HP and Linux servers.
• Expertise in database server installation, configuration, customization and performance tuning of the oracle products and including oracle clients. Creation of database objects tables, indexes, keys, triggers, views , granting object permissions. Created and maintained referential integrity relationships using constraints. Database backup and recovery, database export/import, listener management, monitoring server performance.
• Expertise in installation, configuration of 11G R2 RAC.
• Experience in installation, configuration, maintenance and administration of OEM 12C CLOUD control.
• Ensured database performance is maintained at optimal levels and is able to support defined business requirements by collecting and evaluating database performance statistics. Implementation and troubleshoot of database backup/recovery using RMAN.
• Experience with database tuning using SQL Tuning advisor, explain plan, SQLT, AWR, ADDM, ASH and OEM SQL monitor.
• Developed several UNIX shell scripts to automate database operation, monitor the database and various trace file cleanup jobs.
• Experience with implementation of oracle partitioning including 11G interval partitioning.
• Experience in installation and configuration of 11G R2 Dataguard and expertise in troubleshooting and maintenance of standby databases including gap resolution.
• Experience with oracle automatic memory management.
• Experience in setting up and administering Oracle database security environment. User management, creation and assignment of roles, monitor space requirements and maintain table spaces, creation and maintenance of tables, indexes and other database objects.
• Participated in NY state datacenter consolidation project. Currently working on consolidating databases across the agencies of NY State.
• Proficient with installation and management of ASM.
• Experience working with Oracle Support to report and resolve high priority issues/bugs related to database environment.
• Performed Backup and Recovery using RMAN integrated to Tivoli Storage Manager V5.4 on 10G R2 and 11G R2 RAC. Diagnosed and resolved failed database backups. Performed oracle home cloning, database cloning, oracle exp/imp, expdp/impdp as required for various projects. Expertise in RMAN backup, database cloning using RMAN and troubleshooting RMAN issues.
• Experience in troubleshoot and resolve Oracle database performance issues, database capacity issues, replication, and other distributed data issues.
• Developed technical documentation, provided knowledge transfer and mentored junior DBAs.
• Provided technical support and troubleshooting support to various applications and assisted developers to identify root cause of production/development issues and resolve them based on the priority of helpdesk ticket to maintain high availability of database systems.
• Development and maintenance of daily system verification and monitoring procedures to validate database status and availability.

Confidential

Role : Sr. Oracle Database Administrator

Responsibilities: Oracle DBA

• Responsible for handling, troubleshooting and supporting the production, development, testing and QA environments on IBM AIX, Solaris, HP and Linux servers.
• Expertise in database server and GI installation, configuration, customization and performance tuning of the oracle products and including oracle clients. Creation of database objects tables, indexes, keys, triggers, views , granting object permissions. Created and maintained referential integrity relationships using constraints. Database backup and recovery, database export/import, listener management, monitoring server performance.
• Experience in implementation and administration of OEM 10G/11G GRID control.
• Ensured database performance is maintained at optimal levels and is able to support defined business requirements by collecting and evaluating database performance statistics. Implementation and troubleshoot of database backup/recovery using RMAN.
• Experience in setting up and administering Oracle database security environment. User management, creation and assignment of roles, monitor space requirements and maintain table spaces, creation and maintenance of tables, indexes and other database objects.
• Worked on scheduling periodic jobs in support of Oracle databases backups, statistics collection, log file clean-up, etc. . Developed and maintained Oracle database operational procedures.
• Participated in TIAA-CREF database upgrade and consolidation project Oracle 10.2.0.4 to Oracle 11.2.0.3 .
• Performed Backup and Recovery using RMAN integrated to Tivoli Storage Manager V5.4 on 10G R2 and 11G R2 RAC. Diagnosed and resolved failed database backups. Performed oracle home cloning, database cloning, oracle exp/imp, expdp/impdp as required for various projects. Expertise in RMAN backup, database cloning using RMAN and troubleshooting RMAN issues.
• Provided technical support and troubleshooting support to various applications and assisted developers to identify root cause of production/development issues and resolve them based on the priority of helpdesk ticket to maintain high availability of database systems.
• Development and maintenance of daily system verification and monitoring procedures to validate database status and availability.
• Experienced in Production support functions such as performing technical support for the analysis, maintenance, and enhancements of the Oracle databases, and other new database maintenance projects. Detection and troubleshooting ORA-600, ORA-7445, ORA-4031 errors, working with Oracle tech support, following up with them and resolving them.
• Designed, developed and created database file system layouts and drive distribution. Monitored and applied software patches as per the release notification guidelines.
• Developed and debugged several UNIX shell scripts with a thorough knowledge of language syntax and structure. Developed shell scripts for database monitoring, RMAN backups and cleanup jobs.
• Experience in development and implementation of large scale applications involving on-line OLTP and batch environments for various applications. Developed and scheduled various jobs for regular data refresh from OLTP to WH environments.
• Implementation, setup, administration and troubleshooting 11G R2 Data guard and Data guard failover, archive log gap resolution.
• Migration of database objects from development to test tier, test tier to QA tier and QA tier to production tier. Refreshed development/test databases from copies of production.
• Administration and maintenance of Apache and weblogic application servers.
• Monitored OS resource usage like CPU and memory using tools like TOPAS and OEM grid control and cloud control. Experience with AWR, ADDM to identify system/DB bottleneck areas, wait event tuning and SQL tuning.
• Maintenance and support of Informatica, Autosys and Eagle application environment. Administration of informatica power center and perform object deployments and migrations on repositories from DEV to INT/UAT/QA and PROD.
• Having strong experience with Informatica Powercenter administration.
• Automation of AWR report generation for performance tuning.
• Good knowledge of Installation, configuration, monitoring and administering oracle golden gate including the implementation of data replication.

Confidential

Role : Sr. Oracle Database Administrator

Responsibilities: Oracle DBA

• Responsible for handling, troubleshooting and supporting the production, development, testing and QA environments on IBM AIX servers.
• Expertise in designing Oracle databases starting from defining and collecting the requirements including logical physical database design. Participated in evaluation/review of database design specifications application coding routines to ensure adherence to best practices for database usage using tools like ERwin Data Modeler v 4.1 and ER Studio Suite v 7.0.
• Generation of physical models from logical models and compare models to models data bases and participate in the data model approval process.
• Design and implementation of database backup/recovery using RMAN.
• Experience in implementing 3Oracle Enterprise Manager 10g GRID Control. Installed and configured Grid control version 10.2.0.5.
• Ensured database performance is maintained at optimal levels and is able to support defined business requirements by collecting and evaluating database performance statistics.
• Applied patches on Oracle server to upgrade it from 10.2.0.2 to 10.2.0.3 10.2.0.3 to 10.2.0.4.
• Applied critical CPU patches including Apr 2009 CPU, July PSU and Oct PSU 2009.
• Experience in setting up and administering Oracle database security environment. User management, creation and assignment of roles, monitor space requirements and maintain table spaces, creation and maintenance of tables, indexes and other database objects.
• Worked on scheduling periodic jobs in support of Oracle databases backups, statistics collection, log file clean-up, etc. . Developed and maintained Oracle database operational procedures.
• Involved in NYSDOT system upgrade project Oracle 9.2.0.1, 9.2.0.5 to Oracle 10.2.0.4 and 10.2.0.4 to 11.1.0.6 and 11.2.0.1 .
• Performed Backup and Recovery using RMAN integrated to Tivoli Storage Manager V5.4 on 10G R2 and 10G R2 RAC. Diagnosed and resolved failed database backups.
• Performed oracle home cloning, database cloning, cold backup/Hot backups, Oracle exp/imp, expdp/impdp as required for various projects.
• Provided technical support and troubleshooting support to various applications and assisted developers to identify root cause of production/development issues and resolve them based on the priority of helpdesk ticket to maintain high availability of database systems.
• Daily system verification and monitoring procedures to validate database status and availability. Expertise in RMAN backup, Database cloning using RMAN and troubleshooting RMAN issues. Expertise in Oracle backup and recovery, high availability, and disaster recovery options including RMAN.
• Experienced in Production support functions such as performing technical support for the analysis, maintenance, and enhancements of the Oracle databases, and other new database maintenance projects., checking for ORA-600, ORA-7445, ORA-4031 errors and creating SRs with Oracle tech support and following up with them and resolving them.
• Designed, developed and created database file system layouts and drive distribution. Monitored and applied software patches as per the release notification guidelines.
• Developed and debugged several UNIX shell scripts with a thorough knowledge of language syntax and structure. Developed shell scripts for database monitoring, RMAN backups and cleanup jobs.
• Experience in development and implementation of large scale applications involving on-line OLTP and batch environments for various applications. Developed and scheduled various jobs for regular data refresh from OLTP to WH environments.
• Expertise in database server installation, configuration, customization and performance tuning of the oracle products and including oracle clients. Creation of database objects tables, indexes, keys, triggers, views , granting object permissions. Created and maintained referential integrity relationships using constraints. Database backup and recovery, database export/import, listener management, monitoring server performance and tuning.
• Implementation, setting up and administered 10G Data guard and Data guard failover under disaster recovery project for the organization.
• Migration of database objects from development to test tier, test tier to QA tier and QA tier to production tier. Refreshed development/test databases from copies of production.
• Monitored OS resource usage like CPU and memory using tools like TOPAS and OEM grid control. Worked on AWR, ADDM to identify system/DB bottleneck areas, wait event tuning, SQL tuning.
• Experience with Oracle Business Rule Author User Data functionality.
• Experience in loading and managing large volumes of data using SQL loader. Configured, executed and troubleshooting SQL Loader in a QA/production environment.
• Managed and maintained materialized views for distributed databases, configured and administered oracle streams for enterprise reporting environments.
• Participate with the database administration team with normalization, standardization, and quality control of data.
• Implemented, maintained and supported 24/7 10g RAC on IBM P570 Hardware and GPFS file system.

Confidential

Role : Sr. Oracle Database Administrator

Responsibilities: Oracle DBA

• Responsible for handling and supporting the Production, Development, testing and QA Environments on IBM AIX servers.
• Responsible for providing backend support for the development, testing and acceptance environments for peoplesoft Financial, portal and EPM Applications relying on Oracle10G.
• Troubleshoot peoplesoft, database and network issues effectively.
• Experience installation, configuration and performance tuning of the Oracle products.
• Installed, configured and administered Oracle 10g OEM Grid control and Oracle Management Server.
• Experience in development and implementation of large scale applications involving on-line OLTP and batch environments for various applications. Developed and scheduled various jobs for regular data refresh from OLTP to WH environments.
• Expertise in designing Oracle databases starting from defining and collecting the requirements including logical physical database design. Experience in oracle database modeling using ERwin.
• Expertise in Oracle backup and recovery, high availability, and disaster recovery options including RMAN.
• Design and implementation of database backup/recovery, database monitoring and tuning.
• Oracle Database security, user management, creation and assignment of roles, monitor space requirements and maintain table spaces, creation and maintenance of tables, indexes and other database objects.
• Performed oracle home cloning, database cloning, Cold backup/Hot backups, Oracle exp/imp, as required for various projects.
• Trouble shooting and identifying root cause of production/development issues and resolve them based on the helpdesk ticket priority to maintain high availability.
• Daily system verification and monitoring procedures to validate database state and availability.
• Performed day-to-day database administration tasks such as monitoring of database, sizing of redo logs, database processes, rebuilding and reorganizing indexes, monitoring disk space usage and archival, backup status, and other periodic maintenance tasks.
• Performed database upgrades from Oracle 9i 9.2.0.6 to 10g 10.2.0.2 .
• Worked with Oracle support in opening, managing, and resolving TAR's.
• Applied patches on Oracle server to upgrade it from 10.2.0.1 to 10.2.0.2.
• Applied several quarterly critical CPU patches.
• Applied daylight saving patches DST for Oracle 10G.
• Managed system change log to track patch management for existing environments.
• Performed Backup and Recovery using Lagato Networker.
• Developed shell scripts for cold backup, hot backup, compressing archived log files, purging log files on specific date intervals, trace files, alertlog errors, check for missing archived log files, rolling over different log files, bouncing listener on weekly basis.
• Developed and debugged several UNIX shell scripts with a thorough knowledge of language syntax and structure. Developed shell script for weekly tablespace growth monitoring.
• Worked extensively with tools like Quest TOAD DBA module and SQL TUNING module .
• Optimized Query for optimal Performance, Session Performance and Reliability.
• Performed Database cloning and Oracle home cloning.
• Trained and mentored junior DBA members.

Confidential

Role : Oracle Database Administrator

• Responsible for handling and supporting the Production, Development and testing Environment.
• Provided technical support for various databases and Applications to assure ongoing, 24/7, fully operational conditions.
• I was responsible for installation, configuration and performance tuning of the oracle products and maintenance of the Oracle databases on Linux 2.4 Enterprise server and AIX servers.
• Expertise in designing Oracle databases starting from defining and collecting the requirements including logical physical database design.
• Managed and supports application on Web sphere app server on Oracle 9i databases and customization to support business rules.
• Experience in oracle database modelling using Erwin 4.1..
• Experience in Performance Tuning of Reports of the application. Tuned the reports using EXPLAIN PLAN, HINTS, and TKPROF.
• Performed oracle home cloning, database cloning, cold backup/Hot backups, Oracle exp/imp, as required for various projects.
• Experience in development and implementation of large scale applications involving on-line OLTP and batch environments for various applications. Developed and scheduled various jobs for regular data refresh from OLTP to WH environments.
• Expertise in Oracle backup and recovery, high availability, and disaster recovery options including RMAN.
• Oracle Database security, user management, creation and assignment of roles, monitor space requirements and maintain table spaces, creation and maintenance of tables, indexes and other database objects.
• Applied patches on Oracle server to upgrade it from 9.2.0.1 to 9.2.0.4 and 9.2.0.4 to 9.2.0.6.
• Migration of various database objects from Oracle to DB2 and DB2 to Oracle.
• Implemented and converted logical data model to physical data model and implemented physical data model with optimum performance.
• Developed and debugged several unix shell scripts with a thorough knowledge of language syntax and structure.
• Worked in developing and implementing Physical and Logical design of database.
• Worked extensively with tools like Quest TOAD and ERWIN.
• Optimized Query for optimal Performance, Session Performance and Reliability.
• Involved in modifying database procedures, functions and triggers using PL/SQL according to the project requirements.
• Wrote UNIX shell scripts for export / import of data on weekly basis.

Responsibilities as DB2 DBA

• Monitoring Runstats and Reorgchk using DB2 v8.1
• Upgrade of DB2 UDB databases from DB2 v8.1 to DB2 v8.2
• Installation/Configuration of DB2 Database Instances.
• Setup db2 production database replica for development team using Db2look and db2move to export/import the data.
• Creating connections to DB2 server and troubleshooting DB2 server and clients.
• Moving very large tables from 8K tablespace to 16K tablespace to avoid reaching the maxlimit for the tablespace
• Installed and Configured C compiler for DB2 to enable it for creating and running stored procedures.

Confidential

Title: Database Administrator

Responsibilities

• Managed databases on Oracle 8i/9i/ Versions 8.0.x, 8.1.x and 9.0.x .
• Expertise in designing Oracle databases starting from defining and collecting the requirements including logical physical database design.
• Database maintenance: refreshing data, consistency checking, defining and implementing backup strategies.
• Experience installation, configuration and performance tuning of the Oracle products.
• Especially involved in Performance Tuning tuning the Reports developed as part of the project. Tuned the reports using EXPLAIN PLAN, HINTS, and TKPROF.
• Performed oracle home cloning, database cloning, cold backup/Hot backups, Oracle exp/imp, as required for various projects.
• Experience in development and implementation of large scale applications involving on-line OLTP and batch environments for various applications. Developed and scheduled various jobs for regular data refresh from OLTP to WH environments.
• Experience in oracle database modelling using ERwin.
• Created Materialized Views/Snapshots and Indexes as part of the tuning exercise.
• Creating the Database, tablespaces, database objects, setting object privileges, indexes, user logins, security etc.
• Expertise in Oracle backup and recovery, high availability, and disaster recovery options including RMAN.
• Monitored application and database performance, database security,
• Developed and debugged several unix shell scripts with a thorough knowledge of language syntax and structure.
• Used SQL LOADER utility for transferring data across different platforms.
• Used OEM Oracle Enterprise Manager and DBA Studio for day-to-day activities on the databases.
• Worked in close conjunction with the Developers and Testers.
• Systems supported include Development and Production environments.

Environment: Oracle 8i/9i, SUN Solaris 9.0

Confidential

Title: Software Engineer

• Experience installation, configuration and performance tuning of the Oracle products.
• Created primary database storage structures tablespaces .
• Created primary objects tables, views, indexes .
• Modified the database structure, as necessary, from information given by application developers.
• Experience in development and implementation of large scale applications involving on-line OLTP and batch environments for various applications. Enrolled users and maintained system security.
• Performed oracle home cloning, database cloning, cold backup/Hot backups, Oracle exp/imp, as required for various projects.
• Reduced Disk I/O, tuning buffer cache, optimised memory performance, sizing indexes.
• Performed alteration, modification creation of tables, table-spaces, indexes and other database objects.
• OEM Oracle Enterprise Manager and SQL plus.
• Developed and debugged several UNIX shell scripts with a thorough knowledge of language syntax and structure. Developed SQL scripts for different purposes like monitoring the users' processes, space management.
• Conducted daily weekly export import jobs. Rectification of errors occurred during the export and Import jobs.
• Controlled and Monitored user access to the database.
• Planned for backup and recovery of database information.
• Created stored procedures and database triggers.
• Allocated system storage and planned future storage requirements for the database system.

Environment: Oracle 8x, Win2k