ESaaS - DBA - Sys Admin

Zensar Technologies

Not disclosedIndia (On-site)
Posted: 13d agoOpening: 1

Skills Required

Key skills are marked withstar
  • Key skillOracle Database
  • Key skillDatabase Administration
  • Key skillRMAN
  • Oracle RAC
  • Data Guard
  • Performance Tuning
  • AWR Reports
  • Backup & Recovery
  • Patching
  • ASM
  • PL/SQL
  • Linux
  • Shell Scripting
  • Oracle Cloud Infrastructure
  • High Availability

Job Description

Key Responsibilities:

  • Collaborate closely with development teams to design efficient, scalable, and maintainable database schemas 

  • Participate early in application design to ensure optimal data modeling and query patterns 

  • Optimize SQL queries, stored procedures, and data access patterns during development lifecycle 

  • Design and review normalized and denormalized table structures

  • Define indexing strategies and data partitioning aligned with application use cases

  • Define and enforce database coding standards and performance guidelines

  • Analyze query execution plans and performance issues identified during development, testing, and client UAT and production

  • Ensuring compliance with industry standards and regulatory requirements 
  • Contribute to database security design (roles, privileges, masking strategies)

  • Actively participate in backup and restore process design
  • Analyze Oracle AWR reports

 

What you bring:

  • Extensive experience with Oracle Database 19c
  • Strong experience in data modeling and schema design for complex applications

  • Proficient in optimizing complex queries and store procedures, optimized indexing
  • Experience analyzing execution plans and tuning queries in development phases, or to unlock production incidents

  • Hands-on experience working with developers in Agile environments

  • Database design skills
  • Knowledge of Oracle Recovery Manager (RMAN) for backup –understanding of production database concepts (HA, backup, recovery) as context for design decisions
  • Understanding of database security and practices
  • Proficiency in shell scripting
  • Proficiency in Docker
  • Familiarity with Linux
  • Experience with Oracle SQL Developer
  • Knowledge of cloud database solutions such as Oracle cloud, Amazon RDS for Oracle, MS Azure

 

Added bonus:

  • Java knowledge 
  • Report generation
  • Basic understanding of Kubernetes

Key Responsibilities:

  • Collaborate closely with development teams to design efficient, scalable, and maintainable database schemas 

  • Participate early in application design to ensure optimal data modeling and query patterns 

  • Optimize SQL queries, stored procedures, and data access patterns during development lifecycle 

  • Design and review normalized and denormalized table structures

  • Define indexing strategies and data partitioning aligned with application use cases

  • Define and enforce database coding standards and performance guidelines

  • Analyze query execution plans and performance issues identified during development, testing, and client UAT and production

  • Ensuring compliance with industry standards and regulatory requirements 
  • Contribute to database security design (roles, privileges, masking strategies)

  • Actively participate in backup and restore process design
  • Analyze Oracle AWR reports

Similar Jobs (35111)

Senior Verification Engineer | High-Performance Computing & Graphics

AMD

Not disclosedHyderabad

Skills required:

High Performance Computing, Parallel Computing, MPI, OpenMP, C++, CUDA, Linux, Slurm, Cluster Management, Performance Optimization, Python, Fortran, GPU Programming, Shell Scripting, Networking

Application Tech Support Practitioner

Accenture

Not disclosedBengaluru

Skills required:

Cloud Platforms, AWS, Microsoft Azure, Troubleshooting, Linux, Networking, Cloud Monitoring, Customer Support, Incident Management, Shell Scripting, Python, Identity & Access Management, Cloud Databases, Ticketing Systems, Root Cause Analysis

Product Manager

TriNet

Not disclosedHyderabad

Skills required:

Product Management, Product Roadmapping, Product Strategy, User Research, Requirements Gathering, User Stories, Agile Methodologies, Product Analytics, A/B Testing, Stakeholder Management, Go-to-Market Strategy, Prioritization Frameworks, Data Analysis, Wireframing, Jira

Principal Software Engineer

TriNet

Not disclosedHyderabad

Skills required:

Software Architecture, System Design, Distributed Systems, Technical Leadership, Programming, Scalability, Design Patterns, Cloud Architecture, Performance Optimization, Microservices, Code Review, Mentoring, Technology Strategy, Security Best Practices, Cross-Functional Collaboration

Staff Software Engineer

TriNet

Not disclosedHyderabad

Skills required:

Software Architecture, System Design, Distributed Systems, Technical Leadership, Scalability, Programming, Cloud Architecture, Microservices, Performance Optimization, Cross-Team Collaboration, Mentoring, Code Review, Technology Strategy, Security Best Practices

Staff Software Engineer

TriNet

Not disclosedHyderabad

Skills required:

Software Architecture, System Design, Distributed Systems, Technical Leadership, Scalability, Programming, Cloud Architecture, Microservices, Performance Optimization, Cross-Team Collaboration, Mentoring, Code Review, Technology Strategy, Security Best Practices

Manager, Enterprise Data Management

TriNet

Not disclosedHyderabad

Skills required:

Data Management, Data Quality, Data Governance, Master Data Management, SQL, Excel, Data Cleansing, Data Validation, Data Profiling, Metadata Management, Documentation, Reporting, Attention to Detail

Principal Software Engineer

TriNet

Not disclosedHyderabad

Skills required:

Software Architecture, System Design, Distributed Systems, Technical Leadership, Programming, Scalability, Design Patterns, Cloud Architecture, Performance Optimization, Microservices, Code Review, Mentoring, Technology Strategy, Security Best Practices, Cross-Functional Collaboration

AI Native Software Engineer

Accenture

Not disclosedBengaluru

Skills required:

Artificial Intelligence, Machine Learning, Python, Large Language Models, Deep Learning, PyTorch, TensorFlow, Retrieval-Augmented Generation, Prompt Engineering, Natural Language Processing, MLOps, Model Deployment, Vector Databases, REST APIs, Docker

I&P GN - I&E - Comms & Media - Consultant - Process Excellence-PE

Accenture

Not disclosedBengaluru

Skills required:

Process Excellence, Lean Six Sigma, Process Redesign, Process Mapping, Value Stream Mapping, Root Cause Analysis, KPI Development, Change Management, Automation Opportunity Analysis, Client Management, Training Delivery, Presentation Skills

View All 35111 Jobs