We are seeking an MS-SQL DBA with SQL Tuning experience and an AI and Data Analytics background, highly preferred, for an on-site role with our Austin, Texas client, performing highly complex database and application administration work in the Information Systems Division. Work involves defining, monitoring, maintaining, developing, and tuning integrated database system environments for the client's application areas. Works primarily within Microsoft SQL Server and related application environments. Also, it actively explores the need for and application of AI and data analysis for DBA duties. Works under the limited direction of the Database Administrator Team Lead with considerable latitude for the use of initiative and independent judgment.
Essential Functions:
• Provides accurate and timely system and database administration for applications. Plan the 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 database environment's integrity, reliability, and performance 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, maintenance, configuration, and management, ensuring the use of best practices.
• Performs application and database backup/recovery and cloning.
• Participates in the development and documentation of operating procedures and metrics, and performs 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 highly complex strategic planning, 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.
Requirements:
• 5 -6 years of experience in technical computer systems support roles.
• 3- 4 years of experience as an MS SQL Server Database Administrator.
Preferred
• 2 years of experience in SQL tuning.
• 2 years of experience in tuning the performance of MS SQL Server database environments.
• 3 years working with system and database management tools.
• Knowledge of and experience with AI and data analysis.
Professional Expectations:
• Attends all meetings, meets delivery deadlines and is available during ERS 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 ERS 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.
Education and Training:
Graduation from an accredited four-year college or university with major course work in data processing, computer science, management information systems, business or related field; or attainment of a diploma from a two-year technical school with specialization in computer technology.
Each year of related experience over the required minimum may be substituted for one year (30 semester hours) of required college credit.