SQL DBA Developer

HungryBIrd Consulting Services
  • Bangalore, Delhi, Hyderabad, Mumbai
  • 10-15 lakh
  • 2-7 years
  • Views
  • 27 Apr 2017

  • IT/ Information Technology

  • IT/ Technology - Software/ Services
Job Description

- Performs administration, troubleshooting, installation, maintenance and configuration of SQL servers, databases, services & applications.

- Provides backup, recovery, security management, and ensures the availability of SQL databases and SQL Server operations systems.

- Administers, configures, monitors and maintains Microsoft SharePoint instances.

- Implements procedures for rapid and reliable deployment, configuration, backup and recovery of database servers, including testing of backup and recovery scenarios.

- Provides technical support for SQL database tools.

- Monitors database sizes, disk space availability, and manages databases within SQL Clustered SAN environments.

- Provides support for tuning database queries and assigning indexes.

- Installs upgrades, service packs, and security updates for SQL Server database environments.

- Routinely runs database integrity checks.

- Analyzes, develops, tests and implements database designs.

- Responsible for aiding in own self-development by being available and receptive to all training made available by the company.

- Plans daily activities within the guidelines of company policy, job description and supervisor"s instruction in such a way as to maximize personal output.

- Responsible for keeping own immediate work area in a neat and orderly condition to ensure safety of self and co-workers. Will report any unsafe conditions and/or practices to the appropriate supervisor and human resources. Will immediately correct any unsafe conditions as the best of own ability.

- Normalizations/De-Normalization

- ER-Model (Entity Relationship)

- Different Ways to design database

- All types of Keys (Primary Key, Foreign Key, Unique Key)

- Worked with Stored Procedure, Functions, Indexes, Views, Triggers

- Performance Tuning of Stored Procedure/Functions.

Creation Functions :

- In-built

- User Defined Functions

- Temporary Table

- Table type Variables

BI Tools :

- SQL Server Reporting Services (Report Designing and Deployment on the Server)

- SQL Server Integration Services (ETL package designing and deployment on the Integration Server)

- Knowledge on Cube designing and Data warehouse concepts.

- Worked with Report Server and Report Manager

Competencies/Skill sets for this job

Designing Troubleshooting Training Warehouse

Job Posted By

About Organisation

HungryBIrd Consulting Services