The Database Administrator (DBA) designs, develops and manages enterprise business applications that store and share information across the organization. The DBA enhances the performance, accuracy and reliability of database systems and works with IT department staff, business units and end users to meet data quality standards. The DBA is comfortable working with legacy systems as well as open source or independent vendor products, integrating IT where necessary so that database systems support business goals.
Responsibilities
• Performance tuning and resource monitoring of various databases
•Monitoring performance and managing parameters to provide fast query responses to 'front end' users;
• Ensure data recovery, maintenance, data integrity and space requirements
• Writing database documentation, including data standards, procedures and definitions for the data dictionary ('metadata');
• Communicating regularly with technical, applications and operational staff to ensure database integrity and security;
• Implement database definitions, structure, documentation, and long range requirements
• Commissioning and installing new applications
• Backup/recovery, installation and upgrades of RDBMS
• Assist with the development of new projects and systems as required
Qualifications
•A post-secondary degree in information systems
• Expertise in designing/building/maintaining transactional replication in big multi-server production environment
• Deep understanding of designing/building automation modules/scripts for backup/archival/ETL/cleanup tasks
• The ability to create/tune/optimize stored procedures
• Expertise in partitioning, file group optimization, data mirroring, log shipping, and clustering
• The ability to work closely with IT project managers, database programmers and Web developers