Oracle DatabaseÂ Developer Resume Downingtown, PA - Hire IT People

SUMMARY

Installation of Oracle 10g and 11g Database on Linux, Solaris and Windows.
Automation of DB and Golden gate monitoring by developing scripts using SQL, PL/SQL, shell scripts
Golden Gate setup for Oracle database and setting up zero downtime migrations using Oracle Golden gate
Database Cloning. SQL, SIEBEL Query TuningDatabase and Apps patching.
Recovery and Backup using logical back - ups (export/import), parallel EXP/IMP, data pump, physical back-ups cold back-ups, hot back-ups, RMAN utility.
OEM 12cR3 setup on RAC cluster and Non-RAC server.
Installing and configuring ASM, ASM NFS.
Working on RAC and VERITAS Cluster
Knowledge of Proactive Maintenance of databases that includes working with AWR (Automatic Workload Repository) and ADDM (Automatic Database Diagnostic Monitor).
Creating the Database and configuring for auto growth.
Database security features like Managing Roles, Profiles and privileges.
Data guard setup for physical, logical, multiple, cascade, snapshot standby in oracle 11gR2
Routine maintenance, Performance monitoring and tuning the database that includes SQL Tuning

PROFESSIONAL EXPERIENCE

Confidential, Downingtown, PA

Oracle Database Developer

Environment: Oracle Database 11.2.0.3, Oracle Database 10.2.0.4, Grid 11.2.0.3, Oracle Golden gate 11.2.1.0.3(Bi - Directional setup at schema level), OEM 12.1.0.3, RAC, Solaris 10, RHEL 5

Responsibilities:

Automation Project- Automate DB and Golden gate monitoring by developing scripts using SQL, PL/SQL, shell scripts in such a way that it will generate the reports on daily basis for complete automated health check of Databases and Golden gate . This will alert monitoring reports same way in the absence of OEM grid install.
Golden Gate setup, monitoring and support for 11g Oracle Database.
Backups and Recovery: logical back-ups (export/import), parallel EXP/IMP, data pump, physical back-ups cold back-ups, hot back-ups, RMAN).
Setting up RMAN archival deletion policy where Golden gate is also involved.
Upgrading and Patching Oracle RAC/ Non RAC Databases.
Support for Oracle Golden gate setup across RAC database.
Setting up OEM 12c Grid console on RAC cluster and Non-RAC server.
Database Administration, Tuning and support.
Run time support for 80 databases including RAC / NON RAC /Data Guard /ASM/ Golden Gate.
Solaris and Linux (shell scripting).
Handling LIQUIBASE and MYBATIS tool.

Confidential

Environment: Oracle Database 11.2.0.3, OEM 11.2, RHEL 5

Designing zero downtime deployment architecture through Golden gate.
Analyzing most effective data migration strategies when time is a constraint.
Tuning application queries.
Using SQL tuning advisor for tuning queries.
Creating SQL profiles for tuning.
Creating SQL, PL/SQL scripts, OS level alerts for regular database monitoring and reporting purposes.
Analyzing AWR reports for problems and proactive tuning.
Database Administration, Tuning and support
Working closely with developers and optimizing the PL/SQL performance
Working under high pressure of strict SLA’s in ITIL environment.
Responsible for providing the 24/7 support for production databases along with other team members
Backups and Recovery: logical back-ups (export/import), parallel EXP/IMP, data pump, physical back-ups cold back-ups, hot back-ups, RMAN).
Run time support for 120 databases.
Creating procedures, triggers and functions.
Upgrading Oracle Database and patching.
DB sizing and capacity planning.
Maintaining both OLTP and OLAP databases, the biggest OLTP DB being 1.8 TB.

Confidential

Environment: Oracle Database 11.1.0.7, RHEL 5, OEL 5

Responsibilities:

Installation of Oracle 10g, 11g servers on Solaris, Linux and Windows environment
Creating the database, table spaces, and schemas.
Creating/managing users, profiles, privileges and roles.
Performance tuning of SQL statements.
Regular jobs for EXP/IMP and cold back-ups, hot back-ups.
Database cloning according to user requirements.
Shell scripting for (export of the database, hot back up, cold back up)
Creating SQL, scripts (procedures/triggers), OS level alerts for regular database monitoring and reporting purposes.
Working closely with developers and optimizing the PL/SQL performance.
Run time support for 20 database in a team of 2 DBAs

Confidential

Environment: Oracle Database 11.1.0.7

Responsibilities:

Run time support for R12.
Handling the support activities like patching, manual code migration.
Experience of working with adadmin utility.
Apache bounce, file server bounce.

We provide IT Staff Augmentation Services!

Oracle DatabaseÂ developer Resume

Downingtown, PA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship