Manager Data
Resume:
YAKAM
TANKWA
Oracle Database Administrator
adcmao@r.postjobfree.com
I’m a Database Administrator with 5 years of experience installing, configuring, upgrading, and migrating Oracle, PostgreSQL, and MySQL databases. I'm Proficient in database tools like ASH, AWR and ANALYZE. I've used monitors like SSRS, pgBadger, omniDB, Toad and OEM just to name a few
SKILLS SUMMARY
25 PostgreSQL and 5 MySQL Production Databases and their associated Non-Production Databases.
Installation and Configuration of PostgreSQL and MySQL Software and Creating Databases.
Handled Disasters including failover and loss of databases and storage for PostgreSQL Databases.
Performed PostgreSQL Database Migrations across different hardware and between different systems (OS Versions and RDBMs)
Well versed with SQA (Software quality assurance) life cycle, requirement gathering, deploying test cases
Strong experience in migrating database from Non-ASM to ASM and Non-RAC to RAC
Administered Oracle ASM disk groups (mirroring, compatibility) with Oracle ASM Configuration Assistant (ASMCA)
Proficiency with Installation/maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate
POC of 12c new features like Redaction policy, adaptive query optimization, multiple indexes on single column
Knowledge of tools and features like Data Replay, Log Miner and Flashback data Archive, Schema Management, Data guard and RMAN in Oracle 11g
Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
Strong Knowledge and experience of Creating Users, Public Synonyms, materialized views, Database Links, roles, profiles, privileges, Audit Triggers and assigning roles to users
EDUCATION
BA in Economics - Towson University
TECHNICAL SKILLS
Operating Systems:
Red Hat Linux RHEL 5.x and Windows XP
RDBMS:
Oracle 10g, 11g, 12c, PostgreSQL 9.x – 10.x
Languages:
SQL, PL/SQL, Python, UNIX Shell Scripting, bash and Perl Scripting
Software/ Applications/ Tools:
DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, Sql Navigator, TOAD, Data Pump (expdp, impdp),SRVCTL,SQL*Plus, spotlight oracle
Tuning Tools:
SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM
PROFESSIONAL EXPERIENCE
Fiserv - Brookfield, WI
February 2018 – February 2020
Oracle Database Administrator
●Manage databases running Oracle 11g & 12.2.0.1 on Standalones & Exadata environment, running on X7s with the use of both Cloud Control 12C & 13C in monitoring
●Managing 25 PostgreSQL and 5 MySQL Production Databases and their associated Non-Production Databases
●Installation and Configuration of PostgreSQL and MySQL software
●Provided support for applications, including developing data migration scripts and data validation queries
●Deployed Oracle E- Business Suite, initiated and implemented environment cloning
●Troubleshot and resolved issues in EBS, Discoverer, Logical Apps and Vertex
●Executed backup and recovery techniques using RMAN and processed multiple items of Oracle EBS 11
●Work with application development team staff to develop & test database architecture and approve all production schema changes
●Database monitoring and performance tuning using OEM GC, AWR and ADDM, ASH, SQLT, TRCA, SQL Access Advisor, SPM
●Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace, TKPROF.
●Regular Proactive Health Checks for all the PostgreSQL and MySQL Databases through my automated shell scripts
●Managing/Building Standby (Slave/Replication) Servers for all the PostgreSQL Databases as requested by the Application Teams based on criticality of the Applications
●Refreshes from Production RAC environment to TEST RAC environment.
●Database refreshes using export /import and datapump. Used RDA, ADDM and AWR reports to monitor the database performance
●Refreshing Dev and Test instances with data from Production on a regular basis
●Experience in monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM grid) 10g /11g/12c
●Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM. Performance Tuning of the database (Memory Tuning, I/O Tuning)
●Able to resolve the performance issue in database 12c using full database caching and In-Memory Aggregation features
●Hands on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature
●Starting and stopping the agents to clear metric alerts and collecting ADDM reports in OEM
●Creating blackouts and templates in OEM and migrated databases from Non ASM TO ASM
●Performed various tasks on ASM, creating a disk group, adding a disk to disk group, making disk online and offline and troubleshooting issues in ASM environment
●Implemented physical standby database for maximum availability using Oracle Data Guard 11g with Oracle Enterprise Manager (OEM) 12C cloud Control
●Used import/export utilities for cloning/migration of small sized databases and Data pump import/export to move data between 10g/11g and 12c environments
●Implemented Active Data guard on 12c environment for the Production databases
●Experience Installing OEM 12c and 13c Cloud Control and upgrading the 11g management agents to 12c agents
●Implemented Golden Gate while moving large volumes of transactional data, with minimal impact to online system
●Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
●Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM
●Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups
●Working as a primary DBA on a critical application and managing 22TB of databases
●Managing two node Oracle 11g R2 RAC with grid infrastructure and set up Data Guard for them.
●Managing stand alone database with ASM devices.
●Set up failover for oracle clusterware with HACMP clusterware for 11gR2 database with ASM
oconfiguring and maintaining physical standby data guard for RAC and non RAC databases on 11gR2
●Monitoring, Troubleshooting RAC cluster using SRVCTL and TAF
●Monitoring and maintaining 2/3 node RAC database on Red Hat Linux. Providing support to the development team and handling release schedules
●Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures for daily basis using crontab
●Implemented SQL outline to get a better execution plan for the offending queries
●
Paradigm - Houston, TX
July 2015– February 2018
Database Administrator
●Cloned/Migrated databases using RMAN and traditional Data pump export/import utilities in Oracle 10gR2
●Built 4 node RAC 11gR2 Standby database and set up DG Broke
●Performed SQL and PL/SQL tuning oracle contention and monitored production database
●Performed disk and disk group management in ASM while installing 11gR2 RAC.
●Monitoring Health checks of OCR, VOTING DISKS and troubleshooting issues in RAC environment (11GR2)
●Fixed issues with Pgadmin-III client application. Responsible for monitoring environments using monitoring tool viz. Nagios, Check_Postgres.pl, pgOn, custom scripts and other supporting tools like pgBadger and tailnmail
●Installing and configuring new servers as per customer's request. Cloning the Development, test and UAT environments with production data as per customer's request
●Design and implement disaster recovery for the PostgreSQL Database. Configuring third client software pgadmin-III, phppgadmin to access the database server. Configuring the backup jobs on the customer system. Experienced in performing PITR
●Patched, Upgraded and kept PostgreSQL DBs current. Developed and enhance scripts to automate and execute various DBA tasks
●Expertise in PL/SQL, SQL and UNIX Shell Scripting (Implemented UNIX Scripts using CRONJOB for Day-to-Day activities and Windows Task Scheduler)
●Partitioned tables Maintenance, adding new partitions, exchanging one-year old partitions then archiving of the exchanged partitions, dropping or truncating of old portions
●Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries
●Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN
●Scheduled the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs
●Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups
●Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries
●Maintained the data integrity and security using integrity constraints and database triggers
●Provided 24X7 support for all the production and development databases
●Strong skills in applying security patches (Patch set, Critical Patch Updates, Patch Set Updates, One-off Patches
●Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 12c)
●Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g
●Performed Installation and configuration of Oracle 11.2.0.4 database on HP-UX platform
●Successfully performed migrations from Oracle 11g to 11gR2 RAC (Real Application) Database
●Created Oracle Wallets and implemented Tablespace level TDE security
●Constantly monitored the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files
●Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker or manual
Contact this candidate