SUMMARY:

Hold over 5 years of IT related experience with 5+ years of extensive knowledge and proficiency in oracle 10g and 11g database design, administration and systems analysis within financial, healthcare, logistics and insurance institutions. 5+ years experience with Performance tuning of oracle databases with various inhouse and vendor applications. Demonstrated proficiency in the installation, configuration, upgrade and administration of Oracle 11gR2 database with RAC and ASM.

• Oracle Installation, Configuration & Administration
• Database Upgrade and Migration.
• OMS Grid Installation & Administration
• Oracle Exadata administration and Oracle Cloud
• Application Support
• Backup and recovery using data pump and RMAN.
• Incident, Problem & Change Management
• Oracle, Sql Server Database Administration
• Monitoring and Performance tuning using OEM/Grid Control/Manually.
• Database integrity and Advanced security implementations.
• Exposure to Oracle tools such as Toad/SQL Developer
• Oracle Partitioning
• Oracle High Availability involving Oracle RAC, and Dataguard exposure.
• Remarkable attention - to-detail skills with the unique ability to coordinate multifaceted activities determine and analyze problems and implement corrective actions.
• Enthusiastic and an excellent communicator with a recognized ability to establish and maintain effective working relationships across cross-functional teams and diverse individuals at all levels.
• Exceptional ability to simultaneously manage technical and business requirements as well as supervising documentation and reporting.

TECHNICAL SKILLS:

Database Technologies: Microsoft SQL Server 2000, MySQL, Oracle 10g, 11g R2

Operating Systems: Red Hat Linux, Sun Solaris, HP - AIX

Tools: OpsWare, Toad, Data Pump, SQL loader, AWR, ASH, TKPROF, Explain Plan, Opatch

Utilities: RMAN, ADRCI, SQL*Plus, RDA-HCVE

High Availability Solutions: RAC, Data Guard, and ASM

Networking: SQL*NET

PROFESSIONAL EXPERIENCE:

Confidential, Roseville, MN

Oracle DBA

Responsibilities:

• Interact with internal and external clients to understand data flow and client processes.
• Design and develop logical and physical database structures, standards, and procedures with team
• Monitor the databases to identify and correct performance problems
• Modify database programs to optimize performance
• Create, maintain, and allocate database storage and storage structures
• Evaluate the system database needs, install and configure Oracle RDBMS
• Oracle cloud configuration and set ie database cloud backup and DBaaS
• Code database descriptions and specify identifiers of database to database management system or direct others in coding database descriptions
• Perform data modeling, logical and physical database design.
• Support the activities of the company and assist Professional Services employees with customer data issues.
• Confer with co-workers to determine impact of database changes on other systems and staff cost for making changes to database
• Analyze and capture data requirements from a variety of data sources.
• Develop backup and recovery procedures with team
• Work cooperatively with all levels of users in Development, Database, Systems, and Operations
• Build Oracle RAC VM using OEDA on Exadata, Migrations

Confidential, Omaha, NE

Oracle production support DBA

Responsibilities:

• Upgraded databases from 10g and other 11g versions to 11.2.0.4 and 11.2.0.5 by doing either in place upgrades for dedicated databases or migrations for shared databases
• Installed and configured Oracle 11g software on AIX / UNIX / LINUX operating systems.
• Created profiles, ORAENV and initialization paramters for new database build in silent mode.
• Applied Oracle quarterly patches of the current PSU version to non-RAC and RAC configured databases.
• Performed data and metadata transfer from legacy servers to newly installed servers using Data Pump.
• Implemented Oracle Database advanced security practices such as Virtual Database Privacy
• 24x7 remote support and on call Database support using RSA-VPN.
• Conferred with staff, users, and management to establish requirements for new systems or modifications.
• Ensured that standby database is always in sync with production database by checking archivelogs sequences.
• Performed SQL tuning based on reports generated by SQL Trace, ASH, AWR, Explain Plan.
• Monitor and conducted database health checks on daily basis using SQL developer.
• Performed Dataguard swithover as required for maintenance. This includes coordinating with application owners and sys admins to when the switchover can be performed.
• Planned and performed daily Backup/Recovery using RMAN.
• Clonned production databases as needed for testing, development using RMAN and Grid Control.
• Created tablespaces and planning the location of data, index and rollback tablespaces redo log files and control files in adherence to the Optimal Flexible Architecture.
• Managed database security by creating and assigning appropriate roles and privileges to users depending on the user activity.
• Utilized ADDM and AWR to reduce DB time by diagnosing key problems such as Expensive SQL statements, I/O performance issues, Locking and concurrency issues, Excessive parsing, Resource bottlenecks (including memory and CPU bottlenecks) and recommending a solution.
• Documented work progress and updated work road map on project status for administrative and managerial assessment.

Confidential, Brooklyn Park, MN

Oracle database Administrator

Responsibilities:

• Installation and configuration of Oracle 10g/11g servers and creation of databases in UNIX, Linux and windows environments.
• Planned and scheduled Backup/Recovery Strategy, took Logical Backups (with Export/Import Data pump utilities)
• Created primary objects (tables, views, indexes, synonyms, procedures, functions and triggers) to help application developers with the application design.
• Created & Managed Constraints, Database Access, Roles and Privileges.
• Performed database security and user administration via roles, profile, privilege, synonyms and auditing.
• Planned backup and recovery of database information. Maintained redo logs and archive them to tape.
• Monitored and troubleshooted bugs from alert log, audit logs and trace files using Toad
• Performed day to day activities: Such as, daily error checks and database health monitoring of physical resources (disk space, memory, CPU, etc.). Performance parameters adjusted as needed.
• Produced backup report to ensure the backups were all successful and troubleshoot if the backup was not successful to find out the root cause of failed backups.
• Performed data transfer using Export/Import and Datapump.
• Monitored database for performance and optimization using Toad.
• Tuned database and application performance using Stats pack, AWR, ADDM, Explain Plan and oracle Enterprise Manager (grid control).
• Maintained record of daily data communication transactions, problems and remedial action taken, and installation activities.