Ashish R. Profile

EXPLORE

0.0

(0 reviews)

You're now following

Error following user.

This user does not allow users to follow them.

You are already following this user.

Your membership plan only allows 0 follows. Upgrade here.

Successfully unfollowed

Error unfollowing user.

You have successfully recommended

Error recommending user.

Something went wrong. Please refresh the page and try again.

Email successfully verified.

$10 USD / hour

bangalore,

india

$10 USD / hour

It's currently 10:12 PM here

Joined July 24, 2014

0 Recommendations

Ashish R.

@rnvashish

0.0

(0 reviews)

0.0

$10 USD / hour

bangalore,

india

$10 USD / hour

N/A

Jobs Completed

N/A

On Budget

N/A

On Time

N/A

Repeat Hire Rate

SQL Programmer - Database Administration Administrator - Oracle Programmer

I am ready to work as Database Administration Administrator and I will feel proud to be a part of your team. I have been working for 4.11years with Database Administration and Oracle and consider myself an expert. I have spent a significant part of my career also working as a Oracle Programmer and a SQL Programmer.Stong experience in Performance tuning, If hired by you I will deliver my work to the highest quality. I am ready to be hired by you.

See all SQL Developers in India

Contact Ashish R. about your job

Portfolio

1402333

Oracle DBA with 4.2 years , Expert in Performance tuning

1402333

Oracle DBA with 4.2 years , Expert in Performance tuning

Reviews

Changes saved

No reviews to see here!

Experience

Infosys limited

Apr 2014 - Present

 Tablespace and Datafile management  Backup and Recovery, backup policy configuration- management, Managing Online (Hot) - offline (Cold) backup  Experience in Installation, Configuration, Performance Tuning  Multiplexing Redo log files, External table creation, Quota management, Enqueue Mechanism, managing Snapshot-too old Error.  Restore of databases handling space related issue on tablespace  Real Application Cluster (RAC) installation in oracle 10g and 11g Grid Infrastructure  Migration normal Database to RAC Database, Node Addition-Deletion in RAC environment  Oracle in Linux installation  ASM(Automatic Storage Management), Migration file system to ASM  Transportable Tablespace, Managing Listeners, Services  Manual Database Creation, Database Cloning, RMAN  Configure SMTP Server, Resource management using profile  Re-organizing table online, Expertise in DB Failure Recovery Scenarios, managing undo tablespace  Auditing Database Activities, Flashback Technology like table, database, query, version, drop etc...  Manage Optimizer Statistics, AWR, ADDM, Different Advisory Framework  Oracle plsql programming like procedure, functions, package, cursor, pining package into SGA, Exception handling, Wrapper Utility, Multi table insert, Merge, Index by table, Nested Table, VArray  Install, Configure Oracle Dataguard High Availability Architecture by implementing physical and logical Standby Database  Build and maintain uptime of oracle Databases, manage both productions and test environment  Knowledge of Oracle 11g Grid Infrastructure  Oracle maximum High Availability Architecture (MAA)  Design, Install and configure Oracle Golden Gate  Database management, administration and maintenance, tablespace and Datafile management  Managing listeners, Services, Configuring Catalog Database, managing OMF  Provide accurate and creative solutions to user problems  Provide DBA services with a high degree of customer services, technical expertise and timeliness  Develop stored procedures and objects to implement business logic.  Design and manage database security, roles and profiles  Perform 24*7 project related Database support  Create Database Schema, object and Structures  Oracle Cluster ware installation and configuration  Creating partition table, Resumable tablespace, handling Row-Chaining Row-migration  Resource management using profile, Re-organizing table online  Auditing Database Activities, Listener load-balancing, Flashback Technology  Multiplexing Redo log files, External table creation, Quota management, Enqueue Mechanism, managing Snapshot-too old Error.

Tech Mahindra PVT limited

Apr 2011 - Apr 2014 (3 years)

• Managing data file objects including Tablespace and datafiles, object sizing as well as monitoring database usage and growth. • Managing Tablespace, user profiles, indexes, storage parameters. • Responsible for creating user logons and managing user accounts. • Monitor the instance and plan for future availability of storage on users Tablespace. • Suggesting tuning solutions for SQL queries and Database. • Performance Monitoring the Server’s for Better performance. • Refreshing the test database with the production database. • Adding space to the data files according to Tablespace growth. • Implemented procedures to manage historic optimizer statistics to help diagnose problems with changing execution plans. • Analysis of current optimization model and recommendation to move to cost-based optimization. I was also involved in conducting stress tests to evaluate the success of this approach. • Monitoring and Reorganizing Database objects Tables & Indexes to minimize fragmentation in the database • Performing status checks by monitoring the Alert log, Trace files of the database. • Suggesting tuning solutions for SQL queries and Database. • Rebuilding the indexes and Gather statistics of tables to improve the performance. • PL SQL scripts for test teams which helped in creating test data. • Analysis and redevelopment of the application code to improve performance dramatically and increase resilience. • Produced Oracle SQL and PL/SQL performance-related development standards. • Managing data file objects including Tablespace and data files, object sizing as well as monitoring database usage and growth.

Symphony Software Pvt Limited

Aug 2010 - Feb 2011 (6 months, 1 day)

• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database. • Used SQL LOADER to upload the information into the database. • Used Explain Plan for query optimization and wrote test cases and performed Unit testing. • Analysis and redevelopment of the application code to improve performance dramatically and increase resilience. • Analyze all the business requirements to identify all the NF aspects like Capacity/scalability, availability, usability and security • Understand the requirement capturing, the stories hierarchy, analyzing the requirements in terms of scalability, reliability, security and usability, the acceptance criteria for the requirement. • Used PL/SQL to create Packages, Functions, and Procedure. • Tuning of the SQL queries, which takes long time to process the request using Explain Plan, Hints to reduce the response time

Education

BE in Electronics and Telecommunication

Visvesvaraya Technological University,

India

2006 - 2010

(4 years)

Class XII (PCMIP)

Kendriya Vidyalaya,

India

2004 - 2006

(2 years)

Qualifications

Oracle University

2013

I have certified OCA for oracle 11g.

Publications

Oracle DBA with performance Expertise

Ashish

Have a very strong knowledge in Oracle DBA with exposure to various domain like telecommunication , banking and Auto mobile domains. Expertise in Oracle Performance tuning. Certified OCP by oracle and also attended training by Oracle University for Oracle Performance tuning.