02 Nov
SQL Server Database Administrator [BizID#6770]
Washington, Bellevue , 98004 Bellevue USA

Vacancy expired!

Title: SQL Server Database Administrator [BizID#6770] Location: Bellevue, WA (Remote) Experience: 9+ years Job Description: The candidate should have hands on ETL experience to develop data interfaces for extracting, cleaning, transforming and loading data into data warehouse/SQL Server destination using SQL Server functions and procedures to read data from Multi formatted Flat files, Excel etc.,.

  • Strong experience with performance tuning of SSIS jobs, T-SQL and database custom scripting
  • Good understanding of joining and querying data from SCD Type 2 tables
  • Experience in writing complex T-SQL queries, functions, stored procedures, common table expressions (CTE), etc.,
  • Should have strong experience in reverse engineering ETL logic from already implemented code
  • Strong experience with implementing SQL Server Procedures, functions, and DB triggers
  • Peer review the code, design, test automation, etc.,
  • Experience in working in onsite and offshore model
  • Ability to monitor SQL Server jobs, debug and resolve any production issues on a daily basis
  • Strong experience in using SSIS to load data from flat files to SQL Server destination
  • Must have experience in using SSIS package configurations, variables and parameters
  • Strong experience with performance tuning and daily monitoring of SSIS jobs
Primary Skills / Responsibilities:
  • Understanding of business and project requirements
  • Ability to communicate with client effectively and directly when needed
  • Follow industry best practices while coding and unit testing.
  • Excellent problem solving and analytical skills
  • Stay updated with current technologies and coding methodologies.
  • Should be able to implement as per provided solution
  • Should appreciate the Agile methodology
  • Should be competent to manage working in tight schedules
Desired Skills:
  • 6+ years of industry experience in SQL Server DWBI technologies including SQL Server backend scripting and SSIS
  • Experience working with Cloud technologies like Microsoft Azure is a plus
  • Should have experience working with Agile methodology
  • Should be self-motivated and Smart working
  • Candidate should have excellent communication skills both oral and written
  • Should be willing to learn.
  • Should be B.E, B.Tech, MCA, M.Sc. qualified
Technical Skills :
  • SQL Server (T-SQL)
  • SSIS
  • SQL Server backend scripting
  • Performance tuning
  • Data warehouse application design and Data Modelling
  • SQL Server jobs monitoring and troubleshooting
Secondary Skills :
  • Power BI

Vacancy expired!


Related jobs

Report job