Description
My client, a leading consultancy is looking for a Teradata Database Design Specialist.
- Design database structures for new app features and reviews those designed by developers (tables, columns etc.).
- Write SQL queries for new features and reviews those written by developers.
- Help solving stability and performance problems between the application and the database
- Set up databases for new customer implementations.
- Perform cutover data migrations
- Regularly look at performance reports from Prod for catching potential performance problems.
- Manage database structure and code versions.
- Introduce, implement and manages mechanisms of database code
- Work with Database Operations Team
- Ideally 7 years of Experience
- Experience in database analysis, development and reporting.
- Working knowledge of XDB and MDSYS
- Strong understanding of database concepts including normalization, optimization, etc.
- Working knowledge of Oracle including stored procedures, triggers, index optimization, backup and recovery
- Able to design, write or re-engineer database scripts to enhance functionality of system
- Able to establish standards for configuring databases and monitor adherence.
- Experienced at installing and configuring database management software, translating database design and diagnosing database performance issues
- Can solve problems quickly
- Unix/Linux experience on user level is a must
PREFFERED SKILLS:
- Teradata Database Administrator expert, Knowledge of MySQL, SQLite, Pro*C
- Experience with Spring/Hibernate and extracting stored procedures into Java code
- Understanding of Web Servers (Apache, nginx) and PHP
- Experience with profilers, debuggers, monitoring and diagnostic
- Python or other dynamic languages programming skills Specialized Skills & Knowledge:
- Working knowledge of security, system monitoring, tuning, physical database maintenance, back-up recover procedures, upgrades, logical and physical design of database.
- Working knowledge of database security, system monitoring, tuning, physical database maintenance, back-up and recovery procedures and upgrades.
- Documentation: Enters, transcribes, records, stores or maintains information in written or electronic form.
- Able to analyses user needs and product requirements to create a design.
- Able to create, execute, and document the tests necessary to assure that an application or technical environment meets user functional and performance requirements. May also included automation test tools