Sign In
 [New User? Sign Up]
Mobile Version

Senior Technical Specialist-Performance Tuning,DBA

AT&T


Location:
Hyderabad
Date:
08/17/2017
2017-08-172017-09-16
Job Code:
att4-5284453
Categories:
  • IT Engineer
  • Developer
  •  
  • Save Ad
  • Email Friend
  • Print

Job Details

Company AT&T

Job Title Senior Technical Specialist-Performance Tuning,DBA

Jobid att4-5284453

Location: Hyderabad, IND

Description Looking for a highly motivated Database and Application Performance Tuner with well-rounded experience. This role requires to work on exciting and challenging projects as well as oncall rotation in different shifts. This role requires a highly motivated individual with a strong sense of ownership, technical and analytical expertise as well as an aptitude for business requirements documentation and designing system process flow. Candidate must effectively communicate between end users and technical teams and be able to triage issues. The candidate should have a solid understanding physical design and operation of databases and database internals.

Performance tuner experienced with Oracle 11g, 12c in RAC and multi-node application set-up of EBS/Fusion Apps and great experience with Data warehousing and Data analytics. Successful candidate will assume the responsibilities of supporting Oracle Database and Application Tuning. Along with other Performance Tuners in the team the candidate will provide 24x7 technical / administrative role. Skill requirements include solid knowledge and experience of Oracle Core Database and Oracle Applications duties.



**Roles and Responsibilities:**

Candidate should have knowledge in the following areas with 7 or more years of experience.



1) Database Performance Tuning:



a) Tuning applications developed using SQL, PL/SQL.

b) Expertise in ASH, AWR, SPA, analyzing 10046 trace, analyzing 10053 trace, SQL Profiles, Oracle Baselines, v$ tables, x$ tables, etc.

c) Very strong SQL tuning experience using TKPROF and SQL Monitor with in-depth understanding of all optimizer hints and optimizer plans.

d) Proficient with performance tuning in Oracle database 11g and 12c with RAC and Dataguard.

e) Experience working with large volume of data in the range of 100TB in size and optimizing tables that has billions of rows



2) Oracle Apps Performance tuning:



a) Proficient with performance tuning and application support for Oracle eBusiness suite R12 and Fusion Applications.

b) Reasonable knowledge of Oracle EBS/Fusion Applications technology stack, including architecture, concurrent manager, ESS, finding sessions, obtaining logs, tracing CM/Forms/OAF sessions/ADF sessions.

c) Identifying and tracing sessions from concurrent manager and Oracle forms

d) Good Understanding the Architecture and tuning of Oracle Fusion Applications.

e) Good Understanding the Architecture and tuning of Oracle Fusion Middleware



3) Tuning from OS:

a. In-depth knowledge on Solaris and Linux operating systems

b. Very good with truss, pmap, pfiles, netstat, vmstat, iostat, etc.



4) General tuning:

a. Trend analysis

b. Proactive tuning

c. Code review with developers

d. Load testing

e. Capacity planning



Preferred to have the following experience:



5) Middleware Performance tuning:



a) Tuning applications developed using Java, SOA/Fusion

b) Analyzing thread dumps

c) Tuning Golden Gate, Informatica, ODI, SOA, AppWorx

d) Experience with tools such as DynaTrace



**Key Competencies and Skills:**

Candidate should have knowledge in the following areas with 7 or more years of experience.



1) Database Performance Tuning:



a) Tuning applications developed using SQL, PL/SQL.

b) Expertise in ASH, AWR, SPA, analyzing 10046 trace, analyzing 10053 trace, SQL Profiles, Oracle Baselines, v$ tables, x$ tables, etc.

c) Very strong SQL tuning experience using TKPROF and SQL Monitor with in-depth understanding of all optimizer hints and optimizer plans.

d) Proficient with performance tuning in Oracle database 11g and 12c with RAC and Dataguard.

e) Experience working with large volume of data in the range of 100TB in size and optimizing tables that has billions of rows



2) Oracle Apps Performance tuning:



a) Proficient with performance tuning and application support for Oracle eBusiness suite R12 and Fusion Applications.

b) Reasonable knowledge of Oracle EBS/Fusion Applications technology stack, including architecture, concurrent manager, ESS, finding sessions, obtaining logs, tracing CM/Forms/OAF sessions/ADF sessions.

c) Identifying and tracing sessions from concurrent manager and Oracle forms

d) Good Understanding the Architecture and tuning of Oracle Fusion Applications.

e) Good Understanding the Architecture and tuning of Oracle Fusion Middleware



3) Tuning from OS:

a. In-depth knowledge on Solaris and Linux operating systems

b. Very good with truss, pmap, pfiles, netstat, vmstat, iostat, etc.



4) General tuning:

a. Trend analysis

b. Proactive tuning

c. Code review with developers

d. Load testing

e. Capacity planning



Preferred to have the following experience:



5) Middleware Performance tuning:



a) Tuning applications developed using Java, SOA/Fusion

b) Analyzing thread dumps

c) Tuning Golden Gate, Informatica, ODI, SOA, AppWorx

d) Experience with tools such as DynaTrace



**Education and Qualifications:**

B.E or equivalent educational qualification with relevant technical skills/expertise



**Additional Information:**

Required to work in shifts and support on-call rotation and shifts



At AT&T, we’re bringing it all together. We deliver advanced mobile services, next-generation TV, high-speed internet and smart solutions for people and businesses. That’s why we’re investing to be the premier integrated communications company.

Powered By

Featured Employers

Featured Jobs