We provide IT Staff Augmentation Services!

Sr. Oracle Dba Resume

4.00/5 (Submit Your Rating)

PROFESSIONAL SUMMARY:

  • Over twenty years of federal information technology experience, where he has utilized his extensive Oracle Database and Applications Technology experience to secure and increase operational efficiency and effectiveness.
  • Considerable experience with full development life cycle, which includes user requirements, user design, technical design, detailed design, programming, testing, production, documentation, implementation and user support.
  • Extensive experience cloning production and pre-production environments, executing environment backup, recovery and refresh processes and procedures.
  • Skills set includes project management, databases creation, configuration, maintenance, support of 24x7 productions systems, backup and recovery, monitoring, performance tuning and implementing security/auditing solutions.
  • Extensive experience in researching, evaluating, recommending and implementing new technologies and Information Technology (IT) business processes and procedures in the areas of High Availability, Replication, Data Warehousing, Data Mining and Secure Solutions for federal clients.
  • Developed and implemented database policies and procedures for effective and efficient operation of the Oracle Databases within an organization.
  • Worked with senior management, network management, security management and other organizational groups for smooth, secure and cost effective IT operations.
  • Successfully led several US government systems through internal and external security and auditing compliance phases.
  • 7+ years’ experience administering and supporting Oracle EBS, Oracle Database and Oracle Application Server
  • Experience installing, configuring and maintaining Oracle EBS environments
  • Experience supporting Oracle EBS solutions for DoD Business Transformation Agency (DLA)’s Defense Agency Initiative (DAI)
  • Solid understanding of DoD/federal application architecture policies
  • Experience with capacity planning, administering COOP documents and Disaster Recovery (RMAN) solutions
  • Developed and delivered eBusiness security plan for operating systems, databases, listeners, and Oracle application security recommendations.

TECHNICAL SKILLS:

  • Big Data/Analytics, Oracle Databases: (8i, 9i, 10g, 11g),Oracle RAC, Oracle HA Solutions OracleApplicationsServer (9i, 10g, 11g), WebLogic 10g/11g, Oracle e-Business suite (11i, 12i),
  • Oracle Modules (GL, AR, AP, FA, Projects), System Administration (Linux/Unix/Windows), eBusiness Security Management, Auditing/Internal Controls Management, Configuration Management, Enterprise Monitoring, Project Management, IN-MEMORY databases
  • Operating Systems: Linux, MS - Windows Servers, Sun Solaris, HP/UX Databases: Oracle 7/8i/9i, 10g, 11gR2/RAC, Oracle ASAccess 2.0, SQL*Server, Sybase, Informix
  • Applications: Oracle Federal Financials 11.0.3, 11i, 12i, CompuSearch/PRISM, Govt. Travel*Manager Gelco 8.2, Web server (4.2), Oracle Financials Analyzer (OFA), OBIEE, Oracle Identity Management, Enterprise Management
  • Tools/Utilities: Oracle Enterprise Manager (OEM), Oracle Grid Control, Oracle Apps Management (OAM), ERP Management Pack, Oracle Diagnostics Pack, Oracle RMAN, SQL/SQL*PLUS, TOAD, Data Pump, Oracle GoldenGate, OGG Director/Client, Discoverer, PL/SQL SQLPLUS, SQL Developer, Unix Shell, HP-Performance Manager, Glance Plus, HP-Open View/Data Protector, Load Runner (Performance Metrics), DB AUDIT EXPERT (database auditing tool), KINTANA (Code Management/Migration tool), Intersolv Version Management
 

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle DBA

Responsibilities:

  • Installation, configured, and architecture design for Oracle Enterprise Management Grid Control (OEM) 12cR2. On RedHat Linux 7.
  • Performed tuning, database audit and security compliance and daily database operation and maintenance.
  • Analyzed database performance issues and providing recommendations to application teams Ability to understand use case requirements and plan for product life cycle testing proactively diagnosing and resolving problems affecting database systems.
  • Maintained database configuration in compliance with release management, change management, and cyber security requirement. Implement database upgrades from 11g to 12c.
  • Upgraded, operated and managed databases in 12c clustered and standalone mode.
  • Trouble shooted issues related to Oracle ASM Grid Control/RAC/Standalone databases and configuration, patching on Unix platforms

Confidential, Luray, VA

Data Warehouse DBA

Responsibilities:

  • The NIH nVision/Data Warehouse is an enterprise-wide web application that brings administrative and financial data to NIH user community.
  • Provides DBA support of large data warehousing systems on sun solaris
  • Provides support for analysis, design, development and maintenance of NIH nVision/Data Warehouse project.
  • Responsible for maintaining synchronization of the data model in all the environments.
  • Develop/Support migration plan and be responsible for the coordination with all project participants of all changes and migrations between the environments.
  • Perform database storage, Performance and SQL tuning, using OEM12c .grid control Space Tuning Advisors.
  • Provides database backup and restore support using RMAN
  • Provides Row Level applications security support using VPD security policies
  • Provides Informatica admin support
  • Provides support for database scans and resolving STIGs/ POAMS issues

Confidential

OPS Integration

Responsibilities:

  • Defined and implement cloud-based solution architectures
  • Provided database administration for all database systems, both physical and virtual, within the four operating environments (Development, Test, Stage, and Production) at the data centers. Current database systems include, multiple Oracle products, SQL Server MySQL, Seibel, and IBM DB2; predominately Oracle and SQL Server.
  • Worked on comparing and evaluating Oracle Databases against PostgreS QL.
  • Installed, configured PostgreSQL on windows/linux. Then I migrated sample Oracle data to PostgreSQL database using SQLWays/SQLWays*Commander wizard.
  • Developed initial queries using Psql against PostgreSQL database
  • Provide troubleshooting of hardware, software, and applications.
  • Coordinate with Tier 4 (Vendor Support) service providers for resolution of issues above theTier 3 capability
  • Migrated on-site oracle databases to Amazon AWS RDS & EC2 instances.
  • Developed Standard Operating Procedures (SOP) for database systems in AWS environments.
  • Oversee database replication, using Oracle Data Guard for our Oracle database replication.
  • Install Configure Oracle Access Manager(OAM), Oracle WebGate and configure WebLogic to secure applications.
  • Developed solutions integrating AWS clouds with services hosted on-premise and in other clouds
  • Monitor cloud-based systems and components for availability, performance, reliability, security, efficiency, and ability to meet non-functional requirements and service level agreements
  • Support security audits, accreditation and processes, and obtaining approval to operate (ATO) for cloud-based system architectures
  • Configure environments for and in support of all database related aspects of user acceptance testing, functional acceptance testing, system-level testing, database security testing, installation/migration testing, configuration/compatibility testing, and performance, load and stress testing, and support of systems assurance tasks. During USCIS databases migration from Linux platform to AWS Cloud, One of the task I worked on was comparing and evaluating Oracle Databases against PostgreSQL.
  • I installed, configured PostgreSQL on windows/linux. Then I migrated sample Oracle data to PostgreSQL database using SQLWays/SQLWays*Commander wizard.
  • I also developed initial queries using Psql against PostgreSQL database. This prototype effort was well received and was slated to be used during Next phase of complete migration from Oracle to PostgreSQL.

We'd love your feedback!