MS SQL Server DBA

4 weeks ago


Arkansas County, United States IT Allianz Inc Full time
Job DescriptionJob Description

Title: MS SQL Server DBA

Location: Little Rock, Arkansas,

Onsite Day 1 in LIttle Rock, AR for 3 months. Then remote if approved.

. This is a senior-level experience role.

State government experience is a plus.

Visas: No H1B's & CPT's

Short Description:

The SENIOR SQL Database Administrator will be responsible for providing reliable, cost-effective, & secure enterprise-wide support for business critical production & non-production databases for the Arkansas Integrated Revenue System (AIRS) .

Complete Description:

ON-SITE WORK for at least the first 3 months. The position will then allow remote work after the contractor's work has been satisfactorily verified.

Expert Level SQL Database Administrator

Position is available for extensions.

NOTE: Some SQL shops have multiple members with each member performing specific functions. This position requires candidates that have recent experience in ALL aspects of SQL DBA Administration.

MINIMUM: 7 Years experience SQL Server 2016 (or later versions) database administration:

Installing and upgrading SQL Servers, including applying service packs

Performing routine database maintenance

o Creating and scheduling SQL Server jobs to perform database maintenance activity

o Rebuilding indexes

o Updating statistics

o Consistency checks

o Monitoring error logs and event logs for database errors

SQL Server native tools and service

o SQL Server Profiler

o Index Tuning Advisor

o SQL Server Configuration Manager

o Extended Events

o Performance Monitor

o Dynamic Management View

o SQL Server Broker Service

o Linked Servers

o MSDTC

o SQL Server System Databases

o Database Mail

o SQL Server Health Checks and Policies

Managing SQL Server security and auditing

o User security

o Database roles

o Authentication methods

o SQL Server and database auditing

o Encryption at rest, transit, and backup

Capacity Planning for storage and database objects

o Maintaining and managing SQL Server disk space to ensure storage is properly utilized

o Index and statistics usage

o Managing disk storage for Windows Failover Cluster Service (WFSC)

Database backup and recovery

o Establishing standards and schedules for database backups

o Developing recovery procedures to meet RPO and RTO

o Restoring databases with point in time recovery

Creating and testing Disaster Recovery plans

Proficient in TSQL coding, tuning, and ETL methodologies

SQL Server High Availability Methods

o Mirroring

o Always On

Required: 5 Years Windows Server Administration experience:

Building and maintaining Windows Host and Guest Servers

Installing and managing end point protection

Nessus configuration and vulnerability scans

Application Server, Web Server, File Server, and FTP Server configuration and maintenance

Utilizing PowerShell for administration tasks

Windows Failover Cluster configuration and maintenance

Windows Server Roles and Features

.NET Framework Components

Preferred Knowledge and Skills:

Familiarity with industry security standards (PUB1075, FIPS, and PII)

  • Cloud computing knowledge
  • Cloud storage, backup, and restore mechanisms

F5 administration

Firewall administration and maintenance

SAN, RAID Controller, and other storage device maintenance knowledge

Active Directory knowledge (GPO, FQDN, DNS Server, SPN)

Email, SMTP, and Proxy Server troubleshooting

GenTax architecture and application maintenance

Web Services development and support

Availability to provide 24 hour support

Strong communication skills, both oral and written

  • Required /Desired

Skill

Required /Desired

Amount of Experience

Candidate's actual years of experience

Senior SQL Database Administrator Skills and Experience

Required

10 Years

SQL Database administration (see sub-bullets in JD) SQL Server 2016 or later

Required

8 Years

Windows Server Administration experience (see sub-bullets in JD)

Required

6 Years

Certifications

Required

24hr Support

Required

GenTax Software Application architecture and application maintenance

Desired



  • Arkansas County, United States vTech Solution Full time

    Job DescriptionJob DescriptionJob DetailsJob Title: Senior Financial .Net Developer/Architect Job location: Little Rock, AR 72201Job Duration: 14 Months with possibilities of an extensionWork Module : Hybrid (First 4 weeks Onsite)Job Description:Overview client has a custom developed Statewide Budget Solution that provides the following plans for the Client:...


  • Arkansas County, United States vTech Solution Full time

    Job DescriptionJob DescriptionJob DetailsJob Title: Senior Financial .Net Developer/Architect Job location: Little Rock, AR 72201Job Duration: 14 Months with possibilities of an extensionWork Module : Hybrid (First 4 weeks Onsite)Job Description:Overview client has a custom developed Statewide Budget Solution that provides the following plans for the Client:...


  • Orange County, United States CoStar Group Full time

    Responsibilities Administrate and integrate with Microsoft SQL Server so decent MSFT SQL DBA skill is required Demonstrate extensive knowledge of all aspects AWS Database Engines (RDS, DynamoDB)  Include DB technology evaluation, guidance and consultation, design support, task automation and scripting, best practice and standards development, capacity...


  • Orange County, United States CGS Business Solutions Full time

    CGS Business Solutions is committed to helping you, as an esteemed IT Professional, find the next right step in your career. We match professionals like you to rewarding consulting or full-time opportunities in your area of expertise. We are currently seeking Technical Professionals who are searching for challenging and rewarding jobs for the following...

  • Technical Specialist

    2 weeks ago


    Iowa County, United States IT Allianz Inc Full time

    Job DescriptionJob DescriptionJob Title: Technical SpecialistLocation: Des Moines, Iowa, (Hybrid),Duration: 1+ Year Client: State of IowaInterview: In person CANDIDATE MUST BE LOCAL TO IOWA JOB DETAILS Overall IT experience: Required. 8 yrs. +Education: Bachelor's degree. Highly desired.Database programming; developing business application processes;...


  • Iowa County, United States nLeague Full time

    Job DescriptionJob Description.NET Technical Lead(Local to Iowa)Location: Remote, 200 E Grand Avenue | Des Moines, IA 50309 Client: IA DOM HHSJob Id: 735334Duration: 12+ MonthsJob Description:This is a Senior .NET Developer will be part of a development team and will assist in end-to-end system enhancement, system support and new development using C#,...


  • Arkansas City, United States Laksan Technologies Full time

    Job DescriptionJob DescriptionHYBRID: The selected candidate must be located-in or willing to relocate to the Little Rock area. This will be on-site work for a minimum of one month. DFA has a partial remote work policy that is available after six months, but will require being located within the Little Rock area. Possibility of extensions. OverviewDFA has a...


  • Arkansas City, United States Laksan Technologies Full time

    Job DescriptionJob DescriptionHYBRID: The selected candidate must be located-in or willing to relocate to the Little Rock area. This will be on-site work for a minimum of one month. DFA has a partial remote work policy that is available after six months, but will require being located within the Little Rock area. Possibility of extensions. OverviewDFA has a...

  • .Net Developer

    3 weeks ago


    Iowa County, United States Stellar Professionals Full time

    Job DescriptionJob Description.NET DEVELOPER Applicant must have 5 years of experience with the following: Experience in developing ASP.NETExperience with ASP.NET WebformsExperience with RESTFUL development for web services and APIsExperience using C#, VB.NET, and ASP.NET CoreProficiency with using Visual Studio 2022 and previous versionsExperience in...

  • Webmethods Developer

    3 weeks ago


    Orange County, United States OSI Digital Full time

    Job DescriptionJob DescriptionJob Title: Webmethods DeveloperLocation: Orange County, CAThe ideal candidate will be responsible for designing, developing, testing, and maintaining integration solutions using Software AG's WebMethods suite. You will collaborate with cross-functional teams to understand business requirements and translate them into...

  • Front End Developer

    1 month ago


    Des Moines County, United States Resource Informatics Group Inc Full time

    Job DescriptionJob Description We are needing a front end developer with the following skillsetsReact or Angular but prefer React • Java • Spring • Database (SQL server preferred) • REST API • Web development / HTML5/CSS3

  • Front End Developer

    1 month ago


    Des Moines County, United States Resource Informatics Group Inc Full time

    Job DescriptionJob Description We are needing a front end developer with the following skillsetsReact or Angular but prefer React • Java • Spring • Database (SQL server preferred) • REST API • Web development / HTML5/CSS3


  • Iowa County, United States IT Allianz Inc Full time

    Job DescriptionJob Description.NET Full Stack Tech Lead Location: Des Moines, Iowa, (Remote) Duration: 1+ Year Client: State of Iowa JOB DETAILS Overall IT experience: Required. 5 yrs. +candidate with some lead experienceEducation: Bachelor's degree. Highly desired.Experience in developing ASP.NET. Required. 5 yrs.Experience with ASP.NET Webforms....


  • Suffolk County, United States TeamLogic IT West Babylon Full time

    Job DescriptionJob DescriptionThe IT Technician’s role is to ensure system operation and functionality so that end users can accomplish business tasks. The objective of the IT Technician will be to respond to support requests in a timely manner, be the initial reference point for all IT support-related tickets, and ensure the satisfaction of the end-user,...


  • Sacramento County, CA, United States Employment Development Department Full time

    **TELEWORK IS CURRENTLY AVAILABLE, HOWEVER, STAFF MAY BE REQUIRED TO REPORT TO THEIR ASSIGNED HEADQUARTERS AS BUSINESS NEEDS ARISE.** Are you looking for a fast-paced and challenging position that will provide you with a wide range of SQL Database Administration experience, extensive variety, frequent exposure to database technologies and career growth in...

  • System Administrator 1

    2 months ago


    caroline county, United States M.C. Dean Full time

    Position Summary In this role you will be responsible for administering, maintaining, testing, and monitoring Badging Systems, Visitor Management Systems, Physical Access Control Systems, Video Surveillance Systems, Intercom Systems, and other Integrated Electronic Systems. Candidates must be flexibility in schedule, neat in appearance, able to communicate...

  • SharePoint Architect

    2 weeks ago


    Queens County, United States Techtriad Team - T3 Full time

    SharePoint Architect HybridLong Island City, Queens, NYContract to Hire Job Description: What You ll Do ECR SharePoint Engineer is responsible for the management, maintenance, and optimization of ELC s controlled SharePoint environments within the organization. Their duties typically include:and Configuration: Creating and configuring SharePoint sites,...

  • Azure Cloud Architect

    2 weeks ago


    Orange County, United States CGS Business Solutions Full time

    CGS Business Solutions is committed to helping you, as an esteemed IT Professional, find the next right step in your career. We match professionals like you to rewarding consulting or full-time opportunities in your area of expertise. We are currently seeking Technical Professionals who are searching for challenging and rewarding jobs for the following...


  • Idaho County, United States Yashco Systems Full time

    Job DescriptionJob DescriptionQA Automation Engineer Min 6+ Years Exp MustLocation: Boise, ID ( priority) but any other location, Spring, TX, Austin, TX or Ft Collins, CO 5 days onsite RoleFTE role with Mphasis, only visa independent candidates (GC-EAD/ USC/ L2/ GC/ H4-EAD/ OPT-EAD ) QA Automation Engineer Min 6+ Years Exp MustLocation: Boise, ID (...


  • Idaho County, United States Yashco Systems Full time

    Job DescriptionJob DescriptionQA Automation Engineer Min 6+ Years Exp MustLocation: Boise, ID ( priority) but any other location, Spring, TX, Austin, TX or Ft Collins, CO 5 days onsite RoleFTE role with Mphasis, only visa independent candidates (GC-EAD/ USC/ L2/ GC/ H4-EAD/ OPT-EAD ) QA Automation Engineer Min 6+ Years Exp MustLocation: Boise, ID (...