Senior DB2 PostgreSQL Snowflake DBA

Overview

As a Senior DB2 PostgreSQL Snowflake DBA at Exl Neo, you will collaborate with cross-functional teams, including customers, project management, software engineering, and network operations, to gather database requirements, improve existing systems, and develop new ones. This role is crucial for ensuring the smooth, efficient, and secure operation of our database systems.

Your responsibilities will include:

• 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

To succeed in this role, you should possess the following 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.
• Proficiency with Jenkins, GitLab/Bitbucket.
• Strong Linux/Unix experience.
• Experience supporting highly available and fault tolerant systems.
• Ability to participate in on-call shifts, as our infrastructure runs 24/7.
• Security knowledge & experience (e.g., Database Encryption/masking/Certificates/PKI/SSH/VPN).
• Expert problem solver by applying problem analysis methodologies.
• A Computer Science or Engineering degree or equivalent experience.

Key skills/competency

• DB2 Administration
• PostgreSQL Administration
• Snowflake Data Warehousing
• Database Security
• High Availability (HA)
• Performance Tuning
• ETL Processes
• Linux/Unix
• On-call Support
• Problem Solving