SQL database /ETL Architect in Lansing, MI (Webcam interview)

TASKS:

Technical support is required to assist with the following tasks:

Database design

Database conversions (Create, Maintain, Schedule and Run SSIS Packages

SQL query review and tuning

Replication software support

Relies on experience and judgment to plan and accomplish goals, independently performs a variety of complicated tasks, a wide degree of creativity and latitude is expected.

Designs and builds relational databases. Develops strategies for data synchronization and implementation of a database. Must be able to design, develop and manipulate database management systems. Requires a depth and breadth of database knowledge that shall help with formal design of relational databases and provides insight into strategic data manipulation. Capable of performing the role of a database administrator, if needed.

Skills Required:

Database development with SQL Server Management Studio including creating models, designing DB objects (tables, indexes, view, stored procedures, etc), writing DB procedures, functions and triggers, developing solution architecture from business requirements, information architecture and technical architecture. Advanced SQL knowledge, software configuration and setup of the SQL translations needed between the Legacy and Refresh database, Data Modeling and Version control.

Must understand SQL Server Database projects and how they are applied across environments and how it is used in the version control process.

Thanks and Regards,

Karan Sharma

510-254-3300 ext. 150