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

Responsibilities
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.

Qualifications
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)