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
How do Technogisers function?
Value: Exploring technologies and implementing them on the projects provided they make business sense and deliver value.
Engagement: Be it offshore or onshore, we engage ourselves daily with the clients. This assists in building a trustworthy relationship at the same time, collaborating to come up with strategic solutions to business problems.
Solution: We are involved in providing hands-on contributions towards Backend & Front-end design and development at the same time, flourishing our DevOps culture.
Thought Leadership: Attend or present technical meet-ups/workshops/conferences to share knowledge and help build Technogise brand.
How can you become a Technogiser?
Core Skills:
- A thorough understanding of at least one technology stack is the go-to person for any problems related to this
- Experience: 5 to 8 years of Backend experience
- Should have knowledge about Kafka
- Should have worked on Springboot, Microservices
- Should be able to write the test cases
- Influence technical decision-making and high-level design decisions - choice of frameworks and tech approach
- Demonstrate the ability to understand different approaches for application, and integration and influence decisions by making appropriate trade-offs
Ways of working:
- You communicate effectively with other roles in the project at the team and client levels.
- You drive discussions effectively at the team and client levels. Encourage others to participate.
Going beyond
- Establish credibility within the team as a result of technical and leadership skills
- Mentoring fellow team members within the project team and providing technical guidance to others beyond project boundaries.
- Build and own Growth framework of people in the project team.
- Actively participate in organizational activities.
Tech stack: We are polyglots so focus on varied technologies.
Java,Node, Mongodb, Microservices, Go lang, Ruby, Ruby on rails.
Key Responsibilities:
- Rewrite existing APIs in NodeJS.
- Remodel the APIs into Micro services-based architecture.
- Implement a caching layer wherever possible.
- Optimize the API for high performance and scalability.
- Write unit tests for API Testing.
- Automate the code testing and deployment process.
Skills Required:
- At least 2 years of experience developing Backends using NodeJS — should be well versed with its asynchronous nature & event loop, and know its quirks and workarounds.
- Excellent hands-on experience using MySQL or any other SQL Database.
- Good knowledge of MongoDB or any other NoSQL Database.
- Good knowledge of Redis, its data types, and their use cases.
- Experience with graph-based databases like GraphQL and Neo4j.
- Experience developing and deploying REST APIs.
- Good knowledge of Unit Testing and available Test Frameworks.
- Good understanding of advanced JS libraries and frameworks.
- Experience with Web sockets, Service Workers, and Web Push Notifications.
- Familiar with NodeJS profiling tools.
- Proficient understanding of code versioning tools such as Git.
- Good knowledge of creating and maintaining DevOps infrastructure on cloud platforms.
- Should be a fast learner and a go-getter — without any fear of trying out new things Preferences.
- Experience building a large scale social or location-based app.
YOUR ROLES AND RESPONSIBILITIES:
As a back end engineer you will be responsible for developing and delivering best in class digital neobanking API platform using the latest technologies and solutions. We believe that technology should not be a barrier when it comes to providing the best-in-class banking services to our customers and we echo that when you as an engineer present your designs and thoughts to improve the app constantly to ensure we are leading the innovation in the neobanking domain. Your role will be (but not limited) to
- Work in most challenging and complex use cases within Banking and Finances sector.
- Build domain led scalable banking and payments microservices using JAVA + SpringBoot.
- Work on processing large (and we mean LARGE) amounts of data across the muvin platform.
- Work in a cross-platform team where you integrate with 3 rd party platforms and APIs along with muvin’s APIs to ensure consistent and smooth user experience.
- Develop software using latest tools and technologies in an agile led environment.
- Own and deliver high quality solutions from start to end.
- Participate in muvin’s feature development and planning.
- Learn and get mentored from the veterans in the industry and help the team around you.
WHAT YOU HAVE:
- E/BTech in Computer Science or similar degree.
- 1-5+ years of relevant work experience.
- Strong foundations in Java or other high level programming language.
- Experience working on Spring framework.
- Experience developing, debugging, and resolving performance problems in complex multi-service systems.
- Extensive knowledge on OOP and software architecture.
- Sheer willingness to write performant well designed code adhering to best practices in data structures and algorithms.
- Ability and urge to write meaningful test cases and documentation.
- Good aptitude in analytical and problem-solving skills.
- Experience working with relational databases and NOSQL databases.
- Knowledge or experience working on concurrent and event driven development.
- Dogged desire to become a SME (Subject Matter Expert) in one of the areas outside coding (automation, scalability, performance, architecture, optimization, algorithms etc.,).
- Good communication skills.
WE’LL BE EXCITED IF YOU BRING:
- DevOps and CI/CD experience on AWS or similar cloud services platforms
- Experience working with payments, wallets, and any other banking services.
- Experience working with Docker and Kubernetes.
- Experience with any of the reporting and analytics platforms.
- Min 5 years of hands-on experience in Java Spring-boot technologies
- Experience with monolithic applications
- Experience using Redis and RabbitMQ
- Experience with RDBMS such as SQLServer and My SQL
- Strong analytical, problem solving and data analysis
- Excellent communication, presentation and interpersonal skills are a must
- Micro service frameworks such as Java SpringBoot
- Design and implement automated unit and integration tests
- Design the architecture of new services to deliver timely communication from server to
- client and server to server, while still functioning alongside existing server components
- Describe and implement the communications across multiple network layers, considering
- performance, reliability, and flexibility with respect to the underlying infrastructure
- Enhance and expand the ORM layer of the studio’s in-house web framework
- Craft software solutions for supporting flexibility in resource allocation, from compute to storage
- Consult with technical operations on appropriate Kubernetes-based infrastructure design
- Design for performance, and measure the effects
- Review your colleagues’ code, and learn from their reviews as well
- Identify, document, and communicate best practices for the engineers who use the fruits of your labour
- Requirements:
- 7+ years professional work experience
- BS or MS degree in Computer Science or a related technical field
- Must be proactive, self-directed, detailed and organized
- Proficient in PHP, C++, or Go
- Knowledge of relational databases and SQL, preferably MySQL
- Experience with in-memory NoSQL databases, such as Redis
- Ability to debug issues within custom code quickly
- Passion for developing scalable and maintainable software systems
- Contribute to architectural and design discussions.
- Design, Develop & Unit test features in the product.
- Ensure smooth and timely communication with both the internal and external stakeholders.
- Participate in estimations and ensure timely delivery of the features.
- Conduct peer reviews and ensure the quality of committed code.
Essential Experience And Skill-Set You Should Have
- Should have at least 2-4 years of experience in software development.
- Should have at least 2 years of hands-on experience in Java as a programming language.
- Should be well versed with Java 8 or above.
- Strong foundation in computer science, with strong competencies in Data Structures, algorithms, and their space-time complexities.
- Expertise in developing and consuming RESTful, micro-services using Spring Framework.
- Expertise with Spring data persistence frameworks such as JPA, -Repositories, Entities, Entity Manager etc.
- Exposure to Spring Cloud Frameworks such as Discovery, Config, Spring Cloud Gateway, Ribbon.
- Good to have knowledge on other Spring Frameworks such as Spring Security, Spring AOP.
- Must be proficient with the Linux commands.
- Strong debugging and troubleshooting expertise
- Good working knowledge of Relational and Non-Relational Databases.
- Sound understanding of Agile Software Development Processes like Scrum & Kanban.
- Deep practical knowledge of Domain Driven Design approach to software design.
- Experience writing and maintaining Unit and Integration tests.
Additional Desirable Qualifications
- Good to have knowledge on Java reactive framework.
- Understanding of CI/CD (Jenkins, Maven, Docker, Kubernetes).
- Knowledge on message queueing frameworks like RabbitMQ / ActiveMQ/ Kafka will be add-on.
- Identity & Security Domain Knowledge covering OAuth2, OpenId - Connect, Digital Signatures & Certificates.
- Domain knowledge of Ed-tech industry will be a plus
Required Soft Skills
- A self-starter attitude, the ability to work independently and in a group, demonstrated initiative, and good writing/briefing skills are great to have.
- Should be good at analytical thinking and breaking down large problems into solvable chunks.
- Demonstrated the ability to think creatively and come up with ideas/thoughts with significant business/ organizational impact.
- Ability to quickly adapt to changing technological trends.
- Good Analytical and Communication skills.
- Strong proficiency with JavaScript - Knowledge of Nodejs and frameworks available for it such as Express, etc.
- Understanding the nature of asynchronous programming and its quirks and workarounds
- Good understanding of server-side templating languages such as Jade, EJS, etc.
- Good understanding of server-side CSS pre-processors such as SCSS, Stylus, Less, etc.
- User authentication and authorization between multiple systems, servers, and environments - Integration of multiple data sources and databases into one system
- Understanding fundamental design principles behind a scalable application
- Understanding differences between multiple delivery platforms, such as mobile vs. desktop, and optimizing output to match the specific platform
- Creating database schemas that represent and support business processes
- Implementing automated testing platforms and unit tests - Proficient understanding of code versioning tools, such as Git
Duration :- Full Time
Company Name :- Fragma Data
Main Skills are Java, Microservices, and SQL
Primary Responsibilities
Development of applications in Java including:
Building data processing platforms.
Developing micro-service-oriented applications.
Interact with stakeholders of the applications being developed.
Desired Skills
Must have experience in Java JEE, Spring Framework, and Microservices
Experience in SQL and JDBC
Experience in build tools Maven, git
Experience in Cloud Platforms AWS, Azure is a plus.
About the Company
Based in California’s Silicon Valley, WebShar is focused on enabling innovative teams to bring their ideas to life. WebShar provides software development consulting services to innovative companies around the world. Through years of cutting edge technical expertise, the WebShar team utilizes their extensive knowledge of modern software development methodologies to help companies create innovative software solutions.
About the Job Role
Skills
Primary
- Java, J2EE, Spring MVC
- Hibernate or other ORM
- Web technology and security, REST framework
- Any one UI technology and ready to learn a new one.
- Database knowledge (MySQL, Oracle, Postgres)
- Unit testing frameworks
- Version Control (Eg., Git)
Good To Have
- Microservices architecture implementation using docker and kubernetes
- Web technologies like HTML, CSS and Javascript
- Python, Shell Scripting
Key Responsibilities
- Identify and analyze user requirements
- Prioritize, assign and execute tasks throughout the software development life cycle
- Document development phases
- Design database architecture
- Develop Java EE applications
- Write well-designed, efficient code
- Review, test and debug team members’ code
- Schedule product releases with internal teams
- Ensure our applications are secure and up-to-date
- Stay up-to-date on emerging technologies
Requirements
- 6 to 8 years of work experience as a Senior Java Developer or similar role
- Experience designing, building and testing Java EE applications
- In-depth knowledge of popular Java frameworks like Spring MVC
- Experience with Object-Oriented Design (OOD)
- Good delegation and time management skills
- Problem-solving abilities
- BSc in Computer Science, Engineering or relevant field