facebook Twitter LinkedIn

Principle Database Administrator

Location: Watertown, MA
Date Posted: 01-11-2018
COMPANY OVERVIEW: The client is a global technology company that touches nearly every aspect of travel. Their innovative software enables more than a billion people around the world to plan, book and experience their travel at a time and price that is right for them. By delivering the technology behind travel, the client is working magic behind the scenes every day to make the world a better place, one journey at a time.

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.  Create DB standards and coding conventions.  Introduce, implement and manages mechanisms of database code versioning.  Work with Database Operations Team.

EDUCATION:  Bachelor's degree or equivalent

EXPERIENCE: Minimum 8 years related experience REQUIRED

SKILLS:  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:  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.
this job portal is powered by CATS