Senior Oracle Developer Resume Profile
3.00/5 (Submit Your Rating)
Springfield, VA
SUMMARY:
IT Professional with over 16 years demonstrated abilities in Agile/Scrum methodologies, consulting, managing, lead DBA, Unix Administration, Software and Application Development Life Cycle. Knowledgeable in a wide range of Programming Languages, Operating Systems, Hardware and Software. Enjoying the fast-paced and challenging environment.
PROFESSIONAL SKILLS:
- Databases: ORACLE RAC 12C, 11G, 10G RAC, 9I RAC,
- WINDOWS, NETWORK APPLIANCE SNAPSHOT 2.6
- NET BACKUP FOR UNIX AND BACKUP EXEC FOR
- Database backup: ORACLE RECOVERY MANAGER RMAN , VERITAS
- Database design tool: ERWIN.
- TORTOSE GIT.
- ORACLE SQL LOADER AND SQL DEVELOPER,
- SPOTLIGHT AND IWATCH, SQL LAB TUNNER ,
- ORACLE GRID CONTROL 11G, LIQUIBASE, TOAD, QUEST
- ORACLE GOLDEN GATE, ORACLE ENTERPRISE MANAGER ,
- Database/Programing tools:
- ORACLE CERTIFICATION 10G.
- MICROSOFT SQL SERVER 7.0 and 2000.
- MONGODB.
- NETEZZA DATAWAREHOUSE.
- ORACLE PL/SQL.
- ORACLE AUTOMATIC STORAGE MANAGEMENT ASM ,
- ORACLE 8I, ORACLE DATA GUARD,
- Cloud Infrastructure: AMAZON AWS and EMC VM WARE.
- Middleware: ORACLE FUSION MIDDLEWARE 11G, ORACLE WEB
- LOGIC 11G and ORACLE APPLICATION SERVER 10G,
- TIBCO BUSINESS WORKS AND EMS TUXEDO.
- Programming/Scripting
- Languages: JAVA, C, C , Oracle PL/SQL, UNIX KORN SHELL, SED,
- AWK, and HTML.
- Application Software: AGILE, ORACLE MUFACTURING.
- Operating System: RED HAT ADVANCED SERVER 6, 5 and 4, UNIX
- WINDOWS 95 .
- WINDOWS 2000 client/server , WINDOWS NT
- WINDOWS 7, WINDOWS XP,
- AIX, SOLARIS and HP UX , LINUX, VMWARE,
- Hardware: EMC SAN, NETAPP SAN, DELL SERVER,
- VAX TERMINAL, SUN SPARC, IBM RS 6000 and NCR 3000.
WORK EXPERIENCE:
Confidential
SENIOR ORACLE/MONGODB DBA/DEVELOPER
- Migrating Oracle development and production database to Amazon AWS.
- Configure Grid Control to run on Amazon AWS.
- Following Agile methodology by integrating Oracle DML and DDL in Gradle and Jenkins for automating deployment.
- Installing and configuring ORACLE 12C and 11GR2 Real Application Cluster RAC on Red Hat Advanced Server for dev and test in Virtual Environments on VMWare .
- Implementing backup strategy using RMAN and datapump .
- Configuring Grid Control to monitor databases performance.
- Batch job programming using PL/SQL.
- Installing and configuring Mongo DB Sharding on RedHat in development.
- Logical design USCIS-ELIS2 using Erwin.
- Installing and configuring Liquibase for Oracle version control.
- Maintain and monitoring Tomcat.
- Continuous deployment Database from development to testing to pre-prod environments in
Confidential
SENIOR ORACLE DBA/MONGODB
- Designing, architecting and installing ORACLE 11GR2 Real Application Cluster RAC on Red Hat Advanced Server in production environments which supports multiple COTS systems.
- Implementing backup strategy using RMAN and datapump .
- Configuring Grid Control to monitor databases daily.
- Migrating and upgrading stand alone databases from various platforms Windows and Linux to Oracle 11gR2 RAC on Linux production and Oracle 11gR2 RAC on Linux in VMWare environments
- Installing and configuring Mongo DB on RedHat in development.
- Monitoring and maintaining Data Guard daily for Disater Recovery site.
- Installed TIBCO Business Works and EMS on RedHat.
- Installed and configured Oracle Fusion Middleware 11g on RedHat .
Confidential
LEAD DBA/DEVELOPER/DATAWAREHOUSE
- Designing, architecting and migrating Oracle 10G RAC Real Application Cluster on Red Hat Advanced Server to Oracle 11G RAC that supported DEA'S Registrant Support Network RSN application.
- Planning and Configuring Data Guard for RAC.
- Assisting development team in database logical design using Erwin.
- Planning and setting up Oracle Fusion Middleware 11g cluster on VMWare
- Designing, architecting and implementing Oracle 10G Real Application Cluster on Sun Solaris Server that supported DEA'S registration application registration application for doctors, dentists, pharmacies, and drug companies .
- Setting up and configuring Oracle Golden Gate for Oracle Stream migration.
- Migrating Oracle 10G Application Server Reporting, Form and Mod PL/SQL on Red Hat Advanced Server to Oracle 11G Fusion Middleware and Oracle WebLogic 11G.
- Migrating DEA's ARCOS application mainframe to Oracle 11G RAC logical design tables and objects using Erwin and using PL/SQL and SQL loader to extract data ETL from IBM's M204 to ORACLE and transfer to Netezza DataWarehouse Appliance.
- Designing, architecting and migrating Oracle 9i on Windows 2000 Server to Oracle 10G RAC on Red Hat Advanced Server that supported Registrant Support Network RSN application registration application for doctors, dentists, pharmacies, and drug companies .
- Implemented backup and recovery strategy Veritas Netbackup and Oracle Recovery Manager RMAN on Linux and Unix.
- Designing and implementing Oracle Grid Control 11g and 10g.
Confidential
LEAD PRINCIPAL CONSULTANT
- Designing and implementing s Real Application Cluster RAC and Grid Control 10g for FEDERAL EMERGENCY MANAGEMENT AGENCY FEMA .
- Consulting for Accenture how to implement Oracle Replication.
- Implementing Oracle 10G Replication for Naval Supplies.
- Designing and implementing Oracle RAC 10G for Austin Water Authority on IBM Unix Aix.
- Implementing Oracle Real Application Cluster RAC 10G on Sun Solaris for Illinois State Police Department.
- Setting up and configuring DataGuard 10G.
Confidential
LEAD Oracle
- Setting and Implementing Oracle Disaster Recovery site.
- Migrated Oracle 9i RAC to Oracle 10G RAC on Red Hat Advanced Server.
- Maintained large clustered for government investigative service test and production Oracle 9i database on Red Hat Linux Advanced Server on EMC Storage Area Network SAN .
- Designed, writing proposal and implementing disaster/recovery that include Data Guard and Oracle Recovery Manager RMAN for backup/restore .
- On going support for development, test and production system that include rolling back, rolling forward, monitoring, and tuning clustered database on Linux Red Hat.
- Written proposal, white papers and giving technical input on database issues such as backing up /restoring, disaster/recovery to upper management.
.
Confidential
SENIOR DBA ARCHITECT DATA WAREHOUSE
- Designing logical and physical data warehouse Life Cycle Capacity Planning for Telecommunication Billing size 1 TB .
- Writing proposal hardware/software for implementing database backup/recovery Real Application Cluster and Data Guard .
- Installing, Configuring and Implementing Oracle 9i on IBM and Linux.
- Training/Mentoring junior developer in Pl/SQL.
- Monitoring /Performance tuning billing application using performance pack, analyzing database, indexing, etc .
Confidential
SENIOR ORACLE, SQL SERVER DBA/DATAWAREHOUSE
- Designing database architecture logical and physical Full Life Cycle Capacity Planning size ranging from 400GIG- 2TB .
- Designing and implementing SQL Server 2000.
- Implementing Oracle physical data warehouse for multiple clients host sites.
- Installing, Configuring and Implementing Oracle 8I, 8.1.5, 8.1.7 and 9i on Solaris 2.6 and 2.7
- Tuning Oracle server I/O, tablespace fragmentation, data dictionary, library etc. by utilizing Oracle TKPROFT, EXPLAIN PLAN, and USTAT/BSTAT, etc .
- Implementing Oracle 9i Real Application Cluster RAC and Data Guard.
- Utilizing Oracle Rman and Veritas Netbackup to backup and recover database on production database.
- Partitioning table and bitmapping index in Data Warehouse.