Overview
Senior Programmer Analyst supporting and maintaining Oracle Marketing Resource Management (MRM), an intermediate-level applications development role focused on Oracle Siebel environments, databases, and application server operations.
What you'll do
- Support, maintain, and troubleshoot Oracle Marketing Resource Management (MRM).
- Develop a working understanding of Oracle Siebel architecture, components, configurations, and application dependencies.
- Perform application configuration, issue analysis, defect resolution, and technical troubleshooting.
- Analyze application logs, identify root causes, and coordinate with relevant technical teams to resolve incidents and recurring issues.
- Support application enhancements, maintenance activities, and business-requested changes.
- Collaborate with business users, development teams, database administrators, infrastructure teams, and external vendors.
- Investigate application issues and validate data in Oracle Database environments.
- Write, analyze, and troubleshoot SQL queries, including joins, subqueries, and data validation queries.
- Understand database schemas, tables, views, indexes, stored procedures, and application-to-database connectivity.
- Assist with database-related troubleshooting and performance analysis in coordination with database administrators.
- Support application deployments involving database scripts, DDL/DML changes, and data validation.
- Support application server administration, maintenance, and patching for Oracle WebLogic Server and Apache Tomcat.
- Plan and execute application server patching and maintenance across Development, UAT, Production, and COB environments, as required by the project.
- Follow established change management, release management, and production deployment procedures.
- Perform pre-patching checks, backup or recovery-readiness checks, service shutdown/startup, post-patching validation, and application smoke testing as applicable.
- Validate application availability, connectivity, integrations, and critical functionality following patching or maintenance.
- Coordinate with infrastructure, security, middleware, database, and application teams to address patch-related issues.
- Maintain technical documentation, implementation plans, validation evidence, and rollback procedures.
- Participate in scheduled maintenance windows and production support activities as required.
- Participate in all phases of the SDLC, including requirements analysis, design, development/configuration, testing, deployment, and maintenance.
- Support deployments and promotions across development, testing, UAT, production, and COB environments.
- Assist with release planning, implementation, validation, and post-deployment monitoring.
- Follow IT change management, incident management, problem management, and release management processes.
- Participate in root cause analysis and implement corrective and preventive actions.
- Prepare and maintain technical documentation, operational procedures, deployment plans, and support knowledge articles.
- Work within established security, audit, compliance, and operational standards.
- Support or troubleshoot Oracle analytics and reporting components where required by the application architecture.
What you'll need
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field, or equivalent experience.
- 7–10+ years of overall IT experience, with substantial hands-on experience in enterprise application support, maintenance, and delivery.
- Experience across the complete SDLC, including development or configuration, testing, release, deployment, and production support.
- Knowledge of Oracle Siebel products and enterprise application architecture.
- Ability and willingness to learn, support, and maintain Oracle Marketing Resource Management (MRM).
- Working knowledge of Oracle Database and SQL.
- Familiarity with Oracle WebLogic Server and Apache Tomcat administration.
- Experience or willingness to perform application server patching, upgrades, maintenance, and post-patching validation.
- Understanding of ITIL-based incident, problem, and change management processes.
- Strong troubleshooting, analytical, documentation, and communication skills.
- Ability to work independently while collaborating with geographically distributed teams.
Nice to have
- Familiarity with Oracle Analytics Server (OAS), Oracle Analytics Publisher, Oracle Business Intelligence Enterprise Edition (OBIEE), and Oracle integration technologies will be beneficial.
- Knowledge of application integrations, web services, middleware, and enterprise application architecture is an advantage.
- Candidates with Oracle Analytics Server (OAS) experience or certification will have an added advantage.
- Candidates with Oracle Analytics Publisher experience or certification will have an added advantage.
- Candidates with Oracle Business Intelligence Enterprise Edition (OBIEE) experience or certification will have an added advantage.
- Candidates with Oracle Business Intelligence or Oracle integration technologies experience or certification will have an added advantage.
- Candidates with Oracle Database administration or SQL certifications will have an added advantage.
- Candidates with Oracle WebLogic Server administration experience or certification will have an added advantage.
- Candidates with Oracle Siebel configuration, administration, or development experience or certification will have an added advantage.
- Candidates with relevant Oracle middleware, application support, or enterprise technology certifications will have an added advantage.
Details
- Full-time position.
- Location: Chennai, Tamil Nadu, India.
- Participation in scheduled maintenance windows and production support activities as required.
Read the full description and apply on the company’s own careers page.