IN_Senior Associate_Oracle DBA _Advisory Corporate_Advisory_Bangalore

Specialism

Management Level

& Summary

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 purposeled and valuesdriven 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 .

& 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 MSSQL 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 crossfunctional 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 databaserelated 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

Required Skills

Travel Requirements

Government Clearance Required?