Database and Network Administrator (DNA)
Fletcher Scott Recruiting Inc. - Ottawa, ON

Our Client is looking for a Database and Network Administrator for a full-time position.

You would be responsible for general network maintenance on networks relating to products servers and users in the company as well as for planning, developing, and maintaining the corporate production and company databases. This includes the creation of all plans for ensuring data consistency, definitions, security, and usability. The DNA is responsible for coding or implementing associated systems and applications software, as well as diagnosing and resolving database performance issues to ensure optimal database performance. This individual also installs, configures, and supports the software and hardware components of internal/external networks, as well as deploys and maintains all systems, applications and related computer equipment. The DNA troubleshoots network performance and provides technical guidance to end users.

Job Duties

Conduct end-user requirement assessments to capture business processes and establish specifications for database construction
Refine the logical design of our database for translation into a specific data model, and its physical design to meet system storage requirements
Establish database performance and schema management, including tables, indexes, and partitions
Provide database monitoring and support for mission-critical applications; document all production databases and interface systems
Constantly monitor and assess database servers to make sure that online and batch processes are operating as designed
Troubleshoot database errors and fix system issues via periodic testing, help desk tickets, and other methods
Collaborate with other IT and operational staff to ensure database integrity, security, and ongoing performance
Ensure that server hardware is adequately sized and configured; conduct capacity planning scenarios to meet future needs
Develop, administer, and maintain policies and procedures for ensuring the security and integrity of the database
Provide support for development processes by participating in data modeling sessions and advising about database design or use of objects.
Perform database upgrades
Perform database normalization and replication procedures
Plan for database backup and recovery
Control and monitor user access to the database
Test and install issued patches in conjunction with software providers and vendors or other third parties
Develop and maintain database expertise through professional associations and professional development opportunities
Advise management of new applications or potential system enhancements in support of future requirements
Act as a technical resource during other projects as required
Perform the planning, development, and management of all Network services, programs, and support throughout the enterprise.
Administer and maintain the use of all networks as well as connections to the Internet and peripheral equipment.
Deliver high levels of employee engagement through mentoring processes, ensuring a transfer of knowledge throughout the organization.
Provide training and orientation for staff in services, applications and equipment, ensuring that appropriate operational documentation is produced.
Install, maintain, evaluate and upgrade all computer hardware and software.
Provide internal and external Network support (server security, software updates, hardware maintenance etc.).
Operate master consoles to manage and synchronize use of the networks and to monitor its performance.
Assist with the implementation, deployment and operation of information systems and technology solutions for business needs.
Assist senior management with the direction and facilitation of Network strategic and tactical planning.
Oversee project management for Network-related undertakings, including clear capture of business requirements, provision of functional deliverables, milestone planning, and project post mortems.
Assist with capacity planning for network bandwidth, storage requirements, messaging, Web sites, and other applications.
Stay informed on new or emerging trends and technologies that provide clear benefits to the organization, business partners, and/or customers.
Perform network start-ups and close-downs.
Perform test for security and quality control purposes.
Create status reports as required; present findings to senior management.
Maintain control records and perform data backups.
Perform and assist with disaster recovery operations as necessary.
Monitor company use of the network including e-mail, web navigation and software installation.
Plan end-user training as required.
Perform other duties as assigned.

Requirements

Post-Secondary Degree or Diploma in computer science, or an acceptable combination of education and relevant experience required.
Advanced overall knowledge of networking, operating system, and server architectures, including actual work experience with Microsoft server OS 2003 and above, Microsoft Virtual Machines, entreprise level routers and VPNs.
At least 3 years of direct work experience with database administration Microsoft SQL server 2005 or above database products
DBA certification is an asset
Demonstrated knowledge of database design and analysis, client-server architecture, and data modeling
Strong knowledge of database performing tuning, backup, recovery, storage management, methodologies, processes, and tools
Familiarity with object-oriented design and high-level programming
Able to interpret the operational requirements of end users, project managers, and other stakeholders
Ability to write concise and accurate technical documentation throughout database development projects
Ability to troubleshoot programming changes, errors, and subsequent modifications
Practical knowledge of database replication strategies
Able to stay abreast of current and future technological developments or trends in the area of databases
Advanced knowledge of Web design/application principles and tools, including ASP.NET, JavaScript, VBScript.
Good overall knowledge of programming concepts, software development cycles, and associated tools and platforms, including Agile, UML and Microsoft Project.
Proficiency with networks, firewalls, encryption, and other aspects of network security technologies.
Highly effective project management skills.
Ability to explain technical concepts and theories to non-technical audiences.
High degree of resourcefulness, flexibility, and adaptability.
Able to work independently or as part of a team
Self-starter and highly motivated to make proactive changes
Good written and verbal communication skills

Please contact me for more details on this position.

Thanking you in advance,


Indeed - 30+ days ago - save job - block

» Apply Now

Please review all application instructions before applying.

» Apply Now

Please review all application instructions before applying.