PROFESSIONAL EXPERIENCE:

Confidential, PA

Sr. Oracle Database Administrator

Responsibilities:

• Providing 24*7 L2 Database administration support for more than 4000+ Databases
• Oracle GRID infrastructure/ RAC installation, Up gradation and patching.
• RMAN TAPE backup configuration using Net backup /Data Domain third partly library
• Oracle Database Backup and Recovery using RMAN tape backup.
• Physical standby database (Data Guard) configuration and management.
• Oracle data Guard broker configuration.
• OEM Agent installation, Target deployment, Metric and Template creation.
• Data Replication using GOLDNE GATE and management.
• Database Refreshes from production to pre - production, QA, testing environment using RMAN, EXPDP.
• Oracle Database performance assessment using AWR (Automatic work repository)/ADDM (Automatic database diagnostic monitor), OEM, SQL Plan Management, SQL profiling.
• Use OEM utilities like Memory Advisors, SQL advisors, Segment Advisors, and ADDM.
• Post incident Root cause Analysis.
• Database statistics collection using DBMS STATS or Analyze.
• Database Performance Tuning using SQL Tuning advisor.
• SMOP creation for database change implementation.
• Apply CPU (Critical patch update) and PSU (Patch set Update) in Production, Q/A, Testing and Development Environment.
• Interface with Oracle Corporation using My Oracle Support for critical incidents.
• Worked on ticket managing tool JIRA.

Environment: Oracle Database 12c, 11gR2, OEM, UNIX Shell scripting.

Confidential, TX

Sr. Oracle Database Administrator

Responsibilities:

• Oracle GRID infrastructure/ RAC installation, Up gradation and patching.
• Oracle Database Backup and Recovery using RMAN.
• Physical standby database(Data Guard) configuration and management
• Planning, Testing and Migration of Database schema from UNIX system to Linux system using EXPDP/IMPDP, shell scripts, SQL/PLSQL script and GOLDEN GATE.
• Database schema Deployment and Periodic up gradation.
• Logical database management (schema management).
• Distributed Database management using Materialized view, DB link, Public Synonym. Golden Gate
• Database Refreshes from production to pre-production, QA, testing environment using DB Link, DATA PUMP.
• Development of UNIX script for Database schema management automation and code deployment.
• Oracle Database performance assessment using AWR(Automatic work repository)/ADDM(Automatic database diagnostic monitor)
• Use OEM utilities like Memory Advisors, SQL advisors, Segment Advisors, and ADDM.
• Maximum availability architecture (MAA) implementation.
• Database statistics collection using DBMS STATS or Analyze.
• Database Performance Tuning using SQL Tuning advisor.
• Creation of stored outlines for performance stability.
• Secure database connection set up using oracle wallet and oracle native encryption.
• Preparation and Implementation of Change request in production Environment.
• Experience of client configuration for Oracle Directory Services and Active Directory integration
• Installation and Up gradation oracle software in QA, Testing and Development Environment.
• Apply CPU (Critical patch update) and PSU (Patch set Update) in QA, Testing and Development Environment.
• Interface with Oracle Corporation using My Oracle Support for critical incidents.

Environment: Oracle Database 11gR2, PL/SQL, UNIX Shell scripting.

Confidential, MI

Sr. Oracle Database Administrator

Responsibilities:

• Installation, configuration and up gradation of Oracle server software 11g RAC and related products.
• Establish and maintain sound backup and recovery policies and procedures using RMAN (Recovery Manager) and EXPDP/IMPDP.
• Configure and manage physical stand by database using DATA GURAD.
• Migration of Databases from UNIX system to Linux system using EXPDP/IMPDP, shell scripts, SQL/PLSQL script and GOLDEN GATE.
• Implement and Maintain ODS (Operational data source).
• Oracle Database performance assessment using AWR(Automatic work repository)/ADDM(Automatic database diagnostic monitor)
• Use OEM (Oracle Enterprise Manager) utilities like Memory Advisors, SQL advisors, Segment Advisors, and ADDM.
• Maximum availability architecture (MAA) implementation.
• Database schema Deployment and Periodic up gradation and maintenance.
• Database statistics collection using DBMS STATS or Analyze.
• Identification and Tuning SQL queries.
• Monitoring and Resolving Database session LOCKS.
• Database Security implementation and management for SOX controls.
• Secure database connection set up using oracle wallet and oracle native encryption.
• Provide 24*7 technical L3 support for PL/SQL ETL (Extract Transport and Load) tool.
• Database Refresh from production to testing environment using DB Link, Export/Import.
• Configuring and Monitoring Tablespace utilization, Database growth for estimation and future space requirement.
• Database space management using DBMS ADMIN, Table/Index rebuild.
• Database Clean up by Archiving and rebuilding Table/Indexes, Dropping temporary tables.
• Monitoring and repairing any invalid and unused indexes.
• Requesting system DBA for new schema creation and additional storage addition.
• Participation in weekly change review meeting.
• Construct the database changes for existing application.
• Conducting code walks through and reviews of database deployment.
• Review the change deployment in production environment.
• Prepare and execute database change deployment plan.
• Providing database solutions using GM ticketing management tools.
• Involved in catch and throw Transition activities during initial phase of the project.
• Interface with Oracle Corporation using My Oracle Support for critical incidents.

Environment: Oracle Database 11g, PL/SQL, SQL Developer, UNIX Shell scripting, Oracle Enterprise Manager (OEM)

Confidential

Oracle Database Administrator

Responsibilities:

• Planning, Testing and Migration of Database schema from testing system to Production system using shell scripts, Database Link, SQL Loader, Export/Import.
• Create and maintain Logical data model using Enterprise Architect/ERwin.
• Development and Testing database set up.
• Physical data model management using SQL Developer.
• Data refresh from production to development and testing environment using DB Link, Export/Import
• Oracle Database performance assessment using AWR(Automatic work repository)/ADDM(Automatic database diagnostic monitor)
• Database statistics collection using DBMS STATS or Analyze.
• Identification and Tuning of SQL queries.
• Monitoring and Resolving Database session LOCKS.
• Configuring and Monitoring Tablespace utilization, Database growth for estimation and future space requirement.
• Database space management using DBMS ADMIN, Table/Index rebuild.
• Database Clean up by Archiving and rebuilding Table/Indexes, Dropping temporary tables.
• Monitoring and repairing any invalid and unused indexes.
• Requesting system DBA for new schema creation and additional storage addition
• Implement and maintain database security (create and maintain users and roles, assign privileges)
• Perform general technical trouble shooting and give consultation to development teams
• Interface with Oracle Corporation using My Oracle Support for critical incidents.

Environment: Oracle Database 10g, 11g, PL/SQL, SQL DEVELOPER, Enterprise Architect, UNIX Shell scripting.

Confidential

Oracle Database Administrator

Responsibilities:

• Installation, configuration and up gradation of Oracle server software 10g RAC, 11g RAC and related products.
• Evaluate Oracle features and Oracle related products.
• Establish and maintain sound backup and recovery policies and procedures using RMAN (Recovery Manager)
• Configure and manage physical stand by database using DATA GURAD.
• Perform Live DR-DRILL half yearly.
• Implement and maintain database security (create and maintain users and roles, assign privileges)
• Database Performance Tuning
• Configuring and Monitoring Tablespace utilization, Database growth for estimation and future space requirement. (Capacity planning)
• Work as part of a team and provide 24X7 supports.
• Perform general technical trouble shooting and give consultation to development teams
• Patch Management and Version Control.
• Interface with Oracle Corporation using My Oracle Support for critical incidents.
• Setup and maintain Documentation and standards

Environment: Oracle Database 10g, 11g, PL/SQL, TOAD, RMAN, TKPROF, UNIX Shell Scripting.

Confidential

Application Implementer and Database Administrator

Responsibilities:

• Installation, configuration and up gradation of oracle database software 9i on Red Hat Linux.
• Initial database creation and configuration.
• Database backup configuration using Export/Import and cold back up.
• Database performance tuning.
• Creating ad hoc query and report as per the user request.
• Data fix as per the user request using SQL, PL/SQL.
• Physical data model deployment.
• Client software installation and configuration.
• Network connectivity configuration between client and server using oracle net.
• Extraction, transformation and loading of legacy systems data into DoTSoft systems for parallel run.
• Perform the UAT.
• Production deployment planning.
• Parallel system run with legacy system and compare and validate the data.
• Making the system live.
• Providing production support for application and database after the system is live.
• Provide training to end user for new system(DoTSoft)
• Leading team of 6 members.

Environment: Oracle Database 9i, PL/SQL, TOAD, Oracle Developer 2000(Forms and Reports), UNIX shell scripting