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
- Engineering and Technology
- English Language
- Flexibility of Closure
- Fluency of Ideas
- Inductive Reasoning
- Information Ordering
- Judgment and Decision Making
- Mathematical Reasoning
- Near Vision
- Operations Analysis
- Oral Comprehension
- Oral Expression
- Problem Sensitivity
- Reading Comprehension
- Selective Attention
- Speech Clarity
- Speech Recognition
- Systems Analysis
- Systems Evaluation
- Written Comprehension
- Written Expression
Bachelor of Engineering (B.E) - Others
Bachelor of Technology (B.Tech) - Others
- 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