Database Administrator | MS SQL Server

Database Administrator - MS SQL Server

Job ID
IT JOBS#21

Location:
Delhi NCR, India

Required Skills:

We have been retained by a global auto parts distribution company based in the USA to recruit Reporting Analyst for their software development centre in New Delhi.

Job Description:

This position has responsibility for database development and day-to-day database operations. It is convenient to break detailed duties up into three parts to address the main job functions and requirements.

General Requirements
• Studies and understands business needs
• Communicates architecture to business and management
• Participates in business development as advisor
• Understands technology limitations/features and sets expectations
• Research and development of new database software releases/migrations
• Prepares, oversees and coordinates database and application designs
• Inspects database solutions
• Acts as enterprise consultant and data/database SME
• Advises development group on project resources and estimates
• Communicates architecture to development group
• Create and enforce database development standards and processes
• Create and enforce architectural standards
• Create and enforce design standards
• Owns logical and physical data models
• Owns enterprise data dictionary
• Owns and defines metadata
• Ensure consistency across implementations
• Defines data archive/purge standards

Administrator's Functions:
• Establish the needs of users and monitor user access and security
• Monitor performance and manage system parameters to provide fast query responses to users
• Find improvements and efficiencies in application database access performance, and review with code developers
• Consider both back end data organization and front end accessibility for end users
• Install and test new versions of the database management system (DBMS)
• Control access permissions and privileges
• Maintain data standards
• Develop, manage and test backup and recovery plans
• Plan for future capacity needs
• Work closely with IT project managers and web developers
• Communicate regularly with technical, applications and operational staff to ensure database integrity and security

Development Functions
• Provide development of database objects – tables, views, stored procedures, user defined functions, indexes and triggers in coordination with web code development
• Ensure database security to help prevent SQL injection attacks
• Develop new reports using SQL Server Reporting Services and design database structures to be efficiently queried
• Continually check index performance and adjust accordingly
• Advise/assist developers when direct database interaction is necessary to support application user needs

Experience: at least 4 years of SQL Server experience

Very good communication skills

itForte is one of the leading recruitment agencies in India with top Indian and international companies as its clients

India
New Delhi
Delhi Show on map Get directions