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).
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
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