SQL Server Database Administrator

Information Systems

SQL Server Database Administrator

GENERAL

The SQL Database Administrator is responsible for the planning, development, implementation and maintenance of all the database environments for Moose International and related companies. Responsible for the usage, accuracy, efficiency, security and administration of all company databases. Reports to and works closely with the Applications Development Manager.

RESPONSIBILITIES AND ESSENTAIL FUNCTIONS

· Implementation and support of Microsoft SQL Server Database Systems to support clients’ applications.

· Works closely with application developers to design and implement SQL Server databases, associated support tools and processes in support of business application development requirements and processes.

· Monitor and optimize database performance by identifying slow-running queries and optimizing them using indexing, query tuning, and configuration changes.

· Performs problem resolution and cause analysis along with recommending and implementing preventive techniques.

· Ensuring that the databases are updated accurately and regularly

· Controlling access, performance monitoring and tuning;

· Identifying and resolving users' problems;

· Developing and implementing maintenance procedures

· Collaborating in the design and development of databases to meet new user needs and respond to/anticipate technological innovations

· Planning and co-coordinating database security measures;

· Communicating regularly with internal technical, applications, and operational staff, to ensure database integrity and security;

· Performs related duties as required

· Implementing changes to data policy, standards and guidelines;

· Database performance and tuning;

· Integrity of data structures across span of responsibilities;

· Supports the production environment by ensuring that databases are available and maintained according to maintenance plans and business needs;

· Recommendation of technical database features or utilities;

· Experience with installing and configuring new Microsoft SQL Server releases, management of database tables sizing, expansion, and protection.

· Monitor, recommend, and implement changes for increasing performance measures and managing storage for the application;

· Implementation application-level database configuration changes, diagnostic and problem resolution;

· Technical advice to development staff in the application and system architecture design, standards, and supporting products to be implemented;

· Database backup and recovery as well as disaster recovery;

· Design and implementation of database security strategy including creation of supporting scripts.

· Manage user access and permissions to ensure proper database security

· Design and creation of SQL scripts to enhance and optimize DBA support and batch jobs;

· Strong database performance analysis, query optimization and tuning skills including tracing and profiling.

KNOWLEDGE, SKILLS AND EXPERIENCE

· 3 years experience in the design, implementation, and support of Microsoft SQL Server databases.

· Strong experience with SQL Server 2016 or newer. Experience with SQL 2022 and SSIS a plus.

· Experience with tools utilized in the design and support of Microsoft SQL Server databases, such as SQL Server Management Studio, IDERA SQL Safe and IDERA SQL Diagnostic Manager.

· Assist application-developers in troubleshooting Microsoft .NET applications issues.

· Ability to understand and support vendor software systems including troubleshooting issues that arise.

· Extensive knowledge of T-SQL, views, functions, indexes, triggers, jobs and database permissions and security.

· Strong Microsoft SQL Server database performance analysis, query optimization and tuning skills including tracing and profiling.

· Ability to communicate technical information to non-Information Systems personnel;

· Strong problem-solving, analytical, and troubleshooting skills.

· Effective written and oral communication skills;

Job Type: Full-time

Pay: $95,000.00 - $103,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Employee assistance program
• Employee discount
• Flexible spending account
• Health insurance
• Life insurance
• Paid time off
• Vision insurance

Schedule:

• 8 hour shift
• Monday to Friday

Work Location: In person

Salary : $95,000 - $103,000