Database Developer

Location: mechanicsville, Virginia
Date Posted: 08-10-2017
Position: Database Developer  
Location: Mechanicville, VA
Duration: Direct Hire (must be able to work without needing sponsorship)
SUMMARY: The Database Developer – Data Management will be responsible for managing company data infrastructure and assets, assisting in the planning, design and implementation of company data interfaces and data management components. The role will require a strong technical background and substantial experience in managing and administrating Microsoft SQL Server infrastructure. The individual will understand implementing data models, data design, data access and table maintenance; implementing data policies and procedures; developing and administering ETL processes using SSIS and other tools, interface management standards, and monitoring and alerting.
ESSENTIAL DUTIES AND RESPONSIBILITIES: Primary duties and responsibilities include, but are not limited to the following.
  • Collaborate with other IT staff, vendors, partners and other stakeholders to design and develop data movement and electronic data interfaces utilizing best practices and the production of standard design patterns.
  • Develop relational database and data warehouse components including tables, views, indexes, procedures, SSIS packages, and data interfaces.
  • Develop data interface architectural components including data flow diagrams, data mapping documentation, data dictionaries, and data management plans.
  • Design data management and interface components and practices to facilitate efficient and effective organization, maintenance, and utilization of data.
  • Plan, design and implement system and database integration via both batch and semi-real-time approaches, including the development of ETL processes for data movement between database architecture components and end-application databases.
  • Design and develop business intelligence delivery components such as end user SSRS reports, Crystal Reports, data extracts, and dashboards and other data visualizations.
  • Ability to work extended workdays, weekends and holidays to support business needs.
  • Other duties may be assigned. 
EDUCATION AND/OR EXPERIENCE: Three years of database development/design experience with MS SQL Server in an enterprise environment. Two years of experience gathering requirements, designing, and developing data interfaces with Microsoft SQL Server databases and SQL Server Integration Services (SSIS). Relevant experience or equivalent combination of education and experience is also acceptable.
this job portal is powered by CATS