We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume Profile

Jacksonville, FL

SUMMARY

  • IT Professional with more than 10 years in Design, Development and Systems Analysis
  • Experienced with major databases: SQL Server, Oracle, Informix, DB2
  • Comprehensive training in SQL Server, C , .NET Framework, ADO.NET, ASP.NET
  • More than 10 years of hands-on programming experience with UNIX operating systems.
  • Led/facilitated RAD/JAD sessions, knowledgeable of all phases of the Software Development Life Cycle SDLC

TECHNICAL SKILLS

Databases: Microsoft SQL Server, Sybase SQL Server, Oracle, DB2 and Informix.

Platforms: HP UNIX, SCO UNIX and VAX.

Languages: SQL, PL/SQL, ESQL/C C , .NET Framework, ADO.NET, ASP.NET, C/C languages, Unix C Unix Shell Script, Visual Basic for Applications VBA .

Software: .NET, ClearCase, Requisite Pro, ClearQuest, Erwin Case modeling tool, PVCS, Microsoft Access, Project and Source Safe, TOAD Tool for Oracle Application Developers , Sybase Jaguar server, Sybase PowerBuilder, PowerBuilder Foundation Class PFC and XML/XLST.

EXPERIENCE

Confidential

Environment: Sybase PowerBuilder 11.5, UNIX OS and shell programming, Oracle database stored procedures/triggers, TOAD, Sql Developer, ClearCase, HP Application Lifestyle Management.

Oracle database Administrator

  • Enhancing the Diamond Powerbuilder application to support Qualified Health Plans on the Exchange. This is done by making changes to the Benefit Rules and Benefits windows.
  • Making changes to support the individual grace period Hold, Deny, Reinstate requirements for Health Plan Services members on the Exchange.
  • Modify claims processing to accept claims with either ICD9 or ICD10 diagnosis and procedure codes with service dates after the ICD10 mandate date.

Confidential

Environment: Sybase PowerBuilder 12.5, UNIX OS and shell programming, Informix database stored procedures/triggers.

Worked remotely on a project to create database stored procedures that remove duplicate data from several database tables. Business rules were provided to me and my programs would preserve the original row, identify the duplicate row and delete it from all related tables.

Confidential

Environment: Sybase PowerBuilder 12.5, UNIX OS and shell programming, Informix database stored procedures/triggers.

  • Worked on the CORIS Powerbuilder program, a Court Case Management System that handles Courtroom, Calendar, Exhibits, Warrants, Bail, and Reporting functions for Civil, Criminal, Trust and Traffic cases. My job duties include analysis of user requirements, design of new development, coding, Unit Testing, User Acceptance and Integration testing.
  • Created new windows, database tables, columns and stored procedures. I also changed windows to comply with new laws and improve existing windows and reports. I used the UNIX operating system for shell programming and other host activities.
  • I also converted long-running reports into XML files that were consumed by external agencies and vendors.

Confidential

Developer/Programmer

Environment: Sybase PowerBuilder and PFC, ClearCsse, ClearQuest, Oracle database stored procedures/triggers.

  • Added new features to the ECaR Enterprise Collection and Recovery Powerbuilder program. I created new windows, datawindows, and custom non-visual user objects. This work was needed when integrating external bankruptcy accounts into the Wells Fargo ECaR program.
  • Worked on several projects and teams consisting of Dev Lead, Business Analyst, and developers. Standard SDLC procedures were used and include Design, Technical and code reviews. Team members are distributed in different regions and time zones most meetings with them were conducted online.

Confidential

Developer/Programmer

Environment: Sybase PowerBuilder and PowerDesigner, SQL Server 2008 R2, database stored procedures/triggers and Microsoft Access.

  • In the Quality Assurance group I added new functionality and corrected errors in the VSurvey Powerbulder program used with vendor inspections. Users are in USA, Hong Kong and the UK. Created and updated windows to add/change/delete user profiles and control program security. Added search feature to a main window. Created report wizard for flexible user reports.
  • In the Field Services group's Hastrak program I created a database in SQL Server 2008 and migrated a Powerbuilder application, corrected application, database connection and client/server compatibility issues.
  • I also migrated the Returns Powerbuilder application from Sql Server 2000 to Sql Server 2008.
  • Modified the Chemicals of Concern, TestLab, Standards and Chemical Composition Powerbuilder applications by adding user management windows, researched database replication issues, prepared the programs for migration to a new testing system and corrected programming bugs.

Confidential

Developer/Programmer

Environment: HTML, JavaScript, jQuery, Cascading Style Sheets

Created website with HTML, JavaScript and jQuery to create pages with jQuery picture viewer, slider and other features highlighting jQuery, Javascript and HTML elements.

Confidential

Developer/Programmer

Environment: Oracle 10g, SQL, T-SQL, SQL Developer, TOAD, database stored procedures and triggers, PowerBuilder 11.5

  • Worked on the Vision program, a Court Case Management System that handles Courtroom, Calendar, Fiscal, Person, Records, Exhibits, Warrants, Bail, Appeals and Reporting functions for Felony and Traffic cases. My job duties include analysis of user requirements, design of new development, coding, Unit Testing, User Acceptance and Integration testing, mentoring seasoned developers and training new developers.. Oracle products I use include Oracle databases, TOAD Tool for Oracle Application Developers for Oracle, SQL Plus, and Oracle SQL Developer. Microsoft products/technologies I use include Microsoft Visual Source Safe, SQL Server Management Studio, SQL Server database, Visual Studio, .NET Framework, ASP.NET, ADO.NET, and SharePoint Developer.
  • Added new features to the VISION Traffic Citation and Felony program. Modified existing windows and corrected bugs.
  • Created and modified database stored procedures, tables and functions to add functionality to the program.
  • Mentored junior programmers daily in all phases of software development

Confidential

Environment: UNIX, Autosys, Informix 10, SQL, database stored procedures and triggers, 4GL, HTML, PowerBuilder 10.5.1

Developer/Programmer

  • Created database stored procedures, triggers, and 4gl programs in an Informix database. I also created new windows for existing applications.
  • Helped to convert a semi-automatic Warehouse Management System to a fully-automatic diverter system and new Warehouse Control System. Modifications included adding database support for Relay Picking, Single Line Orders, and changes to route picking logic. Hand-held terminals were modified in HTML, scripts and database stored procedures.

Confidential

Developer/Programmer

Environment: Oracle 9i, Sybase and SQL Server, Visual Studio, ASP.NET, ADO.NET, C , PowerBuilder 11, TOAD, Advanced Query Tool AQT .

  • As Developer/Programmer, helped to identify/define requirements to convert an application to SAP on an ERP/Legacy interface project.
  • Created multi-tier website in ASP.NET and performed production support for the Total Reconciliation Solution and Unclaimed Property Compliance System. Modified Oracle Stored Procedures, Functions and Packages. These programs help SCE comply with state regulatory Escheatment unclaimed revenue requirements.

Hire Now