Job Description

DME III / IV ( SQL DBA & NO SQL DBA) DME III / IV ( SQL DBA & NO SQL DBA) Location

Hyderabad, Telangana IN Department

Product & Engineering Job Role

?

Responsible for creating, monitoring, and maintaining various databases - MySQL, Postgres, Oracle, Click House 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.

? What 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, Click House, 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

? Qualification and other skills

?

B.E./BTech/MCA from a premier institute

8-10 years of experience in managing enterprise databases What you'd have?

?

Expert on any three of the databases (covering minimum 1 from SQL and NoSQL database family each) - Oracle, MySQL, PostgreSQL, Click House DB & NoSQL like Mongo DB, Cassandra, Scylla DB, Redis, Aerospike etc.

Installing MySQL, PostgreSQL, Click House DB, Oracle , Cassandra, Scylla DB & Mongo DB.

Backup and Recovering Oracle, MySQL, Mongo DB, Click House 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.

?

https://www.tanla.com