Oracle DBA at Hunarstreet Technologies pvt ltd · Chennai · 6 - 10 years · ₹5L - ₹8L / yr · Posted 22 Jul 2025

Position: Oracle DBA
Experience: 6–8 Years
Key Responsibilities:
- Install, configure, and maintain Oracle databases in production and non-production environments.
- Perform database tuning, backups, and recovery.
- Monitor database performance and implement improvements.
- Ensure data security and compliance with audit requirements.
- Handle upgrades and patching of database environments.
Skills Required:
- Strong experience with Oracle 11g/12c/19c.
- Hands-on with RMAN, Data Guard, and Oracle RAC.
- Proficient in writing complex SQL and PL/SQL.
- Oracle Certified Professional (OCP) preferred.

Similar jobs (7)
Role overview:
· Technology Expertise & DBA Skill Set
· Cloud Platforms: AWS, Azure
· Database IaaS: Oracle, Microsoft SQL Server, PostgreSQL
· Database PaaS: CosmosDB, MySQL, SQL Managed Instance, RDS Aurora, MongoDB
· Infrastructure as Code: Terraform, Ansible
· CI/CD & Automation: GitHub Actions, GitLab, Azure DevOps
· Programming & Scripting: Python, Bash/Shell, PowerShell
· Operating Systems: Linux/Unix (RHEL, Ubuntu), Window
Database Team Overview
Our Database Team is the foundation of enterprise-grade databases delivering secure, compliant and high-performing database platforms across Azure and AWS. We provide managed services for Oracle and Microsoft SQL Server, operating in a system DBA role to ensure platform reliability, resilience, and operational excellence. In addition, we support PaaS and RDS database services by acting as the platform team defining policies, enforcing security standards, and managing networking configurations while enabling self-service capabilities for application teams to consume these services efficiently.
What would you do here:
· Database Security & Compliance: Implement robust security controls, encryption, and auditing to safeguard sensitive data and meet regulatory requirements.
· Lifecycle Management: Oversee patching, upgrades, and end-of-life transitions to maintain platform stability and minimize risk.
· Performance Optimization: Monitor and tune databases for optimal performance across diverse workloads.
· Automation & Operational Excellence: Design and deploy automation for provisioning, monitoring, and maintenance to achieve “brilliant basics” and reduce manual intervention.
· Business-Critical Certification: Validate and certify database environments to support mission-critical applications with high availability and disaster recovery strategies.
· Incident & Problem Management: Provide rapid response and root-cause analysis for database-related incidents to ensure business continuity.
· Capacity Planning & Scalability: Forecast growth and optimize resources to support evolving business needs.
Best Regards!
Job Summary
Responsible for administration of Postgres databases with secondary skills in administration of
DB2, Oracle, MS-SQL, Clickhouse, Neo4J.
Skill Requirements:
5+ years of experience in Postgres database administration
DB design (Architecture design principles, modelling, partitioning, setting standards and
normalisation), installation, managing schemas, performance tuning, parameter tuning,
storage management, DB maintenance, patching, upgrade, back-up & recovery, High
availability ,replication and capacity planning.
Coding Stored procedures
Working with Linux OS including shell scripting.
Strong experience in AWS and Azure environment.
Experience with an organisation with reliance on 24x7 database services.
Must be an initiative-taker & analytical person with good communication and
interpersonal skills.
Key competencies
Postgres database administration
Skills on other database technologies like DB2, Oracle, MS-SQL, Clickhouse
Cloud services - AWS and Azure.
Job Description (JD) for the MySQL Database Administrator role
Experience: 4-8 Years
Location : Mumbai
Job Title: MySQL Database Administrator
Responsibilities
- Provision and configure MySQL database instances in clustered and non-clustered environments.
- Ensure database performance, security, availability, and reliability.
- Prepare and maintain database documentation, technical specifications, and operational procedures.
- Perform database upgrades, backups, restoration, recovery, and migrations.
- Monitor database and server resource utilization and perform performance tuning and optimization.
- Manage database users, access privileges, periodic access reviews, audits, and documentation.
- Configure, monitor, and troubleshoot MySQL replication.
- Collaborate with application, infrastructure, development, and other stakeholder teams to resolve database-related issues.
- Provide database and application deployment support, as required.
- Perform database backup and restoration validation, data integrity checks, and post-migration validations.
- Follow database change management, security, and operational best practices.
Skills and Qualifications
- Strong hands-on experience in MySQL database administration.
- Good working knowledge of recent MySQL versions, preferably MySQL 8.x.
- Understanding of MySQL storage engines, including InnoDB and MyISAM.
- Practical experience in configuring, monitoring, and troubleshooting MySQL replication.
- Knowledge of MySQL administration best practices, security, and high availability.
- Proficiency in writing, analyzing, and optimising SQL queries.
- Experience with MySQL features such as the Event Scheduler, audit logging, and performance monitoring.
- Ability to assess database resource requirements based on application workloads and technical specifications.
- Familiarity with other SQL and NoSQL databases, such as PostgreSQL and MongoDB.
- Understanding of MySQL limitations compared with other relational database platforms and the ability to identify suitable workarounds.
- Working knowledge of version control tools such as Git, SVN, or CVS.
- Graduate degree in a relevant discipline and good verbal and written communication skills.
Good to Have
- Basic Linux administration, command-line troubleshooting, and Bash scripting skills.
- Familiarity with application server frameworks such as JBoss, GlassFish, and WildFly.
We are looking for an experienced Oracle EBS Techno-Functional Consultant specializing in Oracle Projects (Project Costing, Project Billing, and Project Management), to support and maintain enterprise Oracle EBS applications. The ideal candidate will have a strong blend of functional expertise in project accounting processes and technical skills to independently troubleshoot, customize, and enhance the application, ensuring smooth day-to-day operations in a production support environment.
Key Responsibilities
Functional
- Provide L2/L3 production support for Oracle Projects (PA) module, covering Project Costing (PC), Project Billing (PB), and Project Management (PM) processes.
- Act as the primary point of contact for Project Managers, Finance, and Delivery teams, leading root-cause analysis and resolution for complex incidents.
- Configure and maintain PA setups: Project Types, Project Templates, Task Structures, Costing/Billing Rules, Burden/Overhead structures, Rate Schedules, Agreements, and Funding.
- Support integration points between Oracle Projects and other modules (GL, AP, AR, HR/OTL, PO, FA) for cost/labor/expenditure flows.
- Troubleshoot issues related to Cost Distribution, Cross-Charge/Inter-company billing, Revenue Recognition, Invoice Generation, and Project-GL/AR interfaces.
- Support project close, period close, and cross-period adjustment processes; resolve exceptions in cost/revenue/billing distribution.
- Manage transaction import failures (Cost Collector, Transaction Import), unprocessed transactions, and expenditure batch errors.
- Prepare functional design documents (FDD/MD-050) and test cases (test scripts, UAT support) for enhancements/patches.
- Ensure compliance with SLA/OLA for ticket resolution (incidents, service requests, minor enhancements).
- Support statutory/regulatory and client-specific billing/revenue recognition compliance requirements.
Technical
- Analyze and resolve complex issues related to interfaces (Transaction Import, Cost Collector, Labor/Usage/Expense Report Interfaces), conversions, and custom reports impacting Projects.
- Develop/debug PL/SQL procedures, packages, and triggers for PA-related customizations and data fixes.
- Work on Oracle Workflow (Project/Budget/Invoice approval workflows), Oracle Alerts, and Application Object Library (AOL) objects.
- Support and troubleshoot BI Publisher (BIP)/XML Publisher reports, project status reports, billing/invoice formats, and custom PA reports.
- Perform back-end data fixes/updates (with due approvals) for stuck transactions, failed cost distributions, or interface errors.
- Coordinate with DBA/Infra teams for patches, cloning, and environment refresh activities impacting Projects module.
- Prepare and maintain Technical Design Documents (TDD/MD-070) for custom objects and interfaces.
- Mentor junior consultants on technical troubleshooting and PA functional processes.
Support Process & Governance
- Log, track, and manage tickets via ITSM tools (Zendesk, Remedy, JIRA, etc.).
- Participate in on-call/rotational support.
- Adhere to and help enforce change management (CR) and incident management processes.
- Provide RCA (Root Cause Analysis) documentation for recurring/critical issues.
- Drive knowledge base (KB) documentation and continuous process improvement initiatives.
Job Description:
Mandatory Skills: Linux Administration, Production Support, Database Support, and Monitoring & Observability, with exposure to Cloud and Automation.
Primary Skills: Linux Administration, Production Support
Secondary Skills: Oracle SQL, Splunk, Grafana, AppDynamics, Cloud (OCP/AWS/Azure/GCP), Incident Management, AI/Automation (Good to have)

Lead Data Security Solution Engineer
Exp: 10+ years
Rate: 35 LPA
Location: Remote
Time zone: ET (US Eastern time)
Shift: Night Shift
Type: Fulltime
Responsibilities:
1. Technical and Database Assessment
Review Data In-Licensing requirements, workflow maps, data flows, data lineage, entitlement rules, and dependency records.
Assess relational database platforms, schemas, connectivity methods, interfaces, drivers, service identities, query patterns, and downstream consumption.
Identify where licensed data is stored, transformed, replicated, extracted, cached, archived, or backed up.
Assess current database security capabilities and identify gaps, constraints, risks, and prerequisites.
2. Data-Level Authentication and Identity Integration
Assess authentication for named users, service identities, workloads, and analytical tools accessing databases.
Evaluate OAuth/OIDC or other identity- and token-based authentication directly to the database where supported by the selected technology.
Design integration between enterprise identities, security groups, project groups, database principals, roles, and policy engines.
Reduce reliance on shared or long-lived credentials where feasible and define secure credential or token handling for unavoidable exceptions.
Align with tools currently available and identify gaps if any,
3. Fine-Grained Authorization and Data Firewalling
Design database-level controls that restrict access to explicitly authorized users, groups, services, projects, or licensing populations.
Design and implement row-level security, column-level security, dynamic masking, views, policy-based filtering, or equivalent controls as appropriate.
Define isolation patterns for different licensed datasets and agreements while preserving permitted platform use for other users.
Ensure controls are consistently enforced as close to the data layer as technically feasible and are not solely dependent on application logic.
4. Auditing, Monitoring, and Traceability
Design database auditing to capture who accessed data, what was accessed, when access occurred, and which identity or service was used.
Define logging for queries, exports, failed access attempts, permission changes, and privileged activity where supported and required.
Integrate audit telemetry with appropriate monitoring and reporting capabilities and define retention and evidence requirements.
Validate that audit records are searchable, attributable, protected from inappropriate modification, and useful for investigation.
5. Data Lifecycle, Revocation, and Deletion
Design controls for access revocation when users change roles, leave a project, or when licensing rights expire.
Design methods to identify and remove licensed data from primary stores and relevant downstream copies, extracts, caches, or derived stores.
Address deletion implications for referential integrity, backups, archives, replication, recovery processes, and downstream consumers.
Define validation, exception handling, and evidence mechanisms to demonstrate that required deletion activities were completed.
6. Solution Architecture and Engineering
Translate requirements into current-state and target-state architectures, technical specifications, security patterns, and implementation plans.
Compare solution options and document trade-offs across security, feasibility, performance, scalability, operability, cost, and technology constraints.
Define database connectivity, policy-enforcement, identity, audit, monitoring, lifecycle, and integration components.
Collaborate with database, IAM, security architecture, infrastructure, application, data platform, governance, and scientific teams.
7. POC Design and Execution
Select suitable relational database and workflow candidates that represent Data In-Licensing scenarios and material technical risks.
Define POC architecture, test data, test identities, success criteria, negative tests, performance considerations, and rollback approach.
Implement and validate identity-based authentication, fine-grained authorization, data firewalling, auditing, access revocation, and deletion scenarios.
Document outcomes, limitations, operational considerations, reusable patterns, and recommendations for broader adoption.
What we expect:
Expected Deliverables
Technical assessment of databases, integrations, identities, and data flows
Current-state database security and capability assessment
Target-state data security architecture and detailed technical design
Database authentication and identity-integration design
Row-level, column-level, masking, and policy-enforcement design
Data firewalling and licensed-dataset isolation pattern
Audit, monitoring, traceability, and reporting design
Access revocation, retention, lifecycle, and deletion design
Solution options, feasibility, gap, dependency, and risk assessment
POC architecture, implementation, test results, and recommendations
Reusable implementation patterns and operational handover documentation
Required Technical Skills and Experience
Strong hands-on experience with relational databases, SQL, database architecture, schemas, roles, privileges, and access paths.
Practical experience implementing database-level authorization, including row-level and column-level controls or equivalent fine-grained mechanisms.
Strong knowledge of database authentication, IAM, OAuth 2.0, OIDC, tokens, service identities, workload identities, and secrets management.
Experience designing secure database connectivity and integrations for applications, analytical tools, APIs, ETL/ELT, and data pipelines.
Experience with database auditing, query/activity monitoring, centralized logging, alerting, and investigation support.
Understanding of data lineage, lifecycle, retention, revocation, deletion, backup, archive, and recovery implications.
Ability to evaluate heterogeneous database technologies and design platform-appropriate controls.
Strong architecture, engineering, troubleshooting, documentation, and stakeholder-collaboration skills.
Nice to have:
Experience with enterprise data platforms, cloud or hybrid databases, data catalogs, access governance, and policy-enforcement technologies.
Experience in pharmaceutical research, scientific data, intellectual property protection, data licensing, or another regulated environment.
Experience designing and executing security POCs and converting validated patterns into production-ready designs.
Knowledge of privacy, contractual-use restrictions, segregation, and evidence requirements affecting licensed data.
Applications on this job are not being reviewed actively. You may apply but please follow up with the company via other channels too.
Hiring: Denodo Administrator
Location: Bangalore / pune / Hyderabad💼
Experience: 7+ Years
Key Skills:
- Denodo Administration & Data Virtualization
- Linux/Unix Administration
- SQL Performance Tuning
- Oracle / SQL Server / DB2
- LDAP / AD / Kerberos / SSO
- Shell Scripting / Python
- AWS / Azure
🔹 Experience in Denodo platform administration, production support, performance tuning, security, deployment, and environment management.










