We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

4.00/5 (Submit Your Rating)

SUMMARY

  • 5+ Years of experience in Identity and Access Management area
  • Experienced Oracle Identity Management suite resource
  • Possess configuration and hands on implementation experience with Oracle Access Management 11gR2 upgraded Oracle Access Manager 11gR2 PS1 to OAM 11gR2 PS3
  • Involved in day to day administration of Oracle IDM suite like Access Manager, Virtual Directory, HTTP Server and Oracle Weblogic application server.
  • Experienced with Sun IDM (Oracle Waveset) and OpenSSO.
  • Implemented Role Base Access control (RBAC) using roles in Sun IDM
  • Quick learner and adopt new technologies, new environments
  • Strong believer of knowledge sharing with team members
  • Goal oriented, highly motivated, enthusiastic team player and dedicated professional
  • Able to work under pressure in a multi - task environment, manage continuous change, all with a focus on providing excellent client service.

TECHNICAL SKILLS

Operating Systems: Sun Solaris, AIX, Linux (Redhat, Enterprise), Unix (True 64, Digital, HP, AT&T), Windows

IDM Tools: Oracle Identity Management Suit (OAM, OIF, OIA, OIM), Sun IDM (Oracle Waveset), OpenSSO, Microsoft ForeFront Identity Manager, Oracle Virtual Directory (OVD), Oracle Directory Services (ODSEE)(LDAP), ForgeRock OpenAM

Application/Web server: Oracle Weblogic Application server, Oracle HTTP Server, Apache, Tomcat, GlassFish, WebSphere

PROFESSIONAL EXPERIENCE

Confidential

Senior IDAM Analyst

Responsibilities:

  • Highlight/identify gaps in existing functionality and review requirements with stakeholder
  • Working closely with Customers, Consulting teams, Development teams and partners to ensure that strategy, roadmap and future direction of the IDAM is articulated correctly.
  • Analysis, design, development and deployment of Change Requests related to Identity & Access Management
  • Lead Oracle Access manager (OAM) upgrade project.
  • Designing Single Sign On solutions using IWA/WNA and Form Based authentication.
  • Integrated ADFS with OAM using OIF.
  • Part of ForgeRock OpenAM implementation team to replace Sun OpenSSO.
  • Develop and maintain new and existing functionality and the related documentation
  • Subject matter expert for Oracle Access Manager, Single Sign On (SSO) by using Oracle Access Manager and WebGate, Sun IDM (waveset), OpenSSO. WebLogic
  • Provided ongoing support and enhancements to existing Identity and access management environment.
  • Planning to replace OVD with OID.
  • Implemented SSO solution using OAM for web based applications.
  • Integrated IDAM suite with Oracle Directory services, OVD and Active directory.

Confidential

Senior Consultant

Responsibilities:

  • Identity Management technical lead
  • Installed and configured Oracle Access Manager and Oracle Virtual Directory
  • Worked on Oracle Identity Manager implementation
  • Configure reverse proxies for SSO to use WebGate and Oracle Access manager
  • Supporting existing Sun IDM, OpenSSO and myeHealth application
  • Scripts to start and stop Weblogic Node manager, Admin and Managed servers
  • Troubleshoot IDM synchronization issue with LDAP and Active Directory (AD)
  • Worked with architect to design highly available Weblogic cluster to support OAM
  • Configuration replication to automatically copy modifications from one directory server to other directory servers.
  • Work closely with vendor during upgrades for configuration changes and other upgrade tasks
  • Tier 2 support for application issues
  • Application Server Administrator. Installed, configured and supported Weblogic, Websphere, Tomcat Application Server.
  • Handling all the aspects of administration tasks such as day-to-day site monitoring and maintenance, Installation, Configuration, Clustering, Deploying Applications, Troubleshooting, Load Balancing, Performance Tuning and Maintenance of Application Server.
  • Used SQL, Pl/SQL, TSQL and ANSI SQL to query the database to support the variety of application.
  • Implemented scripts for applications monitoring to reduce downtime
  • Participate and interact with multiple teams including (developers, tester, BA, DA, PM) and business partner on an ongoing basis
  • Ensured day to day operation by troubleshooting and resolving issued logged by the users of highly available mission critical enterprise applications.
  • Generated customized reports, automate existing processes, generate data extracts and implement several other enhancements as per the requirement of the system users.
  • Mentored and worked with the other team members to transfer the knowledge

Confidential

Senior Oracle Consultant & DBA

Responsibilities:

  • Support to CGI sales group for Oracle based requests
  • Participation in proposal work and Oracle opportunities
  • Working on defining upgrade strategy for Oracle 8i/9i database instance to 11g R2
  • Revised Back and recovery strategy for quick and cost effective results
  • Involved with developers to optimize SQL Queries and database tuning

Confidential

Database Administrator

Responsibilities:

  • Responsible to manage Oracle, Sybase and SQL Server databases
  • Established database cloning procedures to clone production database for development team.
  • Conducted backup and recovery strategies using RMAN and prepared documentation for Disaster Recovery Procedures.
  • Participated in planning and implementation of off-site Disaster Recovery planning and testing.
  • Performed Sizing and capacity planning and designed the physical database architecture.
  • Wrote and implemented AIX scripts to monitor database, backup, space usage and system health.
  • Wrote scripts to verify and expire old backups from RMAN catalog.
  • Configured Oracle Enterprise manager (OEM) to monitor database performance.
  • Managed and resolve issues with Oracle Streams and Oracle Data Guard
  • Analyzed and documented pros and cons for data conversation project from Oracle to SQL Server.
  • Provided proactive performance monitoring of databases ensuring service levels were met.
  • Administered change control of physical data structure for all environments.
  • Worked with developer to create SQL Server Reporting services packages.
  • Implemented ETL scripts for data warehousing database.
  • On Call Production support
  • Helped developers’ problems with PL/SQL and SQL tuning issues.
  • Experienced with maintaining physical and logical database design.
  • Developed Database procedure, functions and triggers
  • Involved in implementation of Service Suite ( http://www. Confidential .com/solutions/service) at Confidential
  • Worked closely with vendor to resolve performance issues for Service Suite database
  • Planned and applied patches and Critical patch update (CPU) quarterly.

Confidential

Oracle Database Administrator

Responsibilities:

  • Support production, development and testing databases.
  • Translated requirement in to design and build data models for data warehousing and reporting database.
  • Standardized developer and staging environments with production environments to improve QA process.
  • Planned and implemented DB Auditing and database security using roles, privileges and user management
  • Implement backup and recovery strategies for archiving and non-archiving databases. Monitor databases for performance and tune accordingly.
  • System administrator for Oracle E-Business Suite.
  • Scripts for Database cloning process without Private data

Confidential

IT Analyst

Responsibilities:

  • Developed automated notification generation for a particular data change or a particular event.
  • Redesigned the queries with analytical to performance and tuning.
  • Maintained a Web Based as well client/server application built using Developer-6i and Oracle Database
  • Developed GUI screens in Oracle Forms6i, Reports and triggers and stored procedures in PL/SQL.
  • Performed Unit testing, Integration Testing and System testing for the developed and new designed components of the application in both environments (Web and Client/Server).
  • Implemented in-house built security application.

Confidential

Oracle Programmer/Analyst

Responsibilities:

  • Maintenance and Designing forms using Oracle Forms 6i
  • Involve in Designing and Development of reports using Oracle Reports
  • Working PL/SQL Server Pages (PSP) to build a database driven web site

Confidential

Database Administrator

Responsibilities:

  • Designed, developed, implemented and supported multi-user applications
  • Re-engineered and migrated old software applications to Oracle Developer 2000
  • Prepared and updated technical and operational software documents
  • Trained Oracle developers

We'd love your feedback!