Overview
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:
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.
Decskill Boost:
Equipping our team with the latest tools and methodologies, we optimize Time-to-Market and deliver innovative solutions exceeding client expectations.
Decskill Connect:
Our team collaborates closely with clients to implement and manage IT infrastructures that generate long-term value.
We are looking for an SQL Database Administrator!
Responsibilities
Database Migration Planning: Collaborate with customer to understand requirements, analyze existing database environments, and develop comprehensive migration strategies.
Migration Execution: Perform data migration tasks, including schema conversion, data transformation, and data loading.
Ensure seamless migration with minimal disruption to operations.
Performance Tuning: Optimize database performance before, during, and after the migration.
Identify and resolve performance bottlenecks.
Backup and Recovery: Implement robust backup and recovery procedures to safeguard data during migration.
Conduct post-migration validation to ensure data integrity.
Database Upgrades: Plan and execute database upgrades as part of the migration process, ensuring compatibility and stability of applications.
Requirements
Professional experience as Database Administrator.
Experience and knowledge of different SQL Server versions.
Dbsupport: Tools of Ola Hallengren
Reorganize versus rebuild indexes
Statistics and update statistics backup/restore possibilities within SQL Server
Recovery Model of a database and the impact on backups, logfiles
System databases: which exists and for what are they used
SQL Agent: how does it work, how to configure it, possibilities
What is TDE (transparent database encryption)
Security: default Server roles Default database roles
Application roles
Basic knowledge of high-availability solutions such as clustering, always on, mirroring, log-shipping
SQL development: T-SQL, Stored procedures, scalar/table valued functions, error handling
Common table expressions
INNER versus OUTER JOIN versus CROSS JOIN
CROSS/OUTER APPLY
Transactions: commit and rollback, nested transactions
Foreign key, Unique index versus primary key
Data types and their importance
Certificates and signed objects in security
Identity
Indexes: clustered, non-clustered, covered index, filtered index
In-memory OLTP: tables and native stored procs and functions
Indexed views: pros and cons
Execution plans
Query store
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