Oracle Database Administration
Working within the CloudOps team, you will collaborate with DevOps engineers, Developers, and SREs to ensure seamless database operations supporting our mission-critical applications. 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 Implement partitioning, replication, resource governor, and caching to improve data access and efficiency. 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. 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. Automate routine maintenance tasks, monitoring, and alerting using New Relic and PagerDuty or similar. 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) Provide on-call support for database-related production incidents on a rotational basis. 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. Experience working in DevOps/SRE environments with CI/CD for database deployments. 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.
Oracle Database Administration
Working within the CloudOps team, you will collaborate with DevOps engineers, Developers, and SREs to ensure seamless database operations supporting our mission-critical applications. 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 Implement partitioning, replication, resource governor, and caching to improve data access and efficiency. 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. 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. Automate routine maintenance tasks, monitoring, and alerting using New Relic and PagerDuty or similar. 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) Provide on-call support for database-related production incidents on a rotational basis. 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. Experience working in DevOps/SRE environments with CI/CD for database deployments. 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.