PRAMILA MORE

Oracle ADBA /PLSQL Developer

Techmahindra Pvt. Ltd.

Bangalore

11.2011 - Current

Performing Offshore Lead role [Oracle ADBA manager] for pre-production/production support Applications of AT&T.
Involved in 24x7 support for Production database and applications.
Monitoring & Trouble shooting job failures for ETL Jobs on three data centers and monitoring.
Worked on shell scripting for automating few scripts and on utilities like Toad, Informatica, AOTS.
Identified and produced documentation of best practices.
Data transferring with export/import utilities.
Worked on Major releases & Change Request Deployments.
Monitoring & Trouble shooting GG process & Log dump utility.
Worked with different API teams for investigating & resolving data issues
Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
Involved in the continuous enhancements and fixing of production problems. Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances
Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files. Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
Worked on performance issues like Gather stats Alerts, invalid packages, scheduler Jobs, issues
Modified existing software systems to enhance performance and add new features.
Prioritized and organized tasks to efficiently accomplish service goals.
Exceeded customer satisfaction by finding creative solutions to problems.
Identified needs of customers promptly and efficiently.
Completed day-to-day duties accurately and efficiently.
Approached customers and engaged in conversation through use of effective interpersonal and people skills.
Planned and completed group projects, working smoothly with others.
Recognized by management for providing exceptional customer service.
Maintained open communication with team members and stakeholders, resulting in successful project outcomes.
Automated daily DBA tasks using shell scripting and cron jobs.
Managed user accounts, roles and privileges in the database environment.
Monitored database performance and tuned SQL statements for optimal performance.
Provided technical support during project implementations by troubleshooting complex production issues .
Created PL and SQL procedures and functions for automating day-to-day operations of the organization's systems.
Worked closely with Application teams in identifying and fixing application related issues due to inefficient SQL queries .
Developed scripts for automation of various DBA activities like adding disk space, reorganizing table spaces, index maintenance .
Worked with development team for query tuning for optimization and Application performance.
Migrated databases from one platform to another using tools like export and import, datapump.
Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines. Created PL/SQL scripts to extract the data from the operational database into simple flat text files using package.
Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
Performed trouble shooting of any issues related to Oracle Database server or applications accessing it.
Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.Created indexes on the tables for faster retrieval of the data to enhance database performance.

Summary

Overview

Work History

Oracle ADBA /PLSQL Developer

Senior Engineer

Education

MCA -

BSc -

Skills

Certification

Tools Utilities

Awards

Timeline

Oracle ADBA /PLSQL Developer

Senior Engineer

MCA -

BSc -

Similar Profiles

Vaishnavi ChoudharyVaishnavi Choudhary

Amya MishraAmya Mishra

TARUN RAITARUN RAI