IN_Senior Associate_SQL_Digital Integration_Advisory_Gurugram at pwc

c, Telangana, India -

Full Time

Start Date

Immediate

Expiry Date

27 Mar, 26

Salary

0.0

Posted On

27 Dec, 25

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL, NoSQL, MongoDB, Database Administration, Database Development, Data Modeling, Performance Tuning, Query Optimization, Data Governance, Cloud Solutions, Automation, Scripting, Collaboration, Problem Solving, Communication, Agile

Industry

Professional Services

Description

Line of Service Advisory Industry/Sector Not Applicable Specialism Guidewire 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. Looking for an experienced Senior Database Administrator (DBA) and Developer with 6-8 years of hands-on experience working with both SQL and NoSQL databases. Candidate is expected to have strong expertise in designing, developing, and optimizing complex queries, including aggregate queries, joins, and projections, with a deep understanding of data normalization principles. A strong specialization in MongoDB Atlas is essential, who will lead efforts in managing and scaling cloud-based NoSQL data infrastructure. Responsibilities · Design, develop, and maintain complex database architectures for both SQL (e.g., MS SQL Server, MySQL, PostgreSQL) and NoSQL (primarily MongoDB & MongoDB Atlas) environments. · Write and optimize aggregate queries, joins, and projection operations to maximize query performance and efficiency. · Apply advanced normalization techniques to improve data integrity and reduce redundancy. · Manage database security, backup, and recovery strategies to ensure high availability and data protection. · Lead database migration and replication projects across on-premises and cloud platforms (MongoDB Atlas). · Collaborate with software development teams to design efficient data models and robust query solutions. · Monitor database performance, identify bottlenecks, and implement remediation strategies. · Develop automated scripts and tools for database maintenance, monitoring, and optimization. · Provide expert guidance on data governance, compliance, and best practices related to SQL and NoSQL technologies. · Mentor junior DBAs and developers, conducting code and query reviews to ensure quality standards. · Stay up to date with emerging trends and technologies in database design, development, and cloud solutions. · Bachelor’s degree in Computer Science, Information Technology, or a related field. · 6-8 years of professional experience as a DBA and database developer focused on SQL and NoSQL databases. · Strong proficiency in MongoDB and MongoDB Atlas, including experience designing schemas optimized for aggregation pipelines. · Proven expertise writing complex aggregate queries, joins, projections, and manipulating data structures effectively. · Deep understanding of normalization and denormalization techniques and when to apply each. · Hands-on experience with relational databases such as MS SQL Server, MySQL, PostgreSQL, or similar. · Skilled in performance tuning and query optimization across both SQL and NoSQL platforms. · Experience with cloud platforms and database-as-a-service environments, especially MongoDB Atlas. · Strong scripting skills (e.g., Python, Shell, PowerShell) for automation and tooling. · Familiarity with database security best practices, backup/restore, and disaster recovery planning. · Excellent problem-solving skills and the ability to troubleshoot complex database issues. · Strong communication and collaboration skills with an ability to work effectively both independently and in cross-functional teams. Preferred Qualification & Knowledge · MongoDB Certified DBA or Developer certification. · Experience with containerization and orchestration tools such as Docker and Kubernetes. · Knowledge of monitoring tools like Prometheus, Grafana, or MongoDB Ops Manager, Kibana. · Experience working in Agile/Scrum software development environments. · Familiarity with data modeling tools and visualization platforms. · Knowledge of ElasticSearch including cluster setup, index management, query DSL, relevancy tuning, and performance optimization is preferred. Mandatory skill sets: SQL Preferred skill sets: SQL Years of experience required - 6-8 years Education Qualification: B.E or B.Tech Education (if blank, degree and/or field of study not specified) Degrees/Field of Study required: Bachelor of Engineering, Bachelor of Technology Degrees/Field of Study preferred: Certifications (if blank, certifications not specified) Required Skills Structured Query Language (SQL) 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 Not Specified Available for Work Visa Sponsorship? No Government Clearance Required? No Job Posting End Date Are you ready to make a difference? Want to unlock new value by applying your unique perspective and talents? You can grow exponentially at PwC. Here, you can uncover hidden talents, build lifelong relationships rooted in trust and empathy and turn challenges into opportunities for innovation. We’ll help you grow your skills through challenging, meaningful work so you can go further.

How To Apply:

Incase you would like to apply to this job directly from the source, please click here

Responsibilities

The role involves designing, developing, and maintaining complex database architectures for both SQL and NoSQL environments. Additionally, the candidate will manage database security, lead migration projects, and mentor junior team members.