TERADATA - SENIOR LEVEL DBA

Position Description.
Teradata Senior DBA Database Object Management.
Creation and Analysis of various roles and profiles and should be able to do the profiling 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.
Should be able to analyze workload and should be able to configure same in TASM.
Perform DBA related tasks in key areas of System Administration, Database Administration, Backup, Archive & Restore Management, Performance Management & Reporting Manage Production/Development databases in areas like Capacity Planning, Performance Monitoring & Tuning, Strategies Defined for Backup/Recovery Techniques, Space/ User/ Security Management Along With Problem Determination And Resolution.
Support Mainframe administrative functions including Teradata TDP connections..
upport Unix/Linux level process, scripts, and tools for system management and data movement.
utomation of support process using Unix / Linux Scripting, Teradata SPL, Python / Perl.
Error handling and trouble shooting of Teradata load/unload utilities like FastLoad, MultiLoad, FastExport, Tpump, Arc/Restore.
Working closely with DEV team and assisting them in data modeling.
Good knowledge in UNIX Shell scripting and using them to automate data warehouse jobs, Work with Teradata GSO in resolving RDBMS/TMS/BAR related incidents.
Should have worked on Automation on various activities of Teradata.
Should support 24x7 production databases as well as development databases to ensure maximum availability of database resource for various applications Skills.
Database Administration Performance Tuning Teradata Python Unix What you can expect from us.
Insights you can act on While technology is at the heart of our clients’ digital transformation, we understand that people are at the heart of business success.
When you join CGI, you become a trusted advisor, collaborating with colleagues and clients to bring forward actionable insights that deliver meaningful and sustainable outcomes.
We call our employees “members” because they are CGI shareholders and owners, and, as owners, we enjoy working and growing together to build a company we are proud of.
This has been our Dream since , and it has brought us to where we are today—one of the world’s largest independent providers of IT and business consulting services.
At CGI, we recognize the richness that diversity brings.
We strive to create a work culture where everyone belongs, and we collaborate with clients in building more inclusive communities.
As an equal opportunity employer, we empower all our members to succeed and grow.
If you require an accommodation at any point during the recruitment process, please let us know.
We will be happy to assist.
Ready to become part of our success story? Join CGI—where your ideas and actions make a difference.