SQL DBA Engineer

Job Description

  • Excellent Experience as Lead SQL Server DBA in Production Development. Should have a strong experience with Database Cluster & Replication.
  • Experience in SQL Server 2008/2012/2014 & 2016, SQL, T-SQL, Stored Procedures, Functions, Triggers, Views, Indexes, UDF, BCP, DTS, SSIS packages and SSRS Reports.
  • Skilled at Azure Data Factory, Blob Storage, Sql DW and moving the data to Blob and then to Sql DW using copy transformation/activity and knowledge in Big Data Analytics.
  • Experience in Azure SQL Server (Good to have). Configuring and Maintaining Azure AD.
  • Able to write PowerShell scripts for standard deployments to Azure.
  • Monitor and Maintain customers systems deployed in Azure for patching and security.
  • Experience with Sys Admin work on both Windows and Linux OS
  • Experience with migrating systems from On-Prem to Cloud Provider.
  • Work closely with application and systems administrators on current production system changes or upgrades.
  • Support Enterprise Production Operation staff and create/update procedures on SQL Server and Azure server.
  • Ability to manage EDW and services related to data analytics such as ETL process (Good to have).
  • Strong familiarity with MS SQL Server technology. Understanding of Microsoft SQL Azure, Microsoft BI and analytics platform. Be able to work as a team and interact professionally.
  • Extensive experience in Extracting, Transforming and Loading (ETL tools) using SSIS, DTS Import/Export Data, Bulk Insert, BCP, DTS Packages and SSIS packages.
  • Strong experience with SSIS ETL tools, Extensive knowledge in Deploying SSIS packages
  • Strong experience in Migration of database from MS SQL Server (Store Procedure) and XML to Azure SQL Server/Oracle Server.
  • Create and Build SSIS Package (MUST) in SQL Server Agent and Schedule Jobs according to our daily requirements.
  • Created multiple packages for implementing ETL by using various control flow & Dataflow items.
  • Experience in providing Logging, check points, packages configurations, error handling in SSIS.
  • Experience to configured/maintained Report Manager and Report Server for SSRS and deploy the reports in to the UAT/Production server.
  • Proficient in working with SQL Query Analyzer, SQL Server Management Studio and Business Intelligence Development Studio, Indexes and SQL Profiler.
  • Should have experience in SSAS Cube Designing. (Good to have)

Good to have -

  • Have proficient experience in creating and building the dashboards in Power BI Desktop and very good in EXCEL 2010/2013 and latest version.
  • Good in writing DAX queries/expressions in power bi desktop.

 

Apply Now

Please spend a minute to send your resume or queries to us, We will reply to you shortly.

Contact Us