About this role
This Position will be a key member of the team to support the lifecycle and maintenance of enterprise database platforms. This role will be implementing the enterprise database solutions for applications / systems, technical processes, and performing necessary activities to complete solution testing and deployment. This position will work with / manage external technology vendors, System Integrators (SI), service providers and internal IT groups and business units for projects and initiatives.
- 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 standard 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.
- 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 Web sphere 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.
- 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.