Job Description | Details |
---|---|
Company Name | Impact Analytics |
Post Name | Database Engineer |
Employment Type | Full time |
Job Location | India |
Expected CTC | Not specified |
Vacancy | Not specified |
Starting Date of Online Application | Not specified |
Last Date of Online Application | Not specified |
Job Summary:
As a Database Engineer, you will analyze database design and architecture requirements for distributed applications, develop, construct, test and maintain existing and new data-driven architectures, and align architecture with business requirements to provide optimal solutions.
Responsibilities:
- Analyze database design and architecture requirements for distributed applications.
- Develop, construct, test, and maintain existing and new data-driven architectures.
- Align architecture with business requirements and provide solutions that best solve business problems.
- Build infrastructure for optimal extraction, transformation, and loading of data from various sources on the Cloud (AWS / GCP) using well-defined ETL tools like PySpark, Data Flow.
- Acquire and clean data from multiple sources across the organization.
- Design custom tools to collate the data.
- Improve data reliability, efficiency, and quality.
- Develop automated tasks for data operations.
- Deliver updates to stakeholders based on analytics.
- Set up practices on data reporting and continuous monitoring using Prometheus, ELK, or similar tools.
Qualifications:
- Seven or more years as a hands-on technologist with a good mix of application development and database development.
- Expert level SQL, PostgreSQL, including stored procedures, functions, triggers, and views.
- Strong understanding of database design and modeling.
- Ability to write database code efficiently without compromising data quality, privacy, or security.
- Knowledge of database design principles, query optimization, index management, integrity checks, statistics, partitioning, and isolation levels.
- Good understanding of PostgreSQL replication, high availability, and clustering across availability zones and regions.
- Good understanding of database backup and restore to align with data law.
- Good understanding of a programming language, preferably Python, for custom scripts.
- Understanding NoSQL and in-memory databases is a value add.
- Participate in an agile software development lifecycle, including providing testing guidelines for database-related changes.
Additional Information:
- This role involves data acquisition and clean-up from multiple sources, developing automated tasks, and delivering updates based on analytics.
- Experience with data reporting and continuous monitoring tools such as Prometheus and ELK is required.
Important Notice and Disclaimer:- CareerBoostZone platform is a free Job Sharing platform for all the Job seekers. We don’t charge any cost and service fee for any job which is posted on our website, neither we have authorized anyone to do the same. Most of the jobs posted over Seekajob are taken from the career pages of the organizations. Jobseekers/Applicants are advised to check all the details when they apply for the job to avoid any inconvenience.