Oracle Lead Developer Resume

SUMMARY

experience in IT and many years of experiences as consultant on government projects
Have extensive experiences in data management, database application development, and oracle database administration
Proficient in designing conceptual, logical and physical data models, effectively translate business requirements into the design process.
Experienced in performance tuning at sql level, application level and database level
Participated in designing environment architecture and infrastructure solutions; provided performance analysis for the database optimization process. Participated in performance testing and validation of the revised design.
Expert in coding complex programs using oracle PL/SQL (package, procedures, functions, triggers and object types)
Familiar with application spring frame work, hibernate ORM object to relational mapping, xml parsing, xml schema, and web services
Good work relationship with key stakeholders, reviewing project scope, schedule and helping set expectations for project milestones

TECHNICAL SKILLS

Oracle 8i/9i/10g/11g/12c
Enterprise Manager Cloud control
SQLDevelper, Toad, SqlPlus, ERwin, Data Modeler
Business objects universe
PL/SQL, SQL
SSRS, SQLserver, Transact - SQLHibernate (JPA), JBoss EAP 6.1 Application Server, JAXB2
Java
ColdFusion, Java script
Subversion, Astah Community, Bitbucket

PROFESSIONAL EXPERIENCE

Oracle Lead Developer

Confidential

Responsibilities:

Working on Oracle Real Application Clusters (Oracle RAC) database with Data guard configurations
Building logical data model and implementing physical data model
Applying partitioning, materialized views, and de normalization techniques to improve application performances
Monitoring and tuning DB performance using AWR, ASH reports, Sql tuning advisor
Providing performance analysis for the database optimization process. Participated in performance testing and validation of the revised design.
Working with production DBAs on database sizing, capacity planning, and configurations
Developing DB scripts, packages, stored procedures and triggers
Maintaining DB artifacts
Supporting Informatica ETL processes

Confidential

Oracle Lead Developer

Responsibilities:

Functioned as a data architect/development DBA to review and approve database structural changes and DDL scripts
Worked closely with production DBA, monitored database performances, conducted intensive performance tuning on SQL, PL/SQLs and oracle DB
Developed DB scripts, packages, stored procedures and triggers
Practiced Agile iterative development

Confidential

Oracle Lead Developer

Responsibilities:

Worked on complex reporting data in a data mart
Led a group of developers, created ETL processes using PL/SQL packages and external files;
Designed and developed configurable database solutions for applications