DB2/PostgreSQL DBA (Snowflake DW administration and development experience)

Job Description

<p><strong>About the Role</strong></p><p>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.</p><p><br></p><p><strong>Responsibilities</strong></p><ul><li>Install and upgrade database systems, ensuring smooth and efficient processes.</li><li>Implement and maintain robust database security measures, adhering to industry standards and guidelines.</li><li>Design and support 24x7 high-availability solutions for seamless database operations.</li><li>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.</li><li>Develop and optimize database components, including queries, stored procedures, ETL processes, and conduct code reviews and optimizations to enhance performance.</li><li>Execute database schema and code changes, perform bottleneck analysis, and ensure efficient server/database performance, including recovery and restores when needed.</li><li>Plan for system growth and scalability to accommodate future requirements.</li><li>Ensure compliance with vendor license agreements to maintain legal and operational integrity.</li><li>Handle various reporting and data export/import tasks, working with different formats like CSV, XML, and unstructured data.</li><li>Document the database environment, processes, and best practices to maintain a comprehensive knowledge base.</li><li>Provide technical support and prompt problem resolution to address any database-related issues.</li><li>Be available for production/on-call support to maintain continuous system availability and address emergencies effectively.</li><li>Be willing to learn new technologies and assist with architecture and design.</li><li>Work efficiently within a high security environment (PCI-DSS Level 1 certified).</li><li>Communicate clearly and effectively to all levels of the organization.</li></ul><p><br></p><p><strong>Qualifications</strong></p><ul><li>5+ years of DB2 or PostgreSQL database administration experience.</li><li>2+ years of Snowflake data warehouse administration and development experience.</li><li>Experience working with cloud PaaS database services.</li><li>Jenkins, gitlab/bgit-bucket.</li><li>Linux/Unix experience.</li><li>Experience supporting highly available and fault tolerant systems.</li><li>Participate in on-call shifts, our infrastructure runs 24/7.</li><li>Security knowledge & experience (Ex. Database Encryption/masking/Certificates/PKI/SSH/VPN).</li><li>Expert problem solver by applying problem analysis methodologies.</li><li>Computer Science or Engineering degree or equivalent experience.</li></ul><p> </p><p><strong>Required Skills</strong></p><ul><li>Advanced Azure cloud technologies experience.</li><li>Experience on cloud database deployment using terraform.</li><li>Azure Cosmos or similar database technology experience.</li><li>Desire to automate everything, automate & anything.</li><li>Database development experience.</li><li>Networking experience (Ex. TCP/IP, UDP, Routing, Firewalls, load-balancers).</li><li>Desire to document everything.</li><li>PCI-DSS or similar experience (ex. financial/government/healthcare).</li><li>Understanding of the ITIL framework.</li><li>Familiarity with JBoss or WebSphere application server.</li></ul>