Sql Query Performance Tuning Analysts - Bangalore - Krishna Jyothi Info
Krishna Jyothi Info as the company that open the jobs vacancy, have some qualification and spesification especially for the Sql Query Performance Tuning Analysts jobs vacancy. To find out more information and about qualification and spesification details, walkin interview schedule, the address of the company, the company contact info (email/phone number) of Krishna Jyothi Info company, please start to apply for the job vacancy with fill the jobs application with click the 'Apply This Job' button below.
Please find below are the Job Details:
Job Title: SQL Query Performance Tuning Analysts
Client: DB Ace Technologies
Work Location: Hosur Road, Bengaluru
Position Type: Full Time
Start Date: ASAP (Notice Period Must be less than 1 Month)
Experience Range: 3 to 8 Years
Salary Range: 5 to 10 Lakhs Per Annum
No of Positions: 10
- 3 to 8 years as an Oracle Application (PL/SQL) Developer and/or DBA. Ideal candidate will have the right blend of these two skills.
- 2+ years as a DB Performance Analyst and/or SQL Tuner
- Experience with Oracle 11g, 12c, Grid OEM
- Performance Management – troubleshooting, tuning, performance analysis and pro-active monitoring, optimization of database driven applications
- Expert knowledge in AWR, ASH, ADDM reports.
- Proven expertise in optimization of Oracle SQL Queries.
- Apply tools and technologies to optimize production setup by tuning DB parameters
- Provide on-call support for any urgent performance issues in production environment.
- Carry out root cause analysis of Database/SQL performance problems and recommend a solution for Production as well as Release environments
- Periodically Monitor Production databases from performance perspective.
- Carry out analysis of performance reports and proactively identify expensive SQLs and other performance bottlenecks.
- Keep abreast of new, performance related Oracle features and evangelize their use across IT teams.
- .Proven expertise in tuning high transaction, multi-TB sized DB
- Thorough knowledge of Oracle Cost Based Optimizer and clear understanding of Oracle architecture.
- Preventive Maintenance - Complete end to end analysis of database environment, health checks, configuration management
- Physical Schema design for given Database (indexing, constraints, partitioning, caching etc.
- Excellent debugging and optimization skills in as many areas as possible not restricted to SQL or Oracle database tuning such as operating system perf tools (perf, top, vmstat, iostat, etc.)
- Knowledge in application development
- Identifies changes to the customer environment that could potentially impact the utilization of resources and performance levels.
- Participate in software design reviews with developers to ensure that the architecture is scalable to meet long-term performance goals.
- Experience in related database technologies and products such as dataguard, golden gate, RAC,
- Support the build of the test environment including DB similar to target prod environment
- Advocate implementation of best practices in the areas of database design and operations
- Write/Update, Manage CRON jobs.
- Preferred managing the replication solutions with Golden Gate.
- Excellent verbal and written communication skills.
- Knowledge of Oracle Apps and Web Apps architecture is a big plus.
- Knowledge of Mongo DB and Cassandra is a big plus.
If you are suitable for this above requirement, kindly send us your updated word copy profile along with your annual salary expectations ASAP
Thanks & Regards,
Managing Partner & CEO
Krishna Jyothi Info
Plot No: 46, 2nd Floor, Surya Cyber Space, Arunodaya Colony, Madhapur, HITEC City Road, Hyderabad – 500081
India Mobile: +91 80088 01238
Job Type: Full-time
- DB Performance Analyst and/or SQL Tuner: 2 years
- PL/SQL: 3 years