IN- Associate_ Application Support – SQL DBA Admin _IN IT Services CO_IFS_PAN India
PwC.com
Office
Pune, India
Full Time
Line Of Service
Internal Firm ServicesIndustry/Sector
Not ApplicableSpecialism
IFS - Internal Firm Services - OtherManagement Level
AssociateJob Description & Summary
At PwC, our people in infrastructure focus on designing and implementing robust, secure IT systems that support business operations. They enable the smooth functioning of networks, servers, and data centres to optimise performance and minimise downtime.In infrastructure engineering at PwC, you will focus on designing and implementing robust and scalable technology infrastructure solutions for clients. Your work will involve network architecture, server management, and cloud computing experience.
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:
As Support Technician, you provide first-line technical assistance and support for queries and issues related to the Database. This role involves troubleshooting, resolving technical problems, configuration and manage the database
Responsibilities:
- Provide front-line support for SQL databases, application configuration files, and Azure infrastructure.
- Ensure availability, performance, security and compliance across supported Databases.
- Monitor alerts and tickets (ServiceNow/Jira) for SQL/Azure/app configuration issues.
- Support Azure SQL Database and/or SQL Server instances: connectivity, failover, DTU/vCore sizing basics, firewall rules, auditing, threat detection.
- Monitor health using SSMS, Azure Monitor/Log Analytics, and built-in metrics; respond to deadlocks, blocking, and slow queries.
- Maintain and validate application config files (JSON, YAML, XML, INI, web.config/appsettings.json)
- Perform Implement environment-specific settings; manage secrets through Key Vault or equivalent
- Provision and support Azure resources: VMs, Azure SQL Database, Storage, App Services, VNets/NSGs, Azure Monitor/Log Analytics, Key Vault
- Perform patching, certificate management (TLS), and basic networking (DNS, IP, ports).
- Set up alerts, dashboards, and runbooks for operational tasks.
- Assist with deployments via Azure DevOps/GitHub Actions; troubleshoot build and release pipelines.
- Maintain documentation: runbooks, known issues, topology diagrams, standards.
Meet SLAs for response and resolution; track metrics and report status.
Mandatory Skill Sets:
Azure SQL Database Support
- Execute routine database tasks: backups, restores, user provisioning, role management, and basic performance checks.
- Run and optimize basic queries; assist with index maintenance and statistics updates under guidance.
- Support Azure SQL Database and/or SQL Server instances: connectivity, failover, DTU/vCore sizing basics, firewall rules, auditing, threat detection.
- Monitor health using SSMS, Azure Monitor/Log Analytics, and built-in metrics; respond to deadlocks, blocking, and slow queries per runbook.
Configuration File Management
- Maintain and validate application config files (JSON, YAML, XML, INI, web.config/appsettings.json).
- Implement environment-specific settings; manage secrets through Key Vault or equivalent (no secrets in source control).
- Use version control (Git) and CI/CD to track changes, reviews, and deployments.
- Apply linting/validation tools; ensure rollback and change approval processes are followed.
Preferred Skill Sets:
- Curiosity: A natural curiosity and eagerness to learn, explore new ideas, and see past the status quo. • Collaboration: A natural collaborator, suited to work in a collaborative culture with a diverse and talented team that values collaboration, constructive challenging and mutual respect. · • Challenge: Demonstrates the capability to question and challenge ideas, decisions, and processes in a constructive manner, fostering a culture of continuous improvement and innovation while maintaining respect and professionalism in all interactions. • Value Driven: Demonstrates a strong commitment to ethical principles and organizational values, ensuring that all actions and decisions align with the company's mission and integrity standards. • Friendly and approachable. • Patient and understanding. • Resilient and adaptable. • Willingness to learn and grow in the Support Team and keep abreast with industry trends.
Years Of Experience Required:
3+ Yrs
Education Qualification:
Bachelor’S Degree
Education (if blank, degree and/or field of study not specified)
Degrees/Field of Study required: Bachelor of EngineeringDegrees/Field of Study preferred:Certifications (if blank, certifications not specified)
Required Skills
Structured Query Language (SQL)Optional Skills
Accepting Feedback, Accepting Feedback, Active Listening, Amazon Web Services (AWS), Architectural Engineering, Business Continuity, Cloud Architectures, Cloud Compliance, Cloud Infrastructure, Cloud Migration, Cloud Virtualization, Communication, Continuous Deployment, Continuous Integration/Continuous Delivery (CI/CD), Data Infrastructure, DevOps Practices, Disaster Recovery, Emotional Regulation, Empathy, Google Cloud Platform, Hardware Troubleshooting, Hybrid Cloud, Identity and Access Management (IAM), Inclusion, Infrastructure Architecture {+ 26 more}Desired Languages (If blank, desired languages not specified)
Travel Requirements
Not SpecifiedAvailable for Work Visa Sponsorship?
NoGovernment Clearance Required?
NoJob Posting End Date