Oracle, NOSQL, MongoDB, SQL, DB performance tuning
Contract W2, Contract Independent, 12 Months
Depends on Experience
Work from home available
Job Title: Database Developer
Location: Tampa, FL
Type: Contract (W2/C2C with own corp)
Job Description:
Technology Skills:
• Must have expert level (hands-on) knowledge and understanding in with MS SQL Server/ Oracle and NoSQL
• Data Modelling - dimensional/reporting, data warehousing and transactional use cases (Physical and Logical modelling)
• Performance optimizations on SQL Server/ Oracle, SQL tuning and investigation of bottlenecks
• Ability to translate architecture and low-level requirements to design and code using SQL
• Hands-on MongoDB experience and how to design the best MongoDB schema for a given application will be added advantage
• Knowledge on various Mongodb libraries and apis for different programming languages and platform
• Demonstrate an understanding of the differences between typical relational and NoSQL database development and access methodologies
• Must be able to design logical and physical data models for performance aligned to business use cases
• Hands on SQL features - Indexes, Partitioning, Bulk loads, DB configuration, Security/Roles
• Scale and optimize performance via schema design, query tuning, and index creation.
• Knowledge of reporting and query tools and practices.
Qualifications :
• Minimum of 4-6 years of Extensive experience in SQL Server/ Oracle and must have in depth architecture knowledge of SQL engine
• SQL Management Studio, SQL Server Analysis Services, SQL Server Reporting Services, and Integration Service
• 2+ years MongoDB development, DB performance tuning, aggregation framework experience, and query profiling
• 2+ years of Elastic stack (Elasticsearch, Logstash, Beats, Kibana) experience is preferable
Education :
• Bachelors degree/University degree or equivalent experience.