Job title:

Job Description:

Help strengthen our DRS Technology Team, home based position, able to obtain SC clearance for a 23 months Fixed Term Contract, with occasional travel to customers sites.

We are now looking for a Senior SQL Server Developer/DBA to join our expanding DRS Technology Team. You’ll be responsible for leading in the design, development, testing and maintenance of SQL aspects of applications and providing end-user support

What you’ll be doing:

• SQL development and maintenance for applications and interfaces
• DBA support to the development team
• Transition to cloud environment of complex linked databases
• Undertake other reasonable duties/ projects as identified through business needs.
• Predominantly project /transformation responsibilities, but some limited support to the production environment will be required

What we’re looking for:

Mandatory Skills:

• Ability to hold/gain SC Clearance
• Strong technical knowledge of SQL Server as a developer and development support DBA
• Ability to design, implement and maintain tables, complex stored procedures, functions and views
• Experienced in database and query optimization, analysis of query plans and indexing
• Experienced with managing XML with SQL
• Experienced in building and maintaining SSIS packages
• Technical knowledge of current Windows operating systems
• Experience in virtualization

Desirable Skills:

• Experience with SQL Server in Azure
• Experience configuring and writing SSRS reports
• Clustering and AlwaysOn
• Technical knowledge of IIS web server
• Experience in Active Directory and DNS
• New Relic

About Capita RPP

At Capita Recruiting Partnering Project, we’re transforming the British Army’s recruitment service. Our team are constantly improving the entire recruitment and selection process for both the Regular Army and the Reserves. Our mission is to make joining the Army a less daunting and more transparent experience. Join us and discover better ways to inspire people to become part of the Army.

What’s in it for you?

• Home Based role with occasional travel to client sites
• Opportunity to be a part of a large-scale transformation moving to a Cloud based environment Transformation
• 23 days’ holiday with the opportunity to buy extra leave
• Company matched pension, life assurance, a cycle2work scheme, 15 weeks’ fully paid maternity, adoption and shared parental leave, paternity pay of two weeks…and plenty more
• Voluntary benefits designed to suit your lifestyle – from discounts on retail and socialising, to health & wellbeing, travel and technology
• The opportunity to take a paid day out of the office, volunteering for our charity partners or a cause of your choice
• Access to our Employee Network Groups, which represent every strand of diversity and allow colleagues to connect and learn from each other on an open, inclusive platform

You’ll get the chance to follow your chosen career path anywhere in Capita. You’ll be joining a network of 63,000 experienced, innovative and dedicated individuals across multiple disciplines and sectors. There are countless opportunities to learn new skills and develop in your career, and we’ll provide the support you need to do just that. Our purpose is to create a better outcome for you.

What we hope you’ll do next:

Choose ‘Apply now’ to fill out our short application, so that we can find out more about you.

We’re an equal opportunity employer, which means we’ll consider all suitably qualified applicants regardless of gender identity or expression, ethnic origin, nationality, religion or beliefs, age, sexual orientation, disability status or any other protected characteristic. We recruit and develop our people based on merit and their passion for creating better outcomes, and we’re committed to creating an inclusive environment for all employees.

We’re continuing to adapt to the unprecedented circumstances brought about by COVID-19. Wherever possible, all interviews, assessments and background checks will take place online, to completely remove the need for face-to-face contact. All Capita colleagues who can work from home should do so; and where it is not possible for colleagues to work remotely, we have taken important steps to protect those working from Capita’s offices. Social distancing, enhanced hygiene and safety measures are already in place at all Capita locations that are open to protect our colleagues and manage the risk of COVID-19. The welfare of our people is of paramount importance to us, and we’re doing everything we can to keep our colleagues and customers safe during this time.

Location:

,

Time Type:

Contract Type:

The Data Management Admin Associate is a key member of the global technology team who uses their technical and communication skills to develop software and scripts that increase efficiency, ensure accuracy, and reduce the number of hours spent doing repetitive tasks.

• Work with the Data Management team to collect requirements of tools or scripts to be written
• Use the requirements to design databases, user interfaces and logic (where applicable)
• Advise Data Management leadership on the best way to achieve specific design and implementation goals
• Evaluate existing tools to find improvements and fix issues
• Develop clean and efficient C# desktop applications
• Develop clean and efficient C# web applications using common models, frameworks, and languages (MVVM, MVC, bootstrap, CSS, JS)
• Develop clean and efficient PowerShell scripts
• Write and perform unit and integration tests for all tools (where applicable)
• Document developed tools and update with any new releases
• Provide training to internal staff on developed tools
• Keep up to date with the latest technologies

• Strong knowledge of the most current Microsoft Windows operating systems including the ability to navigate efficiently and perform administration tasks
• Strong knowledge of Microsoft SQL Server and TSQL.
• Strong knowledge of C# and web technologies
• Understanding of the SOLID principles and design patterns and when to use them
• Intermediate knowledge of PowerShell
• Excellent troubleshooting and problem-solving skills
• Excellent attention to detail and organisational skills
• Excellent verbal and written communication
• Ability to work in a fast-paced work environment
• Ability to multi-task and prioritise / re-prioritise work

Desirable Skills

• Any relevant Certifications (specifically Microsoft)

 Minimum Education Requirements:   

• Bachelor’s degree or higher in Computer Software Engineering or similar technical field

Minimum Experience Requirements:  

• 2 years

Consilio’s True North Values

Excellence
We strive to make every client our advocate

Passion
We DO because we CARE

Collaboration
We win together through teamwork and communication

Agility
We flex, adapt and embrace change

People
We value, respect and invest in our teammates

Vision
We create clarity of purpose and a clear path forward

Consilio, LLC is an EEO/Affirmative Action Employer and does not discriminate on the basis of race, colour, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability or any other legally protected status.