Senior Specialist, Global Infrastructure Operations

Responsibilities

• Implement, optimize and automate database technologies (e.g. Oracle Database, Oracle Real

• Application Cluster (Oracle RAC), Postgres, SQL sever, 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 and disaster recovery

• Provide subject matter expertise and represents 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

Experience: 

• Hands-on experience setting up and optimizing Oracle RAC, OGG, Postgres, SQL server.

• Hands-on experience fine-tuning SQL query and optimizing indexes and plan management to speed up SQL query performance.

• Experience in executing projects, including planning and implementing a 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 and cloud solutions such as OCI. Working experience with several of these areas highly desirable.

Technologies Required

• 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.