17 Feb

Sql Query Performance Tuning Analysts - Bangalore - Krishna Jyothi Info

Position
Sql Query Performance Tuning Analysts
Company
Krishna Jyothi Info
Location
Bangalore KA
Opening
17 Feb, 2017 3 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

18Jan

Programmer Analyst Sql. Job Openings in Scio Health Analytics for Programmer Analyst Sql, this job opened at 18 Jan, 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)


16Feb

Product Support Eng. Job Openings in Teradata for Product Support Eng, this job opened at 16 Feb, 2017. Experience with SQL and query tuning. (both at the system and individual SQL query level), dump analysis, filesystem.... ... (Read more about Product Support Eng - Hyderabad - Teradata)


11Jan

Database Analyst. Job Openings in Fiserv Inc for Database Analyst, this job opened at 11 Jan, 2017. Good with developing SQL queries - Having knowledge of MSBI SSIS is a plus. Expertise in DTS , job scheduling T/SQL, stored procedures, triggers and UDFs ·... ... (Read more about Database Analyst - Pune - Fiserv Inc)


11Jan

Database Administration Analyst. Job Openings in Fiserv Inc for Database Administration Analyst, this job opened at 11 Jan, 2017. Good with developing SQL queries - Should be proficient with MSBI-SSIS concepts · Expertise in job scheduling T/SQL, stored procedures, triggers and UDFs, SSIS... ... (Read more about Database Administration Analyst - Pune - Fiserv Inc)


25Jan

Teradata Database Administrator Iii. Job Openings in Groupon for Teradata Database Administrator Iii, this job opened at 25 Jan, 2017. Performance optimization of resource intensive ETL and individual user queries. Experience in performance tuning-required.... ... (Read more about Teradata Database Administrator Iii - Bangalore - Groupon)