Senior Database Egineer Full-Time

FREIGHTIFY SOLUTIONS INDIA PRIVATE LIMITED

Posted By : FREIGHTIFY SOLUTIONS INDIA PRIVATE LIMITED

Chennai, Tamil Nadu (2)

Roles and Responsibilities

  • Lead or participate in database management activities including designing highly complex logical and physical databases
  • Lead highly complex data modelling, mapping, integration, and capacity planning efforts
  • Perform the planning, research, design, implementation, maintenance, and control of server class databases
  • Setup a MongoDB Sharding, Installs, configures as per requirements, Setup a MongoDB Replica Set, Installs, configures and maintains High Availability server solutions
  • Implement appropriate indexes for performance improvement.
  • Monitoring at Server, Database, Collection Level, and Various Monitoring Tools related to MongoDB
  • Implement optimal backup and recovery.
  • Understand and optimize query performance.
  • Evaluate, plan and perform the DB upgrades.
  • Maintenance – during release/outage etc.
  • Implementing best practices for backups, replication, and health checks.
  • Database hardening – implement best practices.
  • Knowledge of aggregation in Mongo DB etc.
  • Design and implement DR plans.
  • Work closely with the application team to understand what changes are coming in a build/patch/hotfix, do an impact analysis, fine-tune the queries if any.
  • Automate the process of deploying DB changes so that we can support this for a new build/patch/hotfix.
  • Act as an application DB during the design process.
  • Reviewing the DB Changes done by developers and enforcing best practices and consistency on DB changes.
  • Enforce security best practices on DB with minimal access policy for developers and applications.

Role Specific Skills
  • Active Listening
  • Category Flexibility
  • Complex Problem Solving
  • Computers and Electronics
  • Critical Thinking
  • Customer and Personal Service
  • Deductive Reasoning
  • Design
  • Engineering and Technology
  • English Language
  • Flexibility of Closure
  • Fluency of Ideas
  • Inductive Reasoning
  • Information Ordering
  • Judgment and Decision Making
  • Mathematical Reasoning
  • Mathematics
  • Near Vision
  • Operations Analysis
  • Oral Comprehension
  • Oral Expression
  • Originality
  • Problem Sensitivity
  • Programming
  • Reading Comprehension
  • Selective Attention
  • Speaking
  • Speech Clarity
  • Speech Recognition
  • Systems Analysis
  • Systems Evaluation
  • Written Comprehension
  • Written Expression

Bachelor of Engineering (B.E) - Others

Bachelor of Technology (B.Tech) - Others

Must Have:

    • 5+ year’s hands-on experience as DBA on MongoDB.
    • Understanding of enterprise application technology architecture, components, databases, networking, and infrastructure as code.
    • Strong DBA Experience – MongoDB / MySQL.
    • Strong knowledge on Sharding, Replica Sets
    • Strong scripting experience - Unix/Shell Scripting, Python
    • Technical knowledge of Linux based and cloud based platforms
    • Strong analytical and problem-solving skills
    • Strong AWS Cloud knowledge

  • NA

Journey