Back to Job Search

Datawarehouse and Database Admin

Job Description

Job Description

Excellent opportunity for Data Warehouse and Database Admin to be part of our Infrastructure services practice. Cognizant Infrastructure Services - Provides IT infrastructure & Cloud services for clients across industry verticals, including both Consulting/Professional and Managed Services, across Enterprise Computing, Cloud services, DevOps, Data Centres, End User Computing, Service Desk, Network Services and Environment Management Services.

Role Expectations :

  • IBM trained CPD Admin.

  • Working with clients and Architects for

  • requirements and DWH database model.

  • Any Modifications on table structure.

  • Upgrades, estimations any change in architecture of the CPD

  • Capacity Planning based on volume of data

  • Data Warehouse is distributed database, so every table data should be equally divide to all DB partitions and this is Admin responsibilities.

  • Environment monitoring via RedHat Openshift Console and provide RCA for P1/P2 tickets by creating documentation. The same to be discussed with client for approval.

  • Working with DataStage team during data load from Source systems to Data Warehouse environments.

  • Working with integrated application team for performance and report issues.

  • Weekly Cold DR DB refresh with Production DB backups.

  • Performing DB maintenance and movement activities (reorg, runstats, load, import, export, table partitioning).

  • Addressing all environments database related issues faced by the developers.

  • Create and provide required DB connections via CPD.

  • Project creations on CPD.

  • Disk space clean-up for critical load balancer, Master and worker nodes.

  • Attending job failures for CPD environment for e.g. failure due to unavailability of services, DB issues, disc space full etc.

  • Connect with IBM based on Service Request (in case required).

  • Support deployments for UAT, Pre-Prod, PROD and DR environments on Data Warehouse platform.

  • Provides 24x7 production support, problem resolution and recovery processes during an outage of the system.

  • Experienced Database Administrator specializing in IBM DB2 UDB on v8.x, v9.x, v10.x, v11.x and Oracle 10g, 11g on LUW.

  • Including - performance monitoring / tuning, maintenance, data movement, backup and recovery, federation, disaster recovery, HADR, Memory tables, data partitioning, new rollouts, planning for critical activities with less downtime, implementing production changes, DB upgrade and migration activities.

  • DB2 environments build suggestion to Architects and client.

  • HADR setup and configurations.

  • TSAMP v4.5 installation and configurations with successful auto failover functionality.

  • TSM v7.1 installation and configurations for daily and weekly backup setup.

  • Performing backup restoration from net-backup tool to production as per client and data requirement.

  • Creating incident through IBM Maximo for performing daily operations.

  • Performing activities (Like Patches, Backup, restoration, upgradation), As per the change raised by team, client, other teams.

  • Expertise in oracle 10g,11g and 19c administration, space management, database security, troubleshooting and documentation.

  • Managing tablespace by adding and Resizing datafiles, managing Tablespace for Different User by Granting Quota on Default & Temporary Tablespaces.

  • Managing database security. Creating users and roles and assigning different roles to users.

  • Basic Knowledge on RAC and Active Data guard on Oracle 19c.

  • Creating AD-HOC, daily, weekly and monthly reports.

  • Experience on Linux administrative tasks and technical troubleshooting.

  • Has well experience to give support for highly demanding environments such as Banking and Telecom domain with 99.5% SLA.

Application Description

https://tas-cognizant.taleo.net/careersection/testsitephenom/jobdetail.ftl?job=00050563621&lang=en&mediaid=56853&src=PhenomPeople

https://careers.cognizant.com/global/en/job/00050563621/Datawarehouse-and-Database-Admin

Employer Description

Cognizant (Nasdaq-100: CTSH) is one of the world's leading professional services companies, transforming clients' business, operating and technology models for the digital era. Our unique industry-based, consultative approach helps clients envision, build and run more innovative and efficient businesses. Headquartered in the U.S., Cognizant is ranked 185 on the Fortune 500 and is consistently listed among the most admired companies in the world. Learn how Cognizant helps clients lead with digital at www.cognizant.com or follow us @Cognizant.