Database Administrator DBA II

慨正橡扯; Holmdel Township (NJ); On-site; USD 80,000 - 120,000; Full time

Job summary

A leading data analytics company seeks an experienced Database Administrator to oversee relational databases like MS SQL Server and AWS Aurora. This role involves designing, implementing, and maintaining database systems, along with troubleshooting and performance tuning. Ideal candidates have a Computer Science degree and strong SQL skills, with opportunities for recent graduates as well.

Qualifications

• 3+ years experience with relational databases.
• Familiarity with AWS Cloud platform.
• Ability to work in a Multi-Site environment.

Responsibilities

• Create and maintain multiple relational databases.
• Support application development and performance tuning.
• Assist in disaster recovery and maintain database environments.

Skills

SQL language

Performance tuning

Database design

Automation with PowerShell

Troubleshooting

Incident Management

Education

Bachelor’s degree in Computer Science

Tools

Microsoft SQL Server

AWS Aurora

PostgreSQL

Job description

Job Description
We are looking for databaseadministrator to design, implement, support, administer andmaintain relationaldatabases such as MS SQL Server, Snowflake, Postgres, etc.

As a Database Administrator, you will:

Create, administer, monitor, and maintain multiple relational databases such as MS SQL Server, AWS Aurora-Postgres, Snowflake, etc.
Work on new and existing logical/physical database designs for applications and infrastructure. Implement relational databases, tables, and table changes, etc.
Support application development for problem solving and performance tuning.
Assist in administering, monitoring and maintaining SQL Server/Snowflake/Aurora Postgres environments, including for disaster recovery.
Be willing to be on-call and occasionally work odd hours to help meet customer service level commitments.

Basic Requirements:

Experience with Microsoft SQL Server 2016, 2017, & 2019 and with AWS and Aurora-Postgres.
Experience in database design for data integrity, performance tuning and capacity optimization.
Knowledge of the SQL language and its capabilities.
Ability to analyze SQL and provide recommendations (performance tuning, tables, views, triggers, indexes, constraints, etc.) and best practices.
Experience writing and troubleshooting complex stored procedures and functions for both SQL Server and Aurora/Postgres
Experience in application (e.g., timeouts, deadlocks, etc.) and server troubleshooting.
Advanced knowledge of SQL Server components and tools (Extended Events, etc.)
Ability to automate routine processes with PowerShell and other scripting languages.
Experience with installation, configuration, support, and tuning of different complex Microsoft SQL Server installations and setups (Availability Groups, Multi-site Availability Groups, Failover Clusters Instances, etc.)
Strong understanding of monitoring: interpretation, actions to take, implementations and administration.
Experience in Incident Management and good understanding of SOX and other regulatory compliance
Good communication skills, ability to collaborate in a team.
Ability to take initiative instead of waiting for work to be assigned.
Active participation in discussions and ability to have and state opinions.
Ability and eagerness to learn and to pick-up other Relational and NoSQL Database Technologies
Qualifications

Bachelor’s degree in Computer Science or similar field.
3+ years of experience with creating, administering, monitoring, and maintaining of multiple relational data bases such as Microsoft SQL Server, PostgreSQL, AWS Aurora, etc.
Familiarity with working on the AWS Cloud platform with RDS SQL Server and Aurora-Postgres and with EC2 instances and related features.
Experience in Managing a Multi-Site (Active-Active) Environment
Recent graduates arealsowelcome to apply.
Responsibilities
Experience with Microsoft SQL Server 2016, 2017, & 2019 and with AWS and Aurora-Postgres.
Experience in database design for data integrity, performance tuning and capacity optimization.
Knowledge of the SQL language and its capabilities.
Ability to analyze SQL and provide recommendations (performance tuning, tables, views, triggers, indexes, constraints, etc.) and best practices.
Experience writing and troubleshooting complex stored procedures and functions for both SQL Server and Aurora/Postgres
Experience in application (e.g., timeouts, deadlocks, etc.) and server troubleshooting.
Advanced knowledge of SQL Server components and tools (Extended Events, etc.)
Ability to automate routine processes with PowerShell and other scripting languages.
Experience with installation, configuration, support, and tuning of different complex Microsoft SQL Server installations and setups (Availability Groups, Multi-site Availability Groups, Failover Clusters Instances, etc.)
Strong understanding of monitoring: interpretation, actions to take, implementations and administration.
Experience in Incident Management and good understanding of SOX and other regulatory compliance
Good communication skills, ability to collaborate in a team.
Ability to take initiative instead of waiting for work to be assigned.
Active participation in discussions and ability to have and state opinions.
Ability and eagerness to learn and to pick-up other Relational and NoSQL Database Technologies
Qualifications
Bachelor’s degree in Computer Science or similar field.
3+ years of experience with creating, administering, monitoring, and maintaining of multiple relational data bases such as Microsoft SQL Server, PostgreSQL, AWS Aurora, etc.
Familiarity with working on the AWS Cloud platform with RDS SQL Server and Aurora-Postgres and with EC2 instances and related features.
Experience in Managing a Multi-Site (Active-Active) Environment
Recent graduates arealsowelcome to apply.

About Us
For over 50 years, Verisk has been the leading data analytics and technology partner to the global insurance industry by delivering value to our clients through expertise and scale. We empower communities and businesses to make better decisions on risk, faster.

At Verisk, you'll have the chance to use your voice and build a rewarding career that's as unique as you are, with work flexibility and the support, coaching, and training you need to succeed.

For the eighth consecutive year, Verisk is proudly recognized as a Great Place to Work for outstanding workplace culture in the US, fourth consecutive year in the UK, Spain, and India, and second consecutive year in Poland. We value learning, caring and results and make inclusivity and diversity a top priority. In addition to our Great Place to Work Certification, we’ve been recognized by The Wall Street Journal as one of the Best-Managed Companies and by Forbes as a World’s Best Employer and Best Employer for Women, testaments to the value we place on workplace culture.

We’re 7,000 people strong. We relentlessly and ethically pursue innovation. And we are looking for people like you to help us translate big data into big ideas. Join us and create an exceptional experience for yourself and a better tomorrow for future generations.

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

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. Verisk’s minimum hiring age is 18 except in countries with a higher age limit subject to applicable law.

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.