Database Engineer at Transcend Softech LLC

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