Database Administrator

As a Database Administrator, you will be responsible for designing, securing, and maintaining database systems, including schema design, performance monitoring, and data integrity. Key duties involve managing user access, ensuring regular backups, and planning for future growth. The role requires at least 5 years of experience with MySQL, MongoDB, and PostgreSQL, proficiency in Python, Bash, SQL, and automation tools like Ansible or Puppet, along with expertise in database security and monitoring tools.

Must Have

• Design and manage database schema.
• Ensure database security and data protection.
• Monitor and optimize database performance.
• Implement backup and recovery procedures.
• Ensure data accuracy and consistency.
• Plan for database growth.
• Perform regular database maintenance.
• Manage user accounts and permissions.
• Resolve database system issues.
• 5+ years experience in Database Administration.
• Expertise in MySQL, MongoDB, PostgreSQL.
• Proficiency in Python, Bash, SQL.
• Experience with Ansible or Puppet.
• Knowledge of database replication and high availability.
• Familiarity with Nagios, Zabbix, or Prometheus.
• Database security and GDPR compliance.
• Excellent communication and teamwork skills.

Perks & Benefits

• Professional Development (training sessions & meet-ups)
• Flexible Working Hours
• Regular Chit Chat Sessions (events, snacks, drinks, games, talent shows)
• Comfortable Working Environment (open office, laptops, freedom to work from anywhere, gaming area)
• Healthcare (compulsory medical insurance, paid sick leaves)
• Appreciations & Certifications (gift vouchers, certificates for top-performers)

Job Responsibilities

• Designing the database schema, tables, relationships, and other structural components of the database.
• Ensuring that the database is secure from unauthorized access, and that sensitive data is protected from theft, hacking, or other security breaches.
• Monitoring database performance, identifying and resolving bottlenecks or other issues that may impact performance.
• Ensuring that the database is regularly backed up and that recovery procedures are in place in the event of a disaster or system failure.
• Ensuring that the data stored in the database is accurate and consistent, and that any errors or inconsistencies are identified and corrected.
• Providing data exports, reports for customer/operational support
• Anticipating future growth of the database system and plan for increased storage capacity, processing power, and other resources as needed.
• Performing regular maintenance tasks, such as database optimization, indexing, and archiving.
• Managing user accounts, permissions, and access rights to the database.
• Identifying and resolving any issues that arise with the database system, including system crashes, data corruption, and other problems.

Requisite Qualifications

• At least 5 years experience in Database Administration.
• Extensive experience in database administration for MySQL, MongoDB, and PostgreSQL, including architecture, schema design, query optimization, and maintenance.
• Proficient in Python, Bash, SQL, and automation frameworks like Ansible or Puppet.
• Experience in configuring and managing replication, high availability, backup, and recovery for MySQL, MongoDB, and PostgreSQL databases.
• Identify and resolve performance issues, optimize databases for maximum performance and scalability.
• Automating database deployments, managing versions, and deploying changes in a scalable and consistent manner.
• Experience with monitoring tools like Nagios, Zabbix, or Prometheus and setting up alert mechanisms for database performance, replication, and critical metrics.
• Database security expertise, including user access controls, encryption, and GDPR compliance.
• Excellent communication skills and ability to work collaboratively with cross-functional teams, including developers, operations, and security teams.

What Do We Offer?

Professional Development

We invest in the professional growth of each & every individual, integrating training sessions & meet-ups into regular work days so you can apply new skills & knowledge to your work immediately.

Flexible Working Hours

We offer significant flexibility with our office timings so you get to tailor your working hours on your terms. Take shift of your liking based on your personal & professional engagements for the day.

Regular Chit Chat Sessions

We work hard & party harder. Apart from organizing events for every festival, we also do quarterly chit-chat sessions. There are snacks, drinks, games talent shows & lots of fun.

Comfortable Working Environment

We do our best to provide you an environment where you can be most productive - an open office, laptops, freedom to work from anywhere, gaming area where you can relax, & much more.

Healthcare

The well-being of our teammates is our priority, which is why we offer compulsory medical insurance to every Classicite. And when our friends get sick, we provide them with paid sick leaves.

Appreciations & Certifications

We know the power of a simple pat on the back. Going a step beyond, every quarter, we motivate top-performers from every team with gift vouchers, certificates & a round of applause.