SQL Server DBA – Performance and Optimization

Description

Position Summary: We are seeking an SQL Server DBA to resolve a critical performance and growth incident in databases, with a technical focus on diagnosing, optimizing, and stabilizing the environment. Key Highlights: 1. Technical role focused on diagnosis and optimization of SQL Server databases 2. Resolution of critical performance and growth issues 3. Opportunity to generate high-impact technical recommendations A prominent company is looking for an SQL Server DBA for a short-term project (1–2 months), focused on resolving a critical performance and growth incident in databases. The role will be highly technical with immediate impact, aimed at diagnosing, optimizing, and stabilizing the environment. Job Objective: Diagnose, optimize, and stabilize the SQL Server database environment, addressing issues such as excessive resource consumption, accelerated growth, and disk saturation. Main Responsibilities: • Analyze current database usage and identify bottlenecks. • Optimize queries, indexes, and data structures. • Monitor and mitigate excessive database growth. • Propose storage strategies and efficient data management approaches. • Review processes associated with intensive resource consumption (Excel, Python, analytical processes). • Implement performance and environment stability improvements. • Generate technical recommendations to prevent recurrence of the issue. Requirements: • Degree in Computer Science or related field. • Minimum 2–3 years’ experience as an SQL Server DBA. Experience in: o Performance optimization (queries, indexes, execution plans). o Administration and maintenance of SQL Server. o Diagnosis of resource consumption and storage issues. • Desirable experience in high-volume data environments. Conditions: • Initial contract: 1–2 months (specific project). • Continuation: Subject to results and possible activation of new projects. • Work modality: 100% on-site. • Location: Las Condes, near Metro Line 1. • Working hours: Office hours. Important: The primary focus of this role is to resolve a critical incident in the short term. An autonomous, solution-oriented profile with practical experience in real-world optimization scenarios is required.-Requirements- Minimum education: University / Professional Institute / Technical Training Center. years of experience Keywords: db, bd, sql, db2, firebird, informix, interbase, oracle, postgresql, sqlserver, mozo, productividad, productivity, yield, rendimiento, optimization