17 Feb

Sql Query Performance Tuning Analysts - Bangalore - Krishna Jyothi Info

Sql Query Performance Tuning Analysts
Krishna Jyothi Info
Bangalore KA
17 Feb, 2017 30+ days ago

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

Required Skills:

  • 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,

Rama Krishna

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

Web: www.kjinfo.biz

LinkedIn: https://in.linkedin.com/in/ramakrishna21

Job Type: Full-time

Required education:

  • Bachelor's

Required experience:

  • DB Performance Analyst and/or SQL Tuner: 2 years
  • PL/SQL: 3 years

Other Sql Query Performance Tuning Analysts Jobs Vacancy


Junior Support Analyst Sql Server Dba Bwe. Job Openings in Bnp Paribas for Junior Support Analyst Sql Server Dba Bwe, this job opened at 19 May, 2017. Perform database and application performance/tuning including exposure on query level tuning and System level tuning.... ... (Read more about Junior Support Analyst Sql Server Dba Bwe - Mumbai - Bnp Paribas)


Programmer Analyst Sql. Job Openings in Scio Health Analytics for Programmer Analyst Sql, this job opened at 19 May, 2017. Knowledge on performance tuning. Designing and Developing SQL Tables. Writing Complex Queries using multiple tables and joins. Writing Procedures and Functions.... ... (Read more about Programmer Analyst Sql - Chennai - Scio Health Analytics)


Application Support Analyst. Job Openings in Morgan Chase for Application Support Analyst, this job opened at 19 May, 2017. Production monitoring, performance tuning,. Production monitoring, performance tuning, problem resolution, systems analysis, testing and post implementation... ... (Read more about Application Support Analyst - Mumbai - Morgan Chase)


Consultant Net With And Sql. Job Openings in Kpmg for Consultant Net With And Sql, this job opened at 27 Mar, 2017. Prior experience on performance tuning (application or database) is preferred. Ability to design, develop, test and troubleshoot SQL queries, stored procedures... ... (Read more about Consultant Net With And Sql - Bangalore - Kpmg)


Associate Data Analyst. Job Openings in Morgan Stanley for Associate Data Analyst, this job opened at 15 May, 2017. Strong SQL knowledge with experience in writing complex queries, preferably in Sybase and DB2 RDBMS. Interact with Quantitative Data Analysts and business line... ... (Read more about Associate Data Analyst - Mumbai - Morgan Stanley)