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 2 weeks 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.

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

Ceres Group

Posted 3 days ago

VIEW JOBS 6/21/2018 12:00:00 AM 2018-09-19T00:00 As our database administrator, supporting the firm's databases, monitoring our systems, writing documentation on current systems design, and providing guidance on future database implementations to support our company's data will be all in a day's work. This collaborative position will have you working closely with IT project managers, developers, and the Systems Engineering team—communicating regularly with application and operational staff to ensure database integrity, security, and quality. This position will focus on Microsoft SQL Server, but occasionally you'll be required to support non-Microsoft databases, too. Responsibilities: * Supporting internally developed database environments, as well as third-party database environments * Ensuring that all databases are being backed up and that recovery procedures are functioning to meet recovery point objectives and recovery time objectives * Installing, configuring, and patching all SQL Server instances to keep them at appropriate patch levels, in accordance with IT and security policies * Evaluating and testing new database solutions and enhancements * Meeting business requirements for high availability and disaster recovery for all supported environments * Writing database documentation, standards, and procedures; educating database users on how to efficiently query the database system * Operationalizing and enforcing standards for the processes and procedures for production code releases * Deploying database schema change scripts provided by third-party vendors or in-house developers * Configuring SQL Server monitoring and alerts to help manage database systems; identifying database server weaknesses and recommending solutions * Designing, building, and maintaining custom DBA utilities/tools to better support the database environment * Ensuring that our database servers meet company standards and follow industry best hardware and software practices * Participating in the on-call rotation for the Database Administration/Operations team Qualifications: * 3+ years' DBA experience with SQL Server * Enterprise-level database operations experience * Excellent communication skills * Experience with SQL Server HA and DR technologies (log shipping, failover cluster instances, availability groups) * Experience with performance tuning, including third-party databases, where code changes are not possible * Experience writing automation using scripting languages such as PowerShell The ideal candidate will also have familiarity with SOME of the following technologies: * Oracle, MySQL, PostgreSQL, or other database platforms * Visual Studio .NET * Windows Server Failover Clustering * SQL Server Reporting Services and SQL Server Integration Services * Microsoft Azure or other cloud infrastructures Ceres Group Boston MA

Oracle Dba/ Performance Tuning

Expired Job

Tata Consultancy Services