Creates conceptual, logical and physical data models for transactional systems in Erwin. Leads business discovery sessions with the end users. Plans, implements and manages systems initiatives with IT and customer teams. Establishes and maintains data technical standards as described in data dictionaries and source to target mapping documents. Conducts database performance monitoring, capacity planning, trend Forecasting. Documents and improves upon processes, procedures, and best practices to align with industry standards and customer needs. Adheres to disaster recovery requirements to ensure business resumption requirements are met. Provides high-level of customer satisfaction to internal and external customers, applying necessary sense of urgency and creativity in problem identification and prompt incident resolution. Provides advanced database systems administration. Analyzes system performance and suggest/implement tuning as needed. Administers MS SQL server database.
Project Specific Technical Requirements:
7+ years of experience in the following:
Data Modeling/Architecture (conceptual, logical, physical, understanding of the data) Database Management performing installation, configuration, customization, implementation and support of SQL Server Database Creating Data Dictionaries and Data Mappings documents. Experience and expertise in monitoring and troubleshooting ETL, DTS, SSIS and Data warehouse queries. Hands-on experience in SQL Server Performance Tuning, Query Optimization and Production support. Hands-on experience writing complex Stored Procedure/ Functions in PL/T-SQL and MS SQL. Writing complex Shell Scripts to support SQL and other functions
ABBTECH is an EOE/Minorities/Women/Disabled Individuals/Veterans