Rodzaj pracy: Pełny etat
Rodzaj umowy: Na czas nieokreślony
Ilość wakatów: 1
Minimalne doświadczenie: Od 3 do 5 lat
Wykształcenie: Wyższe licencjackie
Branża: Praca IT - Bazy danych, Praca IT - Hardware / Information Systems, Praca IT - Konsulting
For our client, an American company providing services in the field of risk management, insurance, consulting and outsourcing in the area of human capital management, we are searching specialist for SQL Server DBA.
In this role you will be working within a team in Krakow regional hub, implementing and supporting database solutions as well as providing production and project DBA responsibilities. This will include upgrades, migration, implementation, setting security, management, configuration, performance tuning and optimization and general BAU activities.
Job specification:
- Operate SQL databases ensuring that systems are running optimally ensuring availability, efficiency and recoverability
- Designing, planning and implementation of new SQL Server estate
- Consolidation/expansion of existing services
- Design and implement monitoring solutions for SQL databases
- Develop and maintain automation scripts for daily operations
- Ability to establish alliances with other teams through recognition of dependencies
- Ensure security and privacy policy follows best practices
- Acts as an expert technical resource to client and development staff in all phases of the development and implementation process
Requirements:
- Expertise in managing SQL Server 2005, 2008 2012
- Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
- Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools
- Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention
- Knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication
- Experience with AlwaysON Availability groups, clustering, replication, log shipping, mirroring and storage replication technologies
- Expert experience in implementing operational automation
- Knowledge of how indexes, index management, integrity checks, configuration, patching
- Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)
- Service Management expertise using SNow will be considered a plus, but not required
- Working knowledge of Business Intelligence (BI) platforms including SSIS, SSAS and SSRS
- Any skills in open source and/or No SQL databases
- Experience with Cloud database hosting providers AWS EC2, Azure VM and Azure SQL Database will be an advantage
We offer:
- Work in multinational team
- Possibility to extend your professional portfolio with trainings, access to technical documentation and day to day cooperation with team of experts
- The opportunity to build strong and meaningful relationships with clients and influence their business
- Comfortable work conditions
- The best medical cover on the market with free dental care
- Generous and competitive benefits package (multisport cards, insurance, vouchers )
- Offices in close proximity to Krakow’s city center
- The chance to participate in social events and charity actions