Senior Database Developer

Job Title: Senior Database Developer

Location: Alpharetta GA(3 days onsite in a week)

Job Type: 12 months contract with good possibility for extension

Skills Required

• 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.

Responsibilities

• 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.