Oracle DBA
Resume:
Casimir Bagneki
Oracle Database Administrator
***********@*****.***
Phone: 240-***-****
Professional Experience
Zoetis Inc -Florham Park, NJ Jun 2014 – Present
Oracle Database Administrator
Worked as a team member for 24x7 support with on call rotation in all prod, QA and dev environments.
Successfully upgraded Oracle 10g (10.2.0.4) to Oracle 11g (11.1.0.6) and Oracle 11g (11.1.0.6) to Oracle 11g (11.2.0.3) on Red hat Linux 6, IBM-AIX.
I have also successfully upgraded from 11g (11.2.0.3) to 12c (12.1.0.1) using DBUA.
Writing and modifying UNIX Shell Scripts to manage Oracle environments for Backend Processes.
Developed SQL*PLUS & PL/SQL scripts for extraction, Transporting & Transforming (ETL) data from Production databases to Data Warehouse Databases.
SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export and Data pump utilities).
Proficient in Oracle High Availability features like RAC, DATA GUARD, GRID CONTROL and Oracle Performance Tuning Utilities like ADDM, AWR, ASH, SQL-Tuning Advisor, EXPLAIN PLAN, TK PROF, DBV.
Performed Data file recovery from logical and physical block corruptions
Good understanding and Implementation expertise in RAC, ASM, Data Guard like remedy change and user tickets, frequently communicate effectively with technical and non-technical customers.
Exp on Cluster management, event management, application management, connection management, storage management, load balancing and availability. Continuous monitoring of performance during peak and non-peak loads using AWR reports, ASH, ADDM and Optimization SQL code using SQL Trace, tkprof, Explain plan.
Experience working with SQL, PL/SQL coding, stored procedures, functions, packages, triggers.
Partitioning strategies for very large tables. Implemented Range, List, Hash and various Sub Partitions, Create and schedule refresh for materialized views.
Work with Oracle Data Pump (expdp and impdp) which provides high speed, parallel, bulk data and metadata movement of Oracle database contents.
Management of schema objects, partitioning of tables & indexes and performing SQL*Loader jobs for loading data from flat files (ETL) and Oracle Database monitoring, troubleshoot and resolve the issues.
Monitoring growth of tables and undertaking necessary re-organization of database, capacity planning.
Designed the logical and physical database structure and involved in Logical, Physical data modeling.
SQL tuning - AWR history of sql execution, index recommendations, SQL Tuning Advisor, SQL Access Advisor, Real Time SQL Monitoring, Interpret Execution plans, Re-write more efficient SQLs.
Data Refresh of large production data warehouse environment to setup test, development environments using SAN level storage mirroring: Gold image copy and cloning.
Performance tuning of Queries by maintaining Aggregates, Compression, partition, Indexing
Performance tuning and diagnosing DBMS and individual Production databases, organized various migration review meetings with the application team to discuss the migration strategy based on their requirements.
Performed policies on data confidentiality, integrity, availability, and auditability, based on Access controls for Access to Data at the database level.
Performed SQL and PL/SQL tuning oracle contention and monitored production database using Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Active Session History (ASH).
Provide support to developers to enhance their SQL, PL/SQL code and responsible for setting up of new user accounts, schema Deployments and related user administrative tasks.
Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases.
Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
Environment: Oracle 11g/11g RAC/9i, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.
SunTrust Bank - Richmond, VA March 2011 - May 2014 Oracle Database Administrator
Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.
Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.
Loading data from flat files to database using SQL*Loader, External Tables.
Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
Applied Bug fixes patches, Quarterly Security Patches for RAC and non-RAC servers for issues when upgrading, DR switchover testing.
Reconfigured the OCR, public and private interconnects, modifying the VIPs and the subnet masks for 2, 3, 4 Node RAC Clusters and Upgraded single instance 9i/10g databases to 11gR2 RAC.
Setup, reconfigured and monitored 2, 3 Node RAC Primary to 2, 3 Node RAC Dataguard for DR.
Tested the Dataguard (DR) SWITCHOVER of RAC to RAC Dataguard as part of the migration.
Created new databases/instances on 12c/11g RAC and single instances using customized scripts, DBCA.
Handled all daily DBA activities and excellent experience with SQL scripting, PL/SQL coding, stored procedures, functions, packages, triggers to enforce the referential integrity constraints
Performance monitoring and Database/Instance/clustered Application tuning using Dictionary views, AWR (Statspack), ADDM, ASM reports, OEM Grid Control, tuned SGA/PGA parameters, initialization parameters and reorganized physical objects (tables & indexes) and tablespaces to improve the performance.
Redesigned table and index partitioning strategies, using HINTS to improve the query performance.
Developed, modified and optimized very complex queries to data retrieval using Explain Plan, SQL Trace, TKPROF, parallel processing and partitioning techniques.
Monitoring the CPU, memory usage, I/O contention on servers using top, iostat, sar, glance, vmstat etc.
Designed daily, weekly Backup and Recovery procedures for production, non- production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups.
Migrated VLDB multi terabyte databases around 10TB and redesigned the RMAN backup Strategy.
Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate.
Intensively used latest 10g/11g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.
Scheduled UNIX scripts in crontab jobs to automate daily tasks like backups, monitoring the alert logs, backup logs, cleaning the old archive logs, old log files, tablespace monitoring to send notification emails.
Migrated data to a new ASM Diskgroup to improve the IO performance of the database.
Export/Import, Datapump, Transportable tablepsaces to migrate database objects from one database to another.
Data aggregation and replication setup using Oracle Streams and Materialized views for reporting.
Oracle Database monitoring, troubleshoot, resolve the issues, monitoring alert log, trace files.
Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.
Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, Suse Linux, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.
Skills Summary
I have over 6 years of hands-on experience as an Oracle Database Administrator. I possess complete life cycle knowledge including Installation. Worked with several Oracle applications including PeopleSoft, Oracle E-business Suite R12 to support Oracle 12cR1, 11gR2, 10g versions involving database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, cloning, space management and security.
Implemented LINUX HUGE PAGES on OEL 5.5 and Redhat Linux 6.x for Clustered Environments.
Applying Patches, Critical Patch Update/Patch Set update and One-off Patches using OPatch.
Experience in patching RAC databases in rolling fashion to maintain high availability.
Experience in tuning database and memory components for optimal performance using AWR, ADDM and ASH reports.
Designed and implemented Oracle Real Application Clusters (RAC) on Linux.
Experienced in installation and configuration of Oracle cluster ware and Automatic Storage Management (ASM) in RAC environment.
Experience in conversion of Single Node Instance to multimode RAC with ASM, and adding instance to existing RAC.
Experience in Migration of Oracle Databases from non-RAC to RAC and non-ASM to ASM Instances.
Experience in Real Application Clusters (RAC) setup with 4 nodes, configuration and cluster interconnection with Automatic Storage Management (ASM).
Configured and maintained physical standby databases using Oracle Data Guard to perform quick disaster recovery.
Experience in maintaining Data Guard to provide high availability by implementing physical standby database and snapshot standby and worked with Oracle 11g features, 11g Grid Control
Troubleshoot Database performance issues with use of PROCWATCHER, LTOM, ORACHK, Cluster health monitor and Other Oracle support suggested utilities and also used OS related utilities like NMON,SAR, OSWATCHER, pstack,pmap,top, topas,vmstat, iostat, prstat, strace etc
Implemented various Partition techniques to achieve availability, performance and manageability of large tables and indexes
Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
Extensive experience designing and implementing backup and recovery strategy for databases using Recovery Manager (RMAN), traditional Export/ Import, Export/Import Datapump as well as conventional Hot/Cold Backups.
Implemented various backup strategies for Large / Medium sized databases using RMAN
Worked extensively on Cloning /Duplicate of databases using RMAN.
Experience with various database Backup and Recovery methods like PITR, TSPITR, Export/Import and Flashback Technologies.
Migrated databases from Non-ASM file system to ASM file system using RMAN.
Upgrading and Migration of Oracle database to higher version and other platforms using manual method and traditional Export/Import, datapump & Transportable Tablespace (TTS).
Expertise in Configuring RMAN with Catalog /Nocatalog and worked on Point-In-Time Recovery and flashback.
Plugging the tablespace between different platforms using Cross platform transportable tablespace Utility.
Collecting performance statistics using Statspack/AWR (Automatic Workload Repository) and ADDM (Automatic Database Diagnostic Monitor).
Used TKPROF utility and Explain Plan for tuning SQL queries.
Experience in regular DBA activities such as Upgrades, Patches, TAR support, Cloning, Backups and Recovery Manager, Performance Tuning, Capacity Planning and documentation
Memory tuning by using ASMM (Automatic shared Memory Management). Sort area size, Buffer cache, Shared pool size, Different pools like Recycle pool, Keep pool.
Rebuilding of Indexes for better performance, User Management, Tablespace management, maintenance of Oracle Database.
Installing Oracle patches, Migration of database across releases.
Experience in Monitoring and Tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
Expertise in loading data from flat files using external tables, SQL* Loader.
Experience with SQL, PL/SQL, UNIX Scripting.
Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
Excellent analytical, problem solving, communication and interpersonal skills
Technical Proficiencies
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 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
Education
Catholic University of America, Washington, DC
Masters of Science Degree in Life Sciences
Contact this candidate