Kristi
adgq2s@r.postjobfree.com
Oracle Database Administrator
St Louis .MI
Career Summary:
Over 8 years of experience of Oracle Database Administrator including 10g, 11g and 12c 18c.19c
Managed databases on Linux, Solaris, Windows, AIX and HPUX.
Refreshed data using exp/imp and data pump on a regular basis.
Supported database on Exadata Cloud X7 (ExaCC)
Upgraded databases from 10g to 11g R2 12c 18c & 19
Oracle Multi-Tenant Patching (PSU).
Managed databases on Amazon cloud (AWS).
Migrated databases from standalone to Clusters.
Tuned SQLs for better performance.
Performed Instance and database tuning using various tools.
Analyze ASH and AWR to check the top waits and top SQLs.
Used ADDM reports to verify oracle recommendation.
Managed small and big tablespaces. Experience with installing and maintaining Oracle 13c Cloud Control
Implemented data replication through materialized views
Build RAC Clusters.
Set up grid control alerts and thresholds
Excellent troubleshooting skills and quick learner.
Build Linux servers and build 12c standalone database server.
Moved database from one data center to another using data guard.
Configured / Managed ASM disks and disk groups
Worked with Different teams to completed Build tasks
Created documents to speed up future builds.
Worked with Different teams to completed Build tasks
Build Disaster Recovery sites using Oracle Data Guard.
Installed and configured databases using silent install, OMF and via scripts.
Has extensive knowledge in dynamic views and dictionary tables.
Applied CPU and PSU patches.
Extensive experience in OS space and tablespace management.
Worked on database security and Fine Grain Auditing.
Extensive work on shell scripting and documentation.
Excellent Experience as Production DBA with 24X7 supports.
Extensive experience in backup and restores using RMAN
Database replication using snapshot, materialized views and advance replication methods
Strong in writing shell scripts to setup cron jobs for checking Adaptive server's availability, backup of databases and crucial system tables, nightly batch jobs for data transfer between servers.
Flexible and excellent team player. Ready to work in any shift.
Excellent troubleshooting skills and quick learner. Setup and support AWS
Build Linux servers and build 12c standalone database server. Moved database from one data center to another using data guard.
Technical skills:
Operating Systems
RHEL, HPUX, AIX, Sun and Windows
RDBMS
Oracle 12c, 11/10g, SQL Server
Tuning Tools
ASH, AWR, ADDM, SQL Profile, SQL Baselines, Execution Plan, OEM
Languages
SQL, PL/SQL, UNIX Shell scripting, T-SQL
Tools
RMAN, OEM, sqlldr, exp, imp, expdp, impdp, TOAD, DBConsole, asmcmd
High Availability
RAC, Data Guard, ASM
Education:
Associate Degree in Applied Science (since 2017, in process)
Addison Trail High School Addison, Illinois, DuPage
Professional Experience:
Ally Bank ST Louis Missouri
Oracle DBA Jan 2016- present
Responsible for administration and supporting oracle 19 c,18, 12c, 11g, 10g and 9i databases
Performance tuning of applications and the databases Oracle 11g/10g
Build 2-node RAC Cluster on Linux.
Build Data Guard for RAC Cluster.
Documented procedures.
Proactive database monitoring using 11g grid monitoring tool.
Install Oracle supplied tools to assist in database and SQL Tuning like SQLT
Performing tuning of application with RBO, CBO, using Trace, tkprof, Explain plan, statspack, AWR, ASH and ADDM.
Worked on slow running queries to optimize databases performance.
Database performance monitoring, Application performance monitoring, tuning database and application with efficient database parameters.
Worked on Performance Tuning tasks to reduce the query response time.
Remove unnecessary histograms in highly volatile schemas.
Worked in Tuning OS, Shared Pool, Buffer Cache, and Redo Log Buffer.
Performed tasks on setup users accounts, passwords, roles, profiles and quota
Monitored data files, logical data storage and data growth activities
Perform capacity planning required to create and maintain database environments.
Performed Silent installation on Exadata.
Applied patches on computer nodes, Exadata home and storage cells.
Migrated standalone databases to Exadata
Implement disaster recovery with use of Exadata
Nationwide Insurance Remote
Oracle DBA Sept 2011 Dec 2015
Responsibilities:
This project pertains to installation of oracle 10g RAC and later converted to 11g upgrade.
Responsible for administration and supporting Oracle 10g/11g.
Provide ON-Call 24*7 Production Database Support having 5-6 TB in size.
Implemented Data Guard for maximum availability.
Responsible for restoring and recovering database as required for Oracle.
Upgraded the database from Oracle 10g to 11g, configured on ASM, and applied oracle patches on need basis.
Used Shell Scripting for automation of job Scripts, for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
Installed, Configured, Upgraded and Performed Trouble Shooting for oracle Golden Gate 10g/11g Version.
Proactively monitored the database and database access, and maintained the database security.
Extensively worked under UNIX environment to provide DBA support.
Ran the Oracle STATSPACK on the Oracle Instances to find out the System Performance Statistics during the peak load times.
Configured Oracle tools like SQL*Net to access the database from the network.
Managing Instances, redo log files, Table spaces, Data files, storage structures, rollback segments, Undo segments, Temporary segments, Indexes.
Implementation of nightly logical backup.
talink with Oracle Corporation and installation of patches
Created Triggers for multi-master replication
Worked with client on regular basis.
Implemented procedures and practices regarding database design, development, monitoring, access, and upkeep.
Installed and configured database management system software.
Developed and implemented backup and recovery strategies.