ADMINISTRATOR L3(CONTRACT)

Wipro Limited (NYSE: WIT, BSE: 507685, NSE: WIPRO) is a leading technology services and consulting company focused on building innovative solutions that address clients’ most complex digital transformation needs. Leveraging our holistic portfolio of capabilities in consulting, design, engineering, and operations, we help clients realize their boldest ambitions and build future-ready, sustainable businesses. With over 230,000 employees and business partners across 65 countries, we deliver on the promise of helping our customers, colleagues, and communities thrive in an ever-changing world. For additional information, visit us at www.wipro.com.

Job Description

Role Purpose

The purpose of this role is to resolve priority incident tickets and service requests while contributing to incident analysis, change request preparation, and continuous service improvement.

͏

Areas of responsibility

Triaging and resolution of tickets-"Perform initial triage for high priority incident tickets (P2 tickets) which may have an impact across one or more processes and resolve priority incident (P3) tickets within defined SLAs.

Create log of incidents and Document observations and related root causes, to support in evaluation of mitigation measures. "

Resolution of service Requests-Fulfil software/hardware/network service requests within agreed timeline, ensuring timely completion and adherence to SLAs while maintaining quality and accuracy in request handling.

SLA Monitoring-Monitor SLA timelines for entire lifecycle of high priority incident tickets (P2 tickets). Escalate as needed and participate in weekly or monthly service review meetings with clients and internal teams.

Change request execution-"Create change requests as per the priority of the incident tickets in adherence with the defined guidelines.

Present changes for approval with rollback plans in change approval meetings. Execute approved changes and document post-implementation outcomes."

Incident Analysis-"Analyse nature of incidents to support root cause analysis and related service improvement plans.

Contribute towards development of mitigation action to reduce repeat incidents, by identifying patterns of issues noted."

͏

͏

͏

Mandatory skills;

• Requires related experience in the design, maintenance, and administration of Postgres (Open Source, EDB and AWS Aurora).
• Highly knowledgeable of Postgres architecture and Internals for all Postgres flavours (EBD and AWS Auroara).
• Proficient with Postgresql installation and configuration, particularly Postgresql Plus Advanced Server from EnterpriseDB

Rates including mark up - 110K/M

Location - Pune 

Exp - 5+ years.

Title And Summary

Lead Platform Engineer

The Database Engineering team is looking for a Lead Platform Engineer to drive our customer experience strategy forward by consistently innovating and problem-solving. The ideal candidate is passionate about the customer experience journey, highly motivated, intellectually curious, analytical, and possesses an entrepreneurial mindset.

Description
• Relevant more than 7 - 15 plus Years of experience handling Postgres Database (On-Prem and Cloud). Knowledge of Cassandra, Redis and Oracle is added advantage.
• Ability to work on database setup of public cloud (like AWS and Azure).
• Responsible for installation, configuration, applying patching, DB upgrades, object creations and administration of Postgres databases.
• Implement proactive monitoring and observability dashboards of all databases to predict and diagnose the majority of problems before they impact application performance or user experience. Create dashboard and configure alerts on Splunk, Dynatrace, and PEM.
• Configure and manage Postgres Installation, replication, upgrades, applying minor patching activities.
• Good problem solving and troubleshooting skills.
• Manage user access and security: Set up user accounts and ensure database security protocols are followed.
• Backup and recovery: Implement backup and recovery plans to protect data against loss.
• Undertake periodic upgrades of database schema and perform testing and verification of released database schema upgrades.
• Support the installation and configuration of Databases for high availability.
• Work on maintaining database security (roles, privileges, authentication)
• Work with auditors (ISA and QSA) to support internal and external audits (like PCI).
• Create and maintain documentation, procedures and best practice guides for database deployment and maintenance
• Uses strong writing and verbal communication skills to build awareness and to proactively promote DBA’s position in support of sound database structures, data governance and other Corporate strategies.
• Displays excellent collaborative skills with cross-functional teams.
• Provide positive customer service to internal business partners.
• Ability to multi-task and prioritize efforts.
• Ability to pick up new technologies at a quick pace.
• Ability to work with team members located in multiple geographies.
• Researches and implements modern technologies to enhance/grow existing database infrastructure and performs proof-of-concept research on behalf of Database Engineering.
• Create and deliver presentations for internal learning, training events, and/or business discussions with strategic partnership that is tailored to the audience.
• Drive intellectual property development and use for projects, team, and Database Engineering.
• Sharp shooters in identifying, troubleshooting, and resolving complex technical challenges or operational issues across Mastercard.

Education (preferred)
• Bachelor’s Degree in Computer Science, Information systems or equivalent experience.

[About You]
• Requires related experience in the design, maintenance, and administration of Postgres (Open Source, EDB and AWS Aurora).
• Highly knowledgeable of Postgres architecture and Internals for all Postgres flavours (EBD and AWS Auroara).
• Proficient with Postgresql installation and configuration, particularly Postgresql Plus Advanced Server from EnterpriseDB
• Observability and Monitoring - Proficient with Postgresql monitoring and alerting tools/processes specifically PEM from EnterpriseDB. Knowledge of Splunk, Dynatrace and similar tools.
• Experience in Postgres replication technologies. Proficient in setup, configuration and monitoring of Postgresql binary and logical data replication solutions (Binary Streaming, XDB and Bi-Directional Replication – BDR,..)
• Proficient with collecting diagnostics and tuning Postgresql as well as SQL tuning
• Proficient with Postgresql procedural languages (PL/pgSQL, PL/Tcl, PL/Perl, PL/Python) and SQL
• Working knowledge of AWS Aurora. Install and configure Amazon Aurora instances.
• Enforce database security policies including IAM roles, encryption, and auditing.
• Set up proactive monitoring using CloudWatch, Performance Insights, and custom alerts.
• Excellent troubleshooting skills.
• Perform debugging, tuning and performance enhancement as well as automation of operational and continuous integration aspect of the Postgres platforms. Can run EXPLAIN and do access path optimization.
• Proficient with collecting diagnostics and tuning Postgres as well as SQL tuning
• Proficient with the Linux operating system, specifically Oracle Linux Enterprise.
• Implement and manage database version control using tools like Flyway.
• Use AWS services like CloudFormation, Lambda, and CloudWatch for orchestration.
• Integrate database operations with CI/CD pipelines using tools like Bitbucket, Github, Jenkins, XLR, CloudFormation, Terraform, and AWS Lambda.
• Working knowledge of Data Modelling.
• Strong knowledge of linux/unix environment. Working knowledge of scripting languages, Bash, ksh, perl etc.
• Knowledge of ITSM process and tools (like Remedy).
• Knowledge of other cloud-native and NoSQL database technologies, such Cassandra, and Redis is a bonus.
• Uses strong verbal and written communication skills to build awareness and to proactively promote DBA’s position in support of sound database structures, data governance and other Corporate strategies.

Corporate Security Responsibility

All activities involving access to Mastercard assets, information, and networks comes with an inherent risk to the organization and, therefore, it is expected that every person working for, or on behalf of, Mastercard is responsible for information security and must:
• Abide by Mastercard’s security policies and practices;
• Ensure the confidentiality and integrity of the information being accessed;
• Report any suspected information security violation or breach, and
• Complete all periodic mandatory security trainings in accordance with Mastercard’s guidelines.

Mandatory Skills: PostgreSQL Database Admin . Experience: 3-5 Years . Reinvent your world. We are building a modern Wipro. We are an end-to-end digital transformation partner with the boldest ambitions. To realize them, we need people inspired by reinvention. Of yourself, your career, and your skills. We want to see the constant evolution of our business and our industry. It has always been in our DNA - as the world around us changes, so do we. Join a business powered by purpose and a place that empowers you to design your own reinvention.