Database Administrator
3 weeks ago
The DB2/PostgreSQL DBA will play a crucial role in managing and optimizing database systems, ensuring high availability and performance while collaborating with cross-functional teams to meet business needs. Responsibilities Collaborate with cross-functional teams, including customers, project management, software engineering, and network operations, to gather database requirements, improve existing systems, and develop new systems. Install and upgrade database systems, ensuring smooth and efficient processes. Implement and maintain robust database security measures, adhering to industry standards and guidelines. Design and support 24x7 high-availability solutions for seamless database operations. Optimize database and server performance by analysing and configuring physical server hardware, operating systems, and database software settings. Provide recommendations for upgrades and new systems. Develop and optimize database components, including queries, stored procedures, ETL processes, and conduct code reviews and optimizations to enhance performance. Execute database schema and code changes, perform bottleneck analysis, and ensure efficient server/database performance, including recovery and restores when needed. Plan for system growth and scalability to accommodate future requirements. Ensure compliance with vendor license agreements to maintain legal and operational integrity. Handle various reporting and data export/import tasks, working with different formats like CSV, XML, and unstructured data. Document the database environment, processes, and best practices to maintain a comprehensive knowledge base. Provide technical support and prompt problem resolution to address any database-related issues. Be available for production/on-call support to maintain continuous system availability and address emergencies effectively. Be willing to learn new technologies and assist with architecture and design. Work efficiently within a high security environment (PCI-DSS Level 1 certified). Communicate clearly and effectively to all levels of the organization. Qualifications 5+ years of DB2 or PostgreSQL database administration experience. 2+ years of Snowflake data warehouse administration and development experience. Experience working with cloud PaaS database services. Jenkins, gitlab/bgit-bucket. Experience supporting highly available and fault tolerant systems. Participate in on-call shifts, our infrastructure runs 24/7. Security knowledge & experience (Ex. Database Encryption/masking/Certificates/PKI/SSH/VPN). Expert problem solver by applying problem analysis methodologies. Computer Science or Engineering degree or equivalent experience. Required Skills Advanced Azure cloud technologies experience. Experience on cloud database deployment using terraform. Azure Cosmos or similar database technology experience. Desire to automate everything, automate & anything. Networking experience (Ex. TCP/IP, UDP, Routing, Firewalls, load-balancers). Desire to document everything. PCI-DSS or similar experience (ex. financial/government/healthcare). Understanding of the ITIL framework. Familiarity with JBoss or WebSphere application server. Pay range and compensation package Long Term Contract Seniority level Mid-Senior level Employment type Contract Job function Information Technology Industries IT Services and IT Consulting #J-18808-Ljbffr
-
Database Administrator
3 days ago
Toronto, Canada iPartner Staffing Full time3 days per week in the office Expert Oracle and Microsoft SQL Database administration experience Demonstrated experience with DACPAC Experience with Azure build automation using Ansible, Terraform, Packer and VSTS Description The Services and Deliverables to be provided by the Vendor will include the following: - Participate in the review of...
-
Database Administrator
1 week ago
Toronto, Canada Bond Brand Loyalty Inc Full timeOur team is composed of dynamic professionals committed to excellence and continuous improvement. We are seeking a skilled Database Administrator to join our growing team and help us manage and optimize our database systems. As a **Database Administrator** at Bond, you will be responsible for overseeing the performance, security, and integrity of our...
-
Database Administrator
3 days ago
Toronto, Canada iPartner Staffing Full timeExpert Oracle and Microsoft SQL Database administration experience - Experience with Azure build automation using Ansible, Terraform, Packer and VSTS - Expert experience with Oracle GoldenGate - Expert Oracle and Microsoft SQL Database administration experience; - Expert experience with planning, configuring, maintenance, administration, performance tuning...
-
Database Administrator
2 weeks ago
Toronto, Canada Infotek Consulting Services Full timeSupport on preparation, installation, configuration and user test of mainframe z/OS, IMS and DB2 version upgrade: - Participate in the review of project and maintenance release artefacts - Use Case, System Requirement Specification, etc.; - Prepare and implement database changes according to design; - Promote database changes through Development,...
-
Database Administrator
7 days ago
Toronto, Canada Intelex Technologies Full time**Position Overview** Database is one of the most critical core components in any service infrastructure! If you wish to work with several database technologies and drive infrastructure efficiency through innovative designs, then you should consider a position as a SQL Server DBA / System Admin here at Intelex. In this role you take ownership of defining...
-
Database Administrator
2 weeks ago
Toronto, Canada Scotiabank Global Site Full timeRequisition ID : Join a purpose driven winning team committed to results in an inclusive and high-performing culture. Scotiabanks Global Technology and Enterprise Platform (GTEP) Database operations (MSSQL) team takes care of end-to-end support for Microsoft data platform products across the globe where Scotiabank is present. Physical & logical database...
-
Database Administrator
4 weeks ago
Toronto, Canada CloudVital Full timeJob Title: Database Administrator Job Type: Full-Time/Contract Job Location: Toronto – Onsite (Office 4 to 5 days a week) This role is an onsite position located in Toronto, requiring you to work in the office 4 to 5 days a week. Responsibilities Participate in the review of project, work request and maintenance release artifacts – Use Case, System...
-
Database Administrator
3 weeks ago
Toronto, Canada CloudVital Full timeJob Title: Database Administrator Job Type: Full-Time/Contract Job Location: Toronto – Onsite (Office 4 to 5 days a week) This role is an onsite position located in Toronto, requiring you to work in the office 4 to 5 days a week. Responsibilities Participate in the review of project, work request and maintenance release artifacts – Use Case, System...
-
Database Administrator
3 weeks ago
Toronto, Canada CloudVital Full timeJob Title: Database Administrator Job Type: Full-Time/Contract Job Location: Toronto – Onsite (Office 4 to 5 days a week) This role is an onsite position located in Toronto, requiring you to work in the office 4 to 5 days a week. Responsibilities Participate in the review of project, work request and maintenance release artifacts – Use Case, System...
-
Database Administrator
2 weeks ago
Toronto, Canada Artech LLC Full timeTitle: Database Administrator Location: Toronto, Ontario Duration: 6 Months Salary Range: Competitive and commensurate with experience Introduction We are seeking an experienced professional to support our diverse database environments, including development, production, and UAT. This role is integral to maintaining the performance, integrity, and...
