PayMate India - Database Architect - Maintenance & Performance Tuning (4-6 yrs) Mumbai (DevOps)
PayMate India
Mumbai, India
6d ago
source : hirist.com

Job Description : Responsible to keep the database up and running smoothly 24 / 7. The goal is to provide a seamless flow of information throughout the company, considering both backing data structure and front-end accessibility for end-users.

Key Responsibilities :

  • Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
  • Experience with backups, restores and recovery models
  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
  • Database design, Database Modelling, Normalization.
  • Reviewing query performance and optimizing code
  • Writing queries used for front-end applications (websites, desktop applications, or cloud apps)
  • Working with application developers to create optimized queries
  • Creating database triggers for automation, e.g., automatic email notifications
  • Creating table indexes to improve database performance
  • Programming views, stored procedures, and functions
  • Perform tests and evaluations regularly to ensure data security, privacy and integrity
  • Monitor database performance, implement changes and apply new patches and versions when required.
  • Technical & Strategic :

  • Excellent knowledge of data backup, recovery, security, integrity and SQL
  • Hands-on experience with database standards and end-user applications.
  • Behavioural Competencies :

  • Must possess - can-do- attitude and a strong drive to take initiative and complete the tasks.
  • Must be a good team player and should be flexible to work on any assigned tasks and adjust to changing business priorities and plans.
  • Should be able to work under minimal supervision.
  • Should be able to work in fast-paced start-up environment
  • Openly accept personal feedback and provide feedback to the management.
  • Report this job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    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