SQL Database Administrator

1 day ago


Lenoir City, Tennessee, United States ShiftCode Analytics Full time
Job Title: SQL Database Administrator

We are seeking a highly skilled SQL Database Administrator to join our team at ShiftCode Analytics. As a key member of our Information Technology team, you will be responsible for designing and supporting our critical database infrastructure.

The ideal candidate will have a strong background in Microsoft SQL Server, with experience in implementing and administering databases within a multi-tiered environment. You will be responsible for managing database security, implementing standard maintenance tasks, and managing SQL Server configurations.

Additionally, you will work closely with the IT team and business functional teams to implement a new ERP system, including a new business intelligence tool. You will also help design a data warehouse and migrate historical source systems to that warehouse.

Responsibilities will include:

  • Implementing and administering Microsoft SQL Server databases within a multi-tiered environment
  • Managing database security and implementing standard maintenance tasks
  • Managing SQL Server configurations and database implementation and design strategies
  • Performing capacity planning, cluster setup, performance tuning, and monitoring
  • Troubleshooting data and database issues and suggesting resolutions
  • Analyzing processing issues and data anomalies and identifying solutions
  • Building and monitoring HA and DR systems using Failover Clustered instances, Always-On Availability Groups, Log Shipping, Mirroring, and Replication
  • Developing, maintaining, and teaching database standards and best practices
  • Working with data owners to verify and obtain approval that any transformed data retains its accuracy
  • Resolving exceptions reported to data conversion

Requirements:

  • 7 years of experience working with Microsoft SQL Server
  • 2 years of experience working with cluster mode
  • 2 years of experience in SQL performance tuning
  • 2 years of experience in DB design (preferred)
  • 2 years of experience with SQL Server 2016
  • 1 year of experience in capacity planning
  • 1 year of experience in disaster recovery
  • Experience working in a Sarbanes-Oxley regulated company (preferred)
  • Experience with SQL 2016 Always-On, Availability Groups, and Failover
  • Experience with data migration with different servers
  • Knowledge of Index and Non-cluster Index
  • Strong background in backend scripting
  • Solid problem determination skills supporting Microsoft SQL problems
  • Experience managing large databases in a real-time production environment
  • Experience resolving database integrity issues, performance issues, blocking/deadlocking issues, connectivity issues, and data replication issues
  • Experience building dashboards and reports in various tools
  • Experience with PowerShell
  • Expertise in ETL tools, data conversion, data de-duplication, data cleansing methodologies
  • ETL and data warehousing experience
  • Microsoft SQL Certification (plus)
  • Excellent written and verbal communication skills
  • Ability to work well independently and within a team environment

Education:

BA/BS or commiserate work experience


  • Database Architect

    2 weeks ago


    Lenoir City, Tennessee, United States ShiftCode Analytics Full time

    Database Administrator and AnalystWe are seeking a highly skilled and experienced Database Administrator and Analyst to join our Information Technology team at ShiftCode Analytics. The ideal candidate will have a strong background in Microsoft SQL Server and a passion for designing and supporting critical database infrastructure.Key...


  • Lenoir City, Tennessee, United States WindRiver Lakefront & Golf Community Full time

    Job SummaryWindRiver Lakefront & Golf Community is seeking a highly organized and detail-oriented Administrative Assistant to join our team. As a key member of our staff, you will provide exceptional support to our employees, members, and owners, ensuring a positive and seamless experience for all.Key ResponsibilitiesProvide administrative support to the...


  • Lenoir City, Tennessee, United States WindRiver Lakefront & Golf Community Full time

    {"Job Title": "Administrative Assistant", "Job Summary": "WindRiver Lakefront & Golf Community is seeking a highly skilled Administrative Assistant to join our team. As a key member of our operations team, you will provide exceptional support to our members, owners, and staff.Responsibilities:* Provide administrative support to the operations team, including...


  • Johnson City, Tennessee, United States City of Johnson City Full time

    Join Our Team as a Geospatial Systems AdministratorThe City of Johnson City is seeking a skilled Geospatial Systems Administrator to enhance our Information Technology Geospatial Information System (IT-GIS) team. This position offers a unique chance to engage in GIS solutions that bolster municipal operations.In this role, you will collaborate with team...


  • Johnson City, Tennessee, United States City of Johnson City Full time

    Join Our Team as a Geospatial Systems AdministratorThe City of Johnson City is seeking a skilled Geospatial Systems Administrator to enhance our Information Technology Geospatial Information System (IT-GIS) team. This position offers a unique chance to engage in GIS solutions that bolster City functions.In this role, you will collaborate with various...


  • Lenoir City, Tennessee, United States WindRiver Lakefront & Golf Community Full time

    {"Responsibilities": "Key ResponsibilitiesEffectively schedule, coordinate and oversee all project subcontractors.Coordinate materials and equipment delivery with vendors and suppliers.Maintain a daily log for the job site's operations, reporting to management as necessary.Make changes in the operation as necessary to best meet construction deadlines.Ensure...


  • Lenoir City, Tennessee, United States WindRiver Lakefront & Golf Community Full time

    WindRiver Lakefront & Golf Community is seeking a skilled Site Construction Manager to oversee and direct all on-site operations for various construction initiatives, working in close partnership with the Senior Project Manager to ensure the successful delivery of high-quality projects within established timelines and budgets. Key Responsibilities Engage...

  • Data Analyst

    2 weeks ago


    Johnson City, Tennessee, United States Regional School District 12 Full time

    Job SummaryWe are seeking a highly skilled Data Specialist to join our team at Regional School District 12. The successful candidate will be responsible for providing accurate data to support decision-making and improvement initiatives within the district.Key ResponsibilitiesDevelop and maintain a systemic process for student databases to enable improved...

  • Data Analyst

    3 weeks ago


    Johnson City, Tennessee, United States Regional School District 12 Full time

    Job Summary:The Regional School District 12 is seeking a highly skilled Data Specialist to join our team. As a Data Specialist, you will play a critical role in managing student databases, providing data-driven insights for decision-making, and supporting technical business office systems.Key Responsibilities:Manage and maintain accurate and up-to-date...


  • Johnson City, Tennessee, United States The Assurance Group, Inc Full time

    Position Overview: The Assurance Group, Inc. is seeking a dedicated Customer Support and Sales Coordinator to enhance our client experience through effective administrative support. Key Responsibilities: Provide exceptional assistance to clients by managing appointment reviews and guiding them through the appointment transfer process.Handle updates,...


  • Johnson City, Tennessee, United States Regional School District 12 Full time

    Job Summary:We are seeking a highly skilled Digital Learning Specialist to join our team at Regional School District 12. As a key member of our educational technology team, you will be responsible for providing professional and digital support to our school community.Key Responsibilities:Develop and implement a systemic process for student database...

  • Registered Nurse

    4 weeks ago


    Johnson City, Tennessee, United States Cynet Health Full time

    Overview:Emergency care specialists are responsible for delivering critical support to patients experiencing severe health issues or trauma that necessitate immediate medical intervention. They must possess the ability to swiftly identify and manage life-threatening situations. Operating under general oversight, these professionals provide comprehensive care...


  • Jersey City, New Jersey, United States Danta Technologies Full time

    Job Title: SQL Database AdministratorWe are seeking a highly experienced and technically proficient SQL Database Administrator to join our team at Danta Technologies. As a key member of our IT department, you will be responsible for managing and optimizing large databases, driving automation initiatives, and ensuring high availability and disaster recovery...


  • Jersey City, New Jersey, United States Danta Technologies Full time

    Job Title: SQL Database AdministratorWe are seeking a highly experienced and technically proficient SQL Database Administrator to join our team at Danta Technologies. As a key member of our IT department, you will be responsible for managing and optimizing large databases, driving automation initiatives, and ensuring high availability and disaster recovery...


  • Oklahoma City, Oklahoma, United States Hobby Lobby Full time

    Job Title: SQL Server Database Administrator **Job Summary:** We are seeking a highly skilled SQL Server Database Administrator to join our team at Hobby Lobby Stores, Inc. As a key member of our IT department, you will be responsible for providing operational database services to our organization. This role will involve owning, tracking, and resolving...


  • Ellicott City, United States 4A CONSULTING LLC Full time $90,000 - $100,000

    Job DescriptionJob DescriptionRole: Azure/SQL DBALocation- RemoteDuration: Full timeQualifications:Minimum of 8+ years hands-on experience in database administration and management, with a focus on Azure SQL Database and on-premises databases (e.g., SQL Server, Oracle).Hands-on experience in developing and maintaining complex stored procedures, functions,...


  • Ellicott City, Maryland, United States Leidos Full time

    Job Title: Senior SQL Database AdministratorWe are seeking a highly skilled Senior SQL Database Administrator to join our team at Leidos. As a key member of our Defense Enclave Services (DES) team, you will play a critical role in supporting data system services and operations for our clients.Key Responsibilities:Analyze business processes and procedures to...


  • Ellicott City, Maryland, United States Leidos Full time

    Job Title: Senior SQL Database AdministratorWe are seeking a highly skilled Senior SQL Database Administrator to join our team at Leidos. As a key member of our Defense Enclave Services (DES) team, you will play a critical role in supporting data system services and operations, as well as digital modernization programs critical to DISA and Fourth Estate...


  • Jersey City, New Jersey, United States MUFG Bank, Ltd. Full time

    Job Title: Database Administrator, SQL Server ExpertWe are seeking an experienced Database Administrator with expertise in SQL Server and Oracle database administration, as well as a strong background in hybrid cloud hosting. The ideal candidate will have a deep understanding of SQL Server and Oracle administration, coupled with expertise in AWS services,...


  • Salt Lake City, United States ConsultNet Full time

    Sr. SQL Database Administrator Salt Lake City, UT (hybrid) 6month contract to hire Pay Range: $50.00 - $65.00per hr / Salary Target: $100K - $120K Job Description: Our client is looking for an expert in SQL Server design and development to provide leadership in creating and maintaining databases and data structures, interfacing with developers and users to...


  • Kansas City, Missouri, United States Zelis Healthcare Full time

    Job Title: Senior SQL Database AdministratorZelis Healthcare is seeking a highly skilled Senior SQL Database Administrator to join our team. As a key member of our database administration team, you will be responsible for implementing and refining operational and business continuity processes, ensuring the performance, availability, and security of our...


  • Alexander City, Alabama, United States Chelsoft Solutions Co Full time

    Job Summary:Chelsoft Solutions Co is seeking a skilled Database Administrator to join our team. As a key member of our IT department, you will be responsible for ensuring the smooth operation of our database systems.Key Responsibilities:Assist with Sybase database administration, including Unix background running and developing CRON jobs with command line...


  • Jersey City, New Jersey, United States Eateam Full time

    Job Title: Database AdministratorWe are seeking a highly skilled Database Administrator to join our team at Eateam. The successful candidate will be responsible for the daily administration of our databases, including migration and upgrade of Oracle and SQL Server databases.Key Responsibilities:Manage client requirements and ensure timely delivery of...


  • Jersey City, New Jersey, United States Della Infotech Full time

    Job Title: Senior SQL Database Developer Job Overview: We are seeking a highly skilled Senior SQL Database Developer to join our team at Della Infotech. The successful candidate will spend a significant portion of their time developing data pull SQL scripts and procedures for EDBI's Data Warehouse Analysts who service data-related requests and projects...


  • Jefferson City, United States Wipro Full time

    Job Description The Mainframe Database Administrator (DBA) leads the planning, analysis, design, implementation, maintenance, and control of the organization's mainframe databases. The Mainframe DBA consults with and advises senior management and multiple clients on high impact data or database management issues, influencing strategic direction. Handles and...


  • Jefferson City, United States Wipro Full time

    *Job Description*The Mainframe Database Administrator (DBA) leads the planning, analysis, design, implementation, maintenance, and control of the organization's mainframe databases. The Mainframe DBA consults with and advises senior management and multiple clients on high impact data or database management issues, influencing strategic direction. Handles and...


  • Jefferson City, United States Wipro Full time

    Job Description The Mainframe Database Administrator (DBA) leads the planning, analysis, design, implementation, maintenance, and control of the organization's mainframe databases. The Mainframe DBA consults with and advises senior management and multiple clients on high impact data or database management issues, influencing strategic direction. Handles and...


  • Jefferson City, United States Wipro Full time

    Job Description The Mainframe Database Administrator (DBA) leads the planning, analysis, design, implementation, maintenance, and control of the organization's mainframe databases. The Mainframe DBA consults with and advises senior management and multiple clients on high impact data or database management issues, influencing strategic direction. Handles and...


  • Jefferson City, United States Wipro Full time

    Job Description The Mainframe Database Administrator (DBA) leads the planning, analysis, design, implementation, maintenance, and control of the organization's mainframe databases. The Mainframe DBA consults with and advises senior management and multiple clients on high impact data or database management issues, influencing strategic direction. Handles and...


  • Jefferson City, United States Wipro Full time $78,554

    *Job Description*Scroll down for a complete overview of what this job will require Are you the right candidate for this opportunityThe Mainframe Database Administrator (DBA) leads the planning, analysis, design, implementation, maintenance, and control of the organization's mainframe databases. The Mainframe DBA consults with and advises senior management...


  • Jersey City, New Jersey, United States Della Infotech Full time

    Job Title: Senior SQL Database DeveloperAt Della Infotech, we are seeking a highly skilled Senior SQL Database Developer to join our team.Job Overview:We are looking for a talented individual to develop and maintain efficient, well-documented custom SQL scripts, stored procedures, and triggers using Microsoft T-SQL in accordance with defined business rules...


  • Jefferson City, Missouri, United States Wipro Full time

    Mainframe Database Administrator Job DescriptionWe are seeking a highly skilled Mainframe Database Administrator to join our team at Wipro. As a key member of our IT team, you will be responsible for designing, implementing, and maintaining our mainframe databases.Key Responsibilities:Design and implement highly complex logical and physical databasesLead...