Data Base Administrator

Position : Data Base Administrator

Location : Montgomery, AL 36104 (Onsite)

Duration : 10+ Months Contract with potential for extension

Skills Required

Intermediate professional level role.

Supports multiple services and multiple databases of medium to high complexity (complexity defined by database size, technology used, systems feeds and interfaces) with multiple concurrent users, ensuring control, integrity and accessibility of data.

Works on multiple projects as a project leader or sometimes as a project advisor.

May coach more junior technical staff.

• Advanced knowledge in MS SQL Server and Datawarehouse, MS Internet Information Services (IIS), PowerBI and SSAS; advanced knowledge in creating, deploying, and monitoring SSIS packages;
• good knowledge on maintaining SQL report servers (SSRS); good knowledge with SQL server encryption; familiar with industry-level best practices for Microsoft SQL Server security standards;
• expert knowledge on backup & recovery; expert knowledge of on-prem to cloud migration; good knowledge of Azure, industry standard server hardware, operating systems, storage, virtualization, and networking technologies;
• familiar with PowerShell, database source control and continuous integration tools; familiar with RedGate, Tableau and Idera Data Architect tools;

strong problem solving skills and a commitment to getting things done right; eagerness to learn and help others; good written and verbal communication skills and professionalism.

Skills Preferred :

Power BI capacity Admin, connecting gateways to data sources, granting access permissions, creating workspaces, publishing Power BI reports and dashboards.

Familiar with Snowflake; strong teamwork and interpersonal skills with the ability to communicate and persuade to all levels of management.

Experience Required :

5+ years of experience with creating SSIS packages.

8+ years of experience in working as MS SQL Server database administrator and database internals, with strong focus in SQL Server 2016, 2019, and 2022.

8+ years in SQL Server database performance tuning along with good understanding of indexing, execution plans, DMV, database storage, database problem identification, problem diagnosis and resolution.

8+ years writing scripts or using leading tools to monitor, perform backup & recovery, and maintenance automation; hands on experience in on-prem to cloud migration.

hands on experience in creating and troubleshooting SSIS packages.

5+ years of experience in performing code.

5+ years of experience with MS Internet Information Services (IIS) with strong focus on server administration and web applications deployment.

Education Required :

Bachelor’s Degree in Computer Science, Information Systems, or other related field

Education Preferred :

Microsoft Certification in SQL Server Database Administration.