Job Opportunities
Sr. Microsoft Sql Dba
one year ago
TESCRA Inc
DESCRIPTION

Perform general database administration tasks including, but not limited to:
design, develop and maintain company databases, analyze the
inter-relationship of data usage and define the physical data structures and
logical views of data elements. Minimize data redundancy and ensure data
integrity and security. Design, code, and implement all schemas. Provide
technical support and consultation regarding database programming and
interaction. Install new software version, patches, and upgrades. Monitor
performance, analyze and track space utilization, establish backup
procedures and provide recovery of data.

 

 

Essential Functions:

 

* Provide design, maintenance, and system support for company
Microsoft SQL DB applications.
* Perform traditional database administration duties including, but
not limited to, software installation, database creation, database
maintenance, capacity planning, tuning, backup, and business continuity
planning for multiple high-availability databases.
* Support, prioritize, and troubleshoot database, operating system,
application and hardware issues.
* Diagnose problems and implement corrective actions related to
database management and associated applications.
* Advanced technical and hands-on experience performing the following
procedures: joining local and remote tables, developing stored procedures,
handling errors in a stored procedure, processing data using cursors,
writing triggers to carry out advanced validation, improving performance
with indexes and views.
* Create, maintain and modify simple to complex reports.
* Review, analyze and modify programming systems including encoding,
testing, debugging and documenting programs as stipulated by company
requirements.
* Maintain familiarity with a variety of the field's concepts,
practices and procedures.
* Create, test and maintain documentation, including diagrams and
schemas, of applications, including standards and procedures for operational
and technical purposes.
* Familiar with storage area networks (SAN) and designing
configuration of production class database servers and database disk
requirements.
* Ability to create database implementation project plans and identify
critical path and resolved issues related to such.
* Provide progress reports to senior IT management as required

QUALIFICATIONS
iconMust Have Skills
  • MICROSOFT SQL
  • MICROSOFT SQL SERVER
  • MICROSOFT SQL SERVER 2005
  • MICROSOFT SQL SERVER - 2008/2008R2/2012
  • MICROSOFT SQL SERVER 2012
  • MICROSOFT SQL SERVER 2014
Minimum Education Level
Bachelors or Equivalent
Years of Experience
6-14 years
ADDITIONAL INFORMATION
Pay Range: OPEN
Work Type: Full Time
Location: India
Job ID: Tescra-Cli-26C44A