Pyramid Systems, Inc.

  • Senior Data Integration Engineer/DBA III

    Job Locations US-DC
    Posted Date 5 days ago(8/13/2019 8:40 PM)
    Job ID
    2019-1267
    # of Openings
    1
  • Overview

    Pyramid Systems is looking for an experienced Data Integration Engineer with a passion for building modern and innovative data solutions. The Data Integration Engineer administers, maintains, develops, and implements databases, data transformation, and messaging platforms while focusing on the integrity and security of the data; maximizing the performance, stability, and scalability of the system; and solving unique and complex interoperability challenges.

    Responsibilities

    • Reviews, evaluates, designs, implements and maintains database(s)
    • Writes SQL code for database access, modifications, and constructions including stored procedures
    • Codes, tests, and implements physical database, applying knowledge of database management system
    • Designs logical and physical databases or reviews description of changes to database design
    • Codes database descriptions and specifies identifiers of database-to-database management system
    • Analyses, summarizes and/or reviews data; reports findings; interprets results and/or makes recommendations
    • Design, develop, and implement modifications necessary to correct software defects and implement enhancements based on requirements provided by the client
    • Investigate and resolve application errors identified by client or users
    • Review database logs, detect and resolve database errors, and optimize database and query performance
    • Apply patches, security fixes, and upgrades to existing data tools. Design and plan data architecture based on client needs.
    • Plan, design, and implement data messaging and interoperability solutions based on requirements provided by the client
    • Plan, design, and implement high performance, distributed, data indexing and searching solutions

    Qualifications

    • Minimum 5 years of experience with at least one of the following databases: Oracle, MS SQL Server, MySQL, PostgreSQL, Amazon Aurora
    • Minimum 5 years of experience database architecture design and optimization of medium to large size databases with minimum of 200 tables
    • Minimum 2 years of experience using Java 8 in an enterprise environment
    • Minimum 2 years of experience with at least one of the following technologies: Elasticsearch, Apache Lucene, Apache Solr
    • Experience with an agile software development methodology, including Kanban or Scrum
    • Experience with Amazon Web Services (AWS) Relational Database Service (RDS) using one of the databases listed above a plus.
    • Experience with messaging and interoperability technologies, such as Apache Kafka, AWS Simple Queue Service (SQS), RabbitMQ, ActiveMQ, or IBM Websphere MQ, is a plus

     

    Pyramid is proud to be an equal and diverse Employer. EEO/AAP/M/F/Disabled/Veteran.

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed