PUNE · FULLTIME
Database Administrator
Persistent Systems
Pune · onsite · Posted 26d ago
Sourced from
₹20.0L - ₹30.0L PA11–16 yrsfulltimePune
About a minute. You'll make an account on the way through.
agent · working
- Read this posting0.7s
- Found the form on Naukri · 11 questions to answer1.1s
- Decided the answers for all of them2.8s
- Tailor your résumé to this role
- Waiting for you
Section · 01
About this role
- Audit, analyze, and refactor legacy PL/SQL packages, stored procedures, functions, and triggers into modular, maintainable, and optimized database components.
- Rewrite and optimize complex SQL queries using Oracle 19c Cost-Based Optimizer (CBO) best practices.
- Transform cursor-based and row-by-row processing logic into high-performance set-based SQL using BULK COLLECT and FORALL techniques.
- Perform comprehensive database performance assessments and recommend optimization strategies.
- Design and implement structured logging, tracing, monitoring, auditing, and error-handling frameworks.
- Lead schema redesign initiatives, including normalization, denormalization, and optimization of large-scale enterprise databases.
- Develop advanced partitioning, indexing, compression, and storage strategies for Oracle 19c environments.
- Identify and eliminate technical debt, including obsolete database objects, redundant indexes, inefficient code, and unnecessary data access patterns.
- Perform deep execution plan analysis using Oracle SQL Monitor, SQLTXPLAIN, AWR, ASH, and other diagnostic tools.
- Optimize Azure-hosted applications and services interacting with Oracle databases through enhanced connection pooling, batch processing, and integration patterns.
- Design scalable data integration frameworks leveraging Azure Data Factory and cloud-native technologies.
- Improve database availability, scalability, reliability, and disaster recovery capabilities.
- Collaborate with application developers to embed database performance best practices within software development lifecycles.
- Lead database modernization and migration initiatives across cloud and hybrid environments.
- Establish database governance standards, performance benchmarks, and architectural best practices.
- Provide technical leadership and mentorship to database administrators, developers, and technical teams.
Sourced from naukri
Section · 02
Skills
Database AdministrationModernizationRefactoringDatabase AdministratorOracle DBSQLData Integration
Section · Company
About Persistent Systems
Persistent Systems
IT Services & Consulting
22.2k+
employees
1990
36 years old
Pune, Maharashtra
India
₹20L – ₹30L PA
This role
About
With 23,900+ global team members across 19 countries, Persistent is a global services and solutions company delivering Digital Engineering and Enterprise Modernization.
Industries
IT Services & ConsultingTelecomFinTechHealthcareEmerging TechnologiesSoftware Product
Employee ratings
5,043 reviews
3.6/ 5
Culture
3.5
Career growth
3.0
Work-life
3.6
Employees rate it well for
Work Life Balance750Work Culture670Salary551Job Security439Senior Management397
Find them on