Apply now »


Work with us

Title:  Lead Administrator - L2

Requisition ID:  80556
City:  London
Country/Region:  GB
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 team requires an experienced Oracle Application DBA to assist the transfer of the Oracle database to the Cloud SQL. The DBA must be experienced with understanding how schemas are configured in Oracle, including stored procedures/functions or other proprietary features of Oracle RDBM system and ideally also experienced in either Postgress or MySQL. The DBA will also ideally be experienced with identifying and rectifying performance issues with SQL queries that we could encounter as part of the transition.

͏

Mandatory Skills:

  • Oracle to Postgres DB migration
  • Postgres DB activities like DB creation, schemas, user, roles, grant permissions
  • Working experience with PL/PG SQL
  • Postgres DBA to assist migrating the Oracle DB to Cloud

--> Knowledge about GCP environment.
--> Knowledge of using the Postgres database/instance in GCP ( Google Cloud Platform)
--> Database Backup and Restore process using both psql and GUI tools like PgAdmin and DBeaver etc..
--> understanding about PITR ( Point n Time Recovery) and HA ( High Availability)
--> Work experience in using tools like PgAdmin and/or DBeaver
--> Writing db objects (function, trigger, procedures etc.) using PL/PgSQL
--> Understanding Postgres database architecture. Database, schemas, roles, users, datafiles, logfiles, config files etc..
--> Working knowledge about creating and managing database roles, users, grants and permissions
--> Working knowledge about creating and managing databases, schema, and schema objects like tables, views, triggers, functions etc..
--> Experience in using the tools like Gitlab, JIRA, Confluence, Miro etc..
--> Oracle knowledge is also required as data migration is from Oracle to Postgres
--> working knowledge about DMS(Data Migrations Services) like migration workspace, db connections profiles and DMS tasks etc. processes in GC

Good to have experience in GCP/AWS environment

  • Good to have knowledge about DVT (data Validation tool) but not mandatory.
  • Good practice in documentation of processes using confluence

͏

͏

Deliver

No Performance Parameter Measure
1 Operations of the tower SLA adherence
Knowledge management
CSAT/ Customer Experience
Identification of risk issues and mitigation plans
Knowledge management
2 New projects Timely delivery
Avoid unauthorised changes 
No formal escalations

͏

Mandatory Skills: Oracle Database Admin .

 

Experience: 8-10 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. Come to Wipro. Realize your ambitions. Applications from people with disabilities are explicitly welcome.

If you encounter any suspicious mail, advertisements, or persons who offer jobs at Wipro, please email us at helpdesk.recruitment@wipro.com. Do not email your resume to this ID as it is not monitored for resumes and career applications.

Any complaints or concerns regarding unethical/unfair hiring practices should be directed to our Ombuds Group at ombuds.person@wipro.com.

We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, caste, creed, religion, gender, marital status, age, ethnic and national origin, gender identity, gender expression, sexual orientation, political orientation, disability status, protected veteran status, or any other characteristic protected by law.

Wipro is committed to creating an accessible, supportive, and inclusive workplace. Reasonable accommodation will be provided to all applicants including persons with disabilities, throughout the recruitment and selection process. Accommodations must be communicated in advance of the application, where possible, and will be reviewed on an individual basis. Wipro provides equal opportunities to all and values diversity.

Apply now »