ASHISH DOSHI

adbwcy@r.postjobfree.com

SR ORACLE SQL DEVELOPER

+1-914-***-****

SUMMARY

Database Architecture, Design and Maintenance, including Database Creation, Schema Development, Database Migration, Database Tuning, Stored Procedures and Triggers

Expertise in Oracle Golden Gate Administration

Experienced Program Manager managing onsite and offshore development teams and managing projects using Agile Methodology and managing efficiency by using ‘follow the sun’ methodology.

Quick learner with excellent communication skills and an ability to understand new business logic.

TECHNICAL EXPERTISE

Strong skills: Perl, PL/SQL, SQL, Oracle Golden Gate

Languages: Perl, Shell script, PHP

Operating Systems: Linux, Windows 7

Tools and Utilities: TOAD, SQL Developer, JIRA, Microsoft Excel

Databases: Oracle DB, MySQL

Enterprise Database Tools: OEM/EM Grid Control (Enterprise Manager), Toad & Quest Central Suite of Products

Application Servers: Apache/Tomcat

PROFESSIONAL EXPERIENCE

IRIS Software, INC

Client -- Citibank, Irving, TX 09/2019 – Present

Software Engineer – Oracle PL/SQL Developer

Involved in writing PL/SQL, Packages, Functions, Stored Procedure

Assisting development team with database in non-production environments

Provide customer production and developer support

Regular maintenance of database including creating databases, tables, tablespaces, data objects, privileges, indexes

Creating Partitioned tables using Range, hash, list partitioning to improve performance and manageability.

Creating database object like tables, indexes, views, synonyms, sequences.

Developed PL\SQL stored procedure, package, triggers

Provide systems integration and architecture oversight to find and close the gaps between various projects in term of common system development processes, configuration management, release management, and the application of IT best practices in the domain of Data Architecture, Data Quality.

Coordinated with IT Infrastructure, Development team and support contracts

Environments: Oracle 11g R2, SQL Developer, Oracle Clients

Tech Mahindra Americas INC

Client -- AT&T, New York, NY 09/2016 – 09/2019

Senior Developer/Architect – Oracle Golden Gate, Perl, Shell Script, SQL

Involved in writing many Unix and SQL scripts and processes to quickly resolve issues in any Oracle database instance.

Working closely with Database Administrators, Database Team, Applications Team, IT Architect and other DBA’s to monitor and troubleshoot the production issues and facilitate business improvements.

Work simultaneously with other departments and/or outside contractors to resolve system production problems. Also involved in working with Storage Architects and relevant team.

Perform other duties as assigned.

Develop high level DB Performance Reports with Recommendations for future DB Capacity Planning works. Worked on all document process, related to all regular DBA activities.

Assisting development groups with database administration in non-production environments

Writing Shell Scripts on various UNIX, AIX and Linux Servers for automation of day to day database jobs like DB health monitoring, DB Stats on Index, Size and Partitions.

Management of User Policies, Roles and Profiles for production Databases.

Alert log monitoring of Oracle Database.

Managing Users: creating users, synonyms, privileges, roles, quotas

Managing table spaces, objects, profiles, storage parameters.

Regular maintenance of database including creating databases, tables, tablespaces, data objects, privileges, indexes, Roles, Authentication.

Data Modeling, Database Design and Creation

Created Partitioned tables using Range, hash, list partitioning to improve performance and manageability

Worked closely with Development DBA teams on trouble-shooting SQL issues impacting database performance and uptime

Work on TDP and incident tickets and update / resolve the tickets within the SLA

Responded to production support calls. The environments of AT&T oracle database are as follows:

Environments: Oracle 11g R2, Oracle Golden Gate, Redhat Linux, Toad, SQL Developer, Oracle Clients/Servers.

Client -- AT&T, White Plains, NY 07/2009 – 09/2016

Senior Developer -- Oracle DBA and Golden Gate Admin support role

Involved in writing many Unix and SQL scripts

Involved in writing Perl scripts, PL/SQL, Stored Procedure and Shell scripts for Data Migration.

Assisting development team with database in non-production environments

Provide customer production and developer support

Managing Users: creating users, synonyms, privileges, roles, quotas

Regular maintenance of database including creating databases, tables, tablespaces, data objects, privileges, indexes

Created Partitioned tables using Range, hash, list partitioning to improve performance and manageability.

Created database object like tables, indexes, views, synonyms, sequences.

Developed PL\SQL stored procedure, package, triggers, cursors, and views

Provide systems integration and architecture oversight to find and close the gaps between various projects in term of common system development processes, configuration management, release management, and the application of IT best practices in the domain of Data Architecture, Data Quality.

Coordinated with IT Infrastructure, Development team and support contracts

Environments: Oracle 11g R2, Oracle Golden Gate, Redhat Linux 6, Toad, SQL Developer, Oracle Clients/Servers.

Tech Mahindra Ltd Pune

Client -- AT&T, USA 03/2006 – 07/2009

Sr. Technical Associate – Perl, Perl-CGI, Shell script, Oracle

Analyze user needs and software requirements to determine feasibility of design within time and cost constraints

Design, develop and modify software systems, using scientific analysis and mathematical models to predict and measure outcome and consequences of design.

Store, retrieve, and manipulate data for analysis of system capabilities and requirements

Develop and direct software system testing and validation procedures, programming, and documentation

Modify existing software to correct errors, allow it to adapt to new hardware, or to improve its performance

Responsible for status reporting, client communication & coordinating with the project management team for timely completion and quality maintenance of projects

Environments: Perl. Perl-CGI, Shell Script, HTML, Oracle 10/11g R2, Oracle Golden Gate, Redhat Linux 6, Toad, SQL Developer, Oracle Clients/Servers, Apache Webserver.

Cybage Software Pvt Ltd Pune 02/2004 – 03/2006

Client - Athena Health USA

Sr Software Engineer

Direct software programming and development of documentation.

Store, retrieve, and manipulate data for analysis of system capabilities and requirements.

Develop and direct software system testing and validation procedures.

Modify existing software to correct errors, allow it to adapt to new hardware, or to improve its performance.

Correct errors by making appropriate changes and rechecking the program to ensure that the desired results are produced.

Conduct trial runs of programs and software applications to be sure they will produce the desired information and that the instructions are correct.

Environments: Perl. Perl-CGI, Shell Script, HTML, Oracle 9i, Redhat Linux, Toad, SQL Developer, Oracle Clients/Servers, Apache Webserver.

Uffizio India Software Pvt Ltd Mumbai 01/2003 – 02/2004

Senior Software Engineer

Consult with managerial, engineering, and technical personnel to clarify program intent, identify problems, and suggest changes.

Write, update, and maintain computer programs or software packages to handle specific jobs such as tracking inventory, storing or retrieving data, or controlling other equipment.

Compile and write documentation of program development and subsequent revisions, inserting comments in the coded instructions so others can understand the program.

Correct errors by making appropriate changes and rechecking the program to ensure that the desired results are produced.

Perform systems analysis and programming tasks to maintain and control the use of computer systems software as a systems programmer.

Conduct trial runs of programs and software applications to be sure they will produce the desired information and that the instructions are correct.

Write, analyze, review, and rewrite programs, using workflow chart and diagram, and applying knowledge of computer capabilities, subject matter, and symbolic logic.

Train subordinates in programming and program coding.

Prepare detailed workflow charts and diagrams that describe input, output, and logical operation, and convert them into a series of instructions coded in a computer language.

Environments: PHP, MySQL, Shell Script, HTML, Linux, Apache Webserver.

Prangya Technologies Pvt Ltd Mumbai 06/2000 – 01/2003

Software Engineer – PHP, Perl, MySQL, Linux

Write, analyze, review, and rewrite programs, using workflow chart and diagram, and applying knowledge of computer capabilities, subject matter, and symbolic logic.

Prepare detailed workflow charts and diagrams that describe input, output, and logical operation, and convert them into a series of instructions coded in a computer language.

Consult with managerial, engineering, and technical personnel to clarify program intent, identify problems, and suggest changes.

Compile and write documentation of program development and subsequent revisions, inserting comments in the coded instructions so others can understand the program.

Correct errors by making appropriate changes and rechecking the program to ensure that the desired results are produced.

Write, update, and maintain computer programs or software packages to handle specific jobs such as tracking inventory, storing or retrieving data, or controlling other equipment.

Environments: PHP, Perl. Shell Script, Python, HTML, MySQL, Linux, Postgres SQL, Apache Webserver.

EDUCATION:

Bachelor of Computer Science, May 2000

Pune Institute of Computer Technology, University of Pune

Area – Computer Science

Diploma in Computer Technology

Bombay Technical Board, 1996

Diploma in Industrial Technology

Bombay Technical Board, 1994

CERTIFICATIONS/TRAINING

Scrum Fundamentals

Agile Implementation

Oracle SQL 9i

Contact this candidate