Sql Database Administrator

3 semanas atrás

Porto, Porto, Portugal Phiture Tempo inteiro

Decskill, founded in 2014 as an IT Consulting Company, places paramount importance on its greatest asset: its people. Our main mission is to deliver value through knowledge and talent, and we achieve this by fostering a culture of excellence and investing in the development and well-being of our people. With over 600 dedicated professionals and offices in Lisbon, Porto, Madrid, and Luxembourg, Decskill operates across three core areas:

  1. DECSKILL TALENT: We believe that our people are key to our success. Through Decskill Talent, we empower our team to embrace the digital transformation challenges of our clients. We collaborate with clients to drive innovation, ensuring project success and business growth.
  2. DECSKILL BOOST: Equipping our team with the latest tools and methodologies, we optimize Time-to-Market and deliver innovative solutions exceeding client expectations.
  3. DECSKILL CONNECT: Our team collaborates closely with clients to implement and manage IT infrastructures that generate long-term value.

At Decskill, we believe that by nurturing and empowering our people to confront the challenges of digital transformation, we create value not only for our clients but also for our entire ecosystem, fostering a digital community dedicated to growth and progress.

We are looking for an SQL Database Administrator
Responsibilities
  1. Database Migration Planning: Collaborate with customer to understand requirements, analyze existing database environments, and develop comprehensive migration strategies.
  2. Migration Execution: Perform data migration tasks, including schema conversion, data transformation, and data loading. Ensure seamless migration with minimal disruption to operations.
  3. Performance Tuning: Optimize database performance before, during, and after the migration. Identify and resolve performance bottlenecks.
  4. Backup and Recovery: Implement robust backup and recovery procedures to safeguard data during migration. Conduct post-migration validation to ensure data integrity.
  5. Database Upgrades: Plan and execute database upgrades as part of the migration process, ensuring compatibility and stability of applications.
Requirements:
  1. Professional experience as Database Administrator.
  2. Experience and knowledge of different SQL Server version.
  3. Knowledge of tools like Ola Hallengren.
  4. Understanding of reorganization versus rebuilding indexes.
  5. Statistics and update statistics backup/restore possibilities within SQL Server.
  6. Recovery Model of a database and the impact on backups, log files.
  7. System databases: which exist and for what they are used.
  8. SQL Agent: how it works, how to configure it, possibilities.
  9. Understanding of TDE (transparent database encryption).
  10. Security: default Server roles, default database roles, application roles.
  11. Basic knowledge of high-availability solutions such as clustering, always on, mirroring, log-shipping.
  12. SQL development: T-SQL, stored procedures, scalar/table valued functions, error handling, common table expressions.
  13. INNER versus OUTER JOIN versus CROSS JOIN, CROSS/OUTER APPLY.
  14. Transactions: commit and rollback, nested transactions.
  15. Foreign key, unique index versus primary key, data types and their importance.
  16. Certificates and signed objects if security.
  17. Error handling.
  18. Indexes: clustered, non-clustered, covered index, filtered index.
  19. In-memory OLTP: tables and native stored procs and functions.
  20. Inner, outer join, indexed views: pros and cons.
  21. Execution plans, query store.
  22. Good level of English.

If you're interested in this job please send your CV to ******, with the reference "DBA".

Thank you :)

Decskill is committed to equality and non-discrimination with all our talents. We recruit and promote talent, based on diversity and inclusion, regardless of age, gender, ethnicity, race, nationality or any other form of discrimination incompatible with the dignity of the human being.

#J-18808-Ljbffr

  • Sql Database Administrator

    Há 6 dias

    Porto, Porto, Portugal Jobtome-All Tempo inteiro

    Decskill, founded in 2014 as an IT Consulting Company, places paramount importance on its greatest asset: its people.Our main mission is to deliver value through knowledge and talent, and we achieve this by fostering a culture of excellence and investing in the development and well-being of our people.With over 600 dedicated professionals and offices in...

  • Sql Database Administrator

    4 semanas atrás

    Porto, Porto, Portugal Sensei Tempo inteiro

    Decskill, founded in 2014 as an IT Consulting Company, places paramount importance on its greatest asset: its people. Our main mission is to deliver value through knowledge and talent, and we achieve this by fostering a culture of excellence and investing in the development and well-being of our people. With over 600 dedicated professionals and offices in...

  • Sql Database Administrator

    3 semanas atrás

    Porto, Porto, Portugal Phiture Tempo inteiro

    Decskill, founded in 2014 as an IT Consulting Company, places paramount importance on its greatest asset: its people. Our main mission is to deliver value through knowledge and talent, and we achieve this by fostering a culture of excellence and investing in the development and well-being of our people. With over 600 dedicated professionals and offices in...

  • Sql Database Administrator

    4 semanas atrás

    Porto, Porto, Portugal Sensei Tempo inteiro

    Decskill, founded in 2014 as an IT Consulting Company, places paramount importance on its greatest asset: its people. Our main mission is to deliver value through knowledge and talent, and we achieve this by fostering a culture of excellence and investing in the development and well-being of our people. With over 600 dedicated professionals and offices in...

  • SQL Server Database Administrator Lead

    1 semana atrás

    Porto, Porto, Portugal TN Portugal Tempo inteiro

    About the RoleWe are looking for a highly skilled Microsoft SQL Server Engineer to join our team at TN Portugal. As a key member of our IT department, you will be responsible for administering, supporting, and optimizing Microsoft SQL Server databases on-premises and in the cloud.Key Responsibilities:Administer, maintain, and troubleshoot Microsoft SQL...

  • Database Administrator

    2 semanas atrás

    Porto, Porto, Portugal Timestampgroup Tempo inteiro

    Timestamp Group aggregates several leading Portuguese IT solutions and services companies around the concepts of excellence and knowledge sharing.We are committed to technological leadership, based on the quality of our service and technological solutions, supported by continuous training and certification.Role: Database Administrator (PostgreSQL/SQL...

  • Database Systems Administrator

    2 semanas atrás

    Porto, Porto, Portugal Timestampgroup Tempo inteiro

    **About Us**Timestamp Group aggregates several leading Portuguese IT solutions and services companies around the concepts of excellence and knowledge sharing.We are committed to providing high-quality services and technological solutions supported by continuous training and certification.**Job Description**We are seeking an experienced Database Administrator...

  • Enterprise Database Administrator

    Há 5 dias

    Porto, Porto, Portugal Jobtome-All Tempo inteiro

    Enterprising Opportunity:Decskill is seeking an ambitious Enterprise Database Administrator to join our team. As a key member of our IT Consulting Company, you will be responsible for managing and maintaining large-scale database systems, ensuring optimal performance, security, and availability.">About the Role:As an Enterprise Database Administrator, you...

  • SQL Database Migration Expert

    2 semanas atrás

    Porto, Porto, Portugal Sensei Tempo inteiro

    Job OverviewWe are seeking a highly skilled SQL Database Administrator to join our team. As a key member of our technical staff, you will be responsible for designing, implementing, and maintaining large-scale database systems.

  • Database Administrator

    3 semanas atrás

    Porto, Porto, Portugal Objectware Tempo inteiro

    Job DescriptionWe are seeking a highly experienced Database Administrator to support mission-critical environments across various technologies.Main ResponsibilitiesSupport the 360° database layer of multiple services on different platforms.Participate in international projects and contribute to current and future technology decisions.Requirements5+ years of...

  • SQL Database Professional

    Há 5 dias

    Porto, Porto, Portugal Jobtome-All Tempo inteiro

    **About Us**Decskill is a leading IT consulting company founded in 2014, dedicated to delivering value through knowledge and talent. We foster a culture of excellence, investing in the development and well-being of our people. Our team of over 600 professionals operates across three core areas: **DECSKILL TALENT**: We empower our team to drive digital...

  • Sql Database Administrator

    Há 7 dias

    Porto, Porto, Portugal Sensei Tempo inteiro

    .Decskill, founded in 2014 as an IT Consulting Company, places paramount importance on its greatest asset: its people.Our main mission is to deliver value through knowledge and talent, and we achieve this by fostering a culture of excellence and investing in the development and well-being of our people.With over 600 dedicated professionals and offices in...

  • SQL Database Engineer

    1 semana atrás

    Porto, Porto, Portugal Tn Portugal Tempo inteiro

    Our Team at Your ServiceTn Portugal's team is committed to delivering high-quality results through collaborative efforts. As part of our team, you will be working closely with other experts to achieve shared goals.About the RoleThis position involves contributing to our team's success by maintaining databases in operational condition, analyzing activity,...

  • Database Administrator

    4 semanas atrás

    Porto, Porto, Portugal Timestampgroup Tempo inteiro

    Timestamp Group aggregates several leading Portuguese IT solutions and services companies around the concepts of excellence and knowledge sharing.We are committed to technological leadership, based on the quality of our service and technological solutions, supported by continuous training and certification.Role: Database Administrator (PostgreSQL/SQL...

  • Database Systems Administrator

    Há 5 dias

    Porto, Porto, Portugal Jobtome-All Tempo inteiro

    **Company Overview**Decskill is a fast-growing IT consulting company committed to delivering value through knowledge and talent. Founded in 2014, we have built a strong reputation for fostering a culture of excellence and investing in the development and well-being of our people.Our team of over 600 professionals operates across three core areas: DECSKILL...

  • Database Systems Administrator

    2 semanas atrás

    Porto, Porto, Portugal Sensei Tempo inteiro

    Key ResponsibilitiesDevelop comprehensive migration strategies to ensure seamless transition of data between different database environments.Optimize database performance by identifying and resolving bottlenecks, ensuring efficient data loading and retrieval.Implement robust backup and recovery procedures to safeguard data integrity during...

  • Senior SQL Database Architect

    Há 6 dias

    Porto, Porto, Portugal Phiture Tempo inteiro

    Company OverviewDecskill, a leading IT consulting company founded in 2014, prioritizes the development and well-being of its professionals. With over 600 dedicated experts across Lisbon, Porto, Madrid, and Luxembourg, Decskill operates in three core areas:1. **Decskill Talent**: Empowering our team to drive digital transformation for clients through...

  • Cloud Database Administrator

    1 semana atrás

    Porto, Porto, Portugal Dellent Tempo inteiro

    Dellent is a consulting company dedicated to delivering high-quality solutions in System Information and Telecommunications.We are seeking a skilled DBA Administrator to join our team and work on a project related to the European stock market area.Job Description:The successful candidate will have the opportunity to collaborate with a leading global trading...

  • Entry-Level Database Administrator Role

    2 semanas atrás

    Porto, Porto, Portugal Jobbex IT Tempo inteiro

    At Jobbex IT, we are committed to providing our customers with exceptional service and support. As a Entry-Level Database Administrator, you will play a key role in ensuring the stability and performance of our databases.The successful candidate will have experience working with PL/SQL and Oracle databases, as well as strong analytical skills. They will be...

  • Database Administrator

    2 semanas atrás

    Porto, Porto, Portugal Phiture Tempo inteiro

    Seeking a Database Administrator: Rhino, are you there?At WE ARE META, we focus on finding the perfect match between our Rhinos and our clients.Why join us?Expand your network: As a consultant at We Are META, you'll have access to a network of national and international partners across diverse sectors of the tech industry.Enjoy our perks: When you join the...