Senior SQL Developer

at MPC Recruitment
Published July 31, 2022
Location Durban, South Africa
Category Computer & IT  
Job Type Full-Time  

Description

 

Job Description:

 

Are you an experienced and well-rounded SQL developer? Are you looking to push your career to the next level in a new team? If you are keen to be involved in exciting projects for a Multi-national technology company, in Legal and Financial Tech, this opportunity might be perfect for you. Our client is looking for a dynamic Senior SQL Developer to join their team. We are looking for a curious, innovative, and driven person to join the development team to enhance and expand their services. Someone disciplined, who inherently drives forward solutions to ensure timely delivery while still adhering to best practices. Our strategic goals for the next 3 years are to build new product offerings on a new framework and transpose the existing platform into the more modern structure.

RESPONSIBILITIES: As a SQL Developer, you will be responsible for participating in product development, from ideation to deployment and beyond. You will work on ground-breaking product features, issues, and improvements that are critical to the success of your customers, and you’ll need to work with the broader company to maintain and help optimize existing systems. You will, therefore, own the following:

  • Responsibility for the database architecture, the development of database schemas and database objects such as stored procedures, functions, views and triggers with T-SQL on MS SQL Server
  • Be adept at determining the most effective and efficient software design, ensuring high availability, data security, scalability, reusability, and data integrity within all processes and solutions.
  • Advanced Performance Tuning
  • Perform tests and evaluations regularly to ensure data security, privacy, and integrity.
  • Troubleshooting, debugging, fixing, and implementing solutions to ensure minimal impact on our customers live production environments as far as possible.
  • Build Packages for database deployment for Development, Testing, Staging, and Production environments and manage replication.
  • Define users and enable data distribution to the right user, in the appropriate format, and as scheduled
  • Determine, enforce and document database policies, procedures, and standards
  • Work closely with the development team to provide design direction
  • Conduct code and unit testing reviews to ensure quality delivery.
  • Implement tools to monitor, manage, audit, and test systems.
  • Provide complex data analysis solutions.
  • Liaise with 3rd parties, ensuring that any data integration works efficiently.
  • Carry out sufficient research and development to identify new trends and features that could be incorporated to enhance the current systems to improve business processes and productivity.
  • Provide time estimates, based on the level of effort and complexity, required to complete the projects. Here are a few things that you might do on a regular day:
  • Ideation and trouble-shooting dev task or brainstorming with team/customer/testing
  • Research solution and prepare/review the technical spec and provide estimates for planning
  • Code
  • Grab lunch with your team in a restaurant nearby or workout at a gym nearby.
  • Continue coding
  • Update helpdesk status and time tracking REQUIREMENTS: You have a minimum of 5 years proven working experience as SQL Developer
  • Strong programming language skills in MS SQL / Transact SQL, SSIS (DTS/Microsoft Integration Services), exposure to C.#
  • Strong database design skills with extensive experience in enhancing and optimizing database objects with T-SQL
  • In-depth knowledge in query optimization, indexing techniques, reading, and understanding execution plans.
  • Ability to create a workflow and apply to data processing solutions is also required.
  • Excellent knowledge of data backup, recovery, security, integrity and SQL
  • Distributed systems/services expertise
  • Familiarity with API Development; JSON, RESTFUL Webservices is a plus
  • Excellent analytical and troubleshooting skills with attention to detail and strong impact assessment ability
  • Version Control System (GIT)
  • You feel at home working in a test-driven, agile team.
  • Promote best-practices within our team and participate in design and code reviews The following would be an advantage:
  • Experience in financial batch file processing
  • Knowledge of Azure cloud deployment
  • Previous experience with DBA case tools (frontend/backend) and third-party tools EDUCATION: Software Degree or Diploma and Certification(s) a plus.

ATTRIBUTES:

  • Positive Attitude and solid work ethic.
  • Inquisitive and innovative problem-solver
  • Excellent collaboration and communication skills – given distributed team dynamic.
  • Professional client interaction skills – empathetic, focus on clarity and solution driven
  • Adept at providing feedback and managing client and team expectations.
  • Great at Time and Task Management.
  • Curiosity and willingness to learn quickly in a fast-paced environment
  • Ability to work independently and as a good team player
  • Adaptable and resilient
  • Resourceful and results driven
  • You know your limits and how to work on a deadline
  • Passionate about adding value in tackling future challenges together with the growing business.

Willing to travel as and when needed by the Group.

COMPENSATION & BENEFITS:

  • A competitive salary and an annual bonus (13th Cheque)
  • Modern working equipment and comfortable office space in Westville
  • Work on challenging technological projects and contribute to architectural decisions.
  • Work in a dynamic and fast-¬growing team where your input is highly valued.

 

Interested candidates can send their CVs

Only registered members can apply for jobs.