Rodzaj pracy: Pełny etat
Rodzaj umowy: Na czas nieokreślony
Ilość wakatów: 1
Minimalne doświadczenie: Od 5 do 10 lat
Wykształcenie: Wyższe inżynierskie
Branża: Praca IT - Bazy danych
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, 2014, 2016
- 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 SQL Server monitoring utilities such as Idera SQLdm, BMC Patrol, NewRelic, Spotlight, SQLSentry
- Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention
- Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering
- Experience with AlwaysON Availability groups, clustering, replication, log shipping, mirroring and storage replication technologies
- Expert experience in implementing operational automation
- Strong knowledge of indexes, index management, integrity checks, configuration, patching
- Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)
- Solid acquaintance with windows server, security delegation, SPNs, storage components
- 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
Nice to have:
- SQL Server certified professional
- ITIL certified
We offer:
- A promising career path and individual development plan
- A large number of career opportunities in different business areas
- Cooperation with young, energetic and craving for knowledge colleagues just like you
- The opportunity to build strong and meaningful relationships with clients and influence their business
- The best medical cover on the market with free dental care
- Generous and competitive benefits package (multisport cards, insurance, vouchers – find out what else is waiting for you!)
- Offices in close proximity to Krakow’s city center
- The chance to participate in social events and charity actions