Technical Authority Expert

Technical Authority Expert

What You Will Do: Key Responsibilities

• Manage and administer enterprise-level database systems

  , specifically focusing on

  Microsoft SQL Server

  and

  Oracle

  environments.

• Design, implement, and optimize Microsoft SQL Server databases

  , including database design, administration, performance tuning, and advanced troubleshooting.

• Develop and implement robust database backup and recovery strategies

  , including comprehensive disaster recovery planning and execution.

• Utilize SQL programming and scripting languages

  for database management and automation tasks.

• Apply database security concepts and best practices

  to safeguard sensitive data and ensure compliance.

• Implement and manage high availability (HA) and failover clustering technologies

  for continuous database operations.

• Diagnose and resolve complex database issues

  , performing root cause analysis with excellent analytical and problem-solving skills.

• Install, configure, and upgrade Oracle server software

  and related products (clients, RAC, standalone instances).

• Perform Oracle database upgrades

  (e.g., from 11g to 12c, and 12c to 19c).

• Optimize Oracle database performance

  through query optimization and instance tuning.

• Manage heavy databases (100+ TB)

  on both Filesystem and ASM, including adding disks to ASM and datafiles in RAC.
• Collaborate effectively with cross-functional teams and communicate complex technical concepts to non-technical stakeholders.

Required Qualifications

• Proven experience as a Microsoft SQL Server DBA

  , managing enterprise-level database systems.

• Strong knowledge of Microsoft SQL Server

  , including database design, administration, performance tuning, and troubleshooting.
• Experience with

  database backup and recovery strategies

  , including disaster recovery planning and implementation.
• Proficiency in

  SQL programming and scripting languages

  .
• Familiarity with

  database security concepts and best practices

  .
• Understanding of

  high availability (HA) and failover clustering technologies

  .
• Excellent analytical and problem-solving skills, with the ability to diagnose and resolve complex database issues.
• Strong organizational and time management skills, with the ability to handle multiple tasks and priorities simultaneously.

• Oracle Database Expertise:

• Experience with

  Oracle 10g, 11g, 12c, 18C, 19C versions

  (18 & 19 are additional benefits).
• Expertise in

  Performance tuning

  (Optimizing Queries, Instance Tuning).
• Knowledge of

  Oracle database upgrade processes

  (e.g., from 12c to 19c and 11g to 12c).
• Experience with

  installation, configuration, and upgrading of Oracle server software

  and related products (clients, RAC 2 nodes, standalone).
• Good understanding of

  RAC (2 nodes or 3 nodes)

  and its services.
• Understanding of

  Active/Passive and Active-Active configurations

  (ASM and Veritas Cluster).
• Good knowledge of

  physical database design

  .
• Good understanding of the

  underlying operating systems

  (Windows, Unix, Linux, Solaris & AIX).
• Familiarity with key OS commands to check server load (e.g., top, topas, sar, vmstat).
• Experience with

  Partitioning

  (Partition Tables, Range, Hash) and partition pruning.
• Knowledge of

  Indexing

  (Local and Global Index, benefits and drawbacks).
• Experience working on

  heavy databases (100+ TB)

  on both Filesystem and ASM.
• Proficiency in

  adding disks in ASM

  and adding datafiles in RAC, tempfiles, etc.

Certifications & Tools (Highly Desirable)

• Microsoft SQL Server certification

  (e.g., MCSA, MCSE) or equivalent industry certifications.
• Experience with

  cloud-based database platforms

  , such as

  Microsoft Azure SQL Database

  .
• Familiarity with

  data warehousing concepts and technologies

  .
• Knowledge of

  PowerShell or other automation tools

  for database administration tasks.
• Experience with

  performance monitoring and tuning tools

  , such as SQL Server Profiler or Extended Events.
• Effective communication and interpersonal skills, with the ability to collaborate with cross-functional teams and communicate technical concepts to non-technical stakeholders.