Job Description

Responsibilities: • Administers manages and monitors all systems, including databases, in development, test and production environments • Monitors and manages system backups and recovery, including databases • Designs, implements and manages system (including databases) security requirements and control mechanisms, including, but not limited to, users, groups, roles, and permissions in all environments • Reviews project requirements and develop and recommends alternative solutions • Oversees all activities relevant to testing a system or solution; collaborate with application developers to ensure that all programs and/or databases comply with all standards and function correctly • Collaborates with internal and external partners to ensure customer needs are met by reviewing requirements, statuses, and associated issues • Develops and improves the effectiveness of changes to specialized systems and databases that result in solving specific business problems; recommends improvements accordingly • Researches and recommends IT tools to improve the efficiency of programs and databases • Keeps abreast of technology, customer needs, and industry-related trends • Completes other duties, including special projects, as assigned by Management Tasks and Experience • Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems. • Manage Always On, Disaster Recovery Environment, Replication, and various public cloud connectivity • Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security. • Upgrade SQL Application server to newer versions as required. • Identify and fix SQL Server performance issues, query optimization, and stored procedure performance improvement. • Automate database task, Backup, Restore operations of production databases to other environments for testing and development purpose. • Perform scheduled maintenance and support release deployment activities after hours.