Database Administrator Resume
0/5 (Submit Your Rating)
Chicago, IL
SUMMARY
- Have 8 Years of experience as Oracle Applications DBA and Oracle DBA.me seek an opportunity dat can provide challenging Oracle Applications, Database and FMW environments where me can use my current expertise and also be able to advance my skills.
- Oracle E - Business Suite administration EBS and database upgrades from multiple versions to teh latest versions in multiple platforms.
- Oracle E-Business Suite administration EBS 11i, R 12 12.1 / 12.2 involving Oracle E-Business Suite cloning, patching, user administration, application upgrades and troubleshooting developer, functional and business user issues.
- Oracle Database administration (installation, backup configuration using RMAN, applying security updates and bug fixes, upgrades, cloning and user administration) of 9i/10g/11g/12c on RAC and ASM.
- Experienced in Space Management, Query Tuning and Application Tuning Cloned Oracle applications R12.
- Leading and managing teh offshore / Onsite model with 24 X 7 Production support.
- Experience of handling OLTP and DATAWAREHOUSING databases ranging up to 12 TB.
- Installation, Configuration, set up replication process and maintenance of Gloden Gate.
- Experience in installation and administering Oracle Fusion middleware technologies (SOA,BPEL,HYPERION)
- Experience in configuring and managing OBIEE applications.
- Performance monitoring and tuning of Database and SQLs.
- Automated several routine DBA tasks and schedule jobs in CRON.
- Proficient in using 11g/12c Oracle Enterprise Manager
- Weblogic server maintenance and troubleshooting.
- Knowledge of Oracle Application Server, SSO, OID, LDAP.
- Working with Oracle Support for Bug fixes by raising TAR/SRs.
- Experience of maintaining MS Sqlserver, Informix databases
TECHNICAL SKILLS
ERP: E-Business Suite R12.2.4, R12.1.3, 11.5.10.2, 11.5.9.
DATABASE: 9i, 10g, 11g, 12C
DB Management: TOAD, OEM 11gR2/ 12c.
Operating Systems: RHEL, Solaris 5.9/5.10, AIX 6.1/7.1, HP-UX, Windows, AWS
BI/Reporting tools: OBIEE 11.1.1.5
Tuning Tools: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ASH, ADDM, SQLT
Programming: UNIX shell Programming (Bourne, corn), SQL, PL/SQL, HTML
PROFESSIONAL EXPERIENCE
Database administrator
Confidential, Chicago, IL
Responsibilities:
- Database and application noledge transfer planning.
- Gathering database requirements for implementation, customization of applications.
- Designing server, database architecture to deploy applications.
- Configuring backup and recovery policies as per Oracle standards.
- Installation and creation of Oracle 11G databases.
- Troubleshooting database issues and implementing monitoring of teh entire environment.
- Working with Development team to assist database activities.
Confidential, Ft. Worth, TX
Responsibilities:
- Upgraded teh Applications from 11.5.10.2 to R12.2.4
- Upgraded teh database from 11.2.0.2 to 11.2.0.4
- Worked extensively on concurrent programs tuning and database tuning.
- Applied patches using ADOP with different adop options
- Database and application Clones from Prod to Test environments
- Setup new Dataguard Environments, Managing and Monitoring and troubleshootingto resolve teh issues.
- Implemented Auditing alerts for new user creation, Responsibility Assignment in controlled environment using PL/SQL.
- Maintaining and Troubleshooting Exadata Cell/Storage and DB/Compute node performance issues.
- Troubleshooting Exadata smartscan/offloading issues
- ImplementedOracle database backup & recovery solutions using RMAN.
- Extensive use ofOracle Data pumps Exports/Imports utilityfor moving data among teh servers.
- Creating Application Users, Profiles, Responsibilities, Menus, Functions for teh user.
- Analyzing teh E-Business suite patches using Patch wizard.
- Database and Schema refreshes.
- Configuring Gloden Gate and maintenance.
- Continuous Performance monitoring and Database Tuning and application using OEM.
- Worked on web logic server’s maintenance and trouble shooting.
- Automated several manual tasks from crontab.
- Creating SRs and worked extensively with Oracle Support to resolve issues.
- Worked on Quarterly password changes.
Confidential
Responsibilities:
- Application (E-Business Suit) upgrade from 12.1.2 to 12.1.3+.
- Database upgrade from 11.2.0.3 to 11.2.0.4.
- OEM 12c upgrade from 12.1.0.2 to 12.1.0.3.
- Installation of 11.2.0.4 GI (ASM standalone database)
- Application of application patches using adpatch.
- Installation and maintenance of oracle fusion middleware (SOA,BPEL,Hyperion)
- Integration of Oracle Retail suit with EBS.
- Analyzing, planning and applying of CPU patches released every quarter.
- Performing application and database clones up on request.
- Maintenance of Physical standby using Data Guard.
- Working on regular issues raised by users through BMC.
- Worked on Backup optimizations as per teh client requirements.
- Performed DR test during teh Annual BCP drill.
- Installation and configuration of OEM 12c OMS and it agents
- Setup OEM metrics to all teh Environments through OEM.
- Worked on quarterly password changes.
- Preparing of all teh metrics report related to service we do
- Migration of storage from older to faster disks
- Managing of ASM, its disks and disk groups and creating them as per Business Requirement.
- Performing of schema refreshes using datapump.
- Performing backup and recovery using RMAN.
- Experience in handling large RAC databases.
- Automated several routine tasks - Automating cold/hot backup, Monitoring scripts - tablespace alerts, validating backup and alerting DBAs in case of backup failures.
- Troubleshooting forms server, Apache server issues
- Performing PRODUCTION maintenance activities during weekend.
- Purging unwanted log and out files and shrinking data files..
- Experience in using patch wizard.
Confidential, Brea CA
Responsibilities:
- Administration and monitoring of RAC Databases and EBS application.
- Patch Application including Patch analysis using adpatch.
- Performing clone as per teh requests using rapid clone.
- Managing and Monitoring of various databases using OEM 12c.
- Monitoring teh Automated refresh of TRB instances daily.
- Working on Concurrent request issues which are submitted through Tidal.
- Backup and recovery using RMAN and hot as well as cold.
- Working on weekly schema refreshes using Datapump.
- Creating SRs and worked extensively with Oracle Support to resolve issues.
- Configuring database user, profiles and roles.
- Exposure of Automatic Storage Management (ASM)
- Supporting issues related to OBIEE DAC and Informatica.
- Working with Third party applications like clearorbit, vertex, webtogo.
- Active support to different teams based on Remedy ticketing tool.
- Attend regular PROD issues through REACT calls.
- Monitoring Standby databases (Dataguard) regularly.
- Worked on Quarterly password changes.
Confidential
Responsibilities:
- Developed standards for directory structures on brand new UNIX boxes.
- Oracle Software Installation.
- Created a number of database instances for development, testing and production.
- Moved databases between machines.
- Attended teh regular issues related to db/environment.
- Backup configuration, monitoring and schedules using RMAN and Hot backups.
- Involved in Production Database Upgradation from 9i to 10g.
- DataGuard configuration and maintenance.
- Documented tasks in coordination with onsite team.
- Regular database activities, backups monitoring, issues resolving.
- Created number of new schemas and maintained privileges.
- Performed number of schema refreshes from production to test to dev using exp/imp.
- Migrated databases between machines.
- Installed patch sets and upgraded Oracle (RDBMS).
- Support of RAC and ASM databases.
- New environment creation, configuration and maintenance.
- Cloning of Oracle Apps Databases/Environments.
- Reactive issue resolution.
- Troubleshooting all Oracle Apps Issues like Forms, Apache, CM, and Workflow.
- Patch application - Including thorough Patch analysis.
- Resolved configuration issues raised by development teams.
- Administration by using AD Utilities.
- Application of Quarterly release of Oracle Critical Patch Updates to Oracle Application Databases.
- Managing Oracle Applications user accounts.
- User account management - creating users, disabling users, responsibility management.
- Managing concurrent managers -ensure system is running smooth, monitoring throughput, watch for long runners.
- Installed Greek, Italy and Chinese languages in test, dev and production Apps database.
- Performed sysadmin tasks as per teh requirement.
- Copying new forms, reports, custom code to production environment from Development.
- Worked on Oracle Apps Upgrade project from 11.5.9 to 11.5.10.2 and Brazil Localizations.
- Worked on password changes of apps, sys, system and specialized users every quarter in TEST, DEV and PROD.
- Documented tasks in coordination with onsite team.
- Decommission of Application instances.
- Installed new Product TOPS as per business requirement.
- Applied DST Patches (Day Light Saving Patches).
- Analysis and Application of quarterly CPU Patches in TEST, DEV and PROD instances.
- Workflow setup for teh Application instances.
- Worked on J2EE and HTTP server application maintenance for DTC Project.
- Maintenance of Application server - Deployments, web server management, application management etc.