Senior Database Engineer
Intone Networks New York
POSITION Senior Database Engineer LOCATION Remote EST/CST DURATION 6+ months Possible CTH INTERVIEW TYPE Video VISA RESTRICTIONS REQUIRED SKILLS 8-12 years experience Reporting & performance tuning PL/SQL, MySQL AWS how to scale, set up clusters Review & propose.
Schemas and database server, in the queries being executed. Propose solution for SQL long queries. SQL queries to improve performance. Monthly Reports solutions for all equipment at customer level. Design database structure for planned projects like file Management and Smart Tag.
Optimize Queries - Ensure that queries are properly optimized. Tables and create indexing. Ensure that tables are indexed on columns frequently used in WHERE clauses, JOIN conditions, and ORDER BY clauses. Adjust database configuration parameters (such as memory allocation, cache sizes, and connection limits) to match the hardware resources and workload of our system.
Add partitioning and sharding to distribute load if required. Large tables, consider partitioning them based on certain criteria (such as range or hash partitioning Evaluate database schema and consider normalizing or de-normalizing it based on the Current KC requirements.
Reporting Strategy Purpose reporting tool for automated report and dashboard. Establish a reporting cadence that provides timely insights without overwhelming stakeholders. Balance frequency with the availability of relevant data and the need for real-time decision-making.
Schemas and database server, in the queries being executed. Propose solution for SQL long queries. SQL queries to improve performance. Monthly Reports solutions for all equipment at customer level. Design database structure for planned projects like file Management and Smart Tag.
Optimize Queries - Ensure that queries are properly optimized. Tables and create indexing. Ensure that tables are indexed on columns frequently used in WHERE clauses, JOIN conditions, and ORDER BY clauses. Adjust database configuration parameters (such as memory allocation, cache sizes, and connection limits) to match the hardware resources and workload of our system.
Add partitioning and sharding to distribute load if required. Large tables, consider partitioning them based on certain criteria (such as range or hash partitioning Evaluate database schema and consider normalizing or de-normalizing it based on the Current KC requirements.
Reporting Strategy Purpose reporting tool for automated report and dashboard. Establish a reporting cadence that provides timely insights without overwhelming stakeholders. Balance frequency with the availability of relevant data and the need for real-time decision-making.
Explore various reporting tools available in the market. Consider factors such as functionality, ease of use, scalability, cost, integrations with existing systems, and support for data visualization.
SRI Tech Solutions IncPrinceton (NJ), 43 mi from New York
AWS DB Engineer Job Description: Experience in Database Engineering and Database Administration Experience with cloud computing platforms (AWS (required Experience with MongoDB and DocumentDB required. (required) Experience with migration...
Samsung SDS AmericaRidgefield Park, 10 mi from New York
JIRA and PPM
• Strong understanding of ServiceNow scripting (JavaScript, GlideScript) and workflow design.
• Fundamentals understanding of Database Engineering
• Strong understanding of JavaScript Data structures and algorithms
• Experience...
AmazonNew York
such as Python, Java, Scala, or NodeJS
• Experience mentoring team members on best practices- Experience with big data technologies such as: Hadoop, Hive, Spark, EMR
• Experience operating large data warehouses
• 7+ years of data engineering, database engineering...