We provide IT Staff Augmentation Services!

Senior Oracle Pl/sql Developer/technical Architect Resume

SUMMARY

  • With an IT experience of 13 years working in all the phases of software development life cycle including requirements gathering, analysis, design and development, implementation, deployment and support.
  • Extremely well versed in Oracle, PL/SQL, Database Modeling, Python & Shell scripting and C on Linux and Unix platforms
  • Working experience in Products in the Banking domain and the service industries in Tours/Travel.
  • Extensively worked on client - server application development using Oracle 12c/11g/10g/ 9.x, 8.x, 7.x, Advance PL/SQL
  • Proficiency in PL/SQL programming in developing advanced Object-Relational Database using Advance PL/SQL Concepts like Collections, Objects, Packages, Stored Procedure, triggers.
  • Make use of Oracle Wallet to secure the Database Credentials in batches written using SQL*PLUS and SQL*LOADER utilities.
  • Practical understanding of the Data modeling (Dimensional & Relational) using ER Diagrams, Performance tuning of Long-running Queries to improve the response time.
  • Created Shell Scripts for invoking SQL scripts and scheduled them using CRON utility in Linux and Unix.
  • Experience in Data Migration using SQL*Loader, Table Partitioning, Performance tuning.
  • Worked basic DBA Activities ( User Create / Grant / Security / Synonym / Table Backup / Table Restore).
  • Working experience in automation of many business-critical applications using shell scripting on Linux and Unix platforms to reduce the manual interventions and probability of errors.
  • Excellent communication and presentation skills, self-motivated, highly committed to responsibilities to work with mid-size teams, technical and business leadership and skills to maintain an outstanding Stakeholder relationship.
  • Comprehensive experience in providing solutions with strong debugging and troubleshooting skills.
  • Excellent leadership skills, good initiator, proactive, keen to learn new things and excellent team player with strong interpersonal and group communication skills making the high team spirit.
  • Demonstrated ability to multi-task and accomplish and deliver multiple projects in a cross-functional environment.

TECHNICAL SKILLS

Operating Systems: Windows 7, UNIX (Solaris/HP/IBM), Linux

Languages: PL/SQL, C-C++, SQL, Basic Java

Scripting Languages: Shell Scripting, Python

Databases: Oracle 10g/11g/12c

Tools: Toad, SQL Developer, SQL*Plus, SQL*Loader, PuTTY, WinSCP

PROFESSIONAL EXPERIENCE

Senior Oracle PL/SQL Developer/Technical Architect

Confidential

Responsibilities:

  • Enhance and Automate Fleet Applications and corresponding batches using Advance PL/SQL and Shell Scripts using Oracle Table Partitioning, Purging.
  • Make Use of standard packages like UTL FILE, DBMS and PL/SQL Collections, used BULK Binding involved
  • Automate the jobs using Packages, procedure, collection and objects using shell scripting on Linux/Solaris Unix Platforms.
  • Make use of Materialized View, Index, Global Temporary Table, Dynamic SQL, Partitioned Table to implement the business requirement.
  • Make use of Oracle Wallet to secure the Database password and easy maintenance of Oracle DB credentials
  • Brainstorming the requirements with Clients, analyzing them and providing appropriate design and solution.
  • Brainstorming with the Web app teams and providing appropriate database interface and support them.
  • Mentoring/Managing the onshore and offshore team.

­­­­­­­

Data Architect/ Senior PL/SQL Developer

Confidential

Responsibilities:

  • Performed the Data modeling and design of the entire Confidential car rental business starting from Fleet Procurement, Fleet Maintenance, Rental Business and Fleet Disposal and Finances of business.
  • Implementing the major business logic in Advance PL/SQL and handling all DBA activities including data migrations and Database management.
  • Make various Services using Advance Collections, Oracle Object, Record, Package and Procedure.
  • Perform Data Migration using SQL*Loader, SQL*PLUS.
  • Helping other teams in the Performance Tuning of Oracle Database operations for a better response time of critical business activities.

­­­­­­­­­

Senior PL/SQL Developer

Confidential

Responsibilities:

  • Performed the Data modeling and design of the most ambitious project of ABG Implementing the major business logic in Advance PL/SQL and handling all DBA activities including data migrations and database management.
  • Designed the most complex aspect of Multi-parenting int ARP System and performing the entire Computation of Rebate System.
  • Helping other teams in the Performance Tuning of Oracle Database operations for the better response time of critical business activities.
  • Implementing the major business logic in PL/SQL and handling all DBA activities including data migrations and Database management.
  • Mentoring and grooming juniors.

­­

Oracle PL/SQL Developer

Confidential

Responsibilities:

  • Design the Approach for Modularization ensuring no impact on the existing working system.
  • Develop various tools for data collection, parsing the existing Codebase and analysis in a shell script, PL/SQL Function and Stored Procedure, Collection and Oracle Objects.
  • Modularization of Confidential tables, C libraries of various modules like Current-Saving, Loan, Wealth Management, Transaction management and controlling cross-module table access from codes independently.

Hire Now