Customer Service Assistant
Resume:
Ashwini T.C.
ac0a1j@r.postjobfree.com 858-***-****
Professional Summary
8+ years of IT experience as an Oracle DBA on Linux, AIX and Windows platforms
Experience includes Installation, Configuration, Upgradation, Space Management, Cloning, Patching, Data Replication, Database Security, Troubleshooting, Performance Monitoring, Tuning, Backup and Recovery, RAC, ASM and Data Pump.
Upgraded databases from 10g to 11g on various platforms.
Managed databases in the range from 50GB to 1TB.
Proficient in administration activities such as User management, Space management, creating and monitoring databases.
Performance tuning of the database using oracle 11g tools like AWR, ADDM, ASH, SQL TRACE, EXPLAIN PLAN and SQL advisor.
Experience in taking full and partial backups, incremental and cumulative backups using RMAN
Database refresh, cloning of production databases for QA from RMAN backups and using database duplicate.
Extensively involved in database cloning manually as well as using RMAN
Experience in performing point in time recovery of table spaces at times of necessity.
Installation, configuration and maintenance of Oracle 11gR2 RAC with two nodes
Experience in migration of Oracle Databases from non-RAC to RAC and non-ASM to ASM Instances.
Implementation of Flashback technology.
Experience in applying PSU patches to Oracle 11g databases.
Strong skills in SQL*Plus, SQL*Loader and UNIX Shell scripts (KSH)
Involved in development of scripts to automate backup and recovery procedures for development databases.
Experience in installing, configuring, tuning and troubleshooting of IBM WebSphere Application Server 7.x, 8.x, WebSphere process server 7.x, BPM 8.x, IBM HTTP Server, WebSphere MQ
Good hands on experience on administration of IBM HTTP server
Excellent troubleshooting skills in OS level and Database level issues.
Experience in using JIRA and confluence tools.
Worked with development and operations staff in resolving problems quickly and efficiently
Ability to work with utmost dedication, juggle multiple projects,use own initiative and motivation to meet deadlines and set priorities without close supervision
Attend business and customer issues in timely manner and maintain high customer satisfaction.
Work Experience
Organization: Misys software solutions
Client: Belize Bank
Project: Fusion Banking Essence 4.0, 4.2
Duration: Mar 2014 to May 2016
Roles and Responsibilities:
Supported 100+ databases including RAC production database and a lot of Development and Test databases and upgraded from 10g to 11g
Provided Production & Test environment support while coordinating with Unix Team and storage team to configure the OS infrastructure for Oracle Databases
Worked on installation and configuration of release 11g R2 RAC with ASM and Raw Devices and 11g CRS on IBM AIX 6.1
Installed and configured 4 node oracle 11gR2 RAC for production environment.
Responsible for upgrading Oracle 10g RAC to 11g RAC.
Implemented Data Pump, Export and Import on day to day basis as per development and test servers
Responsible for Performance Monitoring and analysis of 11gRAC (Real Application Clusters) with AWR (Automatic Workload Repository) reports and ASH (Active Session History).
Identified index fragmentation and rebuild the indexes.
Troubleshooting the RAC related issues (Node eviction).
Addition of third node to existing two node RAC clusters.
Monitoring the health of RAC databases by checking the logs and OSWTAHCER and RAC check tool.
Export & Import of tables, tablespaces, schemas and full database by using Data pump Export & Import Utility.
Handled Physical and Logical Corruptions and recovery using RMAN (Recovery Advisor).
Wrote shell scripts for automation of tasks and used shell scripts with crontab for job scheduling.
Troubleshooting Space Management & User accounts and privilege issues while coordinating with UNIX and Application teams.
Performed proactive database maintenance procedures to ensure optimal performance and uptime and implemented shell scripts for automation of day to day activities.
Identify Top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and interact with the development team to see if these queries can be fine-tuned further.
Regular Security Patching and Critical patch Updates (CPU) and Patch set updates (PSU) on Oracle databases and interim patches for various bug fixes on database products.
Actively involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering Statistics
Managing Users, Roles, privileges, profiles, schemas, SQL Monitoring, SQL Advisor, SQL tuning and Metrics
Organization: Misys software solutions
Client: National Bank of Ceylon, Awash, Scotia
Project: BankFusion and Universal Banking
Duration: July 2010 to Feb 2014
Roles and Responsibilities:
Installation and creation of 10g, 11g Databases for Development, Quality and production environments and upgraded from 10g to 11g.
Implemented Upgradation and Migration of Database's from 10.2.0.5 to 11.2.0.1 and applying patches whenever required.
Installed Oracle Cluster ware to provide infrastructure for RAC and configured 2 node Oracle 11gR2 RAC with ASM.
ASM Setup and maintenance on RAC databases.
Used RMAN for backup and recovery.
Responsible for regular Security Patching on Oracle Products and interim patches for various bug fixes on database products.
Migration of Oracle Databases from non-RAC to RAC and non-ASM to ASM Instances.
Monitor and tune database performance including SQL tuning.
Work with development and operations staff in resolving problems quickly and efficiently.
Clear communication and documentation of technical specifications.
Performing all daily Maintenance tasks including scheduling backup jobs, monitoring job failures and troubleshooting RMAN backup job failures and interacting with Oracle Customer service
Managing Tablespaces, Data files, Rollback segments, Temporary TBS.
Organization: Accropetal Technologies
Clients: Co-operative Bank of Kenya
Project: BankFusion
Role: Graduate Trainee
Duration: Sep 2008 to June 2010
Roles and Responsibilities:
Responsible to both manage and support 15 development/test databases with sizes of databases varying from 50 GB to 500GB.
Installed and Upgraded 10g to 11g.
Perform daily administration support for database backups, performance tuning and monitoring.
Monitored and diagnosed database performance through monitoring of alert files, trace files.
Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
Worked on Data pump to take the logical backups of databases.
Worked on performing Point in time recovery using RMAN.
Used oracle configuration assistants like DBCA (Database Configuration Assistant) for Creating databases, DBUA (Database Upgrade Assistant) for Upgrading databases and NETCA (Network Configuration Assistant) for creating a Client-Server environment using Listener, TNS names etc.
Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary. Online/Offline Database Backups and managing database recovery with RMAN.
Performance tuning via OEM, STATSPACK/AWR for 10g/11g.
Maintenance tasks like bouncing the production database, services through Veritas.
Installed IBM db2 database on AIX servers
Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
Certifications:
ITIL certified
Trained on AIX
Honors and Awards:
Spot award for resolving performance issues in Party Onboarding Reporting module in May 2015
Team award for automating Digital Channel software installation in May 2014
Best performer award in July 2012 for setting up pre-prod 2 node RAC database environment to certify performance of Misys banking product in IBM labs, Paddington, UK
Role model of the team award for outstanding performance in 2010
Work Status: Authorized to work in US for any employer (EAD)
Thanks,
Ashwini T.C.
Contact this candidate