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 & QualificationsTypically 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 / hrPay 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).