Skip to content

AT&T International Careers My Job Application

Join a network that helps you succeed

At AT&T, our talents work together to make a difference. Think you’d like to help us connect more people than ever before? Check out our latest opportunities below, or browse for other recent postings.

India

Senior Technical Specialist-Performance Tuning,DBA

Location:

Bangalore, India

Ref #:

151595

Date published:

03-Aug-2017
Apply now
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