Careers

Senior Database Administrator

Back
Job Title
Senior Database Administrator
Type
Full Time
Location
Ipswich

We are currently looking for a passionate and motivated individual to join us in the role of Senior Database Administrator. To be successful you will need the drive required to meet and exceed customer expectations, build internal and external relationships and deliver service excellence.

Basic Purpose and Function

  • Effectively design, implement, maintain the company’s databases.
  • The role includes the development and design of database strategies, monitoring and improving database performance and capacity, and planning for future expansion requirements.
  • Liaise between Developers, Client, Business Analysts and Project Managers to ensure all parties kept informed in all aspects of work.
  • Provide day-to-day management of alerts for databases and services that are used by applications.
  • Perform a combination of Development and Support Tasks as required.

Key Tasks

  • Co-ordinate effective schema and data changes to Databases in DEV, QA, Demo UAT and Production Environments
  • Liaise with BA and Clients to code and implement Data Import and Reporting Requirements to business-critical systems sometimes within tight timescales.
  • Required to maintain and provide best practice around general housekeeping, administration and documentation
  • Liaise between Developers, client, Business Analysts and Project Managers to ensure all parties kept informed in all aspects of work.
  • Modify programmes to enhance processing performance.
  • Provide day-to-day management of alerts for databases and services that are used by applications.
  • Perform a combination of Development and Support Tasks within SLA as required.
  • Learn processes from other members of team and produce documentation beneficial to the entire team for inclusion in central knowledge store.

Qualifications, Knowledge and Experience

Essential

  • Designing, documenting (ERD, DFD …) and building relational databases from scratch
  • SQL DBA Experience with SQL 2008, 2012 and 2016 in a commercial environment.
  • In depth knowledge of T-SQL, Implementing Stored Procedures, Triggers, Views and Functions.
  • SSRS and SSIS.
  • Ability to communicate both directly with third parties and technically within the team.
  • Ability to liaise with staff to understand and document procedures
  • Experience with database failover and database disaster recovery solutions
  • Microsoft Certification (MCTS, MCTIP) SQL Server Implementation and Maintenance (or equivalent) an advantage
  • Familiarity with merge replication, partitioning, mirroring, multi-site networking and Disaster Recovery models also useful

Desirable

  • Knowledge of WNS-IT Applications.
  • MIS Reporting skills and Toolsets, e.g. Qlik
  • Knowledge and understanding of Microsoft Operating Systems and relevant products.
  • Agile Methodology and Scrum Based delivery
  • Experience working with DevOps
  • Experience migrating databases from SQL2000/2005 to SQL2016

Generic Competencies

  • Communication
  • Results Focus
  • Client Focus
  • Developing Self and Others
  • Problem Solving
  • Quality Focus
  • Commercial Awareness
  • Systems of Work
  • Handling Systems

Specific Competencies

  • SQL Server 2008 and 2016
  • Accuracy
  • Willingness to perform occasional duties out of core hours as required

To apply, please email us here with a copy of your CV

Apply
At any point in the conversation, you can use these key phrases
  1. Restart - clear context and start fresh (don't worry, you will still be signed in, if you have already done so)
  2. Bye - close conversation
  3. Help - display this help info
  4. Feedback - Provide feedback about current conversation
  5. Handoff - Request for transfer to human executive
  6. Menu - Display main query categories