IT Database Administrator (CYFD/ITD #30348)

State of New Mexico

$75K — $113K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's degree in Computer Science or related field.
  • Five years of experience in database administration.
  • Three years in database development including data migration.
  • Technical expertise in SQL, database design, and cloud technologies.
  • Proficient in complex SQL querying and familiar with PL/SQL, T-SQL, and scripting languages like Python.
  • Experience in managing Azure cloud platforms and migration processes.
  • Strong communication and project management skills.

Responsibilities

  • Design and implement database structures and schemas.
  • Install and configure database servers in Azure SQL Server and Sybase.
  • Manage user accounts and implement security measures for access control.
  • Develop and execute backup and disaster recovery plans.
  • Monitor database performance and optimize queries for efficiency.
  • Perform routine maintenance, patching, and troubleshooting SQL errors.
  • Ensure data integrity and provide training to team members on database skills.

Benefits

  • Comprehensive backup and disaster recovery plans.
  • Opportunity for ongoing recruitment and career growth within the organization.
  • Access to advanced cloud technologies and collaborative work environment.
  • Potential for continuous learning and skill development.
Full Job Description
$36.43 - $54.65 Hourly

$75,775 - $113,663 Annually

This position is a Pay Band C10

Posting Details

THIS POSTING MAY BE USED FOR ONGOING RECRUITMENT AND MAY CLOSE AT ANY TIME. APPLICANTS LISTS MAY BE SCREENED MORE THAN ONCE.

*APPLICATIONS SUBMITTED WITHOUT WORK EXPERIENCE OR A RESUME WILL NOT BE CONSIDERED. IF ATTACHING A RESUME, RESUME MUST INCLUDE DATES OF EMPLOYMENT FOR EACH JOB (MONTH & YEAR) AND DETAILS OF WORK EXPERIENCE/JOB DUTIES*

Why does the job exist?

Install, configure, upgrade, administer, monitor, and maintain operationally efficient databases. Experience and knowledge in administration and in developing new dashboards or report development in the various platforms like Power BI, Power BI Administration , and Cloud databases like Azure Sql Server.
This position will manage, secure, and optimize an organization's data infrastructure and ensure data integrity, performance, and availability, often supporting high-tech innovation and critical system

How does it get done?

Database Design & Implementation: Working with developers to design database structures, tables, and views and Capacity Planning with estimating future storage needs and managing hardware/software resources. Providing technical support to users and developing reports to analyze system usage.
  • Database Installation & Configuration: Setting up, installing, and configuring database servers in Azure Sql Server and Sybase. Also work on database Migration involving moving data from old systems to new systems.
  • Security & Access Control: Managing user accounts, permissions, and implementing security measures to prevent unauthorized access
  • Backup & Recovery: Implementing comprehensive backup and disaster recovery plans to prevent data loss.
  • Performance Monitoring & Tuning: Monitoring database health to ensure high performance, optimizing queries, and resolving bottlenecks. Also, includes monitoring server resource utilization (CPU, memory, disk I/O), scheduling and verifying database backups, updating security patches, optimizing slow-running SQL queries, and testing failover/recovery scenarios.
  • Troubleshooting & Maintenance: Performing regular maintenance tasks like patching, updating anti-virus software, and troubleshooting SQL errors.
  • Data Integrity & Maintenance: Ensuring data consistency and accuracy throughout its lifecycle. The position will support all the tasks in performing this function. The candidate will cross train other team members in this skill as a part of knowledge transfer and cross training the members in the team.


  • Ideal Candidate

    Experience as it relates to:
  • Five (5) or more years in working with database administration.
  • Three (3) or more years in database development skills including data migration and data performance tuning to the database objects.
  • The position requires technical expertise in SQL, database design, and cloud technologies, along with strong problem-solving and communication skills to ensure data integrity, security, and performance. Key competencies include backup/recovery, query optimization, scripting/automation, and familiarity with systems like Azure.
  • Proficient in writing and tuning complex SQL queries, and understanding database languages like PL/SQL, T-SQL, or scripting languages such as Python or PowerShell. Ability to design logical and physical databases, create schemas, and establish data relationships.
  • Technical knowledge of various platforms to ensure applications and infrastructure stacks are current and supported.
  • Technical knowledge and expertise in the server administration and management of server resources. Knowledge of cloud platforms like Azure and managing migration.
  • Experience in working with server admin group and infrastructure team to implement any changes to the servers or in deployment of new software.
  • Experience and knowledge in developing new dashboards or report development in the various platforms like Power BI.
  • Excellent verbal, written, interpersonal, and customer service skills.
  • Project and time management skills with abilities of effectively managing competing priorities


  • Minimum Qualification

    Bachelor's degree in Computer Science, Management Information Systems (MIS), Information Technology, Engineering, or similar technical degree and two (2) years of experience in data analysis, design, storage, and security. Any combination of education from an accredited college or university in a related field and/or direct experience in this occupation totaling six (6) years may substitute for the required education and experience.

    Employment Requirements

    Must possess and maintain a valid Driver's License. Pre-employment background investigation is required and is conditional pending results.

    Working Conditions

    Work is performed in an office setting with exposure to Visual/Video Display Terminal (VDT) and extensive personal computer and phone usage. Some sitting, standing, bending, lifting and reaching may be required. Ability to complete assignments with a high level of accuracy within strict time constraints. Frequent use of office machine and equipment. Must be able to lift 25-30 lbs.
    Occasional travel may be required. Occasionally work extra hours on weekdays, weekends and holidays

    Supplemental Information

    Do you know what Total Compensation is? Click here

    Agency Contact Information: Sujatha Seethapathi, 505-660-1749. Email

    For information on Statutory Requirements for this position, click the Classification Description link on the job advertisement.

    Bargaining Unit Position

    This position is covered by a collective bargaining agreement and all terms/conditions of that agreement apply and must be adhered to.

    Similar Jobs

    More Jobs at State of New Mexico

    More Information Technology Jobs

    Find similar IT Database Administrator (CYFD/ITD #30348) jobs: