About TSR:

TSR is a relationship-based, customer-focused IT and technical services staffing company.

For over 40 years TSR, Inc. and its wholly owned subsidiary, TSR Consulting Services, have prospered in the Information Technology staffing business, earning the respect of companies both large and small with well refined candidate screening, timely placement, and a real understanding of the right skill sets required by our clients.

Mission & Vision

We do not believe in building a vision around the company but building a company around our vision, which is simply;

Every employee's voice matters, their effort is appreciated, and their talent is rewarded.

We challenge each employee daily, to raise the bar on how we treat our consultants and candidates. For far too long in this industry, candidates have been ghosted, lied to, or placed at a client and then forgotten about. Each day our staff works tirelessly at qualifying and placing, top talent with our clients, in a compassionate and caring manner.

Not every candidate is a match for the job, but every candidate and consultant will be treated with respect and professionalism.

Database Engineer (Non-Payrolled)

Job Description

• Location: New York, New York
• Type: Contract
• Job #79723

Our client, a leading publishing company, is hiring a Database Engineer on a contract basis.
Job ID #:79723

Work Location:
New York, NY

Summary:

Job Responsibilities:
• Supporting the data persistence technologies and data design relationships on the client's data platforms and associated applications.
• Developing and implementing technology solutions in an RDBMS environment (PostGres, MySQL and Oracle) including tuning packages, stored procedures, functions, triggers, and views.
• Developing search solutions on ElasticSearch based search technologies, including optimizing indexes, creating/organizing facets & filters.
• Engineering data models including data structures, metadata modeling and data governance.
• Performing logical and physical schema design, parent-child relationships, many-to-many relationships, normalization, denormalization, clusters, indexes, and IOTs.
• Participating in a quality-first Agile scrum development team, providing story point estimates and tracking effort against task, weekly grooming sessions, sprint planning, and daily stand ups, communicating effectively in written and verbal form with teammates and manager
• Honors MHE core behaviors, treating others with respect, honoring commitments to the team, seeking out & integrating feedback.
• Participate in code reviews and provide actional, objective feedback to peers

Required Qualifications:
• Experience in configuring, tuning, and optimizing RDBMS solutions on AWS Aurora and RDS on PostGres or MySQL, with storage expertise in indexing, access methods, locking, logging, caching, transaction processing, replication, backup/restore and buffer management.
• Experience in design, development, and management of data on graph database clusters and nodes, including performance, capacity planning, and cost forecasting.
• Experience with database engine internals (query processing): query compilation, optimization, execution, parallel execution.
• Experience in NoSQL system implementation, distributed systems, consensus-based quorum replication.
• Experience in data security and encryption algorithms.
• Knowledge of advance coding skills SDLC of Object-Oriented Analysis & Design (OOAD), Service Oriented Architecture (SOA) design principles, design patterns, application architectures, unit, integration, and system testing strategies.
• Knowledge of middleware caching strategies such as Redis, Couchbase, ElasticSearch and other noSQL Cache systems.
• Engineer (design and code) solution in the most clear, concise, and optimal way possible based on time and other constraints; coordinate best development approach with Architects, Engineers, Database Developers, and others.
• Quality first approach to the user experience, demonstrating empathy towards the user experience and system integration throughout an enterprise feature(s) workflow.
• Understanding of event-driven system architectures.
• Knowledge of the layers of connectivity from a service call to the DB, transaction control, isolation level, etc.; review existing code and recommend refactoring where applicable.
• Knowledge of CI/CD build lifecycle, version control and release management: Terraform, Jenkins, GitHub, Sonar, Puppet, CloudFormation.
• Knowledge of AWS services such as: EC2, IAM, CloudWatch, CloudFormation, Lambda, EMR, Hadoop, Kinesis, RedShift, S3, DynamoDB, Apache Spark.
Nice to Have:
• Experience in designing and implementing Oracle Application Express (APEX) solutions utilizing ORDS, restFul web services, SQL and PL/SQL.

Pay Range: $65- $74/hour