Sr Teradata DBA
Union, NJ 07083
This position is responsible for primarily supporting Teradata environment that will include configuration, administration and maintenance of non-production and production environments. This position must have advanced working knowledge of Teradata RDBMS at both physical and logical levels. This role works closely with BI Analytics, Data Modelers, QA, ETL and other groups. Typically this role supports multiple, technically complex, mission-critical, and/or high-profile Projects. This individual must possess strong Administration Skills including the ability to make sound Database recommendations.
Essential Job Functions:
? Manage/Monitor system performance, including workload management
? Manage/Monitor Query performance and tuning, physical node behavior, and amp distribution
? Support multiple Teradata systems including Data marts, development, and the enterprise warehouse systems and business applications.
? Responsible for implementation and release of database changes as submitted by the development team.
? Provide weekend /off hour Support as Required
? Take care of production deployments.
? Consult on physical database implementations, PPI, skew analysis, join methods, and data access paths.
? Support Unix level process, scripts, and tools for system management and data movement
? Support development and consult on practices of storage management, archive, restore, and disaster recovery
? Work with Teradata GSC in resolving RDBMS related incidents.
? Responsible for improvement and maintenance of the databases to include rollout and upgrades
? Install, configure and upgrade Teradata software and related products.
? Proactively monitor the database systems to ensure secure services with minimum downtime
? Implement and administer access policies in conjunction with corporate standards.
? Help ETL Developers to fine tune the SQL’ s
? Manage DBMS configuration changes.
? Take care of Pack Disk, Scan Disk
? Backup, restore, migrate Teradata data and objects from Production to dev
? Excellent communication (written and verbal). Full life cycle experience in Data Warehousing Data Integration, and Data Management.
? 10+ years - Overall IT experience.
? 10 years - DBA experience; must be proficient in both logical physical database designs.
? 8 Years – Teradata DBA Experience.( Teradata V15 & Higher)
? 3 years – Advance Shell scripting.
? Proficient in Teradata Tools and client utilities including Tara Gui
? Other RDBMS database experience is a plus ( Netezza, Kognitio, SQL server)
? BS/MS degree, applicable certifications or equivalent experience required.
? High-level problem solving and technical experience.
? Advanced knowledge of Teradata Architecture and system internals
? Extensive experience in administering large databases
? Advance Teradata Certification
? Expert understanding of business application
? Expert Database Physical, Logical design/SQL skills
Ken Peters co-founded The Connors Group in June, 2001 and has been responsible for building the foundation of this premier IT staffing organization that serves clients in the areas of executive search, staff placements and consulting services. Ken has over 23 years experience in information technology and IT recruiting.
Ken’s IT background gives him a unique prospective to what an employer is looking for in an IT professional, as well as what’s important to a prospective candidate.
Handling the operations side of The Connors Group, Ken is always looking to leverage technology to create a world class infrastructure. Implementing this technology gives Connors a competitive edge, and adds tremendous value to our clients, and candidates.