Logo
job logo

Database Administrator - W2 Only

Elegant Enterprise-Wide Solutions, Blythewood, South Carolina, United States, 29016

Save Job

About this Position: Job Title: Database Administrator Daily Duties / Responsibilities: SQL Server: Setup and maintain data replication and mirroring. Configure maintenance automation. Backup and recovery. Troubleshoot SQL Server performance issues as they occur, including after-hours and weekends. SQL Server monitoring. Install and configure new SQL Servers. Develop and support data warehouse and cubes through SQL Server Analysis Services. Migrate SQL Server databases to SQL Server 2022. Develop reports using SSRS. Support SSIS packages. Develop database design, development, and management standards. Consult with developers regarding database design. Implement and support databases for vendor supplied applications. Oracle 19 familiarity: Desired Analyze, develop, and support stored procedures and SQL. Business intelligence: Design, develop, and manage dashboards and reports through a BI solution. Data modeling: Designing, developing, and maintaining logical and physical data models using ERwin Data Modeler. Ensuring database designs support scalability, integrity, and performance requirements. Collaborating with data architects, developers, and business analysts to translate business requirements into data models. Modeling activities are required in Oracle databases and may be required for MS SQL databases. Required skills: 5+ years of experience with SQL Server 2019 and 2022. 5+ years of experience with SQL Server Reporting Services. 5+ years of experience with SQL Server Analysis Services. 5+ years of experience with SQL Reports Designer. 5+ years of experience with BI tools and design. 5+ years of experience as an SQL database administrator. 2+ years of experience working with state government agencies. Preferred skills: Data domain boost (DD Boost) to support backup and restore operations for SQL Servers. Experience with Oracle 19 database operations. Experience with Oracle Grid Control. Experience with ERwin Data Modeler. Required education: BA in computer science, data science, or closely related field. "No phone calls please."