Software Engineer

Smartstream Limited; Pune District; On-site; INR 700,000 - 1,200,000; Full time

Job summary

Smartstream Limited is seeking an experienced Database Administrator to manage and optimize enterprise database environments, cloud infrastructure, and automation solutions. The role focuses on Oracle and PostgreSQL with emphasis on performance tuning, Linux administration, Python automation, and AWS integration.

You will work across DB administration, performance analysis, Linux systems, and AI-assisted tooling to support business-critical applications.

Qualifications

• Experience managing Oracle, PostgreSQL databases in enterprise environments.
• Knowledge of database installation, upgrades, patching, migrations.
• Experience with backup/recovery, HA/DR, security and compliance.

Responsibilities

• Manage, monitor, and maintain Oracle, PostgreSQL, or other enterprise databases.
• Perform installation, configuration, upgrades, patching, and migrations.
• Implement backup, recovery, HA, and DR solutions.
• Monitor health, capacity, and storage utilization.
• Database archiving, purging, and data masking.
• Ensure database security and user management.

Skills

Database administration

Performance tuning

Linux systems

Python development

AWS cloud

Automation

DevOps

AI tools

Scripting

Tools

Oracle

PostgreSQL

Job description

Description

Job Description - Database Administrator

We are seeking an experienced and highly motivated professional to manage and optimize enterprise database environments, cloud infrastructure, and automation solutions. The ideal candidate will possess strong expertise in database administration, performance tuning, Linux systems, Python development, AWS cloud services, and modern AI tools to support business-critical applications and infrastructure.

Key Responsibilities

Database Administration :

• Manage, monitor, and maintain Oracle, PostgreSQL, or other enterprise databases.


• Perform database installation, configuration, upgrades, patching, and migrations.


• Implement backup, recovery, high availability (HA), and disaster recovery (DR) solutions.


• Monitor database health, capacity planning, and storage utilization.


• Database Archiving, purging and data masking.


• Ensure database security, user management, and compliance standards.

Performance Tuning

• Analyze and optimize database performance using AWR, ASH, Explain Plans, Query Optimization, and indexing strategies.


• Investigate and resolve slow-running SQL queries and application bottlenecks.


• Perform proactive performance monitoring and system health assessments.

Linux Administration

• Administer Linux servers (RHEL, CentOS, Ubuntu, Amazon Linux).


• Perform server installation, configuration, troubleshooting, and patch management.


• Manage file systems, process monitoring, networking, security hardening, and user administration.


• Develop shell scripts for automation and operational efficiency.

Python Programming & Automation

• Develop Python scripts and utilities for database automation, monitoring, and reporting.


• Build automation workflows for infrastructure provisioning and maintenance tasks.


• Integrate APIs and cloud services using Python.


• Support DevOps and Infrastructure-as-Code initiatives.

AWS Infrastructure

• Deploy, and manage AWS-based infrastructure.


• Administer services including EC2, RDS, S3, VPC, IAM, CloudWatch, Lambda, ECS/EKS, and Route53.


• Implement security best practices, monitoring, backup, and disaster recovery strategies.

AI Tools & Modern Technologies

• Utilize AI-powered tools such as Microsoft Copilot, Claude, GitHub Copilot, Amazon Q, and AI-based monitoring platforms.


• Develop AI-assisted automation and operational workflows.


• Leverage AI tools for troubleshooting, documentation, coding assistance, and productivity enhancement.


• Evaluate emerging AI technologies to improve operational efficiency.

Collaboration & Support

• Work closely with application teams, developers, architects, and business stakeholders.


• Provide L2/L3 support for production environments.


• Create technical documentation, SOPs, and knowledge base articles.


• Participate in on-call support and incident management processes.

Experience

• 2 to 4 years of experience in Database Administration and Infrastructure Management.


• Experience supporting large-scale enterprise production environments.