SQL Database Administrator
at JMT Consultants
Winnipeg, MB, Canada -
| Start Date | Expiry Date | Salary | Posted On | Experience | Skills | Telecommute | Sponsor Visa |
|---|---|---|---|---|---|---|---|
| Immediate | 28 Jan, 2025 | Not Specified | 29 Oct, 2024 | 3 year(s) or above | Good communication skills | No | No |
Required Visa Status:
| Citizen | GC |
| US Citizen | Student Visa |
| H1B | CPT |
| OPT | H4 Spouse of H1B |
| GC Green Card |
Employment Type:
| Full Time | Part Time |
| Permanent | Independent - 1099 |
| Contract – W2 | C2H Independent |
| C2H W2 | Contract – Corp 2 Corp |
| Contract to Hire – Corp 2 Corp |
Description:
Responsibilities:
- 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
- Collaborate with development teams to fix application-related database problems
- 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
- Work with custom-developed applications to ensure seamless data flow
- Collaborate with software developers to integrate database solutions
REQUIREMENT SUMMARY
Min:3.0Max:5.0 year(s)
Information Technology/IT
IT Software - DBA / Datawarehousing
Other
Graduate
Proficient
1
Winnipeg, MB, Canada
