Oracle PL/SQL Developer Resume NJ - Hire IT People

SUMMARY

Overall 10+ years of hands on experience in IT field, with more than 7 years of Database Development experience on SQL, NoSQL databases including Oracle and MongoDB. I also have working experience on Project Management, Scrum Framework.
Professional experience handling very large databases OLTP application hosted on Oracle 12/11g/10g/9i/8i
Proficient in in Oracle development using various Oracle key components such as PL/SQL, Stored Procedures, Functions, Packages, DB Triggers, External Tables, Bulk Load, Ref Cursor, Partitions, Dynamic SQL and Export/Import.
Thorough understanding of RDBMS, Entity - relationship model and Schemas.
Hands-on experience in performance tuning of SQL Statements and Stored Procedures using various optimization techniques such as Hints, Indexes, Explain Plan, Auto trace and using AWR reports.
Hands on experience in developing various Unix Shell Scripts.
Extensive experience on leading application team with full project life cycle experience such as Requirement Gathering, Design, Code Development, Implementation and Validation, Migration of large-scale projects for various clients.
Possess combined technical and functional expertise, successfully guiding teams for PL/SQL design, development and database support activities.
Good understanding of NoSQL Database Concepts and queries. Exposure to Data Modeling, Analysis, and ETL.
Certified Safe 4 Scrum Master (SSM 4.6), well versed with various Agile Frameworks and ceremonies like Sprint Planning, Daily Stand ups, Sprint Review and Retrospective, excellent command in assisting the team in requirement backlog management, prioritization, burndown charts, calculation of team velocity.
Good experience with industry standards like ISO 9001, 27000, 20000, Capability Maturity Model® Integration Level 5 DEV & SVC Models
Possess Excellent Communication Skills (written & verbal), Leadership Skills, Problem solving skills, multitasking.
Excellent Team Management/People Management Skills, Active listener, Detail oriented, and Result driven
Quick in mastering new concepts, applications, techniques, tools and methodologies

TECHNICAL SKILLS

Primary Skill: Oracle 12c, 11g, 10g, 9i & 8i, SQL & PL/SQL Programming, NoSQL (MongoDB)

Secondary Skill: C, C++, TACL, COBOL, JAVA, Scrum, Project Management, DevOps

BI Tools: Tableau

Operating System: Windows, UNIX, Linux

Cloud: Amazon Web Service

PROFESSIONAL EXPERIENCE

Confidential, NJ

Oracle PL/SQL Developer

Environment: PL/SQL, Oracle 12c, Oracle SQL, SQL * Loader, AWS, Database Migration, MySQL, MongoDB

Responsibilities:

Designing and creating Database objects like Tables and integrity constraints for the Sales Data
Creating Oracle Views which enable users to fetch, review and analyze historical data and help in the decision-making process
Design and Development of PL/SQL Packages, Stored Procedures, and Functions and testing in the Test environment
Creation of PL/SQL Triggers to handle different functionalities based on Table inter-dependencies
Use of SQL * Loader for loading the sales data into Oracle tables, Backup and archiving of the database tables
Use of Explain Plans for analyzing and tuning queries, Extensive Performance tuning using Indexes, Database Hints
Worked on Unix Korn Shell scripts

Confidential

Team Lead/Database Developer

Environment: Oracle, IBM DB2, Java, XML, Webservices, Html, Windows, Linux

Responsibilities:

Worked as Team Lead for Application Support, Development and Transformation projects mainly responsible for team management, project management activities like project planning, estimation, cost budget analysis, risk management in compliance with client SOPs
Conduct Code Reviews, Test Cases and Test Data Reviews, Production Readiness Meetings, and Postproduction Validations, Defect Triage Meetings, Go Live Event Planning
Successfully completed TRIPLE ISO Audits (ISO 9001 Quality Management, 20000 Service Management, 27001 Information Security Management) for both application dev and svc projects Assisted projects for CMMI Level 5 Assessments in 2 major DEV Process Areas Requirement Management (REQM), Organization Process Performance (OPM) for projects
Worked as Database Developer responsible for data migration activities from IBM DB2 to Oracle

Confidential

Project Lead

Environment: VMWare, OpenVMS, Basic1.7

Responsibilities:

Worked as Project Lead for Application Development project mainly responsible for team management, project management activities such as project planning, estimation, cost budget analysis, risk management in compliance with client SOPs, SLA tracking etc.
Worked as HP Basic Developer QA successfully completed application code migration from VAX Basic 3.9 to HP Basic 1.7 using TCS Inhouse tools. Effectively handled Design changes, Unit Testing, System Integration Testing, UAT, Production Readiness and Go Live Activities

We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

NJ

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship