MR - Database Engineer (DataStage ETL)

Virginia  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Keywords

Description

DataStage Expert

The Database Engineer will be responsible for providing query development activities including extract, transform, and load (ETL) processing, query optimization, PL/SQL and stored procedures development, and schema architecture and development. The Database Engineer will also provide database architecture support which includes driving database designs, roadmaps, and strategies. This includes providing design guidance to various application development teams, conducting code reviews, and enforcing best practices of database development.

Additional responsibilities include but are not limited to:

  • Partner with application developers in database creation, data structure development, and database object development.

    • Support the development of solutions within the guidelines identified in the DHS Systems Engineering Life Cycle (SELC) that have high availability and scalability consistent with the customer needs
    • Support the deployment of database changes into the various application environments
    • Provide ETL development for automating the consolidation of disparate data sources into centralized repositories
    • Performing relevant selection of algorithms for data masking or obfuscation within the various application environments
    • Ability to provide recommendations on alternative data processing solutions with cost/benefit and tradeoff analyses
    • Develop back-up and recovery procedures and data archive/purge procedures
    • Support the development and maintenance of relevant data management plans, data models, and technical documentation
    • Collaborate effectively with peers, engineers, and government counterparts to solve complex database problems
    • Come up with innovative ideas to improve the performance, scalability, and reliability of DataStage ETL processes for Real Time reporting

Qualifications for this position include:

A Bachelor's degree in Computer Science, Engineering, Information Technology or related field and 6 or more years of professional experience in database engineering, testing, and maintenance in platforms such as Oracle and SQL Server. A Bachelor's degree may be substituted for at least 8 years or more of related experience.

    • Proficiency in query optimization, SQL development, and performance tuning
    • Expertise with DataStage or similar ETL tools
    • Ability to design and implement high-volume data systems using both relational and dimensional techniques
    • Strong experience in building automation tools using Shell Scripting, PL/SQL, and stored procedures
    • Understanding of .NET web applications and OS's (Windows, etc.) and their inter-dependencies
    • Knowledge of various SDLC methodologies and processes
    • Strong interpersonal communication skills with various teams including applications, security, and operation and maintenance (O&M) teams
    • Demonstrated skills in the areas of critical thinking
    • Ability to work in a fast pace environment
Start date
ASAP
Duration
2 years
From
Peoplesourcer
Published at
25.10.2014
Project ID:
797207
Contract type
Freelance
To apply to this project you must log in.
Register