SQL Database Administrator

**JMT Consultants Inc. - Winnipeg, Manitoba**

**Full-Time, Permanent**

Are you ready to dive into the world of cutting-edge data management? As a SQL Database Administrator (DBA) at JMT, you won't just be maintaining databases—you’ll be at the helm of ensuring that massive amounts of data are optimized for performance, security, and accessibility. You'll play a key role in shaping the database architecture and contributing to innovative designs.

You'll have the opportunity to work with a variety of powerful database systems. Your expertise will be crucial in every day work bringing forward new puzzles to solve, as you’ll work to enhance performance and keep the lifeblood of modern businesses—our data—flowing smoothly and efficiently.

If you're passionate about working behind the scenes to make sure data powers every critical decision, this is the role for you

**What you'll do**:

- ** Database Design and Development**:

- Create and optimize database schemas and objects
- Develop stored procedures, functions, and complex queries
- Design and generate complex SQL reports based on business requirements
- **Data Mining and Integration**:

- Perform complex data mining to extract valuable insights
- Integrate data from various sources into databases
- Ensure data consistency, integrity, and quality across different datasets
- Develop and maintain ETL (Extract, Transform, Load) processes
- **Collaboration and Solution Tailoring**:

- Coordinate with internal teams to analyze and assess business needs
- Tailor database solutions to meet unique business requirements
- **Database Management and Maintenance**:

- Oversee comprehensive database management tasks
- Implement backup and recovery strategies
- Secure database access and ensure data integrity
- Optimize physical data storage design
- **Security Management**:

- Implement and maintain database security best practices
- Manage user access and authentication
- Ensure compliance with security policies and data protection regulations
- **Performance Optimization**:

- Continuously monitor database performance and resource utilization
- Identify bottlenecks and optimize queries and indexes
- Maintain peak database performance through proactive measures
- **Troubleshooting and Debugging**:

- Conduct root cause analysis for database issues
- Resolve performance issues and errors promptly
- **Scalability and Improvement**:

- Develop scalable database solutions to accommodate growing data volumes
- Implement strategies for database scaling and partitioning
- Stay updated with the latest database technologies and best practices
- **Integration and Connectivity**:

- Enable and manage connectivity via RESTful APIs
- Collaborate with software developers to integrate database solutions

**What Makes you Stand out**:

- ** Education**:

- Bachelor’s degree in computer science, Information Technology, or a related field
- **Experience**:

- Minimum of 3-5 years of experience as an SQL Developer and/or DBA
- Proven experience with Azure SQL Database services
- Strong background in database schema design and optimization
- Experience in writing complex stored procedures and SQL queries
- Extensive experience in data mining and data integration from various sources
- Experience in coordinating with cross-functional teams to develop tailored database solutions
- **Technical Skills**:

- Proficiency in SQL Server and T-SQL programming
- Knowledge of database security best-practices
- Experience with performance tuning and optimization techniques
- Familiarity with performance monitoring tools and techniques
- Understanding of RESTful APIs and web services
- Experience with cloud platforms, specifically Microsoft Azure
- Proficiency in ETL tools and processes (e.g., SSIS, Informatica)
- Knowledge of data integration methodologies and tools
- Familiarity with scripting languages (e.g., PowerShell) is desirable
- Experience with data warehousing and business intelligence tools is a plus
- **Soft Skills**:

- Strong analytical and problem-solving skills
- Excellent communication and teamwork abilities
- Ability to work independently and manage multiple tasks
- Attention to detail and commitment to quality

**Must Haves**:

- ** Security Consciousness**:

- Must prioritize security in all database activities
- Experience with data encryption and secure data transmission methods
- **Continuous Improvement**:

- Proactive in suggesting and implementing improvements
- Willingness to learn and adopt new technologies
- **Leadership and Guidance**:

- Ability to provide expert advice on database management systems
- Experience in guiding teams on best practices and effective solutions
- **Certification**:

- Relevant certifications such as Microsoft Certified: Azure Database Administrator Associate are a plus
- **Canadian Citizenship/Legally able to work in Canada**

**Leap into Action**: