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

24Mar

Database Analyst. Job Openings in Unitedhealth Group for Database Analyst, this job opened at 24 Mar, 2017. Queries and formatted reports; Strong in SQL Server Integration Services (SSIS) for ETL and SQL Server Reporting Services (SSRS) for report generation.... ... (Read more about Database Analyst - Gurgaon - Unitedhealth Group)


01Mar

Principal Data Analyst Profiler. Job Openings in Aci Worldwide for Principal Data Analyst Profiler, this job opened at 01 Mar, 2017. Performance Tuning or DBA experience. Execute queries against MDM hubs and. Analyze, query and manipulate data according to defined. At.... ... (Read more about Principal Data Analyst Profiler - - Aci Worldwide)


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)


24Feb

Oracle Sql Developer Retail. Job Openings in Citi for Oracle Sql Developer Retail, this job opened at 24 Feb, 2017. Performance monitoring and tuning efforts, suggest changes to improve performance. Review queries created by other developers for adherence to standards and... ... (Read more about Oracle Sql Developer Retail - Pune - Citi)


01Mar

Principal Data Analyst Profiler. Job Openings in Aci Worldwide for Principal Data Analyst Profiler, this job opened at 01 Mar, 2017. Performance Tuning or DBA experience. Execute queries against MDM hubs and. Analyze, query and manipulate data according to defined. At.... ... (Read more about Principal Data Analyst Profiler - Bangalore - Aci Worldwide)