Database Administrator

Job Scope:
Responsible for creating, monitoring and maintaining various databases - MySQL, Postgres, Oracle, ClickHouse including NoSQL databases like Cassandra, Mongo DB, Scylla DB etc.
Automating routine Database Administration, monitoring and alerting activities using shell scripting, python, Perl etc.
Providing DB design solutions, hands-on expert using SQL and other DB related tools.
Providing solutions for Database High Availability (HA), Data Security, Governance, compliance measures etc.

You'll be Responsible for?
Ensure optimal health, integrity, availability, performance, and security of all databases.
Develop and maintain data categorization and security standards.
Evaluate and recommend new database technologies and management tools; optimize existing and future technology investments to maximize returns.
Provide day-to-day support to internal IT support groups, external partners, and customers as required.
Manage outsourced database administration services to perform basic monitoring and administrative-level tasks as directed.
Participate in change and problem management activities, root cause analysis, and development of knowledge articles to support the organization's program.
Support application testing and production operations. Serve as database administration.
Document, monitor, test, and adjust backup and recovery procedures to ensure important data is available in a disaster scenario.
Serve as On-Call database administrator on a rotating basis.
Develop, Implement, and Maintain MySQL, PostgreSQL, Mongo, ClickHouse, Cassandra, Scylla DB and Oracle Instances including automated scripts for monitoring and maintenance of individual databases.
Diligently teaming with the infrastructure, network, database, application, and business intelligence teams to guarantee high data quality and availability.
Collaborating with various teams to install Database software updates, patches, version upgrades when required.
Performance tuning of Databases, SQL Query tuning, optimizing database designs.
Knowledge of schedulers - Cron, or any other new generation schedulers like Apache Airflow
Provide subject matter expertise to internal and external project teams, applications developers, and others as needed. Support application testing and production operations.
Responsible for implementation and ongoing administration of Data Pipelines
What you'd have?

B.E./B.Tech/MCA from a premier institute
5-9 years of experience in managing enterprise databases
Knowledge and Skills
Expert on any three of the databases (covering minimum 1 from SQL and NoSQL database family each) - Oracle, MySQL, PostgreSQL, ClickHouse DB & NoSQL like Mongo DB, Cassandra, Scylla DB, Redis, Aerospike etc.
Installing MySQL, PostgreSQL, ClickHouse DB , Oracle , Cassandra, Scylla DB & Mongo DB.
Backup and Recovering Oracle, MySQL, Mongo DB, ClickHouse DB Cassandra, Scylla DB and PostgreSQL databases.
User level Access: Risks & Threats.
Synchronous and Asynchronous replication, converged systems, partitioning, and storage-as-a-service (cloud technologies)
Linux operating systems (RHEL, Ubuntu, CentOS), including shell scripting.
Windows Server operating system
Industry-leading database monitoring tools and platforms
Data integration techniques, platforms, and tools
Modern database backup technologies and strategies

Why join us?
Impactful Work : Play a pivotal role in safeguarding Tanla's assets, data, and reputation in the industry.
Tremendous Growth Opportunities : Be part of a rapidly growing company in the telecom and CPaaS space, with opportunities for professional development.
Innovative Environment:

Work alongside a world-class team in a challenging and fun environment, where innovation is celebrated.

Tanla is an equal opportunity employer. We champion diversity and are committed to creating an inclusive environment for all employees.

www.tanla.com

---