Designed and developed form using Oracle APEX Application and contributed in database design.
Formulated SQL queries, functions and processes as per customization requirement for APEX
Project 2.
Performed user management activities such as user creation, assigning responsibilities to multiple users for Red Prairie application.
Responsible for creating roles and adding privileges to roles in Oracle 10g as per client requirement.
Al
Dubai
11.2017 - 02.2021
Independently install, customize and integrate commercial software packages.
Facilitate root cause analysis of system issues.
Analyse existing SQL queries for performance improvements.
Performed backups using SQL commands.
Objectively assess a company’s IT and/or business processes.
Assess the company’s risks and the efficacy of its risk management efforts.
Identifying shortfalls or gaps in processes.
Carried out internal audit for Oracle Databases.
Using SQL modified data as per the requirement of client.
(Delete, Update, Insert) etc.
Maintain statistics and data for completed Projects for future.
Prepare presentation in PowerPoint & Dashboard as per the requirement of client.
Experience as MIS-Executive in maintaining IT-Dept.
Which deals in Documentation & reporting.
Prepare presentation in PowerPoint & Dashboard as per the requirement of management.
Performed user management activities such as user creation, assigning responsibilities to multiple users.
Working in India and UAE market in the field of IT has enhanced my skills, working capacity and increased my ability to evaluate the opportunities in SQL, PL/SQL and Database.
Experienced with strong background in.
Functional Consultant
Techno
01.2013 - 11.2016
Created and maintained functions, procedures, packages, triggers, cursors, tables, partitioned tables, views, constraints, indexes, synonyms, sequences, analytic functions.
Export/Import of Tables, schemas, full databases.
Solved L2 issues which impacts the business and production.
Working on daily issues faced by the end user, along with system generated issues.
Worked on creating tables, partitioned tables, views, constraints, indexes, synonyms and sequences.
Working experience of Unix commands like ls, cat, grep , cp, rm, mv, hostname,pwd ,crontab ,tail more etc.
Maintenance of database objects, monitor and killing the blocked session using TOAD.
Pune ( Associate DBA )
KPIT Technologies
08.2012 - 12.2013
Experience in spfile,pfile,granting roles and quotas, log files and alert log files,AWR reports.
Performed backups using data pump and RMAN.
Performed Oracle Database installation for test databases.
Performed regular DBA activities such as Managing Database, Storage, System Security Profiles, monitoring table space size as per requirement.
Adding data files, resizing data files to database as per requirement.
Creation of users and assigning roles, privileges and profiles to users.
Performing Logical backups using Data pump.
Experience of creating database using DBCA utility.
Starting and shutting down instance as per requirement.
Performing regular DBA activities such as monitoring table space size as per requirement.
Take corrective actions to resolve table space issues.
Education
Bachelor of Computer Application -
University of Pune
Additional Information
Team Work
, Responsibility
Analytical
Dedicated
Adaptable
Detail Oriented
Awarded as “Award of Excellence”
Achievements