Senior Database Specialist

Position: Sr. Cloud DBA Specialist

Location

India-Hybrid-EXL Chennai or Noida (Tue/Wed/Thu) In Office, Mon/Fri – Remote

Work Timings

IST - 4 PM to 12 AM (EST - 630 AM to 230 PM)

Role Overview

Sr. Cloud DBA Specialist is responsible for managing critical and non-production databases in multi-tenant environments, ensuring high availability, performance optimization, & compliance with SOX and PHI standards. This role demands strong technical expertise, problem-solving skills, critical thinking, and the ability to work collaboratively in a fast-paced setting.

Education/Work Qualifications

• Bachelor’s degree in Computer Science or related field (or equivalent experience).

Experience Qualifications

• 6-9 years as a DBA with expertise in Oracle, SQL Server, PostgreSQL, and other RDBMS, along with Linux infrastructure management.
• Current Workload would be 60% Oracle, 40% SQL Server.
• 1+ years hands-on Administration experience with: DataBricks, Snowflake (Preferable)
• Oracle APEX
• AWS/AZURE

Key Responsibilities

• Support and manage Oracle, SQL Server, and PostgreSQL databases in production and non-production environments.
• Install, configure, and monitor databases; ensure compliance with security and audit standards.
• Tune SQL and PL/SQL performance, troubleshoot and resolve incidents within SLAs, and automate tasks using Shell, PowerShell, T-SQL, PL/SQL, and Perl.
• Design and implement data models, mirroring, and backup/recovery strategies.
• Automate processes using scripting languages (Shell, PowerShell, T-SQL, PL/SQL, Perl).
• Collaborate with application teams and vendors for database solutions and lifecycle management.
• Provide 24x7 support, including on-call rotation and weekend coverage.
• Stay current with industry trends, emerging Cloud technologies, and AI/GenAI advancements.

Critical Skills (Must Haves)

• Hands-on Sr. DBA Administration experience with: Oracle (Single Instance/RAC, Multitenant, Active Data Guard), SQL Server (HA)
• PostgreSQL Administration is good to have.
• Expertise in RDBMS installations, patching, and upgrades
• Performance tuning in SQL and PL/SQL
• Experience managing large databases (>50 TB)
• Managing and upgrading Oracle APEX
• Cloud technologies Administration experience: AWS, Azure, Snowflake, Databricks (Good to have)
• Tools: Datadog, NewRelic, Oracle Enterprise Manager 13c+, Toad
• Strong Linux administration and scripting skills
• Knowledge and experience with AI/GenAI technologies (e.g., AI-driven automation, predictive analytics, database optimization using AI) (Good to have)
• Ability to leverage GenAI for operational efficiency, such as automating repetitive DBA tasks and enhancing DevOps pipelines. (Good to have)
• Exposure to AI in cloud ecosystems (AWS AI services, Azure Cognitive Services) for advanced database management.
• Knowledge of MongoDB and other RDBMS (Good to have)
• Compliance and audit support experience & Able to Collaborate with development and product teams
• Experience in Digital Marketing/Healthcare Products Preferred.
• Strong communication skills and the ability to work both independently and collaboratively as part of a team.
• Strategic, innovative mindset with strong analytical and problem-solving skills

Key Responsibilities

• Support and manage Oracle, SQL Server, and PostgreSQL databases in production and non-production environments.
• Install, configure, and monitor databases; ensure compliance with security and audit standards.
• Optimize performance (SQL and PL/SQL), troubleshoot issues, and resolve incidents within SLAs.
• Design and implement data models, mirroring, and backup/recovery strategies.
• Automate processes using scripting languages (Shell, PowerShell, T-SQL, PL/SQL, Perl).
• Collaborate with application teams and vendors for database solutions and lifecycle management.
• Provide 24x7 support, including on-call rotation and weekend coverage.
• Stay current with industry trends, emerging Cloud technologies, and AI/GenAI advancements.

Education

• Bachelor’s degree in Computer Science or related field (or equivalent experience).

Experience

• 6-9 years as a DBA with Hands on in Oracle, PostgreSQL, and other RDBMS, along with Linux infrastructure management.
• Oracle APEX, AWS, Azure
• 1+ years hands-on Administration experience with:DataBricks, Snowflake (Good to have)