



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
About
Connect with the team
Similar jobs
Your responsibilities will include:
Designing, implementing and maintaining Java-based applications
Contributing in all phases of the development lifecycle
Writing testable, scalable and efficient code
Test and debug new applications and updates
Maintain up to date code documentation
Participating in code reviews
Key Requirement:
- You have prior experience in Core Java.
- Strong knowledge of Java Application Frameworks
- Hands-on experience working in SQL


We are looking Python intern/developer role. We are looking for candidates who are strong in core Python skills, able to work independently, and strong in developing logic.



RESPONSIBILITIES:
- Help your engineers grow their skills and experience
- Conduct code reviews, and make technical contributions to product architecture as well as get involved in solving bugs and delivering small features
- Hold regular 1:1's with all members of the team, give regular and clear feedback around the individual's performance
- Foster technical decision-making on the team, but make final decisions when necessary
- Provide oversight and leadership to a team of developers to ensure timely execution of team and project deliverables
- Maintain up-to-date skills in software development technologies and a broad understanding of the business, business needs, and how applications/assets drive and support the business
REQUIREMENTS:
- 6+ years of experience in software development and 1+ in team management.
- In-depth technical experience in at least one of the core languages, frameworks, or technologies used in backend development.
- Ability to mentor junior software developers, as well as to collaborate with all stakeholders.
- Extensive experience in developing, deploying, and integrating software solutions.
- Proficiency in documenting processes and monitoring performance metrics.
- Knowledge of best practices related to design principles, API development and software architecture.
- Ability to keep up with software industry trends and innovation.
- Exceptional interpersonal and communication skills.


- 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
As an SDE - III/IV (Backend), you will solve real-life complex problems and create compelling experiences for our users. In this role, you will ensure that the solutions and processes that we create are of the highest quality. And in doing so, you will champion a seamless app experience for all our users.
If you are confident about solving hard, interesting and UNIQUE problems, and creating an impact within an entrepreneurial environment, then you might just be our next SDE - III (Backend).
What will you do
- Collaborate with teams to develop and support the smooth 24x7 operation of our service.
- Create prototypes and proofs-of-concept for iterative development.
- Stay updated with emerging tech cultures and implement them in production systems.
- Develop scalable, long-term strategies to aid the company’s 10X growth.
- Ensure content quality and consistency of the brand.
- Reduce technical debt with quality coding
What you will need
- BTech degree in computer science or related field.
- 4-10 years of relevant work experience.
- Strong knowledge of any of the databases like MySQL, NoSQL, SQL Server, Oracle, PostgreSQL.
- Experience in Java and web technologies.
- Experience in scripting languages like Python, PHP, etc.
- Hands-on experience with systems that are asynchronous, RESTful and demand concurrency.
- Knowledge of best software engineering practices for all stages of software development life cycle

We are looking for a can do it attitude, and the ability to deliver with high velocity and high-quality at the same time. You must have experience developing and designing amazing UI screens.
This person MUST have:
- BE Computer Science, MCA or equivalent
- Cloud app development experience
- Strong ReactJS experience
- Strong experience in Next JS and Typescript
- Understanding of APIs, pagination, searching, sorting
- Creating high performance UI etc.
- Troubleshooting/debugging experience
- Experience with SQL and NOSQL databases
- Strong communication skills
Experience:
- Min 3 year experience
- Not more than 7 year experience.
- Startup experience is a must.
Location
- Remotely, anywhere in India
Timings:
- 40 hours a week but with 4 hours a day overlapping with client timezone. Typically clients are in California PST Timezone.
Position:
- Full time/Direct
- We have great benefits such as PF, medical insurance, 12 annual company holidays, 12 PTO leaves per year, annual increments, Diwali bonus, spot bonuses and other incentives etc.
- We dont believe in locking in people with large notice periods. You will stay here because you love the company. We have only a 15 days notice period.
Responsibilities :
- Developer responsibilities include, but are not limited to the following:
- Experience as a Sun Certified Java Developer with proven hands-on Software Development experience. We use Java 8
- 4-10 years java development experience with JSE/JEE, Java-based Micro-services framework, and implementation, Spring framework, Hibernate framework, SQL, etc
- Hands-on experience on Spring boot & SPARK Microservices and OSGi specifications
- Strong knowledge of micro-service logging, monitoring, debugging, and testing
- Implementations experience of micro-service integration, packaging, building automation, and deployment
- At least two years experience in SOA & Microservices based process applications using BPM (Activiti/JBPM/Camunda)
- Object-Oriented Analysis and design using common design patterns.
- Insight of Java and JEE internals (Classloading, Memory Management, Transaction management, etc)
- Excellent knowledge of Relational Databases, SQL, and ORM technologies (JPA2, Hibernate)
- Experience in developing web applications using at least one popular web framework (JSF, Wicket, GWT, Spring MVC, Spring Boot)
Qualifications: BS/MS degree in Computer Science, Engineering or a related subject and a minimum of 8 years of professional work experience in a mid-d or large corporate Information Technology environment. Highly organized and detail-oriented, with the ability to keep multiple projects and client engagements active at once. Comfort with ambiguity and ability to navigate uncertainty.
- Developing and installing software solutions.
- Designing, implementing and delivering high-quality Software projects in JAVA, SQL / Oracle, J2EE and other JAVA technologies.
- Participate in detailed level in design, coding, code walk-through, peer code reviews and unit testing, System Testing, UAT, Demos, POCs, installation, maintenance of Software modules.
- Software prototype.
- System Architecture.
- Software Design Document.
- User interfaces to be developed as per UX guidelines Code files ensuring coding guidelines followed.
- Code review artifacts during peer code review.
- Test plan and Test Cases.
- Installation/Deployment document Release Document.
- Technical Documentation

Requirement:-
1. Strong PHP Core programming expertise
2. MySQL DB Model Design and Programming expertise
3. Strong skills in either Joomla or WordPress - at least one is needed.
4. Working know how of HTML 5/ CSS 3
5. Knowledge of SVN or any other version control tools
6. Must have solid REST/API implementation and integration concepts.
Preferred addons :-
1. Good to have Frontend Skills in - Javascript/JQuery/Bootstrap/Angular
2. Experience in common third-party social APIs (google, Facebook, eBay etc)
3. Experience with Payment Gateway integration with APIs like (paypal, payza, authorise.net, Firstdata, Ipayout, Stripe etc)
4. Any experience in Ionic / PhoneGap is a plus
Benefits
1. 6 months of probation period.
2. Working Days: Monday-Friday (As per International Standards).
3. Working Timings: 9 hours per day including break of 1 hour
4. Opportunities to learn and grow.

- Building reusable code and libraries for future use
- Participating in all phases of the development and maintenance lifecycle, focusing on speed and efficiency
- Planning and implementing model data structures for scalability
- Working on the maintenance or enhancement of existing data structures
- Designing REST APIs which will be used by multiple clients
What you need to have:
- B.E./ B.Tech/ MCA
- Have experience of building large scale & complex systems with low latency and high availability.
- Have strong experience of working with design patterns & REST APIs.
- Have strong experience of working with Go routines.
- Knowledge of static code analysis tools.
- Must have strong experience with Build and Release management, Agile processes and Estimations.
- Strong understanding of implementing server-side code and designing the data architecture using modern web frameworks.
- Strong understanding of designing database schema.
- Should know about micro-services.
- Writing highly optimised code on server.
- Should be a fast learner and go-getter without any fear of failing.
- Willingness to learn new technologies.
- Experience with popular Golang frameworks like Revel.
- Know how of HTML / PHP.

