|
Click here For
IT Training |
| Job Title: | oracle DBA with cognos Exp | |||
| Job Ref No: | 14353-0215 |
|
||
| Job State: | New York | |||
| City: | Water Street | |||
| Job Posted Date: | 2/22/2012 | |||
| Job Description: | Hi, Since this is an urgent business requirement, I’d appreciate a prompt response on this. Position: oracle DBA Location: Water Street, NY MUST HAVE COGNOS EXPERIENCE The data warehouse application DBA has specialized DBA skills relating to the administration and management of a large database with an analytical front-end. The DBA will be focused on the care and feeding of an Oracle RDBMS system to ensure that processing is consistent and performance is maintained regardless of the circumstances. The DBA will be typically responsible for establishing table structures, configuring databases, reviewing and designing queries and execution jobs to efficiently utilize the system, participating in the design and creation of relational database objects such as tables, views and indexes; regular support and maintenance tasks such as database security, recovery, backup, monitoring, and reorganizations. Key skills include: § Relevant work experience and effective communications skills within a minimum of five years of full-time, progressive experience with an Oracle relational database system in a DBA role § Ability to understand manage application workload and ensure consistent response times § Ability to analyze and monitor batch queries and/or ad-hoc queries across the system § Communicate with the system DBA in support of instance parameterization, instance creation, datafiles, rollback segments and tablespaces and monitoring of instance resources to ensure continuous database operations (disk media, CPU, memory, network and I/O contention) § Perform data warehouse administration including: o Perform storage capacity planning and related database storage activities, including media disk space procurement o Implement, maintain, and test backup / recovery strategies o Implement and review security guidelines/mechanisms o Create instances and databases with appropriate initialization parameters and database structures (i.e., datafiles, rollback segments, tablespaces, etc.) o Review and monitor system and instance resources to insure continuous database operations (i.e. memory, CPU, network usage, and I/O contention) o Perform database upgrades/migrations o Evaluate and test new features/functionality o Create relational database objects such as tables, views, and indexes in adherence to corporate-wide naming conventions and assign user access accordingly o Support and maintaining the environment a relational database requires to properly function (i.e., as database security, recovery, backup, monitoring, and reorganizations) o Ensure Referential Integrity (RI) where applicable. The application DBA will be directly involved with the formulation and testing of the RI rules. o Participate in application performance tuning and testing § Perform job executions, including: o Scheduled execution − Fire-off job streams at pre-determined times, with pre-defined prerequisite conditions. Ensure that a "missed" job is re-scheduled o Conditional execution − execute this task based on the status of completed tasks o Error alerts and job stream validation − the DBA will need to define the scope of everything that might go-wrong and create user-exits to pause execution until important issues are resolved § Design and management of partitioning, materialized views, star schema, and indexing techniques including Bitmap indexes § Experience of working with VLDB, in the range of 3TB and over § Experience with Unix Shell scripting § Participating in database migration reviews § Assist application developers in functional prototyping § Providing technical assistance to other team members and database walkthroughs in the life cycle of the project § Solid understanding of multi-dimensional data models and BI tools such as Cognos § Responsible for instance and data access statistics collection and reporting Let me know the below details as well: 1. Full Name: 2. Current Location: 3. Phone: 4. Email: 5. Visa (Citizen / GC/ TN / H1) − (If H1, please do give Employer Details and H1 Validity date) 6. Rate per hour on W2 or Corp to Corp: (We usually prefer W2 or Corp to Corp instead of 1099) 7. Availability: 8. Relocation: 9. Relevant Exp: 10. Best time to schedule an interview with client: Nagesh Subhashini Software Solutions, Inc. ______________________________ |
|||
| Share This Job: | ||||
|
|
||||
 |
||||
|
Follow Us On :    '
|
|
| About us | Contact us | Feedback | Link to Us | Link Partners| Advertise With us | Buy Banner spot | Site Map Terms and Conditions | Privacy Policy | |
|
Copyrights © 2013 Benchfolks All rights reserved. Serving IT community since 2006 All product names are trademarks of their respective companies. BenchFolks is not a Consultancy nor a Consulting Company nor a Training Company nor a H1B Sponsors Benchfolks.com is not affiliated with or endorsed by any company listed at this site. |
|