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 licencjackie
Branża: Praca IT - Bazy danych
Job specification:
- Operating SQL databases ensuring that systems are running optimally (availability, efficiency and recoverability)
- Designing, planning and implementation of new SQL Server estates
- Consolidation/expansion of existing services
- Designing and implementing monitoring solutions for SQL databases
- Develop and maintain automation scripts for daily operations
- Ability to establish alliances with other teams through recognition of dependencies
- Ensuring security and privacy policy
- Acting as an expert to client and development staff in all phases of the development and implementation process
Requirements:
- Expertise in managing SQL Server 2005, 2008, 2012, 2014
- 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
- Organizational proficiencies to multitask and work in a fast-paced environment with minimum supervision
- Team player with the ability to interact with multiple levels of personnel within the organization
Nice to have:
- SQL Server certified professional
- ITIL certified
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