1 Database Administrator | Business Analyst Job in Harrisburg, PA
LingaTech is Hiring a Remote Database Administrator | Business Analyst
Contract role.
REQUIRED SKILLS: Microsoft SQL - Power BIThis position is responsible for advanced technical work in all phases of database administration support; development activities (support the application development lifecycle, planning, design, development, implementation, data migration, quality assurance, data cleanup, and data administration) as well as database operations activities (database administration, database security, assuring availability, server and database monitoring, performance monitoring, SQL software installation and configuration, and Service Pack installations).
Role Description:
- Provides Operations support for SQL Database and Database Server administration support for critical production systems.
- Ensures overall health and availability and quality of services
- Perform Health Checks to review the performance of databases to identify and provide recommendations to enhance performance of databases.
- Performs migration and upgrade of SQL Databases from legacy server\SQL Version to new server\SQL Version.
- Performs data migration by designing programs to optimally extract, cleanse, transform and load data between data sources as part of data migration and data validation support.
- Deploy database schema changes to test and production environments.
- Provide Power BI Support Assistance to the Lead Power BI Administrator.
- Provide Data Warehouse Support Assistance to the Lead Data Warehouse Administrator.
- Provide Data Mart Support Assistance to the Lead Data Mart Administrator.
- Deploying SQL database solutions within Azure
- Securing Azure SQL resources and data
- Interconnecting Azure SQL resources with other Azure services
- Monitoring and optimizing Azure SQL Database performance
- Processes for migrating on-premises SQL Server databases to Azure
- Provides Database Design support.
- Creates, maintains, and supports the logical and/or physical design of assigned databases by utilizing modeling tool to develop the data models.
- Reviews data dictionaries and data models; provides comments in accordance with standards.
- Defines, develops, and creates databases by assessing requirements.
- Design tables through database normalization by efficiently organizing data by eliminating redundant data and ensuring data dependencies’ make sense.
- Meet with developers and vendors to ascertain requirements and to provide consulting assistance to determine the appropriate database configurations.
- Request backup and restore from the backup team.
- 7 years of SQL Server Database Administration experience
- 7 years of business systems analysis and design experience
- Experience working with database administration on production servers
- 1-3 years of experience with Azure Database Administration and Data Analytics
Job Summary
Contractor
$86k-110k (estimate)
03/20/2024
06/16/2024
lingatech.com
Camp Hill, PA
<25
Related Companies
The job skills required for Database Administrator | Business Analyst include SQL, Database Administration, Azure, Planning, Data Warehouse, Installation, etc. Having related job skills and expertise will give you an advantage when applying to be a Database Administrator | Business Analyst. That makes you unique and can impact how much salary you can get paid. Below are job openings related to skills required by Database Administrator | Business Analyst. Select any job title you are interested in and start to search job requirements.
The following is the career advancement route for Database Administrator | Business Analyst positions, which can be used as a reference in future career path planning. As a Database Administrator | Business Analyst, it can be promoted into senior positions as a Data Modeling Analyst, Sr. that are expected to handle more key tasks, people in this role will get a higher salary paid than an ordinary Database Administrator | Business Analyst. You can explore the career advancement for a Database Administrator | Business Analyst below and select your interested title to get hiring information.
Similar Jobs
Popular Articles
