11+ ERD Jobs in India

• Job Description:

MySQL Database Administrator (DBA) who will be responsible for ensuring the

Performance, Database Tuning, Database Cleanup, Database Migration, Database Availability, and Security of Clusters of MySQL

Instances. The candidate will also be responsible for Orchestrating Upgrades,

Backups, and Provisioning of Database Instances. The candidate will also work in

tandem with the other teams, documentation, and specifications as required.

.

• Key Responsibilities:

✓ Provision MySQL instances, both in Clustered and Non-Clustered Configurations

✓ Ensuring the Performance, Database Tuning, Database Availability, and Security

of Clusters of MySQL Instances

✓ Development of Database Schema

✓ Development of ERD

✓ Find the Root Cause of Database related issues & Database Clean-up

✓ Migrating Data from Customer Database to Serosoft Product Database

✓ Prepare Documentation and Specifications

✓ Handle common database procedures, such as upgrade, backup, recovery,

migration, etc.

✓ Profile server resource usage, optimize and tweak as necessary

✓ Collaborate with other team members and stakeholders

• Skills and Qualifications:

✓ Strong proficiency in MySQL database management

✓ Decent experience with recent versions of MySQL

✓ Understanding of MySQL’s underlying storage engines, such as InnoDB and

MyISAM

✓ Experience with replication configuration in MySQL

✓ Proficient in Database Clean-up and Migrations

✓ Knowledge of De-Facto Standards and Best Practices in MySQL

✓ Proficient in Writing and Optimizing SQL statements

✓ Proficient in Table Scan, Row Scan, Query Execution Plan, SQL Profiler, etc.

✓ Should be able to decide when to create Views (Standard Views, Indexed views,

and Partitioned views)

✓ Knowledge of MySQL features, such as its Event Scheduler

✓ Ability to plan Resource requirements from High-Level Specifications

✓ Familiarity with other SQL/NoSQL databases such as PostgreSQL, MongoDB, etc.

✓ Knowledge of limitations in MySQL and their workarounds in contrast to other

popular relational databases

✓ Proficient understanding of code versioning tools such as SVN / Git

✓ DBA Certification would be added advantage

What You Will Do

• Acquisition strategy: Identify and strategise the next set of cohorts and channels that we need to unlock. This is going to set the roadmap of the pod and effectively unlock new opportunities for activation improvements
• Drive Initiatives: Liaise with internal team members and also with Product, Analytics, Creatives, etc., to drive solutions, scale-up, and achieve efficiency improvement in performance campaigns
• Performance Management: Identify issues which impact CPI and incoming user quality and RCA
• Strong understanding of data - we are a data driven organization, and measure outcomes closely through internal metrics. You will be working closely with the Analytics team across problem discovery, solutioning, execution and measurement

What Will You Need

• Bachelor's / MBA degree in any discipline from a top-tier college – MBA is preferable
• 5+ years of experience in performance marketing strategy / Growth in a high-growth startup, or strategy consulting firm
• Structured problem-solving with good communication skills
• Data-driven with good Excel skills. Proven ability to take up high ownership
• Ability to collaborate with internal and external stakeholders (within the company)
• Enthusiastic about learning new skills and solving challenging problems

• Well versed with Programming Languages C, C++
  
• At least 2 years of experience working in projects in CAD/CAM or 3D graphics APIs like OpenGL, OpenGL-ES, or WebGL, etc.
  
• Good hold on Geometry
• Able to work independently as needed .
• Able to participate and drive in customer scoping sessions, able to do designs and design reviews, code reviews etc.
• Good communication and client facing skills
• Quick learner 
• Self-driven person
• We are looking for someone who can join soon

• Minimum 3 years of working experience in database related projects.
• Working experience on any of the leading Database management systems viz., Oracle,SQL-Server, etc. (Experience on Postgres database systems will be an added advantage).
• Adequate Database Development skills & should be proficient in SQL coding.
• Working experience in Database SQL Optimization/Performance Tuning.
• Working experience on any of the Database Programming languages viz., PL/SQL, PL/pgSQL,T-SQL,etc.
• Flexible to learn, adopt & scale to any data centric technologies as per the evolving Organizational product strategies.

• Good to have skill sets of the Candidate:
• Working experience on Data Warehouse projects or exhibits sound knowledge over the concepts.
• Working experience on Data Analytics/Reporting/ETL or exhibits sound knowledge over the concepts.
• Database agnostic approach to data/database solutions.
• Exhibits sound knowledge on Big-data/Hadoop, Kafka, Map-Reduce programming, NoSQL,etc.

• Experience in software development, prototyping, functional analysis, integration, and testing.
• Experience with Javascript and RESTful technologies including building RESTful APIs
• In-depth understanding of the JavaScript programming languages especially Angular and node.js and the ability to peer review other engineer's code constructively
• Highly skilled at problem-solving, unit-testing, and debugging.
• Expert understanding of best practice engineering principles for building MEAN applications.
• In-depth knowledge of database systems and an understanding of data structures, data normalization, and query performance considerations. Particularly Non-Relational/NoSQL databases including MongoDB.
• Automated unit testing and CI experience
• Ability to effectively communicate technical concepts pictorially, orally or in writing.
• Docker experience desired
• Ability to learn business rules quickly by reading requirements, engaging in conversation, or reverse engineering.
• Expertise in source code control and versioning concepts.

• Understand functional and non-functional testing requirements for APIs

• Document functional and non-functional testing scenarios and cases where needed, on one of the test management tools
• Identify or create data for testing 
• Automation framework design and implementation according to project structure
• Develop test automation scripts using tools like RestAssured and SoapUI
• Must be able to use all web methods like GET, PUT, POST, DELETE, etc.
• Validate feedback, response time, and error code
• Validate XML and JSON body using JSON Parser 
• Raise PR to check in code for test automation scripts
• Conduct peer reviews of test cases and automation scripts

Mandatory Skills


• Intermediate to advanced level skill in programming using Java and/or Python
• Intermediate to advanced level skill in using API test automation tools and developing test automation frameworks - RESTAssured, Postman, SoapUI, Karate, Robot
• Intermediate to advanced level skill in working with databases preferably SQL
• Configuration management - GIT • Build management - Maven
• Continuous Integration - Jenkins 
• Excellent verbal and written communication skills

We indulge in all things that would excite you!!

• Work on large-scale, custom distributed software systems using Java, Scala, MongoDB, JavaScript (AngularJS, ReactJS) and the likes

• We work almost exclusively on customer site providing a mix of delivery and consulting services, so you'll be flexible about travel

• Employ Agile development including task estimation, test automation, deployment automation, and Continuous Integration to improve overall execution speed and product quality

• Work in a dynamic, collaborative, transparent, non-hierarchical, and ego-free culture where your talent is valued over a designation or title

• Spread the word about best practices in software development inside and outside Equal Experts community like Expert Talks

What we look for in you?

• 3 + years Hands-on in development and delivery experience with Java, Scala, and the likes

• Passion for software engineering and craftsman-like coding prowess

• Great OO skills, including strong design patterns knowledge

• Experience working with Agile, TDD, Lean and/or Continuous Delivery approaches and best practices, such as Extreme Programming (XP)

• Enthusiastic to work collaboratively with people and sharing your ideas to solve real business problems.