Skills

PostgreSQL Encryption GitLab Jenkins Architecture Linux Operating Systems Organization Azure Project Management Snowflake ETL Processes PostGres

Job Specifications

Hello,

Hope you are doing well.

Please have a look at the job description below & let me know if you are comfortable:-

Job Title: DB2 DBA

Location: Toronto, Ontario, Canada (Hybrid- 3 days onsite in a week)

Job Type: Long term contract

Job Description:-

Option-I Snowflake with Postgres along with Azure knowledge.

Option-II DB2 in Production support with Azure knowledge.

Overview

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.

Position Requirements:

5+ years of DB2 or PostgreSQL database administration experience
Experience working with cloud PaaS database services.
Jenkins, gitlab/bgit-bucket
Linux/Unix experience
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

Best Regards!

Gurneet Singh

Account Manager (Client Relations & Delivery)

EXL NEO Technologies

Email ID: gurneet@exlneo.com | www.exlneo.com

USA | Canada | India | Costa Rica

About the Company

EXL Neo is a leading IT consulting and staffing firm dedicated to delivering innovative technology solutions and connecting businesses with top-tier IT talent for enterprises in India, USA and Canada. Our mission is to empower organizations to thrive in a rapidly evolving digital landscape by providing expert guidance, strategic consulting, and highly skilled professionals tailored to meet the unique needs of each client. Our Services IT Consulting: * Strategic IT Planning: We work closely with clients to develop IT strategi... Know more