Oracle PL/SQL Lead and Application DBA Resume

SUMMARY:

Seeking challenging assignments for a career encompassing professional & personal advancement.
Technically sophisticated & result driven IT professional, offering around 15+ years of experience in DB PL/SQL Development and Application DBA activity.
Expert in Oracle PL/SQL application tuning.
Having extensive knowledge in procedure, function, package, table creation, table portioning, indexing.
Worked extensive in explain plan to tune the queries.
Having good knowledge in PL/SQL debugging activity.
Good knowledge in Data maintenance and data modeling..
Demonstrated problem analysis, resolution skills, ability to troubleshoot, solves problems quickly & completely. Adept at mapping client’s requirements, custom designing solutions & troubleshooting for complex IT related problems.
Excellent Relationship Management skills, with the ability to conceive profitable and efficient solutions utilizing technology. Excellent communicator with exceptional analytical, people management, relationship management and coordination skills.
Good knowledge in Business requirement gathering, Analysis and documenting.
Good in DB capacity planning.
Application maintenance activity.
Test case preparing and execution planning.
Data pump utility to move the data from one environment to another.
OEM monitoring.

TECHNICAL SKILLS:

Hardware: Pentium Processors

Operating Systems: Windows 95,98,2000,NT,XP

Database: Oracle 8i,9i

GUI: JAVA

Tools: & Utilities: Toad, TFS, PL/SQL developer, beyond compare

Domain Knowledge: SQL, PL/SQL Programming and Oracle Application DBA and Elastic search. DB tuning.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle PL/SQL Lead and Application DBA

Technologies: Oracle PL/SQL, Elastic search, Oracle DB version 10, 11

Tools: TOAD, OEM, TFS, Elastic index

Environment: Production, UAT, QA, Test, Devlopment

Responsibilities:

PL/SQL Development
Working on PL/SQL procedure, package, trigger, table creation, data model, indexing, and table partition.
Requirement gathering and analysis.
Effort estimation for the DB construction.
DB construction design
Technical lead for DB construction.
Oracle Application DBA.
Application Data analyst and data correction specialist.
Pl/SQL and SQL query tuning.
Involved in data model and data maintenance activity.
Elastic search query building
Oracle PL/SQL construction ( procedure, package, trigger, table creation )
Promoting the code to the higher environment with ITIL standards and maintained 99.9% SLA.
Maintaining the version control and code merging activities.
Followed the Agile scrum methodology delivery.
QA/UAT and Prod application support and resolved the P1 performance and application issues resolved within expected SLA
Conducted the application maintenance and data growth analysis and prepared the planned capacity increase.
Used dynamic construction methodology to reduce source code and for the application flexibility.

Confidential

Oracle PL/SQL Lead and Application DBA

Technologies: Oracle PL/SQL, Elsatic search, Oracle DB verion 10, 11

Tools: TOAD, OEM, TFS, Elastic index

Environment: Production, UAT, QA, Test, Devlopment

Responsibilities:

Requirement gathering and analysis.
Requirement Master document creation
Effort estimation for the DB construction.
DB construction design
Technical lead for DB construction.
PL/SQL and SQL query tuning.
Involved in data model and data maintenance activity.
Oracle PL/SQL construction ( procedure, package, trigger, table creation )

Confidential

Senior Associate

Environment: (with skill versions)

Software Languages: SQL,PL/SQL ORACLE DBA application

Database: Oracle 11g

Server: Oracle 11g Application Server

O/s: Windows NT /2000 and Unix

Hardware: Intel Processor,512 MB RAM, 80GB HDD

Confidential

Senior Associate

Environment: (with skill versions)

Software Languages: SQL,PL/SQL

Database: Oracle 8i

Server: Oracle 9i Application Server

O/s: Windows NT /2000 and Unix

Hardware: Intel Processor,512 MB RAM, 80GB HDD

Confidential

Programmer

Environment: (with skill versions)

Software Languages: SQL,PL/SQL

Database: Oracle 8i

Server: Oracle 9i Application Server

O/s: Windows NT /2000

Hardware: Intel Processor,512 MB RAM, 80GB HDD

Confidential

Database Programmer

Environment: (with skill versions)

Software Database: Oracle 8i

Languages: SQL,PL/SQL

Server: Oracle 9i Application Server

Tools: Rational Rose, Erwin Data Modeler

O/s: Windows NT/2000

Hardware: Intel Pentium Processor, 80gb Hard Disk, 512 MB RAM

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship