Oracle Database Administrator Resume
3.00/5 (Submit Your Rating)
Washington, DC
SUMMARY:
- I am a Database Administrator with approximately 5 years of hands - on experience in database creation, configuration, management, supervision, tuning, monitoring, backup, recovery, & security implementation.
- My passion started for database administration in 2014 and has allowed me to become extremely skilled in using Oracle 10g, 11g, 12c, & 18c.
- I have very in-depth and widespread experience in Oracle Database Administration on 24x7 critical production and large databases using Oracle RDBMS.
- My al background in database administration also includes being very proficient with MySQL Server, MsSQL Server, AWS Services, RDS, Aurora, Redshift & DynamoDB.
- The confidence I portray in my skills has allowed me to become a team leader in a plethora of group projects that I have lead successfully.
- Oracle 11g, 12c, & 18c Database Administration
- Installation of Oracle grid infrastructure and ASM.
- Troubleshooting on a single instance in UNIX/Linux.
- Security Technical Implementation Guidelines (STIG) Compliance Standards Violations. Database & System Security (Auditing, data access, profiles) as per STIG Rules.
- Performed Upgrades of Oracle 11g to 12c, and 12c to 18c within the same server & different servers
- Database creations: multi-tenant databases, single instance & RAC environment.
- Proficient in using various database utilities like SQLLoader, SQLDeveloper, DataPump, TFA.
- Hypervisor/Virtualization (Oracle Virtual Machine & VMWare)
- Migration of databases and schemas across multiple platforms of Windows to Linux, Oracle 10g to 11g, Oracle 11g to 12c, & Oracle 12c to 18c
- Migration & Upgrade from Premises into Cloud with AWS DMS & Schema Conversion Tool
- Encrypted & Compressed Backups from Premises into Cloud (AWS S3)
- Providing support in Massive Data Uploading ETL using the SQL*Loader utility and DataPump.
- Database design with developers from scratch. Creating ERD’s, for forward and reverse engineering, to OFA Institution.
- Monitored (ADDM, Alert log, dynamic performance views, DBMS STATS)
- Tuning including capacity planning and report creation/distribution.
- Performance monitoring using Oracle Enterprise Manager, ADDM, AWR Reports, TOAD, and SQL Developer.
- Performance Tuning & Capacity Monitoring
- Database Monitoring
- I/O balancing and performance enhancement, utilized table partitioning & purge for space management.
- Patching, Upgrading, Migration & Cloning
- Backup & Recovery
- Oracle RAC Administration w/ GRID Control
- SQL Tuning for Performance Optimization
- Implementation of Flashback Technology, Log Miner, Automatic Database Diagnostic Manager (ADDM)
- Dataguard; Dataguard Broker, Failover and Switchover.
- Standby/Failover Administration
- ASM & Grid Control instances
- Golden Gate
- Replication: Materialized Views, oracle streams, & GG
- Recovery Strategies for disaster scenarios
- Linux Redhat 6.2
- Oracle E-Business Suite
TECHNICAL SKILLS:
Databases: Oracle 10g, 11g, 12c, 18c, & AWS
DB Tools: Oracle (SQL*Plus, SQL Loader, DB Configuration Assistant, NETMGR), OEM, Toad, OEM Grid, RMAN, Exp/Imp/DataPump, AWR, ADDM, OUI, DBUA, Oracle Trace File Analyzer, DBMS STATS, SQL TRACE, TKPROF, EXPLAIN PLAN, ADRCI, & SQL Tuning Advisors.
Operating Systems: Linux, Red Hat LINUX 6.2 & 7, Centos 5.3, MS Windows Server (2008/ 2012), UNIX (Solaris 8/9/10), Oracle E-Business Suite
PROFESSIONAL EXPERIENCE:
Confidential, Washington, DC
Oracle Database Administrator
Responsibilities:
- I have installed and configured software, Oracle 10g, 11g, 12c, & 18c on Windows and UNIX/Linux platforms using Oracle OFA
- Database conversion to a pluggable database on 12c.
- Database Creation & database structure changes, table/index sizing, SGA sizing, SQL, I/O & Application tuning, transaction monitoring, detecting lock contentions, tuning sort operations.
- Capacity planning (supported 3 tier architecture, planning of tables, indexes, tablespaces and databases) with developers to allow for growth potential and analyze data growth trends for capacity, resource, and production.
- Cloning using utilities and manual methods for all database sizes
- Designed and implemented different backup strategies like Cold/Hot procedures, RMAN with Flash Recovery Area, and Logical Backups (expdp/impdp) & DATAPUMP utilities respectively.
- Scheduled Backups, purge jobs, Maintenance Jobs using DBMS JOBS, DBMS SCHEDULER, Crontab and $UNIVERSE.
- Automated tasks at operating system level using Crontab and AT and also at the database level using SQL Scripts and PL/SQL procedures.
- Configured Backup and Recovery setting for Oracle database 10g, 11g, 12c, & 18c for single instance on File system & ASM storage using RMAN
- Applied Database Security Patches: Critical Patch Update (CPU), Patch Set Update (PSU) and One-off Patch using OPatch while incorporating Oracle's best practices with quarterly patches.
- Installed, Configured & Managing Oracle 11gR2 Data Guard (Active Physical Standby) for single & multiple instances to achieve high availability
- Installed, setup, configured and currently Managing Oracle 12c Grid Control (OEM) for monitoring multiple Databases, Production, Active Dataguard (DG Broker), Stage and Dev systems.
- Performed instance tuning by changing init.ora parameters & managed region parameters such as shared pool size & db cache size
- Constantly monitored the Alert logs Files, Trace Files, System Event Logs for unusual events and took appropriate action to resolve any issues, according to company policies of incident reports.
- Performance monitoring, Database Monitoring using OEM, TOAD and Spotlight, and Database/Instance/RAC tuning using Dictionary views, AWR, Statspack, ADDM, ASH reports, OEM Grid Control, Fine tuning of SGA/PGA parameters, initialization parameters and reorganized physical objects (tables & indexes) and table spaces at performance standpoint.
- Involved in creating and managing users and objects as well as assigning roles and privileges to different users for improved security by 40%
- Tuning of Oracle Databases for performance improvement, sizing database objects for effective space management and for optimal performance, using AWR, ADDM, ASH, Trace Analyzer, SQLTXPLAIN, OSWatcher and other OS related utilities like pstack, pmap, top, vmstat, iostat, prstat, strace, truss and also used Oracle Enterprise Manager(OEM) 11g and 12c to monitor single instance and RAC databases.
- Converting Standby database to Snapshot standby database for pre-go live activities
- Identifying performance bottlenecks on high volume transaction systems, & analyzing/performance tuning SQL statements & design indexes to improve the response of SQL queries in an Oracle Environment.
- Lead DBA team occasionally on specific projects such database upgrades, database/schema migration and database patching.
- Supported Production databases on 24/7 on call rotation; shared responsibility with fellow DBAs for 24/7 on-call support.
- Documented work progress and updated work road map on project status for administrative and managerial assessment
- Followed my daily database administration duties, which including some, but not all, proactive monitoring and tuning strategies to satisfy clients SLA for databases ranging from 10GB to 2.3TB.
- Collaboration with the System Administrator to configure any software and hardware requirements that will function with the Oracle Database.
- Migration of databases and schemas across multiple platforms of Windows to Linux, Oracle 10g to 11g, Oracle 11g to 12c, Oracle 12c to 18c and etc. using DataPump within the same server & different servers.
- I have installed and configured the latest Linux Redhat 6.2 software. I monitored the servers and Linux Redhat 6.2 scripts regularly, performed troubleshooting steps, & tested the software to make sure there were no software issues, on a server for end-users.
- Database security policy creation and institution, using passwords, privileges in user profiles, basic data encryption, network security, system security, Transparent Data Encryption, DataPump, RMAN Encryption and User Account Management.
- Establishing recovery strategies and implementation of Oracle Dataguard standby failover systems in disaster scenarios.
- Configuration and management of ASM - Grid Control instances. Configured Oracle Restart
Confidential, Fairfax, VA
Oracle Database Administrator
Responsibilities:
- Worked on a cross-functional team that oversaw the Oracle RAC & Data Guard installations/administration and configurations for Linux environments, High Availibility & Optimal Performance.
- Analyzed Tables, Indexes and Clusters against chained and migrated rows and provided solutions.
- Pro-active Database Monitoring objects and usage to determine if objects needed to be cached.
- Partitioned tables Maintenance, adding new partitions, exchanging one year old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.
- Assisted Senior Database Administrators in mentoring and instructing individuals and companies to achieve higher productivity.
- Assisted in teaching, helping and mentoring junior DBAs from understanding the basics to Advanced Database Creation, Development and Administration. Assisted in formulating lesson plans primarily in the areas of Oracle on Unix/Linux/ Windows platforms, SQL Server Database Admin, Oracle E-Business Suite Admin (Install & Patch) and some Development courses for 10g,11g, 12c, & 18c.
- Resolved any customer questions & complaints with proper solutions and performed routine checks on the Linux RedHat 6.2 servers of the firm.