SQL Database Administrator Full-time

STAYINFRONT INDIA PRIVATE LIMITED

Posted By : STAYINFRONT INDIA PRIVATE LIMITED

Gandhinagar, Gujarat (1)

The MS SQL DBA is primarily responsible for providing operational and SQL database services to the organization. As a DBA, this person is primarily responsible for the maintenance and support of databases on large scale database servers running on Microsoft SQL Server. 

Responsibilities will include:

  1. Owning, tracking, and resolving database related incidents and requests.
  2. Fulfilling requests and resolving incidents within SLAs
  3. Perform regular database maintenance activities by following internal processes (data loads, data fixes, schema updates, database copies, software installs, upgrades and patches).
  4. Running daily database checks.
  5. Assist with the automation of regular database support activities.
  6. Maintain code in centralised repositories appropriate to each project.
  7. Support and implement database solutions in Microsoft SQL Server. This will involve a complete understanding of our core software components and how they interact with the back-end database.
  8. Interact with the CRM Development team to coordinate resolution of model-related problems that may be affecting the back-end database.
  9. Work directly with the Research and Development team in New Zealand or India to implement and test newly created system files and core software components.
  10. Provide ongoing support and technical guidance to users at various levels within the organization.
  11. Work on rostered shifts (including weekends) providing 24x7 DBA services.

Essential Qualifications: 

  1.  Has 1+ years of experience in database development and support in MS SQL Server environments.
  2. Experience in Database Administration in SQL Server (2008 and 2012).  

Essential Requirements:

  1.  Experience in writing SQL queries, Stored Procedures, Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
  2. Knowledge of backups, restores, recovery models, shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
  3. Knowledge of how indexes, index management, integrity checks, configuration, patching work, how indexes are stored, how they can be created and managed effectively.
  4. Knowledge of SQL Server tools.
  5. SQL Development – ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints).  

Role Specific Skills
  • Active Learning
  • Active Listening
  • Administration and Management
  • Category Flexibility
  • Complex Problem Solving
  • Computers and Electronics
  • Critical Thinking
  • Deductive Reasoning
  • Design
  • Engineering and Technology
  • English Language
  • Fluency of Ideas
  • Inductive Reasoning
  • Information Ordering
  • Judgment and Decision Making
  • Mathematical Reasoning
  • Mathematics
  • Monitoring
  • Near Vision
  • Number Facility
  • Operations Analysis
  • Oral Comprehension
  • Oral Expression
  • Originality
  • Problem Sensitivity
  • Programming
  • Reading Comprehension
  • Science
  • Speaking
  • Speech Clarity
  • Speech Recognition
  • Systems Analysis
  • Systems Evaluation
  • Technology Design
  • Telecommunications
  • Time Management
  • Visualization
  • Writing
  • Written Comprehension
  • Written Expression

Bachelor of Computer Applications (B.C.A) - Others

Bachelor of Science (B.Sc) - Computer Science

Bachelor of Technology (B.Tech) - Computer Engineering

Bachelor of Technology (B.Tech) - Computer Science & Business Systems

Bachelor of Technology (B.Tech) - Computer Science & Engineering

Experience in SQL Database Administration

  • Health Insurance
  • 5 Days Working
  • Career Advancement
  • Rewards & Recognitions

Journey