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