| Job Title: |
|
Oracle DBA |
| Category: |
|
Software Development |
| Job For: |
|
Alumni |
| Total Positions: |
|
1 |
| Job Location: |
|
Karachi |
| Gender: |
|
Both |
| Minimum Education: |
|
Bachelors |
| Degree Title: |
|
BSCS |
| Career Level: |
|
Experienced Professional |
| Minimum Experience: |
|
5 Years |
| Required Travel: |
|
25% |
| Salary Range: |
|
PKR 0 to 0 per Month |
| Apply By: |
|
Jan 19, 2015 |
| |
|
|
| |
|
|
|
|
| Job Description: |
JOB DESCRIPTION
- Capacity planning for hardware and software in the configuration and implementation of Oracle e-Business Suite 11i/R12
- Knowledge of Application Modules Set-up and Implementation (Order Management, Discrete Manufacturing, Financials, Advance Pricing, Advance Planning etc.)
- Complete Knowledge of system Admin Modules (FND, AD, APPLSYS, ICX..etc)
- Optimizing Application Module Processing and Screens (e.g. Order processing and Workbench).
- Set-up Customization Environment (Required extensive security and standards)
- Up-grading Modules to latest patch level using Mini-Pack and Maintenance Pack Patches
- Installing Oracle Application 11i/R12 using Rapid wiz in multi-node architecture.
- Building Multiple Test Instance using Oracle Application Cloning Process (Required to run Rapid Wiz Installation and set-up Source and Target instance to prepare for Cloning Process)
- Cloning Oracle application/Database using ADCLONE and Rapid clone with/without AutoConfig to create new TEST/PROD Instance.
- Up-grading Oracle Application to latest patch level using Maintenance Patch
- Developed custom interface programs for conversion legacy data into oracle application 11i/R12
- Maintaining Custom Interface to migrate Data in Oracle Application from other system
- Implementing Comprehensive Backup/Restore mechanism and data replication.
- Implemented Maximum Availability Architecture (MAA) using oracle Failsafe/RAC (Real Application Cluster) and Disaster Recovery (DR) using Standby DB mechanism
- Configuration of Recovery Manager (RMAN) for Online Backup
- Maintaining security system on Application level, Database level as well as Operating system Level.
- Implemented user and network security and auditing in Oracle Application.
- Performance tuning monitoring of the Oracle Application, Database and Unix kernel parameters
- Database Space Management and Pinning Objects
- Analyzing Schema (Gather Schema Statistics)
- Optimizing Table and Index Partitioning
- Troubleshooting Oracle Application Performance/Tuning Issues.
- Configure OEM 10g/11g/12c for Application (specially Concurrent Manager) and Database Monitoring
- 3rd Party Software for System and Application Monitor
- Shell scripts for automatic startup and shutdown of Databases as well as automated backups, session waits and locks and snapshot refreshes and load multiple data files.
- Automated daily Database, Application, and System health monitor with some kind of notification (Pager, Email, Mobile)
- Performing DBA activities such as Security Management, Space Management, User and Responsibility set-up, Performance Tuning Monitoring, Concurrent Manager Monitor, defining printers, and setup Oracle Alerts/Auditing
- Managing Oracle Applications Security
- Data Auditing and user
- Managing Concurrent Programs and Reports
- Managing Concurrent Processing
- Setting-up Multiple Currency
- Setting-up Multiple Languages
- Maintaining User, System and Custom Profiles
- Knowledge of ALL Oracle backup and recovery scenarios.
- Good understanding of the Oracle database, related utilities and tools.
- Must have RMAN hands-on in all Backup / Recovery scenarios.
REREQUIRED EXPERIENCE AND SKILL SET
- 5+ Years of IT Experience as an Oracle DBA core and APPS DBA in a UNIX or Linux / Windows environment
- Experience with secure data transfer and secure schemas.
- Develop, review and enforce database standards.
- Strong experience in Backup and Recovery of large databases.
- Expertise in Oracle database performance tuning and troubleshooting.
- Ability to document database performance issues and also help team mates understand the resolution process.
- Able to work independently
- Able to support US/Canada customers, expected to work late.
- Willing to travel in short notice, national / international
- Ability to work on multiple projects/issues simultaneously
- Excellent Communication Skills
|
| Required Skills: |
| Ada, OWL, SAS, Windows, Oracle, iOS, Unix, WAI, NDepend |
| Company Information |
|
|
Company Name: 7NSoft Systems (Pvt) Ltd
Company Description:
Legacy to the Cloud
Founded in 2004 by visionaries from leading technology organizations, MLOGICA’s leaders envisioned a faster, more efficient way of modernizing IT infrastructures to eliminate the skyrocketing costs of legacy systems that had stymied innovation and eaten away at enterprise profitability for years. They also realized modernization offered their customers the opportunity to harness the power of globally dispersed data to build revenue.
mission is to assist its customers in driving enterprise profitability through advanced analytics and Cloud modernization. Helping customers unravel the complexities of migrating mission-critical, enterprise applications, databases, infrastructure, and data—while saving them time, money and business disruption is how we do it.
|
|
