Data Base Administrator

Description

Do you dream about code every night? If so, we’d love to talk to you about a new product that we’re making to enable delightful testing experiences at scale for development teams who build modern software solutions.

What You'll Do

 Troubleshooting and analyzing technical issues raised by internal and external users.

 Working with Monitoring tools like Prometheus / Nagios / Zabbix.

 Developing automation in one or more technologies such as Terraform, Ansible, Cloud Formation, Puppet, Chef will be preferred.

 Monitor infrastructure alerts and take proactive action to avoid downtime and customer impacts.

 Working closely with the cross-functional teams to resolve issues.

 Test, build, design, deployment, and ability to maintain continuous integration and continuous delivery process using tools like Jenkins, maven Git, etc.

 Work in close coordination with the development and operations team such that the application is in line with performance according to the customer's expectations.

What you should have

 Bachelor’s or Master’s degree in computer science or any related field.

 3 - 6 years of experience in Linux / Unix, cloud computing techniques.

 Familiar with working on cloud and datacenter for enterprise customers.

 Hands-on experience on Linux / Windows / Mac OS’s and Batch/Apple/Bash scripting.

 Experience with various databases such as MongoDB, PostgreSQL, MySQL, MSSQL.

 Familiar with AWS technologies like EC2, S3, Lambda, IAM, etc.

 Must know how to choose the best tools and technologies which best fit the business needs.

 Experience in developing and maintaining CI/CD processes using tools like Git, GitHub, Jenkins etc.

 Excellent organizational skills to adapt to a constantly changing technical environment

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.

This person MUST have:

• BE Computer Science or equivalent
• Cloud app development experience.
• Strong Troubleshooting and debugging skills
• A strong passion for writing simple, clean, and efficient code.

• 3 years of experience with the Django framework and other backend technologies.
• Knowledge of NodeJS
• Experience with building, modifying, and extending API endpoints (REST or GraphQL) for data retrieval and persistence.
• Understand how to use a database like Postgres (preferred choice), SQLite, MongoDB, MySQL.
• Experience creating high-performance applications.
• Experience with messaging and broker tools - Rabbitmq, MQTT
• Experience with SQL and NoSQL databases
• Experience with the full software development life cycle, including requirements collection, design, implementation, testing, and operational support.
• Knowledge of web services
• Proficient understanding of code versioning tools Git.
• Hands-on experience deploying and managing infrastructure with CloudFormation/Terraform
• Experience managing AWS infrastructure.
• Hands-on experience in Linux environment.
• Basic understanding of Kubernetes/Docker orchestration.
• Manges existing infrastructure/Pipelines/Engineering tools (On-Prem or  AWS) for the engineering team (Build servers/Jenkins nodes etc.)
• Experience with scrum or other agile software development methodology.
• Excellent verbal and written communication, teamwork, decision making and
• influencing skills.
• Handle customer calls/emails regarding technical issues for end-users.
• Strong communication skills
• Attention to detail.

Experience:

• Min 3 year experience

Location:

• Ahmedabad Office Or,
• Work from home

Timings:

• 40 hours a week with a rotational shift every month.

Job Description: 

● At least 4 to 8 years of experience in software quality assurance manual testing 

● Proven record of test strategy and planning, STLC, deployment, defect tracking, and test  harness. 

● High degree of initiative with a passion for learning technology. 

● Must have strong hands-on experience on any programming language PHP, React Native JavaScript, HTML, CSS. 

● Must be competent enough on API testing using Rest Assured and Postman.

● Performance testing experience with relevant automation and monitoring tools (e.g.,  JMeter, load runner). 

● Responsible for coming up with and executing scale tests, performance, and longevity tests.

● Must have testing experience on cloud-based platforms and working knowledge on  integration testing using CI/CD pipelines. 

● Should have working experience with at least one of the MYSQL databases and NoSQL DB viz. 

● Cosmos Db, Cassandra, MongoDB.

● Should have strong fundamental understanding of network topology and the TCP/IP stack  and working knowledge of load balancing methods and deployment architecture

● Experience with GIT Hub, Maven, HP ALM, Jira, Jenkins, code coverage tools and CI/CD
● Exposure of sizing (estimating) the project and defining timelines 

● Good to have knowledge of Platforms like Windows / UNIX / Mainframe.

● Work under the direction of the Game QA Lead to provide test support for two dozen experienced game designers, artists, and engineers. 

● Perform daily smoke tests of game builds, using the build computer and the install scripts.

● Run through and write test plans for existing and new features. Become familiar with the  project design by closely reading project documentation and reaching out regularly to our  team of game developers. 

● Verify that identified bugs are fixed in the database. 

● Identify and bug new issues that occur in the HMD and tablet interface.

● Build on your own fundamental QA skills by learning the specifics of game  development QA for mobile devices, VR headsets, and experimental technology.

● Engage in continuous improvement of the QA process. 

● Maintains quality service by establishing and enforcing organization standards.
● Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of the-art practices; participating in professional societies. 

● Contributes to team effort by accomplishing related results as needed

Security Monitoring and Operations (SIEM)
Security Solutions design and deployment
IDAM - Identity and Access Management Experience
Network Monitoring and Management Experience
VAPT - Vulnerability Assessment and Penetration Assessment
Experience on DLP and Endpoint Security
Knowledge on Encryption 
Experience in performing Maturity Assessment for identifying the security gaps and recommending measures to fix the gaps
Experience in Audit controls and applying security measures (ISO, PCI etc..)
Knowledge in automation and scripting

THE OPPORTUNITY

A platform to learn and grow in a great working environment with cutting edge technologies. There is vast opportunity to showcase creative thinking which can be translated into a highly optimized tools/utilities.

KEY ACTIVITIES

• Code Integrations ( Compile, Build, Notify )
• Package creation ( Service Packs, Patches, Hotfixes )
•  Environment Preparation ( With GOLD SCM technical stack )
•  Environment & Infra management
•  Package delivery ( Customer specific & Standard )
• Build & Deployment automation
• Tickets management

KEY CRITERIA

Primary Technical Skills  

• Shell Scripting
• ORACLE DB Fundamentals
• Infra Monitoring & Diagnostics
• ClearCase / GIT
• DevOps concepts
• Basic Java

Other Required Skills

• Problem Solving
• Logical Reasoning
• Aptitude & Attitude
• Communication (Verbal & Written)