Database Architect - Mumbai, Maharashtra, India - Lionbridge

Lionbridge
Lionbridge
Verified Company
Mumbai, Maharashtra, India

1 week ago

Deepika Kaur

Posted by:

Deepika Kaur

beBee Recuiter
Description
We need a Database developer of 8+ years of hands-on experience in performing SQL database development tasks.


Job Profile:


  • Database Developer/Architect (8+ years)

Qualification :

  • BE/BE-Tech or higher degree in Computers/IT stream

Primary Requirements:

  • Expertise in Transact-SQL (DDL, DML, DCL), in Design and Normalization of the database tables, SSIS packages.
  • Handson experience delivering and supporting data stores in Cloudbased environments (e.g., Azure, AWS, or Google Cloud Platform).
  • Experience in implementing business logic using Triggers, Indexes, Views and Stored procedures using MSSQL, Azure SQL DB, etc.
  • Extensive knowledge of advance query concepts (e.g. group by, having clause, union so on).
  • Experience with tools like MSSQL Server management studio.
  • Experience in C#, dotNet development
  • Proficient in tuning T-SQL queries to improve the database performance and availability.
  • Experienced hands in Query tuning and performance tuning.
  • Experience with Dynamic Queries.
  • Experience in monitoring and improving MSSQL Server Performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
  • Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
  • Good knowledge in Normalizing and Denormalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
  • Transformation of data from one server to other servers using tools like bulk copy program (BCP), data transformation services, data conversions from legacy systems to MSSQL server.
  • Experience in Power BI will be an added advantage

Soft Skills:

  • Excellent verbal and written communication skills
  • Good Leadership and presentation skills
  • Proactive and teachable
More jobs from Lionbridge
See all jobs of Lionbridge