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.
• 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.
• 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 resume : gunjan.saxena@flairsoft.net
Gunjan
Flairsoft Limited
Office : 614-375-4490
You received this message because you are subscribed to the Google Groups "US IT SOLUTIONS" group.
To post to this group, send email to us-it-solutions@googlegroups.com.
To unsubscribe from this group, send email to us-it-solutions+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/us-it-solutions?hl=en.
No comments:
Post a Comment