Database Administrator

Novalink Solutions LLC•Harrisburg, PA

About The Position

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) and database operations activities (database administration, database security, assuring availability, server and database monitoring, performance monitoring, SQL software installation and configuration, and Service Pack installations). The role involves providing operations support for SQL Database and Database Server administration for critical production systems, ensuring the overall health, availability, and quality of services. Key responsibilities include performing health checks to review database performance, identifying areas for enhancement, and migrating/upgrading SQL Databases. The position also entails performing data migration by designing programs to extract, cleanse, transform, and load data, as well as deploying and securing SQL database solutions within Azure. Database design support is crucial, involving the definition, development, and creation of databases based on requirements, and meeting with developers and vendors to ascertain needs and provide consulting assistance. Additional duties include deploying and maintaining database schema changes, providing technical support for the PSP Data Warehouse, Data Marts, and Power BI environments, and integrating Azure SQL resources with other Azure services. The role requires monitoring, troubleshooting, and optimizing Azure SQL and SQL Server Database performance and availability, supporting the migration of on-premises SQL Server databases to Azure SQL, and designing, developing, and maintaining logical and physical database models. Collaboration with developers, business stakeholders, and vendors is essential for gathering requirements and recommending appropriate database architectures. The Database Administrator will also coordinate database backup and restore requests and ensure adherence to database standards.

Requirements

SQL Server Database Administration experience Required 7 years
Data Analytics experience Required 3 years
Azure Database Administration experience Required 1 year
Data Warehouse experience Required 1 year
Worked in Database Administration on Production Servers Required 4 years
Excellent Communication Skills Required
Provides high quality and professional customer service Required

Nice To Haves

Business systems analysis and design experience Desired
Microsoft SQL (HA / Always On) Desired
Power BI Administration Highly Desired

Responsibilities

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.
Deploying SQL database solutions within Azure.
Securing Azure SQL resources and data.
Provides Database Design support.
Defines, develops, and creates databases by assessing requirements.
Meet with developers and vendors to ascertain requirements and to provide consulting assistance to determine the appropriate database configurations.
Deploy and maintain database schema changes across test and production environments.
Provide technical support for the PSP Data Warehouse, Data Marts, and Power BI environments in collaboration with the Lead Power BI Administrator.
Deploy, configure, secure, backup, and maintain Azure SQL database solutions.
Integrate Azure SQL resources with other Azure services to support enterprise applications and data solutions.
Monitor, troubleshoot, and optimize Azure SQL and SQL Server Database performance and availability.
Support the migration of on-premises SQL Server databases to Azure SQL.
Design, develop, and maintain logical and physical database models based on business and technical requirements.
Review and validate data models and data dictionaries to ensure compliance with organizational standards.
Develop and maintain database structures, including tables, relationships, and normalization, to ensure data integrity, efficiency, and minimize redundancy.
Collaborate with developers, business stakeholders, and vendors to gather requirements and recommend appropriate database architectures and configurations.
Coordinate database backup and restore requests with the backup administration team.
Engages in ongoing process improvement.
Execution of all responsibilities with little direct supervision of Team Lead.
Determine time estimates and schedule for own work and resolve issues in a timely manner.
Identify and track 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 update on all work activities.
Follow database standards.
Able to work in a team environment.
Complete assigned tasks.