We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

2.00/5 (Submit Your Rating)

Ashburn, VA

PROFESSIONAL PROFILE:

  • A motivated and proactive individual with a wide range of IT knowledge and expertise gathered over the span of 7+ years in fields such as Healthcare, Financial and the Communication domain.
  • Able to maintain strategic vision of the organization and link it with everyday work.
  • Very passionate about projects and able to carry out tasks that are time sensitive in an efficient manner to guarantee the growth and success of the organization.
  • A wonderful team player and a fast learner who values collaboration and communication, eager and possesses a very strong work ethic and can relate and work efficiently with diverse groups. Hardworking and honest young man with much potential.
  • Execute multiple tasks without supervision and ambition for challenging jobs.
  • Ability to work under pressure with or without supervision.
  • Experienced in installing, upgrading, migrating, patching, refreshing databases and cloning oracle homes
  • Upgraded GRID Infrastructure, RAC - Data guard setups for 11gR2 and 12c
  • Enforced database security strategies by creating database users, user roles, profiles, audit trails, audit banners and transparent data encryption
  • Experienced in database Backups RMAN (Full/Incremental backups) and in traditional hot/cold backups and in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Tablespaces
  • Experienced with Oracle RAC, Oracle Enterprise Manager Grid Control, Data Guard including Active DG and Flashback.
  • Performed PL/SQL development, Shell scripting and Performance tuning, OS utilities AWR/ADDM.
  • Installed and configured Oracle 11g RAC data guard physical standby and data guard broker.
  • Used OEM, SQL Developer, Mobaxterm, SCT, DMS, PGAdmin and TOAD to administer database.
  • Experience with My Oracle Support (MOS)/Meta link for Oracle SR, patch download Experience and TFA reporting
  • Determined problem-solver with success in aligning the business and industry’s best practices and technical vision in order to initiate, implement, and improve innovative business technology solutions
  • Experienced with HP service Manager’s service desk and on-call tools for problem/incident management and on-call support.
  • Goldengate configuration for business intelligence purposes.
  • Excellent communication, inter-personal and organizational skills.

TECHNICAL SKILLS:

  • Oracle 12c/11G/10G Architecture Linux/UNIX/Window Client/Server Environments Maximum Availability Architecture Oracle software installation and maintenance Production support and maintenance
  • Backup & Recovery strategies Database Security & Space Management Shell and SQL scripts to monitor databases Shell scripting AWR/ADDM/ASH report generation VMware, Oracle Virtual Machine, AWS, Oracle Cloud Infrastructure (OCI), Goldengate

PROFESSIONAL EXPERIENCE:

Confidential, Ashburn, VA

Oracle Database Administrator

Responsibilities:

  • Upgraded several databases from 4
  • Manages several databases on AWS RDS Instances.
  • Migrated Oracle OnPrem Databases to AWS Aurora Postgres
  • Migrated Oracle OnPrem Database to Oracle cloud infrastructure using Standby DR strategy for minimal downtime.
  • Using Schema Migration Tool (SCT) and Database Migration Service (DMS) to migrate to the cloud.
  • Goldengate installation and configurations.
  • Enable TDE on all OCI database running on Exadata in the cloud.
  • Oracle secure backups to the cloud
  • Applied quarterly PSU Patches to RAC/Non-RAC databases.
  • General administration and routine operations including ASM disk group management, applying database tuning improvements, managing users and database security, troubleshooting and performance tuning.
  • Upgraded several databases from .1.2.0
  • Configuration of container and pluggable databases
  • Working with Jenkins and Docker for DevOps automations.
  • Upgraded GRID Infrastructure, RAC-Data guard setups from 2
  • Export and import of tables and schemas as per development/Application team requirements using Data pump
  • Generated scripts for daily maintenance routine activities, growth rate monitoring and optimizing database performance
  • Oracle RAC/data guard Installation and upgraded from 11.2.0.1 CRS/ASM to 11.2.0.4 GRID infrastructure.
  • Routine database replication using either active active or active passive topology.
  • Provide planned maintenance for the implementation of new releases and Database migrations
  • Provide support after normal business hours (i.e., nights, weekends, and holidays) and participate in a 24 x 7 on-call rotation.
  • TDE configuration for tablespaces as new security measure for cloud databases.
  • I manage about 210 databases with the minimum size of 40G and Maximum size of 1 - 5 Terabyte which keeps growing.
  • Recently migrated 7 databases between 900G and 5 Terabyte to the cloud using Data guard for minimum downtime.

Confidential, Fort worth, TX

Oracle Database Administrator

Responsibilities:

  • Delivered 24/7 database administration support to more than 250 servers and 310 databases, which include oversight of DBA on-call rotations.
  • Proactively provided support to RAC, ASM, and Data Guard physical standby databases throughout daily production operations.
  • Resolved archivelog gaps and other related problems. Effected switch over manually and using DMGDRL
  • Used AutoSys, windows task scheduler and Crontab to schedule weekly backup and file clean jobs
  • Closely tracked and administered the production environment, which includes database alert logs, file system disk space, tablespace monitoring, system shut downs, and database restarts for maintenance purposes.
  • Performed refresh of schemas from production to test environment using the DATAPUMP utility (expdp/impdp).
  • Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12c Grid Control, OraTools and TOAD
  • Successfully run complete, incremental, and archive backups with Recovery Manager (RMAN).
  • Upgraded multiple databases from 11.2.0.3 to 11.2.0.4.

Confidential, Adrian, MI

Oracle Database Administrator

Responsibilities:

  • Installed and configured Oracle 10g/11g software on Linux.
  • Refreshed databases and configured them to meet developer and user requirements
  • Applied Oracle Critical PSU on our databases on quarterly basis.
  • Managed backups and recoveries using RMAN, data-pump export/import utilities Managed tablespace, control file and online redo logs.
  • Conducted regular status checks, monitoring the Alert log, trace files of databases.
  • Monitor databases which include basic health checks, growth of objects, and performance of databases.
  • Monitored database activity and file usage by removing old or obsolete files to ensure necessary resources are released to enhance database performance.
  • Checked database and servers for disk contention, monitored resource usage, system events, to maximize performance.

We'd love your feedback!