Application database administrator
Bloom Solutions
Bangalore
8h ago

JD1381 - Application database administrator

Key Skills : SQL Server,JSON data modeling,OLTP,Microsoft SQL,windows server, security delegation, SPNs, storage components Exp : 5 -

8 Sal : Loc : Bangalore Client of Bloom Consulting Services email : hiring bloomsolutions.com

About the Job

Application DBA INSZoom is the world’s 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’re a fun, fast-paced technology company who lives and breathes technology. We’re 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 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 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.
  • 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
  • Bachelor’s degree from an accredited educational institution.
  • 5-8 Years relevant experience.
  • Location

  • This job is based in Bengaluru, India
  • What You Need for this Position

    You should have knowledge of :

  • SQL Server
  • JSON data modeling
  • windows server
  • security delegation
  • SPNs
  • storage components
  • Experienced

    Apply
    Add to favorites
    Remove from favorites
    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form