Data Engineer

Carnegie Affiliates

Apply to this job
New York, NY, us on site Until 8/21/2026 H-1B sponsor history First posted March 21, 2025 Last posted March 21, 2025
Job description

Major Subscription Based Content  Corporation

Managing database systems in AWS.  Table and database schema architecture

Normalization of database schema

Query creation and optimization.  Index creation, management and optimization. Stored procedures, prepared statements, triggers, indexing, datawarehousing, etc.

PHP programming - scripting, database extraction and model layers.  SQL programming.  Recommend and implement best practices in queryand schema architecture, Smoke and Load Testing, etc etc


There is alot more 

Strong knowledge of MySQL and SQL. Should have interest in learning about data and experience working with column based databases like Vertica and open to NoSQL databases such as MongoDB.

Expertise with MySQL 5.x running in a Linux 24x7 production environments

Strong knowledge of Linux fundamentals

Strong knowledge of Database Thery and concepts

Strong scripting and analytical skills

Expertise in writing complex and elegant SQL queies

Experience with MySQL Security and performance tuning

etc,etc,etc

All your information will be kept confidential according to EEO guidelines.

About this role

Summary

Manage databases in AWS, optimize queries, schemas, and scripting with MySQL and SQL.

Job title

Data Engineer

Experience level

not specified

Industry

software

Location requirements

must be in New York, NY, with remote options allowed

Salary

Not specified

Visa sponsorship

H-1B sponsor history

Management role

No

Skills & keywords

Required skills

MySQLSQLLinuxschema architecturequery optimization

Preferred skills

VerticaMongoDBNoSQLperformance tuningsecurity

Specializations

database systemsSQLMySQLNoSQLdata warehousing
Locations

Structured locations inferred from the posting.

New York, NY, USA

Hybrid City