PL/SQL Lead Developer Resume

SUMMARY

9 years of experience with Development, Maintenance and Implementation of IT Applications.
Out of which seven years of Solid experience in Investment Banking Domain.
Highly organized and efficient in fast - paced multitasking environments; Strong ability in prioritizing effectively to accomplish objectives with commitment and enthusiasm.
Extensive work experience with RDBMS and Databases like Oracle
Strong Experience in Development, Maintenance and support phases
Advanced knowledge in Exception handling/Debugging through Putty VI Editor & SQL Scripts
Highly proficient in writing Database related scripts like SQL, PL/SQL Scripts which include Stored Procedures, Functions, Triggers, Packages, Indexes
Exceptional skills in Automating repetitive tasks using UNIX Bash Shell Scripting, Python, AutoSys, Job Scheduler in given LINUX environment
Robust Experience in High level programming like Python
Solid Experience in Investment Banking, Telecom and Government Sector Domains
Profound in performance tuning of database SQL Scripts
Impressive Track record of consistently delivering projects and taking complete accountability for work and results in Agile Methodologies
Efficiently collaborated with customers, business analysts, partners, and IT team members to understand business requirements that drive the analysis and design of quality technical solutions.
Excellent ability on providing innovative solutions to business needs.
Strong judgment and decision-making abilities
Ability to articulate and translate technical language to non-technical customers. Influenced at all levels across the company within span of control.

TECHNICAL SKILLS

Operating Systems: Windows Server, UNIX, LINUX, Solaris, Mainframes

Data bases: Oracle 12c/11g, DB2, Sybase

Programming languages: SQL, PL/SQL, UNIX, Python, AutoSys job Scheduler, XML

IDE Tools: Toad, SQL Developer, SQL *Plus, Sublime Text

Others: ArcGIS, Clarity, Axiom, Informatica, Business Objects, IBM MQ, Splunk

PROFESSIONAL EXPERIENCE

Confidential

PL/SQL Lead Developer

Responsibilities:

Extensive Experience in writing Oracle PL/SQL & SQL DB queries and optimizing them.
Strong Focus on development of stored procedures, functions and SQL scripts for multiple Applications in the project
Deep involvement in analysis, design, coding, testing, debugging and documentation.
Ad-hoc data query for various analyses.
Defined and implemented industry standard coding practices during the development phase
Extensively utilised Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements
Flexible in providing workday and after-hours production support for applications.
Created and Maintained AutoSys job schedules
Automating repeated tasks using Python and UNIX Bash Scripting
Juggle an array of tasks while demonstrating strong organization skills
Continually work towards making improvements in the release process

Technical Environment: Oracle 10g, PL/SQL, SQL, Python, UNIX, AutoSys Job Scheduler, VI Editor, Sybase, Toad, Jenkins, SVN, GitHub

Confidential

PL/SQL Lead Developer

Responsibilities:

In Depth involvement in creation of SQL Scripts for Database Objects like Sequences, Views and Indexes.
Involved in database development by creating PL/SQL functions, procedures, packages.
Created and mapped business needs/application requirements to technical solutions
Coordinated with DBAs for tasks such as creating/rebuilding indexes, adding partitions, and analysing tables
Extensively worked in Agile Methodologies for the Development
Automated Repetitive Tasks in Linux Bash Scripting
Developed AutoSys Jobs in the project

Technical Environment: Oracle 10g, PL/SQL, SQL, UNIX, VI Editor, Tortoise SVN Tool, Toad 9.0.1 Tool

Confidential

Sr. PL/SQL Developer

Responsibilities:

Generating SQL Scripts for Database Objects like Sequences, Views and Indexes.
Working in Clarity Tool to interact with the Database
Developed Database Triggers
Working in Unix Environment to interact with the Physical Telephone Switches.
Working on Oracle Database to ensure the proper re-connection and Disconnection of Telephone Numbers.
Highly proficient in diagnosing performance issues across application tiers

Technical Environment: Oracle 11g/9i, PL/SQL, SQL, PL/SQL Developer, Clarity Tool, UNIX, VI Editor

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship