Junior SQL Server Administrator

Description

Job Summary: The Junior SQL Server Administrator will manage, maintain, secure, and optimize databases, ensuring their availability and integrity while providing technical support. Key Highlights: 1. Manages performance optimization and process automation. 2. Defines database architectures and ensures operational continuity. 3. Provides specialized technical support to development and BI teams. **Join Our Team as a Junior SQL Server Administrator!** **Job Description:** The Junior SQL Server Administrator will be responsible for the end-to-end management, maintenance, security, and optimization of the company's databases. This role is critical in improving performance, automating processes, auditing information, performing environment migrations, and defining database architectures—ensuring the availability, integrity, and operational continuity of information systems. Additionally, they will provide specialized technical support to development, BI, and project teams. **REQUIREMENTS:** **Academic Qualifications:** * Graduate or Bachelor’s degree in Systems Engineering, Computer Science, Software Engineering, Data Science, or related fields. * Technical higher education in database administration or similar disciplines. **Required Experience:** Minimum experience working as a DBA or in database support: * **Technical graduate:** minimum 2 years. * **University bachelor’s graduate:** minimum 1 year. **Technical Competencies:** * Database engine administration (SQL Server, MySQL, PostgreSQL, or others) * **Advanced SQL proficiency:** complex queries, views, functions, stored procedures, and tuning * Installation, configuration, and updating of database instances and servers * **Advanced optimization and performance tuning:** indexes, execution plans, partitioning, jobs, monitoring * **Auditing and traceability:** log analysis, change control, activity tracking * **Database migrations:** on-premise, server-to-server, across versions, and/or to the cloud * **Database architecture:** logical/physical design, normalization, modeling, standards * **Access and security administration:** roles, permissions, encryption, compliance policies * **Automation:** creation of jobs and maintenance plans, automated backups, and scheduled tasks * **Backups and recovery:** definition, execution, and validation of disaster recovery strategies * **High availability:** clustering, replication, Always On, failover **Desirable (non-exclusive):** * Knowledge of **Azure SQL, AWS RDS, Redshift, or other cloud services** * Experience with ETL tools or data integration * Familiarity with Power BI or reporting **Personal Competencies:** * Strong analytical skills and attention to detail * Results-oriented mindset and commitment to continuous improvement * Ability to clearly and systematically document processes * Good communication and collaborative teamwork skills * Commitment to information security **Residence:** * **Preferably residing in Los Olivos or nearby districts** (Independencia, Comas, San Martín de Porres, Carabayllo, etc.). **RESPONSIBILITIES:** * Administer and maintain the company’s databases and instances * Monitor performance, availability, and security * **Optimize queries, processes, indexes, and table structures** * Audit tables, access, changes, and resource usage * Execute, validate, and **automate backup and recovery plans** * Design and execute **database migrations** across environments and servers * Define and maintain **preventive and corrective maintenance plans** * Manage **creation, modification, and control of access** to servers and databases * Participate in designing **database architectures** for new projects * Support development teams (procedures, integrations, automations) * Document diagrams, policies, incidents, and technical configurations **WORK CONDITIONS:** * **Schedule:** Monday to Friday, 8:30 a.m. to 6:30 p.m. * **Location:** On-site – Los Olivos, Lima. * **Compensation:** S/2,500.00 per month. * **Employment Type:** Full-time. **We look forward to building the future of technology together!** Job Type: Full-time Salary: S/.2,500.00 per month Application Question(s): * Indicate your level of expertise in SQL Server administration * Have you performed SQL Server database migrations between servers? * What have you directly optimized in SQL Server? Work Location: On-site employment