Principal Data Modeler / Database Engineer – Richardson, TX – Act...
SOC - Richardson, Texas, United States, 75080
Work at SOC
Overview
- View job
Overview
12+ months, with the possibility for extension and/or conversion to client FTE. Candidates must have an active TS / SCI clearance to be considered for this role. Our client is hiring a Principal Data Modeler / Database Engineer in Richardson, TX or Aurora, CO. You will have the opportunity to directly impact the world around you and contribute to classified programs and technologies you are passionate about. This position involves designing, creating, updating, and managing databases and high-performance data models. What You Will Do Identify and understand customer needs and apply sound, demonstrable understanding of database principles, theories, and concepts related to software engineering to translate those needs into 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 meet 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, including 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. Apply proven problem solving and analytical skills. Work effectively in an Agile / Scrum environment. Obtain Security+ certification within 60 days of start date. Qualifications You Must Have Typically requires a degree in Science, Technology, Engineering, or Mathematics (STEM) and a minimum of 8 years of Database Engineering experience. At least five years of experience performing relational data modeling with Oracle and PostgreSQL RDBMS. Eight years of experience with Oracle SQL and PL/SQL, and PostgreSQL SQL and PL/pgSQL. Experience with bash scripting and Python. Experience working with Systems and Software Engineers to design, implement, and modify backend databases to interact with applications. Strong Linux command line skills for database administration activities and deployment automation. Active and transferable TS / SCI clearance prior to start. U.S. Citizenship is required as only U.S. Citizens are eligible for a clearance. Qualifications We Prefer Existing Security+ Certification (or higher). Experience using AWS RDS for Oracle and AWS Aurora PostgreSQL. Experience with NoSQL databases such as MongoDB and DynamoDB. Data architecture experience for critical design decisions. Troubleshooting database issues like Disaster Recovery, replication, backups, and performance. SQL tuning experience in Oracle and PostgreSQL. Knowledge of database security controls and audit & compliance requirements. Experience virtualizing or containerizing databases. Experience automating routine tasks. Experience with Oracle Spatial and/or PostgreSQL PostGIS. Experience using git source control. Experience with Atlassian Jira and Confluence. Employment Prerequisites Successful completion of a background investigation and drug urinalysis are required to be eligible for this position. SOC, a Day & Zimmermann company, is an Equal Opportunity Employer.
#J-18808-Ljbffr