Appian (Junior & Senior)

• Job Description:

MySQL Database Administrator (DBA) who will be responsible for ensuring the

Performance, Database Tuning, Database Cleanup, Database Migration, Database Availability, and Security of Clusters of MySQL

Instances. The candidate will also be responsible for Orchestrating Upgrades,

Backups, and Provisioning of Database Instances. The candidate will also work in

tandem with the other teams, documentation, and specifications as required.

.

• Key Responsibilities:

✓ Provision MySQL instances, both in Clustered and Non-Clustered Configurations

✓ Ensuring the Performance, Database Tuning, Database Availability, and Security

of Clusters of MySQL Instances

✓ Development of Database Schema

✓ Development of ERD

✓ Find the Root Cause of Database related issues & Database Clean-up

✓ Migrating Data from Customer Database to Serosoft Product Database

✓ Prepare Documentation and Specifications

✓ Handle common database procedures, such as upgrade, backup, recovery,

migration, etc.

✓ Profile server resource usage, optimize and tweak as necessary

✓ Collaborate with other team members and stakeholders

• Skills and Qualifications:

✓ Strong proficiency in MySQL database management

✓ Decent experience with recent versions of MySQL

✓ Understanding of MySQL’s underlying storage engines, such as InnoDB and

MyISAM

✓ Experience with replication configuration in MySQL

✓ Proficient in Database Clean-up and Migrations

✓ Knowledge of De-Facto Standards and Best Practices in MySQL

✓ Proficient in Writing and Optimizing SQL statements

✓ Proficient in Table Scan, Row Scan, Query Execution Plan, SQL Profiler, etc.

✓ Should be able to decide when to create Views (Standard Views, Indexed views,

and Partitioned views)

✓ Knowledge of MySQL features, such as its Event Scheduler

✓ Ability to plan Resource requirements from High-Level Specifications

✓ Familiarity with other SQL/NoSQL databases such as PostgreSQL, MongoDB, etc.

✓ Knowledge of limitations in MySQL and their workarounds in contrast to other

popular relational databases

✓ Proficient understanding of code versioning tools such as SVN / Git

✓ DBA Certification would be added advantage

MySQL Database Developer

Strong development knowledge in DB Design & development with 6+ Years’ to 10 Years experience (MySQL DB) – Mandatory

Strong hands on writing complex PGSQL, procedure and Functions & prevent blocking and Deadlocks

Conduct SQL objects code review & Performance tuning(Mandatory)

having hands on Microsoft SQL and Postgres DB is anadvantage.

Strong knowledge in RDBMS and NoSQL Concept with strong logical thinking and solutions

Expert in transaction databases (OLTP) and ACID property with handling large scale application databases

· Perl as a Developer.

· Python

· Strong knowledge of MS SQL Server (or any database like Sybase/Oracle/MySQL etc),

· Good understanding of RHEL Linux,

· Good understanding and hands-on with HTML and web technologies.

Secondary Skills (Good to have)

DevOps, Ansible, Git/S

ApnaComplex is one of India’s largest and fastest-growing PropTech disruptors within the Society & Apartment Management business.  The SaaS based B2C platform is headquartered out of India’s tech start-up hub, Bangalore, with branches in 6 other cities. It currently empowers 3,600 Societies, managing over 6 Lakh Households in over 80 Indian cities to effortless manage all aspects of running large complexes seamlessly.

If it excites you to - drive innovation, create industry-first solutions, build new capabilities ground-up, and work with multiple new technologies, ApnaComplex is the place for you.

The primary responsibility of this role is to handle technical requests filed by the end users of the product, handle troubleshooting and resolve errors.

Key job responsibilities

• Troubleshoot Issues
• When technical issues with the product arise, production support engineers must act quickly to analyze the available data and find the root cause of the problem. They may then develop a solution themselves or pass the problem on to other engineering team members, all the while providing users with progress updates.
• Contribute to Product Development
• Production support engineers participate in all stages of the product development process, including designing, building, and testing. They also create useful tools such as internal software to automate key processes or platforms where customers can send inquiries and reviews.
• Assist Users
• This role entails interacting with product users, often external customers but sometimes also employees. These interactions can occur in various setups, including in-person meetings, phone calls, emails, and live messaging chats. In all of these cases, it’s vital to address concerns promptly and maintain a helpful attitude.
• Prepare Technical Documentation
• Production support engineers prepare extensive documentation when logging product issues, as they must note all details, including their observations, diagnoses, and action steps. Other common tasks include weekly reports summarizing production performance, release notes for upgrades, and troubleshooting guides.
• Suggest Improvements
• Because production support engineers deal with product issues first-hand, they can readily suggest overall product improvements, such as features that customers want. Ideally, they should also proactively evaluate engineering processes and provide recommendations to increase efficiency

Basic Skills & Qualifications

• 1-5 years of relevant experience.
• Should be familiar with Database tools (such as excel or MySQL)
• Should be familiar with Industry-specific tools (such as programming languages)
• Should be familiar with Customer support software (such as Zoho Desk, Zendesk, or LiveAgent)

Skills that will help you build a success story with us

• Problem Solving skills.
• Technical expertise
• Customer Service
• Attention to detail
• Multitasking

Locations: Bangalore 

Quick Glances:

• https://www.apnacomplex.com/why-apnacomplex">What to look for at ApnaComplex
• https://www.linkedin.com/company/1070467/admin/">Who are we A glimpse of ApnaComplex, know us better
• https://www.apnacomplex.com/media-buzz">ApnaComplex - Media – Visit our media page  

ANAROCK Ethos - Values Over Value:

Our assurance of consistent ethical dealing with clients and partners reflects our motto - Values Over Value.

We value diversity within ANAROCK Group and are committed to offering equal opportunities in employment. We do not discriminate against any team member or applicant for employment based on nationality, race, color, religion, caste, gender identity / expression, sexual orientation, disability, social origin and status, indigenous status, political opinion, age, marital status or any other personal characteristics or status. ANAROCK Group values all talent and will do its utmost to hire, nurture and grow them.

• Job Title:- Microsoft Tech Lead
• Location:- CG Road, Ahmedabad(Mobile and flexible), WFH is available, sometime you have to come attend business meetings
• Education:- No bar in Education
• Desired Skills:- ASP.Net, C#, Database Design, MySQL, MSSQL, Bootstrap, SQL Server
• Experience: - 05 yrs. to 06 yrs.
• Number of Vacancy:- 01
• Job Timing:- Flexible Time
• Interview Process: - 2 round, First round is Telephonic, Second round is face to face only.

Job Description

Responsibilities:-

• Plan, lead and deliver the software development cycle.
• Lead technical team and solve their day to day issues.
• The successful candidate would lead a team of 6-10 developers.
• Handle ongoing projects as well as new projects.
• Guide or mentor new team members and existing members.

Skills Requirement

• Experience in Microsoft ASP, C#, SQL server, MS SQL, Bootstrap, database design and github.

Who can Apply

• Education : No bar
• Experience : Good to have: BFSI domain and professional certification

POSITION SUMMARY

Essential Skills & Key Responsibilities

• Expertise in P2P domain which includes Procurement and Account Payables and Fusion
• P2P functional implementation experience including Interfaces & RICE objects with other legacy applications.
• Leading the business analysis capability in the procurement space, building excellent business connect, influencing and negotiating between tech and business.
• Capture & clarification of business requirements through a range of analysis techniques for the Business (data flow diagrams, case tool analysis, gap analysis and work & process flow diagrams)
• Function as a techno-functional resource and assist in designing solutions for business
• Understand the business data in depth, analyse key performance indicators and use the same to analyse the requirements further
• Obtaining agreement on business analysis deliverables and ensuring that they meet all the requirements of the business
• Proactively working with business to identify, define, and clarify the scope / issues in terms of complex business/systems requirements.
• Identify options for potential solutions and assessing them for both technical and business suitability/feasibility
• Working with business to capture & clarify business requirements & support business & technology teams in data analysis, in UAT phase etc.
• Acting as a proxy customer with the development teams, facilitating open communication between the customer & development team
• Driving user acceptance criteria with the customer
• Aware of the AGILE terminologies and should have knowledge of AGILE tools like JIRA, Confluence etc.
• Basic knowledge of PL/SQL for data querying & analysis will be an added advantage.
• Exposure to MS Office products like Visio and Excel

Product Support Engineer (L1 Support) – Immediate Requirement.

Key skills

• 1-3 years exp in Product Support Role.
• Need to Understand the product and features, to demonstrate the end users.
• Sound knowledge on Java and SQL
• Need to Analyze and Resolve the Product specific queries, MySQL.
• Consistently Deliver the customer requirements.
• Engage with Development team and manage the progress of cases.
• Should be able to cope up with high pressure work environment.
• Work model will be 24X7.

Must require

• Good Communication both verbal and written
• Analytical skills
• Team player
• Preferred male applicants only