Dba And Technical Specialist Resume Profile
SUMMARY
- More Than 8 years of DBA for Oracle EBS, Oracle Hyperion planning and Oracle data warehouse.
- DBA and technical specialist with about 1 years of PeopleSoft based application experience. My knowledge on PeopleSoft is on both technical and functional experience, I have experienced with PeopleSoft HRMS 8.8 / 9.0 / 9.1 / 9.2 applications and Integration Tools. Possess good analytical and problem solving skills.
Professional Skills
- Project management
- Meet Business partners and understand Business requirements
- Plan tcollect, analysis and consult Business requirements included non functional requirements
- Submit documentation and review Business requirements with Project Manager/Head of IT
- Walk through Business requirements and relevant development documentation with Development team
- create business cases and system scenarios
- Support development team during coding, testing and request for change
- Communicate, manage Business partners on testing plan and sign off UAT User Acceptance Test
- Follow and update issues, problems that can impact Business requirements and systems
- Prepare weekly report update on Business requirements statuses tProject Manager/Head of IT
- Complete User manual/guide for Business requirements and systems
- Administrator Operation System
- Microsoft Windows 2008/2003/2000
- Red hat, OEL Oracle Enterprise Linux , Cent OS
- Administrator Database Server
- DBA for Oracle database 8i, 9i, 10g, 11g
- MS SQL server 2005, 2008
- MySQL
- Essbase database administrator multidimensional database
- Tuning performance database
- Database Tools
- Automatic Workload Repository AWR
- Recovery Manager RMAN
- Remote Diagnostic Agent RDA
- The Lite Onboard Monitor LTOM
- Enterprise Manager EM
- ADDM,
- SQLPlus
- Toad
- System Analysis and Design
- Communication and interpersonal skills
- Analyze design model database
- write function, procedure, package, trigger on database for applications
- optimal sql statement timprove performance database
- Database Design, Database Modeling and Data Warehousing
- Administering User and Security in Oracle database server and MS SQL server
- Managing Database Storage Structures and Performance Management
- Backup and recovery database
- Development Tools:
- Oracle Form, Oracle Report, PL/SQL Developer, SQL Developer
- Use ODI Oracle data integrator tETL data from different source tdata warehouse
- Oracle Business Intelligence OBIEE
- Peoplesoft: application disigner
- Exposure on interface design with Application Designer
- Experience on doing requirement gathering / fit gap analysis from user
- Have experience in documented documentation follow the CMMI Level 3 standard
Present Employment
Company Name | : | Confidential |
Position Title | : | DBA and Technical Specialist |
Employment History
Confidential
Dona Orient is a corporation specializing in the production
Responsibilities Includes:
I had develop and administrator :
- Window server 2003
- Administration for mail server exchange 2003
- Oracle database 8i
- Backup daily database and applications
- Management users of application.
- Developer with Oracle form and Oracle Report 6i
Business Analyst:
- Get requests from accounting department, HR dept,
- Consulting solutions are suitable for professional
- ERP software management:
- HR module
- PR module
- MI module
- AP module
- Confidential
Responsibilities Includes:
Collect requirements from design studios across the manuscript about a new web product. meeting with the designer, programmers department tfind the optimal solution and adjusted tfit the description of the original design
Administator and programmer:
- Administration of Oracle 10g database
- Analysis of design design and database develop Oracle 10g and mysql
- Writing materials analysis and design Database
- Optimize and turning the query toptimize speed for database.
- Provide solutions tthe Database for the web application company
- Write Store Procedure, Trigger, Function, jobs
- Look at the new technology of search engine for web search
- Responsible for backup and recover the database tOracle 10g
- Observed performance of the database tdetect problems slow down the database and provide solutions.
Confidential
Responsibilities Includes:
Oracle database 11g administrator
- Administration Oracle application
- Configure Oracle standby database
- Integrate data from any source tthis application.
- Clone application from Production tDEV, TEST, UAT environment
- Develop Oracle report builder customize report for my company .
- Monitor and tunning this system.
- I participated tbuild Data warehouse:
- Participate in construction projects Budget Planning system
Business Analyst:
- Get requirements, write documentation
- Contact with partner tclear all the requirements of end user and implement it on system application.
- Track and report project progress each week between the end user and development team.
Confidential
Work Description:
- Oracle database 10g, 11g, 12c administrator
- Installation and configuration Peoplesoft application
- Integrate data from any source tthis application
- Apply patch and bundle for application.
- Tuning performent for database and application.
- Participate in projects
ParkWay hospital:
Using Change Assistant tool tapply patch and bundle
PIL company:
- Tuning performance for Oracle database and SQL query of payroll.
- Support write report for peoplesoft by Crystal report
RHB Bank
- Design technical system architecture for peoplesoft HCM 9.2
- Installation Oracle database
- Installation Peopletool 8.53.13
- Installation Peoplesoft HCM 9.2
- Installing peoplesoft Change Assistant
- Installing web server weblogic
- Configuration Application
- Configuring Integration between peoplesoft peopletools and Oracle DB
- Setting up the peoplesoft Pure Internet Architecture PIA
- Setting up process scheduler on Linux
- Installing and compiling COBOL on linux
- Apply patch and bundle for peopletool 8.53 and peoplesoft HCM 9.2
- Backup and Clone DMO, DEV, UAT, SIT and PRD environment