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 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 

• 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