Application Support Engineer
Accenture
3 - 5 years
Bengaluru
Posted: 21/06/2025
Job Description
Project Role Description : Act as software detectives, provide a dynamic service identifying and solving issues within multiple components of critical business systems.
Must have skills : Oracle Database Architecture
Good to have skills : NA
Minimum 3 year(s) of experience is required
Educational Qualification : 15 years full time education
Summary: As an Application Support Engineer, you will act as software detectives, providing a dynamic service that identifies and resolves issues within various components of critical business systems. Your typical day will involve collaborating with team members to troubleshoot problems, analyzing system performance, and ensuring the smooth operation of applications that are vital to business functions. You will engage with stakeholders to understand their needs and provide timely solutions, contributing to the overall efficiency and effectiveness of the organization. Roles & Responsibilities: A:Need to provide logical and/or application DBA support technical support, 24/7 for maintenance of oracle database systems within a defined operating model and processes. B :Write, review, and optimize application SQL queries, stored procedures, and views to ensure efficient data access and performance. C: Analyze slow-running queries and troubleshoot application-level database performance issues using logical techniques working with developers and application teams. D: Provide input for modification of procedures and documentation used for problem resolution and day-to-day maintenance Technical Experience: • Perform SQL performance tuning and optimization for Oracle databases to enhance application efficiency. • Review and fine-tune Oracle SQL queries, PL/SQL stored procedures, packages, and indexes to improve execution performance. • Analyze inefficient Oracle SQL statements, complex joins, and subqueries; enhance Oracle execution plans for optimal results using database profiles and others • Diagnose and resolve Oracle database-related application errors and performance issues using Oracle tools (e.g., AWR, ADDM, SQL Trace). • Analyze Oracle database usage patterns to recommend improvements to the logical data model and schema design. • Design and maintain logical data structures, Oracle database schemas, views, PL/SQL packages, triggers and user-defined functions. • Lead Oracle schema design initiatives to support evolving business needs. • Collaborate with application developers to convert business requirements into efficient Oracle database designs. • Define and enforce data validation rules, constraints, and referential integrity within the Oracle environment. • Manage Oracle metadata, data dictionaries and representing logical structures. • Provide logical database support for application development. • Ensure that Oracle database designs meet performance, scalability, and maintainability goals. • Write Oracle SQL queries to meet business and reporting requirements. • Assist app developers with logical Oracle database tasks, including schema versioning, migrations, and validation testing. • Facilitate promotion of logical Oracle database changes through environments (Dev, QA, Prod). • Support logical components during oracle db migrations and version upgrades. • Document Oracle logical database structures, data dictionaries, and ERDs for development and operational use. • Support data validation and testing efforts within Oracle database environments. • Assist in logical security tasks within Oracle , including role definitions, privileges, and access control at schema level. Professional & Technical Skills: • Able to prioritize and execute tasks in a high-pressure environment • Work in a team-oriented, collaborative environment • Should be able to perform initial level of trouble shootings. Additional Information: - The candidate should have minimum 3 years of experience in Oracle Database Administration (DBA). - This position is based at our Bengaluru office. - A 15 years full time education is required.15 years full time education
About Accenture
We work with one shared purpose: to deliver on the promise of technology and human ingenuity. Every day, more than 775,000 of us help our stakeholders continuously reinvent. Together, we drive positive change and deliver value to our clients, partners, shareholders, communities, and each other.We believe that delivering value requires innovation, and innovation thrives in an inclusive and diverse environment. We actively foster a workplace free from bias, where everyone feels a sense of belonging and is respected and empowered to do their best work.At Accenture, we see well-being holistically, supporting our people’s physical, mental, and financial health. We also provide opportunities to keep skills relevant through certifications, learning, and diverse work experiences. We’re proud to be consistently recognized as one of the World’s Best Workplaces™.Join Accenture to work at the heart of change.Visit us at www.accenture.com
Equal Employment Opportunity Statement
All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state, or local law.
Job candidates will not be obligated to disclose sealed or expunged records of conviction or arrest as part of the hiring process.
Accenture is committed to providing veteran employment opportunities to our service men and women.
About Company
Accenture is a global professional services company specializing in consulting, technology, and outsourcing services. Headquartered in Dublin, Ireland, Accenture provides a wide range of services in strategy, digital, technology, operations, and consulting. It helps organizations improve their performance and create sustainable value by leveraging technology and industry expertise. Accenture works across various sectors, including financial services, healthcare, telecommunications, energy, and more. Known for its deep focus on innovation, Accenture partners with leading technology companies to drive digital transformation and help clients navigate complex challenges in an increasingly digital world.
Services you might be interested in
One-Shot Campaign
Reach out to ideal employees in one shot!
The intelligent campaign for reaching out to the ideal audience to whom you can ask for help (guidance or referral).