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
- Development of applications in Java including:
- Building data processing platforms.
- Developing micro-service-oriented applications.
- Interact with stakeholders of the applications being developed.
- Must have experience in Java JEE, Spring Framework, and Microservices
- Experience in SQL and JDBC
- Experience in build tools Maven, git
- Good to have experience in Cloud Platforms AWS, Azure is a plus
- 3+ year of experience in Development in JAVA technology.
- Strong Java Basics
- SpringBoot or Spring MVC
- Hands on experience on Relationl Databases (SQL query or Hibernate) + Mongo (JSON parsing)
- Proficient in REST API development
- Messaging Queue (RabitMQ or Kafka)
- Microservices
- Any Caching Mechanism
- Good at problem solving
Good to Have Skills:
- 3+ years of experience in using Java/J2EE tech stacks
- Good understanding of data structures and algorithms.
- Excellent analytical and problem solving skills.
- Ability to work in a fast paced internet start-up environment.
- Experience in technical mentorship/coaching is highly desirable.
- Understanding of AI/ML algorithms is a plus.
Job Description
Title - Lead Snowflake Developer
Location - Chennai/Hyderabad/Bangalore
Role - Fulltime
Notice Period/Availability - Immediate
Years of Experience - 6+
Job Description:
- Overall 6 years of experience in IT/Software development
- Minimum 3 years of experience working with Snowflake.
- Designing, implementing and testing cloud computing solutions using Snowflake technology.
- Creating, monitoring and optimization of ETL/ELT processes.
- Migrating solutions from on-premises to public cloud platforms.
- Experience in SQL language and data warehousing concepts.
- Experience in Cloud technologies: AWS, Azure or GCP.
Technical skills required:
Skills: Java 8 and above, Rest Web services, MySQL.
Strong background in Core Java and good knowledge of collection Framework.
Proficient in developing high-performance, less memory-intensive micro-services applications using the Java framework.
Should have deep knowledge of Micro-service development.
Core Java, SpringBoot, MicroServices |
- DB2 or any RDBMS database application development |
- Linux OS, shell scripting, Batch Processing |
- Troubleshooting Large Scale application |
- Experience in automation and unit test framework is a must |
- AWS Cloud experience desirable |
- Agile Development Experience |
- Complete Development Cycle ( Dev, QA, UAT, Staging) |
- Good Oral and Written Communication Skills |
Job Description:
As a L3 analyst, you will play a key role within the Application Management team, leading services for its customer(s). This service has responsibility for the smooth daily operational running of the Client platform both in the cloud and on-premises. The Client application is business critical and centrally manages data for trading, settlement, risk, client and regulatory reporting systems. As a L3 analyst, you will be responsible for supporting complex infrastructure and application issues raised by L1/L2 support teams, and business analysts. You would also be working on client requests for enhancements, fixes, maintaining custom code, and following the best practices such as Agile, DevOps, etc.
The role is a technical role requiring a good technical knowledge of SQL/PLSQ, Core Java along with good debugging skill while supporting client implementations. You should have basic understanding on Unix system and commands. The ability to troubleshoot issues, assist users and help write specifications is essential. This position also works with product management to improve the software engineering processes and practices associated with continuously building, deploying, and updating software and environments.
- Accountability and primary responsibility/duties:
- A typical day would look like as follows: -
- 40% support issues.
- 40% configuration/development work.
- 20% continuous improvement, automation, CICD, so on.
- Activities would range across the lifecycle from discovery to post-implementation support.
- Understanding client’s requirement, replicate the problem and providing the solution
- Understanding and developing new requirements coming in from BAs (Business Analysts) and customers.
- Update the existing functionality based on client needs.
- Develop changes that cater to enhancing the product and/or fixing production issues
- Prepare product releases of software components. (Java/SQL-PLSQL)
- Contribute in all phases of the development cycle. (development/Deployment/Testing, peer review)
- Create technical document for all changes made.
Required Qualifications/Knowledge/Skills
- Bachelor’s degree in Computer Science or related field
- Strong basics and working experience in following technologies: -
- Core Java.
- SQL / PLSQL coding.
- Object Oriented Programming concepts and data structures.
- Working knowledge on Unix platform
- Working knowledge on XSLT and XML handling
- Basic understanding App & web server working knowledge (JBOSS, WebLogic and WebSphere) and debugging skills.
- Advantageous to have:
- Working understanding on CICD, Dev-ops technologies.
- Queuing technologies including Kafka, MQ, Solace.
- Scripting including Python, Unix, java.
- Hands on knowledge of Dev ops processes and tools Good interpersonal and communication skills.
The ideal candidate is a self-motivated, multi-tasker, and demonstrated team-player. You will be a lead developer responsible for the development of new software products and enhancements to existing products. You should excel in working with large-scale applications and frameworks and have outstanding communication and aleadership skills.
Responsibilities
- Writing clean, high-quality, high-performance, maintainable code
- Develop and support software including applications, database integration, interfaces, and new functionality enhancements
- Coordinate cross-functionally to insure project meets business objectives and compliance standards
- Support test and deployment of new products and features
- Participate in code reviews
Qualifications
- 5+ years of relevant work experience
- Mandatory experience in building scalable microservices on nodejs platforms
- Expertise in Object Oriented Design, Database Design, Service architecture
- Experience with Agile or Scrum software development methodologies
- Ability to multi-task, organize, and prioritize work
• Build out our web architecture allowing new feature modules to be sent to production, while having
strategic foresight on long term product vision.
• Software development project management from transforming requirements into technical specifications,
design, code, and tested systems.
• Closely involved in development life cycle right from concept stage to delivery and post- launch support.
• Keep abreast of new trends and best practices in web development and explore new technologies.
• Document the development process, architecture, and standard components.
• Coordinate with co-developers and actively participate in code reviews , bug fixing code /architecture.
• Brainstorm and solve problems and put effort in constant improvement in technical front .
• Perform frequent peer reviews.
• Participate actively in demos / S&T.
• Share knowledge through collaboration, training, peer review, presentations, and articles.
• Track record of delivering in Scrum, Agile and other methodologies.
• Proficiency in establishing processes and tools to enable team productivity when developing websites
(version control, automatic build, code review).
• Strong verbal and written communication skills and cognitive ability.
• Contribute towards a positive healthy fun and creativity driven culture.
Must Have:
• Strong aptitude towards problem solving with a hacker mindset.
• Should have infinite love towards Linux and respect open-source development.
• Should have sound knowledge of core PHP, MVC Frameworks Laravel preferred.
• Familiarity with limitations of PHP as a platform and its workarounds.
• Should be excellent in SQL/NoSql database (Surprise us we are constantly pushing out DB architecture).
• Basic Knowledge of Frontend Technologies to easily communicate in terms of Front end Lingos.
• Experience with Agile development methodologies.
• Experience in building high secure components, encryption techniques.
• Experience in building event based and queue based Infrastructure.
• Experience with multi-tier system and service design and development for large scale systems.
• Extensive, real-world experience designing technology components for enterprise solutions and defining
solution architectures and reference architectures with a focus on cloud technologies.
• Passion for best design and coding practices and a desire to develop new bold kickass ideas.
• Experience with caching and scaling techniques.
• Experience with cloud infrastructure is must AWS/GCP/DO.
• Good to have experience with any tool such as Jenkins, Gitlab Devops building pipelines, CI/CD automation.
• Eager to learn new languages and experiment / explore new technologies.
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.