SQL Server Database Administrator
# 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