Senior SQL Developer – Internet of Things

About client

Headquartered in San Diego, California, USA, our client, a subsidiary of Caterpillar Inc., is one of the world’s leading manufacturers of industrial gas turbines, with more than 15,000 units and over 2 billion operating hours in over 100 countries.

Products from Solar Turbines play an important role in the development of oil, natural gas and power generation projects around the world. Solar Turbines’ products include gas turbine engines (rated from 1,500-30,000 horsepower), gas compressors, and gas turbine-powered compressor sets, mechanical-drive packages and generator sets (ranging from 1-22 megawatts).

Solar’s customers put the company’s products to work in many areas including production, processing and pipeline transmission of natural gas and crude oil and generation of electricity and thermal energy for processing applications, such as manufacturing chemicals, pharmaceuticals, and food products.

Job details

We are looking for enthusiastic and motivated Senior SQL Developer who possess excellent communication skills and ability to learn. You will be part of the international team working in agile environment responsible for development of new application for process optimization for turbine spare parts, its tracking and ordering.

Various acquired data will be stored in the database on the client site. Data amount will grow with the time and should be accessible quickly for the analyses.

As a senior developer you will design database schemata preferably normalized, optimize the data storage and access, programming the stored procedures and optimizing the queries. Part of the job is a support for developers to guide them how to access the stored data and provide the necessary documentation. Basic administration knowledge is required.

Job requirements

  • Computer skills – programmer
    • PL/SQL – expert
    • UML – basic
  • DB Architecture
    • Create relational normalized schemata
    • Administration (Access Control and Security)
    • System architecture (Partitioning, Data flow, Clustering, Replication)
  • Databases
    • Oracle
    • MySQL
    • Microsoft SQL – optional
    • SQLite – optional
  • Other
    • Agile software methodology – SCRUM
    • Continuous integration (Jenkins or Hudson tools)
    • Design Patterns
    • NoSQL databases – optional

Other requirements

  • Soft Skills
    • Excellent communication
    • Ability to learn, absorb and apply new knowledge rapidly
    • Working in a team
    • Proactive approach
    • Working under pressure
  • Language Skills
    • English – advanced (both written and verbal)
  • Years of experience: 4+