We provide IT Staff Augmentation Services!

Senior Oracle Database Administrator Resume

SUMMARY:

  • An accomplished and seasoned Senior Oracle Database Administrator (SDBA) Oracle Cloud Infrastructure Professional and Azure Cloud), System Administrator, Cloud Infrastructure professional (AWS Solutions Architect Associate, with over
  • 8+ years of experience with extensive knowledge in Oracle database administration, IT Support Specialist (Certified by Google), Oracle Certified Associate (OCA) in Oracle 12c platforms with extensive knowledge in configuration and Installation,proficient in Oracle 10g, 11g and 12c, 18c, 19c, MySQL, MS SQL Server and PostgreSQL highly accomplished, deeply driven Configuration,
  • Patch Installation.
  • Expertise in Database Design and development (SDLC), Monitoring & Tuning, Migration, Upgrades, Backup & Recovery, Cloning, data modeling and Security Implementations. Enthusiastic, proactive team player who is fast at picking up new technology with great attention to detail with strong organization, verbal, and written communication skills able to multitask successfully and thrive in a dynamic fast paced and versatile work environment.

TECHNICAL SKILLS:

  • Installation, configuration, and upgrade of Oracle 10g, 11g and 12c using OUI, DBCA, DBUA
  • Azure Cosmos DB
  • Software & Application: REST API, HTMLS
  • Strong proficiency in MySQL database management
  • LINUX (Red Hat, Ubuntu, Centos)
  • Decent experience with recent versions of MySQL
  • 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 Exadata administration; X5, X8
  • IAM administration
  • Microsoft Office (Word, Excel, PowerPoint, Access).
  • Oracle Data Guard configuration and Administration (Using Broker)
  • Oracle ASM and RAC
  • Azure Cosmos DB
  • UNIX (Solaris 8/9/10)
  • Python, Ansible, Jenkins, API, Terraform
  • Database Migration using Data Pump utility
  • MS SQL Server Management Studio
  • MS SQL Server Configuration Manager
  • SQL, PL/SQL, T - SQL, UNIX Shell scripts
  • TDE (Transparent Data Encryption

PROFESSIONAL EXPERIENCE:

Senior Oracle Database Administrator

Confidential

Responsibilities:

  • Upgrade of GRID and Oracle Databases from 12.1.0.2 to 19.10 as well as convert Non CDB databases to Pluggable databases.
  • Installation, configuration, Administration and Upgrade of Golden gate
  • Perform scheduled maintenance and support release deployment activities during regular working/after hours
  • Enhanced the performance of the company’s Oracle environment by providing advanced performance tuning using tools like AWR, ADDM, EXPLAIN PLAN, ASH, SQL TUNING ADVISOR, TKPROF, SQL TRACE automated via OEM grid control 12c and both command line.
  • Application of Oracle Database 19c Patch Release Update in both QA and Production environments.
  • Managing, troubleshooting, and resolving Oracle database and application issues.
  • Created scripts and scheduled backups in Cron for RMAN database backups and recoveries.
  • Logical Volumes layouts, Disk layouts and Capacity planning
  • Supported development teams for all the database related issues and handled the critical issues like network failures and ASM DISK group errors and node failures in the RAC
  • Restore and recover of database from offline, online and RMAN backup.
  • Created and managed database objects such as tables, indexes, materialized views and referential integrity constraints.
  • Database upgrades, resource capacity planning, platform migrations, application consolidations and data center rationalization.
  • Maintained database security via unique database roles and object permissions. Resized database files to decrease cloning, backup, and restoring time.
  • Executed and provided ADDM, AWR and database health check reports to information owners and recommended solutions for improved performance.
  • Maintained various SLA’s including ticket response and resolution time.
  • Plan and perform Backup/Recovery using RMAN based on SLAs, test backup for corruption, Work with Flash Recovery Area as well.
  • Resolved locking issues, inconsistencies and assisted in batch processes.
  • Redesigned table and index partitioning strategies, using HINTS to improve the query Performance.

Senior Oracle Database Administrator

Confidential

Responsibilities:

  • Performed Installation, security and patch upgrades over successive Oracle generations using the OUI and DBCA
  • Created and granted users the privileges and roles and resizing the datafiles to manage database growth.
  • Refreshed schema using Export/Import. Created databases, tablespaces, tables, indexes, set privileges and user logins
  • Full responsibility and expertise in database administration (DBA), performance tuning, database backup, database recovery, database security, database optimization, data migration of Oracle instances
  • Monitoring and performance tuning using Oracle Enterprise Manager Console and SQL Developer to manage daily tasks regarding performance and maintenance
  • Monitoring and reporting daily backup with RMAN, configuring, and managing backups (full and incremental)
  • Performed Installation, security and patch upgrades over successive Oracle generations using the OUI and DBCA
  • Full responsibility and expertise in database administration (DBA), performance tuning, database backup, database recovery, database security, database optimization, data migration of Oracle instances
  • Created database objects such as tables, views, synonyms, sequences and triggers
  • Database Security monitoring and security compliance auditing
  • Monitors and resolves Data guard problems, maintains flashback capability, troubleshoots database problems including performance issues and resolves them with the AWR, Performance views and SQL Tuning advisor.
  • 24x7 Production database administration, support and monitoring to ensure proactive problem solving.
  • Upgrade of Oracle Enterprise manager (OEM) 13.3 to 13.4 and applied OMS, Agents, Grid and Database Patches.
  • Migrated data from Oracle 10g R2 database on UNIX to Oracle 11g on a Linux platform.
  • Table space monitoring, Performance monitoring and tuning for performance improvement.
  • Implement database security using Oracle's Transparent Data Encryption (TDE) to protect the organization's critical information and exceed the industry standard.
  • Perform SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) reports and automatic session history.
  • Administered tablespaces (data file) on space management and adjusted for future needs

Hire Now