Database Administrator, Senior

NJM Insurance Group • Trenton, NJ

4d

About The Position

The SQL Database Administrator, Senior (DBA) will be responsible for maintaining and ensuring the ongoing availability of SQL Server systems, both on-premises and in the cloud (AWS SQL Server and Azure SQL). The DBA will take ownership of the complete understanding and optimization of multiple database products, ensuring their performance, security, and reliability.

Requirements

• Bachelor’s degree in Computer Science, Math or IT related field.
• Minimum of 10 years of experience with Microsoft SQL Server.
• At least 3 years of experience with native Azure SQL Database.
• Minimum 5 years of experience with Powershell or Python scripting.
• Experience in technical database administration, development, tuning, and database design.
• Working experience or knowledge SSRS and PowerBI Reports development.
• Strong communication and interpersonal skills.
• Proven self-reliant, self-starter with the ability to educate others.
• Strong analytical and problem-solving skills.
• Project and task-oriented with a focus on details.
• Strong collaboration and teamwork skills.

Nice To Haves

• MongoDB Atlas database management experience a plus.
• DB Certification in Microsoft SQL Server or Azure SQL database preferred.

Responsibilities

• Maintain and ensure the availability of SQL Server systems, including on-premises, AWS, and Azure environments.
• Monitor system performance and implement necessary security updates and patches.
• Optimize and manage multiple database products to ensure high performance and efficiency.
• Quickly learn new product platforms and database technologies.
• Stay updated with the latest industry trends in database management.
• Improve standard practices and procedures within the team to enhance efficiency and effectiveness.
• Develop and implement best practices for database management.
• Troubleshoot and solve database-related issues effectively.
• Provide timely and efficient resolution to database problems.
• Continuously work to acquire deep skills in relevant DBA areas.
• Participate in training and development programs to enhance technical expertise.
• Understand the infrastructure environment and independently support an application’s database platform.
• Ensure the database platform meets the application’s requirements.
• Maintain solid proficiency in backup and recovery options.
• Develop and implement backup and recovery strategies.
• Perform database design tasks, including schema design, indexing, and normalization.
• Ensure database designs meet performance and scalability requirements.
• Maintain team’s documentation and make updates and improvements as needed.
• Ensure documentation is accurate and up to date.
• Capacity planning of databases and regular performance assessments and implement tuning measures.
• Write and optimize T-SQL scripts for automating administrative tasks.
• Ensure scripts are efficient and maintainable.

Benefits

• Eligible full-time employees receive a competitive Total Rewards package, including but not limited to a 401(k) with employer match up to 8% and additional service-based contributions, Health, Dental, and Vision insurance, Life and Disability coverage, generous PTO, Paid Sick Leave, and paid parental leave in addition to state-mandated leave.
• Employees may also be eligible for discretionary bonuses.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level