Junior Oracle Database Administrator Resume
Wayne, PA
PROFILE SUMMARY:
- I have Over 3 years of Experience in Oracle Database Administration in Various environments including UNIX/LINUX, Solaris and Windows Environments supporting applications with Oracle 10g, 11g & 12c Databases.
- I have proven technical knowledge of Database Administration and infrastructure management combined with outstanding Database Security, Encryption using TDE, Performance Tuning abilities and Creative problem solving skills in both strategic and tactical areas as well as excellent Communication skills. I have strong aptitude to analyze and resolve problems.
- To say the least, I’m Proactive, and a fast learner, willing to learn. I’m a Great team player, Dynamic and also Reliable. I’m good with Documentation; Multitasking and I pay Attention to Details.
PROFESSIONAL SUMMARY:
- Experience in On - Call 24x7 production Support, Application/Development and Production.
- Good in Database Performance Tuning using Utlstat, scripts, Statspack and dynamic performance views to monitor system statistics and wait events, AWR, ADDM and Tuning of SGA.
- Experienced in Tools like, Toad, SQL Developer,Oracle Enterprise Manager Grid Control, Putty, NX client, Winscp, Remote Desktop Connection, VNC, Team Viewer, LogMeIn and Cisco VPN Client.
- Experience in Database Backup and Recovery concepts using RMAN and other options such as User-Managed Backup, RMAN-Managed backup with or without catalog, operating system backup, cold and hot Backup, Full Backup, Incremental and Cumulative Backup. Implementing backup and recovery strategies.
- Monitored physical I/O and Proper sizing of rollback segments.
- Optimized SQL using explain plan, Auto trace feature and TKPROF to analyze the execution plan and tune the statements.
- Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and Perl based utility “opatch as well as database upgrades
- Maintaining and scheduling Cold Backups, Hot Backups, and Export Dumps. Maintaining backups of Archive logs and automating cleaning of archive logs. Deploying RMAN to automate backup and maintaining scripts in recovery catalog.
- Data transferring with export/import utilities and Data Pump and SQL* Loader and Golden Gate
- Performing complete and incomplete recovery during disasters, failures and user errors.
- Configuring user creation, their roles and privileges profiles to control access over database objects.
- Deployed Standby databases using Data Guard 11G (Maximum Performance).
- Proven technical knowledge of infrastructure management (network, systems), combined with outstanding leadership ability and creative problem solving skills in both strategic and tactical areas as well as excellent communication /documentation skills and strong aptitude to analyze and resolve problems.
TECHNICAL SUMMARY:
Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x. Unix, Linux Enterprise Server 9, 10. Windows 95/98/NT/2000.
RDBMS: Oracle 9i, 10g, 11g
Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL.
Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.Toad, Putty, NX client, Winscp, Remote Desktop Connection, VNC, Team Viewer, LogMeIn and Cisco VPN Client
Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import
Applications: PeopleSoft 9.1, FN, HR CRM, Portal, Parking and other Custom Applications.
PROFESSIONAL EXPERIENCE:
Confidential, Wayne, PA
Junior Oracle Database Administrator
Environment: Oracle 12c/11g/10g/9i, Unix, Linux, Solaris, SQL Developer, PL/SQL, Shell scripting (Bourne), OEM, Statspack, RMAN, AWR, ADDM, Datapump.
Responsibilities:
- Installation of oracle 11g and 12c databases in development and test environments depending on project requirements.
- Refreshing development/test database from production using Datapump Export/Import & RMAN backups.
- Maintaining and scheduling Cold Backups, Hot Backup on Crontab, and Export Dumps, maintaining backups of Archive logs and automating cleaning of archive logs. Deploying RMAN to automate backup and maintaining scripts in recovery catalog.
- Planned Database backups (operating system, full/partial backups, and export/import) using various types of Backups and designed the Backup methodology for the organization.
- Making structural changes to the databases. Sizing database objects for effective space management and optimal performance.
- Managing database security, Creating and assigning appropriate roles and privileges to users depending on the user activity
- Data transferring with export/import utilities, Data Pump and SQL* Loader and Golden Gate
- Performing Complete and Incomplete Recovery during disasters, failures and user errors.
- Performance tuning, monitoring tablespaces, monitoring users, etc. as well as much problem solving.
- Designed Logical and physical database for business transaction functionality.
- Provide production support for the deployed project till it is stabilized.
- Written SQL scripts to create database objects like tables, views and sequences.
- Defragmentation of tables and indexes for improved performance and effective space management.
- Managed Database MaintenanceActivities to achieve optimum database uptime.
- Configuration of Listener and Tnsnames.
- Doing the regular activities like monitoring the alert logs, redo log status, listener. Log and checking the space for normal segments, rollback segments and tablespaces.
- Created database link between two databases to access the table data from one local database to remote database using distributed database feature.
- Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
- Capacity planning of tables, indexes, table spaces and databases to allow for growth potential.
Confidential, Handover, MD
Entry Level Oracle Database Administrator
Environment: Oracle 11.2.0.3, 10.2.0.5, RHEL 5.5, 6, Sun Solaris 10.0, DataGaurd, RAC, RMAN, OEM, Datapump, AWR, ADDM, ASH, TOAD 11.0.
Responsibilities:
- Refreshing development/test database from production using Export/Import & RMAN backups.
- Managing database security.
- Performed other Oracle DBA responsibilities performance tuning, monitoring tablespaces, monitoring users, etc. as well as much problem solving.
- Provide production support for the deployed project till it is stabilized.
- Written SQL scripts to create database objects like tables, views and sequences.
- Created procedures and functions using PL/SQL.
- Installation of oracle 10g and 11g databases in production, development and test environments depending on project requirements.
- Collaborated with the UNIX system Administrator to configure software and hardware requirements that will function with the Oracle Database.
- Creating and assigning appropriate roles and privileges to users depending on the user activity.
- Defragmentation of tables and indexes for improved performance and effective space management.
- Configuration of Listener and Tnsnames.
- Doing the regular activities like monitoring the alert logs, redo log status, listener. Log and checking the space for normal segments, rollback segments and tablespaces.
- Created database link between two databases to access the table data from one local database to remote database using distributed database feature.
- Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization.
- Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.