Database Engineer

Alpharetta, GA - USA

Monthly Salary: Not Disclosed

Posted on: 17 hours ago

Vacancies: 1 Vacancy

Job Summary

Role: Database Developer OR Database Engineer

Location: Alpharetta GA (Hybrid 3 Days Onsite Per Week)

Duration: Contract (C2C)

(Needed 8 to 30 Years only)

Job Description:

RDBMS Expertise:

Profound knowledge and hands-on experience in RDBMS - Oracle and PostgreSQL.

Strong understanding of database architecture design and performance optimization.

Expertise in SQL for creating queries stored procedures and views.

Database Migration:

Experience in database migrations (preferred Oracle to PostgreSQL).

Ability to perform data mapping conversion and validation.

Proficient in using tools and scripts to automate migration processes.

Data Engineering & Analysis:

Proficiency in Databricks for big data processing and analytics.

Skilled in Python and PySpark for data manipulation and analysis.

Capability to develop and optimize ETL processes.

Job Scheduling & Automation:

Experience with setting up and maintaining Databricks jobs for periodic reporting.

Familiar with workflow orchestration tools for task automation.

Performance Optimization:

Skilled in performance tuning and troubleshooting of PostgreSQL and Oracle databases.

Experience in indexing query optimization and caching strategies.

Cloud Platforms:

Familiarity with cloud-based database services and infrastructure specially on AWS.

Database Design & Development:

Design and develop robust database solutions that meet data storage and retrieval requirements.

Create scripts and procedures to automate routine database tasks.

Migration & Implementation:

Lead the migration process from Oracle to PostgreSQL ensuring data integrity and minimal downtime.

Develop comprehensive migration plans and execute them proficiently.

Support & Maintenance:

Monitor database performance and implement necessary improvements.

Reporting & Analytics:

Develop and maintain Databricks jobs for generating business reports and analytics.

Provide insights from data analysis to support decision-making.

Role: Database Developer OR Database Engineer Location: Alpharetta GA (Hybrid 3 Days Onsite Per Week) Duration: Contract (C2C) (Needed 8 to 30 Years only) Job Description: RDBMS Expertise: Profound knowledge and hands-on experience in RDBMS - Oracle and PostgreSQL. Strong understanding ...