back Back to Jobs

Principle Cassandra DBA



Location: Boston, MA
Job # 10121411
Date Posted: 11-07-2017
Principle Cassandra DBA
Location: Watertown, MA or Dallas, TX
Rate: W2 hourly
Start 2 weeks notice

Resumes to: recruiter@romackinc.com
  • 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.
EXPERIENCE: Minimum 8 years related experience
 
REQUIRED SKILLS:
  • 2 years of Cassandra 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:
  • 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