Database Administrator role at Dauphin County, PA
: Job Details :

Database Administrator role at Dauphin County, PARole: Database AdministratorLocation: Dauphin CountyComplete Description:This position is responsible for advanced technical work in all phases of database administration support, including development activities (supporting 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).Provides Operations support for SQL Database and Database Server administration support for critical production systems.Ensures overall health, availability, and quality of services.Performs Health Checks to review the performance of databases and provide recommendations to enhance performance.Performs migration and upgrade of SQL Databases from legacy server/SQL Version to new server/SQL Version.Designs programs for data migration to optimally extract, cleanse, transform, and load data between data sources.Deploys database schema changes to test and production environments.Provides Power BI Support Assistance to the Lead Power BI Administrator.Provides Data Warehouse Support Assistance to the Lead Data Warehouse Administrator.Provides Data Mart Support Assistance to the Lead Data Mart Administrator.Deploys SQL database solutions within Azure.Secures Azure SQL resources and data.Interconnects Azure SQL resources with other Azure services.Monitors and optimizes Azure SQL Database performance.Manages 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 tools to develop data models.Reviews data dictionaries and data models, providing comments in accordance with standards.Defines, develops, and creates databases by assessing requirements.Designs tables through database normalization by efficiently organizing data and ensuring data dependencies make sense.Meets with developers and vendors to ascertain requirements and provide consulting assistance for appropriate database configurations.Requests backup and restore from the backup team.Role Description:Engages in ongoing process improvement.Knowledgeable in data analysis and database management techniques.Executes all responsibilities with little direct supervision.Determines time estimates and schedules for own work, resolving issues promptly.Identifies and tracks issues, risks, and action items.Coordinates with vendors and service providers to resolve technical support issues.Assists in coordinating software releases.Manages and provides status updates on all work activities.Follows database standards.Able to work in a team environment.Completes assigned tasks.#J-18808-Ljbffr