We provide IT Staff Augmentation Services!

Dba/developer Resume Profile

Carlsbad, CA

Specialization: With over 20 years of ORACLE experience and over 10 years of DBA experience, in both Web and networked client/server environments, I can provide DBA, Development, Design, Project Management and Unix Administration skills that are especially valuable to companies using ORACLE and Unix. My mentoring and management skills provide additional value by providing training and guidance to technical and non-technical team members.

Work Experience:

Confidential

DBA/Developer

  • Performed DBA duties included hot and cold RMAN backups. Additional duties include developing and releasing DB and web code from Dev to Test to Production, providing data models and DB documentation, providing Production support including database changes in support of the Sicomm B2B and G2B web-based application, providing Linux administration, including NTP, DNS, and NAGIOS activities. iPlanet app server with Perl cgi and Server-Side Javascript
  • Moved Oracle database from local host to Amazon Cloud EC2 servers using Oracle 12c
  • Developed PL/SQL stored packages, triggers, etc. in support of web applications, including System/Web Testing, Quality Review, and release mgt.
  • Converted standalone ASP/SqlServer based application to integrated Oracle/iPlanet, including System/Web Testing
  • Insured database quality by adding auditing triggers, tables, additional keys, and practicing Quality Control Activities
  • Supported Software Development Life Cycle SDLC , including test environment management and test execution and closure
  • Strong analytical and problem solving skills

Confidential

Senior DBA

  • Performed DBA duties included hot and cold backups using RMAN and shell scripts, SQL Loader, Export/Import, SQL Plus, recovery management, tuning, Data Guard, database migration from 10g to 11g, on-line reorg, etc. Oracle Forms 10gDS , ERWIN, VSS, and Toad. Additional duties include administering ORACLE 11g classified and unclassified datamarts and data warehouses on Windows servers, releasing Stored Procedures and DDL from Dev to Test to Production following CM controls, assisting Product Development with all aspects of the Development Life Cycle including coding and review of stored procedures PL/SQL , materialized views, SQL tuning, issue investigation, etc., development of audit procedures and supporting database auditing reports. Providing Logical and Physical Modeling using Erwin and release management using Visual Source Save. Development of ETL processes using PL/SQL.

Confidential

Oracle Production DBA

  • Usual DBA duties included hot and cold backups using RMAN and shell scripts, SQL Loader, Export/Import, SQL Plus, recovery management, tuning, Data Guard to Disaster Recovery Site, database migration from 8i to 9i to 10g to 11g, on-line reorg, etc. Oracle Enterprise Manager, Oracle Advanced Security, Oracle Forms/Reports 10gDS , Spotlight, Quest Central, Toad, FogLight and SharePlex. Additional duties include administering ORACLE 11g/10g/9i/8i datamart on HPUX/Win2K servers, releasing Stored Procedures and DDL from Dev to Test to Production following CM controls, assisting Product Development with all aspects of the Development Life Cycle including coding and review of stored procedures PL/SQL, Java , materialized views, SQL tuning, issue investigation, etc., development of SOX/SAS-70 procedures and supporting database auditing reports. Providing extensive operational background in establishing and implementing operational standards for installing and maintaining/patching Oracle binaries, establishing and implementing DB monitoring, DB backup/recovery, access management, performance troubleshooting, DB upgrades, DB migrations, test, and validation in a large scale enterprise implementation. Implementing Disaster Recovery procedures and geographically separate site, Services Management, ITIL Foundation , SCRUM, Service Desk, and 6-Sigma. Providing Logical and Physical Modeling using Oracle Designer 10g and PowerDesigner. Implementation of data partitioning, compression, and archive automation. Support of COTS products such as Appworx and Business Objects. Participating in on-call rotation, project and time tracking using PlanView, weekly status reporting, and virtual elimination of unplanned database downtime. Development and deployment of Web Services and ETL processes using PL/SQL stored procedures, JDeveloper, and WebMethods. 2TB payroll data warehouse Worked with on-shore and off-shore teams. Lead DBA in 3 member team.
  • Supported Software Development Life Cycle SDLC and Information Technology Lifecycle Management ITIL
  • Designed and created test data, executed test cases, logged defects, managed defect resolution, ensured reproducible and verifiable results
  • Assisted with Use/Test Case development, execution, and closure
  • Strong analytical and problem solving skills
  • Provide Quality Control Activities, such as database integrity, verify data criteria, consistency, processing movement, and completeness

Confidential

:Oracle Developer

  • Developer with UBC of Las Vegas, NV. a dot.com This position involved working with other project DBAs and Developers, logical and physical design using Designer 9i/10g and Erwin, and coding of stored procedures PL/SQL and Java , and XML/XSLT. Move Stored Procedures from Dev to Test to Production. Develop Reports and Forms using 10gDS. Administer 10g Application Server. Source code management using CVS.

Confidential

Oracle DBA

  • Designer/Developer with Toyota Motor Sales of Torrance, CA. a dot.com This position involved administration of ORACLE 9i/8i datamart on HPUX and Win2K servers, working with other project DBAs, logical and physical design using Designer 9i/6i and Erwin, change management of both code and models, development of physical and logical standards documents, and coding of stored procedures PL/SQL and Java , DB2, MS SqlServer, XML/XSLT, and Informatica. Oracle DBA duties included hot and cold backups using RMAN and shell scripts, SQL Loader, Export/Import, SQL Plus, recovery management, tuning, database migration from 8i to 9i, etc. The Toyota Order Management System TOMS , including working with ADO/COM programmers and tuning n-tier applications. Data uploads and downloads nightly between various systems, including SqlServer, DB2, and other mainframe applications.
  • Developed extensive PL/SQL stored procedures, functions, packages, triggers, object views, object types, including PL/SQL server pages PSP
  • Created tables, indexes, views, materialized views, including range partitioned tables and indexes
  • Developed in-house encrypt/decrypt database function in Java for application level security
  • Developed extensive HP Unix shell scripts, including Perl and Oracle Forms using 9iAS, for DBA activities: automating development and testing schema level refreshes also converted FORMS from 6i to 9i
  • Tuned SQL and PL/SQL for max performance, including extensive DBA and Architectural problem solving, replacing looping with Bulk Collections, use of temporary tables, and Statspack
  • Performed code reviews on backend and middle tier VB code
  • Use of ClearCase for source code management, Oracle Designer/SCM for models, and ClearQuest for defect tracking and call tracking

Oracle Experience by OS :

Unix: Oracle V12c,11g,10g,9i,8i,8.x,7.x,6 Installations/Upgrades and Applications Development using SQL PLUS, SQL FORMS, SQL ReportWriter, SQL Menu, Structured Query Language SQL , PL SQL triggers and procedures on Unix Solaris, Linux, Ultrix, Dynix, HP-UX, AIX, and SCO Unix SQL FORMS 3.0 character version using PL SQL triggers and procedures on Unix 11gAS/10gAS/9iAS Application Server, Net Apps , WebDB, OAS, Oracle Web Server, Portal SQL Forms, SQL Reports, SQL Menu, and SQL Graphics using Motif/MS Windows Developer 11g,10g,9i,6i,2000

VAX/VMS: Oracle V7.x,6 Installations/Upgrades and Applications Development using SQL PLUS, SQL FORMS, SQL ReportWriter, SQL Menu, Structured Query Language SQL , PL SQL triggers and procedures SQL FORMS 3.0 character version using PL SQL triggers and procedures CASE Designer, CASE Generator, CAS Dictionary

Windows NT/200x: Oracle V11g,10g,9i,8i,8,7 Installations/Upgrades and Applications Development using SQL Forms, SQL PLUS, SQL ReportWriter, SQL Menu, Structured Query Language SQL , PL SQL triggers and procedures Developer 11g,10g,9i,6i,2000 SQL FORMS, SQL REPORTS, SQL MENU, and SQL GRAPHICS Designer 11g,10g,9i,6i,2000 CASE DESIGNER, CASE Generator, CASE Dictionary V 5.0, 5.1, 6.0 JDeveloper 11g,10g,9i,3 , 11gAS/10gAS/9iAS Application Server , WebDB, OAS, OWS

General Experience: Over 20 years of experience working in the computer industry. 40 years of general experience including 4 years in the U.S. Army Secret clearance and 3 1/2 years Civil Service. Most of the last 20 years have been spent as project lead or DBA on various database development projects.

Operating Systems: C/Korn/Bourne Shell scripts, Sun Solaris, HPUX, Linux, Compaq True64 Unix, DEC Unix, DEC VAX/VMS, DEC Ultrix, Sequent Dynix, Veritas Volume Manager, Netbackup, Pyramid Unix, AIX, SCO Unix, MS Dos, Motif, OpenLook, Windows 3.11, 95, NT/2000, XP, Server 2003/2008 , and OS/2.

Hardware: Sun Sparc/Intel , Compaq Alpha, DEC VAX, Hewlett Packard, Sequent, Pyramid, IBM RS/6000.

DBA Tools: ORACLE Enterprise Manager/Grid Control, TOAD, Network Manager, Replication Manager, ORACLE Server Manager, SQL Plus, SQL Loader, RMAN, DATAPUMP, Export/Import, Access Manager, SQL DBA, OMNIBASE SMARTSTAR RDBMS, Britton Lee Database Machine, DECs RDB and Datatrieve.

Data Bases: ORACLE Relational Database Management System versions 12c,11g,10g,9i,8i,8.x,7.x,6.x , including Metalink, ORACLE FORMS versions 2.3, 3.0, 4.0, 4.5, 6i, 9i, 10g, 11g Internet, Net Apps, CDE, X-windows, MS-Windows, Macintosh, and character mode versions , SQL PLUS, ORACLE Reports , SQL Menu, Structured Query Language SQL , Procedural Language/Structured Query Language PL/SQL , Oracle Designer 11g,10g,9i,6i,2000 , SqlServer 2005/2003/2000/7.

Languages: PL/SQL, Server-Side Javascript, Java, XML/XSLT, Perl, Unix Shell, Pascal, COBOL, FORTRAN, BASIC, C , C, ALL-IN-1 scripts, HTML, HTTP, INTERLEAF Publishing System, Visual Basic, Digital Command Language DCL using VMS operating systems, Regis Graphics Language, POSTSCRIPT, Runoff, Forms Management System FMS , RPG-II/III, TUTOR, PL/1, Logo, PILOT, LISP, VAX Macro, and various other Assemblers. Familiar with DEC-windows/ X-windows/ MS-Windows APIs .

Networking: SqlNet/Net8, Ethernet, DECNET, Pathworks, TCP/IP, ISDN, AppleTalk, Novell Lite, and MicroSoft Windows for Workgroups, NT File Servers, NFS, FTP, and POP3 Mail server installation

ERP and CRM Products: Oracle Financials, Vantive, SCT Banner, ACT, GoldMine.

ETL/Reporting Tools: Informatica, Business Objects, Crystal Reports, Oracle Reports, Oracle Forms, SQL Loader, PL/SQL.

Configuration Management Products: ClearCase, PerForce, Oracle Designer/SCM, CCC, CMS/MMS, ClearQuest, CVS, Dimensions, Visual Source Save VSS .

Internet Tools: ORACLE 11gAS/10gAS/9iAS, OAS, WebServer, WebDB, Portal, PSP, HTML, Internet Explorer, Internet Information Server IIS Web Page design, Web Server management, and Networking issues , WebMethods, WebLogic.

Hire Now