Sql Database Administrator

2 semanas atrás

Coimbra, Coimbra, 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 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 AdministratorResponsibilities:
  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 versions.
  3. Familiarity with dbsupport tools of Ola Hallengren.
  4. Understanding of index management: reorganize versus rebuild, statistics and update statistics.
  5. Knowledge of backup/restore possibilities within SQL Server.
  6. Understanding of Recovery Model of a database and the impact on backups and log files.
  7. Familiarity with system databases and their uses.
  8. Understanding of SQL Agent: how it works, how to configure it, and its possibilities.
  9. Knowledge of TDE (transparent database encryption).
  10. Basic security knowledge: 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 skills: T-SQL, stored procedures, scalar/table valued functions, error handling, common table expressions, INNER versus OUTER JOIN versus CROSS JOIN, CROSS/OUTER APPLY.
  13. Understanding of transactions: commit and rollback, nested transactions.
  14. Knowledge of foreign keys, unique index versus primary key, data types and their importance.
  15. Familiarity with certificates and signed objects in security.
  16. Understanding of indexes: clustered, non-clustered, covered index, filtered index.
  17. Knowledge of in-memory OLTP: tables and native stored procedures and functions.
  18. Understanding of indexed views: pros and cons.
  19. Familiarity with execution plans and query store.
  20. 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á 2 dias

    Coimbra, Coimbra, Portugal Decskill 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

    Há 3 dias

    Coimbra, Coimbra, 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

    1 semana atrás

    Coimbra, Coimbra, 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...

  • Database Administrator Specialist

    Há 2 dias

    Coimbra, Coimbra, Portugal Decskill Tempo inteiro

    **About Decskill**We are a leading IT consulting company that prioritizes knowledge and talent. Our mission is to deliver value through expertise, fostering excellence and investing in the growth and well-being of our professionals.With over 600 dedicated experts across three core areas – Talent, Boost, and Connect – we empower our team to drive digital...

  • SQL Server Migration Expert

    1 dia atrás

    Coimbra, Coimbra, Portugal Decskill Tempo inteiro

    Job OverviewAs a key member of our team, you will be responsible for planning and executing database migrations, ensuring seamless transitions with minimal disruption to operations.You will optimize database performance, implement robust backup and recovery procedures, and plan and execute database upgrades as part of the migration process.We require an...

  • Relational Database Management Professional

    1 dia atrás

    Coimbra, Coimbra, Portugal Decskill Tempo inteiro

    Main ResponsibilitiesCollaborate with customers to understand migration requirements and develop comprehensive strategiesPerform data migration tasks, including schema conversion, data transformation, and loadingOptimize database performance before, during, and after migrationImplement robust backup and recovery procedures to safeguard dataPlan and execute...

  • Database Systems Administrator

    Há 5 dias

    Coimbra, Coimbra, Portugal Vopak Tempo inteiro

    Company Overview">Vopak is a leading company in the energy transition and energy security sectors. We are committed to creating a safe, pleasant, and inclusive work environment where equality, diversity, and satisfaction are of paramount importance.">What You Will Do as a Data Engineer for Operations">You will play a crucial role in ensuring the efficiency,...

  • SQL Database Administrator

    Há 5 dias

    Coimbra, Coimbra, Portugal Adentis Portugal Tempo inteiro

    About the RoleWe are looking for a skilled BI Analytics Application Support specialist to join our team. The ideal candidate will have a strong background in SQL, PL/SQL, and Unix environment administration, as well as practical experience with job scheduling tools like ControlM.Key ResponsibilitiesManage and provide technical support for our BI and...

  • Cloud Database Administrator

    Há 2 dias

    Coimbra, Coimbra, Portugal Vopak Netherlands Tempo inteiro

    Required Skills and QualificationsMore than 2 years of operations experience, preferably with cloud technologies and cloud storage.Strong knowledge of SQL Server, PostgreSQL, and MongoDB.In-depth understanding of query optimization, indexing strategies, and execution plans.Affinity with development tools and programming languages.A college or academic degree...

  • Database Operations Expert

    Há 6 dias

    Coimbra, Coimbra, Portugal Vopak Tempo inteiro

    **Job Description**The successful candidate will support our software development team by ensuring the efficiency, stability, and security of our database environment. With advanced SQL development skills and expertise in database management, particularly within Microsoft SQL Server, you will focus on optimizing query performance, automating operations, and...

  • Oracle Database Expert with Performance Tuning Skills

    Há 6 dias

    Coimbra, Coimbra, Portugal SGF Global Tempo inteiro

    About SGF Global:We are a global company providing IT solutions and services. Our team is comprised of experienced professionals who deliver high-quality projects to our clients.The position of Senior Oracle Database Administrator is available due to the growth of our business and the need for additional resources to support our clients' databases.The key...

  • Cloud Database Specialist

    Há 4 dias

    Coimbra, Coimbra, Portugal Vopak Tempo inteiro

    Join Our Team as an Operations Engineer">We are looking for a skilled Operations Engineer to join our team at Vopak. As an Operations Engineer, you will play a critical role in ensuring the efficiency, stability, and security of our database environment.">Your Key Responsibilities">">Optimize database queries and indexes">Automate operations to ensure smooth...

  • Developer Pl/Sql

    1 semana atrás

    Coimbra, Coimbra, Portugal Decskill 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...

  • Highly Experienced Oracle DBA for Global Company

    Há 6 dias

    Coimbra, Coimbra, Portugal SGF Global Tempo inteiro

    We are looking for an experienced Oracle DBA to join our team in Almada, Portugal. As a Senior Oracle Database Administrator, you will be responsible for ensuring the optimal performance and security of databases for our clients.Your key responsibilities will include:Database administration and maintenance;Performance tuning and optimization;Backup and...

  • DBA Oracle Senior

    Há 7 dias

    Coimbra, Coimbra, Portugal SGF Global Tempo inteiro

    SGF Global is looking for a DBA Oracle Senior to work for one of our clients in Almada (Portugal)They deliver the following solutions:- Performance Services- IT Administration- Software Engineering and Architecture Services- DevOps and SRE ServicesResponsibilities:- Administration, access management, installations, upgrades, migrations, encryption...

  • SAS Data Analytics Expert

    Há 7 dias

    Coimbra, Coimbra, Portugal Phiture Tempo inteiro

    Role Summary:We are seeking an experienced Data Insights Specialist to join our team. As a key member of our analytics team, you will work with SAS Base, SAS Enterprise Guide, and SAS Visual Analytics to deliver actionable insights. You will have a strong understanding of SQL and be able to develop and maintain databases. Excellent communication skills and a...

  • Operations Specialist

    Há 2 dias

    Coimbra, Coimbra, Portugal Vopak Netherlands Tempo inteiro

    Salary and BenefitsA gross salary between €30K- €45K depending on your experience, knowledge and seniority in the roleBonus opportunityThis position can be located in Lisbon, Coimbra or Castelo Branco30 holidays;Home office budgetGood career opportunitiesJob DescriptionAs an Operations Engineer, you will support product teams with database-related...

  • Full Stack C# Developer

    Há 6 dias

    Coimbra, Coimbra, Portugal Sensei Tempo inteiro

    We are looking for a highly skilled Full Stack C# Developer to join our team at Decskill. The successful candidate will be responsible for designing, developing, and maintaining complex software applications using C#, ASP.NET, and SQL Server.The ideal candidate will have a strong background in software development with a minimum of 4 years of experience in...

  • Data Pipeline Expert Wanted

    Há 19 horas

    Coimbra, Coimbra, Portugal JobFinder Spain Tempo inteiro

    Responsibilities:We're looking for a talented individual to join our team as a Senior Data Engineer. Your primary focus will be on building data reports, identifying performance bottlenecks, communicating with Engineering & Product management, and aligning with existing development teams. The ideal candidate will have strong analytical SQL knowledge and...

  • Senior Software Engineer

    Há 6 dias

    Coimbra, Coimbra, Portugal Sensei Tempo inteiro

    We are looking for a highly skilled Senior Software Engineer to join our team at Decskill. The successful candidate will be responsible for designing, developing, and maintaining complex software applications using C#, ASP.NET, and SQL Server.The ideal candidate will have a strong background in software development with a minimum of 4 years of experience in...