Top MNC Jobs

Database Performance Engineering Lead Leading Product Based Company In Kalyani Nagar Pune Jobs

Job Details
Role Responsibilities:
€Analyse designs of legacy and in-development databases for performance problems and suggest design improvements accordingly
€Build a library of knowledge on the databases in use in all applications that are in scope for performance testing and engineering
€Perform query execution analysis and provide fixes for poorly performing queries on the application critical path
€Provide guidance and support to project teams including architects, developers, and DBAs on high-performance, efficient, and scalable database design, jobs, and queries.
€Participate in performance testing of applications and assist with analysing operational database issues encountered during testing.
€Provide guidance on data strategy and mechanisms for loading data in the test environments as per the test requirements.
Candidate Requirements:

€Must be willing to work in shifts (timings: 2.00 PM €“ 11.00 PM)
€Certified Professional Database 11g
€At least 5 years€™ experience as a DBA with extensive experience of tuning database
€At least 5 years previous experience developing PL/SQL and SQL
€Specific knowledge of Oracle internals including the ability to analyse raw trace files from SQL extended session trace
€Advanced SQL design authoring
€Database design, 3NF and ERD experience
€Oracle OCI knowledge
€Good solid Linux shell scripting
€Experience of load simulation tools
€Should be able to read and interpret raw SQL trace files
€Understand the impact of parallelism on the database
€Understand how CBO chooses its path & how histograms and bind variable peeking can influence query execution.
€Understand the difference between an execution plan which utilises nested loops in favour or hash joins
€Advanced SQL experience and expertise tuning an individual SQL statements from information gained from wait event analysis in trace.
€Excellent Written and Oral Skills
€Ability to work flexible schedules and be on-call
Qualities Needed for This Jobs
Database Performance Tuning, Pl Sql Development, Database Design, Db Design, Query Optimization
Want latest jobs alert?
Candidate Profile
This Requirement Is For A Database Performance Engineering Lead Who Would Be Responsible To Deliver The Best-in-class Product Experience To Their Customers.
Looking for Bachelor Of Technology (b.tech/b.e),master In Computer Application (m.c.a),masters In Technology (m.tech/m.e/m.sc) graduates profile.
Sample Placement PapersT
More Information
Location Pune , Maharashtra
Education Bachelor Of Technology (b.tech/b.e),master In Computer Application (m.c.a),masters In Technology (m.tech/m.e/m.sc)
Experience 8 (yrs)
Industry Computers / IT
Job Type : Full-time
Download Seventh Contact Hiring Solutions Placement Papers and Interview Questions
Advertisements
How to Apply
Post Resume Free

Similar Jobs to Database Performance Engineering Lead Leading Product Based Company In Kalyani Nagar Pune Jobs

Contact Us Terms of Services Privacy Policy

Follow us on : Find us on Facebook Find us on Twitter 

YuvaJobs.com - All Rights Reserved
Click Here Post Your Resume Free !