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 3 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.… Change Resume
Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere

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
Database Developer / DBA

Shawmut Design And Construction

Posted 2 days ago

VIEW JOBS 8/16/2018 12:00:00 AM 2018-11-14T00:00 Overview At Shawmut, our primary objective is to deliver exceptional service catered to our clients specific goals and concerns. Our project teams deliver top quality work through a hands-on, collaborative process while keeping our clients best interests our absolute focus at all times. With specialized training and the support of a national company, we foster project teams whose skill and dedication leads to the deliberate, predictable and repeatable construction experiences that have attracted and retained the top clients in every market in which we focus. The most memorable construction experiences are based on one principle it's the people who make the difference. And at Shawmut, we have the very best. Responsibilities Exciting Opportunity to join an expanding business application team. Be part of a team responsible for designing, implementing and supporting a wide range of Business Applications primarily focused around Corporate ERP. The position is very collaborative with an internal team of Business Analysts. Successful candidate will be able to take Requirements and transfer them into Technical Solutions. Desired skills include experience with Oracle SQL, PL/SQL, database design and DBA management. Knowledge and experience with Open Interfaces and APIs is also desired. Job Responsibilities are but not limited to: * Design and implement Database Objects to maintain the organizational data and maintain the integrity of the relational data. * Design and Implement Database procedures and complex queries to retrieve data for different needs of the organization. * Assist the development staff with complex SQL. * Modify existing databases and database management systems * Enhance third-party software by taking advantage of user extensions or customizations to work in harmony with core product. * Data Transformations, ETL programming from Origin to Source Data Mapping capabilities. * Work as part of a project team to coordinate database development and determine project scope and limitations. * Proven ability to efficiently diagnose and address complex technical problems. * Performs database tuning and optimization (schema and SQL). * Monitor DB Backups/Alerts/Storage. Work with external software vendors for support and design Qualifications * BS in Computer Science or related field * Must be skilled at establishing and maintaining consistency of a products performance, function and physical attributes. * 2+ years' experience with Oracle PL/SQL programming and performance tuning * Oracle 12c a Plus * Dell Boomi a Plus * Ability to extract, compare, manage data in a database * Work independently with minimal supervision. * Construction Industry Experience is a plus * Experience with MS SQL/TSQL is a plus Shawmut Design And Construction Boston MA

Oracle Dba/ Performance Tuning

Expired Job

Tata Consultancy Services