Sorry, this job is no longer accepting applications. See below for more jobs that match what you’re looking for!

Oracle Dba/ Performance Tuning

Expired Job

Tata Consultancy Services Boston , MA 02298

Posted 5 months ago

Job Description:

  • Looking for an Oracle database, system, Application and SQL performance tuning expert with an ability to identify, analyze performance issues and provide solutions, workarounds to resolve the issue.

  • Should have the ability to work with customer business, development, and support teams to identify the issue and work independently in analyzing and providing recommendations.

  • Should have strong analytical and communication skills.

Key Responsibilities:

  • Oracle Database performance tuner should have hand-on experience in Oracle 9i/10g/11g/12c , Oracle Exadata

  • Experience working with OEM 10g/11g/12c.

  • Ability to diagnose the performance issues from SQL to Application to Database to System to Storage

  • Should have "Expert" level SQL tuning skill and experience , Expert level understanding of Oracle database architecture

  • Expert knowledge in DPT and AWR objects

  • Experience in creating and executing performance testing strategy is a plus

  • Identify and resolve performance bottlenecks at DB & at session /program level

  • Should have experience & ability to work with various teams to resolve performance issues (development, storage administrators, network administrators, system administrators and business users)

  • Experience in shell scripting.

  • Review physical structures of database , Review performance, maintenance and utilities associated with database structure

  • Performance tuning and query optimization using PL/SQL , tuning database performance,

  • Performs database re-organizations as required to assist performance and ensure maximum uptime of the database.

  • Implements and enforces security for all of the Oracle Databases.

  • Candidate should possess strong problem solving skills.

  • Demonstrate the ability to work with already established data models and naming conventions.

  • Be able to grasp the problem at hand and recognize appropriate approach, tools and technologies to solve it.

  • A record of working effectively with application teams, understanding Customer business drivers and executing on multiple performance tuning projects

Candidate qualifications:

  • BS in Computer Science or equivalent experience

  • 10+ years as a DBA , 5+ Years as Oracle performance tuning ( DB system and SQL tuning )

  • Experience working in production environments requiring 99.99% availability

  • Previous experience and a strong technical background deploying, administrating, tuning, monitoring, and maintaining database technologies including but not limited to Oracle 10g, 11g/12c, and Unix/Linux a major plus

  • Solid experience in database tuning, design, security, backup, recovery, and archival concepts and procedures.

  • Exposure to the Cloud or virtualized Application environments a plus.

  • Familiarity with ETL processes and operations

  • Excellent communication skills are a requirement including the ability to effectively communicate with technical, non-technical employees and vendors.

  • Strong problem solving, testing, and network troubleshooting skills.

  • Should have "independently" able to identify and resolve database performance issues

  • The skill to work to tight deadlines under pressure

  • Business awareness and understanding of project requirements

  • Ability to work in a fast paced, team atmosphere.

See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Oracle DW DBA

Connexions Data Inc

Posted 7 days ago

VIEW JOBS 10/9/2018 12:00:00 AM 2019-01-07T00:00 Oracle DW DBA Location: MA Duration: 6+ Months Job Description for Data Warehouse/BI DBA Customer is looking for a strong Oracle Data Warehouse/Business Intelligence DBA. This is a hands-on technical role to implement DW/BI environment using a number of tools, assist and guide developers as to best practices in this environment. The DW/BI environment is implementation of OBIEE in Bigdata. Elements include Oracle EBS database, Cloud Informatics for ETL, Agile, OBIEE, Camstar and other applications. It is imperative that the DW DBA have experience with Oracle EBS and its data structure as it will be the main source of data. It would also be good if the consultant had knowledge working within the manufacturing industry, but not a must. Understanding of the customer processes and requirements for best practice. Solid understanding of and experience using the tools required for implementing intelligent DW schemas, including using materialized views, partitioning, Indexing (more than B-tree), and various compression schemes including Hybrid Columnar Compression. Should have several years of experience developing complex database solutions, designing the database tables as well as developing complex oracle queries and database procedures. Must be able to identify poorly designed code and explain reasoning to developers. Should have some background in ERP systems and the kind of reporting that is done against them, Oracle E-Business Suite experience preferred Understanding of how Bigdata handles database queries different from commodity hardware. Project experience in performance tuning and handling high data load. Should have very good communication skills and requirements gathering skills. Very good team player to adjust with the given team and strong experience taking customer requirements to live. Please send resume to Nancy Shaha Skills: Oracle DW DBA Contract 6 months + Connexions Data Inc Boston MA

Oracle Dba/ Performance Tuning

Expired Job

Tata Consultancy Services