Lead Aurora PostgresSQL Database Engineer
Company: ADP Automatic Data Processing
Location: Parsippany
Posted on: January 15, 2021
|
|
Job Description:
Job SummaryAutomatic Data Processing, Inc. (ADP) is one of the
largest providers of business processing and cloud-based solutions
including payroll, talent management, human resource management,
benefits administration and time and attendance to employers and
automotive dealerships around the world. ADP builds configurable
solutions that can fit your organization's unique goals and
increase your productivity. For more information about ADP, visit
the company's Web site at . The ADP DataCloud product development
team is looking for a Lead Database Engineer that is highly skilled
in multiple technical areas including database engineering and
operations, performance, stability and scalability, Amazon database
technologies. The successful candidate will have a strong command
of designing and implementing PostgreSQL and Oracle
databases.Responsibilities Design and implement highly scalable,
interactive databases with performance, stability and scalability
Define and establish standards and best practices to implement and
support Aurora PostgreSQL database clusters, and high-performance
computing environments, particularly on the AWS Cloud Champion all
database environment builds, including design, capacity planning,
cluster setup, upgrades, performance tuning and ongoing monitoring
Diagnose, troubleshoot, and resolve data and performance issues, to
ensure that database systems meet business and performance
requirements, which may include after-hours/weekends Develop and
deploy alerting, monitoring, and reporting tools and dashboards
integrated with other cloud-based monitoring tools, to help support
business requirements Define and implement database backup and
recovery strategies Work with developers and engineers on all
database related changes via code reviews, tuning, testing, and
validation Performance tuning of databases to support high
read/write throughput while minimizing latency Assist with data
analysis by writing ad hoc queries Analyze database access patterns
to isolate hotspots, data model problems, and other bottlenecks
Perform proactive capacity planning and forecasting based on
database usage patterns and new business initiatives Implement an
effective cost management strategy for AWS databases Design and
support data migrations Report progress and status of assigned
tasks to project teams and manager Provide technical leadership and
motivation to junior developersQualifications Bachelor's degree in
Computer Science, Engineering or related discipline 7 years of
Postgres or Oracle database development experience 2 years of
hands-on experience with Aurora PostgresSQL Expert understanding of
complex inner workings of Aurora PostgresSQL Strong understanding
of the Aurora Postgres data model and architecture including
installation, configuration of a cluster, replication, security,
and best practices Familiarity with other SQL/NoSQL databases such
as MongoDB, Redshift, Redis, etc. Knowledge of data population
techniques, e.g. Extract Transform Load (ETL) and Extract Load
Transform (ELT) and familiarity with Change Data Capture (CDC)
tools like Golden Gate, DMS etc. Exposure to Enterprise Data
Warehouse systems with understanding of Star Schemas, Snowflake
Schemas, etc. Knowledge of operating relationships between
database, business applications, and the operating systems
Familiarity within Linux Environments, able to write/maintain
scripts Familiarity with Infrastructure as Code software, such as
Terraform, and CI/CD process Prior experience working with
Agile/Scrum methodologies Ability to manage day-to-day tasks
independently Ability to perform multiple tasks concurrently
Excellent analytical and problem-solving skills Strong knowledge of
system security and overall IT security methodologies Experience
and knowledge of change management principles, methodologies and
tools Exceptional communication skills, both written and verbal
Relevant AWS certifications desiredGeneric Skills Leadership: not
only at the management level but at the individual level having the
confidence and resilience to take risks be self-empowered
Communication: understand and express ideas/solutions in a
comprehensive and practical format knowledge sharing User Focus: an
absolute focus on the user (internal or external) experience every
aspect of a solution should be productized for ease of use
Improvisation: the ability to think across disciplines and existing
boundaries (technologies/business/geographies) - lateral thinking
Collaboration: teamwork with a positive approach to ambiguity
Research: an inclination to continuous research inside and outside
the current focus fields Influence by example: scientific proof of
an idea (success or failure) as the presentation tool represent an
idea in order to promote it Technical Knowledge: broad and deep
technical knowledge with a strong focus on data/objects and
API/contracts Abstract Thinking: view of ideas and solutions as
abstractions/patterns that can be leveraged/adapted/reused deliver
frameworks instead of point solutionsADP is an Equal
Opportunity/Affirmative Action Employer; M/F/D/V. ADP believes that
diversity leads to strength.LITECHWe're designing a better way to
work, so you can achieve what you're working for. Consistently
named one of the 'Most Admired Companies' by FORTUNE-- Magazine,
and recognized by DiversityInc-- as one of the 'Top 50 Companies
for Diversity,' ADP works with more than 740,000 organizations
across the globe to help their people work smarter, embrace new
challenges, and unleash their talent. "Always Designing for People"
means we're creating platforms that will transform how great work
gets done, so together we can unlock a world of opportunity.At ADP,
we believe that diversity fuels innovation. ADP is committed to
equal employment opportunities regardless of race, color, genetic
information, creed, religion, sex, sexual orientation, gender
identity, lawful alien status, national origin, age, marital
status, or protected veteran status. We support an inclusive
workplace where associates excel based on personal merit,
qualifications, experience, ability, and job performance.Brand:
ADPJob ID: 196475Employment Type: Full-TimeJob Area: Technology
Keywords: ADP Automatic Data Processing, New York , Lead Aurora PostgresSQL Database Engineer, Engineering , Parsippany, New York
Click
here to apply!
|
Didn't find what you're looking for? Search again!
Other Engineering JobsMac Tools Seeking Mechanics - Technicians - Training Provided Description: Build a Great Career and a Quality Life with Mac Tools. br br Feel the freedom and independence of working on your own, in a stress free environment - with no one to answer to, except yourself Join (more...) Company: Mac Tools Location: Rockville Centre Posted on: 01/24/2021 Data Engineer Description: If you are a Lead Data Engineer with ETL and Python experience, please read on Our mission is to help people find the best properties to live and invest in. We've created a dynamic platform that helps (more...) Company: Optello Location: New York Posted on: 01/24/2021 TechOp Engineer - Ticker Plant (Consultant) Description: Job Requisition Number:88024You will be part of a highly creative, dynamic, and innovative team environment. The job requires you to work closely with various groups including system administration, application (more...) Company: Bloomberg Location: New York Posted on: 01/24/2021 AWS Cloud Engineer Description: This trading platform is looking for an AWS Engineer to join their growing team.-- You will work with the Infrastructure team as the AWS Engineer - currently Company: Motion Recruitment Location: New York Posted on: 01/24/2021 Senior Swift Engineer Description: Tech/Gaming App Start-up Company is looking for a Swift / iOS Engineer to take over the mobile application process for our game and interaction social app. Working with product and engineering, you'll (more...) Company: Onward Search Location: New York Posted on: 01/24/2021 Data Engineer Description: A major financial firm is seeking a Data Engineer to join their team in New York, NY.Within this role, you will work closely with various scrum teams on their specific Company: Open Systems Technologies Location: New York Posted on: 01/24/2021 Manager, Sales Engineering ? Spectrum Enterprise Description: At a glance: Are you an expert in service provider solutions and skilled at managing a team responsible for technical pre-sale activities Can you commit to a sales engineering leadership position (more...) Company: SPECTRUM Location: Moonachie Posted on: 01/24/2021 AI Group - IR Research Engineer Description: Job Requisition Number:87012Financial information drives the markets and Bloomberg has a wide variety and diverse set of information sources available on its flagship product - The Bloomberg Terminal. (more...) Company: Bloomberg Location: New York Posted on: 01/24/2021 Mac Tools Seeking Mechanics - Technicians - Training Provided Description: Build a Great Career and a Quality Life with Mac Tools. br br Feel the freedom and independence of working on your own, in a stress free environment - with no one to answer to, except yourself Join (more...) Company: Mac Tools Location: Roslyn Posted on: 01/24/2021 Site Reliability Engineer Needed! Description: If you are a Site Reliability Engineer please read on Top Reasons to Work with Us 1. 401k, Medical, Dental, FSA2. 22 days PTO 3. Tech resources, including: company-provided Mac or PC laptop and/or mobile (more...) Company: CyberCoders Location: New York Posted on: 01/24/2021 |