Report this Job
Job Scope:
Responsible for creating, monitoring and maintaining various databases - MySQL, Postgres,
MongoDB, Oracle, ClickHouse etc.
Automating routine Database Administration, monitoring and alerting activities using shell
scripting, python, perl etc.
Providing requested data to Internal and external team using SQL or other tools.
Supporting periodic Data Governance audits, compliance measures etc.
Job Responsibilities:
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 organizations 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
Serve as on-call database administrator on a rotating basis.
Develop, Implement, and Maintain MySQL, PostgreSQL , Mongo 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.
Serve as on-call database administrator on a rotating basis.
Responsible for implementation and ongoing administration of Hadoop infrastructure
Qualification and Experience
B.E./B.Tech/MCA
6-8 years of experience in managing enterprise databases
Knowledge and Skills
Oracle, MySQL, PostgreSQL, Clickhouse DB & knowledge on NoSQL like Mongo DB & Redis etc.,
Installing MySQL, PostgreSQL, Clickhouse DB & Mongo DB.
Backup and Recovering Oracle, MySQL, Mongo DB, Clickhouse 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
Humaniquee