DB Admin

JOB FAMILY DESCRIPTION

Provides support to and maintains multiple production and/or non-production databases of significant and/or strategic impact across the enterprise. Responsible for standards and design of physical data storage, maintenance, access and security administration.

GENERAL DUTIES & RESPONSIBILITIES

• Performs backup and recovery on Database Management Systems, configures database parameters and prototype designs against logical data models, and defines data repository requirements, data dictionaries and warehousing requirements.
• Optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and cost.
• Ensures service level agreements are met for internal and external clients.
• Provides status reports that detail issues for escalation to management.
• Performs configuration, scripting, analysis, installation, monitoring, administration and tuning for database management systems.
• Required to participate in a 24x7 on-call rotation.
• Weekend work – Related to on-call and Company/Application Initiative’s and/or deployments.
• Performs data analysis to provide management with timely and accurate information and predict future requirements.
• Develops, implements and tests database backup and recovery policies and procedures.
• Creates and maintains documentation for database policies, procedures, and processes.
• Performs/schedules routine maintenance on databases to keep them running at peak performance.
• Monitors database performance, availability, and capacity.
• Participates in continuous business process redesign to improve internal operations.
• Interfaces with user departments remotely and on-site to assist in the implementation of work requests and provide operational support.
• Troubleshoots issues and recommends solutions.
• Performs other duties as required.

EDUCATIONAL GUIDELINES

Bachelor’s Degree in Computer Science, Information Systems or the equivalent combination of education, training, or work experience.

GENERAL KNOWLEDGE, SKILLS & ABILITIES

• Knowledge of database management systems.
• Ability to work independently and in a team environment with minimal supervision.
• Must be self-motivated, a team player, and have a strong track record in customer satisfaction.
• Thorough database design and analysis skills.
• Strong written and verbal communication skills.
• Ability to learn and apply new skills in a constantly changing technical environment.
• Strong problem-solving skills.
• Knowledge of DB encryption.
• Knowledge of SQL and SQL performance and tuning.
• Knowledge of Cloud Databases.
• Experience with scripting languages such as PowerShell is preferred.
• Interested in learning new skills/platforms, i.e., Job Schedulers, Open-Source Databases, etc.
• Ability to monitor and tune databases and instances.
• Ability to maintain and monitor availability, security, and integrity of databases.
• Knowledge of backup and recovery operations for database management systems.
• Demonstrated experience with successful system and project implementations.
• Ability to adapt to the use of new software tools as they are acquired or adopted within IT.
• Focused on production and customer needs.

Job Type: Full-time

Pay: $65,000.00 - $80,000.00 per year

Benefits:

• 401(k)
• Dental insurance
• Flexible schedule
• Health insurance
• Paid time off
• Vision insurance

Schedule:

• 8 hour shift

Ability to commute/relocate:

• Somerset, NJ 08873: Reliably commute or planning to relocate before starting work (Required)

Experience:

• MySQL: 1 year (Preferred)
• Database administration: 1 year (Preferred)

Work Location: One location