Job Description
Job Description SQL DBA - Trainee Analyst/Engineer
Experience : 0 to 1 Years
No.of Positions: 2
Job Location: Bangalore
Notice Period: Immediate / Max 15 Days
The candidate should have strong SQL knowledge, Here are few points
- Implement and maintain the database design
- Create database objects (tables, indexes, etc.)
- Write database procedures, functions, and triggers
Good soft skills are a must (written and verbal communication)
Good team player
Ability to work in a 24x7 support model (rotation basis)
Strong fundamentals in Algorithms, OOPs and Data Structure
Should be flexible to support multiple IT platform
Analytical Thinking
Additional Information :
Functional Area: IT Software - DBA, Datawarehousing
Role Category: Admin/ Maintenance/ Security/ Datawarehousing
Role: DBA
Education :
B.Tech/ B.E
Skills
SQL DBA, IMPLEMENTATION, SQL, DBMS, DATA WAREHOUSING
About Semperfi Solution
Similar jobs
Hiring PHP Developer
Job description
Should have proven work experience of 1-2 years as a PHP - Laravel based development in a competitive environment
Proficient in developing applications based on Laravel 5 or greater
Proficient in handling MySQL database. (Experience in PostgreSQL is a plus)
Experience in other PHP Frameworks like Yii, Zend , Cake PHP, CodeIgniter are added advantage
Experience in analyzing & modifying existing open source / plugin code & extensions jQuery, XML, JavaScript, HTML, CSS, AJAX
Experience in SOAP, REST and web services
Responsibilities:
- Lead the development of the back-end systems for our first product.
- Build reliable, secure and performant back-end systems.
- Drive test coverage and continuous delivery automation within the team.
- Mentor and provide feedback to teammates.
Requirements:
- 3+ years of software development experience.
- Strong computer science fundamentals.
- Deep and wide knowledge of Java ecosystem.
- Can write code that is readable, maintainable, secure and performant.
- Know the importance of tests and how to approach writing different types of tests.
- Good intuition for REST API design.
- Deep understanding of relational databases, transactions, entity-relationship modelling.
- Comfortable writing highly concurrent systems.
- Experienced in using profilers, tuning garbage collection, optimising SQL queries.
The Role
Working as a “Backend Developer” at Bonzai gives you the opportunity to work on maintaining and improving the platform.
- Work on the entire product lifecycle starting from design to deployment and monitoring.
- Explore new technologies such as Kotlin, patterns such as Domain-Driven Design and other cool stuff such as Gitlab CI/CD pipelines, Docker, ECS, Golang, Python, Terraform, distributed tracing and even Haskell.
- Ensure top-notch performance in terms of product and feature experience.
What you need to succeed
- 2 - 3 yrs of experience in Java, Spring Boot, Hibernate, Rest API, and MySQL.
- Good to have experience/knowledge of other programming languages such as Kotlin or Python, other DBs such as Redshift, platforms such as AWS and architectural patterns such as https://martinfowler.com/bliki/DomainDrivenDesign.html">Domain-Driven Design (DDD) and https://en.wikipedia.org/wiki/Hexagonal_architecture_(software)">Hexagonal architecture.
- Good understanding of Object-oriented concepts, Functional programming and Design Patterns.
- Exceptional communication skills and ability to articulate complex ideas in written, spoken and visual language
- Bachelor in engineering preferably from a leading institute across the globe.
We're looking for Senior Node js backend developers with over 2+ years of experience and strong expertise in Javascript based development using Node js and Express. We are looking for cadidates who are go-getters and are leaning towards leadership positions. Candidates must have a proven history of building, scaling, optimising and securing Node js based backends and APIs using a microservice architecture.
Bonus Skill : Experience with ReactJs, Postgres
We would prefer candidates who can join immediately or are currently serving their notice period.
Key Skills Required
-
A passion for Javascript based solutions and an extremely strong understanding of JavaScript
-
Proficiency in Node js and Express based development
-
Stong experience in building scalable REST APIs
-
Experience in implenting API security using tokens, encryptions keys and other methods
-
A proved history of building scalable and secure web applications and APIs with Node js using a microservice architecture
-
Working experience with API Gateways
-
Experience with Docker
-
Experience in maintaining code via Git workflows
-
Ability to work independantly or as a part of a team
-
Ability to work in an Agile environment
Responsibilities
-
Understanding requirement and congributing to engineering solutions at a conceptual stage to provide the best possible solution to the task/challenge
-
Building high quality code using coding standards based on the SRS/Documentation
-
Building component based, maintainable, scalable and reusable backend libraries/modules.
-
Building & documenting scalable APIs on the Open Spec standard
-
Unit testing development modules and APIs
-
Conducting code reviews to ensure that the highest quality standard are maintained
-
Securing backend applications and APIs using industry best practices
-
Troubleshooting issues and fixing bugs raised by the QA team efficiently.
-
Optimizing code
-
Building and deploying the applications
• Should have 5+ years of work experience in design, develop, Code and Unit Test web and desktop-based applications written in .Net framework starting from 4.x and above.
• Strong analytical skills to understand a given requirement and provide work estimates.
• Strong Object-Oriented Programming knowledge.
• Strong experience with Static Code Analyzers like Fortify.
• Should have good understanding of web servers such as IIS and Front-end such as HTML’s and Razor based engines.
• Strong debugging skills using .net front end and backend.
• Strong coding experience and thorough understanding of programming languages such as C#, VB.NET, ASP.Net, ADO.Net, JQuery, JavaScript, Traditional Web Services, WCF, Web API and other Scripting languages such as pythons.
• Strong working knowledge on various design patterns such as MVC, MVVM, DDD, Repository Pattern and any custom/hybrid framework as designed by the Architects.
• Should have a strong working knowledge of Azure DevOps.
• Strong knowledge and understanding of data sharing medium using JSON, XML and other media types.
• Strong knowledge on Entity Framework (6 and above) and other ORM such as Dapper.
• Strong knowledge and programming skills in Database such SQL SERVER, Oracle, My SQL and SQL Express. Additionally, nice to know-how knowledge in MS ACCESS.
• Strong knowledge and coding experience in REST based web services and service-oriented design patterns using WCF and other API’s.
• Should have used IDE such as Visual Studio and Visual Studio Code for Front-end development.
• 1+ years of building SPA web solutions using Angular 6/7/8 , BackBone, Bootstrap
• 5+ years building HTML5 complaint pages
• 3+ years of experience using TypeScript
• 3+ years of writing automated testing using Jamine or others
Day to Day job Duties: (what this person will do on a daily/weekly basis)
• Co-ordinate/mentor other Junior developers on a day to day basis.
• Understand the use cases/User Story, code and develop on a designed platform/pattern.
• Strict adherence to coding standards.
• Participate self-code review/peer reviews and correct errors wherever applicable before checking in the final code into the Branch/code repo.
• Create code documentations wherever applicable and as set guidelines by the team.
• Create and perform Unit Tests wherever applicable as set guidelines by the team.
• Provide feedback and assist in estimation planning.
• Merge code branches as and when required.
• Create and publish release documentations and application deployments as and when requested.
• Report out statuses to the leads onshore daily during the Stand-up calls.
• Additionally, update efforts on a given work item on everyday basis.
• Provide true estimates on work assigned prior development. Also ask questions/provide comments on User Stories/work items assigned.
• Be a team player and flexible towards availability in case of any urgent issues that need immediate attention.
• Plan out vacations in advance (min. 2 weeks of adv. Notice).
Nice to have(not a must) experience, skills
• Good understanding of Service Workers.
• Prior coding experience using FORTRAN.
• Experience on 3rd party tools like Spire.Pdf, PDF.Js.
• Knowledge of Rapid application development framework like DevExpress, Code on Time, HighCharts.
• Knowledge of code clean up tools like CodeMaid.
• Knowledge of Power BI and O365 Suites of applications.
• knowledge of SQL Data tools like SSIS and SSRS.
General Accountabilities/Job Responsibilities
- Participation in the requirements analysis, design, development and testing of applications.
- The candidate is expected to write code himself/herself.
- The candidate is expected to write high level code, code review, unit testing and deployment.
- Practical application of design principles with a focus on the user experience, usability, template
- designs, cross browser issues and client server concepts.
- Contributes to the development of project estimates, scheduling, and deliverables.
- Works closely with QA team to determine testing requirements to ensure full coverage and best
- quality of product.
- There is also the opportunity to mentor and guide junior team members in excelling their jobs.
Job Specifications
- BE/B. Tech. Computer Science or MCA from a reputed University.
- 3 -12 Years of experience in software development, with emphasis on JAVA/J2EE Server side programming.
- Hands on experience in Core Java, Multithreading, RMI, Socket programing,
- JDBC, NIO, webservices and Design patterns.
- Should have Knowledge of distributed system, distributed caching, messaging frameworks,
- ESB etc.
- Knowledge of Linux operating system and PostgreSQL/MySQL/MongoDB/Cassandra database is essential.
- Additionally, knowledge of HBase, Hadoop and Hive are desirable.
- Familiarity with message queue systems and AMQP and Kafka is desirable.
- Should have experience as a participant in Agile methodologies.
- Should have excellent written and verbal communication skills and presentation skills.
- This is not a Fullstack requirement, we are purely looking out for Backend resources.
BASIC QUALIFICATIONS
- Ability to design for scale
- Implement solutions for broadly defined problems
- Drive best practices and engineering excellence
- Development of code in object oriented languages like C++ and Java and build large scale robust distributed systems
- 3+ years experience building successful production software systems
- A solid grounding in Computer Science fundamentals (based on a BS or MS in CS or related field)
- Experience developing software services and an understanding of design for scalability, performance and reliability.
- Mastery of the tools of the trade, including a variety of modern programming languages (Java, JavaScript, C/C++) and open-source technologies (Linux, Spring)
- Proven ability to work in a fast paced, agile and in an ownership and results oriented culture.
SKILLS WE ARE LOOKING FOR
Build reusable APIs for our client-facing apps in Node.js
Create and maintain scalable infrastructure leveraging modern cloud platforms Write tests and documentation as you implement features with your team Maintain expertise in current and emerging technologies and tools
THE PERSON WE ARE LOOKING FOR
4+ years’ Experience with NodeJS
BS degree or higher in Computer Science or Engineering Experience documenting and testing RESTful APIs
Experience working with databases in PostgreSQL, MongoDB or Redis
Experience and enthusiasm for working collaboratively with others in an Agile environment