Data Engineering·Confirmed live in the last 24 hours·
Full-timePlano, TX, USANo salary listedIn-person
About the Job
Requirements
At least 10 years of experience overall.
At least 5 years of experience as an Oracle Database Developer.
At least 3 years of experience working with MongoDB.
Proficiency in managing Oracle relational databases and MongoDB NoSQL databases.
Strong understanding of Oracle database concepts, including tables, views, materialized views, SQL, and schema design, and MongoDB administration, including document structure, JSON querying, and aggregation pipelines.
Experience monitoring and tuning database performance on Oracle and MongoDB platforms.
Experience managing backup and recovery procedures for Oracle and MongoDB databases.
Experience with query optimization and troubleshooting complex queries.
Experience using automation tools such as Autosys.
ETL process expertise and working knowledge of tools such as Informatica.
A bachelor's degree.
Good communication and documentation skills.
A solid understanding of data architecture and logical and physical data modeling for efficient database design.
Experience with stored procedures, triggers, table and index creation, database design and development, SQL tuning and optimization, and scripting such as Bash, Perl, or Python.
Ability to work independently with minimal guidance and understand requirements provided by Business Analysts.
Responsibilities
Monitor and tune database performance on Oracle and MongoDB platforms to ensure optimal query response times.
Manage backup and recovery procedures for Oracle and MongoDB databases to ensure data availability.
Write complex queries and troubleshoot them.
Write ETL programs to source data from upstream database systems and files in formats such as XML and CSV.
Desired Qualifications
Experience with database deployment automation tools such as Liquibase.
Experience with Agile processes and tools such as JIRA, Confluence Wiki, Bitbucket, Jenkins, and Ansible.
Job Description
Primary Skill: Oracle DB developer, Mongo DB Development, MS SQL, ETL, SSIS.
Secondary: Autosys, Informatica.
Experience: Minimum 10 Years.
5+ years of experience as an Oracle Database developer & 3+ years of experience working with MongoDB is required.
Autosys, Informatica, scripting such as bash, perl, or python, stored procedures, triggers, table and index creation and familiarity with database design and development.
Experience in SQL tuning optimization will be important.
Expected to have good communication and documentation skills.
Solid understanding of data architecture, logical and physical data modeling for producing efficient database design.
Experience writing complex queries, and query tuning and troubleshooting. In addition, resource will work independently with minimal guidance, in understanding requirements provided by Business Analysts and writing ETL programs to source data from upstream database systems as well as data sourced with various file formats such xml, csv etc.
Required Skills:
5+ years of experience as an Oracle Database Developer.
3+ years of experience working with MongoDB.
Proficient in managing both Oracle relational databases and MongoDB NoSQL databases.
Strong understanding of both Oracle database concepts (like tables, views, materialized views, SQL, schema design) and MongoDB administration (document structure, querying with JSON, aggregation pipelines).
Monitoring and tuning database performance on both platforms to ensure optimal query response times.
Managing backup and recovery procedures for both Oracle and MongoDB databases to ensure data availability.
Query optimization using various analysis methods.
Writing complex queries and troubleshooting.
Must have used automation tools like Autosys.
ETL Process expertise and working knowledge of tools like Informatica.
Must have worked with database deployment automation tools like Liquibase Desired Skills.
Experience with Agile process and tools like JIRA, confluence wiki, Bitbucket, Jenkins, Ansible, etc.
Qualifications
Bachelor's
Additional Information
All your information will be kept confidential according to EEO guidelines.