• INSZoom - SQL DBA Professional - Data Modeling/OLTP Jobs in Bangalore,India - 23799261

  • INSZoom
  • Save Job
  • 5 - 8 Years
  • Posted : above 1 month

Job Description:

- INSZoom is the worlds largest immigration software company, with solutions for immigration lawyers, corporations, universities, healthcare organizations, and more

- Our feature-rich cloud-based software provides a comprehensive platform that allows clients to share and process valuable information online, process immigration applications quickly and stay compliant while doing so We are a fun, fast-paced technology company who lives and breathes technology

- We are on a mission to simplify the challenges of global immigration and compliance through technology

Position Purpose

- We are looking for an experienced and talented Application database administrator (DBA) who will keep the database up and running smoothly 24/7

- The successful candidate will be responsible for the development and sustainment of the SQL Server Data Warehouse, ensuring its operational readiness (security, health and performance), executing data loads, and performing data modeling in support of multiple development teams

Essential Functions

- Configure and maintain database servers and processes, including monitoring of system health and performance to ensure a high level of performance of critical Microsoft SQL Server RDBMS systems and ensure the high availability of our products

- Experience of Performance and Tuning of both Server and Stored Procedures would be beneficial

- Independently analyze, solve, and correct issues in real time, provide problem resolution end-to-end

- Strong knowledge of database modeling and design

- Maintains database performance by identifying and resolving production and application development problems, calculating optimum values for parameters, evaluating, integrating, and installing new releases, completing maintenance, answering user questions

- Refine and automate regular processes, track issues, and document changes

- Assist developers with tuning of complex query and schema refinement

- Create new database clusters and should be responsible for high availability /disaster recovery solutions using Always ON, Log shipping etc required for business continuity and data growth

- Responsible for promoting application related objects/code (releases) through different environments including production

- Administer security - user accounts & database roles, schema, data encryption, etc

- Support application developers and BI/DevOps teams with database architecture, query optimization, data loads etc

- Responsible to execute and automate recurring DBA tasks

Required Skills and Knowledge

- Strong experience on SQL Server 2016 Administration

- Experience on JSON data modeling

- Understanding of server-client computing and relational database (OLTP) environment

- Must have technical documentation skills

- Knowledge of Microsoft SQL

- Knowledge of programming paradigms and logic

- Solid acquaintance with windows server, security delegation, SPNs, storage components

- Should be able to meet SLAs as per the priorities

- Should be able to assist technical development teams in advising them to implement best database usage practices

- Should maintain documentation as per the Industry Standards

- Strong communications skills and ability to document and present complex designs to a wider audience

- Able to prioritize and execute tasks in a high-pressure environment

- Knowledge of other databases like oracle, MongoDB will be a plus

Education & Experience

- Bachelors degree from an accredited educational institution

- 5-8 Years of relevant experience

Location Bengaluru, India

Profile Summary:

Employment Type : Full Time
Salary : Not Mentioned
Deadline : 12th Apr 2020

Key Skills:

Would you like to try out these free online tutorials?

People who search this job also searched for the following Keywords


Salary trends based on over 1 crore profiles

View Salaries

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status