Ice Services
Overview
Designs and architects database solutions. Triage at level 3 to find solutions for medium to very complex issues. Act as SME for application support to provide in-depth database needs including design, performance, deployment. Automate mundane tasks. Bring new skills and technology to help support applications using the latest design and features. Exposure to cloud database technologies and free RDBMS/No-SQL experience is an added advantage. Responsible for standards and design of physical data storage, maintenance, access, and security administration. Responsibilities
Designs and architects database solutions. Optimizes database access and allocates resources for optimum configuration, performance, and cost. Performs data analysis to provide management with timely and accurate information and to predict future requirements. Ensures service level agreements (SLAs) are met for internal and external clients. Provides strategic engineering solutions to drive technology improvements. Takes ownership of projects to ensure successful implementation, including technology stack upgrade efforts. Fosters relationships and acts as a technical liaison between the DBA team and business units. Monitors database performance, availability, and capacity. Participates in continuous business process redesign to improve internal operations. Performs backup and recovery, configures database parameters, prototypes against logical data models, and defines data repository requirements, data dictionaries and warehousing requirements. Performs configuration, scripting, installation, monitoring, administration and tuning for database management systems. Troubleshoots service broker queues, message flow, and stuck messages. Supports BizTalk SQL Server and acts as SME to support messages SLA. Develops, implements and tests database backup and recovery policies and procedures. Documents database policies, procedures, and processes. Performs routine maintenance to keep databases running at peak performance. Reviews database storage utilization and trend analysis for incident remediation and prevention. Interfaces with user departments remotely and on-site to assist in work requests and provide operational support. Researches and evaluates new RDBMS for possible implementation. Performs other duties as required. Knowledge And Experience
Bachelors degree in computer science, Information Systems or the equivalent combination of education, training, or work experience. Requires nine (9) or more years of experience working with various database management systems in database design, testing, implementation, maintenance and administration in a multi-platform environment. Required to participate in a 24x7 on-call rotation. Expert level knowledge of SQL Server database management systems (2012, 2014, 2017, & 2019; SQL 2022 is a plus). Expert level knowledge SQL performance and tuning. Expert level knowledge of Microsoft GEO-Clustering and Always-On Availability Groups in local and geographically dispersed data centers. Extensive knowledge of task automation. Strong database design and analysis skills. Expert level knowledge of backup and recovery operations for database management systems. Expert level knowledge of database encryption such as Always Encrypted, Protegrity, TDE, and TLS. Expert level knowledge of OS, storage, and network layers for troubleshooting purposes. Expert level knowledge of relational database concepts and terminology. Ability to monitor and tune databases and instances. Ability to maintain and monitor availability, security, and integrity of databases. Ability to focus on production and customer needs and deliverables. Ability to adapt to the use of new software tools as they are acquired or adopted within IT. Strong written and verbal communication skills. Must be self-motivated, a team player, and have a strong track record in customer satisfaction. Demonstrated experience with successful system and project implementations. Nice to have Service Broker, and BizTalk SQL support. Nice to have experience interacting with Mainframe flat file ingestion architecture. Nice to have experience for DB2 to SQL Server migration. Preferred Knowledge And Experience
Knowledge of PowerShell scripting and automation. Knowledge of AWS RDS SQL. Knowledge of Microsoft Azure RDBMS. Knowledge of Cloud SaaS RDBMS. Knowledge of OLA Hallengren maintenance plans. Experience with scripting languages. Strong problem-solving skills. Ability to work independently and in a team environment with minimal supervision. Ability to learn and apply new skills in a constantly changing technical environment. Seniority level
Not Applicable Employment type
Full-time Job function
Information Technology #J-18808-Ljbffr
Designs and architects database solutions. Triage at level 3 to find solutions for medium to very complex issues. Act as SME for application support to provide in-depth database needs including design, performance, deployment. Automate mundane tasks. Bring new skills and technology to help support applications using the latest design and features. Exposure to cloud database technologies and free RDBMS/No-SQL experience is an added advantage. Responsible for standards and design of physical data storage, maintenance, access, and security administration. Responsibilities
Designs and architects database solutions. Optimizes database access and allocates resources for optimum configuration, performance, and cost. Performs data analysis to provide management with timely and accurate information and to predict future requirements. Ensures service level agreements (SLAs) are met for internal and external clients. Provides strategic engineering solutions to drive technology improvements. Takes ownership of projects to ensure successful implementation, including technology stack upgrade efforts. Fosters relationships and acts as a technical liaison between the DBA team and business units. Monitors database performance, availability, and capacity. Participates in continuous business process redesign to improve internal operations. Performs backup and recovery, configures database parameters, prototypes against logical data models, and defines data repository requirements, data dictionaries and warehousing requirements. Performs configuration, scripting, installation, monitoring, administration and tuning for database management systems. Troubleshoots service broker queues, message flow, and stuck messages. Supports BizTalk SQL Server and acts as SME to support messages SLA. Develops, implements and tests database backup and recovery policies and procedures. Documents database policies, procedures, and processes. Performs routine maintenance to keep databases running at peak performance. Reviews database storage utilization and trend analysis for incident remediation and prevention. Interfaces with user departments remotely and on-site to assist in work requests and provide operational support. Researches and evaluates new RDBMS for possible implementation. Performs other duties as required. Knowledge And Experience
Bachelors degree in computer science, Information Systems or the equivalent combination of education, training, or work experience. Requires nine (9) or more years of experience working with various database management systems in database design, testing, implementation, maintenance and administration in a multi-platform environment. Required to participate in a 24x7 on-call rotation. Expert level knowledge of SQL Server database management systems (2012, 2014, 2017, & 2019; SQL 2022 is a plus). Expert level knowledge SQL performance and tuning. Expert level knowledge of Microsoft GEO-Clustering and Always-On Availability Groups in local and geographically dispersed data centers. Extensive knowledge of task automation. Strong database design and analysis skills. Expert level knowledge of backup and recovery operations for database management systems. Expert level knowledge of database encryption such as Always Encrypted, Protegrity, TDE, and TLS. Expert level knowledge of OS, storage, and network layers for troubleshooting purposes. Expert level knowledge of relational database concepts and terminology. Ability to monitor and tune databases and instances. Ability to maintain and monitor availability, security, and integrity of databases. Ability to focus on production and customer needs and deliverables. Ability to adapt to the use of new software tools as they are acquired or adopted within IT. Strong written and verbal communication skills. Must be self-motivated, a team player, and have a strong track record in customer satisfaction. Demonstrated experience with successful system and project implementations. Nice to have Service Broker, and BizTalk SQL support. Nice to have experience interacting with Mainframe flat file ingestion architecture. Nice to have experience for DB2 to SQL Server migration. Preferred Knowledge And Experience
Knowledge of PowerShell scripting and automation. Knowledge of AWS RDS SQL. Knowledge of Microsoft Azure RDBMS. Knowledge of Cloud SaaS RDBMS. Knowledge of OLA Hallengren maintenance plans. Experience with scripting languages. Strong problem-solving skills. Ability to work independently and in a team environment with minimal supervision. Ability to learn and apply new skills in a constantly changing technical environment. Seniority level
Not Applicable Employment type
Full-time Job function
Information Technology #J-18808-Ljbffr