|
|
| Company: |
SimSan Global Solutions Inc, |
|
| Job Title: |
Oracle Administrator/DBA |
| Job category: |
Information Technology |
| Job Location: |
USA |
| Job Reference Number: |
SGS-ODBA002 |
| Job Description: |
Oracle Admin / DBA
Position Id: SGS-ODBA002 Description: As part of our Enterprise team, you will be responsible as the development Database Administrator (DBA) for an Oracle Data Warehouse. In this role, you will design, implement, perform tuning, support the physical database structures, and document the integrated reporting repositories in support of Business Intelligence reporting environment. The `best fit` candidate will have advanced knowledge of data warehouse implementation strategies, design physical data models, automate ETL processes.
Project tasks will include excellent Oracle PL/SQL programming skills, Unix Shell Scripting, implement data conversion processes, review and make recommendations for ETL procedures, and have end user communications. Candidate must be able to participate, review, and critique logical, physical, and dimensional data models. In this role, you will partner with the DWH Architect/Oracle Data Warehouse Logical DBA to obtain and document business and data process flows.
Responsibilities:
- Work with a development team to perform performance analysis and tuning: add indexes, create partitions and materialized views, set analyze strategies for gathering statistics, adjust redo log sizes, etc. - Develop data models and perform planning of architecture, functions, modules, recovery, standards and implementation.
- Design/build summary tables; - Monitor space usage.
- Perform schema maintenance as required.
- Create/propose database security rules.
- Create/propose schemas to support one-time data cleansing/fix efforts.
- Focus on the interface of the database with the Business Intelligence query tools.
- Assist the Data Center with recoveries.
- Perform periodic data reorganization.
- Review and document current environment
- Review design documentation for compliance with requirements
- Identify process changes; design and help implement revised processes
- Help drive consensus on areas of required commonality
- Assist with preparation and delivery of communications to end-users
- Identify and design security for related to end-user reporting
Required Technical Skills and Experience :
- 4+ years in Information Technology Experience - 2+ years of Data Warehouse Database Administration experience, skilled in physical database design, performance tuning, SQL development, Unix scripting, stored procedures, triggers, views, capacity planning, and trouble shooting.
- 2+ years Oracle DBA experience with Oracle 9i, 10g with Real Application Clusters (RAC) and ASM, 11g - Installing, configuring & patching Oracle software versions 10g & 11g
- Experience managing Oracle Applications ERP preferred - 2 + years of experience with business intelligence and ETL (Extract, Transform, Load) - Knowledge of Windows and UNIX/Linux OS platforms and file system management skills - Knowledge of Unix shell / Perl scripting. - Security management and how Oracle enforces integrity. - Datawarehousing and tuning experience in Cognos would be a plus. - Exceptional oral and written communication skills and Strong presentation skills
- MS Office, MS Outlook, MS Project, Visio, Clarity (Niku), CA Service Desk
- Ability to create, document and implement repeatable processes
- Ability to efficiently manage multiple tasks
- Work with a diverse group including users, developers, etc.
- Work in a fast paced environment
- Establish, follow and enforce documentation standards
- Capable of being both an individual contributor and working as part of a team.
- Proactive personality with a proven track record of delivering on responsibilities and tasks.
- Highly adaptive with an ability to organize, coordinate, and execute on details.
- Willingness to work in a team environment, and in a proactive manner
Education Required:
- Bachelors Degree in computer science or related technical field (or equivalent work experience).
|
Language Requirements: |
English-Very Good |
| Employment Type: |
Full Time |
| Yearly Salary: |
Unspecified |
| Posting Date: |
2008-10-30 |
| Level of Education: |
Masters |
| Years of Work Experience: |
3 to 5 Years |
| Company: |
SimSan Global Solutions Inc, |
| Contact Name: |
SimSan Global Solutions Inc, |
| Contact Phone: |
18177987614 |
| Preferred Method of Contact: |
E-mail |
| Preferred Language of Resume/Application: |
English |
|
|
|
