SQL Server Data Analyst Role

Greetings from IMS One World..!!

Designation : SQL Server Data Analyst
Experience : 4+ Year
Qualification : B.E/ B.Tech/ MCA/ BCA/ B.SC
Location : Hyderabad
Responsibility:

  • Design and Development
  • Design, develop, test, implement and maintain new and existing databases. Database developers create management methods and systems to access efficiently to information stored in databases.
  • Preparing the Technical Documentation during and after coding as well as estimating level of effort required
  • Creates and executes designs for small sets of new functionality as part of a software project Contribute to peer code reviews and evaluating new options of similar technology, offer suggestions to improve processes, and provide comments on some electrical design aspects
  • Contribute to product and/or application definition activities including feature analysis and system tradeoffs
  • Modifying databases and products according to client needs.
  • Providing assistance to others in topics related to data management.
  • Creating reports on databases.
  • Designing and developing database architectures.
  • Designing for performance to provide fast responses to front-end users; mapping out the conceptual design for a planned database; considering both back-end organization of data and front-end accessibility for end-users; reviewing the logical design and translating the design into a specific data model; further refining the physical design to meet system storage requirements; installing and testing new versions of the DBMS; maintaining data standards, including adherence to the Data Protection Act as appropriate;
  • writing database documentation, including data standards, procedures and definitions for the data dictionary (metadata); defining solution specific access permissions and privileges; developing, managing and testing back-up and recovery plans; ensuring that storage and archiving procedures are functioning correctly; capacity planning;
  • Testing and System Integrity:
  • SQL Server Database Developer

Job Description:

  • Review product and/or application information including manuals and brochures for technical accuracy
  • Performs technical root cause analysis and outlines corrective action for given problems
  • Perform Unit Test Execution and Peer Code Review of the Features Updated
  • Debugging/ Fixing any internal or external issues if any
  • Document Installation and data migration procedures

Requirement:

  • SQL DBA with 4+ years working experience in writing Stored Procedures, Functions, Triggers, JOBs in SQL Server2008, 2012 versions.
  • Knowledge of Java, Visual Basic and SQL
  • Minimum 1 year experience installing, configuring and managing multi instance SQL Server environments
  • Extensive knowledge on T-SQL programming.
  • Strong performance tuning skills, Clustering Mechanism and should have exposure on SQL Server Replications.
  • Experience in data replication, performance tuning, scaling, disaster recovery within the SQL Server environment
  • Understanding of, and experience with, server-client computing and relational database environments
  • Experience with data management techniques
  • Working experience on SQL Server Management Studio very effectively and strong Knowledge of reporting and query tools and practices.
  • Degree in Information Technology, Software, Computer Science, Mathematics, Engineering, or any other related field or other related field.
  • Any certification to the area an added advantage.

If you are interested kindly contact on below information :-

Binkal Prajapati
Recruitment Consultant
Global Recruitment Services – Middle East
binkal.prajapati@imsoneworld.com

Salary:INR Best As Per Industrial Norms

Industry:IT-Software / Software Services

Functional Area:IT Software – Application Programming , Maintenance

Role Category:Programming & Design

Role:System Analyst

About sqlschool

SQL School (Regd: SequelGate Innovative Technologies Pvt. Ltd.) is one of fastest growing organization delivering Realtime Training and Realtime Projects exclusively on Microsoft SQL Server. Our Training services include SQL DBA Online Training, MSBI Online Training, SQL DBA Classroom Training, MSBI Classroom Training and Realtime Projects. SQL School, established in February, 2008 is now, one of the best institute offering Trainings on SQL Server, SQL Database Administration (DBA) and Business Intelligence (BI) technologies. We have been working with numerous consultancies in India, US, UK and Australia. We undertake Online Trainings and Corporate Trainings on SQL Server 2008, SQL Server 2008 R2 and SQL Server 2012 (DENALI) versions. We make sure that all our sessions are very much interactive and well structured. We encourage every participant to come up with his / her own queries during & after the training sessions. We prefer practical approach rather than theoretical information to master the technical depth of the technology. We provide excellent Lab Handouts for practice, Realtime Case Studies and Projects on SQL Server Administration (SQL DBA) and Microsoft Business Intelligence (MS BI) Training courses. Free LIVE DEMOs would be provided prior to training registration. Specific DAY to DAY Course Plan will also be shared prior to training registration to ensure transparency of our Training services.