Compact Solutions Polska Sp. z o.o. is a premier consulting organization focused exclusively on solving the toughest data challenges for information intensive businesses across the world. We specialize in architecting, designing and deploying high-performance enterprise information management solutions which allow business to rapidly glean intelligence from their information assets. We are currently looking for an experienced database administrator to join one of our American projects (working from Krakow’s office or remotely). This position is responsible for primarily supporting Teradata environment and will include configuration, administration and maintenance of non-production and production environments.
Teradata Database Administrator
Miejsce pracy: Kraków
Essential Job Functions:
- Manage system performance, including workload management and throttling in TASM
- 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
- 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
- Manage, design, 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
- Backup, restore, migrate Teradata data and objects from Production to dev
- Responsible for implementation and release of database changes as submitted by the development team
- Provide weekend /off hour Support as Required
Requirements:
- 6 years Teradata DBA Experience (Teradata V13 & Higher)
- Advanced knowledge of Teradata Architecture and system internals
- Working knowledge of Teradata client tools (TDadmin, SQL Assistance , View Point, Visual explain ) and utilities (Bteq, Arcmain, Fastload, Multiload, Tpt,Tpump)
- Minimum 3 years of involvement in implementing & upgrading PDCR releases
- TASM Experience
- Advanced SQL coding/tuning skills
- Advance Shell scripting
- Other RDBMS database experience is a plus ( Netezza, Kognitio, Oracle, SQL server, Mongo DB)
- Expert Database Physical ,Logical design/SQL skill
- Extensive experience in administering large databases
- Expert understanding of business application
In Compact Solutions you can:
- Earn a very attractive salary package reflecting your skills and experience (contract opportunities)
- Work on innovative tools and platforms to solve the most challenging data integration problems
- Work in flexible, friendly and informal environment
- Remote work possibility
- Choose from many benefits: Medical insurance, Multisport card, English lessons etc.
- Use our fun room, library, fully equipped kitchen and other facilities