Database Administrator

The Database Administrator (DBA) 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, MongoDB, UDB and etc., 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

Database task automation

• Setup SQL Agent Jobs and Tivoli jobs. Work with release time to automate database deployments

Required Skills & Qualifications:

• 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-Premise 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

Compensation: Salary is commensurate with experience and credentials.

Pay Range: $97,947-$123,458