SQL Developer

Location Cyprus
Job Type Exclusive
Salary Attractive
Reference 28833

My client in the Software Development industry is looking for an Experienced SQL Server Developer to join their team in their Cyprus based office.

They offer a range of cutting-edge solutions to help companies improve their competitiveness and deliver the best experiences and innovative solutions.

They are a familiar sized business, specializing on gaming platforms (Spots book and Casino).

 

Tasks:

  •  Ability to handle the database environment as individual contributor for designing and trouble shooting

  •  Ability to diagnose server reliability, performance issues and fine tune those issues starting from Index level, Table level and Database level.

  •  Ability to handle the deadlocks, locks, blocks and design the flow of the objects and queries in sequenced way.

  •  Ability to design the Cost Threshold, MaxDOP, Legacy Cardinality, Asynchronous statistics, Parameter sniffing and Query Store

  •  Running of SQL Profiler, Extended Events and querying server to identify performance problems on servers experiencing bottlenecks.

  •  Finding DMV queries to answer questions about server-level performance at instant and troubleshooting even if the data goes around 25 million in table

  •  Ability to plan activities like Installation, Upgradation (In-Place, Side by Side), Service Packs, Patches (QFE, CU & GDR), configuration settings in SQL Server and also handled with missing .msi & .msp files

  •  Create databases and database objects and should have worked in Transact-SQL, like creating stored procedures, views, functions (UDF), Triggers and writing Ad-hoc queries for project maintenance.

  •  Create Schema, Synonym, Sequence, Assembly and CLR based on the requirements.

  •  Implementation of SQL Logins, Users and Authentication Modes as a part of Security Policies for various categories of Clients

  •  Perform Integrity checks for databases to overcome vulnerability to corruption.

  •  Configure SQL Jobs and SQL Auditing from login to user level changes.

  •  Designing and monitoring of comprehensive Backup plan and recovery strategies.

  •  Troubleshooting of SQL server instances on failure.

  •  Figuring out the exact reasons for performance issue and sorting out based on the project environment also Rebuilding/Reorganize the indexes based on the fragmentation level for better performance

  •  Ability to design the requirement from database level as individual performer after discussing with other application development teams, also experienced working in a team-oriented and collaborative environment

  •  Ability to present ideas in user-friendly language and to prioritize and execute tasks in a high-pressure environment

 

 

 

Requirements

  •  8 - 10 years Microsoft SQL Server Developer and administration experienced in ?across version of 2005/2008/2008R2/2012/2016

  •  Degree in one of the following subject areas: Computer Science, Business Administration, Information Technology or related field preferred

  •  Microsoft certifications (70-461 Development & 70-462 Administration) would definitely be an added advantage

  •  Deep knowledge about Indexes and Performance tuning like handle the memory spills, Disk IO, hash join, RID Lookup, Key Lookup, Table scan, Index scans, parallelism, adaptive join in SQL Server.

  •  Good Understanding in SLQ Server Wait_info/ Wait_Types.

  •  Experienced in memory grants IO, Plan cost, cache costs and also who has deep knowledge in Actual execution plans and Estimated execution plans.

  •  Good knowledge in Encryption, encrypting the data from Column level, table level and Database level by knowing AES, TDE and CLE

  •  Deep knowledge in implementing In-Memory OLTP and table Partitioning for databases based on business needs.

  •  Experience in SQL Server Disaster Recovery and High Availability setups will be an added advantage.

  •  Knowledge in SQL Server Mirroring and Replication will be an added advantage

  •  Experiences in Data warehousing using SSAS / SSIS / SSRS for OLTP and OLAP will be an added advantage.

  •  Experience with data management and data processing flow charting techniques

  •  On-call troubleshooting experience with at least one production SQL Server for a year. You don’t have to be the only DBA or have DBA in your job description, but you should have been the one person that the company would call if the SQL Server service stopped working

  •  Knowledge of reporting and query tools and practices. Knowledge of standard Reports from SQL Server.

  •  Good understanding of the organization’s goals and objectives, also having good interpersonal, written, Technical documentation and oral communication skills

 

Benefits

  •  Family atmosphere & close-knit team

  •  Employees are well looked after

  •  Relocation package

  •  Accommodation provided

  •  Flights to home country every 3 months (paid for by company)

  •  Competitive Salary

Apply Now