Database Administrator (Cloud DBA / Data Strategist)

Description

Job Summary: Servinform is seeking a Database Administrator (Cloud DBA / Data Strategist) for its Digital Transformation team, focused on designing and orchestrating distributed, hybrid, and serverless ecosystems. Key Highlights: 1. Design and provision of efficient and scalable database services 2. Ensure data integrity, availability, and security 3. Proactive database performance optimization **Description:** ---------------- At Servinform, we are a leading company in business transformation services, with over 9,000 professionals and a presence in Madrid, Sevilla, Barcelona, Valencia, and Bilbao. We manage projects for more than 600 client companies, committed to innovation, technology, and continuous development. Currently, our IT Department seeks to incorporate a Database Administrator (Cloud DBA / Data Strategist) into the Digital Transformation team. At Servinform, data is the cornerstone of our intelligent automation services (RPA, IDP, STT/TTS, text analytics, AI/GenAI, etc.). We seek a DBA who has evolved from traditional operational maintenance to data strategy and reliability engineering. This profile will not only administer servers but also design and orchestrate distributed, hybrid, and serverless ecosystems that power our AI and GenAI solutions. Our IT department is growing—if you want to develop your career within a solid company with expansion expectations, this is your opportunity. What will be your **responsibilities**? * Service Design and Provision: Collaborate with architects and developers to design efficient and scalable database schemas. o Implement and configure database management systems (DBMS) in on-premises and cloud environments (Cloud SQL, Azure SQL, BigQuery). Design high-availability and disaster recovery architectures (Always On, Data Guard, Repmgr) to ensure business continuity. * Administration and Maintenance: Ensure the integrity, availability, and security of corporate and customer data. Design and validate backup and recovery strategies. Manage the data lifecycle, including complex migrations between on-premises platforms and the cloud. * Performance Optimization: Perform proactive performance tuning (tuning) by analyzing execution plans and optimizer statistics. Optimize storage and compute in columnar environments such as BigQuery, applying partitioning and clustering to improve cost efficiency. Manage advanced memory configurations (shared_buffers, work_mem) in PostgreSQL environments. * AI Support and Incident Resolution: Enable AI capabilities within the database, such as AI Vector Search for semantic similarity searches in Oracle 23ai or BigQuery. Diagnose and resolve locks, deadlocks, and real-time performance incidents. What do we offer? * Working hours: Monday to Thursday, 9 a.m. to 6 p.m.; Fridays, 8 a.m. to 4 p.m. * Hybrid work model * Integration into a rapidly developing team with a positive working environment. * Permanent contract * Salary negotiable based on experience and expertise * Employee benefits and discount portal * Consulting agreement * Location: Pisa Industrial Park, Mairena del Aljarafe (Sevilla) \*\*No sector of our society can be understood without gender equality and the inclusion of people with disabilities. Therefore, at Grupo Servinform, we view equality and diversity as essential drivers of social progress, working daily to achieve this goal. **Requirements:** --------------- MANDATORY REQUIREMENTS Main Responsibilities and Functions * Service Design and Provision: o Collaborate with architects and developers to design efficient and scalable database schemas. o Implement and configure database management systems (DBMS) in on-premises and cloud environments (Cloud SQL, Azure SQL, BigQuery). o Design high-availability and disaster recovery architectures (Always On, Data Guard, Repmgr) to ensure business continuity. * Administration and Maintenance: o Ensure the integrity, availability, and security of corporate and customer data. o Design and validate backup and recovery strategies. o Manage the data lifecycle, including complex migrations between on-premises platforms and the cloud. * Performance Optimization: o Perform proactive performance tuning (tuning) by analyzing execution plans and optimizer statistics. o Optimize storage and compute in columnar environments such as BigQuery, applying partitioning and clustering to improve cost efficiency. o Manage advanced memory configurations (shared_buffers, work_mem) in PostgreSQL environments. * AI Support and Incident Resolution: o Enable AI capabilities within the database, such as AI Vector Search for semantic similarity searches in Oracle 23ai or BigQuery. o Diagnose and resolve locks, deadlocks, and real-time performance incidents. DESIRED REQUIREMENTS * Oracle Database: Physical database profiling, mastery of multitenant architecture (CDB/PDB), RMAN management, and advanced diagnostics using AWR/ASH reports. * Microsoft SQL Server: Experience with the BI trilogy (SSIS, SSRS, SSAS), complex ETL processes, and Always On availability group management. * PostgreSQL: In-depth engine knowledge, extension handling (pg_stat_statements), and graphical tools such as pgAdmin. * Cloud Computing: Experience administering data services on Google Cloud (Bigtable, Spanner) and Azure Database. * Automation: Ability to develop scripts in Python or PowerShell and use infrastructure-as-code tools (Terraform/Ansible) to automate repetitive tasks. * Security: Implementation of encryption (TDE, SSL/TLS), identity management (IAM), and regulatory compliance with laws such as GDPR. EDUCATION AND CERTIFICATIONS (DESIRABLE) * Bachelor's degree in Computer Engineering or related field. * Google Professional Cloud Database Engineer or Professional Data Engineer. * Microsoft Azure Database Administrator Associate (DP-300). * Oracle Database Administration Certified Professional. * EDB PostgreSQL Professional.