Senior Database Developer

Experience: 10 years

Job Description :

Skills; PySpark , Databrick , Performance tuning , Oracle PL/SQL, AWS, PostgreSQL

If interested, please share updated resume.

Skills Required:

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

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

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

             4.      Job Scheduling & Automation:

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

                       •          Familiar with workflow orchestration tools for task automation.

             5.      Performance Optimization:

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

                       •          Experience in indexing, query optimization, and caching strategies.

             6.      Cloud Platforms:

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

Responsibilities:

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

             2.      Migration & Implementation:

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

                       •          Develop comprehensive migration plans and execute them proficiently.

             3.      Support & Maintenance:

                       •          Monitor database performance and implement necessary improvements.

             4.      Reporting & Analytics:

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

                       •          Provide insights from data analysis to support decision-making.