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 Description Job Title : Senior Principal Enterprise Software Test Engineer – Verification Architect – (23000EY5) Experience : 5 Years...
Apply For This JobAbout Accenture: Accenture is a global professional services company with leading capabilities in digital, cloud and security. Combining unmatched experience...
Apply For This JobVrhunec IT Pvt Ltd.(USA Based) Provide solution related to E-Commerce website development & digital marketing. We offer top-notch web developers,...
Apply For This JobJob Description Essential Duties and Responsibilities:Perform related duties as assigned by supervisor Maintain compliance with all company policies and procedures...
Apply For This JobOverview: WHAT YOU DO AT AMD CHANGES EVERYTHING We care deeply about transforming lives with AMD technology to enrich our...
Apply For This JobDear Candidates, We are Impact Infotech Pvt Ltd. hiring for IT Recruiter @Noida location. Company- Impact Infotech Pvt. Limited. Skill-IT...
Apply For This Job