Title:Database Architect/Sr. Database DeveloperDatabase Architect/Senior Database DeveloperKBR, in support of the Volpe National Transportation Systems Center, has an immediate requirement for a Database Architect/ Senior Microsoft SQL Server Database Developer. The qualified candidate will be a key contributor in developing applications for the Federal Aviation Administration (FAA) to support the work of their Aviation Safety Inspectors. The position will include the design of databases and database objects, along with optimization for the handling of a large amount and variety of FAA’s aviation safety related data. This project presents several exciting technical challenges including data analytics and application scaling. The successful candidate will also be required to write high level and detailed design documents for use by all levels of project stakeholders and development staff. This will require working closely with the business analysts and .NET development staff to design and develop database objects to support the application. Candidate must be able to obtain public trust clearanceResponsibilities
Participates in client/project meeting(s) for highly complex project definition, needs assessment and design review.
Evaluates the needs and requirements of the users and provides technical expertise in the development of technical, structural, and organizational specifications. Determines appropriateness of data for storage and optimum storage Organization.
Designs, develops, and integrates highly complex database systems for internal and external users/clients.
Develops complex programs and derives logical processes on technical platforms.
Creates, documents, and implements standards and/or complex modeling to monitor and enhance the capacity and performance of the database.
Performs complex analyses and reviews applications being released into production. Develops and oversees the implementation of test application code in client server environments to ensure that software conforms to build management practices.
Create and maintain data model diagrams and data dictionaries.
Collaborate with business analysts to review requirements and translating conceptual data model to logical and physical data models.
Collaborate with the application development team and the release management team to support application deployment.
Collaborate with other members of database team to meet project goals and deliver quality solutions, often working on several tasks/projects simultaneously, providing guidance, direction and best practices on schema changes and design.
Collaborate with the release management team to automate database deployments.
Troubleshoot production issues, work with help desk and development teams to debug and provide solutions.
Incorporate and/or migrate data from various and diverse external data sources to be used by the system.
Design, develop and manage data interfaces with other database systems according to project requirements.
Requirements:
5+ years of experience of working with relational databases; 5+ years with Microsoft SQL Server.
5+ years of experience designing and maintaining large mission critical enterprise databases.
5+ years of experience of working with SQL; 5+ years of T-SQL developing Stored procedures, Views, Triggers, UDF (User defined Functions), constraints, etc.
5+ years of experience working with relational data modeling using tools like Erwin, MS Visio, etc.
Experience of database optimization using profilers, query analyzers and query plans.
Experience managing SQL clusters for high availability and data replication.
Experience designing and developing databases for analytics and reporting.
Experience with ETL tools and technologies, especially SSIS.
Experience of working in a .NET environment using Visual Studio, Team Foundation Server (TFS) and Git
Experience using application life cycle management tools such as Jira.
Experience developing applications for the cloud.
Ability to analyze large enterprise database environments and recommend emerging technologies to optimize operations.
Good team player with excellent communication and time management skills.
Experience with Agile software development methodology.
Education:
Bachelor's degree in engineering, computer science, or software engineering.
Microsoft Certifications would be nice to have.
KBR is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, disability, sex, sexual orientation, gender identity or expression, age, national origin, veteran status, genetic information, union status and/or beliefs, or any other characteristic protected by federal, state, or local law.
