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 Data Security, Governance, compliance measures etc.
You'll be Responsible for,
-
Ensure optimal health, integrity, 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 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
-
Knowledge of schedulers like 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. Serve as database administration.
-
Responsible for implementation and ongoing administration of Data Pipelines
Qualification and Experience
-
B.E./B.Tech/MCA from a premier institute
-
8-10 years of experience in managing enterprise databases
You'd have,
-
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, 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?
We thought you'd never ask! We offer all the usual stuff: competitive salary, flexible working hours, challenging product culture but the real perks are:
-
Challenging and fun work environment solving meaningful real-life business problems - you'll never have a boring day at the office.
-
World-class team who love solving tough problems and have a bias for action
Tanla is an equal opportunity employer. We welcome and encourage diversity in the workplace regardless of race, gender, religion, age, sexual orientation, gender identity, disability, or veteran status. https://www.tanla.com