Job Description

Description

Essential Functions • Partner with IT application architects, data architects, and infrastructure architects to plan and meet corporate SQL standards and business goals. • Develop database solutions to support web based, high volume transaction applications. • Work with IT to ensure compliance with corporate policy. • Build and maintain moderately complex stored procedures in collaboration with .NET programmers. • Develop data extracts from existing SQL databases, backup and recovery of database sites and utilization of https, IIS, Windows, and .NET programming techniques. • Administer Windows 2016 and newer and SQL Server 2016 and newer platforms. • Migration of systems from SQL 2012 and 2016 to newer editions. Migration of On-Premises systems and application databases to Azure IaaS or PaaS. • Monitor and maintain all SQL instances and databases to maximize system availability. Quickly diagnose and resolve any issues as they arise. Provide support as required by application owners. • Develop, test, document, and implement high quality SQL database solutions including SQL Stored Procedures and SSIS Packages on time and in accordance with specifications and supporting documents. • Configure and install Microsoft SQL Server (including log shipping, database mirroring, and AlwaysOn Availability Group setup) in both on premises and Azure cloud environments. • Proactively analyze performance of stored procedures, queries, and reports including plan analysis, index recommendations and database server configuration to take actions to correct any discrepancies. • Provide troubleshooting and resolution of support issues. • Provide consultation for the evaluation of SQL and Data Systems. • Provide the implementation and deployment of SQL solutions. • Perform data migrations using T-SQL, SSIS or another package. • Create and develop SQL scripts to execute data test strategies to verify enhancements meet business requirements and data is at an acceptable quality threshold. • Establish, maintain, and follow group procedures and policies related to the SQL Server environment, including installation, configuration, backup, disaster recovery, and other such operations. • Provide ongoing status report updates for current projects. • Participate in on-call schedule for 24 x 7 x 365 support. • Work with IT counterparts and management team to employ analysis and design techniques including database schema design to ensure business goals. • Develop and manage effective working relationships with other departments, groups, or personnel with whom work must be coordinated. • Participate in systems development lifecycle stages including architecture specifications and design; application configuration; database design; programming; quality assurance; testing and implementation; and ongoing maintenance and support. • Meet professional obligations through efficient work habits such as, meeting deadlines, honoring schedules, coordinating resources and meetings in an effective and timely manner, and demonstrates respect for others.