Dear Business Partner*, * We have very Urgent Opening-Immediate Closure. Send me your [Genuine] candidates resume and rate confirmation ASAP to* * bin...@boston-technology.com
* * Job title: Lead. Oracle DBA ** Duration: 6+ months Location: *Columbus**, Ohio* Pay Rate: $DOE/hr on C2C *Required Skills:* The resource selected for this project will work on production OAKS Business Intelligence Implementation technical support and enhancements pertaining to Oracle Database. Key Role Responsibilities Senior Oracle DBA with a strong background in managing several Oracle 10g RAC databases across multiple UNIX nodes hosting multi terabytes of data from various PeopleSoft application modules and data warehouse environments. In-depth knowledge of Oracle Database production support and performance tuning for applications running on Oracle-PeopleSoft platform. Knowledge of PeopleSoft infrastructure and database schema is desired. One of the major responsibilities is to maintain optimal performance of the database environment for the Business Intelligence application. Proficiency with the design and implementation of dimensions and star schemas, materialized views, database partitioning, various indexing techniques and additional performance tuning skills is highly desired to support the large data warehousing solutions. Skills / Experience required >5 Years of project experience required - Manage large Oracle 10g databases hosting various PeopleSoft modules (e.g. FINANCE, HCM and EPM) across multi-node (e.g. HP-UX) Oracle RAC clusters. For all the Skills / Experience required below greater than 10 years of project experience required. Perform production and non-production database environments' standard support activities and application SQL performance tuning. Design and implement materialized views by consolidating operational data from various data sources and organize them to a state which would help the data warehouse queries by avoiding resource intensive operations like summarization, aggregation, complex joins, etc. Leverage the power of DBMS_MVIEW package to assess the possibility of fast refresh of materialized views (MVs), tune the MVs, and validate the execution plans to ensure the implementation of query rewrite. Apply data compression techniques as appropriate to conserve space and optimize database performance. Develop automated procedures to perform mundane database maintenance tasks like statistics gathering, table shrinking, temp space utilization, index rebuilding, and special cases of statistics gathering using various combination of the METHOD_OPT option of the DBMS_STATS package. Install, upgrade, and configure Oracle CRS, RAC, and OEM GC software in compliance with the certification metrics across multiple servers on an on-going basis to proactively address issues with the vendor software. Must be proficient in tracking the quarterly CPU/PSU patches from Oracle and implement them across all environments in coordination with the end users. Implement fail-proof database backup and recovery procedures using RMAN and MML. Provide automated procedures to ensure successful completion of backup jobs and validation of backup sets to ensure their successful utilization during a recovery. Implement routine procedures to identify and process expired and obsolete backups. Track the runtime of the backup jobs and optimize them in compliance with the SLA. Implement database flashback recovery and allocate optimal disk space for the flashback logs. Perform database cloning using RMAN duplicate, transportable tablespace, and data pump across various Oracle RAC clusters. Integrate the capture and restore of PeopleSoft configuration data with the database cloning process to minimize the overall cloning time. Monitor the health, availability, and performance of databases using OEM Grid Control, and custom scripts. Configure appropriate metrics, UDM, monitoring templates, thresholds, alerts, corrective actions, and notifications to proactively diagnose potential database issues and resolve them before they impact the applications. Ensure the uninterrupted collection of target data by the management agents across all targets and implement procedures to analyze this data to perform trend analysis and minimize alerts by adjusting the values of various parameters and thresholds. Optimize resource utilization at the cluster level by leveraging various workload management options available with Oracle RAC architecture. Configure RAC services to distribute the application workload across available instances and optimize resource utilization across all available nodes. Configure TAF policies for RAC services to leverage the failover and connection load balancing capabilities. Maintain application performance at its peak level by capturing the wait events and resource intensive SQL statements from AWR and ASH reports. Perform root cause analysis on these items and implement appropriate measures to optimize them. Gather trace information by setting events like 10046, 10704, etc and process the trace files with the tkprof utility to analyze the wait events and the resource intensive SQL statements. Apply various SQL tuning techniques, data volume and distribution analysis, indexing options, join validations, pre summarization and aggregation of data, set-based processing, Top-N SQL, query rewrite, etc, to optimize such SQL statements. Investigate the occurrences of bind peeking in the database environments and resolve them by implementing SQL outlines and profiles. Capture AWR baselines at various stages of batch and online processing and compare them to identify the root cause behind the performance difference between a normal system response and a slower one. Design and implement disaster recovery environment using Oracle Data Guard, Data Guard Broker, and physical and logical standby databases. Monitor the archive log gaps in the standby environments and resolve them in compliance with the SLA. Perform load testing of database by creating and executing various testing scenarios representing the real life behavior of the PeopleSoft applications with high volume of data and transactions. Generate performance test reports isolating the resource intensive transactions. Analyze these statements in coordination with the functional team and recommend/implement appropriate tuning techniques to optimize the resource utilization and project realistic estimate of resource requirements in compliance with the SLA. Perform capacity planning for disk space used in databases by tracking the space growth every month, exploring opportunities to archive and purge historical data and plan for additional storage in advance to host the growing data. Design and implement partitioning of growing periodical data by adopting appropriate partitioning options available and construct automated procedures to maintain these partitions at regular intervals. Utilize available options to minimize downtime while performing partition maintenance activities. *Please send qualified candidates resumes with below details, which save time... * Candidate full Name: Contact Mobile #: Email id: Current location: Relocate/Commute to client location (YES/NO): Availability to join project: Candidate Date of Birth: (M/ D / Y): Rate: Candidate Visa/Work Status (H1B/GC/Citizen): How long you candidate Visa valid: How many years candidate having US experience? : Kindly let me know if you can go for in-person interview with client on your own expenses (YES/NO): Are you currently working on project or when did you complete your latest project: How many interviews attended in last 2 weeks and options likely? : Last 4 digits SSN No: Which company is holding you are H1B Visa? : Does Candidate have a car/license? : § Please send me 2 References of your recent project with their Name, Contact Info, Designation and Official Email Id. Reference # 1 Name:* * Phone No: E-mail contact: Reference # 2 Name:* * Phone No: E-mail contact: Please feel free to contact me for any further clarifications Thanks & Regards *Bindu Sagar* Resource Manager Phone No: 781-544-4799 ext: 112 Fax No: 508.519.9180 Boston Technology Corporation 33 Boston Post Road West, STE 110 Marlborough, MA-01752, USA bin...@boston-technology.com www.boston-technology.com *An Inc 500/5000 Company** Certified Minority Owned Business Enterprise (MBE) *Notice of Confidentiality: The information contained herein is intended only for the confidential use of the recipient. If the reader of this message is neither the intended recipient, nor the person responsible for delivering it to the intended recipient, you are hereby notified that you have received this communication in error, and that any review, dissemination, distribution, or copying of this communication is strictly prohibited. If you receive this in error, please notify the sender immediately by telephone, and destroy this e-mail message OR reply with the subject ” *REMOVE*” such that your email would be taken out of our distribution list. *** * **** -- You received this message because you are subscribed to the Google Groups "Oracle-Projects" group. To post to this group, send email to oracle-projects@googlegroups.com. To unsubscribe from this group, send email to oracle-projects+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/oracle-projects?hl=en.
