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.

Those in software engineering at PwC will focus on developing innovative software solutions to drive digital transformation and enhance business performance. In this field, you will use your knowledge to design, code, and test cutting-edge applications that revolutionise industries and deliver exceptional user experiences.

*Why PWCAt 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:

We are seeking a highly skilled Database Administrator (DBA) with extensive hands-on experience in managing AWS OpenSearch or Elasticsearch clusters, as well as expertise in in-memory databases (e.g., Redis, Memcached) or graph databases (e.g., Neo4j). The ideal candidate will have a deep understanding of data and index shard management, schema planning, and data modelling for distributed search, in-memory, and graph-based systems. Additionally, the candidate must be proficient in DevOps tools and have experience managing critical production systems that directly impact revenue. The role requires a proactive learner capable of adapting quickly to new technologies in a fast-paced environment.

Key Responsibilities

· Manage and optimize AWS OpenSearch/Elasticsearch, in-memory (e.g., Redis, Memcached), and graph database (e.g., Neo4j) clusters for high availability and performance.

· Optimize data distribution, sharding, caching, and graph traversals for efficient query performance.

· Design schemas and data models for search, caching, and graph-based use cases.

· Tune query performance and indexing strategies to meet SLAs for critical production systems.

· Automate deployment, scaling, and monitoring using DevOps tools (e.g., Terraform, Ansible, Docker, Kubernetes).

· Troubleshoot and resolve issues in real-time for revenue-impacting systems.

· Implement monitoring and alerting (e.g., CloudWatch, Prometheus) to detect performance issues.

· Ensure security and compliance with encryption and access controls (IAM, VPC).

· Collaborate with development and DevOps teams for application integration.

· Stay updated on advancements in relevant database technologies.

Requirements and Skills:

· 5+ years managing AWS OpenSearch or Elasticsearch in production.

· 2+ years managing in-memory databases (e.g., Redis, Memcached) or graph databases (e.g., Neo4j).

· Proven track record with critical production systems impacting revenue.

· Expertise in data and index shard management, caching strategies, and node-relationship modelling.

· Strong experience in schema design and data modelling for search, caching, and graph use cases.

Technical Skills:

· Proficient in AWS services (e.g., OpenSearch Service, EC2, ElastiCache, CloudWatch).

· Advanced knowledge of Elasticsearch/OpenSearch APIs, query DSL, and optimization.

· Experience with in-memory databases (e.g., Redis, Memcached) or graph databases (e.g., Neo4j Cypher).

· Skilled in DevOps tools:

· IaC: Terraform, CloudFormation

o Configuration: Ansible, Chef, Puppet

o CI/CD: Jenkins, GitLab CI, GitHub Actions

o Containerization: Docker, Kubernetes

o Monitoring: Prometheus, Grafana, ELK Stack

· Familiarity with scripting (e.g., Python, Bash) for automation.

Soft Skills:

· Strong problem-solving and analytical skills for distributed systems.

· Quick learner, adaptable to new tools and processes.

· Excellent communication and collaboration skills.

Certifications (Preferred):

· AWS Certified Solutions Architect, AWS Certified Database – Specialty, or Elastic Certified Engineer.

· Neo4j Certified Professional or Redis-related certifications.

· DevOps certifications (e.g., Docker, Kubernetes).

Good-to-Have

· Experience with other AWS databases (e.g., RDS, DynamoDB, Neptune).

· Knowledge of big data tools (e.g., Hadoop, Spark, Kafka).

· Familiarity with log analytics platforms (e.g., ELK Stack, Splunk).

Responsibilities of the Job Include (But Not Limited To):

· Serve as primary POC for advanced-level troubleshooting and perform hands-on DB/system administration

· Automate regular administrative tasks and ensure correctness

· Document data standards, procedures, and dictionary definitions

· Collaborate with SREs and developers on DB design, performance tuning, and production support

· Help evolve application/database architecture and support environment creation

· Respond to on-call incidents, and support technical queries from staff, management, and vendors

Mandatory skill sets:

· Expertise in Selenium with any programming language (Cypress, Java, Python, C#, Java script) · - Logical programming and debugging skills. · - Automation framework development/enhancement experience is a must. · - Experience in robot framework is a plus. · - Experience in a fast-paced agile environment. · - Good interpersonal and communication skills · - Good debugging skills and an ability to identify issues quickly and effectively · - Experience in developing automation framework for testing Restful web services · - Experience in Jenkins, configuring jobs, executing TestNG test cases from Jenkins · - Good Understanding about Data structure and algorithms · - Good knowledge on Relational Database/SQL Queries · - Worked on Manual functional/regression/integration testing · - Strong understanding of APIs and experience of automating APIs · Logs/monitoring: browser dev tools, Kibana/CloudWatch (nice-to-have).

Preferred skill sets:

· Cypress, Java, Python, C#, Java script

Years of experience required:

Overall 5 - 10 Years

Education qualification:

B-Tech / MCA

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

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

Degrees/Field of Study preferred:

Certifications (if blank, certifications not specified)

Required Skills

Java

Optional Skills

Acceptance Test Driven Development (ATDD), Acceptance Test Driven Development (ATDD), Accepting Feedback, Active Listening, Analytical Thinking, Android, API Management, Appian (Platform), Application Development, Application Frameworks, Application Lifecycle Management, Application Software, Business Process Improvement, Business Process Management (BPM), Business Requirements Analysis, C#.NET, C++ Programming Language, Client Management, Code Review, Coding Standards, Communication, Computer Engineering, Computer Science, Continuous Integration/Continuous Delivery (CI/CD), Creativity {+ 46 more}

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Not Specified

Available for Work Visa Sponsorship?

No

Government Clearance Required?

No

Job Posting End Date