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
Wissen Technology is now hiring for Java Developer with hands on experience in Core Java, multithreading, algorithms, data structure and SQL skills .
Required Skills:
- Experience - 5 to 10 years.
- Experience in Core Java 5.0 and above, CXF, Spring.
- Extensive experience in developing enterprise-scale n-tier applications for financial domain. Should possess good architectural knowledge and be aware of enterprise application design patterns.
- Should have the ability to analyze, design, develop and test complex, low-latency client-facing applications.
- Good development experience with RDBMS, preferably Sybase database.
- Good knowledge of multi-threading and high-volume server-side development.
- Experience in sales and trading platforms in investment banking/capital markets.
- Basic working knowledge of Unix/Linux.
- Excellent problem solving and coding skills in Java.
- Strong interpersonal, communication and analytical skills.
- Should have the ability to express their design ideas and thoughts.
Key Responsibilities
• Analyze and understand business processes and requirements to develop effective technical solutions.
• Assist in the planning, designing, development, of new applications and enhancements to existing applications.
• Collaborate with IT team members, decision makers, systems owners, and end users to define business requirements and systems goals, and identify and resolve business systems issues.
• Prepare functional specification documents in accordance to new business requirements.
• Ensure compatibility and interoperability of business software applications.
• Review and analyze the effectiveness and efficiency of existing systems and develop strategies for improving or further leveraging these systems.
• Assist in the deployment of new applications and enhancements to existing applications.
• Identify, assess, and recommend software solutions and implementation partners to management.
• Perform cost-benefit and return on investment analyses for proposed systems to aid management in making implementation decisions.
• Participate and sometimes drive IT projects to ensure that system requirements and data engineering needs are addressed throughout the project life cycle.
• Create systems models including integration points, specifications, diagrams, and charts to provide direction to internal stakeholders and third parties.
• Coordinate and perform in-depth tests, including end-user reviews, for modified and new systems.
• Provide orientation and training to end users for all modified and new systems.
Qualifications & Experience
• Minimum Bachelor’s degree in Information Technology, Computer Science, or related field.
• Minimum of 5 years of experience in related fields with 3 to 4 years in systems and/or functional analysis.
• Proven experience in analysing, designing, and implementing information systems.
• Strong understanding of business processes and technical systems.
• Hands-on skills in SQL and databases (e.g. Oracle, SQL Server).
Other Prerequisites
• Excellent problem-solving skills and the ability to work under pressure. • Good project management skills.
• Excellent written and oral communication and interpersonal skills.
• Ability to conduct research into systems issues and products as required.
• Ability to communicate ideas in both technical and user-friendly language.
• Highly self motivated and directed.
• Keen attention to detail.
• Proven analytical and creative problem-solving abilities.
• Strong customer service orientation.
• Experience working in a team-oriented, collaborative environment
Who are we and what do we do?
The Dice platform, one of the most advanced SaaS fintech organizations, helps businesses convert their spending from many fragmented applications, prepaid cards, offline reimbursement/invoice management, procurement, and payment systems to a single spend platform. There will be no more cash, cards, refunds, or offline invoicing since our entire goal is to provide businesses more knowledge and control over how they spend their money, resulting in significant cost savings and profitability. We are a hyper growth startup collaborating with premium Indian enterprises, startups, and industry leaders across disciplines.
Perks in store for you when you join the team:
- You'll be surrounded by passionate team members.
- Your work will have a visible impact.
- You will be working on interesting technical challenges in a fast-paced environment.
Requirements and skills:
- Hands-on Software Development experience.
- 2-4 years of relevant experience in Java development.
- Hands-on experience in designing and developing applications using Java EE platforms.
- Object-Oriented Analysis and design using common design patterns.
- Profound insight of Java and Java EE (Multithreading, Reactive Programming, etc)
- Excellent knowledge of Relational Databases, SQL, and ORM technologies (MySQL, EBean)
- Excellent knowledge in RESTful API development, event-based processing.
- Experience with test-driven development.
- Knowledge of GIT, Linux, Docker, Redis
Responsibilities:
- Designing, implementing, and maintaining Java applications that are often high-volume and low-latency, required for mission-critical systems
- Delivering high availability and performance
- Contributing in all phases of the development lifecycle
- Writing well-designed, efficient, and testable code
- Conducting software analysis, programming, testing, and debugging
- Managing Java and Java EE application development
- Ensuring designs comply with specifications
- Preparing and producing releases of software components
- Transforming requirements into stipulations
- Support continuous improvement
- Investigating alternatives and technologies
Location:
Pune
Your Impact:
• Implements Digital Consumer experiences based on a foundation of SFCC (Salesforce commerce cloud) to meet expected quality standards
• Ensures functional requirements and high-level solution designs are understood and are translated into detailed technical design
• Implement proofs of concept to prove any new technologies, application flows or integration scenarios and identify customizations needed to SFCC platform for meeting client requirements
• Guides the performance tuning and scalability of the ecommerce solution
• Diagnose and solve technical problems during implementation and support phases
Your Skills & Experience:
• 4-8 Years with 2+ years of implementing commerce application on any eCommerce platform in last 3 years
• If you have not worked in eCommerce platform, we can still discuss with you if you are expert in Java/Net and understand REST/SOAP webservices.
• Demonstrate proficiency in build and release management using CI/CD strategies (leveraging tools like Jenkins and DevOps practices), implement Mocha/Chai unit and functional test cases in order to reduce costs while ensuring quality
. Contributes to designing, implementing and documenting the build release process as well as system configuration and deployment characteristics of the applications
• Participates in technical walkthroughs/ code reviews of other team members’ components, test plans and results and help them with gaps
• Collaborate with architect to define implementation processes and quality gates and standards
• Identifies risks and issues, and help monitor them
• Guides the development of reference and resource materials
• Mentors developers in improving their platform knowledge and development skills
• Communicate technical design to the developers and help/guide them in the implementation
• Participates in Agile sprints
Set Yourself Apart With:
• eCommerce platform certification
• Security considerations – OWASP, CSRF, reCAPTCHA etc. – Basic knowledge or experience
• Git Development workflow – Proficient
• Visual Studio Code IDE or Eclipse IDE - Proficient
• Knowledge on Agile methodology and desired tools like Jira, confluence etc.
• Scripting/development experience with Node.js, Mocha/Chai
• Experience working in any Salesforce cloud environment like SFMC, SFSC etc.
• Excellent written, verbal communication and articulation skills & Good team player
• Self-starter and self-learner with keen interest to grow
• Process orientation and the ability to define and setup processes
• Ability to provide necessary coaching to bring team members up to speed on the technology
• Ability to prioritize and manage multiple tasks
• Excellent and innovative approach to problem solving and finding solutions
• Flexible and proactive/self-motivated working style with excellent personal ownership of problem resolution
Strong fundamentals in OOPS, RDBMS, Data structures, and Design patterns
Experience in any SQL database (Preferably SQL Server)
Ability to write clean code
Ability to write automated unit tests using frameworks such as NUnit, Mock, etc.
Ability to communicate and articulate clearly and work collaboratively in an agile team
Experience with code repositories like git
Ability to communicate and articulate clearly and work collaboratively in an agile team
Vah Vah! is an ed-tech company that offers online makeup courses in micro-batches to students across India to learn from the leading teachers in top cities. We provide holistic education with lots of practical training that makes our students job-ready with not just the base skills but also the soft skills for great customer service. Our teachers have more than 15+ years of experience in training makeup and have certified more than 1000+ students. Vah Vah! is founded by executives with extensive experience running consumer business and mobile games at scale (over 100 million players) at Zynga. Vah Vah! is backed by a leading investment firm.
Website Link: https://vahvah.com/
The Mission
Vah Vah teaches professional makeup to budding makeup artists and influencers through live online classes. We have students from Srinagar, all the way to the Andamans. And experienced teachers who have worked in Bridal Makeup, Ramp Shoots, Film and more. We empower our students to join the workforce as fully trained makeup artists. This is the future of vocational education, and you can help build it.
Our Culture
- Amazing workplace and colleagues to work with
- We have the right mixture of creativity, analytics and hustle to move fast in the right direction.
- You will work with colleagues who don’t take themselves too seriously but move mountains.
- See yourself evolving every month with new problems to solve and new skill to master.
- Work with the smartest engineers so you can learn from them.
- Competitive salary at par with the best in the industry
- Great stock options so you can benefit from the company's growth.
- Immense exposure to new technologies
Responsibilities:
- Compile and analyze data, processes, and codes to troubleshoot problems and identify areas for improvement.
- Collaborating with the front-end developers and other team members to establish objectives and design more functional, cohesive codes to enhance the user experience.
- Participating in continuing education and training to remain current on best practices, learn new programming languages, and better assist other team members. Taking lead on projects, as needed.
Requirements:
- Overall experience of 2-5 years in building backend services using languages like NodeJs, Java etc
- Fluency or understanding of specific languages, such as Java, Node.Js, Python, and operating systems may be required.
- Strong understanding of the web development cycle and programming techniques and tools.
- Focus on efficiency, user experience, and process improvement.
- Strong problem solving and verbal and written communication skills.
- Ability to work independently or with a group.
- Sound knowledge on source control and DevOps
What you get:
- Amazing workplace and colleagues to work with
- Competitive salary at par with the best in the industry
- Immense exposure to new technologies
• 3+ years development and delivery experience with Java, Springboot, Micriservices, JPA and from reputable institutes • Solid experience with application frameworks such as Springboot and strong familiarty with micro services architecture and design patterns • Familiarity with databases like MySQL, MongoDB, Redis etc • Hands-on experience in analysis, design, coding, and implementation of complex, custom-built applications • Exposure to CI/CD using Gitlab, Jenkins preferred • Familiarity with Docker, Kubernetes, EFK Stack is preferred • Broad knowledge of web standards relating to APIs (OAuth, SSL etc.) • Exposure to product development is preferred • Understand Architecture Requirements and ensure effective design, development and maintenance of multiple micro services in Java Springboot deployed in cloud within containers consuming data present in relational as well as NoSQL databases. o The microservices shall expose APIs which allow ease of integration with variety of client apps o Microservices should handle a scale of thousands of requests per second • Develop communication patterns between microservices which are efficient, lightweight and secured using Kafka • Debugging issues on a live setup • Lead a small team of engineers • Create test cases and technical documentation • Maintain a high level of code quality and consistency by adhering to and enhancing the coding standards, design methodology and programming practices |
* Understanding of building architecture from product requirements.
* Experience of leading teams of developers to maximise performance.
* Knowledge of Multithreading, Thread Pooling, Background Jobs and Schedule Jobs with supporting tools and libraries.
* Working on Microservices based architecture using spring cloud, distributed application pattern and multiple data source management in the application.
* Working on Linux and Windows based OS and their command line tools.
* Working with unit testing frameworks.
* Object-Oriented development and Metaprogramming.
* Experience in working with the SQL Databases (MySQL or PostgreSQL) and No SQL. Databases (Cassandra or MongoDB).
* Knowledge of server configuration management and deployment techniques. Good to have experience in handling DevOps tools like Jenkins and containerization using Docker.
* Experience in working with different AWS cloud services.
Out of which, an experience of 1 to 2 years in Spring Boot and Microservices is mandatory
Need to have an experience working on Digital Domain or E-Commerce Domain or Travel Domain
Strong experience with Java 8, Spring and Spring Boot, Spring MVC, Spring Data
Working experience on Microservices
Version Control: Git
Strong understanding of functional/reactive programing, OOP, design
Experience on Docker and Kubernetes.
SDLC: Working experience in Agile methodology
Strong written and verbal communication skills
Strong Interpersonal skills and Time Management skills
Immediate Joiners Preferred
Within maximum 30 days notice period can also apply
Currently remote working, however, post pandemic, candidates need to relocate to any of the location given above