Oracle Database Administrator Resume
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