2 Database Sharding Jobs

E2M is not your regular digital marketing firm. We're an equal opportunity provider, founded on strong business ethics and driven by more than 300 experienced professionals. Our client base is made of digital agencies that need help with solving their bandwidth problems, cutting overheads, and increasing profitability. We need diligent professionals like you to help us help them. If you're someone who dreams big and has the gumption to make them come true, E2M has a place for you. We are seeking an experienced and skilled MERN Stack Developer to join our dynamic team. This role requires hands-on experience in building scalable and high-performance web applications using modern technologies. The ideal candidate will have expertise in developing APIs, working with databases, and optimizing performance in distributed systems. Candidates must have 5+ years of professional experience and be eager to work on challenging and innovative projects. Responsibilities: Backend Development: - Develop, test, and maintain RESTful APIs and GraphQL endpoints using Node.js. - Design and implement microservices-based architecture in Node.js. - Set up Docker-based Node.js environments. Database Management: - Work with MongoDB, MySQL, PostgreSQL, and Redis for efficient data storage and retrieval. - Implement data replication and database sharding for scalability. - Participate in database migrations, particularly from MongoDB to PostgreSQL or MySQL. Code Optimization and Quality: - Write clean, modular, and scalable code. - Utilize tools like ESLint and SonarQube to maintain code quality. - Collaborate on testing and debugging to ensure application reliability. Performance and Monitoring: - Implement performance optimization techniques for backend systems. - Use APM tools for monitoring and performance analysis. Collaboration and Communication: - Work closely with cross-functional teams to integrate APIs with front-end applications. - Participate in code reviews and knowledge-sharing sessions. Required Skills: - Proven experience with Redis and Redis JSON in live projects. - Hands-on experience with Node.js APIs (both RESTful and GraphQL). - Proficiency in MongoDB and MySQL/PostgreSQL database design and management. - Understanding of JavaScript promises and asynchronous programming. - Experience working with microservices architecture. - Knowledge of Docker-based setups for Node.js. - Familiarity with data replication and database sharding. - Experience with PM tools for efficient project management. Good to Have: - Knowledge of AWS and cloud services. - Experience with database migrations from MongoDB to PostgreSQL or MySQL. - Familiarity with ESLint or SonarQube for code quality checks. - Knowledge of Node.js sockets. - Experience using APM tools for performance monitoring Qualifications: - Bachelor's degree in Computer Science, Information Technology, or a related field. - Minimum of 5 years of professional experience in web development with a focus on backend technologies. - Strong problem-solving skills and the ability to work in a fast-paced environment. - Familiarity with version control systems such as Git.,

Position: PostgreSQL DBA Location: Remote Shift Time: 2pm to 11pm Experience: 8+ Years Job Overview: We are looking for a highly experienced Senior PostgreSQL DBA to join our growing team. The ideal candidate will play a critical role in managing, optimizing, and scaling PostgreSQL databases in a Kubernetes-based environment that utilizes sharding and pods for high availability and distributed workloads. The role requires deep technical expertise, an ownership mindset, and hands-on experience working with mission-critical, high-throughput database systems. Key Responsibilities: Design, implement, and maintain highly available PostgreSQL clusters Manage sharded database architecture and performance across multiple pods in Kubernetes Optimize database performance, indexing, query tuning, and vacuuming strategies Monitor, troubleshoot, and resolve database issues including replication, failover, and storage Automate backups, recovery plans, and database provisioning Ensure database security, access control, and compliance with client policies Collaborate with DevOps and application teams to ensure smooth database operations and integrations Participate in incident management and on-call support for database-related production issues Perform database capacity planning, data partitioning, and archiving strategies Technical Skills & Experience Required: 8+ years of hands-on experience with PostgreSQL administration Strong knowledge of PostgreSQL performance tuning, replication, and backup/restore mechanisms Experience with database sharding, partitioning, and horizontal scaling Solid understanding of AWS services such as EC2, EKS, RDS, Aurora, S3, CloudWatcha Proficient in writing SQL, PL/pgSQL, and automation scripts (Bash, Python, etc.) Hands-on experience with monitoring and logging tools such as Datadog, Splunk, Prometheus, or pgBadger Experience integrating with CI/CD pipelines and DevOps practices Strong understanding of database security, auditing, and access control Desirable Skills: Exposure to cloud-native PostgreSQL services (e.g., Amazon RDS/Aurora, GCP Cloud SQL, Azure PostgreSQL) Familiarity with PostgreSQL extensions like PostGIS, TimescaleDB, etc. Knowledge of high availability tools (Patroni, Pgpool-II, Stolon, etc.) Exposure to multi-tenant or microservices-based architectures Knowledge of cloud cost optimization for database infrastructure Experience working in an Agile development environment Required Skills: Strong problem-solving skills and proactive mindset Ability to communicate technical concepts clearly with cross-functional teams Comfortable in client-facing roles, especially during incidents and design discussions Willingness to mentor junior DBAs and support team knowledgesharing Show more Show less