Database Engineer

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.

Key Skills

Databases,SQL,Database Development,Microsoft SQL Server,Database Design,Performance Tuning,NoSQL,MySQL,Postgresql,Database Administration,MongoDB,Oracle

Employment Type : Full Time

Experience : years

Vacancy : 1