IT Infrastructure Analyst DBA

Overview

On Site
$50 - $60
Contract - Independent
Contract - W2
Contract - 12 Month(s)

Skills

SQL Database Administration
? Proficient in SQL Failover Cluster and Always On
? SQL DB Replication Publisher / Subscriber

Job Details

Responsibilities
SQL Database Administration
? Train/Knowledge transfer to junior level SQL Admins.
? Extensive knowledge of SQL and SQL server tools
? Proficient in SQL Failover Cluster and Always On
? Experience in database performance, development, and maintenance
? SQL Backup & Restore Flat and NetApp Snapshots
? SQL DB Replication Publisher / Subscriber
? SQL Server Reporting Services - Reports management and troubleshooting
? T-SQL Code execution/analysis
? In-depth understanding of database security, backup and recovery, and performance
monitoring requirements
? Familiarity with relational and dimensional data modelling
? DB Restores to different servers retaining security settings required for the destination.
? Keep/Stay in line with security policies that are in place.
? Develop T-SQL to execute repetitive tasks as consistently as possible
? SQL Resource Based Constrained Delegation
? SSIS Data import and Transformation from flat files csv, tsv text.
? SSIS Data import and Transformation from Excel, MS Access
SQL Server Administration & Deployment
? Train/Knowledge transfer to junior level SQL Admins.
? Plan deploy and manage SQL 2019 & 2022
? Plan deploy and manage SSRS
? Migrate SSRS reports to new servers
? Experience in SQL Server troubleshooting
? SQL Failover Cluster management
? Kerberos Configuration
? Demonstrated success working in large team environments
? Scale, Plan and deploy SQL Servers standalone and/or Failover Cluster
? Managed Microsoft Azure based PaaS and IAAS environments
? SQL DB Replication Publisher / Subscriber
? SQL Server in-place upgrade
Windows Server Administration
? Proficient in WSFC (Windows Server Failover Cluster Management)
? Powershell scripting for server task automation and/or SQL automation
? Windows Server Patching and scheduling via Tanium codes
? HPE Server Hardware management and monitoring (DL380/360 Gen10, Gen11)
? Manage iSCIS LUN/Disk connectivity to target host.
Position Requirements
Formal Education & Certification
? College diploma or university degree in the field of computer technology, system
administration, computer science, or information systems, or five years+ related work
experience.
Knowledge & Experience
? Extensive knowledge of Microsoft SQL and SQL server tools
? Database performance, development, and maintenance
? Experience overseeing the design, development, and implementation of software and hardware
solutions, systems, or products.
? SQL Backup & Restore Flat and NetApp Snapshots understanding
? Exceptional analytical skills with the ability to apply them to systems issues and products as
required.
? SQL DB Replication Publisher / Subscriber with isolated SCADA SQL Servers
? SSRS Server deployment and Reports security, deployment and management.
? Experience with Oracle is a plus.
? Proficient in Windows Server Administration
? Some RHEL experience is a plus
Personal Attributes
? Able to exercise independent judgment and take action on it.
? Able to effectively communicate with programmers and SSRS reports developers.
? Excellent analytical and creative problem-solving skills.
? Excellent listening, interpersonal, written, and oral communication skills.
? Able to work in the security structure set forth by our main infrastructure team (Dtech).
? Highly self-motivated and directed.
? Ability to effectively prioritize and execute tasks while under pressure.
? Strong customer service orientation.
? Experience working in a team-oriented, collaborative environment.
Work Conditions
? Occasional evening and weekend work to meet deadlines.
? Occasional evening and weekend work for patching or upgrades.
? Sitting for extended periods of time.
? Dexterity of hands and fingers to operate a computer keyboard or mouse, lift and move
servers and to handle other computer components.
? Physical ability to add/remove server hardware.
? Lifting and transporting heavy objects with a team, such as servers that are 1u and/or 2U in top of
rack.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Agile Global Solutions, Inc