Oracle DBA
Resume:
Ndikum Tanda Sherman
Oracle Database Administrator
ac1ctk@r.postjobfree.com 240-***-****
Professional Summary:
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, ASM with Oracle 10g, 11g and 12c.
•Experience in Upgrading databases and applied patch sets to multiple databases.
•Expertise in Database Space Management, Expertise in troubleshooting and performance tuning.
•Expertise in attaining Performance tuning for Oracle database using utilities like STATSPACK, TKPROF, Explain Plan, SQL TRACE, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
•Fabricated multiple CLONING databases using traditional method (scripts) and RMAN utility.
•Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
•Created 12c multitenant container database using DBCA
•Configured non-pluggable 12c database into pluggable container database.
•Applied various patch sets released through critical patch updates. 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 using Oracle's Transportable Tablespace (TTS) to migrate Tablespace across Oracle databases.
•Monitor and maintain system security and Auditing. Experienced in executing SOX related auditing controls.
•Having hands on experience in Hot/Cold Backup, Recovery of databases using RMAN with VERITAS Net Backup.
•Hands on experience in Performance Tuning and Memory (SGA) Tuning by identifying top Sqls/Sessions and Tuning.
•Gathered database/Objects statistics using DBMS_UTILITY, DBMS_STATS packages and ANALYZE command.
•Scheduling and Troubleshooting Database performance issues using Statspack, Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
•Efficient in SQL query Optimization using Explain plan, Auto trace, TKPROF, Gathering statistics, pinning objects.
•Experienced in loading data from flat files using SQL Loader and External Tables.
•Knowledge on Oracle Support processes for technical requests through Meta link.
•Monitoring & Reorganizing Tablespaces/Tables/Indexes.
•Skilled in using tools such as SQL Developer and TOAD.
•Experienced in converting Business Requirements to Technical Specifications.
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.1RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10.Windows 95/98/NT/2000.
RDBMS
Oracle 9i/10g&11g
Tools & Utilities
RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, TOAD, Oracle SQL Developer
Tuning Tools
TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.
Languages
SQL, PL/SQL, C, C++, UNIX Shell Scripting, PERL.
Others
Remedy, ConnectWise.
Professional Experience:
Dell Corporation - Atlanta, GA Aug’2013 – Present
Oracle Database Administrator
•
Responsibilities:
•Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.
•Extensively used AWR, ADDM and explain plan for periodic performance tuning.
•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).
•Upgrade databases from Oracle 10g to 11g, Oracle 11g to 12c.
•Security patches for PCI compliances and also one-off patches for bug fixes
•Implemented DATA GUARD (Standby) for disaster recovery (DR) purpose and also fail-over and switch-over processes. Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.
•Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
•Refreshed/cloned databases using RMAN utility.
•Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
•Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
•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).
•Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.
•Used Secure SCP & FTP extensively for the File transfers from machines to remote server.
•Cloning & duplicating databases using scripts as well as RMAN for test and developments instances.
•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.
•Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
•Achieved optimized performance for the databases by rebuilding indexes, implementing portioning methodologies (Range partitioning, List partitioning, Hash partitioning, Composite partitioning) on tables and indexes.
•Loading data from flat files to database using SQL*Loader, External Tables.
•Used TOAD for database management.
•Made optimal use of Oracle Support in resolving the SRs.
•Monitor CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck.
•Performing SQL*Loader jobs for loading data from text files.
•Installation, Configuration and Administration of GoldenGate
•Replication using GoldenGate
•Writing SQL scripts to monitor Archive log gaps in DR, monitor table space and extent growth.
•Working with Materialized views with Query Rewrite, Bitmapped Indexes, etc
•Involved in the migration of cluster databases and single instance databases.
•Automation of Startup, Shutdown, Backup, Cloning of the databases.
•Handling day-to-day activities.
Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, RHEL 5.2, RAC, ASM, Datagaurd, Oracle Streams, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.
Wells Fargo Bank MD
May'2011-July’2013
Oracle Database Administrator
Responsibilities:
•Established, designed, tested and implemented backup and recovery solutions including automated daily hot/cold backups depending on criticality of the Database - (RMAN, EXP/IMP PUMP and shell scripts) and database migration.
•• Troubleshooting the database performance using Oracle Enterprise Manager, generating the monthly reports on the database to see how much load has been applied on database constantly.
•Participated in doing schema refresh like taking export of one schema and importing it into another schema using different ways of utility tools like REMAP_SCHEMA, REMAP_TABLESPACE
•Space management of logical structures (i.e. table spaces, rollback segments) and auditing of users
•Optimization of SQL queries, PL/SQL, Stored Procedures, Functions, Database Triggers and Shell scripting and worked with the users to meet business requirements.
•Implemented both unidirectional replication as well as bi-directional replicate using Golden Gate
•Working with High transaction databases (OLAP) using Golden Gate to replicate the data to source
•Installing and configuration of Golden Gate Validate on production, development and testing
•Analyzing SOX application for validating business inventory for critical ones and risk assessment
•Responsible for automation of startup, shutdown of database without the involvement of DBA to start the database manually Actively worked on performance tuning of instance (SGA and PGA) and Physical database that included resolving fragmentation and disk contention. Use Partitioning and indexing feature of Oracle 10g to improve performance.
•Disaster recovery planning; implemented database backups and disaster recovery strategies using RMAN and data pump export, import.
•Supported very large database with heavy OLTP and batch activities Writing and testing PL/SQL procedures (stored procedure, triggers, function, cursors and packages) for maintaining tables, retrieving data from tables and managing users. Responsibilities included working with developers to tune the PL/SQL, SQL.
•Designed and Implemented database security using Oracle roles and privileges.
•Experienced in optimizing SQL and PL/SQL tuning using CBO, explain plan, TKPROF, Statspack, ADDM, AWR.
•Involved In query optimization and using rule based optimizers and cost based optimizers
•Created and Managed user, table spaces, data files and archive log
•Performance Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the Stats pack report generated from snapshots taken at the peak business hours.
•Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance.
•Communicate and coordinate with Oracle using My Oracle for major database issues/ problems
•Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs.
•Worked on oracle Public and Private Database Link.
•Applied client patches and other patches as required.
•Perform User Management, creation, monitoring and management of database users, altering passwords of users and granting and revoking system/object privileges, roles, auditing user actions in the database.
Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, ASM, Datagaurd, Oracle Streams, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM,
Sprint, Overland Park, KS
Jan'2010-April’2011
Oracle Database Administrator
Responsibilities:
•Install oracle database software 9.2.0.1, 10.2.0.1 and 11.1.0.6.0 using oracle universal installer on development, test and production server for their claim, policy and online applications in IBM AIX 5.3 environment.
•Install OEM grid control that includes oracle agent, management repository and management service on VMware Red Hat Linux virtual machine. Install agents on various AIX database servers.
•Upgrade software and databases from 9.2.0.1 to 9.2.0.6, 10.2.0.1 to 10.2.0.3, 9.2.0.6 to 10.2.0.3 and 10.2.0.3 to 11.1.0.6.0 on development; test and production databases on AIX database servers. Apply patch set to upgrade software and use database upgrade assistant, export/ import and manual scripts to upgrade databases.
•Migration of full 9.2.0.6 databases, schemas those are on Linux environment into AIX, 10.2.0.3 database environment using export/import and data pump utility.
•Create development, test and production databases using database configuration assistant- DBCA, manual scripts and sqlplus using Automatic storage management- ASM.
•Database performance tuning using AWR, ADDM, ASH, sql tuning advisor, explain plan, statistics, blocking sessions, STATSPACK, TKPROF, sql query restructure and sql trace.
•Schedule cronjob for daily night hot/online backup of production databases on tape using RMAN scripts.
•Refresh or restore development, test and reporting databases from production database backup using RMAN scripts or export/ Import and data pump utility.
•Schedule a cronjob and create lots of shell script in Unix environment like backup and restore of databases, update statistics, export and import of tables, log file maintenance, cleanup archive logs, startup and shutdown databases, email logs and alert to users, mount point space check, tablespace size check and business related activity like automatic bill payment, check generation, bill generation and many more.
•Created physical standby database on remote server to provide high availability.
Environment: RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, Oracle 9i/10g, AIX 5.1, 5.2, 5.3
Educational Qualificaton:
•Oracle Certified Associate Holder
•Bachelors of business administration Buea
Contact this candidate