SQL Developer / Database Engineer

NAM Info Inc; Mount Laurel Township (NJ); In loco; USD 100.000 - 150.000; Tempo pieno

Descrizione del lavoro

Responsibilities include ensuring data accuracy and integrity, collaborating with cross-functional teams, and providing timely updates on tasks and risks. Strong experience across SQL Server, Oracle, and PostgreSQL is required in a fast-paced environment.

Competenze

• Experience with SQL Server, Oracle or PostgreSQL in large-scale environments.
• Strong SQL programming and tuning capabilities.
• Background in data modeling and database design for scalable data platforms.

Mansioni

• Design, develop, and maintain complex SQL queries, stored procedures, functions, and database objects.
• Translate business requirements into efficient and scalable database solutions.
• Optimize query performance and troubleshoot database-related issues.
• Support ETL, data integration, and data validation activities.
• Ensure data accuracy, integrity, and reliability through testing and quality checks.
• Collaborate with development and business teams to deliver high-quality solutions.
• Provide timely updates on technical tasks, risks, and issue resolution.

Conoscenze

SQL Server

Oracle

PostgreSQL

Advanced SQL Programming

Performance Tuning

Query Optimization

Data Modeling

Database Design

ETL and Data Integration

Agile Development Methodologies

Shell scripting

JSON data queries

Scheduling & Splunk monitoring

Strumenti

Azure DB

Cosmos DB

Descrizione del lavoro

• Design| develop| and maintain complex SQL queries| stored procedures| functions| and database objects.
• Translate business requirements into efficient and scalable database solutions.
• Optimize query performance and troubleshoot database-related issues.
• Support ETL| data integration| and data validation activities.
• Ensure data accuracy| integrity| and reliability through testing and quality checks.
• Collaborate with development and business teams to deliver high-quality solutions.
• Provide timely updates on technical tasks| risks| and issue resolution.
• Required Skills:SQL Server / Oracle / PostgreSQLAdvanced SQL ProgrammingPerformance Tuning & Query OptimizationData Modeling & Database DesignETL and Data IntegrationAgile Development MethodologiesAzure DB| Cosmo DB| Shell scripting | JSON query and data structure Auto sys scheduling and splunk monitoring tool (Nice to have)"