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