Design, implement, and operate scalable database platforms across hybrid and cloud environments. Drive database reliability, performance, and lifecycle management by establishing standardized operational practices, enabling cloud adoption, and executing complex database migrations from on‑premises systems to managed cloud services. Partner with infrastructure, application, and DevOps teams to ensure database platforms support business growth, scalability, and operational resilience. Core Responsibilities Database Administration & Operations Manage and support enterprise Oracle (Oracle Linux) and SQL Server database environments (Windows‑based SQL Server required) Ensure database availability, reliability, and performance across production and non‑production environments Establish and maintain database standards for configuration, patching, and lifecycle management Drive proactive monitoring and issue resolution to prevent service disruption Lead migration of databases from on‑premise environments to cloud platforms (AWS RDS and related services) Design and implement cloud‑native database architectures aligned with scalability and resilience requirements Evaluate and onboard appropriate AWS database offerings (RDS, Aurora, etc.) based on workload needs Establish migration strategies, including data replication, cutover planning, and validation Performance Tuning & Optimization Analyze and optimize database performance of Oracle and SQL Server instances Identify bottlenecks in queries, indexing strategies, and system resources Implement performance tuning mechanisms to improve throughput and reduce latency Partner with application teams to optimize database interaction patterns Backup, Recovery & Data Protection Design and manage database backup and recovery strategies to ensure data integrity and business continuity Experience with Oracle Recovery Manager (RMAN) to perform regular hot backups, database exports to replicate schema level data across dev/test/stage instances Implement and validate backup solutions, including automated backup scheduling and recovery testing Ensure compliance with RPO/RTO objectives and disaster recovery requirements Utilize enterprise‑grade backup tools and cloud‑native capabilities Automation & Operational Efficiency Develop automation for database provisioning, monitoring, and maintenance activities Integrate database operations into infrastructure automation and DevOps workflows Reduce manual operational overhead through scripting and tooling Cross-Platform & Infrastructure Integration Collaborate with infrastructure and cloud teams to align database platforms with hybrid architecture strategies Ensure database systems integrate with networking, security, and identity frameworks Support platform standardization across on‑prem and cloud environments Required Experience 8+ years of experience in database administration and engineering Microsoft SQL Server administration in Windows environments Database migration from on‑premise to cloud platforms (AWS preferred) AWS RDS and managed database services Experience operating in hybrid infrastructure environments Critical Skills Oracle database architecture, administration, and troubleshooting SQL Server (Windows) administration and performance tuning Database migration strategies and execution Performance optimization (query tuning, indexing, resource management) Backup and recovery design (RMAN, native SQL Server tools, cloud‑native solutions) AWS database services (RDS, Aurora, monitoring tools) Scripting/automation (Python, Shell, PowerShell preferred) Cross‑team collaboration and operational execution #J-18808-Ljbffr
Oracle Database Administrator
ITJ
tijuana, tijuana
Publicado hace 16 días
Denunciar empleo