Database Administrator(Oracle + SQL server)

PwC; Hyderabad, Gurugram District, Bengaluru; On-site; INR 900,000 - 1,300,000; Full time

Job summary

PwC in Hyderabad is seeking a database specialist to support and optimize multiple database environments. You will handle installation, configuration, patching, backup-recovery, and replication, spanning MySQL, MS-SQL and Oracle GoldenGate within a microservices framework.

You will discuss requirements with clients, address performance and integration issues, and participate in capacity planning and migration between on-prem and cloud environments.

Qualifications

• Experience with installation, configuration, patching, backup-recovery and replication on Linux/Windows.
• Ability to discuss DB requirements with clients and address performance and integration issues.
• Experience migrating databases on-prem to on-prem or on-cloud.
• Production DB support across multiple server versions.
• Design and build solutions for transitioning to microservices architecture.
• Identify trends and opportunities to improve processes and execution.
• Coordinate with management to ensure regulatory compliance.

Responsibilities

• Day-to-day production DB support and maintenance.
• Monitor performance bottlenecks related to CPU, I/O, and memory.
• Handle DB architecture improvements and capacity planning.
• Engage with partners to resolve medium-complexity issues.
• Keep up-to-date with industry regulations and trends.

Skills

MySQL

MS-SQL

Oracle GoldenGate

Linux

Windows

Replication

Backup & Recovery

Patching

Microservices

Performance tuning

Tools

CentOS

DB Migration

Production DB tooling

Job description

Role & responsibilities

Responsibilities

• Database role supports our services that focus on Database technologies, including MySQL, MS-SQL and Oracle Goldengate with Microservices architecture.
• Extensive experience with Installation, Configuration, Patching, Backup-Recovery, Configuring Replication on Linux/Windows and CentOS infrastructure.
• Experience in involving discussion with clients for DB requirements, performance, and integration issues and providing better solutions or approaches along with capacity planning.
• Responsible for identifying and resolving performance bottlenecks in relation to CPU, I/O, Memory, and DB Architecture
• Responsible for Database migration i.e., on-prem to on-prem or on-prem to cloud
• Responsible for resource layout for new application from DB side
• Day-to-Day Production DB support and maintenance of different versions of server database
• Design and build function-centric solutions in the context of transition from traditional, legacy platforms to microservices architectures
• Identifies trends and assess opportunities to improve processes and execution.
• Raises and tracks issues and conflicts, removes barriers, resolves issues of medium complexity involving partners and calls out to appropriate levels when required.
• Solicits and responds to feedback while gaining dedication and support.
• Stays up to date on industry regulations, trends, and technology.
• Coordinates with management to ensure all operational, administrative, and compliance functions within the team are being carried out in accordance with regulatory standard methodologi

Preferred candidate profile

Perks and benefits