MPP Database Engineer
Company: Accenture Federal Services
Location: Reston
Posted on: May 12, 2022
|
|
Job Description:
Job Description Accenture Federal Services delivers a range of
innovative, tech-enabled services for the U.S. Federal Government
to address the complex, sensitive challenges of national security
and intelligence missions. Refer a qualified candidate and earn up
to $10K. Learn more here > Job Description: We are searching for
a talented Massive Parallel Processing (MPP) Database Engineer to
join our CloudTracker
(https://www.novetta.com/products/cloudtracker/) product team. The
successful candidate will have significant experience in working
with data warehouses. Our team is using Amazon RedShift, but we are
open to interviewing candidates who have not yet worked with
RedShift specifically. As a member of the team, you will be
responsible for all aspects of database design, implementation,
query construction/execution, and monitoring/optimization. If
you're looking for a highly visible role in a great company,
working with other super smart people, and want to help build a
modern, cloud-native web application on AWS and Azure, then we want
to speak with you We use Agile Scrum, and release working software
at the end of each two week sprint using CI/CD with Jenkins. We
follow sound engineering best practices to design / mock, spec,
build, test, and publish capabilities our users want and need. If
this sounds interesting to you, please read the minimum
requirements and apply Responsibilities include: Works with the
business analyst and other team members to understand project
objectives; analyzes and proposes related work objectives/tasks
Assists with the design, implementation, and integration of
software applications with database engines, data structures and
functions. Decomposes work into executable tasks that are
achievable within a two week sprint Designs, develops, and
optimizes database designs (cluster size, infrastructure resources,
table structures/layout, etc) for optimal performance of
processing-intensive analytics over very large data sets. Performs
algorithm development (query construction, analysis) over massive
shared/replicated datasets. Identifies and troubleshoots issues
(stuck queries, connection pooling, query performance, cluster
performance, etc) Applies industry standards and engineering best
practices that are appropriate for building/delivering
production-grade software. Ensures efficient delivery of
engineering capabilities using repeatable processes. Identifies and
mitigates risks that are associated with overall system
performance, and delivery of production-grade systems Conducts
thorough testing using representative datasets to accurately
profile query performance for evaluation/optimization Reviews
database performance against design requirements and documents
results. Proposes and applies appropriate tools that assist with
monitoring/optimizing, and identifying/resolving database related
problems Ensures quality control over all related work products.
Basic Qualifications: 5 years of experience and deep understanding
of: MPP data warehouses and architectures. Bonus for AWS RedShift,
but could be Asterdata, Teradata, Greenplum, Oracle RAC, SQL Data
Warehouse, etc Database programming with SQL and any vendor
specific dialects -e.g. PL/pgSQL, T-SQL, PL/SQL, etc On-line
analytical processing (OLAP) and on-line transaction processing
(OLTP) query models Data interchange formats -e.g. CSV, JSON, XML
Data schemes/structures, functions and normalization -e.g. tables,
data types, views, indexes, triggers, stored procs, runtime
classes, first - fifth normal form. Affiliated tools and techniques
related to database and query design/construction/optimization
-e.g. logging/auditing; performance monitoring; query execution
analysis; issue detection, root cause analysis and resolution. 3
years of experience with the following: Analyzing business
requirements and devising work objectives/tasks Task decomposition
and estimation SCRUM/Agile -e.g. Use Cases, User Stories, Work
Tasks, Atlassian JIRA, Confluence. Git/Github source control
Desired Skills: DoD 8570 Level I and applicable Computing
Environment (CE) certifications (these will be required to be
obtained/maintained) Ability to work independently without
supervision Demonstrates good analytical thinking and problem
solving skills Ability to work well in teams, and possesses good
communication skills AWS/Azure Certifications and/or prior
experience with Amazon RedShift Security Clearance: Eligible
Eligibility Requirements US Citizenship required. Important
information Applicants for employment in the US must have work
authorization that does not now or in the future require
sponsorship of a visa for employment authorization in the United
States and with Accenture Federal Services Accenture Federal
Services is an EEO and Affirmative Action Employer of
Females/Minorities/Veterans/Individuals with Disabilities.An active
security clearance or the ability to obtain one may be required for
this role. Accenture Federal Services is committed to providing
veteran employment opportunities to our service men and women.
Candidates who are currently employed by a client of Accenture or
an affiliated Accenture business may not be eligible for
consideration. COVID-19 update: The safety and well-being of our
candidates, our people and their families continues to be a top
priority. Until travel restrictions change, interviews will
continue to be conducted virtually. Subject to applicable law,
please be aware that Accenture requires all employees to be fully
vaccinated as a condition of employment. Accenture will consider
requests for accommodation to this vaccination requirement during
the recruiting process. What We Believe We have an unwavering
commitment to diversity with the aim that every one of our people
has a full sense of belonging within our organization. As a
business imperative, every person at Accenture has the
responsibility to create and sustain an inclusive environment.
Inclusion and diversity are fundamental to our culture and core
values. Our rich diversity makes us more innovative and more
creative, which helps us better serve our clients and our
communities. Read more here Equal Employment Opportunity Statement
Accenture is an Equal Opportunity Employer. We believe that no one
should be discriminated against because of their differences, such
as age, disability, ethnicity, gender, gender identity and
expression, religion or sexual orientation. All employment
decisions shall be made without regard to age, race, creed, color,
religion, sex, national origin, ancestry, disability status,
veteran status, sexual orientation, gender identity or expression,
genetic information, marital status, citizenship status or any
other basis as protected by federal, state, or local law. Accenture
is committed to providing veteran employment opportunities to our
service men and women. For details, view a copy of the Accenture
Equal Opportunity and Affirmative Action Policy Statement.
Requesting An Accommodation Accenture is committed to providing
equal employment opportunities for persons with disabilities or
religious observances, including reasonable accommodation when
needed. If you are hired by Accenture and require accommodation to
perform the essential functions of your role, you will be asked to
participate in our reasonable accommodation process. Accommodations
made to facilitate the recruiting process are not a guarantee of
future or continued accommodations once hired. If you would like to
be considered for employment opportunities with Accenture and have
accommodation needs for a disability or religious observance,
please call us toll free at 1 (877) 889-9009, send us an email or
speak with your recruiter. Other Employment Statements The Company
will not discharge or in any other manner discriminate against
employees or applicants because they have inquired about,
discussed, or disclosed their own pay or the pay of another
employee or applicant. Additionally, employees who have access to
the compensation information of other employees or applicants as a
part of their essential job functions cannot disclose the pay of
other employees or applicants to individuals who do not otherwise
have access to compensation information, unless the disclosure is
(a) in response to a formal complaint or charge, (b) in furtherance
of an investigation, proceeding, hearing, or action, including an
investigation conducted by the employer, or (c) consistent with the
Company's legal duty to furnish information.
Keywords: Accenture Federal Services, Reston , MPP Database Engineer, Engineering , Reston, Virginia
Click
here to apply!
|