
SMSTR64
Full Job Description
We are seeking an experienced Database Administrator (SMSTR64 - Software Engineer) to manage and optimize enterprise database environments, cloud infrastructure, and automation solutions at SmartStream in Pune.
Key Responsibilities:
<-- -->
DATABASE ADMINISTRATION: Manage, monitor, and maintain enterprise databases. Perform installation, configuration, upgrades, patching, migrations, archiving, purging, data masking, security management, and capacity planning.
PERFORMANCE TUNING: Optimize performance using AWR, ASH, Explain Plans. Resolve slow SQL queries and bottlenecks through proactive monitoring.
LINUX ADMINISTRATION: Administer RHEL/CentOS/Ubuntu servers including installation, troubleshooting, file system management, networking, security hardening, and shell script automation.
PYTHON PROGRAMMING & AUTOMATION: Develop Python scripts for database automation, monitoring, reporting, API integration with cloud services, and DevOps/Infrastructure-as-Code workflows.
AWS INFRASTRUCTURE. Deploy and manage EC2, RDS, S3, VPC, IAM, CloudWatch, Lambda, ECS/EKS, Route53 with security best practices.
AI TOOLS & MODERN TECHNOLOGIES: Utilize AI tools (Copilot, Claude, Amazon Q) for automation workflows, troubleshooting, documentation, and productivity enhancement. Evaluate emerging technologies to improve efficiency.
COLLABORATION & SUPPORT: Work with application teams and developers. Provide L2/L3 production support, create technical documentation/SOPs, and participate in incident management.
<--
- Support large-scale enterprise production environments. --/>
Foundit
Practice this interview
A voice mock interview for SMSTR64 - Software Engineer at SmartStream, with questions from this job description and your resume, and a scored report afterwards.
Set up interview