Database Engineer II - Jersey City, United States - Penn Foster Inc

    Default job background
    Description
    Company Description
    We help the world see new possibilities and inspire change for better tomorrows.

    Our analytic solutions bridge content, data, and analytics to help business, people, and society become stronger, more resilient, and sustainable.

    Job Description
    Support operational environments' database systems across SQL Server, PostgreSQL, AWS RDS, and AWS Aurora
    Demonstrates an understanding of complex problem-solving techniques dealing with physical Database creation and support.

    Ability to formulate and recommend technical direction for Database related activities for the project teams in collaboration with other teams in IT organization.

    Ability to develop standards, processes, and procedures within the scope of Technology & Infrastructure DB Services team.
    Demonstrates a strong understanding of the database development life cycle including data modeling, database coding, testing, and implementation.

    Demonstrates a working understanding of quality assurance and/or software development processes and methodologies, with the ability to share that knowledge with peers, and project team members.

    Ability to effectively communicate written and verbal to all levels within the organizations as well as communicate directly with customers on new projects and / or issues with production systems.

    Plan and execute database migrations as needed
    Monitor and improve performance; diagnose and resolve database-related problems
    Design and manage backup and recovery processes and continuity of operations plan

    Qualifications
    3+ years of experience in configuring, managing, and troubleshooting Aurora PostgreSQL (Postgres) and AWS RDS.
    3+ years of experience in MS SQL (2012/2016) database management, modeling, T-SQL programming, architecting systems with data analytics needs
    3+ years of experience with ETL tools such as Attunity, AWS Glue, DMS, or ETL programming
    2+ years of experience partitioning tables in Postgres using PGPartman.
    3+ years of Production experience with performance tuning queries and stored procedures

    3+ years of hands-on experience working with various AWS services such as S3, CFTs, API Gateway, Lambda functions, IAM, Amazon ECS etc.

    3+ years of experience with database backup and recovery, including implementing disaster recovery standards

    2+ years of experience with application performance monitoring tools including, New Relic, Splunk (log monitoring), Dynatrace, Solarwinds, Cloud Watch, Cloud Trail.

    3+ years of experience designing and implementing data security solutions such as Data Encryption (Voremetric preferred), Data Masking, Key Management.

    2+ years' experience in AGILE SDLC (Scrum etc) environment which includes participating in standups, refinements, sprint reviews, retrospectives etc.
    #LI-MB1

    Additional Information

    In 2022, Verisk received Great Place to Work Certification for our outstanding workplace culture for the sixth year in a row and second-time certification in the UK, Spain, and India.

    We're also one of the 38 companies on the UK's Best Workplaces list and one of 18 companies on Spain's Best Workplaces list.

    For over fifty years and through innovation, interpretation, and professional insight, Verisk has replaced uncertainty with precision to unlock opportunities that deliver significant and demonstrable impact.

    From our historic roots in risk assessment, we've grown to provide analytic insights that help transform industries focused on some of the world's most critical areas.

    Today, the insurance industry relies on Verisk to be, and to make the world, more productive, resilient, and sustainable.
    Verisk works in collaboration with our customers and at the intersection of people, data, and advanced technologies.

    Through proprietary platformed analytics, advanced modeling, and interpretation, we deliver immediate and sustained value to our customers and through them, to the individuals and societies they serve, with greater speed, precision, and scale.

    We're 9,000 people strong, committed to translating big data into big ideas. We help others see new possibilities and empower certainty into big decisions that impact individuals and societies. And we relentlessly and ethically pursue innovation to help move our customers, and the world, toward better tomorrows.


    Everyone at Verisk—from our chief executive officer to our newest employee—is guided by The Verisk Way, to Be Remarkable, Add Value, and Innovate.

    Be Remarkable by doing something better each day in service to our customers and each other
    Add Value by delivering immediate and sustained results that drive positive outcomes
    Innovate by redefining what's possible, embracing challenges, and pushing boundaries
    Verisk Businesses
    Underwriting Solutions — provides underwriting and rating solutions for auto and property, general liability, and excess and surplus to assess and price risk with speed and precision
    Claims Solutions — supports end-to-end claims handling with analytic and automation tools that streamline workflow, improve claims management, and support better customer experiences
    Property Estimating Solutions — offers property estimation software and tools for professionals in estimating all phases of building and repair to make day-to-day workflows the most efficient

    Extreme Event Solutions — provides risk modeling solutions to help individuals, businesses, and society become more resilient to extreme events.

    Specialty Business Solutions — provides an integrated suite of software for full end-to-end management of insurance and reinsurance business, helping companies manage their businesses through efficiency, flexibility, and data governance
    Marketing Solutions — delivers data and insights to improve the reach, timing, relevance, and compliance of every consumer engagement

    Life Insurance Solutions – offers end-to-end, data insight-driven core capabilities for carriers, distribution, and direct customers across the entire policy lifecycle of life and annuities for both individual and group.

    Verisk Maplecroft — provides intelligence on sustainability, resilience, and ESG, helping people, business, and societies become stronger

    At Verisk you can build an exciting career with meaningful work; create positive and lasting impact on business; and find the support, coaching, and training you need to advance your career.

    We have received the Great Place to Work Certification for the 7th consecutive year. We've been recognized by

    Forbes


    as a World's Best Employer and a Best Employer for Women, testaments to our culture of engagement and the value we place on an inclusive and diverse workforce.

    Verisk's Statement on Racial Equity and Diversity supports our commitment to these values and affecting positive and lasting change in the communities where we live and work.

    Verisk Analytics is an equal opportunity employer.
    All members of the Verisk Analytics family of companies are equal opportunity employers.

    We consider all qualified applicants for employment without regard to race, religion, color, national origin, citizenship, sex, gender identity and/or expression, sexual orientation, veteran's status, age or disability.


    Unsolicited resumes sent to Verisk, including unsolicited resumes sent to a Verisk business mailing address, fax machine or email address, or directly to Verisk employees, will be considered Verisk property.

    Verisk will NOT pay a fee for any placement resulting from the receipt of an unsolicited resume.
    HR CCPA Privacy

    #J-18808-Ljbffr