A career in Digital Solution Team, within Internal Firm Services, will provide you with the opportunity to support our core business functions by deploying applications that enable our people to work more efficiently and deliver the highest levels of service to our clients. You’ll focus on managing the design and implementation of technology infrastructure within PwC, developing and enhancing both client and internal facing applications within PwC, and providing technology tools that help create a competitive advantage for the Firm to drive strategic business growth.
Our Information Technology Development team helps develop and supports internal information technology systems and applications for use by all staff levels. You’ll help our team develop programs and applications that cater to PwC’s strategic technology needs using your knowledge of technical domains of application.
Ability to create SQL scripts, queries, views and stored procedures along with designing database tables and structures
Work with developers to optimize queries, stored procedure and database design
Troubleshoots and resolves performance-related issues for Postgres plus Advanced Server, Oracle servers
Work with Architects and Senior Engineers on database design and implementation enhancements
Provides technical and operational database administration. Installs, maintains, develops and implements policies and procedures for ensuring the security, availability and integrity of the company databases and large data warehouse database environments.
Provides analysis and definitions of technical standards related to database resources.
Provides analysis and design function for new and existing systems.
Provide support resolving conversion and upgrade data issues. Liaise with Project Managers, Business Analysts, Developers for the definition and clarification of requirements and to facilitate the progress on project tasks.
Performs other duties as assigned.
Bachelor/Master degree holder
Much experience as database developer on Oracle servers
Very good knowledge of SQL scripts including Stored Procedures, PSQL scripting, SQL Monitoring tools and Performance monitoring and tuning
Ability to proactively identify, troubleshoot and resolve live database systems issues
Knowledge of Disaster Recovery principles and practices including planning, testing, backup/restore
Practical experience in managing the internal and external database security
Knowledge and experience in qualifying, staging and deploying of specialized software pieces into a complex production hosting center
Good to have exposure to NoSQL databases like MongoDB, Cassandra etc.
Good to have scripting knowledge (WS script, PowerShell, DOS and Batch scripts)
Education (if blank, degree and/or field of study not specified)
Degrees/Field of Study required: Bachelor DegreeDegrees/Field of Study preferred:
Certifications (if blank, certifications not specified)
Desired Languages (If blank, desired languages not specified)