Web Content Display Web Content Display

 

Position Title: Database Administrator
 
Position Location:                     St Albans, UK                 
Reports to:                               Development Manager, PLM         
Supervisory Responsibility:         None    
Term:                                        Permanent
Full/Part Time:                           Full Time
Date Prepared:                           4th December 2009
 
About Agentrics
Agentrics was founded by the world’s largest, most successful retailers to provide solutions for more effective sourcing and supply chain collaborations. Over the years, we expanded our services to support retailer growth initiatives in private label product development, data sharing, performance analytics, food safety and business intelligence. Today, Agentrics is a trusted partner to more than half of the world’s top 25 retailers and hundreds of other merchants and trading partners.
 
Agentrics has one of the industry’s most active customer communities, as we facilitate user- and executive-level interactions so customers can share innovative practices, address global issues and influence industry standards. More information is available at www.agentrics.com.
 
 
Responsibilities:
 
  •  Installation of new software — it is the job of the DBA to install new versions of DBMS software, application software, and other software related to DBMS administration. It is important that the DBA or other IS staff members test new software before it is moved into a production environment.
  • Configuration of hardware and software with the system administrator — in many cases the system software can only be accessed by the system administrator. In this case, the DBA works closely with the system administrator to perform software installations, and to configure hardware and software so that it functions optimally with the DBMS.
  • Security administration — one of the main duties of the DBA is to monitor and administer DBMS security. This involves adding and removing users, administering quotas, auditing, and checking for security problems.
  • Data analysis — the DBA analyzes data stored in the database and makes recommendations relating to performance and efficiency of that data storage. This includes the effective use of indexes, enabling "Parallel Query" execution, or other DBMS specific features.
  • Database design (preliminary) — the DBA can be involved at the preliminary database-design stages, eliminating many problems that might occur. The DBA knows the DBMS and system, can point out potential problems, and can help the development team with special performance considerations.
  • Data modeling and optimization — by modeling the data, it is possible to optimize the system layouts to take the most advantage of the I/O subsystem.
  • Responsible for the administration of existing enterprise databases and the analysis, design, and creation of new databases.
o    Data modeling, database optimization, understanding and implementation of schemas, and the ability to interpret and write complex SQL queries.
o    Proactively monitor systems for optimum performance and capacity constraints.
o    Establish standards and best practices for SQL.
o    Interact with and coach developers in SQL scripting.
  
Travel Requirements:
None.
 
Skills and Expertise:
Essential:
  • Identify and develop ways to improve the current procedures and technology solutions.
  • Install, configure, and maintain MS SQL Server RDBMS Systems
  • Diagnose/troubleshoot issues at different levels including database, application, and system level (I/O, CPU, memory, etc.)
  • Perform performance tuning
  • Be responsible for Database replication management
  • Create change management records, scheduling implementation, and maintenance events
  • Create standard operating procedures
 
Education and Experience:
Essential:
  • Demonstrated combination of experience and formal training and advanced education within computing science, management information systems or equivalent
  • Proven experience within database administration  
Desirable:
  • Bachelors of Science degree in Computer Science, MIS, or Business Administration preferred. Proven experience gained within an MS SQL Server 2005 and MS SQL Server 2008 Enterprise Database Administration position.
  • Strong technical background that includes experience in Microsoft SQL Server in a highly available enterprise environment.
  • Strong analytical problem solving, trouble shooting and analysis skills to quickly identify and resolve issues.
  • Attention to detail and process improvement are expected.
  • Need to have the ability to work well with internal customers.
  • Experience with system migrations, backups/restores and other general DBA activities.
  • Experience managing multiple RDBMS on large systems
  • Practical experience monitoring and performance tuning to provide a high availability service
  • Practical experience managing the internal and external database security
  • Flexible, adaptable and able to manage multiple tasks in a dynamic and fast paced environment
  • Standards adherence skills: create and maintain consistent documentation of new and existing deployments.
  • Ability to set and manage priorities judiciously
  • Team player; ability to work in a very collaborative, agile environment.
Accommodations:
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
 

To Apply Online:

https://home.eease.com/recruit/?id=14034