Technical Support Manager

Amanpreet Kaur Email: ********@*****.***

Phone: 905-***-****

PROFESSIONAL SUMMARY

* ***** ** ****** *** experience with a total experience of 8 years in fast paced IT environment.

Possess technical and analytical skills.

An accomplished IT professional with an in-depth experience as an oracle database administrator having working in a broad range of functional domains

Implemented oracle database (11g) grid Control on multi production environment to monitor, Administer and maintain multiple databases and applications through single console.

Formulated the backup & recovery strategies (RMAN/Data Protector/TSM) for Databases and Applications.

Self-motivated with a pro-active attitude towards work, good communication and relationship building skills.

Energetic and organized with excellent problem-solving, decision-making and leadership qualities coupled with the ability to be a team player.

Strong knowledge of System Development Life Cycle (SDLC) processes including analysis, design, testing, implementation and maintenance of DBA-related requirements.

Positively coordinated and participated in database performance and stress test and made

recommendations crucial for design or coding changes

Successfully implemented and reported top matrix data on Incidents, RCAs/RFCs, security,

policies and procedures related to all aspects of work.

Experience in writing complex SQL queries involving multiple tables inner and outer joins.

Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.

Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other SQL statements for various applications.

Excellent development experience in creating stored procedures, PL/SQL packages, triggers, functions, cursor management and exception handling.

Expertise in performance tuning of SQL and ETL code and writing efficient and

complex queries on huge volumes of data.

TECHNICAL SKILL SET

Oracle Databases RDBMS : Oracle12c, Oracle 11g, 10g and 9i

Other Databases : MS Access, MS SQL Server, MySQL

Tools : Remedy, Win SCP, OEM, TOAD, MS Visio/Office,

RMAN and Flashback Recovery, SQL Developer,

EXP, IMP, Data Pump, SQL Plus, AWR, ADDM,

ASH, OEM, Dataguard,Golden Gate, RAC, ASM,Exadata and Putty.

Scripting Languages : VB, SQL and PL/SQL

Platforms : Windows, MS DOS, Linux and Sun Solaris.

PROFESSIONAL EXPERIENCE

Client – Zimmer Dec 2013- Oct 2015

Oracle DBA

Proficient in Oracle 10g and 11g Database Administration, Enterprise Manager, RMAN, Backup, Recovery, Database Migration, Upgrade, Patch Application, Performance Tuning, Real Application Clusters, Data Guard Administration,Golden Gate in UNIX environments.

Scheduled, installed, configured, managed and troubleshot Oracle 10g, 11g databases on Linux and Windows OS.

Created, tested and developed databases following OFA compliance rules.

Experienced in creating databases, table spaces, tables, indexes and their database objects.

Implemented various table partitions for large tables, multiplexing control files and re-do log files.

Administered database user accounts; created, modified, deactivated user accounts; assigned and monitored access rights.

Managed Undo Tablespaces, Schema Objects, re-do Logs, Control files and Archive logs.

Installed, configured and managed 11gR2 (RAC) and ASM storage, as well as managed Oracle databases using database control or Oracle Enterprise Manager.

Generated AWR/ASH/ADDM reports.

2years working on Golden Gate technology.

Analyzed and monitored tables, indexes based on performance, tablespaces and data file utilization regularly.

Consistently monitored alert log files, trace files, user sessions daily, and took appropriate actions to kill inactive sessions and make systems manipulations based on logs.

Understanding about Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression, Flash Cache, etc.

Provide and implement performance tuning recommendations of all components in Exadata database machine.

Advise, provide guidance and develop Disaster Recovery strategies for the Exadata Database machine.

Solid skills to configure Exadata to meet company internal security requirement.

Performed bulk load of data using SQL Loader, and conducted standard and fine grain database auditing.

Configured, troubleshot and resolved various Oracle network components and

connectivity problems, to ensure database access, consistency and integrity.

Provided network troubleshooting, administrative support for the development staff, database administration on production, testing and development of database servers.

Resolved various complex issues within the database; for example; corrupted data files, tns and listener connection issues, control file and spfile problems.

Identified and removed fragmentation, row migration/chaining of database objects.

Configured various RMAN parameters as per required, implemented the use of Oracle Recovery Manager (RMAN) for cold and hot backup to all databases; performed physical backups and database cloning using RMAN utility.

Extensively used DATAPUMP and Export/Import utilities for logical backups.

Identified and recovered corrupted database blocks using Block recover option in RMAN utility.

Created and managed documentation on configuration and support of Oracle databases, database structure, changes, problems and issues for future reference and analysis.

Used explain plan, AWR, ADDM and various Oracle Advisors to tune the database.

Upgraded Oracle 10g database to 11g and Oracle 11g databases from 11.2.0.1 to 11.2.0.3 using patch set.

Managed RAC databases using CRSCTL, SRVCTL and grid control.

Client – Jaguar and Landrover(JLR) Dec 2011- Nov 2013

Oracle DBA

Provided support on various Production (DB/APP) environments.

Proactive monitoring of all environments and deploying alert mechanism for incidents.

Worked closely with developers to extend support on all development activities.

Resolved performance tuning related issues, reports, analysis and queries through OEM and command line interface.

Work actively on features such as AWR, ADDM, and ASH, Flashback, performance statistics collection, and fine tuning database wait events.

Installed, configured and troubleshooted Oracle Database.

Set up new databases and provided all database-related support for the production and test databases.

Implement Database Cloning and Data Guard.

Responsible for writing PL/SQL Scripts.

Coordination with onsite engineer, client & vendor to document understanding of the system.

Cloning and Patching of application and databases for bug fixing and resolution of concurrency issues.

Tuning the application/database to achieve the required throughput. Used tools like OEM for Database and SQL (Application) tuning.

l Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects. Assisted in integration of Exadata applications into current IT actionable events and solutions.

l Integration of Exadata monitoring into our existing IT monitoring framework. Provide and implement performance and tuning recommendations of all components in the Exadata machines.

Manage flashback utility.

Set up Recovery Catalogue, Perform Backup and recovery using RMAN.

Greatly improved performance in daily transforms by identifying and reorganizing database objects.

Used Explain Plan and Oracle optimizer hints to enhance performance of SQL statements.

Perform the user requirements and troubleshooting activities and resolved connectivity issues.

Implemented, administered, and maintained daily backup and archived data on both disk and tape with RMAN, Diagnose RMAN Bugs.

Hands on experience on ASM.

Configured, managed and administer RAC (Real Application Cluster) environment

Extensively used DATAPUMP and Export/Import utilities for logical backups.

Client – DOWJONES August 2008 – Dec 2011

Oracle DBA

The client is having about 400 databases (Production, Development, and UAT) on different versions ranging from Oracle 9i to Oracle 11g on Sun Solaris 9 and linux. All these databases are mission critical and support 24 x7 operations.

Responsibilities:

Provided Database upgrades.

Agent installation and managed databases via grid control.

Configured Grid Control Monitoring.

Provided online remote support for different databases like (production database, quality database, Test Database).

Took logical backup through export/Import and datapump.

Managed Undo Tablespace.

Performed database re-organizations as required to assist performance and ensure maximum uptime of the database.

Put standards in place to ensure that all application design and code is produced with proper integrity, security and performance. Reviewed the design and code frequently to ensure the site standards are being adhered to.

Worked on Remedy ticketing tool to handle online queries of developers / users and resolving them remotely and providing them solutions.

Refreshed schemas and Tables using exp/imp and expdp/impdp.

Performed scheduled Change Requests (CRs).

Performed upgrades / testing on non-production environment before implementing on Production servers.

Verified and executed SQL scripts in production/non production environments provided by users.

Generated AWR/ASH/ADDM reports.

Monitored databases through Grid Control.

Performed performance analysis and tuning.

Involved in coordinating with application team and centralized operation team for implementing change requests.

Provided technical support to application development teams.

Enforced and maintain database constraints to ensure integrity of the database.

Administered all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.

Assisted with impact analysis of any changes made to the database objects.

Troubleshoot problems regarding the databases, applications and development tools.

Created new database users as required.

Space management including daily monitoring of UNIX filesystem, utilization related to database tablespaces and other oracle owned filesystems.

Managed database roles/privileges and application responsibilities.

Involved in Firing Queries against database.

Client – AOL July 2007 – May 2008

Designation – Technical Support Associate

Responsibilities:

Worked with WIPRO as Technical Support Executive for UK based project (AOL-America Online) where I used to deal with network related hardware issues which involved configuring different routers and modems and desktop troubleshooting.

Surpassing the Productivity targets with excellent quality with onus on customer satisfaction.

Worked for various projects on floor. (Reducing Average handling time, Controlling Repeated dispatch hits, One-time resolution and Superior Customer Experience)

Provided remote assistance to customer’s system in order to resolve hardware related issues.

Ensured quality support to all customers within set policies and support boundaries.

TRAININGS/CERTIFICATIONS

Oracle 10g ASSOCIATE

Oracle 10g PROFESSIONAL

I.T.I.L Foundation

Certification in Web Designing.

EDUCATION

Bachelors in Technology (2003-2007), Punjab Technical University Computer Science.

Contact this candidate