Vacancy expired!
Location: Chesterfield, MO Description: Our client is currently seeking a SQL Database Administrator on a Direct Hire/FTE Basis.
This is a St. Louis based role, but will be allowing of remote work structure! SQL Database Administrator: Responsible for the analysis, design, implementation and support of databases used in the development of in-house application solutions and acquired software platforms. Responsible for the implementation and execution of preventative maintenance routines to ensure end-user availability and performance of database files and their related management systems. Work with management to develop database strategies to support organizational needs. Consult with and advise the development staff on proper database usage as it relates to development tasks. Direct and control the maintenance and use of the organizational data dictionary. Responsible for proper security of all databases and their respective database management systems. Responsible for quality control and auditing of databases to ensure accurate, secure, and appropriate use of both testing and production databases. Establishes/maintains robust methods for monitoring, alerting and capacity management objectives within scope of responsibility. Education/Experience:- Bachelor's Degree in Computer Science or related field is required.
- Minimum of 5+ years of Database administration and design including designing high-availability systems in a distributed environment.
- Experience with application development methodologies (such as Agile) is highly desirable. Experience within the financial servicing industry will be beneficial. Previous experience designing or participating in the build out of a data warehouse would be beneficial.
- Extensive knowledge of Database Administration on Microsoft SQL Server 2016 and newer in a multi-site high-availability environment.
- Extensive expertise with Microsoft SQL Server, SQL queries, stored procedures, data structures and experience with applied SDLC practice and Change Management.
- Knowledge of programming, systems analysis and design, and database structures.
- Knowledge of high availability solutions such as Microsoft Windows Failover Clustering and AlwaysOn Availability Groups.
- Working knowledge of SQL Server and system performance tuning tools such as Perfmon, Database Engine Tuning Advisor, SQLIO, PAL, SQL Sentry Performance Advisor, DMVs.
- Knowledge of advanced T-SQL techniques including windowing functions, common table expressions, functions.
- Knowledge of PowerShell is beneficial. Knowledge of SQL Server Integration Services, Reporting Services and Audit is essential. High-level knowledge of vSphere, Microsoft Server 2016/2019 and Veeam is beneficial
- ID: #43827585
- State: Missouri Chesterfield 63005 Chesterfield USA
- City: Chesterfield
- Salary: USD TBD TBD
- Job type: Permanent
- Showed: 2022-07-04
- Deadline: 2022-09-01
- Category: Et cetera