×

Loading...
Ad by
  • 最优利率和cashback可以申请特批,好信用好收入offer更好。请点链接扫码加微信咨询,Scotiabank -- Nick Zhang 6478812600。
Ad by
  • 最优利率和cashback可以申请特批,好信用好收入offer更好。请点链接扫码加微信咨询,Scotiabank -- Nick Zhang 6478812600。

Oracl DBA in US

本文发表在 rolia.net 枫下论坛Position Title: Data Base Administrator

Duties: Responsible for recommending, configuring computer hardware and software; and installing and maintaining computer software to meet the business requirements. Perform administration and operation of database management systems, (Oracle Enterprise Edition 9iR2 and 10g, (SQL Server and DB2 also desirable). Provide knowledge of Data Modeling, and Architecture. Provide technical assistance and knowledge on Oracle RAC, Oracle Internet Application Server and Oracle Identity Management and Internet Directory and Oracle XMLDB.
Required: Oracle Streams, Advanced Replication, Advanced Queuing (AQ), Oracle Workflow

Highly desired - 10g AS experience

- Strong technical writing, documentation development, and consulting skills are necessary
- High degree of initiative and the ability to work independently and follow-through on assignments
- Experience as a DBA for the full SDLC, from Development through to Production
- Experience developing and implementing Backup/Disaster Recovery & Business Continuity plans
- Experience with Oracle Developer Suite Tools, Oracle Warehouse builder and Workflow.
- Experience with Windows and UNIX (Solaris and Linux) operating systems as a charge DBA
- Experience with Oracle RAC, Oracle OID, Oracle OEM, Oracle IM, and Oracle iAS.
- Experience with Gateways and ETL processes for legacy systems integration and migration.
- Team-oriented individual with excellent interpersonal, planning, coordination, analytical, problem solving and decision-making skills.
- High degree of initiative and the ability to work independently and follow-through on assignments


Skills and Experience:
· 7-10 years experience as responsible DBA or 4 years of relevant experience.
· Oracle DBA with Oracle Enterprise Edition 9iR2/10g background (primarily 9iR2).
· Should have Legislative business background. Must have a solid background in writing SQL and stored procedures
· Important that candidate have solid general DBA experience, from development through production stages.
· This candidate should also have experience with setting up and maintaining replication, particularly with updateable snapshots and Oracle Real Application Clusters.
· Preferably, the DBA candidate will have good exposure to DB2 and SQL-Server

Required skills
- Databases: Oracle Enterprise Edition 10g/9iR2, Oracle Enterprise Manager and Oracle Real Application Clusters
- Metadata Modeling tools: Oracle Designer, Oracle Warehouse Builder and Oracle Work Flow
- Administration of: Oracle OLAP; Oracle Discoverer, Forms and Reports
- Database language: PLSQL and SQL
- Network: TCP/IP, Net8/9/10 and Oracle Network Directory, Oracle Internet Directory
- Internet/Intranet: Oracle Internet Application Server, Oracle Identity Management
- Advanced queuing
- Backup & Recovery strategies
- Participates in Disaster Recovery planning and implementation
- Participates in Capacity Planning and implementations
- Database Tuning,
- Database Security
- Startup and Shutdown of Databases,
- Performs physical and logical support of Metadata Repository
- Responsible for 24/7 Production Support
- Support ODS and Data warehouse Enterprise Data Store

Desired skills

- Operating System: Unix (Solaris/Linux) and Windows 2000/2003
- Jdeveloper
- XML (XMLDB)

Special Notes:

1. Utilizing Oracle Streams to capture source database objects and placing it in a queue at source to be propagated to a destination database
2. Utilizing Advanced Queuing for propagation scheduling of queues to destination databases and to create queue tables using Oracle Warehouse Builder or Oracle Enterprise Manager.
3. Utilizing Advanced Replication, specifically Materialized view replication and multi-master replication
4. Utilization of Oracle Text Manager using:
4.1 Context and Ctxcat indexes
4.2 Lexer
4.3 Stop and word list
4.4 Stored queries
4.5 Thesauri

Education, Certification & Training Experience
Bachelors Degree.
List of certifications and training to be included.
Experience training others would be a plus.

Contact:
wangjb@gtmsi.com更多精彩文章及讨论,请光临枫下论坛 rolia.net
Report