Oracle Database Administrator

Position Overview

As an Oracle Database Administrator at Intelex Technologies, you will play a critical role in managing and optimizing our Oracle, MS SQL Server database environments. You will be responsible for the design, implementation, performance tuning, high availability, and security of our database infrastructure across cloud deployments. Working within the CloudOps team, you will collaborate with DevOps engineers, Developers, and SREs to ensure seamless database operations supporting our mission-critical applications.

This role operates on a shift from 2:00 PM to 11:00 PM IST.

Responsibilities and Deliverables

Database Administration & Architecture

• Design, implement, and optimize databases across Oracle, MS SQL Server, and Snowflake environments.
• Participate in troubleshooting, investigation, and RCA of database issues.
• Participate in architecture/design reviews, ensuring database structures align with application needs and performance goals.
• Define and maintain best practices for schema design, indexing strategies, and query optimization.

Performance Tuning & Scalability

• Conduct proactive query tuning, execution plan analysis, and indexing strategies to optimize database performance.
• Monitor, troubleshoot, and resolve performance bottlenecks across Oracle, MS SQL Server, and Snowflake.
• Implement partitioning, replication, resource governor, and caching to improve data access and efficiency.

High Availability, Replication & Disaster Recovery

• Design and implement HA/DR solutions for all supported databases, including MS Clustering, Oracle Data Guard, and AlwaysOn Availability Groups.
• Perform capacity planning, ensure proper backup and recovery strategies are in place.
• Automate, test failover and recovery processes to minimize downtime.

Security & Compliance

• Implement role-based access control (RBAC), encryption, auditing, and compliance policies across all database environments.
• Ensure adherence to SOC 2, ISO 27001, GDPR, and HIPAA security standards.
• Collaborate with security teams to identify and mitigate vulnerabilities.

DevOps, CI/CD, & Automation

• Integrate database changes into CI/CD pipelines, ensuring automated schema migrations and rollbacks.
• Use Terraform or other IAC tools for database provisioning and configuration management.
• Automate routine maintenance tasks, monitoring, and alerting using New Relic and PagerDuty or similar.

Cloud & Data Technologies

• Manage cloud-based database solutions such as Azure SQL on VM, SQL on EC2, Oracle on EC2, and Snowflake.
• Work with NoSQL solutions like MongoDB when needed.
• Support data warehousing and analytics solutions (e.g., Snowflake).

Incident Response & On-Call Support

• Provide on-call support for database-related production incidents on a rotational basis.
• Conduct root cause analysis and implement long-term fixes for database-related issues.

Qualifications & Skills Required

• 8+ years' experience managing Oracle in enterprise environments.
• Expertise in database performance tuning, query optimization, and execution plan analysis.
• Strong experience with replication, clustering, and high-availability configurations.
• Hands-on experience with cloud databases in AWS or Azure (SQL on EC2, Oracle on EC2, Azure SQL etc.).
• Solid experience with backup strategies, disaster recovery planning, and failover testing.
• Proficiency in T-SQL, PL/SQL SQL scripting.
• Experience automating database tasks using PowerShell, Python, or Bash.

Desired

• Familiarity with AlwaysOn Availability Groups, Resource Governor.
• Experience working in DevOps/SRE environments with CI/CD for database deployments.
• Certifications such as Oracle DBA Certified Professional, Microsoft Certified: Azure Database Administrator Associate, or AWS Certified Database – SpecialtySQL Server knowledge and hands-on.

Education & Other Requirements

• Bachelor's or master's degree in computer science, Data Engineering, or equivalent experience.
• This role requires a satisfactory Criminal Background Check and Public Safety Verification.

Key skills/competency

• Oracle Database Administration
• MS SQL Server Management
• Snowflake Data Warehousing
• Performance Tuning & Optimization
• High Availability (HA)
• Disaster Recovery (DR)
• Database Security
• DevOps & CI/CD
• Cloud Database Management
• Incident Response