Technical Architecture – SQL

We are seeking a skilled SQL Server Database Administrator to provide database administration and support for enterprise applications and SQL Server environments. The role involves managing Microsoft SQL Server databases, designing and maintaining database structures, performing data migrations, optimizing database performance, and ensuring data security, integrity, backup, and recovery. The ideal candidate will work independently while collaborating with database administrators, developers, application teams, and infrastructure teams.

• Perform database administration and support activities using Microsoft SQL Server 2016/2019.
• Install, configure, maintain, and upgrade database software.
• Analyze, design, and review logical and physical data models.
• Support application development and maintenance throughout the system development lifecycle.
• Perform data analysis, data correction, data loading, and database migration activities.
• Review, migrate, and optimize stored procedures to improve database performance.
• Develop and maintain SQL Server Integration Services (SSIS) packages and Power Shell scripts.
• Monitor database performance, storage capacity, and resource utilization, and recommend improvements.
• Analyze and resolve database performance and operational issues.
• Assist with database conversions and migrations from older SQL Server versions to current versions.
• Maintain database access security and data integrity.
• Ensure databases are backed up appropriately and can be restored when necessary.
• Assist with database server infrastructure evaluations and software recommendations.
• Follow established database standards and recommend improvements to database administration practices.
• Use Azure Dev Ops for source control, work item management, documentation versioning, and time tracking.
• Estimate and schedule assigned work, anticipate potential issues, and resolve them in a timely manner.
• Provide accurate status updates to database administration leadership, application leads, analysts, and project managers.
• Represent the database administration team in project status meetings when required.
• Stay current with new database releases and related technologies and recommend improvements and best practices.

• Strong experience with Microsoft SQL Server 2016/2019 database administration.
• Experience installing, configuring, maintaining, and upgrading SQL Server databases.
• Strong understanding of database design, logical and physical data modeling, and database structures.
• Experience with SQL queries, stored procedures, data migration, and data correction.
• Hands-on experience with SQL Server Integration Services (SSIS) and Power Shell scripting.
• Experience monitoring, troubleshooting, and optimizing database performance.
• Knowledge of database security, access management, data integrity, backup, and recovery procedures.
• Experience supporting enterprise applications and database development life cycles.
• Experience using Azure Dev Ops for source control, work items, and documentation management.
• Strong analytical, problem-solving, communication, and documentation skills.
• Ability to work independently with minimal supervision and collaborate effectively within a team.

• Experience supporting multiple enterprise application databases and reporting environments.
• Experience with SQL Server version conversions and database modernization.
• Knowledge of database server infrastructure and related technologies.
• Ability to provide technical guidance and serve as a backup to database administration leadership.

• Microsoft SQL Server 2016/2019
• SQL Server Database Administration
• Database Design and Data Modeling
• T-SQL and Stored Procedures
• SQL Server Integration Services (SSIS)
• Power Shell Scripting
• Database Migration and Data Conversion
• Database Performance Monitoring and Tuning Database Security, Backup, and Recovery
• Azure Dev Ops and Source Control