[Lovers India] Urgent Client Position :::: Oracle DBA Consultant :::: Downtown Chicago, IL

Hi,

Hope you are doing good. Please find the below job description and let me know your interest ASAP.

Bourntec is currently seeking Oracle DBA Consultant to join our client team in Chicago , IL. 

Location:                    Downtown Chicago, IL
Duration:                    6 month contract
Job#                           18096-1

This position is more niche with the performance piece

The candidate for this position must possess the following skills and traits:

• In-depth knowledge of the Oracle optimizer and statistics (how statistics influence the optimizer, best way to gather statistics, timing of when to gather statistics, differences in 10g and 11g)
• Ability to drill down to root cause of Oracle database performance issues - considerations include Oracle wait events, SQL plan changes, blocking, I/O, network bandwidth, etc.
• Ability to anticipate performance issues given projected system growth, variations of data load, user volume, etc.
• Understanding of how database configuration choices (i.e. swap size, memory) can later influence database performance.
• Recommend / Coordinate / Implement database configuration changes
• Expert at writing, debugging and tuning complex SQL and understands the best ways to incorporate database requests into application programs.
• Strong proponent of following defined processes and procedures (e.g. change management)
• Proficiency with:
- AWR (Automatic Workload Repository) to determine system level performance issues such as buffer busy, latches and enqueues, cluster related findings, I/O related findings.
- ADDM (Automatic Database Diagnostic Monitor) to see the Top SQL which are causing performance issues, along with the ability to make suggestions for improvements
- ASH (Active Session History) to help determine 'Transient performance related issues'.
• Optimize the performance of the database by ensuring the best possible database throughput and response time.
• After orientation, the candidate must be able to accomplish the assigned work independently. Weekly touch points are required with the assigned Northern Trust manager to determine progress and sticking points, but a qualified candidate will be self-driven and motivated to find and resolve issues.
• Knowledge of all Oracle backup and recovery scenarios.
• Operate with continuous process improvement mentality - review -> analyze -> improve -> start over
• Excellent communication skills with management, development teams, vendors and systems administrators. The candidate must be able to lead discussions, record meeting minutes, determine and assign action items and distribute the meeting minutes in a timely manner.
• Proven ability to influence Application teams through mentoring and education in adopting best practices for database development.
• Ability to handle multiple projects and deadlines.

OTHER:
- Candidates must work on-site. After an initial training period, there may be some flexibiliy for working remotely, though the majority of the days on assignment will still be completed on-site.
- This is a six month position that could be extended if job performance and business needs justify a longer assignment.

 

Thanks & Regards,

Sandeep Reddy

Bourntec Solutions Inc.,
1701 East Wood field Road, Suite 636, Schaumburg, IL - 60173
Direct: 847 805 6373,
Board: 224 232 5090 Ext 6239
sandeep@bourntec.com | www.bourntec.com

This message is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by e-mail or telephone, and delete the original message immediately. 

 

 

--
--
You received this message because you are subscribed to the Google
Groups "Lovers India" group.
To post to this group, send email to loversindia@googlegroups.com
To unsubscribe from this group, send email to
loversindia+unsubscribe@googlegroups.com
http://groups.google.co.in/group/loversindia
 
---
You received this message because you are subscribed to the Google Groups "Lovers India" group.
To unsubscribe from this group and stop receiving emails from it, send an email to loversindia+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.