Teradata Admin :: :: Bangalore

Squircle IT Consulting Services is a leading IT solutions and services company established with a specific mission of providing comprehensive, top of the line solutions around ERP and BI. Since its inception in November, 2007, SQUIRCLE has emerged as a key player in ERP and BI space. SQUIRCLE brings together the best Technology and Domain expertise in PeopleSoft to offer a full spectrum of services ranging from Implementation, Business Consulting to Support.

No Relocation.
Please Line up candidates for Teradata Admin.

Walkin:
For Permanent: Wednesday 28th Dec 2016.(Timing-11 AM to 3 PM)
For Contract: Tuesday 27th Dec 2016. (Timing-11 AM to 3 PM)

POC: Prakhar

Client : Brillio
Location : Bangalore ( RMZ Eco space)
Experience : Junior-3+ Year, Lead-5+
NP : Max 20 Days
Rate : 7.5 LPA Max(3-5 Years), 5+ Years: Open (13 LPA Max)
Position : Perm/Contract
NP ::25DAYS MAX
Job Description:
Contract duration- 4-6+ months (contract may extend based on project demand). Conversion of candidate totally depend on Project demand and consultant performance.

The L2 – DBA – Teradata resource, should have knowledge of the following:

Database Object Management:
· The creation, update and deletion of database objects such as Databases, Views, Users, Roles and Profiles etc.

System Performance:
· System monitoring using view point, Performance tuning of queries, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI and USI and NUSI and JI etc) etc. Analyzing explain

Workload Management:
· Resource partitions, classify and govern the query before its execution in the database.

Resource Monitoring:
· Database Query Log(DBQL) , ResUsage, Access Logging

User Management:
· Creation and managing Users, Databases, Roles, Profiles and Accounts. Assigning profiles, granting or revoking access rights or roles, changing of passwords etc.

Space Management:
· Managing the allocation of database space (Permanent Space, Spool Space and Temporary Space) across the entire system.
· Recording and tracking of Space Movements to assist with capacity planning and forecasting.
· Using techniques such as Multi-value compression (MVC) and BLC to reduce unnecessary disk space usage.

Access of Database Objects:
Granting and Revoking Access Rights on different database objects.

Security Control:
· Handling logon and logoff rules for Users.
· Implementation of TDWallet.

System Maintenance:
· Specification of system defaults, restart etc.

Capacity Planning & Management:
· Analyze the past and current data to predict the future capacity (CPU processing and Storage) requirements

Data Storage and Management:
· Archiving and restoring data using the Teradata DSA and ARCMAIN utility.

Load/Unload utilities:
· Using Mload, TPT, Fastload, Fastexport, Bteq Utilities.
· Expert in Datamovement Utilities like Datamover.

Query Grid:
· Implementation of QueryGrid and Foreign Servers.

Incident Management:
· Experience in handling live incident related to Teradata system

Hi,

We have multiple openings for different location, for different clients. If you are interesting in  plz find the attached details. 

Closing Block

Full Name (As per PAN CARD): 

Self Mobile number: 

Alternate Number: 

Email Address: 

Total Experience: 

Relevant Experience: 

Highest Qualification (Degree): 

Current Employer name (Payroll): 

Current Designation: 

Current CTC (Annual) 

Expected CTC (Annual) 

Official Notice Period (As per Offer Letter): 

Can join in (Days): 

Any Interviews / Offers in Pipeline: 

Current Location: 

Work / Requirement Location: 

Date of Birth: 

PAN card Number: 

Interview Timings: