Vacancy expired!
- This DBA consulting resource should also have special skills in maintaining Database Security, Data Masking of sensitive data and Backup & Recovery.
- Use of Oracle's Flashback feature
- Experience with Dataguard
- 4-6 years' experience: Database Design, Database security, Oracle, Current Database Technology, Database Administration, Database management, Oracle Database Management, Oracle DBA
- This consulting position will be working on, currently in progress, PeopleSoft Application Upgrade Project.
- During this project, consultant will work on the PeopleSoft Upgrade & the Oracle Enterprise Manager Upgrade projects. Both are part of PeopleSoft Application Upgrade project. BSC's PeopleSoft Database Administration team, at present, manages and supports 140 PeopleSoft databases and its related databases. Oracle Enterprise Manager (OEM) monitors these databases.
- Install, upgrade, and patch Oracle engine and related Oracle tools as necessary in conjunction with Midrange Technical Support.
- Monitor database performance and tune instances as necessary.
- Monitor database and listener availability to ensure maximum uptime.
- Assess and act on alert log messages including investigation, contacting Oracle Support and referral to other groups as necessary.
- Perform high-level security functions, including securing system user accounts and main application schema accounts.
- Maintain security permissions on Oracle owned operating system files.
- Manage table spaces, control files, redo logs and other physical components of the database.
- Maintain parameter and configuration files including database initialization parameter (pfile/spfile) files, and TNS configuration files.
- Develop, test and document DB backup/recovery and disaster recovery procedures. Perform DB recovery as needed.
- Copy/clone production DBS into non-production environments.
- Develop and maintain UNIX shell scripts to set Oracle environment variables, create/remove DBS, startup and shutdown instances, start and stop listeners; move and/or compress archive redo logs, remove aged Oracle log and trace files, scan alert logs to issue Email notifications of Oracle errors and to identify unplanned resource outages, ensure high availability failover of Oracle resources (e.g., HP Service Guard and IBM HACMP) in conjunction with Tech Support.
- Maintain Database Security using Datamasking, Transparent Data Encryption(TDE), and TNS Network Security
- Database Cloning using RMAN
Vacancy expired!