drjobs Senior Data Engineer (PostgreSQL and d SQL syntax)

Senior Data Engineer (PostgreSQL and d SQL syntax)

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Jobs by Experience drjobs

4-5years

Job Location drjobs

Ahmedabad - India

Monthly Salary drjobs

81 - 100

Vacancy

1 Vacancy

Job Description

This is a remote position.

We are seeking a Senior Data Engineer (PostgreSQL and d SQL syntax) to join our team.

Responsibilties:
  • Work closely with other talented database professionals & software engineer. Our vetting process means you can count on your team members to know what they are talking about.
  • Work from home or work remotely from anywhere.
  • Flexible work schedule: meaning you can work regular hours or whenever you work best
  • Work-life balance is essential and highly valued at company. If you choose to work more than 40 hours you ll be compensated for the
    extra work.
  • Work on interesting projects solving complex business problems with custom software.
  • 100 hours per year to focus on your professional development. We invest in your growth.
  • Profit sharing bonus means as we re successful you re successful.
  • Variable compensation opportunities for being part of on-call team rotation and performing client focused work outside of normal business hours.
  • Excellent benefits package including medical insurance dental vision 401(k) matching FSA disability life insurance and paid parental leave.

Requirements

  • Basic understanding of data modeling design patterns such as 3NF and star-schema.
  • Data warehouse design experience using medallion architecture and/or snowflake methodologies.
  • Experience with Microsoft Fabric Synapse or Snowflake.
  • Reporting tools such as Power BI.
  • ETL tools such as Azure Data Factory.
  • Performance tuning databases and long running queries.
  • Stored procedure development.
  • Database migrations and/or database server consolidations including Azure SQL solutions.
  • Configure Azure SQL databases elastic pools and Managed Instances.
  • Perform health checks assessments and security audits for client databases.
  • Implement replication and/or log shipping for disaster recovery or reporting scenarios.
  • Evaluate disk I/O and network throughput for SQL performance.

    Nice to Have Experience:

  • Advanced SQL syntax.
  • SQL Server installation & configuration in production environments using best practices.
  • Availability Group & failover cluster configuration.
  • Exposure to MySQL and/or PostgreSQL environments.
  • Familiarity with Red Gate SQL Monitor or similar tools.
  • Right-sizing VM for SQL Server.
  • Develop and maintain robust backup recovery and maintenance plans.
  • Holding Microsoft certification(s) in the Data & AI solutions field are a plus.
  • Microsoft Certified: Fabric Analytics Engineer Associate (DP-600).
  • Microsoft Certified: Fabric Data Engineer Associate (DP-700).
  • Microsoft Certified: Power BI Data Analyst Associate (PL-300).
  • Microsoft Certified: Administering Microsoft Azure SQL Solutions (DP-300).

Benefits

  • Work Location: Remote
  • 5 days working

Basic understanding of data modeling design patterns such as 3NF and star-schema. Data warehouse design experience using medallion architecture and/or snowflake methodologies. Experience with Microsoft Fabric, Synapse or Snowflake. Reporting tools such as Power BI. ETL tools such as Azure Data Factory. Performance tuning databases and long running queries. Stored procedure development. Database migrations and/or database server consolidations, including Azure SQL solutions. Configure Azure SQL databases, elastic pools, and Managed Instances. Perform health checks, assessments, and security audits for client databases. Implement replication and/or log shipping for disaster recovery or reporting scenarios. Evaluate disk I/O and network throughput for SQL performance. Nice to Have Experience: Advanced SQL syntax. SQL Server installation & configuration in production environments using best practices. Availability Group & failover cluster configuration. Exposure to MySQL and/or PostgreSQL environments. Familiarity with Red Gate SQL Monitor or similar tools. Right-sizing VM for SQL Server. Develop and maintain robust backup, recovery, and maintenance plans. Holding Microsoft certification(s) in the Data & AI solutions field are a plus. Microsoft Certified: Fabric Analytics Engineer Associate (DP-600). Microsoft Certified: Fabric Data Engineer Associate (DP-700). Microsoft Certified: Power BI Data Analyst Associate (PL-300). Microsoft Certified: Administering Microsoft Azure SQL Solutions (DP-300).

Employment Type

Full Time

Company Industry

About Company

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.