IN_Senior Associate_Oracle DBA _Advisory Corporate_Advisory_Bangalore

PricewaterhouseCoopers

Line of Service

Advisory

Industry/Sector

Not Applicable

Specialism

SAP

Management Level

Senior Associate

Job Description & Summary

At PwC, our people in software and product innovation focus on developing cutting-edge software solutions and driving product innovation to meet the evolving needs of clients. These individuals combine technical experience with creative thinking to deliver innovative software products and solutions.

In technology delivery at PwC, you will focus on implementing and delivering innovative technology solutions to clients, enabling seamless integration and efficient project execution. You will manage the end-to-end delivery process and collaborate with cross-functional teams to drive successful technology implementations.

Why PWC

At PwC, you will be part of a vibrant community of solvers that leads with trust and creates distinctive outcomes for our clients and communities. This purpose-led and values-driven work, powered by technology in an environment that drives innovation, will enable you to make a tangible impact in the real world. We reward your contributions, support your wellbeing, and offer inclusive benefits, flexibility programmes and mentorship that will help you thrive in work and life. Together, we grow, learn, care, collaborate, and create a future of infinite experiences for each other. Learn more about us.

At PwC, we believe in providing equal employment opportunities, without any discrimination on the grounds of gender, ethnic background, age, disability, marital status, sexual orientation, pregnancy, gender identity or expression, religion or other beliefs, perceived differences and status protected by law. We strive to create an environment where each one of our people can bring their true selves and contribute to their personal growth and the firm’s growth. To enable this, we have zero tolerance for any discrimination and harassment based on the above considerations.

Job Description & Summary: Seeking an experienced Senior Oracle Database Administrator with knowledge of AWS Cloud technologies. The ideal candidate will have a deep understanding of Oracle administration coupled with expertise in AWS services, particularly AWS RDS Oracle/Aurora and DMS. Individuals with proficiency in infrastructure as code tools like Terraform, scripting languages such as Python, Java script, Bash, PowerShell, and experience with serverless computing using AWS Lambda functions are preferred. Oracle as primary with MS-SQL as secondary - Database administration and Support ; Exposure to Cloud RDS, EMR products and support

Responsibilities: · Design and Implementation: · · Design, deploy, and manage Oracle databases on premises and in AWS RDS, ensuring optimal performance, availability, and scalability. · Collaborate with cross-functional teams to architect and implement hybrid cloud database solutions aligned with business requirements. · Develop and maintain infrastructure as code using Python, Bash, Ansible, PowerShell and Terraform to automate the provisioning and configuration of a hybrid cloud database environment. · Migrate on premises databases to AWS using DMS, DMS CDC and development custom CDC scripts. · Collaborate with data engineers, DevOps, and other stakeholders to define database requirements and solutions. · Monitor and maintain the health, performance, and security of a hybrid cloud database environment. · Support of Production environments with strong troubleshooting skills. · Implement cost optimization strategies and ensure efficient utilization of database resources. · Perform database migrations, upgrades, and patching activities with minimal downtime and risk. · Implement and manage database backups, replication, and disaster recovery strategies to ensure data integrity and availability. · Continuously improve database infrastructure and architecture to support evolving business needs and best practices and optimal flexibility. · Utilize Python, Bash, Ansible, PowerShell and Terraforms scripting to automate database administration tasks, streamline processes, and enhance operational efficiency. · Automate the configure and manage database security policies, access controls, and encryption in compliance with industry standards and regulations. · Utilize Terraforms for managing cloud resources and deployments, ensuring consistency and reliability in infrastructure management. · Collaborate with DevOps teams to integrate database deployments into CI/CD pipelines and automate release processes. · Ensure all automation is robust, reusable, and adheres to industry standards. · Implement and enforce security best practices for Data Platforms in a hybrid cloud environment. · Ensure compliance with relevant regulations and internal policies through proper configuration and auditing. · Document database configurations, procedures, and best practices for knowledge sharing and team collaboration. · Provide support and troubleshooting assistance to other team members and stakeholders to resolve database-related issues, performance bottlenecks, and scalability challenges in Hybrid cloud environments.

Mandatory skill sets: Oracle DBA and AWS

Preferred skill sets: · Azure

Years of experience required: 5- 8 years

Education qualification: BE/B.Tech/M Tech/MCA

Education (if blank, degree and/or field of study not specified)

Degrees/Field of Study required: Bachelor of Engineering, Master of Engineering

Degrees/Field of Study preferred:

Certifications (if blank, certifications not specified)

Required Skills

Oracle Database

Optional Skills

Accepting Feedback, Accepting Feedback, Active Listening, Analytical Thinking, Client Management, Communication, Creativity, Deliverable Planning, Delivery Management, Developing User Stories, Embracing Change, Emotional Regulation, Empathy, Inclusion, Intellectual Curiosity, IT Business Strategy, IT Consulting, IT Infrastructure, IT Service Management (ITSM), IT Systems Development, Leading Design Workshops, Learning Agility, Market Research, Optimism, Process Improvement {+ 22 more}

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Available for Work Visa Sponsorship?

Government Clearance Required?

Job Posting End Date

Read Full Description
Confirmed a day ago. Posted a day ago.

Discover Similar Jobs

Suggested Articles