[Hiring] Senior Specialist, Global Infrastructure Operations @APL Logistics

Role Description

• Implement, optimize and automate database technologies (e.g. Oracle Database, Oracle Real Application Cluster (Oracle RAC), Postgres, SQL Server, Teradata, etc.) on-prem and in the Public Cloud.
• Implement, optimize Oracle Golden Gate (OGG) technologies for real-time change data capture (CDC) on-prem and in the Public Cloud.
• Implement and maintain robust solutions for enterprise database technologies to meet business demands including:
  • Performance tuning
  • Upgrades
  • Clustering
  • Redundancy
  • Disaster recovery
• Provide subject matter expertise and represent the highest level of technical escalation for Database technologies on-prem and in the Public Cloud.
• Consult with and serve as liaison for end users and application developers in the support of mission-critical applications.
• Ensure appropriate standards and procedures are adhered to, and develop and implement standards for installation, maintenance, and enhancement of database platforms to support quality deliverables.
• Clearly articulate design trade-offs of availability, performance, interoperability, and costs to both technical and executive audiences in regard to database technologies.
• Provide guidance and cross-training to other members on the team.

Qualifications

• Hands-on experience setting up and optimizing Oracle RAC, OGG, Postgres, SQL Server.
• Hands-on experience fine-tuning SQL queries and optimizing indexes and plan management to speed up SQL query performance.
• Experience in executing projects, including planning and implementing short and long-term work plans and successfully completing projects on schedule.
• Experience in implementing enterprise database and Cloud technologies.
• Minimum 3 years’ experience of any of the following Linux / Unix platforms: RHEL / Solaris / AIX.
• Experience with application and database performance tuning, capacity planning, and reporting.
• Practical experience troubleshooting database problems.
• Experience in managing and dealing with third-party system integrators and solution providers.
• Experience working with clustered systems and high availability systems.
• Good knowledge of Database platforms (Oracle RAC/OGG/Postgres/SQL Server).
• Good knowledge of cloud-based database technologies in the Azure Cloud.
• Knowledge of managing IBM WebSphere Application Server, Apache Tomcat, Oracle WebLogic is a plus.
• Knowledge of Oracle Transportation Management, Oracle Business Intelligence, and Oracle ODI is a plus.
• Good knowledge of other technologies used in IT enterprise infrastructure such as:
  • Server hardware
  • Virtualization/VMWare
  • Networks
  • Load balancers
  • Firewalls
  • SAN Storage
  • Backups
  • Databases
  • AD / LDAP
  • SSO
  • Cloud solutions such as OCI

Requirements

• Database & Cloud: Oracle RAC, Oracle Golden Gate, PostgreSQL, SQL Server, Azure cloud databases.
• OS Platforms: RHEL, Solaris, AIX (Linux/Unix).
• Performance: SQL tuning, index optimization, execution plan management, DB/App performance tuning.
• Infra & Tools: VMWare, server hardware, networks, load balancers, firewalls, SAN storage, backups, AD/LDAP, SSO, OCI.
• Application Servers (Plus): WebSphere, Tomcat, WebLogic.
• Other Plus Skills: OTM, OBI, ODI.