SUMMARY:

• 13+ years’ experience of Oracle Database Administration, Data Migration, PL/SQL ETL support, and Application Implementation.
• Thorough hands on experience on Oracle 12c,11g, 10g, 9i, 8i, 7.3 databases on variety of operating system like Enterprise Linux, AIX, Solaris and Windows Environments.
• Oracle GRID infrastructure (cluster ware/ASM)/RAC (Real Application Cluster) installation, implementation and up gradation.
• Backup and Recovery management using RMAN (Recovery Manager).
• Data Replication and management using Data guard/Golden Gate.
• Distributed database management using Materialized view, DB LINK, Synonyms.
• Expertise in Database Performance Tuning(Instance Tuning/SQL Tuning/TKPROF)
• Create and maintain Logical data model using Enterprise Architect.
• Data refreshes from Production to Non production using data pump(EXPDP/IMPDP)
• Database and system migration from Legacy system to Oracle 10g/11g.
• Expertise in Oracle Data migration using Data pump/DB link/Golden Gate
• Create, Manage and configure ASM Disk Groups.
• Monitor and Manage Database through OEM (Oracle Enterprise Manager).
• Use OEM (Oracle Enterprise Manager) utilities like Memory Advisors, SQL advisors, Segment Advisors, and ADDM
• Expertise in providing production database support for application.
• Expertise in data management using SQL/PLSQL.
• Experience on VI editor and UNIX SHELL scripting
• Maximum availability architecture (MAA) implementation.
• Interface with Confidential using My Oracle Support for critical incidents.
• Worked primarily in Banking, Manufacturing and Telecommunication Domains.
• Expertise in database bug fixing and logical data error correction.
• Handled multiple tasks and adapt to a constantly changing environment.
• Worked in multiple projects concurrently.
• Technological forte is Oracle DBA and also proficient in SQL, PL/SQL, and UNIX shell scripting.

TECHNICAL SKILLS:

Database: Oracle 12c, 11G, 10G, 9i, 8i, 7.3

Languages & Technologies: SQL, PL/SQL.

Tools: / IDEs: SQL Developer, Toad, Oracle Enterprise Manager (OEM)

Scripting Languages: UNIX Shell Script.

Operating Systems: Windows, UNIX, Linux

Job Scheduling: UNIX Cron job, DBMS SCHEDULER

PROFESSIONAL EXPERIENCE:

Confidential, Westchester, PA

Sr. Oracle Database Administrator

Responsibilities:

• Providing 24*7 L2 Database administration support for more than 2000+ 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 Confidential using My Oracle Support for critical incidents.
• Worked on ticket managing tool JIRA.

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

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: Oracle Database 11gR2, PL/SQL, UNIX Shell scripting.

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 Confidential using My Oracle Support for critical incidents.

Environment: Oracle Database 11g, PL/SQL, SQL Developer, UNIX Shell scripting, Oracle Enterprise

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 Confidential using My Oracle Support for critical incidents.

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

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 Confidential 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.

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 Dot Soft 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(Dot Soft)
• Leading team of 6 members.

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