Job Description

Essential functions and responsibilities:

Monitor the health of the DB servers through both automated and manual processes

Recommend and implement solutions for performance monitoring and tuning.

Analyze problems,

anticipate

future problem areas, and implement solutions.

Perform environment setup and configuration, proactive

monitoring

and maintenance.

Support the development of long- and short-term requirements for database administration and design.

Participate in your change control process for all planned

application

and technical activities.

Work with report writers to provide data needed for reports.

Take on

full roadmap items, work with other functional teams, and be able to deliver high quality results on time.

Investigate and find the root cause for software problems reported by stakeholders

Direct organization of requirements and data into a usable database schema by directing development of ad hoc queries, scripts

, updates

to existing queries.

May perform database administration and maintenance, including database installation and configuration, backups, upgrades

, patching

.

Review SQL code written by application developers to ensure compliance

to

coding standards and best practices as well as maximum performance.

Evaluate performance of stored procedures and find time/resource consuming areas and give inputs to application developers to fix them

Create deployment and rollback scripts for all database objects manually or auto generated.

Analyze access patterns and propose the best combination of indexes, constraints, foreign keys, and queries.

Proactively

identifies

technical opportunities and enhancements while addressing major incidents

in a timely manner

Manages and ensures the integrity, security, and retention of data

Administers and

maintains

end user accounts, permissions, and access rights

Participate in an on-call rotation providing 24-hour, 7-day support, and off-hours maintenance windows

Qualifications +

Education and background:

+

Bachelor's degree in computer science or related discipline is

required

; experience may substitute for the education requirement

+

3-5 years' experience with Relational Databases

e.g.

MariaDB/

Mysql

/NoSQL and above

required

+

3-5 years' experience with automation

utilizing

Shell scripting (Shell, Perl, python, etc.)

required