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