Sr. Oracle Database Administrator Resume Northbrook, IL - Hire IT People

SUMMARY:

An accomplished Oracle DBA with over 20 years of extensive database design, coding, testing and production support experience for Mission Critical and high Availability Systems. Highly skilled in database tuning and proven ability to design and implement highly performing database systems.

EXPERIENCE:

Confidential, Northbrook, IL

Sr. Oracle Database Administrator

Responsibilities:

Design physical database structures ( Tables, Indexes, Materialized views etc.) using logical models provided by development team.
Oracle Certified Professional, Oracle 8i, Oracle 9i, Oracle 10g and extensive experience in Oracle 11g, Oracle 12c
Data Warehouse design, Partitioning (Range, Hash & Interval), Index management, SQL query management
Perform numerous application and database tuning assignments on a day to day basis using AWR / ASH reports, Dynamic performance views, Explain Plans, Oracle Enterprise Manager (OEM), SQL Plan management (SPM), SQL Trace, TKPROF, SQL Profiles, and Database Stats
Designed an highly available and redundant Centralized Codes Management System that interfaces various applications throughout the company.
Served as technical DBA lead for database server consolidation project in order to consolidate several small databases into a single large database environment thereby significantly reducing maintenance costs
Extensive experience with Active Data Guard and Oracle Streams. I have also supported applications running Golden Gate.
Experience in automating the daily maintenance activities by generating Shell scripts & sql script.
Strong solutions experience including technical project management, data architecture, data modeling, database administration and global team management.
Enforced auditing management system to meet government compliance standards
Performed data replication using Materialized Views (snapshots) and Oracle Streams
Recover data/objects using active dataguard and flashback techniques
Use of datapump for database environment creation for development work and testng
Maintain database security utilizing database auditing, user management and role management
Conducted various training exercises with onshore and offshore resources

Sr. Oracle Database Administrator Consultant

Confidential, Chicago

Responsibilities:

I maintained large size production databases for business critical applications used by over 3000 Independent Agents.
Also maintained multiple development and Test databases to support inhouse development work across various teams.
My daily tasks included System and database performance tuning, Database Maintenance, Backup and Recovery, Capacity planning, etc. to support data growth needs. Proactively monitored performance issues, identifying bottlenecks / root cause and provided recommendations.
Developed and implemented the policies, technical procedures & standards for preserving the integrity and security of Oracle Applications data, reports, and access
Performed Database design and object creation, space management, Index Maintenance, database security and Role management, SQL Performance Tuning
Utilized tools such as TKPROF, EXPLAIN PLAN and DBMS STATS, and Unix tools - iostat, vmstat, TOP, SAR
Performed constant research to provide necessary upgrades and patching.
Used monitoring tools such as Precise/SQL, SQL Developer, Quest Toad, Oracle Enterprise Manager, BMC Patrol for database and application performance tuning.

Confidential

Land Customs Engineer

Responsibilities:

Table size Estimation
Database User Management, Role Management
Database Tuning and Query Optimization
Database Procedures and Triggers
Database Backup and Recovery
Configuring for Distributed Database
24x7 production support DBA working on a primary/ secondary pager rotation

Confidential

Systems Engineer

Responsibilities:

System Analysis and Design
Development of District Planning Software
Classification of Information in groups
Testing & Implementation throughout country.
User’s Training
Reports generation for District level Planning
Shell scripts used for User Creation and Backup

We provide IT Staff Augmentation Services!

Sr. Oracle Database Administrator Resume

Northbrook, IL

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship