Occupation:Database Administrator |
Location:Fairfield, OH |
Education Level:Bachelor |
Will Relocate:YES |
Description
Professional Summary * Over 5+ years of experience as an Oracle Database Administrator having hands and experience in database installation, administration, configuration, production support, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation. * Experience in translating business requirements into conceptual, logical, and physical data models. * Experience in configuring Oracle network, RMAN, Recovery Catalog, and Performance Tuning of database by optimizing SQL and PL/SQL scripts and instance. Used statspack report, AWR report, ADDM advisors, autotrace and execution plan. * Excellent experience in installation, setup and configuration of Oracle 10g and 11g in HP-UX, Sun Solaris, Windows and UNIX/Linux environment. * Proficient at performing major Database Release Upgrade (manually as well as using DBUA) along with applying various PSU patches using OPatch for 10g 11g 12c databases. * Adept at routine Database Administration tasks including automated installation, creation and replication of databases, management of tablespaces, logs, grants, roles, users, indices. * Working experience in database cloning, database backup, recovery procedures and security. * Experience in application Support, SQL Loader, Data pump, Data Guard, Fine Grain Auditing (FGA), performing Flashback, transportable tablespaces. * Experience in designing and configuring high-availability systems using DATAGUARD with physical standby. Effectively used DATAGUARD BROKER utility. * Hands on experience in installation and maintenance of enterprise manager 12c and Grid Control 11g and addition of targets for database Monitoring/Performance/Diagnostics purposes. * Implemented and maintained 12c multitenant architecture using container and pluggable databases and performed conversion of non-container databases to pluggable databases. * Experience in Performance Tuning, Tuned various large critical OLTP and OLAP databases using various tools like AWR, STATSPACK, ASH, SQL-TRACE, TKPROF, ADDM, and Explain Plan Utilities. * Experience in the management and implementation of database models, data flow diagrams, database schemas, database scripts, to support a robust data management infrastructure. * Qualified at writing SHELL Scripts and using CRONTAB for automatic backups. * Adept at installation of OEM Database Control, OEM grid control and Deploying Agents. * In-depth knowledge and understanding of Oracle Database features such as RMAN for backup and recovery, Materialized Views, Export/Import, Data Pump and Data Guard. Working knowledge of Auditing and Database Security. * Experienced in Designing, Installing, Configuring and Maintaining Real Application Cluster (RAC) using raw devices, OCFS, Automatic Storage Management (ASM) and SRVCTL utility.
Accomplishments
Highlights:
Job Skills
Keywords
