Arainn Consultants

 

www.arainn.ca

 

Specialists in Sourcing Software Personnel

 

Our client has the following permanent opportunity based in Vancouver (513)

 

SQL Server DBA

 

Job Description:  

 

On a daily basis, you can expect to:

o   Build, implement and maintain maintenance plans

o   Undertake performance tuning

o   Maintain awareness of the Product goals and development strategies

o   Share experience and knowledge with colleagues

o   Continually monitoring and obsessing over mission critical servers to ensure 24/7 operations

o   Produce recommendations on new technologies and how our business can be operated more efficiently

o   Analyze and resolve issues, carefully manage risk and manage backup and restores

 

Responsibilities

       Developing and managing the overall strategy of how we structure, maintain and analyze our Database systems and servers minimizing potential problems with servers and production databases by monitoring operations, resources and log files, ensuring file systems have the necessary space for proper functions

       Plan upgrades or modifications, resolving issues with servers and production databases to ensuring functionality of production software

       Provide service and support 24/7/365 as required, during exceptional circumstances, to maintain systems and service availability. This includes monitoring and responding to after-hours alerts sent through mobile devices, as well as responding to phone calls for support as situations require

       Analyze bottlenecks of database systems, storage devices and networks to maximize database and application performance levels and storage capacity

       Advise on the capacity requirements for data

       Experience in troubleshooting and resolving urgent/critical incidents on production systems

       Develop, enhance and follow tools and procedures used for checks and monitoring the status of the systems ensuring their integrity

       Suggest new procedures to prevent or identify problem areas

       Provide feedback and suggestions to Development to resolve production issues with databases or applications used in production when faults occur

 

Requirements:

       Seven years experience with DBA role

       Five years experience with SQL server

       Experience with SQL Server 2008 R2 / 2012 undertaking administration tasks

       Transact SQL (TSQL)

       SQL Server HA (High Availability)

       Experience working with the following:

o   SQL Server Replication, Database Mirroring and Logging

o   SQL Server Reporting Services (SSRS)

o   Working knowledge of Windows and SQL Server Clustering

o   New Database Administration / Installation

o   Database security and monitoring

o   Disaster Recovery (DR) | Business Continuity (BC)

o   Data modeling and scripting

o   Server and database security

o   Developing Functionality and stored procedures

o   Index Management and Optimization

o   Respond to and resolve database access and performance issues

o   Microsoft Dynamics AX 2009 / 2012

 

Email your resume to cooljobs@arainn.ca

 

At Arainn (pronounced 'erin'), we know recruiting. Our recruitment team focuses on sourcing software personnel for opportunities across North America, bringing together people and technology to drive business further. If you are looking to develop your career with a role that will match your goals and desire for growth, then consider the latest opportunities we have active.