Job Summary
- Company
- C&S Wholesale Grocers, Inc.
- Location
- Keene, NH
- Industries
- Wholesale Trade/Import-Export
- Computer/IT Services
- Food and Beverage Production
- Job Type
- Full Time
- Employee
Senior Teradata Database Administrator
About the Job
C&S Wholesale Grocers, Inc. is the second-largest food wholesaler and 12th largest private company in the nation. Founded in 1918, C&S provides distribution services to supermarkets, retail stores and military bases. 2008 was our best year in our 90 year history.
A senior level Teradata DBA position involving management of Enterprise Data Warehouse databases in a highly dynamic environment. Provide technical expertise to a team in support of operational and project activities related to our business Systems. Provide technical and operational support to other departments and teams in support of their business objectives.
Qualified candidates must have:
• BS Degree, computer science or similar technical discipline, (experience can be substituted for degree).
• Three to five years as a (large Systems) database administrator.
• Experience in a large, 24x7 environment.
• Experience with multi-terabyte, multi-application databases.
• Previous experience in a Teradata or similar MPP environment.
• Ability to write, debug and tune SQL macros, procedures, functions, triggers, etc.
• Solid experience with very large, multi-workload data warehouses.
• High degree of skill with database commands and Teradata utilities such as Teradata Manager, TSET, Visual Explain, ARCMAIN, Priority Scheduler, TASM, etc.
• Advanced knowledge of database administration tasks such as Database Console utilities, security, and workload management.
• Previous experience with issues around database, client tool, and hardware upgrades.
• Ability to write, debug and tune SQL, macros, procedures, functions, triggers, etc.
• Ability to identify / implement primary index & secondary index considerations on tables.
• Ability to identify / implement statistics collection on tables.
• High degree of experience with database monitoring and tuning tools such as Teradata
• Solid experience with the UNIX operating SYSTEM and command set as well as high degree of competence with shell scripting.
• Solid experience with very large, multi-workload data warehouses.
• Familiarity of the capabilities of the Teradata API.
• Define, implement & monitor Teradata Manager alert requirements.
• Ability to create monitoring and alerting scripts as required supporting operational requirements.
• Identify and eliminate data skews by working with the application teams.
• Maintain cron jobs and other admin. scripts on Teradata.
• Identify performance issues and make recommendations for resolution.
• Identify worst performing SQL instances as candidates for tuning
• Ability to independently cater to end users’ adhoc SQL queries, analyze them for performance considerations and work with them on providing solutions that are optimized for run time as well as SYSTEM resource usage.
• Understand and maintain performance management database macros / process.
• Incident management through T@YS.
• Experience in near-active environment and subsequent loading considerations.
• Investigate all SQL through DBQL and PMCP interrogation.
• Manage Roles, Profiles.
• Monitor, dynamically manage and kill sessions.
• Operate database utilities through CNSTerm.
To apply for this position, visit us online at www.cswgcareers.com and apply to requisition #3412.
Working Safely is a Condition of Employment at C&S - An Affirmative Action Employer M/F/D/V
A senior level Teradata DBA position involving management of Enterprise Data Warehouse databases in a highly dynamic environment. Provide technical expertise to a team in support of operational and project activities related to our business Systems. Provide technical and operational support to other departments and teams in support of their business objectives.
Qualified candidates must have:
• BS Degree, computer science or similar technical discipline, (experience can be substituted for degree).
• Three to five years as a (large Systems) database administrator.
• Experience in a large, 24x7 environment.
• Experience with multi-terabyte, multi-application databases.
• Previous experience in a Teradata or similar MPP environment.
• Ability to write, debug and tune SQL macros, procedures, functions, triggers, etc.
• Solid experience with very large, multi-workload data warehouses.
• High degree of skill with database commands and Teradata utilities such as Teradata Manager, TSET, Visual Explain, ARCMAIN, Priority Scheduler, TASM, etc.
• Advanced knowledge of database administration tasks such as Database Console utilities, security, and workload management.
• Previous experience with issues around database, client tool, and hardware upgrades.
• Ability to write, debug and tune SQL, macros, procedures, functions, triggers, etc.
• Ability to identify / implement primary index & secondary index considerations on tables.
• Ability to identify / implement statistics collection on tables.
• High degree of experience with database monitoring and tuning tools such as Teradata
• Solid experience with the UNIX operating SYSTEM and command set as well as high degree of competence with shell scripting.
• Solid experience with very large, multi-workload data warehouses.
• Familiarity of the capabilities of the Teradata API.
• Define, implement & monitor Teradata Manager alert requirements.
• Ability to create monitoring and alerting scripts as required supporting operational requirements.
• Identify and eliminate data skews by working with the application teams.
• Maintain cron jobs and other admin. scripts on Teradata.
• Identify performance issues and make recommendations for resolution.
• Identify worst performing SQL instances as candidates for tuning
• Ability to independently cater to end users’ adhoc SQL queries, analyze them for performance considerations and work with them on providing solutions that are optimized for run time as well as SYSTEM resource usage.
• Understand and maintain performance management database macros / process.
• Incident management through T@YS.
• Experience in near-active environment and subsequent loading considerations.
• Investigate all SQL through DBQL and PMCP interrogation.
• Manage Roles, Profiles.
• Monitor, dynamically manage and kill sessions.
• Operate database utilities through CNSTerm.
To apply for this position, visit us online at www.cswgcareers.com and apply to requisition #3412.
Working Safely is a Condition of Employment at C&S - An Affirmative Action Employer M/F/D/V
Company Tools
Contact Information
C&S Wholesale Grocers, Inc.
