• Us Citizen

• Green Card

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 1st Jan 2021

Role: Teradata DBA

Location: San Jose, CA

Type: Contract

Duration: 12 Months

NOTE : Except OPT & CPT all visa are acceptable

JD:

- 4+ years working as a Teradata DBA professionally is must.
- Experience working in a production environment with minimal to no downtime allowed.
- Performance monitoring experience utilizing ViewPoint is required.
- Experience handling atleast one cluster with few petabytes of data is required.
- Experience in handling year end maintenance activities right from plan till execution.

Responsibilities:

- Optimizing developer, as well as, users SQL.
- Performance tuning via TASM. Workload Management such as Delay queue monitoring and Changing the system state based on delay queue.
- Monitor Teradata Utility failure/long run /delay.
- Work with incident owners on Security/SOX related issue and bring it to closure.
- Work with incident owners on Single row insert and Guide users to follow the steps to get rid of such queries.
- Design, model, configure, test, and install databases.
- Perform and troubleshoot database backup, recovery, capacity, and security plans.
- Administer, maintain, and implement changes to existing databases to meet Customer requirements.
- Respond to test and production database problems and implement immediate resolution efforts across technology areas.
- Design, create, implement, and support databases to meet project and system design requirements.
- Implement moderately complex changes to existing databases.
- Install and configure new database engines and upgrades to new product releases.
- Implement physical data models at a project level.
- Create, document, and administer, and document database backup and recovery plans, capacity plans and security plans to meet project requirements.
- Analyze and resolve highly problems of medium to high complexity.
- Use database/ system management tools proficiently.
- Monitor and tune existing databases of medium complexity and moderate business exposure.
- Investigate, troubleshoot, and resolve Batch failure/log running problems.
- Notify users on Log responding/idle sessions/Session block and take necessary action.
- Release query manually from Queue by working with operations teams on Job concurrency control.
- Provide general technical support to Services and Development groups.
- Handling year end activities such as analyzing and consolidating  list the table names with expiring partitions and views  where  data restriction need to apply /extend by sending notifications and get signoff
 

Shubhangi Singh
Cell :408-878-6800 / 931-464-2207
IDC Technologies Inc.
www.idctechnologies.com