- Company Name
- TRANSREACH TALENT LLC
- Job Title
- DB2/PostgreSQL DBA
- Job Description
-
Job title: DB2/PostgreSQL DBA
Role Summary: Leads the administration, development, and optimization of DB2 and PostgreSQL databases while managing Snowflake data warehousing. Ensures high availability, security compliance, and performance across on‑premise and cloud environments.
Expectations: Deliver reliable database services, participate in on‑call rotations, apply best practices for automation, documentation, and security, and collaborate cross‑functionally to meet business data needs.
Key Responsibilities:
• Install, upgrade, and maintain DB2, PostgreSQL, and Snowflake instances.
• Design, implement, and support 24x7 high‑availability and fault‑tolerant solutions.
• Optimize database and server performance: hardware, OS, and DB settings.
• Develop and refine SQL, stored procedures, ETL pipelines; conduct code reviews and performance tuning.
• Manage schema changes, backups, restores, and disaster recovery.
• Plan capacity, scaling, and hardware upgrades.
• Enforce database security: encryption, masking, PKI, SSH, VPN.
• Perform data import/export across CSV, XML, and unstructured formats.
• Document architecture, processes, and best practices.
• Provide technical support, troubleshoot issues, and participate in 24/7 on‑call duty.
• Communicate status and technical details to stakeholders at all levels.
Required Skills:
• ≥5 years DBA experience with DB2 or PostgreSQL.
• ≥2 years Snowflake data warehouse administration & development.
• Experience with cloud PaaS databases, Linux/Unix, and cloud migration.
• CI/CD tools: Jenkins, GitLab/Bitbucket.
• High‑availability & fault‑tolerance design and support.
• Security fundamentals: Database encryption, masking, certificates, PKI, SSH, VPN.
• Problem‑solving using analytical methodologies.
• Strong written and verbal communication.
Required Education & Certifications:
• Bachelor’s degree in Computer Science, Engineering, or equivalent experience.
• Certifications in database administration, cloud platforms, or security are a plus.
---