• AE MS SQL Server specialist Jobs in Thiruvanananthapuram

  • Ernst & Young
  • Thiruvanananthapuram
  • Save Job
  • 2 - 2 Years
  • Posted : above 1 month

Job Description:



  • Database technical design and architecture based on established standards

  • ETL analysis, design, documentation, and implementation using Rapidminer as a tool

  • Review and testing of application databases developed both in-house, and by external vendor

  • Setup, maintenance, and documentation of Development, QA and Staging database environment(s) on each given project

  • Database backups in Development, QA and Staging database environments

  • Version control of scripted DB objects using MS TFS and MS VS Database Edition

  • Bigdata / Hadoop based solution development is a secondary function on need basis

  • Database builds, deployments, and promotion of DB object changes from Development to QA and Staging environments using MS TFS and MS VS Database Edition

  • Database performance tuning and DB query optimization

  • Cross training of both other SQL Developers and support staff

  • SQL scripting for generation and auto population of test data

  • Communications with Operations support staff on troubleshooting and repairing production issues


Key Documentation Deliverables

  • Entity Relationship Diagram (ERD)

  • Database installation and deployment documentation

  • ETL technical documentation

  • Documented feedback from database reviews


Knowledge, Skills, and Experience Requirements

  • ETL design and development using Rapidminer as a tool is highly desirable

  • Python scripting knowledge for various ETL operations

  • Nice to have Bigdata / Hadoop based data warehouse skill set using Hortonworks or Cloudera distribution

  • In-depth knowledge of relational database, design, planning and implementation

  • In-depth knowledge of Microsoft SQL Server 2008, 2012, 2014 and other related tools such as SSIS, SSAS, SSRS, Replication, Database mirroring and log shipping

  • In-depth knowledge of data modeling (ERD) utilizing MS SQL Server Management Studio, MS VS and/or MS Visio

  • Hands-on experience with MS VS Database Edition, TFS, SQL Server Management Studio, and other MS SQL Tools

  • Working knowledge of the entire Software Development Life Cycle

  • Knowledge of Disaster and Recovery strategies such as Microsoft Cluster Technology

  • Excellent written and verbal communication skills

  • Excellent organizational and time management skills

  • Creativity and self-motivation

  • Ability to learn new technologies and take on responsibility

  • Ability to work independently and in a team environment with aggressive timetables

  • knowledge of document databases and knowledge of data storage in Azure as requirements for this role

Value of Role

  • Provide database solutions for application development

  • Provide facility to produce and maintain quality data efficiently

  • Provide documentation that articulates the database technical solutions

  • Add value to the business by facilitating improved process design



,

Profile Summary:

Employment Type : Full Time
Industry : Banking / Financial Services
Salary : Not Disclosed
Deadline : 20th Jan 2020

Key Skills:

Company Profile:

Ernst & Young
At EY, our purpose is Building a better working world The insights and quality services we provide help build trust and confidence in the capital markets and in economies the world over We develop outstanding leaders who team to deliver on our promises to all of our stakeholders In so doing, we play a critical role in building a better working world for our people, for our clients and for our communitiesIn a world thats changing faster than ever, our purpose acts as our North Star guiding our more than 260,000 people providing the context and meaning for the work we do every day We help digital pioneers fight data piracy; guide governments through cash-flow crises; unlock new medical treatments with data analytics ; and pursue high quality audits to build trust in financial markets and business In other words, working with entrepreneurs, companies, and entire countries to solve their most pressing challenges

These free online tutorials may interest you

People who search this job also searched for the following Keywords

Salary trends based on over 1 crore profiles

View Salaries

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status