Responsibilities
Create a Database and normalize the database into small tables by applying rules of Normalization, defined Check Constraint and applied Business Rules.
Well versed with the
DDL
and
DML
statements
Help write and optimize in-application SQL statements
Creating and maintaining complex
stored procedures
, Extended
System SP
,
Triggers
,
views
,
Tables
, user defined functions,
DBCC commands
.
Create
indexes
and analyse its role for
optimizations
Develop Dynamic search queries and results with manipulated data.
Ensure performance, security, and availability of databases
Prepare documentations and specifications
Handle common database procedures such as upgrade, backup, recovery, migration, etc.
Implement SQL Logins, Roles and Authentication Modes as a part of Security Policies for various Categories of users.
Create Linked server and running distributed queries to access data from other remote servers.
Follow the Microsoft recommended best practices in designing, developing, and implementation and testing of the
ETL
using
SQL Server Integration Services (SSIS)
, including upgrading
DTS
to
SSIS.
Prepare different types of reports using
SSRS
.
Skills & Qualifications
Degree in one of the following subject areas: Computer Science, Business Administration, Information Technology or related field preferred
Good experience of IT industry with strong understanding of database structures, theories, principles, and practices
2 – 4 years Microsoft SQL Server experience (2008 / 2012 / 2014)
Understanding of, and experience with, server-client computing and relational database environments
Experience with data management and data processing flowcharting techniques
Knowledge of reporting and query tools and practices
Good interpersonal, written, and oral communication skills
Ability to present ideas in user-friendly language
Self-motivated and directed, with keen attention to detail
Able to prioritize and execute tasks in a high-pressure environment
Experience working in a team-oriented, collaborative environment
Should have good working experienece in SQL ( SSMS), Queries, SP, Extract requirments from SP/QUERIES.
MS Office ( word, xlsx, ppt, viso..etc)
Job Title IT Project Service & Control Manager – S&G Job Description Philips is a global leader in health technology,...
Apply For This JobLocation Chennai Proven track record Effective communication and convincing skills. Proficient in English. Excel and Presentation skills Research to identify...
Apply For This JobApplies basic knowledge of the job skills and company policies and procedures to complete a variety of assignments/tasks. Good understanding...
Apply For This JobLooking for the Manager as well as executive for sales and marketing.Who have an experience in US IT recruitment more...
Apply For This Job...
Apply For This JobAbout XEAM-XEAM is a CMMI Level 3 certified 17 years experienced company providing end-to-end HR services in the field of...
Apply For This Job