AMCAD is seeking a senior level database developer with 5+ years of experience. This position will be located at AMCAD’s Herndon headquarters in the heart of Northern Virginia.
-Interface with clients to determine requirements necessary for ETL, systems integrations, design, and data migration work, including migrating data from various data sources/database vendors.
-Build Scalable ETLs using SSIS for large volumes of legacy data encompassing complex transformation logic.
-Perform activities encompassing all operations of database platforms, including modeling, designing, and creating objects to facilitate development using SQL Server or RDBMS Building.
-Install, configure, and maintain internal databases for development, testing, and integration purposes and troubleshoot issues in multiple environments at different levels including the database, application, and system levels with use of SQL profiler.
-Work with Software Development team and system analysts to detail logical and physical data models, using Erwin Data Modeler.
-Conduct client training sessions to gather requirements and compile comprehensive documentation for ETL and implementation strategies, including upgrading databases to SQL 2005, SQL 2008, SQL 2008 R2.
-Utilize T-SQL to create complex functions, stored procedures, and triggers to facilitate business rules and to automate system events through the use of scheduled tasks and SQL Server jobs.
-Ability to design and build data marts.
-Perform schema design, performance tuning, capacity planning, and change control management tasks.
Skill Desired: MS SQL 2005, 2008, 2008 R2, SSIS, SSRS, SSAS, ErWin Data Modeler.
Travel Required: 10% to 20%