Job Description :
SQL Server Database Administrator (DBA)


Summary:
ESM Solutions is looking to add a team member to its technical staff with a background in Information Systems/Technology with 5 to 8 years of related experience. The Database Administrator will provide a variety of database expertise in a dynamic software-as-a-service environment. The successful candidate will have experience with Microsoft SQL Server 2017 and related technologies.

Responsibilities include but are not limited to:

Responsible for Microsoft SQL Server in multiple environments, including: production, training, demo, test and

development.

Responsible for database backups and disaster recovery

Responsible for database index management

Responsible for monitoring, problem resolution, performance tuning and capacity planning

Support developers in recommending and applying best practices for database schema design

Support developers in performance tuning stored procedures

Support of third party reporting tools such as Crystal and Exago

Assist in the creation and on-going maintenance of an ETL process and data warehouse build

Manage DB replication and log shipping process

Prioritize and manage support inquires

Track and document support tickets from open to close/resolution

Assist in developing best practices to ensure exceptional database services delivery

Provide project level reporting

Other duties as assigned

Required Technical Skills:

Microsoft SQL Server 2008 R2 and 2017

SQL Administration in both physical and virtual environments

Log Shipping setup, configuration, and management

SQL Server Reporting Services

SQL Server Integration Services

T-SQL query, triggers and stored procedure writing

Replication and Mirroring

Database modeling and design including ERDs for both OLTP and OLAP

Monitoring and benchmarking

SQL upgrade experience (+)

SQL Server Analysis Services (+)

SQL Server Clustering (+)

SQL Server Certifications (+)

Knowledge of PCI data privacy practices and legal compliance requirements (+)

DBaas experience (AWS, Azure, etc…)

Non-relational DB application experience

Data Warehousing implementation, maintenance and support



Skills and Requirements for Success:

Bachelor’s degree, or equivalent experience preferred focused on Information Systems and Technology

Analytical, technical and problem solving skills to identify and facilitate problem resolution in a timely manner

Strong written and verbal communication skills

Must be a self-starter with the ability to prioritize deliverables and meet deadlines

Must be highly organized and detail-oriented

Must demonstrate flexibility and be able to adapt to changes

Desire to take ownership and responsibility for environment and associated tasks

Ability to multi-task

Great personality

Good sense of humor


Compensation and Benefits:

Commensurate with Experience

Strong Benefits package including medical, dental, life and 401(k) matching