SQL Server Database Administrator
Where
Sign in to see the travel time
In short AI
Senior SQL Server Database Administrator, hybrid role in Lisbon, at DataSmart, a Portuguese consulting company. Administration of SQL Server instances across On-Premises and Microsoft Azure infrastructures, with over 50 servers and 500 databases.
Description
a long ad (4,494 characters): the AI summarised it; the full text is in the next tab.
- Role
- Install, configure, administer and maintain Microsoft SQL Server environments across hybrid On-Premises and Azure infrastructures, including Development, Testing, QA and Production environments. Define and execute backup, restore and disaster recovery strategies, manage security, optimise performance, and configure replication and high availability. Collaborate with Application, Development, Business Intelligence and Infrastructure teams in Agile environments.
- Requirements
- Strong professional experience in Microsoft SQL Server database administration
- Experience with large-scale, mission-critical SQL Server environments
- Hands-on experience with hybrid On-Premises and Microsoft Azure infrastructures
- Solid knowledge of SQL Server installation, configuration, upgrades and migrations
- Experience administering Development, Testing, QA and Production environments
- Solid knowledge of backup, restore, disaster recovery and preventive maintenance
- Advanced Transact-SQL scripting and SQL Server Agent administration
- Strong understanding of security, permissions, roles and auditing
- Experience with query optimisation, execution plans, indexing and performance tuning
- Knowledge of storage management, transaction logs and capacity optimisation
- Experience with SQL Server Profiler and monitoring tools
- Solid understanding of relational data modelling
- Experience with replication and high availability (Always On, Clustering, Log Shipping, Database Mirroring)
- Knowledge of SSIS, SSAS and SSRS
- …
- Preferred
- Azure experience, Agile ceremonies (Sprint Planning, Reviews)
- Conditions
- Contract: not stated
- Salary: not stated
- Hours: not stated
- Location: hybrid, Lisbon
- Benefits
- none stated
# Think Data Be Smart #
About Us: DataSmart is a Portuguese company, positioning itself as a consulting company of excellence, with over 20 years of existence. We are specialized in Technologies and Information Systems services, for the Portuguese and International markets. We pride ourselves on fostering a culture of involvement, experience, and excellence.
Join our team as a Senior SQL Server Database Administrator (Hybrid – Lisbon)!
What You’ll Do:
- Install, configure, administer, and maintain Microsoft SQL Server environments
- Manage SQL Server instances across hybrid On-Premises and Microsoft Azure infrastructures
- Administer Development, Testing, Quality Assurance, and Production environments
- Support mission-critical database infrastructures with 50+ servers and 500+ databases
- Manage SQL Server version lifecycles, upgrades, and database migrations
- Configure and administer database data files, transaction logs, and storage allocation
- Define and execute backup, restore, and disaster recovery strategies
- Implement preventive maintenance plans to ensure database availability and performance
- Create, configure, and maintain SQL Server Agent jobs
- Manage database security, including logins, users, roles, privileges, and auditing
- Develop and maintain Transact-SQL scripts for database administration
- Optimize database performance through index maintenance, statistics updates, and query tuning
- Monitor database processes, transactions, locks, and resource utilization
- Analyze execution plans and identify performance bottlenecks
- Manage database storage, capacity planning, and file maintenance
- Support relational data modelling, including primary keys, foreign keys, cardinality, and data types
- Configure and maintain data replication and high-availability solutions, including Log Shipping, Database Mirroring, Clustering, and Always On
- Support deployments and operations involving SSIS, SSAS, and SSRS
- Collaborate with Application, Development, Business Intelligence, and Infrastructure teams
- Work with multidisciplinary teams, vendors, and partners to resolve technical challenges
- Participate in Agile ceremonies, including Sprint Planning, Reviews, and cross-functional squad activities
Qualifications:
- Strong professional experience in Microsoft SQL Server Database Administration
- Proven experience managing large-scale, mission-critical SQL Server environments
- Hands-on experience with hybrid On-Premises and Microsoft Azure database infrastructures
- Strong knowledge of SQL Server installation, configuration, upgrades, and migrations
- Experience administering Development, Testing, QA, and Production environments
- Solid knowledge of backup, restore, disaster recovery, and preventive maintenance strategies
- Advanced Transact-SQL scripting and SQL Server Agent administration skills
- Strong understanding of database security, permissions, roles, and auditing
- Experience with query optimization, execution plans, indexing, statistics, and performance tuning
- Knowledge of database storage management, transaction logs, and capacity optimization
- Experience with SQL Server Profiler and database monitoring/troubleshooting tools
- Solid understanding of relational data modelling and database design principles
- Experience with replication and high-availability technologies, including Always On, Clustering, Log Shipping, and Database Mirroring
- Knowledge of SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS)
- Strong analytical, troubleshooting, and problem-solving skills
- Excellent communication and collaboration skills
- Experience working with multidisciplinary teams in Agile environments
At DataSmart, you will have the opportunity to integrate into a solid company and participate in projects of high recognition, nationally and internationally, with an appealing technological environment and career progression.
Excellence in the way to the future!
Connect with Us: Follow us on LinkedIn for updates on career opportunities, company news, and industry insights! For further details, visit us at www.datasmart.pt
#JoinOurTeam #DataSmart #ThinkDataBeSmart #SQLServer #SQLServerDBA #DatabaseAdministrator #MicrosoftSQLServer #Azure #DatabaseAdministration
Do you accept the challenge?
We are waiting for you!
How to apply
Apply via the form in the advert, with name, email, contact and curriculum vitae (required). More information at www.datasmart.pt. AI
Prepare your application
A cover letter and a short pitch for this job, written from your profile, and what to learn next.
Sign in and create your profile from your CV. It is private: we share it with no one.
Something wrong or unlawful in this ad? Report it
Similar jobs
- SQL Server Database AdministratorDataSmart · Lisboa
- SENIOR MICROSOFT SQL SERVER DATABASE ADMINISTRATOR (DBA)iTRTech Group · Lisboa
- Database AdministratorSmart Consulting · Lisboa
- Senior SQL Server Database Administrator – Cloud & High Availability ExpertiseITDS Portugal · Lisboa
- Senior Azure SQL Database AdministratorITDS Portugal · Matosinhos
- Senior SQL Server DBA & ArchitectITDS Portugal · Lisboa
Salary compared ⓘ
26 jobs · Database designers and administrators · Lisboa district
see the best paid →Training for this job
- DP-3001: Migrate SQL Server workload to Azure SQLGalileuonline · daytime · 7 h · 560 € + IVA · starts 11/12/2026Asked for in this ad: SQL and databases
- DP-300: Implement scalable database solutions using Azure SQLRumosonline · daytime · 28 h · 1,670 € · starts 23/11/2026Asked for in this ad: SQL and databases
- Criar a estrutura de uma base de dados e programar em SQLCESAE Digitalonline · evenings · 50 h · freeAsked for in this ad: SQL and databases
Published on (1)
- DataSmart seen 22 Nov
Where the company is see on the map →
- Lisboa (Lisboa) ≈ 38 jobs · 1 on the company's website (office) · OSM · Google Maps
- Porto (Porto) 12 jobs
- Braga (Braga) ≈ 4 jobs · 1 on the company's website (office) · OSM · Google Maps
- Coimbra (Coimbra) 4 jobs
according to the company's other jobs, the addresses on the company's website; consultancy: the work is often at a client's premises; these are the addresses of the consultancy's offices. ≈ approximate point (only the locality or the postcode is known).
First seen on 22 Nov, 14:47