Database Administrator W01

Market Force Information   •  

Winnipeg, MB

Industry: Professional, Scientific & Technical Services

  •  

Less than 5 years

Posted 29 days ago

Market Force Information LLC operates in the exciting and growing industry of customer experience management. Increasingly multi-location businesses such as retailers, restaurants, banks, hotels and others are differentiating themselves in hyper-competitive markets byfocusing on and investing in the experience that they deliver to their customers. These brands need to understand what matters most to their customers, where they are not meeting expectations and what the financial ROI could be for various improvements that they might make in their businesses. That’s where Market Force comes in.

Serving over 200 clients globally, Market Force provides a host ofmeasurement, analytics and reporting services that empower its clients to protect their brand’s reputation, delight customers, and grow their revenues. We seek out talented, collaborative, and creative team members who are passionately committed to supporting our business and helping our clients reach their goals. Currently, we are looking for a Database Administrator to join the Application Development team.

The Database Administrator is responsible for providing operational database services as well as project-level support to the organization. This DBA role will have a primary focus on SQL Server Databases, but with a need to support a MySQL system as required. The role is best suited for someone with a service-oriented mentality and a high sense of ownership of the problems and requests assigned. The idealcandidate will also possess the ability to focus on managing and resolving issues and proactively escalating any issues that cannot be resolved within the established timeframes.

In support of this, duties of the Database Administrator include

  • Perform day-to-day production SQL Server database administration tasks including maintenance, troubleshooting, scaling, tuning, optimization, installation, upgrades, backup/recovery, and data migration across multiple data centers and multiple database server architectures/systems.
  • Troubleshoot and resolve production database issues
  • Ensure performance, security, and availability of databases
  • Profile server resource usage, optimize and tweak as necessary
  • Maintain database design/release documentation
  • Provide 24x7 support for critical production systems
  • Work closely with members of the Software Development Team to design and implement optimal solutions

The successful candidate for this position will possess:

  • A Bachelor’s degree in Computer Science, Mathematics or related IT field (preferred)
  • 3+ years’ hands on experience in designing and administering SQL Server databases and knowledge of de-facto standards and best practices in SQL Server
  • Experience with replication configuration in SQL Server
  • Experience with SSIS packages/Integration Services in SQL Server
  • Experience working with Windows Server, including Active Directory
  • Proficiency in optimizing T-SQL statements
  • Experience with data modeling in relational databases and writing complex T-SQL queries
  • The Ability to plan resource requirements from high level specifications
  • An understanding of Powershell scripting and the ability toautomate routine tasks
  • Familiarity with monitoring tools and how to apply to the DB environment
  • The ability to support environments remotely while on On-Call
  • Hands-on experience with NoSQL / non-relational databases (a plus)
  • ETL / data migration experience with large data sets
  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
  • Familiarity/Experience with SQL Cloud Services such as Microsoft Azure or Amazon Web Services
  • 1+ years’ experience with MySQL Database Administration (preferred)

Our company fosters an environment of energy, learning and growth. Along with offering competitive pay we are excited to offer great employee benefits including:

  • Bonus Incentives
  • RRSP/DPSP
  • EcoPass Options
  • Vacation Time
  • Health, Dental and Vision Insurance
  • Life Insurance
  • LTD

Market Force Information is an Equal Opportunity Employer