Technical Support Oracle

MELKIT KAUR +1-650-***-****

Hayward,CA

*******@*****.***

SUMMARY

Over nine years of IT experience in Database Administration, Development, and Test and Production support of Oracle 8i/9i/10g/11g and MySQL Databases Server. Oracle Certified Associate, Experience with VLDB in Global Environment

EXPERIENCE

• Database Administration expertise includes installation, upgrading, database creation, backup, recovery, optimization and performance tuning of Oracle 11g/10g/9i/8i in UNIX, Aix & Solaris platform.

• Installing, configuring and upgrading the Oracle and MySQL Database Server.

• Experience working with Development and production support of VLDB environment (2TB).

• Experience in upgrading databases from 8i to 9i,9i to 10g and 10g to 11g.

• Experience in upgrading MySQL databases

• Worked on 10g and 11g New Features: Data Pump, Automatic performance and diagnostics, Flash Back Technology, 10g and 11g RMAN’s New Features.

• Experience in PL/SQL code development constructing procedures, packages, triggers and functions.

• Experience in Installing 10g Grid Agent on servers and configure to the OEM Grid control.

• More than 5 years of experience on Oracle database administration on UNIX, Aix & Solaris platform

• Experience of supporting Oracle, SQL Server and MySQL DB.

• Experienced in handling all the domain and technical interaction with application users, analyzing business processes, documenting business requirements.

• Experience in Oracle (RAC), Oracle Warehouse Builder DB which runs ETL and Oracle Grid.

• Experience in applying the DST and SECURITY PATCHES on databases.

• Good experience in Stored Procedures, Functions, Database Triggers and Packages using PL/SQL.

• Good maintaining tables, indexes, views, partitions, materialized views and optimize quires.

• Perform interface development and operations, database tuning, capacity planning and database monitoring.

• Perform benchmarking of oracle characteristics related for performance as required by client and report feasibility of use of those characteristics in client.

• Ability to apply innovative approaches to solving design and technical issues.

• Experience in tuning of complex SQL statements, Explain Plan, TKPROF and DBMS_STATS.

• System wide tuning using UTLBSTAT and UTLESTAT (stat pack).

• Cold/Hot/Logical Backup and Restoration of database.

• Automation of the database Backup and Recovery process using shell scripts.

• A quick learner, with capacity to learn and embrace challenge

• Proven ability to work under pressure of time constraints and to prioritize assignments necessary.

• Proven ability to work effectively and provide support within a technical team.

Technical Skills

Databases : Oracle 12c/11g/10g/9i/8i/8, Oracle 10g/11g RAC

Operating System : HP-UX 11/11i, Sun Solaris 8/9, Red Hat Advanced server2.1,

RHEL 3.0,4.0.5.0, Windows NT/2000/2003.

Language/Tools : SQL, PL/SQL, SQL*LOADER, SQL*Net, OEM, RMAN, Export/Import,

TKPROF, Data Pump, Backup/Recovery and Shell Scripting.

Education:

Associate Degree Computer Science/Information Technology.

Multimedia University Melaka, Malaysia

Completed on July 2005

Certifications:

Oracle Certified Associate 10g 2008

Trainings Attended Course for OCA and OCP

Trained in backup and recovery procedure via RMAN

Trained on Critical Patch Update on databases.

Basic knowledge on SQL Server Database.

Knowledge of ITIL/Change management

Attended courses on communications skills.

Professional Experience

Organization : Dhiriti Solution

Role : Remote Oracle DBA

Duration : June’15 – Feb ’16

Environment : Oracle 10g, 11g, 12c

Description :

• Provide technical support remotely on Oracle database.

• Perform routine database checks and changes.

• Work on requests made by customer on the database.

Responsibilities involved:

• Provided database administration supports for Dhiriti Solutions’ clients.

• Written and modified shell scripts and setup Cron jobs.

• Closely worked with Oracle support in resolving ORA-600, ORA-7445 and ORA-3113 issues.

• Resolved issues related to Materialized view refresh, performance and db-links.

• Tuned PL/SQL queries using tools like AWR, ADDM and Explain plan for optimum performance.

• Worked with offshore team remotely

• Worked with different teams remotely like security, network, storage and System Admins to complete project on time.

• Cloned databases using RMAN Duplicate database.

• Troubleshooter of many networking related issues.

• Used Transportable Tablespace to move tablespace one database to another.

• Analyzing the growth of tables and undertaking necessary re-organization of the database when required.

• Fixing minor and major PL/SQL errors or bugs in the database

• Responsible for providing application development support for PL/SQL Query like Optimization, Stored Procedures, Triggers, Indexes etc.

• Worked with oracle on troubleshooting many RAC related issues.

Organization : Savvis (Century Link)

Role : DBA

Duration : June’12- Nov’14

Environment : Oracle 10g, 11g,12c

Description :

• Provide overall technical support on Oracle and MySQL database.

• Perform routine database checks and changes.

• Work on requests made by customer on the database.

Responsibilities involved:

• Provided 24X7 database administration supports for production and non-prod databases for clients.

• Upgraded 10g to 11g and 11g to 12c

• Performing migration on both Oracle 11g and MySQL Databases.

• Applied various patches to cluster ware as well as Oracle RDBMS software.

• Written and modified shell scripts and setup cron jobs.

• Installed and configured OEM agent software.

• Databases build on different platforms.

• Installed database using scripts and via silent install

• Maintained both logical and physical standby databases using Data Guard

• Performing change in RAC database parameter

• Monitor problem on PL/SQL query resolution and where necessary ensure appropriate escalation.

• Fixing minor and major PL/SQL errors or bugs in the database

• Resolve all incidents according to SLA in remedy, minimizing response time in reacting.

• Upgrade database version from older to the latest version.

• Perform database tuning using AWR report and self-investigation.

• Monitoring to database and server file system space sizes.

• Analyzing the growth of tables and undertaking necessary re-organization of the database when required

• Responsible in PL/SQL code development constructing procedures, packages, triggers and functions

• Responsible for providing application development support for Query Optimization, Stored Procedures, Triggers, Indexes etc. for multiple development applications.

• Worked with oracle on troubleshooting many RAC related issues.

• Housekeeping of database to ensure ample space allocation for storage of data.

• RMAN backup, setup backup jobs, monitor and ensure backup is completed successfully.

• Ensure availability of valid database backups at all times on both Oracle and MySQL databases.

• Creating databases on MySQL database.

• Basic maintenance on MySQL Database.

Organization : T-Systems Malaysia

Role : DBA

Duration : August 11- February 12

Environment : Oracle 10g, 11g

Description :

• Provide overall technical support on Oracle and SQL Server database. Perform routine database checks and changes.

• Operate effectively with minimal supervision and within a clear accountability framework.

• Contribute to the development, enhancement, formalization, and implementation of standard technical service delivery processes globally.

Responsibilities involved:

• Provide DBA specific services to other parts of the organization such as Service Engineering and other Run & Maintain teams.

• Perform basic maintenance on RAC databases, and work of special requests on RAC databases.

• Ensure that any potential problems, such as performance degradation, reliability and security issues are addressed proactively.

• Participate in ad hoc team meetings to discuss issues facing the team and action plans to address these issues.

• Follow formal processes and adhere to the global end-to-end processes (involving Incident Management, Change Management, Problem Management, Situation Management, etc.).

• Monitor problem on PL/SQL query resolution and where necessary ensure appropriate escalation.

• Fixing minor and major PL/SQL errors or bugs in the database

• Analyzing the growth of tables and undertaking necessary re-organization of the database when required.

• Responsible for providing application development support for Query Optimization, PL/SQL Stored Procedures, Triggers, Indexes etc. for multiple development applications.

• Worked with oracle on troubleshooting many RAC related issues.

• Execute allocated database support tasks. Tasks include standard request support, break/fix support, proactive management, trouble-shooting, problem monitoring/resolution etc. relating to backup, monitoring, security management, storage, hardware, PL/SQL, Oracle, and related components

• RMAN backup, setup backup jobs, monitor and ensure backup is completed successfully.

• Perform test recovery using RMAN on development box to ensure the validity of the backup.

• Housekeeping of database to ensure ample space allocation for storage of data.

Organization : Steelcase Office Solution

Role : DBA

Duration : Feb’10- Feb 11

Environment : Oracle 10g, 11g

Description :

• Provide overall technical support on Oracle and SQL Server database. Perform routine database checks and changes.

• Maintain both Oracle and SQL Server databases.

Responsibilities involved:

• Ensure availability of valid database backups at all times

• Ensure that any potential problems i.e. performance degradation, reliability and security issues are addressed pro-actively.

• Resolve all problems within targets as specified in SLA, minimizing response time in reacting to problems and queries.

• Participate in identification and root cause analysis of repetitive problems

• Responsible in PL/SQL code development constructing procedures, packages, triggers and functions

• Fixing minor and major PL/SQL errors or bugs in the database

• Execute allocated database support tasks. Tasks include standard request support, break/fix support, proactive management, trouble-shooting, problem monitoring/resolution etc. relating to backup, monitoring, security management, storage, hardware, PL/SQL, Oracle, and related components

• RMAN backup, setup backup jobs, monitor and ensure backup is completed successfully.

• Perform test recovery using RMAN on development box to ensure the validity of the backup.

• Modifying database storage structure, resizing and adding new tablespaces.

• Housekeeping of database to ensure ample space allocation for storage of data.

• Maintaining backups of SQL Server Database.

• Basic maintenance on SQL Server Database.

Organization : IBM Malaysia

Role : DBA

Duration : Jun 2007 – Jan 2010

Environment : Oracle 9i, 10g

Client : Malaysian Airlines

Description :

• Responsible for overall technical issues relating to database configuration, database setup, health check, physical database designs and database performance tuning.

• Dealing with all Oracle related projects, from sales, architecture, application design and database.

Responsibilities involved:

• Install and maintain the various Oracle database servers.

• Create physical database in development, test and production environments

• Perform configuration and tuning of the DBMS

• Involved in requirement analysis, design and development of new ETL batch scripts

using shell script, oracle PL/SQL and SQL query

• Performing performance PL/SQL tuning on database level.

• Provide technical support during testing and production.

• Perform health checks on Oracle database and ensure conformance to

Company’s requirements

• Setup procedures for database backup and recovery trough RMAN

• Perform day to day activity on database and quarterly updating patches

• Responsible in PL/SQL code development constructing procedures, packages, triggers

and functions

• Fixing minor and major PL/SQL errors or bugs in the database.

• Applying latest critical patch updates on the databases.

• Upgrading database version from 9i to 10g with Grid.

• Setting up disaster recovery database for Data Guard database maintenance.

• Maintaining data warehouse database and data mining.

• Cloning of Oracle 9i to a new environment on AIX platform.

Organization : Long Bridge Consulting

Role : Oracle Consultant

Duration : Sept 2005 – April 2007

Environment : Oracle 9i,

Client : Koperasi Tentera, Perbadanan Putrajaya, MPK, Iris

Description :

• Migrated Application of Group Insurance System

• The project involved Oracle database installation and architecture on different operating

system like Solaris10, HP UX, and other Unix OS.

• Application testing and maintenance at client side.

• The project involved system migration for Koperasi Tentera.

• Developed new forms using Oracle Form builder.

• Implemented system reports, and did testing and bugs fixing.

• Experienced hands on Oracle 9i database.

• Dealing with new Oracle software suggested to client.

Responsibilities involved:

• Design, test and fix bugs of the development of oracle Application systems via Oracle

Forms and report.

• Tuned PL/SQL queries, reports & stored procedures.

• Responsible for production support and mentored developers on issues pertaining

PL/SQL queries

• Basic maintenance of database on Linux and Windows server.

• Perform and design report structure through Oracle report application.

• Perform backup and recovery via RMAN and Export/Import.

• Created new scheme for new structure of tables.

• Upgrading database version from 9i to 10g

• Maintaining data warehouse database and data mining.

• Perform routine technical support on database which includes DB monitoring.

• Suggest any relevant new Oracle product to client for upgrading purpose.

Contact this candidate