Autodata Solutions is looking for a Senior Database Administrator to join their London office.
As a part of a technical team, the Database Administrator maintains and controls access to testing and production of data set across multiple platforms. You will design, implement, operate and maintain databases including monitoring, back-up and recovery procedures, performance tuning and implementing database change management. This role requires strong familiarity with both MSSQL and MySQL database systems.
- Design logical and physical databases and review descriptions of changes to database design to understand how changes affect the physical database (how data is stored in terms of physical characteristics, such as location, amount of space, and access method)
- Establish physical database parameters, code database descriptions and specify identifiers of database to database management system or direct others in coding database descriptions
- Resolve database performance issues, database capacity issues, replication, and other distributed data issues
- Specify user access level for each segment of one or more data items, such as insert, replace, retrieve
- Interact with Developers to effectively explore, investigate and implement requirements as they apply to database technology
- Perform database maintenance, patching, backup & recovery as needed
- Post secondary education in Computer Systems Technology, Computer Science or related discipline
- 7+ years experience in MySQL and MSSQL Server Administration, data dictionary creation, data modeling & updating, database startup & shutdown, setup, backup & recovery, SQL scripting (PL-SQL, Triggers & Stored Procedures), performance tuning, replication, data warehousing and log shipping
- Working knowledge Microsoft Windows Cluster, SQL Server Cluster setup & AlwaysOn
- Experience with data modeling tools
- Ability to be on-call as part of the team rotation, a good attitude, reliable, ability to adapt quickly and effectively manage priorities
- Experience with Mongo and/or Oracle Administration an asset
Autodata Solutions is a consulting, technology services and business process outsource company dedicated to the automotive industry. Founded in 1990, it is our mission to provide solutions that increase the effectiveness of the automotive sales chain and help put vehicles in consumers' driveways. Clients benefit from the expertise we have gained from our singular focus on the automotive sector as well as 26 years of successful client engagements.
Why work with us? Well here are some of the reasons we think we’re pretty great:
- Been around for 26 years & nominated as a ‘Great Place to Work’ several times
- Over 300 technical minds to collaborate with on a daily basis right here in London
- Monthly catered breakfasts, holiday events and other out of office events including summer BBQs, golf tournaments, skating and ice hockey
- An active Wellness Committee that organizes corporate volleyball, soccer and softball teams, monthly on-site massage, kickboxing, indoor rock climbing, art/painting classes, Escape Room and lunch and learns
- Ongoing community philanthropy helping Toys for Tots, the United Way, Girls Rock I.T., Explode Conference, our corporate charity: Families in Need and other local programs
- Employee discounts on vehicles and accessories available through select clients
- Training and educational incentives for continued career growth
- Bake Sales, Raffles, Auctions and free coffee!
For more information about Autodata, please visit our company website at www.autodata.net.
We thank all applicants for their interest however only those selected for an interview will be notified. Autodata Solutions is an equal opportunity employer. We are compliant with AODA legislation; if you require work related accommodations, please specify.