What are the responsibilities and job description for the SQL DBA position at NJM Insurance Group?
The Database Administrator (official NJM job title) is responsible for the implementation, configuration, maintenance, compliance, security, monitoring and performance of all critical database systems serving NJM applications.
Job Responsibilities:
Install and Configure highly efficient and highly available database systems
- Work independently to implement HA options, such as Always-On, Failover Clustering, Database Mirroring, Log Shipping and Replication
- Install database systems, such as SQL Server and MongoDB aetc., compliant to NJM standards
- Configure database systems in compliance with NJM best practices
General Database Administration
- Capacity planning
- Security administration and compliance enforcement
- Database backup and recovery
- Database health baselining
- Database system maintenance, monitoring and optimization
- Performance tuning
- Scripting for database task automation
- Database upgrades and migrations
- Setup and monitor alerts
Production Support
- Efficiently perform troubleshooting and provide timely resolutions
Project Support
- Work with developers/users to gather and evaluate database requirements
- Database physical and logic design
- Review, understand and execute provided scripts
- Deployments
Required Qualifications & Experience:
- At least 4 years production database administration experience
- Bachelor’s degree in Computer Science or equivalent work experience required
Solid knowledge of database theory fundamentals and DBMS internal architecture for both RDBMS and non-SQL
- Ability to understand database requirements and identify resolutions
- Provide sound solutions to database tasks
- Ability to identify areas of improvement
- Design, Install and Configure highly efficient and highly available database systems
Strong On-Prem and cloud general database administration skills
- Proficient in data integrity and recoverability, high availability, security, replication, maintenance, optimization, and monitoring
- Ability to perform capacity planning, setup maintenance plans, configure alerts
- Proficient in security administration
- Provide solid database backup and restore service
- Ability to perform database upgrades and migrations
Proficient with common third-party Database tools
- Ability to independently use tools such as Delphix, Spotlight, Compliance Manager/SQLSecure, Data Compare, SolarWinds, DB Artisan and Litespeed
- Ability to identify and interpret data from the tools for specific situations
Good troubleshooting and creative problem-solving skills for database design, creation, maintenance and optimization
- Ability to identify root cause or rule out database issue
- Ability to provide suggestions or resolutions
- Highly efficient on production support
Proficient in scripting languages for database administration and routine automation
- Proficient in scripting languages include T-SQL, Batch commands, Python and PowerShell
- Ability to develop database automation procedures
Adaptive and Proficient in Multi-tasking
- Able to handle multiple projects and tasks.
- Able to solve scheduling conflicts with proper priority and time management
- Ability to learn quickly, work in a fast paced environment and adapt to change
- Ability to adapt to technology changes and show commitment to learn
Legal Disclaimer: NJM is proud to be an equal opportunity employer. We are committed to attracting, retaining and promoting a diverse and inclusive workforce that is fully representative of the diversity that exists in the communities in which we do business.