DBA

We are seeking a skilled and experienced Database Administrator (DBA) with 5-7 years of experience in managing and maintaining data solutions using Azure Data Factory, SQL Server, and Informatica. The ideal candidate will be responsible for the design, implementation, monitoring, and optimization of databases, and cloud-based data workflows.

Key Responsibilities:

Database Administration (SQL Server)

  • Install, configure, and manage SQL Server databases and instances in both on-premises and cloud environments.
  • Perform regular database backups, disaster recovery, and high availability configurations.
  • Optimize SQL Server performance by analyzing and tuning queries, indexes, and execution plans.
  • Monitor database health and troubleshoot performance issues and system errors.
  • Implement and enforce database security measures, access control, and user management.

Azure Data Factory (ADF)

  • Conceptual knowledge on ETL/ELT workflows using Azure Data Factory pipelines.

Informatica

  • Experience in Informatica PowerCenter and Informatica Cloud to understand the ETL workflows
  • Collaborate with business teams to understand data transformation requirements and optimize Informatica jobs.
  • Ensure proper version control and documentation for all Informatica processes.

General Responsibilities

  • Collaborate with development teams, architects, and business stakeholders for database-related solutions.
  • Perform data modeling and schema design for transactional and analytical systems.
  • Create and maintain database documentation, standards, and procedures.
  • Ensure compliance with data governance, regulatory, and security requirements.
  • Stay up to date with emerging database, cloud, and ETL technologies.

Required Skills and Qualifications:

  • Bachelor’s degree in Computer Science, Information Technology, or a related field.
  • 5-7 years of experience in database administration, basic knowledge on ETL, and data management.
  • Proficiency in SQL Server, T-SQL scripting, and performance optimization techniques.
  • Hands-on experience with Azure Data Factory for pipeline development and orchestration.
  • Experience in Informatica PowerCenter and Informatica Cloud for ETL processes.
  • Experience with cloud-based environments, especially Microsoft Azure.
  • Knowledge of data warehousing, data modeling, and schema design best practices.
  • Familiarity with automation tools for database and ETL processes.
  • Strong troubleshooting, problem-solving, and communication skills.

Preferred Qualifications:

  • Certification in Azure (e.g., Azure Data Engineer, Azure Solutions Architect) or Informatica.
  • Experience with DevOps tools and CI/CD pipeline implementation for database solutions.
  • Familiarity with other ETL and data integration tools.
  • Experience with data governance and compliance regulations (GDPR, HIPAA, etc.).

Soft Skills:

  • Strong analytical and problem-solving abilities.
  • Effective communication and collaboration skills across technical and business teams.
  • Ability to manage multiple priorities and projects simultaneously.
  • Strong documentation and reporting skills.
Not sure where to start? Ask IVY.
IVY