Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Jobs

Interviews

Home
>
Jobs in Bengaluru
>
Lorven Technologies Private Limited
>
Oracle & MS-SQL and PostgreSQL DBA

Oracle & MS-SQL and PostgreSQL DBA

Lorven Technologies Private Limited

8 - 13 years

2 - 6 Lacs

Bengaluru

Posted:1 week ago| Platform:

Apply

Skills Required

oracle apps dba dbms data migration aws cloud aws query tuning performance tuning disaster recovery amazon rds aws lambda sql server sql database design amazon ec2 postgresql powershell sql server administration unix amazon cloudwatch

Work Mode

Work from Office

Job Type

Full Time

Job Description

Job Title Oracle & MS-SQL and PostgreSQL DBAExperience 8-16 YearsLocation Bangalore
:
Must have 4 Year degree (Computer Science, Information Systems or equivalent)
8+ years overall IT experience (5+ Years as DBA)
Technical
Skills:

Hands-on expertise in data migration between databases on-prem to AWS cloud RDS.
Experience in usage of AWS Data Migration Service (DMS)
Experience in export/import of huge size Database Schema, full load plus CDC.
Should have knowledge & experience in Unix command and writing task automation shell scripts.
Knowledge & experience on Different Backup/restore methods and backup tools is needed.
Experienced with hands on experience in DBA Skills of database monitoring, performance tuning, DB refresh.
Hands on experience in Database support.
Hands-on expertise in data migration between databases on-prem toMongo Atlas.
Experience in creating clusters, databases and creating the users.
Hands-on expertise in data migration between databases on-prem to AWS cloud RDS (postgres)
SQL Server Administration:Install, configure, upgrade, and manage SQL Server databases hosted on AWS EC2, RDS.
AWS Cloud Integration:Design, deploy, and manage SQL Server instances using AWS services like RDS, EC2, S3, CloudFormation, and IAM.
Performance Tuning:Optimize database performance through query tuning, indexing strategies, and resource allocation within AWS environments.
High Availability and Disaster Recovery:Implement and manage HA/DR solutions such as Always On Availability Groups, Multi-AZ deployments, or read replicas on AWS.
Backup and Restore:Configure and automate backup strategies using AWS services like S3 and Lifecycle Policies while ensuring database integrity and recovery objectives.
Security and Compliance:Manage database security, encryption, and compliance standards (e.g., GDPR, HIPAA) using AWS services like KMS and GuardDuty.
Monitoring and Automation:Monitor database performance using AWS CloudWatch, SQL Profiler, and third-party tools. Automate routine tasks using PowerShell, AWS Lambda, or AWS Systems Manager.
Collaboration:Work closely with development, DevOps, and architecture teams to integrate SQL Server solutions into cloud-based applications.
Documentation:Maintain thorough documentation of database configurations, operational processes, and security procedures.
Non-Technical
Skills:

Candidate needs to be Good Team Player
Ownership skills- should be an individual performer to take deliverables and handle fresh challenges.
Service/Customer orientation/ strong oral and written communication skills are mandate. Should be confident and capable to speak with client and onsite teams.
Effective interpersonal, team building and communication skills.
Ability to collaborate; be able to communicate clearly and concisely both to laypeople and peers, be able to follow instructions, make a team stronger for your presence and not weaker.
Should be ready to work in rotating shifts (morning, general and afternoon shifts)
Ability to see the bigger picture and differing perspectives; to compromise, to balance competing priorities, and to prioritize the user.
Desire for continuous improvement, of the worthy sort; always be learning and seeking improvement, avoid change aversion and excessive conservatism, equally avoid harmful perfectionism, 'not-invented-here' syndrome and damaging pursuit of the bleeding edge for its own sake.
Learn things quickly, while working outside the area of expertise.
Analyze a problem and realize exactly what all will be affected by even the smallest of change you make in the database.
Ability to communicate complex technology to no tech audience in simple and precise manner.
Skills

PRIMARY COMPETENCY Data Engineering

PRIMARY Oracle APPS DBA

PRIMARY PERCENTAGE 51

SECONDARY COMPETENCY Big Data Technologies

SECONDARY PostgreSQL

SECONDARY PERCENTAGE 39

TERTIARY COMPETENCY Data Engineering

TERTIARY Microsoft SQL Server APPS DBA

TERTIARY PERCENTAGE 10

More Jobs at Lorven Technologies Private Limited

EWT / Portal - Full Stack - Java,Java, Spring Boot, Maven, Angular

Bengaluru

5.0 - 10.0 yrs

INR 5 - 9 Lacs

Artificial Intelligence Engineer

Bengaluru

8.0 - 12.0 yrs

INR 8 - 12 Lacs

SFMC Developer

Chennai, Tiruchirapalli

5.0 - 10.0 yrs

INR 1 - 4 Lacs

Delivery Module Lead

Pune

6.0 - 8.0 yrs

INR 7 - 12 Lacs

Sr AWS Data Engineer

Hyderabad, Pune, Gurugram

4.0 - 6.0 yrs

INR 2 - 6 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

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

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

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

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

Lorven Technologies Private Limited

Information Technology

N/A

Login to

Please Verify Your Phone or Email

Confirm Action

Search

Profile

Upskill and Grow with AI

Oracle & MS-SQL and PostgreSQL DBA