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 youll 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 youd 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
Job Classification
Industry: Telecom / ISPFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Database AdministratorEmployement Type: Full time