Job details
We are currently looking for a Jr. Database Administrator for one of our clients, an international company, located in downtown Montreal, Canada. The DBA must possess business intelligence and data warehouse experience; a passion for data, with an attention to detail and accuracy, driven to provide innovative and excellent solutions, and who likes to have fun while working hard to achieve success. The incumbent must be a dynamic, customer service focused individual who embraces our dynamic culture while delivering robust, clean, and flexible solutions that drive our development and business teams. The data provided by this role is often high visibility with an absolute need for accuracy as they affect not just monitoring of the business but forecasting and planning at the highest levels. The position requires hands-on experience with MySQL Server 5.6 or above. Direct experience with on-call troubleshooting for database related issues are essential. Additionally, experience with the management and implementation of database upgrades and migrations are necessary.
We use agile development methodology and expect our DBAs to be self-motivated, work well independently, and work with our development teams during software deployments. We look for individuals that can assume responsibility for their work and require minimal supervision to ensure their tasks are complete.
Job Responsibilities
- Oversee Development of New Databases
- Debug Database Issues on Live Data
- Proactively Tune Database in Production
- Monitor and maintain system health and security
- Design backup processes for server and associated data
- Create accounts for all users and assign security levels
- Establish a disaster recovery protocol
- Provide end-to-end technical support and problem resolution
- Participate in capacity planning for storage, servers and network components as needed to ensure performance and service level agreements.
- Stay current with database technology advances to enable production support and incident resolution.
- Collaborate with analysts, developers, and end users to communicate and enforce standards and guidelines for data access and security.
- Document databases in support of system development life cycle compliance.
- Own and manage the DB/DW ticket queue for the development team.
- Develop, maintain/enhance the database structures (data modelling, indexing, etc.).
- Develop, maintain/enhance and troubleshoot the data load scripts, jobs and packages (ETL).
- Provide technical support and mentoring to IT and business report developers.
- Look for and act on continuous improvement opportunities that make yourself, IT and Sekure Merchants better.
Job qualifications
- A Bachelor of Science degree in Computer Science or equivalent.
- 2+ years as MySQL production DBA including experience with design, implementation, backup and recovery, monitoring, and performance tuning.
- Advanced knowledge of database structure and theory
- Experience with MySQL and MSSQL
- Experience with Python
- Strong experience of relational databases, backup and restore operations, replication, locking, mirroring, clustering, DB logins/permissions, stored procedures, schema, triggers, database maintenance activity, etc.
- Understand wait statistics, index maintenance, query performance tuning (query plans), long running queries, configuring meaningful SQL alerts.
- Advanced knowledge of writing SQL and T-SQL scripts.
- Experience with running health-check scripts and able to execute process improvements based on results.
- Experience with system development lifecycle methodologies, deliverables, controls
- Experience with database monitoring tools such as Quest Spotlight.
- Experience with designing and implementing high-availability database features, utilizing various replication and disaster recovery methodologies.
- Experience implementing database schema changes in live production environment requiring minimal downtime and zero performance impact.
- Experience defining and implementing database management tools across entire database platform to ensure database performance and stability is maximized across the entire organization
- Experience with managing the full life-cycle of database schema design and implementation, which includes script management from development through production releases.
- Experience with scaling up and out (e.g. sharding based on specific keys) databases to meet the needs of increased storage and computing capacity.
- Familiarity with reporting tools (Tableau working experience would be an asset)
- Work experience related to business intelligence, and data warehouse development would be an asset.
- Detail oriented with the ability to work well independently and as a team player
- Strong critical thinking and analytical skills required
