Senior Consultant | Oracle Data Engineering | Hyderabad | Oracle
Senior Consultant | Oracle Data Engineering | Hyderabad | Oracle
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Your potential unleashed.
Indias impact on the global economy has increased at an exponential rate and Deloitte presents an opportunity to unleash and realise your potential amongst cutting edge leaders and organisations shaping the future of the region and indeed the world beyond.
At Deloitte your whole self to work every day. Combine that with our drive to propel with purpose and you have the perfect playground to collaborate innovate grow and make an impact that matters.
The team
Enterprise technology has to do much more than keep the wheels turning; it is the engine that drives functional excellence and the enabler of innovation and long-term growth.Learn more about ET&P
Your work profile
As Senior Consultant in ourOracle Team youll build and nurture positive working relationships with teams and clients with the intention to exceed client expectations: -
Job Title: Oracle PL/SQL Senior Consultant
Location Workplace: Hyderabad or BLR
Job Type: Full-time
Job Description:
An Oracle PL/SQL Developer is responsible for developing and maintaining Oracle database applications using the PL/SQL programming language. Developing and maintaining Oracle database applications using PL/SQL. Designing and developing database schemas stored procedures functions and triggers using PL/SQL. Optimizing database performance by tuning SQL queries and PL/SQL code. Developing and executing test plans to ensure the quality and accuracy of PL/SQL code. Troubleshooting and resolving issues related to PL/SQL code.
Responsibilities:
Designs develops implements and maintains custom oracle applications written in PL/SQL and supports back-end data processing in PL/SQL
Good Experience in SQL Analytical Query Performance Tunning concepts.
Knowledge about oracle architecture 9i and 18c different and ETL Process
Design and Develop database objects like Stored Procedures Functions Packages and Triggers.
Develop database for Ref Cursor Collections Dynamic SQL and Exception handling
Able to work on Collections like PL/SQL Records PL/SQL Tables and Nested Tables in PL/SQL blocks and Bulk Collection.
Good Experience Oracle Partitioning is a key feature
Must have experience in creating scheduler jobs Views Materialized Views.
Should have good understanding in Indexing.
SQL Query tuning using different tools. Clear understanding of query plan.
Perform code reviews to ensure code quality standards compliance and best practices.
Debug and troubleshoot PL/SQL code to identify and resolve issues.
Collaborate with cross-functional teams to gather and analyze requirements.
Design and develop database schema tables and relationships.
Create and optimize SQL queries and PL/SQL code for efficient data retrieval and manipulation.
Ensure data integrity security and performance in database operation. Collaborate with application developers to design and implement database structures that meet application requirements.
Optimize database performance through indexing query optimization and other tuning techniques.
Implement and maintain database security measures such as roles privileges and access controls.
Monitor and troubleshoot database issues.
Excellent problem solving issue identification analytical and technical documentation skills.
Strong interpersonal skills and ability to work well in a team environment.
Understand SDLC process and tools agile program management concepts and version control.
Qualifications:
- Bachelors degree in Computer Science or a related field.
- 5 to 8 years of proven experience in Database Development.
- Strong proficiency in ORACLE SQL PL/SQL.
- Proven experience as a PL/SQL Developer in a senior or lead role.
- Strong problem-solving skills and the ability to work collaboratively in a team environment.
- Exposure to cloud hosting and IT domains such as CI/CD pipelines and automated testing.
- Excellent communication and interpersonal skills.
Location and way of working
- Base location: Bengaluru
- This profile involves occasional travelling to client locations OR this profile does not involve extensive travel for work.
- Hybrid is our default way of working. Each domain has customised the hybrid approach to their unique needs.
Your role as a Senior Consultant
We expect our people to embrace and live our purpose by challenging themselves to identify issues that are most important for our clients our people and for society.
In addition to living our purpose Analyst across our organization must strive to be:
- Inspiring - Leading with integrity to build inclusion and motivation
- Committed to creating purpose - Creating a sense of vision and purpose
- Agile - Achieving high-quality results through collaboration and Team unity
- Skilled at building diverse capability - Developing diverse capabilities for the future
- Persuasive / Influencing - Persuading and influencing stakeholders
- Collaborating - Partnering to build new solutions
- Delivering value - Showing commercial acumen
- Committed to expanding business - Leveraging new business opportunities
- Analytical Acumen - Leveraging data to recommend impactful approach and solutions through the power of analysis and visualization
- Effective communication Must be well abled to have well-structured and well-articulated conversations to achieve win-win possibilities
- Engagement Management / Delivery Excellence - Effectively managing engagement(s) to ensure timely and proactive execution as well as course correction for
the success of engagement(s)
- Managing change - Responding to changing environment with resilience
- Managing Quality & Risk - Delivering high quality results and mitigating risks with utmost integrity and precision
- Strategic Thinking & Problem Solving - Applying strategic mindset to solve business issues and complex problems
- Tech Savvy - Leveraging ethical technology practices to deliver high impact for clients and for Deloitte
- Empathetic leadership and inclusivity - creating a safe and thriving environment where everyones valued for who they are use empathy to understand others to adapt our behaviours and attitudes to become more inclusive.
How youll grow
Connect for impact
Our exceptional team of professionals across the globe are solving some of the worlds most complex business problems as well as directly supporting our communities the planet and each other. Know more in our Global Impact Report and our India Impact Report.
Empower to lead
You can be a leader irrespective of your career level. Our colleagues are characterised by their ability to inspire support and provide opportunities for people to deliver their best and grow both as professionals and human beings. Know more about Deloitte and our One Young World partnership.
Inclusion for all
At Deloitte people are valued and respected for who they are and are trusted to add value to their clients teams and communities in a way that reflects their own unique capabilities. Know more about everyday steps that you can take to be more inclusive. At Deloitte we believe in the unique skills attitude and potential each and every one of us brings to the table to make an impact that matters.
Drive your career
At Deloitte you are encouraged to take ownership of your career. We recognise there is no one size fits all career path and global cross-business mobility and up / re-skilling are all within the range of possibilities to shape a unique and fulfilling career. Know more about Life at Deloitte.
Everyones welcome entrust your happiness to us
Our workspaces and initiatives are geared towards your 360-degree happiness. This includes specific needs you may have in terms of accessibility flexibility safety and security and caregiving. Heres a glimpse of things that are in store for you.
Interview tips
We want job seekers exploring opportunities at Deloitte to feel prepared confident and comfortable. To help you with your interview we suggest that you do your research know some background about the organisation and the business area youre applying to. Check out recruiting tips from Deloitte professionals.
Required Experience:
Senior IC
Employment Type
Full-Time
