Karix

Staff Engineer - Database Administration

Hyderabad, Telangana, India

2 months ago
Save Job

Summary

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

12-15 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.

(ref:hirist.tech)

How strong is your resume?

Upload your resume and get feedback from our expert to help land this job