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