Senior database architect vs database specialist

Differences between senior database architect and database specialist duties and responsibilities

Senior database architect example responsibilities.

• Create PHP page for loan officers to add to their contact list for leads which interact with the MySQL database.
• Create ETL packages using Microsoft SSIS to transform and integrate several database structures into a single integrate data warehouse.
• Design, create complex clinical research reports using SSRS.
• Develop stored procedures and database code TSQL, SQL, SSIS.
• Analyze queries, develop and implement index strategies for OLTP systems.
• Design, develop, modify, test, and implement SSIS projects.
Show more

Database specialist example responsibilities.

• Assist founder with maintaining and improving internet website manage ERP systems, payroll and self-service human resource system.
• Used T-SQL skills including creation of user define functions, complex store procedures, query optimization to write automate reporting.
• Design ETL process involving data quality, testing and information delivery and access to the data warehouse.
• Develop graphical applications using Java and wxWindows C++ API.
• Experience includes: * Pre- and post-decision processing of Medicare appeals cases.
• Create procedures, functions, and triggers; handle database performance and tuning.
Show more