i
Kumaran Systems
18 Kumaran Systems Jobs
Oracle Database Administrator with SQL DBA !!
Kumaran Systems
posted 1d ago
Flexible timing
Key skills for the job
We are hiring for Oracle Database Administrator with SQL DBA 7-12 years (Preferably to join immediate/less than 15 days) !!
Location : Chennai (Siruseri ,work from office)
About us ,
We are a rapidly growing NASSCOM 2009-listed IT-enabling company with footprint in four countries. For two decades now, we have provided our global clientele with a range of high-end IT services including migration support, system integration, and infrastructure management solutions. Equipped with two development centres located at Chennai, Kumaran Systems can be that one-stop-shop for every IT solution that your business demands. Kumaran has been ranked among the Top 500 global software companies (16th Annual Ranking by Software Magazine) and among the Top 200 Indian software companies (3rd Annual Ranking by Data quest).
Website :: www.kumaran.com
Job Description:
Mandatory Skillset:
Oracle Database Administrator with SQL DBA
Core DBA Admin
Informatica Admin
Linux
Shell scripting
Pega Admin
Oracle Database administration:-
Expertise in Oracle (11g/12c/19c) database version
Strong experience in database performance tuning, query optimization, and index management.
Experience in backup & restore strategies.
Understanding of cloud database solutions: AWS RDS.
Manage, configure, and optimize Oracle database instances.
Perform routine health checks, maintenance, and upgrades to ensure database availability and reliability.
Conduct in-depth performance analysis to identify and resolve slow-running queries, indexes, and resource bottlenecks.
Optimize database configurations, query execution plans, and schema design for Oracle
Oracle Database Architecture
Installation, configuration and upgrading of Oracle server in a standalone Environment
Implementing DR solutions using Oracle Standby Database using Oracle Data Guard
Start and Stop of Oracle Database Services
Migrating schemas using traditional exp/imp and Oracle Datapump utilities.
Usage of Oracle RMAN
Usage of Alert logs
Familiar with Oracle CPU and PSU patching procedure.
Generating and Analyzing Oracle AWR and ADDM Reports
Monitor data backup process and perform data recovery if needs be.
Study database related issues that could affect the database production infrastructure and document the issues.
Develop scripts to automate functions, processes and monitor database performance.
Microsoft SQL Database Administrator :-
Cloud experience with application production DBA.
Skills include Microsoft SQL DB Administration, DB backup and restores, SQL Scripting, ETL Jobs, SSRS etc.
Solid experience in Database creation, SQL Scripting, Users setup, Client Migrations, Performance Turning, Monitoring, and Troubleshooting issues.
Primarily working on App Deployments and Client Migrations. Microsoft SQL Database Administrator
Ready to start working on production, self-learner and eager to support client requests.
PostgreSQL Administration:-
Provide primary support for PostgreSQL
Design, maintain and ensure high availability solutions including replication, clustering etc.
Design, Implement and document Disaster Recovery strategies.
Provide proactive and reactive data management support to ensure database security, integrity, stability and system availability.
Monitor database performance, implement changes, and installations and apply new patches and versions when required.
Perform user access management & performance tuning
Manage all regular DBA Tasks and activities.
Linux environment.
Informatica PowerCenter Administration:-
Install, configure, and maintain Informatica PowerCenter components (Repository Server, Integration Service, Domain Configuration) on Windows servers
Monitor and optimize PowerCenter performance, including troubleshooting and resolving issues.
Manage Informatica platform upgrades, patches, and performance tuning to ensure optimal system performance.
Administer user access, roles, and security policies within Informatica applications.
Monitor, troubleshoot, and resolve issues related to Informatica workflows, jobs, and integrations.
Work closely with development and data teams to optimize ETL processes and improve data quality.
Strong knowledge of Informatica repository management, services configuration, and metadata management.
Experience in installation, upgrades, and troubleshooting of Informatica tools.
Familiarity with Linux/Unix environments, shell scripting, and database connectivity (Oracle, SQL Server, etc.).
Understanding of performance tuning, job scheduling (Autosys, Control-M), and security configurations.
has context menu
Interested applicants share profiles to lakshmi.prasuna@kumaran.com
Employment Type: Full Time, Permanent
Read full job descriptionPrepare for Oracle Database Administrator roles with real interview advice
8-13 Yrs
Chennai, Bangalore / Bengaluru
3-5 Yrs
Chennai, Bangalore / Bengaluru