Pyramid Systems, Inc.

SQL Database Administrator

US-VA-Fairfax
5 hours ago(1/23/2018 9:24 AM)
Job ID
2018-1094
# of Openings
1
Category
Information Technology

Overview

Job Summary: Administers, maintains, develops, and implements databases and their policies and procedures to insure the integrity of the data, performance, stability, and scalability, and that databases are working properly in conjunction with the applications.

Responsibilities

·         Reviews, evaluates, designs, implements and maintains complex database(s)

·         Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process

·         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 data models 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

·         Manage and Administer Medium to Large Scale Databases, Create Backups, Maintenance plans and Disaster Recovery Plans

·         Review Database Logs, Detect and resolve Database errors Optimize database Performance

·         Monitor, identify, and resolve capacity issues.

·         Apply patches, Security Fixes and upgrades to existing Database.Design and Plan Database/Data architecture based on Client needs.

Qualifications

  • Minimum 5 years of experience with MS SQL Server and familiarity with one or more of the following: Oracle, MySQL, PostgreSQL, Amazon Aurora.
  • Minimum 5 years of experience with a data modeling tool such as Erwin
  • Minimum 5 years of experience in database architecture, design and optimization of medium to large size databases with minimum of 200 tables
  • Experience with Amazon Web Services (AWS) Relational Database Service (RDS) using one of the databases listed above is desirable.
  • Experience with migration into cloud solutions a plus.

U.S Citizenship is Required*

 

Education:

  • Bachelor’s degree in related field, or specialized technical training of equivalent length.

Certifications:

  • Microsoft SQL Server Administrator
  • Microsoft SQL Server Developer preferred

Options

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