Description

You will lead data modeling and database design efforts for application development and product implementation initiatives.

Responsibilities

• Create conceptual, logical, and physical models for custom applications, data exchange, and integration services.
• Manage and migrate database objects across development, QA, and production environments.
• Optimize database performance, scalability, security, and capacity utilization.
• Reverse engineer and document database architecture for business-critical legacy databases.
• Define data testing strategies and participate in the software testing and defect resolution process.
• Mentor and guide development team members on database-related tasks.

Required Skills

• 8-10 years of expertise in MS-SQL Server database administration, utilities, and tools.
• 6-8 years of application data modeling experience using ERwin or ER/Studio.
• Proficiency in MS-SQL Server 2014/2016/2017 in high availability environments.
• Intimate knowledge of SQL and T-SQL.
• Ability to write and optimize complex SQL queries, procedures, and functions.
• Experience designing and integrating databases, data warehouses, and multidimensional databases.
• Familiarity with SSRS, SSAS, SSIS, and ETL concepts including Dimensions, Facts, and Cubes.
• Knowledge of SQL Server security management, backup, and recovery scenarios.
• Working knowledge of cross-platform databases including MySQL, Oracle, and DB2.
• Microsoft Certified Database Administrator.

Preferred Skills

• BA/BS Degree in a technology-related field.

Key Skills

Education

BA/BS Degree