Job Description

Responsibilities/Tasks:

• Develop complex T-SQL queries, Stored Procedures and Triggers.
• Assist in the design of the relational database architecture for new development projects.
• Develop new / alter existing SQL objects based off a set of requirements.
• Troubleshoot SQL objects that fail.
• Support the development team in troubleshooting application performance using SQL profiler and optimizing SQL queries or tuning indexing.
• Service requests from business, which include changes to processes or ad hoc data requests.
• Develop according to set coding standards and processes.
• Collaborate with Business Analysts to define scope and goals, track milestones, decide priorities, and report regularly to PMs, team leaders and BAs.
• Work with Business Analysts to identify and understand source data systems.
• Contribute to all phases of the SDLC process extending from requirements gathering and design to development, testing and deployment.
• Investigate and fix production issues.
• Develop and test extraction, transformation and load processes.
• Work in a very data driven environment and use data analysis skills to anticipate and fix bugs.
• Support production databases.
• Monitor production databases regularly or respond to any database issues by bringing down the database or taking the database offline.
• Monitoring or optimizing the performance, security, backup, recovery or integrity of database management systems.

Requirements:

• Relevant degree or diploma in computer information systems, computer science, data analytics, data management, engineering, mathematics or statistics
• Relevant Microsoft Certification (SQL developer/Azure) will be beneficial.
• 5 years relevant experience as a SQL developer as part of a team in a software development environment, with the main focus of work being database development in SQL Server.
• Contributed to the development of software applications that are deployed to a working production environment.
• Ability to work in a team environment: Follow mentorship/provide team leader mentorship, collaborate on a common (UML) design model.
• A good understanding of the SDLC process, tools and techniques specifically as applied to software development methodology.
• Experience working with security sensitive data (beneficial)

Skills and Knowledge Requirements:

• Knowledge of security vulnerabilities and working impact on software solutions implemented to a working production environment.
• Experience of the following in Microsoft SQL Server:

o Relational database design principles
o Understanding of SQL Server Administration
o SQL OLTP development
o SQL Query optimization
o SQL Query analysis
o Database object design
o XML and JSON structures (beneficial)
o Good XML manipulation skills in XQuery (beneficial)

• Basic understanding of front-end languages like HTML5, CSS, JAVA script (Beneficial)
• Ability to deliver production quality software by e.g. paying attention to detail, doing extensive unit testing and supporting quality testing phases.
• Knowledge and experience of the following toolsets:

o SQL Server Management Studio 2012 upwards
o SQL profiler (beneficial)

• Knowledge on cloud services like Azure, AWS (Beneficial)
• Good understanding of data integrity and security best practices.
• Hands on experience in Exception Handling and Troubleshooting
• Troubleshooting slow running queries, Profiling Performance Issues (Beneficial)

Personal Profile:

• Self-starter, self-motivated, team player
• Excellent communication, interpersonal and collaboration skills
• Strong attention to detail and accuracy.
• Able to work under pressure and meet deadlines.
• Able to apply standards.
• Strong sense of responsibility, not only for own scope of work but also for the entire solution and reputation of the company and clients.
• Analytical thinking.
• Quick learner and retainer of knowledge
• Fast to comprehend and solve complex problems
• Own transport for occasional in-office and team event collaborations
• Home office setup for remote working, including a reliable and uninterrupted internet connection, with a minimum of 50MBps up and down speeds

Recru-IT