Job Responsibilities:
- Supporting the data persistence technologies and data design relationships on the McGraw Hill Higher Ed 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
- Title: Database Engineer
- Location: Remote
- Duration: 9 month initial contract
We’re looking for someone with:
· 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.
Job Types: Full-time, Contract
Benefits:
- 401(k)
- Dental insurance
- Health insurance
Schedule:
- 8 hour shift
- Day shift
- Monday to Friday
Work Location: Remote