Database Administrator II at Zeomega Inc

Plano, Texas, United States -

Full Time

Start Date

Immediate

Expiry Date

06 May, 26

Salary

0.0

Posted On

05 Feb, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Database Administration, SQL Server, SSIS, PowerBI, Data Warehouse, Performance Tuning, Data Integrity, Backup and Recovery, T-SQL, PL/SQL, Windows Clusters, High Availability, Monitoring, Security Management, ETL, Data Migration

Industry

Software Development

Description

Description The Database Administrator II is responsible for installing, maintaining, and securing database systems to ensure optimal performance, data integrity, and reliable backup and recovery. This role also supports database planning and development efforts and troubleshoots issues to meet user and business needs. Requirements Education: Bachelor's degree preferred (B.S. or B.A. in Computer Science or related field) or equivalent. Experience: Minimum of 6 years of experience and/or training; or equivalent combination of education and experience in related field. Computer Skills: To perform this job successfully, an individual should have extensive knowledge and the ability to use MS-Office products (Word, Excel, Visio, PowerPoint, and Outlook), Linux based systems, SQL Server database systems, SSIS, PowerBI, Redgate, SolarWinds, MS Teams,WebEx, GoTo Meeting and other productivity tools. Other Requirements: Expert knowledge of transactional databases and strong working knowledge of data warehouse environments Ability to configure, maintain, and support Windows and SQL Server clusters Experience implementing SQL Server Always On Availability Groups for high availability Proficiency in monitoring and analyzing SQL Server databases (SQL Server 2022 and earlier), including related tools and scripts Expert knowledge of SSIS packages, including deployment, upgrades, and ongoing maintenance Experience with SQL Server Change Data Capture (CDC) Experience supporting continuous integration and deployment for databases Strong understanding of logical and physical database design principles Ability to perform SQL Server and operating system–level performance tuning and monitoring In-depth knowledge of SQL Server backup and recovery strategies and scenarios Expert knowledge of SQL Server security management and data integrity Experience working with data warehouse platforms, including extract, load, and transform (ELT/ETL) processes; SSIS experience required Advanced industry knowledge of performance tuning, query optimization, and environment remediation Experience with database tools such as Redgate, Spotlight, and OEM, with flexibility to learn and adopt new tools Strong T-SQL and PL/SQL programming skills, including DDL and DML scripts, stored procedures, triggers, views, and related objects

Responsibilities

The Database Administrator II is responsible for installing, maintaining, and securing database systems to ensure optimal performance and data integrity. This role also supports database planning and development efforts and troubleshoots issues to meet user and business needs.