848 Piktorlabs Jobs
Specialist I - Cloud Infrastructure Services
Piktorlabs
posted 7d ago
Flexible timing
Key skills for the job
Resolve complex trouble tickets spanning across different technologies and fine tune infrastructure for optimum performance and/or provide technical and people leadership (Hierarchical or Lateral)
Outcomes:
Measures of Outcomes:
Outputs Expected:
Resolution:
Troubleshooting:
Escalation/Elevation:
Tickets Backlog/Resolution:
Installation:
Runbook/KB:
Collaboration:
Stakeholder Management:
Strategic:
Process Adherence:
Process/efficiency Improvement:
Process Implementation:
Compliance:
Training:
Performance Management:
Skill Examples:
Knowledge Examples:
1) Good understanding of customer infrastructure and related CIs.
Role - Oracle DBA/MSSQL DBA Job Description Responsibilities: Install, configure, and maintain MSSQL Server and Oracle instances and databases. Proactively monitor database systems to ensure optimal performance including database tuning, query optimization, and capacity planning for both MSSQL and Oracle environments. Perform routine maintenance tasks such as index rebuilds, database consistency checks, etc. Develop and implement database backup and recovery strategies for MSSQL and Oracle databases. Troubleshoot and resolve database-related issues, including errors, performance bottlenecks, and connectivity problems. Plan and execute database upgrades and apply patches for MSSQL and Oracle environments. Collaborate with application team to support database-driven applications and projects. Develop and maintain documentation, including database schemas, configurations, and standard operating procedures for both MSSQL and Oracle environments. Implement and manage database security and access controls for MSSQL and Oracle environments. Strong experience in Azure, Azure SQL environments. Qualifications: 8-9 years of experience as a Database Administrator with proficiency in managing MSSQL Server and Oracle databases in production environments. Strong knowledge on database architecture, administration, and performance tuning for both MSSQL and Oracle. Strong knowledge on Oracle/MSSQL database version upgradation. Proficiency in SQL and PL/SQL programming languages. Strong understanding of database management principles, including backup and recovery, performance tuning, and database security for both MSSQL and Oracle. Strong communication and interpersonal skills, with the ability to work effectively in a team environment. Certification on MSSQL Database Administration and Oracle Certified Professional (OCP) is a plus.
Employment Type: Full Time, Permanent
Read full job descriptionPrepare for Specialist roles with real interview advice