This is a remote position.

• 
  Analyze, solve, and correct issues in real time.
• 
  Provide suggestions for solutions.
• 
  Create ETL packages. (Mandatory on SSIS, Knowledge of other ETL is good to have).
• 
  Experience with complicated SSIS Package coding and maintenance.
• 
  Participate in ongoing DW/BI performance tuning activities.
• 
  Refine and automate regular processes, track issues, and document changes.
• 
  Assist developers with query tuning and schema refinement.
• 
  Provide support for critical production systems as required.
• 
  Maintaining code versioning and support code deployments.
• 
  Perform scheduled maintenance and support deployment activities as required.
• 
  Manage SQL Databases but not limited and can extend to NoSQL/Cloud Database as applicable.
• 
  Preserve data integrity.
• 
  Maintains contemporary knowledge of industry trends, concepts, and techniques.
• 
  Experience in creation of SQL Tables, Views, MV’s, Stored Procedures and working on complex T- SQL statements.

Requirements

• 
  Expert knowledge in traditional relational database concepts and design.
• 
  Fluent in SQL
• 
  Database design and query optimization.
• 
  Write and debug stored procedures and ability in advanced SQL operations.
• 
  Advanced query, join operation, and aggregate.
• 
  Knowledge of data warehousing.
• 
  Automate manual data tasks through workflows and ETL packages.
• 
  Should possess skill to maintain, monitor, troubleshoot daily jobs using SQL Server Agent.
• 
  Administrate application and server environments.
• 
  Analyze data quality and make recommendations for data preparation.
• 
  Strong ability to communicate both verbally and in writing, especially with technical analysis (including understanding internal documents).
• 
  Experience with data manipulation, data engineering, and working with large data sets.