Summary
Overview
Work history
Education
Skills
Certification
Accomplishments
Languages
Work availability
Timeline
SANIA ISA

SANIA ISA

Abu Dhabi,UAE

Summary

Experienced and specialized in delivering enterprise-wide complex projects and services, in a complex corporate environment, with 7+ years of experience in Oracle Database framework.

Experienced in Oracle Database operations to understand the customer’s requirement based on extensive contextual knowledge to handle complicated vendor managed Infra & Database upgrade.

Ability to manage time and priorities effectively to allow timely completion of multiple tasks on concurrent assignments with quality.

Excellent oral and written communication skills with positive and flexible attitude as well as strong presentation skill.

Overview

8
8
years of professional experience
5
5
Certification

Work history

Lead Oracle/SQL Server Database Administrator

Accenture
Bangalore, India
03.2018 - Current
  • Analyzed business reports for prompt communication, follow-up and ongoing support.
  • Produced high-standard database solutions to meet stability, reliability and performance metrics.
  • Installation and configuration of OEM 13c and also configured alerts for databases.
  • Table space management (Data file Resizing/Addition of data file) through Automation.
  • Installation and configuration of Uni and Bidirectional Golden Gate
  • Successfully completed purging and reorg of tables for this quarter.
  • Followed standard practices for migrating changes to test and production environments.
  • Created optimal technical solutions to user needs with in-depth system analysis.
  • Documented analysis results and provided performance improvement feedback.
  • Well Versed with usage of Oracle Export/Import feature to be used at Database/Schema/Table level.
  • Incorporated extensive familiarity with system for data management and backup and recovery accountability.
  • Designed and implemented TSQL queries for reporting and complex solution development.
  • Developed custom database objects, stored procedures and delivered application support.
  • Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
  • Created and updated database designs and data models.
  • Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
  • Set up and controlled user profiles and access levels for each database segment to protect important data.
  • Implemented BI solution framework for business intelligence projects.

Oracle Database Administrator

Accenture
Bangalore, India
05.2016 - 02.2018
  • Provided resources and skill sets to support DBA functions for applications.
  • Proposed database changes to ease monitoring and administrative effort.
  • Established working relationships across various departments to understand existing and emerging IT requirements.
  • Liaised with system administrators to monitor, troubleshoot, triage and provide RCAs for incidents.
  • Migration of OS version from HP-UX to RHEL 6.6 Linux and migration of Oracle Database version 11.0.1.7 to Oracle version 11.2.0.4.
  • Expert in Administration of Oracle Database and Applications E-Business Suite (11i & R12, 12.2 with 11g and 12c DB).
    Installation of 19c PDB/CDB database with ASM.
  • Good understanding on applying database and Application Patches (One-off, Mini Pack, Family Pack and CPU) and (ADPATCH, ADOP).
  • Performed, developed, and maintained Database Backup and recovery using Cold, Hot and RMAN.
  • Extensive experience in supporting and managing Production, Development and test Instances and Oracle Applications environments of varied complexity.
  • Did fresh installations of R12.1.1 and 12.2 Oracle Applications.
    Performed upgrade of EBS Application from 12.1.1 to 12.1.3.
  • Installation and creation of 10g, 11g and 12c RAC databases along with ASM.
  • Performed Database Refresh using Expdp/Impdp and Rman Duplicate utility.
  • Migration of database from one domain to other.
    Troubleshooting and Solving various tables and sync issues in GoldenGate and Shareplex.
  • Experience in supporting and managing Production, Development and test Instances and Oracle Applications environments.
  • Experience in creating various shell scripts in Linux/Unix for monitoring purpose.
  • Performed migration of 12TB database with minimal downtime of 6 hours using Advanced Transportable Tablespaces method (XTTS).
  • Administrative experience in managing Oracle Weblogic/ Oracle Fusion Middleware (Oracle ADF Applications, OBIEE and SOA Suite)

Education

Bachelor Of Technology - Computer Science

Kiit University, Bhubaneshwar
05-2016

Skills

  • SQL
  • Enterprise scale delivery
  • Strategy, Innovation and Redesign
  • Teamwork and Team management
  • Administrator leadership
  • Oracle GoldenGate
  • Oracle RAC
  • Dataguard
  • Oracle APEX
  • RMAN Backup And Recovery
  • OEM12C,13C
  • Performance Tuning
  • File and database management
  • Automatic Storage Management
  • Linux Scripting
  • Transportable Tablespaces
  • E-Business Suite

Certification

  • Oracle Cloud Infrastructure Architect Associate

  • Cloud Infrastructure Fondations Associate

  • Cloud Platform Application Integration Specialist

  • Microsoft Azure Fundamentals

  • Microsoft Azure Administrator

Accomplishments

  • Automated processes and scripts to reduce workflow by 60 hours.
  • Purged and Reorged 1 TB of data and saved the backup time by 20 hours.
  • Used Microsoft Excel to develop inventory tracking spreadsheets.
  • Supervised team of 5 staff members and delivered the project on time.
  • Documented and resolved the Database Corrupt Issue which led to Zero Data loss.
  • Achieved Appreciation by completing Golden Gate Replication Task with accuracy and efficiency.

Languages

English
Fluent
Hindi
Advanced

Work availability

Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
morning
afternoon
evening
swipe to browse

Timeline

Lead Oracle/SQL Server Database Administrator - Accenture
03.2018 - Current
Oracle Database Administrator - Accenture
05.2016 - 02.2018
Kiit University - Bachelor Of Technology, Computer Science

Similar Profiles

Create profile
SANIA ISA