Senior Database Administrator

6 days ago


Omaha, Nebraska, United States Alliant Insurance Services Full time

Alliant Insurance is hiring a Senior Database Administrator for our Omaha office

POSITION HIGHLIGHTS

Hybrid role working 3 days in office, 2 days remote

Monday - Thursday 7:30 - 4:30, Friday 7:30 - 2:00.

Office location: 8420 W Dodge Rd, Omaha, NE 68114

SUMMARY

Responsible for developing and supporting the design, implementation, and administration of database needs for the company.

ESSENTIAL DUTIES AND RESPONSIBILITIES

Troubleshoots issues to full resolution and provides detailed updates to management.

Creates new databases or designs database structures for new systems.

Implements database maintenance best practices including index rebuilds, distribution statistics, and database consistency checks.

Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.

Experience with data Extract, Transform and Load (ETL) methodologies including Microsoft SQL Server Integration Services (SSIS).

Performs database performance tuning activities such as analyzing SQL server query plans, index tuning, troubleshooting database blocking, and resolving deadlocks using SQL Profiler and Windows Performance Monitor.

Creates and manages multiple databases and assists in capacity planning.

Monitors and maintains database systems and troubleshoots problems that may arise.

Maintains data integrity and security.

Executes backups, recovery and recovery testing, and verification.

Develops strategies and implements solutions for managing back-ups, restoration and replication.

Supports software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures.

Proactive housekeeping/archiving and shrinking of databases.

Recommends improvements to database security measures to prevent unauthorized access or misuse of data.

Designs and implements data storage structures such as tables and indexes to improve performance of database applications.

Provides technical support for an organization's database applications by answering user questions about database structure or function.

Mentors and cross trains other team members.

QUALIFICATIONS

EDUCATION / EXPERIENCE

Bachelor's Degree in computer related field or equivalent work experience

Master's Degree preferred

Eight (8) or more years of experience in Database Administration (SQL Server

Five (5) or more years of experience in SQL Server Integration Services (SSIS)

Five (5) or more years of experience in SQL Server Reporting Services (SSRS)

Microsoft Certifications

SKILLS

Strong verbal and written communication skills

Strong organizational and documentation skills

Good planning, prioritization and time management skills

Excellent conceptual, analytical and problem-solving skills

Strong knowledge of database security best practices

Ability to work within a team and to foster teamwork

Proficient in Microsoft Office products

Strong working knowledge of complex computing management systems including system administration, performance monitoring, problem management, change management, records management, and disaster prevention and recovery

Data warehousing, data modeling, and business intelligence knowledge a plus

Snowflake experience a plus

Data Analyst experience a plus

LI-MH1

  • Omaha, Nebraska, United States American Unit, Inc Full time $150,000 - $200,000 per year

    Job DescriptionTitle: Senior PostgreSQL and Oracle Database AdministratorLocation: Omaha, NE (Onsite 5 days/week)Position Summary: As a highly skilled PostgreSQL and Oracle Database Administrator, you will leverage your extensive experience to lead complex database migration projects from Oracle to PostgreSQL. Your role involves comprehensive management and...


  • Omaha, Nebraska, United States Zachary Piper Solutions Full time

    Zachary Piper Solutions isseeking a highly experiencedSenior Power BI Analystto manage and optimize the Power BI environment supporting a DoD program out of Omaha, Nebraska. TheSenior Power BI Administratorwill be responsible for overseeing platform administration, user access, data integration, and governance across the Power Platform...

  • Senior Administrator

    14 minutes ago


    Omaha, Nebraska, United States Matlen Silver Full time

    Position Title: Systems AdministratorLocation:  Omaha Nebraska 68182 OR Lincoln, NE 68512Duration: 06+ Months (Possible Conversion/Extension)***Due to client requirements this role is only open to USC OR GC candidates***Description:Client is looking for a talented Systems Administrator to provide technical systems support, managing/troubleshooting,...


  • Omaha, Nebraska, United States Pacific Life Full time $60,000 - $120,000 per year

    Job Description: Job Description Providing for loved ones, planning rewarding retirements, saving enough for whatever lies ahead – our policyholders count on us to be there when it matters most. It's a big ask, but it's one that we have the power to deliver when we work together. We collaborate and innovate – pushing one another to transform not just...


  • Omaha, Nebraska, United States Dark Wolf Solutions Full time $140,000 - $180,000 per year

    Dark Wolf Solutionsis looking for aSeniorDevOps Engineerto engineer and maintain Infrastructure as Code (IaC) from which mission applications are developed and deployed. A successful candidate should be a leader and problem solver with a proven ability to deliver superior results as part of a high performing team in a fast-paced environment. This position...


  • Omaha, Nebraska, United States State of Nebraska Full time

    The work we do mattersHiring Agency:Correctional Services - Agency 46Location: Omaha, NEHiring Rate:$18.548Job Posting:JR Administrative Technician - Omaha Correctional Center - Health Services (Open)Applications No Longer Accepted On (If no date is displayed, job is posted as open until closed): Job Description:Information about the Nebraska Department of...


  • Omaha, Nebraska, United States GT Midwest Full time $40,000 - $60,000 per year

    :We are a proud family-owned business committed to fostering a positive and collaborative work environment. We believe in supporting our team members and creating a workplace where everyone feels valued and motivated to contribute to our shared success. We are currently seeking a dedicated Office Administrator to join our team and help us maintain smooth...


  • Omaha, Nebraska, United States Frontier Senior Living Full time

    Medication Technician:Frontier Senior Living is seeking an outstandingMedication TechnicianforThe Brant at Gretnacommunity located inOmaha, NE.We are currently looking for Evening shift (2:30pm-11:00pm) and NOC shift (10:30pm-7:00am) Weekends includedFrontier Senior Living's portfolio of communities spans throughout the United States with each community...


  • Omaha, Nebraska, United States OnCare Health Full time

    *Lead Operations, Elevate Patient Care: Join the OnCare Health Team* Our Primary Care Administrator Will:Provide patient care as needed and serve as a clinical resource and educator for providers and other associates.Ensure high level of associate performance through selection, training, coaching counseling, and performance evaluationOversee all functions...


  • Omaha, Nebraska, United States Opti9 Technologies Full time $60,000 - $90,000 per year

    Is this you? You're an outgoing, detail-oriented HR administrative professional who enjoys supporting an HR team and takes pride in getting things done efficiently. You thrive on variety, take initiative to improve processes, and bring enthusiasm to everything you do. If that sounds like you, join our dynamic, growing technology company—where our focus on...