We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

3.00/5 (Submit Your Rating)

SUMMARY:

  • Accomplished Database Administrator with over 7+ years of IT and related experience, including 7 years as Oracle DBAas well as some experience in MS SQL Server. Worked on operating systems like UNIX, LINUX, Windows and AIX. Experience include Installation,Upgradation, Patching, Migrating, Cloning, Memory Management,Performance Monitoring, Troubleshooting,Backup and Recovery, Database security, System maintenance, Database design and Modeling, Capacity planning, Documentation, Application support and deployment, Ability to write and maintain high quality documentation. An energetic and enthusiastic high achiever who can successfully manage multiple priorities and produce result under pressure with optimal calm.
  • Installation, Configuration and Capacity planning
  • Performance monitoring and tuning
  • Backup and Recovery
  • Database Security and Migration
  • Upgrades and Patching
  • Oracle RAC and ASM
  • Oracle Data Guard
  • Installation, configuration and upgrade of Oracle 10g, 11g and 12c, 19c, using OUI, DBCA, DBUA,Auto upgrade.
  • Data Integrity,Validation, Cleaning, Audit
  • Work with various operating systems including UNIX(Solaris8/9/10), LINUX Red Hat and MS Windows Servers 2008, 2012, 2014 and 2016
  • Monitoring and performance tuning using AWR, ADDM, OEM console, Grid Control, SQL Developer, Explain Plan, Optimizer Statistics
  • Backup and recovery using RMAN and Maintenance plan Wizard
  • Oracle Data Guard configuration and Administration (using Broker)
  • Oracle ASM and RAC
  • Database Migration using Data Pump utility
  • Database security including TDE
  • MS SQL Server Management Studio
  • MS SQL Server Configuration Manager
  • SQL, PL/SQL, T - SQL, UNIX Shell scripting
  • Customer Service
  • AWS (RDS,EC2,VPC,Migration, SNS notification, lambda,S3)
  • Microsoft Azure, functions, azure pipeline,storage,queues.
  • Snowflakes( tables, database, shares, streams, snow pipe, loading, integration, ExternaL Function, enable time travel)
  • Orchestration with Matillion
  • Python

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Database Administrator

Responsibilities:

  • Installed and configured Oracle 10g, 11g, 12c, 18c and 19c software on UNIX/LINUX operating systems.
  • Fixed various database performance issues using Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM) and Active Session History (ASH).
  • Strong in analyzing how Oracle resources are being used during SQL executions.
  • Identified long - running database queries, refine queries for better performance, and working with end- users to implement changes.
  • Involved in session management and monitored the critical wait events, blocking sessions in the database.
  • Experience indatabase upgrade using both DBUA and manual method, and database patching and backup and recovery to Microsoft Cloud using URL/Windows Azure
  • Experience in managing Oracle RAC for high availability.
  • Successfully configure and manage Data Guard for disaster recovery, data protection and high availability.
  • Performed Data Guard failover as required for maintenance. This includes coordinating with application owners and sys admins to when the failover can be performed.
  • Perform data and metadata migration to newly installed servers using Data Pump Expdp/Impdp.
  • Experience in data replication using snapshot, materialized views and dblinks.
  • Create database objects like views, procedures, functions, triggers, tables, synonyms and indexes.
  • Plan and perform Backup/Recovery using RMAN base on SLAs, test backup for corruption, Work with Flash Recovery Area as well.
  • Extensively worked on complete & incomplete recoveries of the databases including Point in time recovery (PITR) and Tablespace point in time recovery (TSPITR) using RMAN utility.
  • Clone production databases as needed for testing, development using RMAN.
  • Work on database security including Auditing (standard auditing, fine grain, valued based and statement auditing), Encrypting (Transparent Table Encryption).
  • Hands on experience in UNIX scripting.
  • Apply Oracle quarterly patches and Interim patches to databases using Opatch utility.
  • Experience in monitoring oracle instances and maintaining databases performance using OEM(Oracle Enterprise Manager 12c and 13c).
  • Use SQL Developer to connect to databases, navigate tables inside databases, create tables and other databases objects with GUI, insert data into tables and create reports.
  • Performed Data Guard failover as required for maintenance. This includes coordinating with application owners and sys admins to when the failover can be performed.
  • Involved in each phase of thelifecycle(SDLC) includingrequirement gathering, technical design, development, system integration phase, quality assurance phase,development,and production support activities.
  • Part of the 24/7 on call production support team.
  • Installed, configured and maintained Standard and Enterprise editions of SQL Server 2008, 2012, 2014 and 2016.
  • Successfully apply Service Packs on various software versions, migrate and update SQL Server databases from older to newer versions.
  • Experience in using SQL Server Configuration Manager to set up job scheduler SQL Server Agent.
  • Use a varied range of backup optimization techniques including incremental backup, backup stripping, backup resilient or mirror, compressed backup and backup with checksum.
  • Migration using data pump and transportation table spaces
  • Developed a backup strategy for our MSSQL Server databases and administered these databases using tools like SS management studio, SS DCA.
  • Working knowledge of Microsoft SSIS, SSAS, ETL, SSRS
  • Installed and configured the Oracle Golden Gate software on Unix/Linux platform for both Unidirectional and Bidirectional replication
  • Expert in working with PL/SQL including Procedures, Functions, Cursors and Triggers.
  • Installed, configured, patched Oracle database 18c and 19c software. Created databases and migrated data on 18c and 19c.
  • Installed, configured, and monitored Oracle golden gate in my environment.
  • Implemented Oracle Database advanced security practices such as Virtual Database Privacy, TDE and Data Masking
  • SQL tuning and database performance tuning using explain plan and SQL tuning advisor.
  • Utilization of Oracle Exadata Database machine for high performance of Oracle Databases increasing number of databases managed and reducing downtime.
  • Responsible for database backups, designs, development, testing, performance tuning and database and system security through unique database roles and object permissions, resized database files to decrease cloning, backup and restoring time.

Confidential

Oracle Database Administrator

Responsibilities:

  • Experience working with Oracle 10g, 11g and 12c.
  • Experience in applying patches such as CPU/PSU patches, One - Off Patches, Interim patches as per the oracle recommendations.
  • Good knowledge in setting parameter files (both Pfile & Spfile).
  • Monitored and performed database sizing, tablespacesand data files management.
  • Performed administration activities like user creation and administration, profiles, privileges and roles administration, space and schema management.
  • Performed Database Backup using RMAN utilities for physical backup and Data Pump utilities for logical backup.
  • Resolved database network problems using Oracle Net Configuration Assistant (NETCA)
  • Monitored the state of the listener by checking the status of listener and restarting listener.
  • Constantly monitored data files, control files, redo log files for space and availability.
  • Refreshed databases from Production to Test environments using a hot backup and data pump.
  • Cloned databases in Test, Dev, QA environments.
  • Used Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM)reports for turning database performance issues and applying recommendations.
  • Automated the processes using CRONTAB.
  • Created and managed database objects such as tables, indexes, materialized views and referential integrity constraints.
  • Performed capacity planning for databases.
  • Automated DBA task utilizing SQL and UNIX shell
  • Extensively worked on complete & incomplete recoveries of the databases including Point in time recovery (PITR) and Tablespace point in time recovery (TSPITR) using RMAN utility.
  • Monitoring the CPU, memory usage, I/O contention on servers using top, iostat, SAR, glance, vmstat etc.
  • Cloned production databases as needed for testing, development using RMAN.
  • Work on database security including Auditing (standard auditing, fine grain, valued based and statement auditing), Encrypting (Transparent Data Encryption).

We'd love your feedback!