Database SME (Oracle & SQL)

7 years

0 Lacs

Posted:1 week ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

Role Description

We are seeking an experienced

Database SME (Oracle & SQL)

to design, manage, and optimize enterprise-level database systems within the

Banking, Financial Services, and Insurance (BFSI) domain

. The role involves ensuring high availability, security, performance, and compliance of mission-critical databases while supporting both on-premises and cloud environments.Key Responsibilities

Database Administration

  • Install, configure, and manage Oracle (12c, 19c) and SQL Server (2016, 2019, 2022) in high-availability setups.
  • Oversee database architecture, upgrades, and migrations.

Performance Optimization

  • Conduct query tuning, indexing, partitioning, and in-memory processing to enhance database performance.

Security & Compliance

  • Implement RBAC, encryption, auditing, and data masking.
  • Ensure compliance with PCI DSS, GDPR, ISO 27001, SOC 2, and other BFSI security regulations.

Backup & Recovery

  • Develop and maintain robust backup and recovery strategies using RMAN, Data Pump, SQL Server Always On, and enterprise backup tools.

High Availability & Disaster Recovery

  • Design and implement Oracle Data Guard, Oracle RAC, SQL Server Always On, and Failover Clustering solutions.

Automation & Scripting

  • Automate database administration tasks using PL/SQL, T-SQL, PowerShell, Python, and Ansible.

Incident & Problem Management

  • Troubleshoot and resolve performance issues, connectivity failures, and outages in production environments.

Cloud & Hybrid Database Management

  • Support and optimize databases hosted on AWS RDS, Azure SQL, Oracle Cloud, and hybrid cloud platforms.

Monitoring & Reporting

  • Use monitoring tools like Oracle Enterprise Manager (OEM), SQL Server Profiler, Prometheus, and Splunk for proactive analysis and reporting.

Collaboration & Documentation

  • Work with cross-functional teams and maintain detailed documentation of database architectures, policies, and recovery procedures.

Required Skills & Qualifications

  • 7+ years of hands-on experience in Oracle and SQL Server administration.
  • Proven expertise in high availability architectures (RAC, Data Guard, Always On, Failover Clustering, Replication, Mirroring, Log Shipping).
  • Strong background in backup, recovery, and disaster recovery planning.
  • Experience in database security, encryption, and compliance standards.
  • Proficiency in PL/SQL, T-SQL, PowerShell, Python, or Ansible for automation.
  • Experience with cloud-based database solutions (AWS RDS, Azure SQL, Oracle Cloud).
  • Strong problem-solving and troubleshooting capabilities in production environments.
  • Experience with database migrations, upgrades, and patching.

Preferred Certifications

  • Oracle Certified Professional (OCP) – Database Administration
  • Microsoft Certified: Azure Database Administrator Associate
  • AWS Certified Database – Specialty
  • Certified Kubernetes Administrator (CKA) – preferred for containerized database environments

Skills

Postgres Dba,Oracle,Ms Sql

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now
UST logo
UST

IT Services and IT Consulting

Aliso Viejo CA

RecommendedJobs for You

trivandrum, kerala, india

trivandrum, kerala, india