DXC Technology Data Engineer III in Roseville, California

Job Description:

Conceptualizes designs, develops, integrates, deploys and maintains the data layer and data components by applying specialized knowledge of information, data and database management disciplines to provide world-class solutions for our clients. Ensures organizational and team member success by applying knowledge of high performance team techniques, coaching techniques, mentoring models and collaboration strategies to work collaboratively as a member of a high performance team and to provide coaching/ mentoring to other team members as appropriate. Collaborate across business units to enhance knowledge of data engineering capability and information management and to increase intellectual capital by applying knowledge of data engineering management strategies and tools, communities of learning, delivery organizations and knowledge management tools, to contribute to the continuous enhancement and communication of the information management body of knowledge. Develops the data components of application solutions by applying knowledge of service offerings, capabilities, innovation, sales pursuit strategy, and data engineering solutions best practices to collaborate with the solution development team and the client to develop winning solutions that ensure win rates, margins and revenues are improved.

Responsibilities:

Participates in or leads a Data Engineering Team supporting one or more application projects. Works collaboratively with the Application team, including architects, developers and testers, to ensure project success. Engage and collaborate with the infrastructure DBA teams to ensure delivery of DB infrastructure components. Ensure integration of DE deliverable s with other project deliverable s. Collaborates with the Application Project manager to plan and manage the DE activities and deliverable s. Coaches less experienced DE team members. Participates in discussion with customers and peers to collect and analyse data requirements.

Works collaboratively with the Application team, including architects, developers and testers, to ensure project success. Collaborates with the Application Project manager to plan and manage the project activities and deliverables.

Coaches less experienced team members. Participates in discussion with customers and peers to collect and analyze data requirements. Participates in solution development for projects. Participates in client meetings and presentations.

Assists Data Architect or Team Leader to develop solutions by documenting components of the solution, defining deliverable s and preparing estimates. Plans and Leads database development and maintenance of databases including:

  • Design database environments and databases.

  • Design, develop, modify, test, release/ deploy and maintain database objects.

  • Design database objects and supervise develop, modify, test, release/ deploy and maintain by other DBAs.

  • Design, develop, modify, test, release/ deploy and maintain database security and audit solutions design, develop, modify, test, release/ deploy and maintain database recovery solutions.

  • Execute database and data recovery.

  • Manage database performance, capacity and availability.

  • DBMS SW implementation, upgrade, patching.

  • Utilizing best practices, work plans, checklists and defined processes.

  • Proactively supports application teams. Performs SQL tuning.

  • Provides advice on application data issues.

  • Participates in project technical reviews. Leads work product reviews.

  • Develops and maintains database support documentation.

  • Designs database monitoring solutions and assists others in monitoring and proactively anticipating or identifying issues.

  • Takes ownership of complex database incidents and problems and provides resolutions in a timely manner.

  • Engages SMEs or vendors to provide assistance to resolve more complex incidents as required.

  • Produce and maintain logical and physical data models for databases and projects.

  • Participates in the development and maintenance of enterprise data models for less complex enterprises.

  • Participates in formal Data Modeling Reviews. May lead reviews of simple data models.

  • Assist business and technical personnel in data analysis activities including using SQL queries.

  • Performs Model Conversion (data mapping) to produce a data dictionary and data mapping matrix between the external software and the internal database for business function replacement.

  • Performs in data quality analysis / data profiling, to produce a data quality assessment (and baseline).Utilizing best practices, work plans, checklists and defined processes. Proactively supports application teams. Performs SQL tuning. Provides advice on application data issues.

  • Performs Model Conversion (data mapping) to produce a data dictionary and data mapping matrix between the external software and the internal database for business function replacement.

  • Performs in data quality analysis / data profiling, to produce a data quality assessment (and baseline).

Requirements

  • 5+ yeas of recent experience with PL/SQL development with Oracle 10g or 11g. Must be able to manage schemas, create DDLs, optimize and develop complex queries and execute deployments to various environments.

  • 3 + years of experience with T-SQL development in MS SQL Server environment

  • 3+ years of progressive experience in data architecture, logical and physical relational database modeling and design, metadata management, operational database

  • Experience with Oracle Database Administration to assist with routine DBA activities including RMAN, monitoring and maintenance.

  • Experience with all components of relational database design in a high-availability, transactional (OLTP) environment

  • Experience with working in UNIX environment and developing shell scripts

  • Work as part of a team to provide 24x7 support

  • Interface with Oracle technical support

  • Establish standards and best practices for SQL

  • Exceptional interpersonal skills, including teamwork, facilitation, and negotiation

  • Excellent analytical and technical skills

  • Excellent written and verbal communications skills

  • Excellent planning and organizational skills

  • Excellent data modeling and meta data management skills

  • ERWin experience and/or other data modeling tool experience

DXC Technology is EEO F/M/Protected Veteran/ Individual with Disabilities