Oracle Database Administration

Location: Itanagar

Position Overview

Position:
Oracle Database Administrator

Shift: 2:00 PM to 11:00 PM IST

Company Overview

With more than 1,300 clients and 1.6 million users, Intelex Technologies, ULC is a global leader in environmental, health, safety and quality (EHSQ) management software. Since 1992 its scalable, web-based platform and applications have helped clients across all industries improve business performance, mitigate organization-wide risk, and ensure sustained compliance with internationally accepted standards (e.g., ISO 9001, ISO 14001, ISO 45001 and OHSAS 18001) and regulatory requirements.

Intelex is one of North America's fastest-growing tech companies who has recently been recognized as a Great Place to Work for over 7 years, Best Workplace in Technology, Best Workplace for Millennia ls and Canadian HR Team for fewer than 500 employees and has been recipient of Waterstone's Most Admired Corporate Cultures award, and Deloitte's Best Managed Companies award. For more information, visit  or see what our employees are saying by following our #Proud Intelexian hashtag.

Fortive acquired Intelex in 2019.

As a Database Administrator (DBA) 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 Cloud Ops team, you will collaborate with Dev Ops engineers, Developers, and SREs to ensure seamless database operations supporting our mission-critical applications.

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 Always On 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.

Dev Ops, 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 Pager Duty 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 No

SQL solutions like Mongo

DB 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…