We provide IT Staff Augmentation Services!

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

Hire Now