Lead Database Administrator And Business Data Analyst

Lead Database administrator and BusinessData analyst
Description -
Applies developed subject matter knowledge to solve common and complex business issues within established guidelines and recommends appropriate alternatives. Works on problems of diverse complexity and scope. May act as a team or project leader providing direction to team activities and facilitates information validation and team decision making process. Exercises independent judgment within generally defined policies and practices to identify and select a solution. Ability to handle most unique situations. May seek advice in order to make decisions on complex business issues.
Responsibilities

• Designs and establishes secure and performant data architectures, enhancements, updates, and programming changes for portions and subsystems of data pipelines, repositories or models for structured/unstructured data.
• Analyzes design and determines coding, programming, and integration activities required based on general objectives and knowledge of overall architecture of product or solution.
• Writes and executes complete testing plans, protocols, and documentation for assigned portion of data system or component; identifies and debugs, and creates solutions for issues with code and integration into data system architecture.
• Leads a project team of other data engineers to develop reliable, cost effective and high-quality solutions for assigned data system, model, or component.
• Collaborates and communicates with project team regarding project progress and issue resolution.
• Represents the data engineering team for all phases of larger and more-complex development projects.
• Build cloud-based database systems of high availability and quality.
• Design and implement database in accordance to requirements.
• Minimize database downtime and monitor database performance to provide fast query responses.
• Provide proactive and reactive data management support and training to users.
• Determine, enforce and document database policies, procedures and standards.
• Perform tests and evaluations regularly to ensure data security, privacy and integrity.
• Diagnose and troubleshoot database errors.
• Review SQL code and database changes.
• Manage database deployments to all environments.
• Create and manage database reports, visualizations, and dashboards.
• Provide database reports to the users, in appropriate format and in a timely manner.
• Recommend and implement emerging database technologies.
• Establish consistent customer service SLAs and commit to high quality in the customer experience.
• Work with engineering teams to resolve production incidents.
• Coordinate database processes across different products and organizations.
• Provide ad-hoc data analysis reports for executives and upper management.
• Track and manage database related bugs using JIRA.
• Collect data from a variety of sources and transform into insights to improve business decisions.
• Provides guidance and mentoring to less experienced staff members.

Knowledge & Skills

• Using data engineering tools, languages, frameworks to mine, cleanse and explore data.
• Fluent in NoSQL & relational based systems and ability. Expert level of transactional SQL language is a must.
• Fluent in complex, distributed and massively parallel systems.
• Strong analytical and problem-solving skills with ability to represent complex algorithms in software.
• Strong understanding of database technologies and management systems.
• Strong understanding of cloud-based systems/services.
• Database architecture testing methodology, including execution of test plans, debugging, and testing scripts and tools.
• Excellent written and verbal communication skills; mastery in English and local language.
• Ability to effectively communicate product architectures, design proposals and negotiate options at management levels.
• Other desired programming languages will be Java, C++, or Python.
• Scala language with Spark SQL is a nice to have.
• Understanding of analytics pipeline with AWS services (EC2, RDS, S3, EMR, Redshift, etc.)

Scope & Impact

• Collaborates with peers, junior engineers, data scientists and project team.
• Typically interacts with high-level Individual Contributors, Managers and Program Teams.
• Leads a project requiring data engineering solutions development.

Education & Experience

• Bachelor's or Master's degree in Computer Science, Information Systems, Engineering or equivalent.
• Proven working experience as a Database Administrator
• Hands-on experience with database standards and end user applications
• Experience with AWS cloud services and Linux environments
• Excellent knowledge of data backup, recovery, security, integrity and SQL
• Familiarity with database design, documentation, and coding
• Problem solving skills and ability to think algorithmically
• Understanding of relational and dimensional data modeling
• Strong mathematical and statistical knowledge
• Typically 5-10 years' experience.

Job -
Software
Schedule -
Full time
Shift -
No shift premium (United States of America)
Travel -
Relocation -
EEO Tagline -
HP Inc. is EEO F/M/Protected Veteran/ Individual with Disabilities.