Database Engineer

A client of Innova Solutions is immediately hiring for a Database Engineer
Position type: Full-time, Contract
Duration: 12 Months
Location: Richardson, Texas-Onsite
As a Database Engineer,you will:

• Day to Day Responsibilities
• You would be familiar with designing, creating, updating, and managing databases and high-performance data models.
• Identify and understand customer needs and apply sound, demonstrable understanding of database principles, theories, and concepts related to software engineering to translate those needs to viable design solutions.
• Translate needs and design requirements into physical data models.
• Analyze business requirements, RFCs, and technical specifications to identify data modeling impacts and design needs.
• Collaborate with systems engineers, product owners, architects, and stakeholders to gather and validate data requirements.
• Design new database structures (tables, indexes, constraints, views) and modify existing models to accommodate program needs.
• Author and implement database data model changes (DDL) using database change control automation.
• Work with developers on best practices for interacting with databases, writing and maintaining SQL statements.
• Utilize data modeling tools such as Oracle SQL Developer Data Modeler, Oracle Designer, and others.
• Demonstrate critical thinking skills with the ability to communicate concepts and ideas clearly.
• Use proven problem solving and analytical skills.
• Work in an Agile/Scrum environment.
• Obtain Security+ certification within 60 days of start.

The ideal candidate will have:

• Required Skills & Qualifications
• Typically requires a degree in Science, Technology, Engineering, or Mathematics (STEM) and a minimum of 8 years of Database Engineering experience.
• Five (5) years of experience performing relational data modeling with Oracle and PostgreSQL Relational Database Management Systems (RDBMS).
• Eight (8) years of experience with Oracle SQL and PL/SQL and PostgreSQL SQL and PL/PGSQL skills.
• Experience with bash scripting and python.
• Experience working with Systems and Software Engineers to design, implement, and modify backend databases to interact with applications.
• Experience and strong Linux command line skills to perform database administration activities, deployment automation.
• Active TS/SCI CI Poly prior to start date.
• Preferred Skills:
• Existing Security+ Certification (or higher).
  Experience using AWS RDS for Oracle and AWS Aurora PostgreSQL database services.
• Experience with NoSQL database products such as MongoDB and DynamoDB.
• Data architecture experience for critical design decisions (such as the suitability of a product/technology for a given use case).
• Experience troubleshooting database issues such as Disaster Recovery, replication & backups and other related issues.
• Experience troubleshooting database performance issues.
• Strong SQL tuning experience in Oracle and PostgreSQL.
• Experience with database security controls and audit & compliance requirements.
• Experience virtualizing or containerizing databases.
• Experience with automating routine tasks.
• Experience using Oracle Spatial and/or PostgreSQL PostGIS.
• Experience using git source control.
• Experience using Atlassian Jira and Confluence.

Thank you!
PAY RANGE AND BENEFITS:
Pay Range*: $90-/hr to $100/hr
*Pay range offered to a successful candidate will be based on several factors, including the candidate's education, work experience, work location, specific job duties, certifications, etc.
Benefits: Innova Solutions offers benefits( based on eligibility) that include the following: Medical & pharmacy coverage, Dental/vision insurance, 401(k), Health saving account (HSA) and Flexible spending account (FSA), Life Insurance, Pet Insurance, Short term and Long term Disability, Accident & Critical illness coverage, Pre-paid legal & ID theft protection, Sick time, and other types of paid leaves (as required by law), Employee Assistance Program (EAP).