Logo of Huzzle

Oracle DBA

  • Job
    Full-time
    Senior & Expert Level
  • Data
    IT & Cybersecurity
  • Chennai

AI generated summary

  • You need a bachelor's in IT, experience as a DBA, knowledge of Oracle/SQL Server, SQL/T-SQL skills, and expertise in security, performance tuning, and HA/DR solutions. Strong communication skills are essential.
  • You will install, configure, and upgrade databases, manage objects, ensure backups, optimize performance, troubleshoot issues, oversee security, handle migrations, collaborate with developers, and maintain documentation.

Requirements

  • Bachelor's degree in computer science, information technology, or a related field.
  • Proven experience as an Oracle/SQL Server DBA or similar role.
  • In-depth knowledge of Oracle and SQL Server database architecture, installation, configuration, and administration.
  • Strong understanding of database security principles and best practices for both Oracle and SQL Server.
  • Proficiency in SQL and T-SQL scripting for Oracle and SQL Server, respectively.
  • Familiarity with database performance monitoring and tuning tools for both Oracle and SQL Server.
  • Ability to diagnose and troubleshoot database issues in both Oracle and SQL Server environments.
  • Knowledge of high availability (HA) and disaster recovery (DR) solutions for both Oracle and SQL Server databases.
  • Excellent analytical and problem-solving skills.
  • Strong communication and interpersonal skills.

Responsibilities

  • Install, configure, and upgrade Oracle and SQL Server database software and related products.
  • Create and maintain database objects, such as tables, indexes, and views, in both Oracle and SQL Server databases.
  • Design and implement database backup and recovery strategies for Oracle and SQL Server databases to ensure data integrity and availability.
  • Monitor and optimize performance of Oracle and SQL Server databases, identifying and resolving performance bottlenecks.
  • Troubleshoot and resolve database issues, such as connectivity problems, data corruption, and query optimization.
  • Manage database security for both Oracle and SQL Server, including user access control, data encryption, and database auditing.
  • Plan and implement database migrations, upgrades, and patching for both Oracle and SQL Server databases.
  • Collaborate with application developers to design and optimize database schemas and queries for both Oracle and SQL Server databases.
  • Develop and maintain database documentation, including data models, database diagrams, and operating procedures for both Oracle and SQL Server databases.
  • Stay up-to-date with Oracle and SQL Server database technology trends, best practices, and industry standards.

FAQs

What are the primary responsibilities of the Oracle DBA position?

The primary responsibilities include installing, configuring, and maintaining Oracle and SQL Server databases, optimizing database performance, troubleshooting issues, managing database security, and ensuring data integrity and availability through backup and recovery strategies.

What qualifications are required for the Oracle DBA role?

A Bachelor's degree in computer science, information technology, or a related field is required, along with proven experience as an Oracle/SQL Server DBA or a similar role.

How many years of experience are needed for this position?

The position requires 7 to 10 years of relevant work experience.

Is there a certification preferred for this position?

Yes, the Oracle Certified Professional (OCP) certification is preferred.

What specific skills are necessary for the Oracle DBA role?

Necessary skills include in-depth knowledge of Oracle and SQL Server database architecture, database security principles, proficiency in SQL and T-SQL scripting, and familiarity with performance monitoring and tuning tools.

Is this position full-time or part-time?

This position is full-time.

Does the Oracle DBA role require travel?

No, the position does not require travel.

Are there opportunities for professional development in this role?

Yes, the role includes staying up-to-date with Oracle and SQL Server technology trends, best practices, and industry standards, which offers opportunities for professional development.

Will the company provide relocation assistance for this position?

No, relocation is not eligible for this position.

Does Applied Materials offer equal employment opportunities?

Yes, Applied Materials is an Equal Opportunity Employer committed to diversity in the workplace. All qualified applicants will receive consideration for employment without regard to various factors, including race, gender, and disability.

Manufacturing & Electronics
Industry
10,001+
Employees

Mission & Purpose

Applied Materials is the leader in materials engineering solutions used to produce virtually every new chip and advanced display in the world. Our expertise in modifying materials at atomic levels and on an industrial scale enables customers to transform possibilities into reality. At Applied Materials, our innovations make possible a better future.