Location
Bangalore | India
Job description
The Database Developer will be a part of BNIs Global Information Technology Team and will primarily have responsibilities over the creation, development, maintenance, and enhancements for our databases, queries, routines and processes. The Database Developer will work closely with the Database Administrator, data team, software developers, QA engineers and DevOps Engineers located within the BNI office in Bangalore, as well as all levels of BNI Management and Leadership teams. This is an unparalleled opportunity to become part of a growing team and a growing global organization. High performers will have significant growth opportunities available to them.
The candidate should be able to be an expert in both database and query design and should be able to write queries on the fly on demand, he/she should posse good hands-on experience on data engineering and should be well versed with tools mentioned in the technical table below.
The person should be able to own the assignments and should be independent in terms of the development of queries and other aspects in data engineering.
Job Responsibilities - Design stable, reliable and effective databases
- Create, optimize and maintain queries, used in our software applications, as well as data extracts and ETL processes,
- Modify and maintain databases, routines, queries in order to ensure accuracy, maintainability, scalability, and high performance of all our data systems,
- Solve database usage issues and malfunctions,
- Liaise with developers to improve applications and establish best practices
- Provide data management support for our users/clients
- Research, analyze and recommend upgrades to our data systems
- Prepare documentation and specifications for all deployed queries/routines/processes,
- Profile, optimize and tweak queries and routines for optimal performance,
- Support the Development and Quality Assurance teams with their needs for database development and access
- Be a team player and strong problem-solver to work with a diverse team
Job Requirements - Bachelors Degree or equivalent work experience
- Fluent in English, with excellent oral and written communication skills
- 5+ years of experience with Linux-based MySQL/MariaDB database development and maintenance
- 2+ years of experience with Database Design/Development/Scripting
- Proficient in writing and optimizing SQL Statements
- Strong proficiency in MySQL/MariaDB scripting, including functions, routines and complex data queries.
- Understanding of MySQL/MariaDBs underlying storage engines, such as InnoDB and MyISAM
- Knowledge of standards and best practices in MySQL/MariaDB
- Knowledge of MySQL/MariaDB features, such as its event scheduler
- (Desired) Familiarity with other SQL/NoSQL databases such as PostgreSQL, MongoDB, Redis
- (Desired) Experience with Amazon Web Services RDS offering,
- (Desired) Experience with Data Lakes and Big Data
- Experience in Python
- (Desired) Proficient Understanding of git/GitHub as a source control system
- Familiarity with working on an Agile/Iterative development framework
- Self-starter with positive attitude with the ability to collaborate with product managers and developers,
- Strong SQL Experience and ability to write queries on demand.
Primary Technologies:
- Database Stored Procedure
- SQL Optimization
- Database Management
- Airflow / DBT / RedShift / Python / Linux
- MariaDB (or any relational database)
- MongoDB
- Shell Scripting
- Understanding of MySQL/MariaDB underlying storage engines
Job tags
Salary
