
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
Job Title : Golang Developer
Experience : 3+ Years
Location : Pune, Maharashtra (On-site)
Employment Type : Full-Time
Role Overview :
We are looking for a passionate and skilled Golang Developer with strong computer science fundamentals and hands-on development experience. The ideal candidate should be a logical thinker, self-motivated problem solver, and eager learner who enjoys building scalable and high-performance applications.
Mandatory Skills : Strong hands-on experience in Golang, RESTful API development, PostgreSQL/MySQL, Git version control, and solid problem-solving with computer science fundamentals.
Key Responsibilities :
- Develop, maintain, and enhance backend applications using Golang.
- Write clean, scalable, and efficient code following best coding practices.
- Design and implement RESTful web services.
- Collaborate with cross-functional teams including Product, UX, and QA to deliver quality software on time.
- Take end-to-end ownership and accountability of assigned tasks.
- Contribute to performance optimization and application scalability.
Required Skills :
- Strong hands-on experience in Golang and related frameworks.
- Good understanding of RESTful API development.
- Experience working with RDBMS such as PostgreSQL/MySQL.
- Strong problem-solving skills and solid computer science fundamentals.
- Experience with Git version control.
- Excellent communication skills.
Good to Have :
- Basic knowledge of HTML, CSS, and any JavaScript framework.
- Exposure to Non-relational databases.
- Participation or credentials on platforms like HackerRank/HackerEarth.
- Understanding of end-to-end web application development.
We’re hiring a remote, contract-based Backend & Infrastructure Engineer who can build and run production systems end-to-end.
You will build and scale high-throughput backend services in Golang and Python, operate ClickHouse-powered analytics at scale, manage Linux servers for maximum uptime, scalability, and reliability, and drive cost efficiency as a core engineering discipline across the entire stack.
What You Will Do:
Backend Development (Golang & Python)
- Design and maintain high-throughput RESTful/gRPC APIs — primarily Golang, Python for tooling and supporting services
- Architect for horizontal scalability, fault tolerance, and low-latency at scale
- Implement caching (Redis/Memcached), rate limiting, efficient serialization, and CI/CD pipelines
Scalable Architecture & System Design
- Design and evolve distributed, resilient backend architecture that scales without proportional cost increase
- Make deliberate trade-offs (CAP, cost vs. performance) and design multi-region HA with automated failover
ClickHouse & Analytical Data Infrastructure
- Deploy, tune, and operate ClickHouse clusters for real-time analytics and high-cardinality OLAP workloads
- Design optimal table engines, partition strategies, materialized views, and query patterns
- Manage cluster scaling, replication, schema migrations, and upstream/downstream integrations
Cost Efficiency & Cost Optimization
- Own cost optimization end-to-end: right-sizing, reserved/spot capacity, storage tiering, query optimization, compression, batching
- Build cost dashboards, budgets, and alerts; drive a culture of cost-aware engineering
Linux Server Management & Infrastructure
- Administer and harden Linux servers (Ubuntu, Debian, CentOS/RHEL) — patching, security, SSH, firewalls
- Manage VPS/bare-metal provisioning, capacity planning, and containerized workloads (Docker, Kubernetes/Nomad)
- Implement Infrastructure-as-Code (Terraform/Pulumi); optionally manage AWS/GCP as needed
Data, Storage & Scheduling
- Optimize SQL schemas and queries (PostgreSQL, MySQL); manage data archival, cold storage, and lifecycle policies
- Build and maintain cron jobs, scheduled tasks, and batch processing systems
Uptime, Reliability & Observability
- Own system uptime: zero-downtime deployments, health checks, self-healing infra, SLOs/SLIs
- Build observability stacks (Prometheus, Grafana, Datadog, OpenTelemetry); structured logging, distributed tracing, alerting
- Drive incident response, root cause analysis, and post-mortems
Required Qualifications:
Must-Have (Critical)
- Deep proficiency in Golang (primary) and Python
- Proven ability to design and build scalable, distributed architectures
- Production experience deploying and operating ClickHouse at scale
- Track record of driving measurable cost efficiency and cost optimization
- 5+ years in backend engineering and infrastructure roles
Also Required
- Strong Linux server administration (Ubuntu, Debian, CentOS/RHEL) — comfortable living in the terminal
- Proven uptime and reliability track record across production infrastructure
- Strong SQL (PostgreSQL, MySQL); experience with high-throughput APIs (10K+ RPS)
- VPS/bare-metal provisioning, Docker, Kubernetes/Nomad, IaC (Terraform/Pulumi)
- Observability tooling (Prometheus, Grafana, Datadog, OpenTelemetry)
- Cron jobs, batch processing, data archival, cold storage management
- Networking fundamentals (DNS, TCP/IP, load balancing, TLS)
Nice to Have
- AWS, GCP, or other major cloud provider experience
- Message queues / event streaming (Kafka, RabbitMQ, SQS/SNS)
- Data pipelines (Airflow, dbt); FinOps practices
- Open-source contributions; compliance background (SOC 2, HIPAA, GDPR)
What We Offer
- Remote, contractual role
- Flexible time zones (overlap for standups + incident coverage)
- Competitive contract compensation + equity
- Long-term engagement opportunity based on performance
JOB DESCRIPTION:
Location: Pune, Mumbai, Bangalore
Mode of Work : 3 days from Office
* Python : Strong expertise in data workflows and automation
* Pandas: For detailed data analysis and validation
* SQL: Querying and performing operations on Delta tables
* AWS Cloud: Compute and storage services
* OOPS concepts
We are hiring for ASP. NET MVC/Core Developer.
Join Us from Anywhere in India!
Experience Range: 1-3 years
Role and Qualifications:
- Essential: Proficiency in ASP. NET MVC & ASP. NET Core, with a minimum of 1 year of hands-on experience
- Familiarity with. NET framework versions starting from. NET 4.5 and onwards
- Strong grasp of C#, JavaScript, TSQL, HTML, ASP. NET MVC, ASP. NET Core, ASP. NET Web API, and MSSQL
- Effective verbal and written communication skills
- Even candidates with foundational knowledge are encouraged, including freshers
What We Offer:
- Competitive salary increments based on your current CTC
- Additional referral bonuses
- Collaborative and supportive work environment
- Embrace remote work options
- Engage with cutting-edge technologies
- Salary commensurate with qualifications - no limitations for the right candidate
- Flexible work timings to accommodate project needs
- Performance-based bonuses
If you're an ASP. NET developer ready to contribute your skills within a dynamic environment, we're excited to welcome you, regardless of where you're located. Your expertise will be valued as we navigate the latest technologies and celebrate a culture of excellence.
Feel free to reach out and explore this opportunity further!
We are Hiring ASP.NET MVC/Core Developers
Click Here to Apply : https://prishusoft.com/jobs/junior-aspnet-mvccore-professional
Experience Level
- 1–2 years of professional experience in web application development using ASP.NET MVC and ASP.NET Core.
Key Responsibilities
- Develop, maintain, and enhance web applications using ASP.NET MVC and ASP.NET Core.
- Write clean, scalable, and maintainable code following best practices.
- Design, develop, and integrate RESTful APIs with ASP.NET Web API.
- Collaborate with front-end developers and UI/UX designers to deliver exceptional user experiences.
- Work with MSSQL databases, including writing complex T-SQL queries, stored procedures, and optimizing performance.
- Participate in code reviews and contribute to technical discussions, architecture decisions, and performance improvements.
Technical Skills & Expertise
- Strong proficiency in ASP.NET MVC with at least 1 years of project experience.
- Good working knowledge of ASP.NET Core for modern application development.
- Solid skills in C#, JavaScript, and HTML.
- Experience with .NET Framework 4.5+.
- Hands-on experience with ASP.NET Web API development and consumption.
- Expertise in MSSQL (T-SQL, indexing, performance tuning).
Soft Skills
- Strong verbal and written communication skills.
- Collaborative team player with a willingness to share knowledge and contribute to team success.
Preferred / Bonus Skills
- Experience with Angular, React, or Vue.js for dynamic front-end development.
- Exposure to unit testing frameworks (e.g., Jasmine, Karma) for front-end applications.
- Understanding of DevOps practices and CI/CD pipelines.
- Familiarity with TypeScript for scalable JavaScript development.
Work Mode: Full-time On-site / Hybrid (Ahmedabad)
Top Skills:
You write high-quality, maintainable, and robust code, often in Java/C#/Python/C++/Go/Ruby on Rails.
You recognize and adopt best practices in software engineering: design, testing, version control, documentation, build, deployment, and operations.
You have experience building scalable software systems that are high-performance, highly-available, highly transactional, low latency and massively distributed.
Roles & Responsibilities:
You solve problems at their root, stepping back to understand the broader context.
You develop pragmatic solutions and build flexible systems that balance engineering complexity and timely delivery, creating business impact.
You understand a broad range of data structures and algorithms and apply them to deliver high-performing applications.
You recognize and use design patterns to solve business problems.
You understand how operating systems work, perform and scale.
You continually align your work with Amazon’s business objectives and seek to deliver business value.
You collaborate to ensure that decisions are based on the merit of the proposal, not the proposer.
You proactively support knowledge-sharing and build good working relationships within the team and with others in Amazon.
You communicate clearly with your team and with other groups and listen effectively.
Skills & Experience:
Bachelors or Masters in Computer Science or relevant technical field with 3+ years of experience in Design and Development
Experience in software development and full product life-cycle.
Excellent programming skills in any object-oriented programming languages - preferably Java, C/C++/C#, Perl, Python, or Ruby.
Strong knowledge of data structures, algorithms, and designing for performance, scalability, and availability.
Proficiency in SQL and data modeling.
Location: Hyderabad/Bangalore
CTC - no bar
- Set up, manage, automate and deploy AI models in development and production infrastructure.
- Orchestrate life cycle management of AI Models
- Create APIs and help business customers put results of the AI models into operations
- Develop MVP ML learning models and prototype applications applying known AI models and verify the problem/solution fit
- Validate the AI Models
- Make model performant (time and space) based on the business needs
- Perform statistical analysis and fine-tuning using test results
- Train and retrain systems when necessary
- Extend existing ML libraries and frameworks
- Processing, cleansing, and verifying the integrity of data used for analysis
- Ensuring that algorithms generate accurate user recommendations/insights/outputs
- Keep abreast with the latest AI tools relevant to our business domain
- Bachelor’s or master's degree in Computer Science, Statistics or related field
- A Master’s degree in data analytics, or similar will be advantageous.
- 3 - 5 years of relevant experience in deploying AI models to production
- Understanding of data structures, data modeling, and software architecture
- Good knowledge of math, probability, statistics, and algorithms
- Ability to write robust code in Python/ R
- Proficiency in using query languages, such as SQL
- Familiarity with machine learning frameworks such as PyTorch, Tensorflow and libraries such as scikit-learn
- Worked with well know machine learning models ( SVM, clustering techniques, forecasting models, Random Forest, etc.)
- Having knowledge in CI/CD for the building and hosting the solutions
- We don’t expect you to be an expert or an AI researcher, but you must be able to take existing models and best practices and adapt them to our environment.
- Adherence to compliance procedures in accordance with regulatory standards, requirements, and policies.
- Ability to work effectively and independently in a fast-paced agile environment with tight deadlines
- A flexible, pragmatic, and collaborative team player with an innate ability to engage with data architects, analysts, and scientists.
- Hands-on programmer with ability to write idiomatic code in Java
- Strong preference to write automated unit & integration tests
- Prior experience in designing & deploying Microservices and performant REST APIs
- Good understanding of and experience in Continuous Integration / Continuous Delivery
- Hand-on experience using one of the server-side Java frameworks such as Spring Boot
- Excellent communication skills
Nice to have
- Experience working with AWS or other Cloud providers
- Experience working in Event-Driven systems (using Apache Kafka or something similar)
- Exposure to Angular or React









