MS SQL Database Administrator

Overview

Allied Consultants, Inc. is an Austin-based firm which has for 33 years been a premier provider of technical and business professionals to clients in Texas. We are currently seeking an experienced MS SQL Database Administrator to be a key resource on a technical services team.

Allied Consultants offers its family of consultants excellent rates, a local support staff, and an attractive benefits package which includes medical insurance (Allied shares a percentage of the cost), life insurance, a matching 401(k) plan and a cafeteria plan.Candidates selected for interview will be required to undergo criminal background checks and may be required to complete a drug screen in accordance with Federal and State Law.  Offers of Employment are contingent on a successful background checkAllied Consultants is an equal opportunities employer.

Responsibilities

Performs highly complex (senior-level) database and application administration work in the Information Systems Division. Work involves defining, monitoring, maintaining, developing and tuning integrated database system environments for client's application areas. Works primarily within Microsoft SQL Server and related application environments. Also actively explores the need and application of AI and data analysis for DBA duties in the near future. Works under limited direction of the Database Administrator Team Lead with considerable latitude for the use of initiative and independent judgment.

Duties and Responsibilities

Essential Functions:

• Provides accurate and timely system and database administration for client's applications. Plans database server layout, conducts SQL Server instance capacity planning. Implements and manages databases and environments to provide healthy, robust, and scalable database platforms. Ensures the integrity, reliability and performance of the database environment for development, test, and production systems.
• Provides accurate and timely technical support for application client/server and web environments, including development, test and production systems. Provides technical assistance to development, end-user and other staff.
• Installs, configures, upgrades, and patches database software, application software and other supporting products. Coordinates activities with vendors as necessary for timely installation, software upgrades and maintenance as well as configuration and management ensuring use of best practices.
• Performs application and database backup/recovery and cloning.
• Participates in the development and documentation of operating procedures and metrics and perform quality control to ensure the standards and requirements are met. Analyzes existing procedures for efficiency and effectiveness.
• Collaborates with various teams including application and network teams.
• Participates in strategic planning in a highly complex manner, including the AI and data analytics fields.
• Attends work regularly in accordance with agency leave and attendance policies. Complies with all applicable agency policies and procedures, including safety and standards of conduct. Performs on-call or scheduled after hours work as required.
•  

Knowledge, Skills and Abilities

Thorough knowledge of the principles, practices, and techniques of development and design of systems as it relates to architecture; of project control; of database structures and theories; of current database technologies; of data analysis techniques. The ability to identify and define user task needs; to process information logically; to conduct short-range and long-range project planning; to plan, organize, and coordinate work assignments; to assess future information needs so that the databases can evolve in an appropriate manner. Ability to follow established procedures and assist in the development of new procedures; to work in a team environment; and handle multiple projects with strong attention to detail. Strong interpersonal and communication skills. Uses all knowledge, skills and abilities to apply critical thinking to all aspects of the job. Critical thinking is a process of forming reasoned opinions through observation, information collection, interpretation, analysis, inference, evaluation, and other skills necessary to successfully meet performance standards of the job. Must be self-motivated.

Professional Expectations:

• Attends all meetings, meets delivery deadlines and is available during client office hours.
• Logs in and remains on agency Jabber during work hours.
• Attends remote meetings with camera on unless prior arranged for camera off.
• Coordinates leave and vacation with client lead.
• Must dress appropriately for a business/business casual environment.
• Communicates respectfully and works harmoniously with all co-workers, customers and vendors.
• Provides exceptional customer service.
• Is flexible; able to work under pressure and able to adapt to change; and able to work on multiple problems and tasks.
• Takes initiative to prevent and solve problems.

**Location of job: Onsite**

Qualifications

Minimum (Required):

Years

Skills/Experience

5-6

Experience in technical computer systems support roles

3-4

Experience as an MS SQL Server Database Administrator

Preferred (Optional):

Years

Skills/Experience

2

Experience in SQL tuning

2

Experience in tuning the performance of MS SQL Server database environments

3

Working with system and database management tools.

Knowledge of and experience with AI and data analysis