SUMMARY:

• Oracle Certified Associate database administration with over 5 years of hands - on experience working on DBA/Architecture, Production 24*7 support, Implementation, Configuration, Upgrades, Replication, Performance Tuning/ Optimization/ AWR, ADDM, User/Security Administration, Backup/Recovery, Data/Network Administration and Maintenance, Database Migration,

TECHNICAL SKILLS:

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. Linux Enterprise Server 9, 10. Windows 95/98/NT/2000

RDBMS: Oracle 10g, 11g, 12c

Languages: SQL, PL/SQL, UNIX Shell Scripting.

Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM. Toad, Putty, NX client, WinSCP

Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, Data Pump, Export, Import

Others: Remedy, Connect Wise

PROFESSIONAL EXPERIENCE:

Confidential, Brookfield. WI

Oracle Database Administrator

Responsibilities:

• Configured Oracle Data Guard to ensure disaster recovery and RAC for high availability and data protection
• Excellent experience in Performance tuning of oracle databases using different tools like AWR, ADDM, SQL TUNNING ADVISOR and tuning of SQL scripts using SQL Trace and Explain Plan
• Proficient in Database Administration activities such as installation, configuration, database creation, sizing, backup and recovery, performance tuning and capacity planning.
• Managed data files, control files, redo log files, tables, indexes, constraints for performance and availability.
• Good exposure of Oracle DBA tasks Installation, Patching, Cloning, and Upgrade of Oracle Databases.
• Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
• Strong Knowledge and experience in database security. Creating Users, creating and managing tables, views, and indexes, Database Links, roles, profiles, privileges, Audit Triggers and assigning roles to users.
• Install and configure Cloud Control 12c, deploy 12c agents, plug-in installations on the target servers and monitor databases.
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases

Oracle Database Administrator

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11g R2 on Linux and Upgraded from Oracle 10g to 11g, 11g and 11gr2 to 12c.
• Migration of database from one server to another server and migration of non ASM database to ASM database.
• Managing, Monitoring and optimizing the performance of the databases on a periodic basis using AWR, ADDM reports and providing recommendations.
• Installation and consolidation of 12c multitenant database's in QA and Test environments. Container and Pluggable database administration and cloning.
• Installation, setup and configuration of Operational Data Store for use with Oracle Golden Gate. Resolving issues related to Network Congestion, Memory (SGA and PGA) CPU & IO and other oracle related issues.
• Applying Quarterly Security Patches (CPU/PSU) and applying Patch set and One-off Patches.
• Implemented Data Guard on Oracle 11g with high availability and performance configurations and participated in Data Guard Fail over tests.
• Monitoring several databases of varying Terra byte sizes using Oracle Enterprise Manager Grid Control.
• Performed daily database administration tasks: User management, Space monitoring, Performance monitoring and tuning, Alert Log monitoring and backup monitoring.
• Expertise in UNIX Shell Scripting and automated many common tasks using CRONTAB including: Backups, exports and imports, archiving old records and verification of such processes.

Jr. Oracle Database Administrator

Responsibilities:

• User creation with proper roles and privileges.
• Responsible for integrity and concurrency of data.
• Create a PL/SQL function, stored procedure, package to support reports.
• Refreshing and manipulating data in tables using PL/ SQL procedures.
• Written stored procedures, functions and triggers.
• Testing, Debugging and Documentation.
• Estimating table sizes, table spaces.
• Created database objects like tables, tablespaces, buffer pools, indexes
• Performance monitoring and tuning.
• Analyzing tables and indexes for performance tuning.
• Creation, maintenance, backups and restoration of databases.
• Creation of logins and user ids and setting up privileges and procedures
• Monitored and tuned rollback segment, temporary table space, redo log buffer, sort area size

Jr. Oracle Database Administrator

Responsibilities:

• Monitor performance of database systems resources and query throughput
• Optimize SQL Code as necessary
• Monitor and maintain database storage resources
• Monitor and maintain database maintenance plans for backups, index rebuild/defragment, and database statistics
• Oracle RDBMS Installation, Upgrades, Migrations and Configuration
• Install database software service packs and cumulative updates as necessary
• Maintain database documentation as required
• Maintain and administer database security access
• Perform database Ad-hoc backups and restores
• Trouble shoot and resolve database connectivity issues