Job Search


 
Information Technology (IT)
Location: Cyprus,Larnaca
Reference: 4294
Date Posted: 04/02/2020
SQL Server Developer
CareerFinders, on behalf of our client, an established and expanding IT Consultancy firm with offices in Larnaca, we are seeking to recruit an experienced and talented SQL Server Developer to join their team. The successful candidate should have extensive and demonstrable experience with Microsoft SQL Server Developer and administration experience across versions 2005/2008/2008R2/2012/2016.
Share To: 
Key Duties/Responsibilities:
 
  • 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 and troubleshooting even if the data goes around 25 million in table.
  • 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.
 
Key Skills/Experience:
 
  • 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 will be an added advantage.
  • Ability to handle the database environment 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.
  • Should have 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.
  • Have also experienced in memory grants IO, Plan cost, cache costs and also who has deep knowledge in actual execution plans and Estimated execution plans.
  • 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.
  • 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.
  • Good knowledge in Encryption, encrypting the data from Column level, table level and Database level by knowing AES, TDE and CLE.
  • 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
  • Experience in Data warehousing using SSAS / SSIS / SSRS for OLTP and OLAP will be an added advantage.

To apply for this vacancy, please send your CV, along with any covering letter to jobs@careerfinders.com.cy quoting the above job title. Please note that due to the high volumes of applications received only shortlisted applicants will be responded to. By sending us your CV you are giving CareerFinders your consent to be contacted for this and any other suitable vacancies that we believe match your skills and experience. To view our privacy policy, please click www.careerfinders.com.cy/privacy-policy
Footer Logo - CareerFinders
 
CareerFinders Location Head Office
6th Floor, Athlos Building, 28 Nikis Avenue,
Nicosia, 1086, Cyprus. License 272 

Limassol Office
Office 102, 1st Floor, 98 Pafou Road,
Limassol. 4152, Cyprus
  CareerFinders Telephone +357 22 002285