Oracle Dba/developer/support Resume
Austin, TX
SUMMARY:
- I am a US citizen. I have worked in the USA with the Government at State and Federal levels.
- I have also worked in the Banking Industry (both commercial and merchant) and in the Oil - industry.
- I have passed the USA SF85P (Public Trust Position form - equivalent to Security Clearance).
- I am a skilled Oracle DBA and Developer with over fifteen years industry experience.
- Certified as Oracle developer, certified DBA on all Oracle platforms up to 12c and also certified in J2EE Web - Development.
- I was part of a DBA Team that worked on Dell systems and Federal projects to implement the new Federal Business Enablement Program covering several applications including: EBS, SOA, SABRIX, GTM, TFS, GAFT, SIEBEL, B2B and OBIEE.
- Mainly involved in installing the Databases in RAC environment on multiple Oracle Homes, Documentation, Fine Tuning, Performance and High level Technical Support to users. Extraction and Loading of Data using EXPDP, IMPDP. Cloning Databases, Backup and Recovery using RMAN.
- My work had involved Database administration, systems design, Data - modeling and applications development.
- As a DBA I have been involved with Backup/Recovery strategic planning and implementations, Database Tuning, Local and Remote Database monitoring, maintenance and support (24x7). Database Installation, Patching, Security - level issues and user - roles, Data - Loads, Data - migration and extensive PL/SQL Programming, dynamic SQL, also using RMAN, RAC, ASM, OEM, Golden - Gate, DBA studio, SQL*Loader, Data - Loads, etc. As a Developer, the tools and Languages
- I have applied include PL/SQL, TOAD, FILEZILLA, WINSCP, PUTTY, JAVA, J2EE, JSP, EJB, STRUTS, ODBC, JDBC, Oracle Forms, Reports, Cold - Fusion, Dreamweaver, Fireworks, etc.
- I have worked on UNIX, LINUX, Windows and LAN Network platforms.
- I have a wealth of experience in PL/SQL, Functions and Stored Procedure programming to support Web - developer - teams, returning structured parameters and REF–Cursors, also involved in the web–programming writing Data–Objects, SERVLETS, etc.
- Have used several utilities to extract, transform and load (ETL) legacy data.
- Other tools and languages I have used are JavaScript, HTML, XML, Debugger, PL/SQL Developer, VISIO and Erwin for Entity Relationship Diagrams.
PROFESSIONAL EXPERIENCE:
Confidential, Austin, TX
Oracle DBA/Developer/Support
Responsibilities:-
Part of a DBA Team that worked on Dell systems and Federal projects to implement the new Federal Business Enablement Program covering several applications including: EBS, SOA, SABRIX, GTM, TFS, GAFT, SIEBEL, B2B and OBIEE. Mainly involved in installing the Databases in RAC environment on multiple Oracle Homes, Documentation, Fine Tuning, Performance and High level Technical Support to users. Extraction and Loading of Data using EXPDP, IMPDP. Cloning Databases, Backup and Recovery using RMAN
- Support for local and remote Oracle Databases
- Oracle RAC, Data–Guard, Oracle Standby, OEM Interface
- Database Installations, Monitoring, Tuning, Administration and Management, Technical Support
- Support for local and remote Oracle Databases
- Oracle RAC, Data–Guard, Oracle Standby, OEM Interface
- Database Installations, Monitoring, Tuning, Administration and Management, Technical Support
- Golden Gate: Dynamically synchronized data between the legacy NSK Database with Oracle Database. Created the necessary OBEY and PARAMTER files to generate the Extracts needed for the data loads. Used IMPDP to load the Oracle trail dump file before running the Extract process.
- Programming PL/SQL to develop customized reports to support wide variety of clients
- Programming PL/SQL, Writing Stored Procedures, Packages, Functions, Reporting
- Creating databases, Database Cloning and Data–loads, RMAN, Restores and Recovery
- Support for local and remote Oracle Databases
- Oracle RAC, Data–Guard, Oracle Standby, OEM Interface
- Database Installations, Monitoring, Tuning, Administration and Management, Technical Support
- Programming PL/SQL to develop customized reports to support wide variety of clients
- Programming PL/SQL, Writing Stored Procedures, Packages, Functions, Reporting
- Creating databases, Database Cloning and Data–loads, RMAN, Restores and Recovery
- Support for local and remote Oracle Databases
- Oracle RAC, Data–Guard, Oracle Standby, OEM Interface
- Database Installations, Monitoring, Tuning, Administration and Management, Technical Support
- Programming PL/SQL to develop customized reports to support wide variety of clients
- Programming PL/SQL, Writing Stored Procedures, Packages, Functions, Reporting
- Creating databases, Database Cloning and Data–loads, RMAN, Restores and Recovery
- Environment: Oracle RAC, ASM, UNIX, LINUX, VPN, SSH, FTP, FILEZILLA, WINSCP, TOAD
- Reports processing, Supporting Clients Applications.
- Technical (Customer) Support.
- Systems conversions for a variety of customers
- Reversed Engineer the ERD for Production and Development databases using Oracle Designer 10g
Tools: Oracle Advanced Replication, Oracle Standby Database, Replication Conflict Resolution, OEM Interface, RAC, ASM, Oracle 9i, 10g, 11g, Backup/Recovery, RMAN Cloning, EXPDP/IMPDP, Technical Support,Oracle Installer, Patches, Database Monitoring and Tuning, PL/SQL Development, Programming Stored procedures and functions, Reporting, WINDOWS, LINUX, HP, UNIX, FILEZILLA, WINSCP, TOAD
Confidential, Greenwood, CO
Senior Oracle Developer/Support
Responsibilities:
-
Programming PL/SQL to develop customized reports to support wide variety of clients in America and Abroad
- On the side: Developing customized forms 10g for an Accounting Package and writing PL/SQL
- Installed and configure Developer 10g and Application server. Start, stop OC4J instance, design, develop, test, QA and implementation
- Programming Oracle Forms 10g on the accounting package and State in West–Africa
- Forms 10g calling multiple forms and processing including images
Tools:: Oracle 9i, 10g, 11g, Developer 10g, Forms 10g, PL/SQL, SQL, Stored procedures and functions
Confidential, Greenwood, CO
DBA/Web–Developers Support
Responsibilities:
-
Short contract mainly to resolve the serious performance issues in the existing applications and the Database levels
- Worked on local and remote Oracle Databases
- Successfully resolved the performance issues at database and application levels
- Programmed PL/SQL using pipeline functions (Streams)
- Extensive PL/SQL Programming returning ref–cursors and data to web application developers
Tools:: Oracle 10g, Oracle Wait Interface, 10g EM, PL/SQL, SQL, Stored procedures and functions
Confidential
Oracle DBA/Developer/Support
Responsibilities:
-
Working on oil/gas supplies systems using Oracle Databases and Oracle software tools
- Supporting about 10 Oracle databases including Development, Test and Production Databases
- Installing Oracle 9, 10g and 11g Databases on Windows, Linux
- High Technical Support to team members and remote customers
- Patching, Maintaining, Monitoring and Tuning the databases
- Configuring Oracle Enterprise Manager (OEM) to monitor/send out emails and alerts to ensure the good health of the Databases
- Programming Packages, Procedures, Functions and Triggers using PL/SQL, Exposed to RAC and DataGuard
Tools:: UNIX, Windows, Oracle9i, Oracle 10g, Oracle 11g, DataGuard, OEM, STATSPACK, Oracle Wait Interface, 10g EM, RMAN, SQL–Developer, PL/SQL,SQL, Stored procedures, Oracle Installer, Patches, APEX, SVN
Confidential, Boston, MA
DBA/Web–Developers Support
Responsibilities:
-
Several Oracle Databases supporting satellite broadcasting in the USA, Latin America and Canada
- Database Installations, configuring, Tuning and Administration. Backup/Recovery, Data–Loads
- Backup/Recovery, Extensive PL/SQL Programming to support the Web–developers
- Designed, modeled, normalized and implemented logical and physical models
- Programmed using SQL, PL/SQL, JAVA, J2EE, JSP, HTML, EJB
Tools:: OEM, DBA studio, TOAD, SQLLDR, UTL FILE, PL/SQL, SQL, Java, J2ee, JSP, EJB, Servlets, Oracle Installer, Oracle 8i, Oracle 9i