Production Support Engineer - Oracle PL/SQL, GCP

Responsibilities • Provide L2/L3 support to cloud-based application and services. • Troubleshooting and resolve performance, reliability, and security issues. • Monitor system health using tools like Splunk, Geneos, New relic and Grafana. • Maintain 24/7 operational support model to ensure business continuity. • Update the RUN Book and KEDB as & when required. • Participation in production change review/documenting, raising appropriate CAB questions and ensuring the deployments of every change have followed the standards and completed successfully. • Able to understand and debug Oracle procedures, function and triggers • Follow security protocols and compliance requirements to safeguard data warehouse assets. • Maintain up-to-date documentation of data warehouse processes, troubleshooting steps, and best practices. • Guide internal teams on cloud best practices, security, and cost optimization. • Work closely with data engineers, analysts, and business teams to understand data needs and improve system performance. Skills Requirement • Bachelors Degree in Information Technology/Engineering/Computer Science • 6 - 8 years of experience in Banking sector with Application Developer/Production support background within the Wealth Management industry. • Experience working with relational databases such as Oracle (EXCC) and SQL server • Proficiency in SQL for querying, troubleshooting, and performance tuning. • Familiarity with ETL tools (e.g., Informatica, Talend, SSIS) and data pipeline management. • Understanding of data warehouse concepts, star/snowflake schemas, and dimensional modelling. • Experience with cloud-based data warehouses (Google BigQuery) is a plus. • Unix file systems, commands, shell scripting development and trouble shooting • Windows systems, batch scripting development and trouble shooting • Oracle PL/SQL queries development and trouble shooting • Managing / monitoring Control-M and Tivoli/Geneos monitoring tools. • Expertise in performance tuning troubleshooting and optimizing cloud resources. • Strong background in DevOps methodologies, automation, and CI/CD pipeline management. • Proven ability to work in fast-paced, high-availability environment with a focus on operational excellence. • Experience working with cross-functional teams including developers, security, and infrastructure teams. Technical Skills • Google Cloud Platform (GCP) - Preferrable • Knowledge on AI API flows & AI agent, Fundamental of LLM models and Agentic AI. • Terraform, Jenkins, GITlab CI/CD. • Monitoring and Logging: Prometheus, Grafana, Splunk, Geneos. • Kubernetes, Docker, helm • Programming & Scripting: languages (e.g. Python, UNIX shell and PowerShell, PERL, Python, Github, Spring boot, JAVA/.NET and similar programming languages) • Operating systems (e.g. UNIX, Windows) and the underlying infrastructure environments • Middleware (e.g. MQ, WebLogic, Tomcat, Joss, Apache, Kafka and similar), DAP, Dweb, Fabric • Oracle, MS-SQL, Sybase, No SQL • Jira, SVN • WebLogic, Tomcat, fabric • BMC Control-M