Pyramid Systems, Inc. - Carrers - Quality Assurance Manager

Pyramid Systems, Inc. - Careers

JOB OPENINGS:

Senior Application Database Developer

Senior Application Database Developer will develop and implement databases and their policies and procedures to ensure the integrity of the data, performance stability and scalability, and the databases are working properly in conjunction with the applications. He/She will perform complete system data design based upon business requirements, as well as prepare project plans and estimates for all database-related project elements. The Database Developer will mentor junior developers and work as a team member to improve group processes and set standards. He/She will manage client expectations in order to make every customer a positive reference.

Duties and Responsibilities:

  • Manages the design and modeling of front-end application and the RDBMS back-end schema, including the assurance of appropriate technology controls (i.e. normalization, referential integrity, etc)
  • Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process
  • Writes codes 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 specify identifiers of database-to-database management system
  • Analyzes, summarizes and/or reviews data; reports findings; interprets results and/or makes recommendations
  • Designs and implements Object Relational mapping systems for performance and flexibility
  • Designs, develops, and implements modifications necessary to correct software defects and implements enhancements based on requirements provided by the client
  • Investigates and resolves application errors identified by client or users

Qualifications:

Education/Certification:

  • Bachelorís degree in related field, Oracle or MS SQL certification preferred.

Experience Required:

  • Minimum five years experience in the field or in a related area
  • Minimum five years experience with at least one of the following databases: Oracle 9G, 10G, MS SQL Server 2005
  • Minimum five to seven years experience with triggers and stored procedures
  • Minimum two years experience with ERWIN, Data Modeling UML, O/R Mapping
  • Minimum two years experience DBA warehousing, architecture design, and optimization of medium to large size databases with
    200+ tables
  • Demonstrated strong communication and presentation skills
  • Problem solver
  • Self-motivated, self-starter able to work effectively on his/her own with minimal supervision

 

 

Pyramid Systems, Inc.
703.553.0800  | 9302 Lee Highway Suite 1200, Fairfax, VA 22031