SQL Server 2016, MSBI, Power BI

Job Description For Associate Software Developer

 Job Title: Associate Software Developer

Company: Mydbops

Location: Pondicherry

About us:

As a seasoned industry leader for 8 years in open-source database management, we specialize in providing unparalleled solutions and services for MySQL, MariaDB, MongoDB, PostgreSQL, TiDB, Cassandra, and more. At Mydbops, we are committed to providing exceptional service and building lasting relationships with our customers. Our Customer Account Management team is vital in ensuring client satisfaction and loyalty. We are looking for a dedicated and motivated individual to join our team as a  Senior Backend Developer

Responsibilities:

• Collaborate with senior backend developers to gather requirements, understand specifications, and assist in the implementation of features.
• Design and develop efficient, scalable, and reliable software applications using Python and Go.
• Write clean, maintainable, and well-documented code following best practices and coding standards.
• Assist in troubleshooting and debugging issues in existing applications, and contribute to finding and implementing effective solutions.
• Participate in unit testing activities to ensure code quality and stability.
• Collaborate with the DevOps team to deploy and maintain applications in production environments.
• Learn and stay updated with the latest trends and advancements in backend development technologies and practices.
• Contribute to code reviews, providing constructive feedback to enhance code quality and performance.
• Collaborate effectively with cross-functional teams, including product managers, designers and other developers.

Requirements:

• Bachelor's degree in Computer Science, Software Engineering, or a related field.
• Equivalent work experience will also be considered.
• Strong understanding of programming fundamentals and software development principles.
• Knowledge of Python and Go programming languages, with a willingness to learn and grow expertise in both.
• Familiarity with backend frameworks such as Flask or Django (Python) and Gin or Echo(Go).
• Basic understanding of relational databases (e.g., PostgreSQL, MySQL) and NoSQL
• databases (e.g., MongoDB, Redis).
• Familiarity with version control systems, such as Git.
• Solid problem-solving skills and the ability to analyze and debug code issues.
• Excellent communication skills and the ability to collaborate effectively in a team environment.

Preferred Qualifications:

• Experience with frontend technologies such as HTML, CSS, and JavaScript.
• Knowledge of containerization technologies like Docker.
• Understanding of API development and integration principles.
• Familiarity with cloud platforms such as AWS, Azure, or Google Cloud.
• Familiarity with testing frameworks and methodologies.
• Passion for learning and staying updated with the latest advancements in backend
• development.

What We Offer:

• Competitive salary and benefits package.
• Opportunity to work with a dynamic and innovative team.
• Professional growth and development opportunities.
• Collaborative and inclusive work environment.

Job Details:

• Work time: General shift
• Mode of Employment - Work From Office (Pondicherry)
• Experience - 0 to 3 years

Job Summary: We are looking for a skilled SQL Developer to join our team. The ideal candidate will have a strong understanding of database management systems, experience in writing complex SQL queries, and a solid understanding of data structures and algorithms. The SQL Developer will be responsible for designing, developing, and maintaining SQL databases, ensuring their performance, availability, and security.

Key Responsibilities:

• Design, develop, and optimize SQL databases, tables, views, stored procedures, and triggers.
• Develop efficient and complex SQL queries for data extraction, transformation, and loading (ETL).
• Create and maintain database schema designs, data models, and ER diagrams.
• Analyze and optimize complex SQL queries for better performance.
• Implement indexing strategies, query optimization techniques, and other performance tuning practices.
• Ensure data integrity and security by designing and implementing database constraints, data validation rules, and security policies.
• Work with software developers, data analysts, and system administrators to integrate SQL databases with other applications and systems.
• Collaborate with business stakeholders to understand data requirements and provide solutions.
• Document database designs, stored procedures, and other database-related activities.
• Maintain accurate records of database changes, optimizations, and configurations.

Eligibility Criteria:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 3 to 5 years of experience as an SQL Developer or in a similar role.
• Proven experience in database design, development, and management.
• Experience with SQL Server, MySQL, PostgreSQL, or other relational database management systems.
• Proficiency in writing complex SQL queries, stored procedures, functions, and triggers.
• Strong understanding of indexing, query optimization, and performance tuning.
• Familiarity with database security best practices.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration abilities.
• Attention to detail and commitment to quality.
• Ability to work independently and in a team environment.
• Experience with cloud-based databases (e.g., AWS RDS, Azure SQL Database).
• Experience with NoSQL databases.

What We Offer:

·        Competitive salary and performance based incentives.

·        Comprehensive benefits package, including health

·        Opportunities for professional growth and career advancement.

·        A collaborative and innovative work environment.

Around 4 years of experience in creating and implementing Web-based applications using

C#, ASP.net, Web API, MVC, Micro Services, JavaScript and SQL Server.

Familiarity or exposure to CI / CD, Dev Ops such as Dockers, containers, Azure, Pipeline is

highly recommended

Ability to work in an Agile, fast-paced environment, and learn rapidly.

Bachelor degree in computer science, computer engineering or similar.

Familiar with object-oriented development, design patterns and specifically in .NET

Framework (C#) with a strong background in web-based development and service-oriented

Architecture.

Expert in HTML, CSS, JavaScript, JQuery, JSON.

Writing clean, readable, and easily maintainable code.

Must have knowledge of project/task management tools like Jira,

Familiarity with Version Control like Bitbucket, Git etc.

Understanding of UI, cross-browser compatibility and web standards.

Build features and applications with responsive design

Good English communication skills, written and spoken.

Able to work with minimum supervision as well as perform under pressure and meet

Deadlines.

• Manage different versions of complicate code and distribute them to different teams in the organization utilizing TFS.
• Develop an ASP.Net application to input and manage a production schedule, production statistical analysis and trend reporting.
• Create routines for importing data utilizing XML, CSV and comma delimitate files.
• Filter and cleanse OLTP data with complex store procedures and SSIS packages in the staging area.
• Develop a dimensional database and OLAP cube using SSAS for analysis, maintenance and good customer service.
• Involve in development and implementation of SSIS, SSRS and SSAS application solutions for various business units across the organization.
• Extract the data from XML and load it to dimensional model.
• Maintain SQL scripts, indexes, complex queries for data analysis and extraction.
• Create advanced reports like dashboard and scoreboard using SharePoint and power pivot for better presentation of data.
• Create cubes in SSAS reports which require complex calculations such as calculation of the premium for a particular policy.
• Create SharePoint sub sites, lists, libraries, folders and apply site permissions according to the given requirement.
• Work with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements.
• Develop T-SQL functions and store procedures to support complex business requirements.
• Create and configure an OLTP replication database for disaster recovery purpose.
• Designed/Implemented/Maintain OLAP servers and processes to replicate production data to the server.

The ideal candidate will be familiar with the full software design life cycle. They should have experience in designing, coding, testing and consistently managing applications They should be comfortable coding in a number of languages and have an ability to test code in order to maintain high-quality code.

Responsibilities

• Design, code, test and manage various applications
• Collaborate with engineering team and product team to establish best products
• Follow outlined standards of quality related to code and systems
• Develop automated tests and conduct performance tuning

Qualifications

• Bachelor of Science in Information Technology
• 1+ years of experience working with .NET, Asp.net or relevant experiences
• Experience developing web-based applications in Asp.net, Dot net Core, jQuery, HTML5, Rest base API integration
• Understanding DB,PL/SQL, Webform
• Experience working in agile development environment

About theAsianparent : theAsianparent is a reproductive health-tech company that reaches out to 30 million mothers every month through our parenting website and app. Our vision is to improve the overall health of pregnant women, mothers and families in South East Asia by helping them navigate their most important moments with data-driven solutions and information in the form of content, community and physical products.

Headquartered in Singapore, theAsianparent has offices in Vietnam, Indonesia, Malaysia, the Philippines, Thailand, India, Sri Lanka, Hong Kong and Nigeria. Our investors include Fosun, JD.com,Vertex Ventures and others.

Link: https://tickledmedia.com/" target="_blank">https://tickledmedia.com/ / https://sg.theasianparent.com/" target="_blank">https://sg.theasianparent.com/

We are looking for a Backend Engineers with 4+ years of experience to join our team. This is unique opportunity for a driven and insightful Engineer to join the leading growth-stage start up in the most meaningful segment of the economy(parents) in the core market of Singapore. This is a role where careers are made, if you are upto the challenge, and keen to work with world-class teams.

Work Experience : 4 years & above

About the Role :

This role is based in our India Office, reporting to the Head of Development.  

Experience: PHP Developer: 3 - 5 Years

Job Specifications:

• Required (Must Have) skills : Wordpress, Core PHP, OOPS Concept, MySQL, Github
• Desired (Good to have) skills : Linux Command, Basic HTML5 & CSS3, JS/Jquery Ajax, Third-party APIs

Requirements:

1. Must be a self-starter & be able to work with minimum supervision
2. Basic architectural understanding of modern day web applications and enjoy designing a system for speed and scale.
3. Should be able to create a website in HTML, Wordpress, WooCommerce and Laravel (Good to have)
4. Highly Proficient with PHP, MySQL, JQuery, JavaScript, MVC Architecture, OOPs & XSLT
5. Excellent knowledge of PHP frameworks and MVC design patterns
6. Experience of creating database schema
7. Experience with CI/CD tools like jenkins is a plus.
8. Experience with testing and automation frameworks.
9. Good knowledge and experience in AGILE and SCRUM methodologies.
10. Working knowledge of AWS Services, Web Services/REST API etc.
11. Understanding of SEO is plus

What can you expect :

• A fast-paced environment to learn and grow in your career with a market leader with ambitious growth plans.
• Opportunities to learn about and work in different areas of content creation and management and become a well-rounded digital media content professional.
• Dynamic and supportive work culture.
• A passionate team of people working tirelessly to help women across South East Asia and beyond.

• 10 + years of experience and expertise in database and systems architecture design, development and implementation;
• Expertise and experience in data structures, indexing, query, and retrieval;
• Excellent data management skills including ensuring data integrity, data access, security and archiving procedures;
• Knowledge of the language technology and video extraction research domains to be able to converse fluently with the research communities to transform research requirements into concrete formalisms.
• Experience in cross platform development for multiple variants of Unix, Linux including 32 and 64 bit
• Experience with NoSQL, SQL databases, statistics and algorithms
• Strong oral and written communication skills
• Design, implement and test novel database architecture designs to accommodate the multimodal data types used in Client managed technology evaluations
• Administer and monitor database and address data security solutions as applicable
• Design and develop efficient techniques for fast, optimized data access and transfer of distributed or networked database systems
• Design, implement and test novel data structures, data search, query and retrieval solutions to enable access to and processing of the multimodal data types used in Client managed technology evaluations

- 2+ years experience in application support on Asp.Net and SQL

- Should be able to debug production issues and bug fixes

- Should be able to write queries for extracting data using joins

- Interact with stakeholders and provide regular status updates on call logs to on-site and offshore project co-coordinator

- Provide daily status updates and time-sheets to on-site and offshore project

- Ready to work in shifts

- Knowledge Transfer / Training to stakeholders

- Good communication skills

- Highly committed and able to work independently and as a team

- Positive attitude towards learning

- Deadline orientated and escalate in advance in case of delays 

- Contribute towards improving quality, standardization and documentation for all 

changes & Support activity

- Ability to remain calm in a fast-paced and highly pressure environment