DallasRecruiter Since 2001
the smart solution for Dallas jobs

Data Modeler

Company: Pinnacle Group
Location: Dallas
Posted on: September 16, 2020

Job Description:

Data Modeling and Design - Data Modeler The Data Modeling and Design team is comprised of data modelers and database administrators who work with the application teams to understand the client business and data needs and implement various database technologies to support those needs. The team uses Agile development following the Kanban methodology and is in the process of developing DevOps practices. The DBA will report under Enterprise Data and Analytics. Candidate will work with the Data Modeling and Design team to ensure well-designed database solution are maintained and promoted throughout the environment and that all incoming and ongoing projects that utilize database technology conform to the enterprise data model and meet standards for accuracy, consistency, and reliability. Design, create, implement, and support database schemas to meet project and system design requirements Understand and translate business needs into data models supporting long term solutions Participate and lead discussions on logical and physical database design with business and technical teams in support of Technology investment projects Analyze data related system integration challenges and propose appropriate solutions Engage with software quality teams and other organizations to ensure that quality standards are met Partner with appropriate infrastructure team regarding physical database design to ensure high scalability and availability Assist business analysts, developers, and related organizations to understand and use an agreed formal model, the concepts of the organization and how they relate to one another Assist the Database Engineering team with analysis and troubleshooting, fine tuning application performance and identifying performance improvement opportunities Partners with different areas within Technology and across the company to lead various activities required to support the Technology Roadmap. Personally responsible for driving analysis, recommendations, and delivery across many Enterprise Data Technology capabilities. Modify database objects according to requests and perform tests independently or with a team Impact analysis and assessment of database changes - at both object and code level Impact analysis and assessment of application logic changes Impact analysis and assessment of business process changes Work closely with external vendor on design changes, patches and updates, and liaison with project team Partners with different areas within Technology and across the company to lead various activities required to support the Technology Roadmap. Required Skills (years skill) 4 year college degree in Business, Computer Science, Information Technology or related field or equivalent education preferred. 10 plus years of experience in a Senior DBA role with a concentration in data modeling, application development, and executing medium or large tiered application database or data mart projects. 10 plus years database modeling or design 6 plus years of experience with Postgres database 6 plus years Postgres SQL or equivalent 3 plus years' experience with Amazon AWS, DynamoDB, Redshift, ElastiCache, and DocumentDB Working knowledge of Schema as Code. Strong analytical and problem solving skills. Experience with a DevOps model of software development and deployment Agile development methodologies Must be proficient with ANSI standard SQL and be able to troubleshoot and tune SQL queries, stored procedures, triggers, indexes, functions, and be able to identify and resolve performance issues Must be proficient with Data Architecture or Design principles and have the ability to clearly understand logical and physical data modeling techniques and optimize them for project requirements. Must have strong written and verbal communication skills, including the ability to communicate complex issues in a structured and concise manner. Ability to coach or mentor co-workers Additionally Must have the ability to assume a high level of responsibility and to work independently in a cross-functional, team oriented environment. Must have the ability to implement complex changes to existing database schemas. Must have the ability to properly manage highly sensitive and confidential information. Must have the ability to contend with the range and complexity of large business problems. Must have the ability to plan and support large business initiatives. Must have the ability to partner and work effectively with multiple levels of management to develop and implement Company plans. Must be proficient in developing and delivering presentations to medium to large audiences including senior leadership. Proficient in Microsoft Office suite (Excel, Word, ppt, etc) Preferred Skills 5 to 8 years design, configuration, and implementation of database security 3 to 6 years' experience with Oracle Exadata, RAC, Data Guard, Golden Gate 3 to 6 years' experience with Oracle 11g or higher 3 to 6 years Linux andor UNIX shell scripting Experience with implementing Data Quality processes, governance and tools Experience with using and applying the Agile development methodology Functional and QA testing experience preferred Data Analysis aka Data Archaeology' experience preferred Experience in implementing enterprise data programs a plus LI-JK1

Keywords: Pinnacle Group, Dallas , Data Modeler, Other , Dallas, Texas

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other Other Jobs


Sort Center- Seasonal Sortation
Description: br br br Seasonal Warehouse Sort Team br br Location: br Coppell, Irving and Carrollton, TX br br Job opportunities vary by location. We update postings daily with open positions. br (more...)
Company: Amazon
Location: The Colony
Posted on: 09/25/2020

Remote Work-From-Home Independent Contractor - Call Center Representative
Description: We got what you want, you got what we need Goodbye long commutes, rigid schedules, and busybody managers. Hello, Liveops. Our well-known clients are seeking Independent Contractors to provide virtual (more...)
Company: Liveops
Location: The Colony
Posted on: 09/25/2020

Bilingual RN/LVN Pediatric Home Health Nurse
Description: Location: Tyler, TX Join our team as a BILINGUAL Home Health Pediatric Nurse for a growing company that has a huge HEART The Company: Angels of Care Pediatric Home Health is a family, clinically-owned (more...)
Company: Angels of Care
Location: Tyler
Posted on: 09/25/2020


Supervisor, Claims
Description: Job Description Position Purpose: Oversee the day to day work functions of
Company: Corporate
Location: Tyler
Posted on: 09/25/2020

Application Developer
Description: The Digital S/W Engineer Intmd Analyst is a developing professional role. Deals with most problems independently and has some latitude to solve complex problems. Integrates in-depth specialty area knowledge (more...)
Company: Citi
Location: The Colony
Posted on: 09/25/2020

Appliance Repair Techs - Dallas
Description: Key Benefits ul li Work where you want, when you want li Full Support - You do the repairs, we do the rest li Twice Weekly pay li Be the next
Company: PULS
Location: Wylie
Posted on: 09/25/2020

CDL-A OTR Driving Jobs - 2 Yrs. OTR EXP Req'd - Avg. $75k/Year
Description: What We Offer: Most drivers average 75,000 per Year 6,000 sign-on bonus for qualified drivers Generous home time Home when you want, for as long as you need 100 no-touch freight 95 drop and hook (more...)
Company: Tri National Inc
Location: Wylie
Posted on: 09/25/2020

RN, ER, FT, 11A-11P
Description: Details: Advancing Healthcare Together The Future of Healthcare is in East Texas br Why UT Health - East Texas br Our People. Our people truly are our greatest strength. They make a massive difference (more...)
Company: UT Health East Texas
Location: Tyler
Posted on: 09/25/2020

IT Professional (Part-Time)
Description: IT Professional Part-Time 1,719 locationsPart-timeSalary: 13.00 to 33.00 /hourThis position requires enlistment in the United States Army Reserve as a soldier.As a part of a team of soldiers,
Company: U.S. Army
Location: Tyler
Posted on: 09/25/2020

Team Member - unit 967 - FM 2493
Description: Description: br The Team Member is a business partner responsible for fulfilling the purpose of Whataburger by promptly ensuring each customers experience meets or exceeds expectations. The Team Member (more...)
Company: Whataburger Ventures LLC
Location: Tyler
Posted on: 09/25/2020

Log In or Create An Account

Get the latest Texas jobs by following @recnetTX on Twitter!

Dallas RSS job feeds