Staff Database Architect & Data Modeler

Collins Aerospace in Annapolis, MD

  • Industry: Advertising/Marketing/Public Relations - Event Coordinator/Planner
  • Type: Full Time
  • $56,240.00 - 91,780.00
Apply for this job
Date Posted:2019-10-29-07:00Country:United States of AmericaLocation:HMD31: Annapolis, MD 2551 Riva Road , Annapolis, MD, 21401-7435 USAAt Collins Aerospace, we re dedicated to relentlessly tackle the toughest challenges in our industry all to redefine aerospace.Created in 2018 through the combination of two leading companies Rockwell Collins and United Technologies Aerospace Systems we re driving the industry forward through technologically advanced and intelligent solutions for global aerospace and defense. Every day we imagine ways to make the skies and the spaces we touch smarter, safer and more amazing than ever. Together we chart new journeys, reunite families, protect nations and save lives. And we do it all with some of the greatest talent this industry has to offer.We are Collins Aerospace and we hope you join us as we REDEFINE AEROSPACE.Our industry-leading experts are setting the standards for the aerospace industry and paving the way for the future. But as new challenges present themselves, we need fresh, creative and motivated minds to overcome these hurdles, help us break barriers and achieve new levels of innovation. Do you have what it takes to join a global, diverse organization that doesn t shy away from big opportunities? If so, we invite you to join our ranks and create the next generation of aerospace technologies.Together, we will nurture an engineering culture that values intellectual curiosity, risk takers and integrity. A place where we will challenge ourselves, our teams, and the status quo and where we will work to find a way the right way to achieve what others can only dream of.Role OverviewCollins Aerospace is seeking a Database Architect & Data Modeler to support our Surface Transportation and Critical Infrastructure team in developing and deploying complex integrated solutions and systems for the Rail/Transit industry who will be tasked with leading the design and management of data architecture and design of platform data models based on the current state, lessons learned from desired end state of systems including leveraging industry standard best practices for data modeling, data quality and further data monitoring. The Database Architect and Data Modeler will also design and architect database solutions for housing and protecting data as well as data warehouse solution and business intelligence reporting capabilities. The Database Architect and Data Modeler maintains and evolves core Platform databases by determining structural requirements, creating and maintaining documentation, developing and implementing holistic database solutions, acting as SME on platform architecture to advise derivative projects on normalized/optimized extensions. This role is the overall Database and Data Architect and Modeler for a long-term programs supporting platform development and associated applications. As a Database Architect and Modeler Provide Solution Development and Integration for agile teams, including requirements backlog management, DevOPS, database design, database tuning for software development, testing, ETL data migration, and support during release deployment. Assist with the client's data management strategies and management processes. Conceptual, logical, and physical data modeling for relational databases and advise on future tech-stack roadmap at enterprise level. Perform project tasks independently, and may direct the efforts of others. Participate in or lead the development of client deliverable content. Anticipate client needs and formulate solutions to client issues. Review deliverables for accuracy and quality. Qualifications require experience with designing, implementing, and tuning relational databases (e.g., Oracle, SQL Server, PostgreSQL) Experience with NoSQL databases (e.g., Cassandra, MongoDB). Preferred Agile experience. Experience designing and tuning data warehouses Cloud computing (AWS, Azure) Experience collaborating with clients to translate business needs.Primary Responsibilities:Determines database structural requirements by analyzing operations, applications, and programming; reviewing objectives; evaluating current systems; augmentation based on client requirements. Maintains core system optimization and normalization Develops database solutions by designing proposed system; defining database physical structure and functional capabilities, security, back-up, and recovery specifications, replication, fault-tolerance, etc.Installs database systems; develops flowcharts; applying optimum access techniques; coordinating installation actions; documents actions.Maintains database performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases; completing maintenance; answering user questions.Prepares users by conducting training.Provides database support by coding utilities, responding to user questions, and resolving problems.Updates job knowledge by participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.Accomplishes information systems and organization mission by completing related results as needed.Leads, coordinates and manages artifacts pertaining to Data Modeling, ER Diagrams and documentation, standards definitions and enforcement, ETL and Database loadingDevelopment and design of database stored procedures and triggers, etcExpertise and certification with Oracle, SQL Server, PostGreSQL, NoSQL and other databasesCloud computing and Big Data and data streaming solutions such as Hadoop and othersQualifications:This position requires a Bachelor s degree in the appropriate discipline and 7 years of relevant experience or an Advanced degree in the appropriate discipline and 5 years of relevant experience.In the absence of a degree, 11 years of relevant experience is required.Experience with Oracle database driven solutions with progressive experience from DBA/Developer to Architect Oracle Database Architecture experience including data structures, data dictionary, database schemas ; Strong PL/SQL and ETL skills Data architecture and data modeling tools and techniques including conceptual, logical and physical data models & schemas. Experience with ER Diagrams & Entity-Relationship Model (ERM), Semantic data modeling and/or Bachman Diagrams Experience with industry standard data modeling tools such as ERwin, Sparx, PowerDesigner or Embarcadero Experience with Oracle 12c and other databases required Desired Experience with: Oracle Grid Control, RAC, RMAN, Active Data Guard, OLAP, OBIEE, Oracle Database Fault, Oracle Label Security, Oracle Enterprise Manager. Experience and advocate for Agile practices and tracking mechanisms such as JIRA and/or previous experience or training as a Scrum Master and Agilist.At Collins, the paths we pave together lead to limitless possibility. And the bonds we form with our customers and with each other -- propel us all higher, again and again.Some of our competitive benefits package includes: Medical, dental, and vision insurance Three weeks of vacation for newly hired employees Generous 401(k) plan that includes employer matching funds and separate employer retirement contribution Tuition reimbursement Life insurance and disability coverage And moreApply now and be part of the team that s redefining aerospace, every day.United Technologies Corporation is An Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status, age or any other federally protected class.Privacy Policy and Terms:Click on this link to read the Policy and TermsNote to candidates regarding interview scams: We'd like to make it clear that UTC Aerospace Systems never asks candidates for money. If you've been approached with a job offer that you suspect may be fraudulent, we strongly recommend you do not respond, send money or personal information. Please report any suspicious activity to Talent Acquisition.
Apply for this job

You may be interested in these similar jobs!
Data Architect
Corporate Brokers in Annapolis, MD

- Candidate must be a US Citizen, or permanent resident with a green card. - Bachelor?s degree in relevant field preferred (STEM degree preferred), …

Read More
Data Warehouse Architect/Data Modeler
International Millennium Consultants Inc. (IMC) in Parkville, MD

Sr. IT Architect Data Warehouse/Data Modeler Location: Baltimore, MD 5 year contract position Preferred: Knowledge of education data Duties: Provides…

Read More
Data Modeler
OMM IT Solutions in Baltimore, MD

Urgently looking for a Data Modeler Description of Work: Design, architect, and build databases from determining business requirements to planning an…

Read More
Systems Engineer, Lead (Data Modeler) (Security Clearance Required)
Parsons in Fort George G Meade, MD

Ready for a challenge that will keep you on the cutting edge of cybersecurity? Parsons works on top level cybersecurity for national defense programs…

Read More
Systems Data Modeler II
Zapata Technology in Fort George G Meade, MD

Referral Eligible Summary:Zapata Technology is seeking a Systems Data Modeler in Fort Meade, MD. Check out the details below and our awesome benefits…

Read More
Systems Data Modeler III
Zapata Technology in Fort George G Meade, MD

Referral Eligible Summary:Zapata Technology is seeking a Systems Data Modeler in Fort Meade, MD. Check out the details below and our awesome benefits…

Read More
Data Architect/Modeler
ECS Federal in Washington, DC

ECS is seeking a Data Architect/ Modeler to work in our Washington, DC office. Please Note: This position is contingent upon contract award. Job Desc…

Read More
Data Architect/Modeler (Security Clearance Required)
ECS Federal in Washington, DC

ECS is seeking a Data Architect/ Modeler to work in our Washington, DC office. Please Note: This position is contingent upon contract award. Job Desc…

Read More
8579 : Junior Data Modeler in Baltimore, MD
kpg99 in Baltimore, MD

Junior Data Modeler Baltimore, MD 6+ Months Ps and f2f/ Video Job Description: Experience with logical data modeling Experience using ERwin data mode…

Read More