Database Administrator

7 months ago

Chicago, United States Metropolitan Water Reclamation District of Greater Chicago Full time

General Statement

Under direction, designs, implements, administers and maintains the District’s relational database systems that support the functional requirements of the application systems used by the operating departments; and develops, implements, and oversees database policies and procedures to ensure the integrity and availability of databases and their accompanying software.

Essential Job Functions

Essential job functions are fundamental, core functions common to positions in a classification. They are not intended to be an exhaustive list of all job duties for any one position in the class. Since class specifications are designed to be descriptive and not restrictive, incumbents may complete one or all of the job duties listed or tasks of similar kind not specifically listed here. Evaluates user requests for development of new databases or modifications to existing databases; determines the scope of work and timeline for projects; serves as the technical lead on more complex projects. Assesses and develops long-term strategic goals for production databases in conjunction with data owners and department managers. Leads the design and development of new databases; assists with the installation and testing of new databases. Modifies existing databases and database management systems; tests programs or databases and corrects errors; performs system upgrades as needed. Develops, tests and implements SQL program code and application code for use with databases. Defines, reviews and implements database backup and recovery strategies. Plans, coordinates and implements appropriate security, indexes, access controls, constraints, triggers and other database-related features to safeguard database against accidental or unauthorized damage, modification or disclosure. Monitors performance of application programs with respect to associated databases and performs required performance tuning actions to ensure database stability and efficiency. Recommends changes to data storage practices to optimize efficient use of space and prevent unnecessary database growth. Provides technical support to other analysts and technical staff related to database design and administration; troubleshoots more complex database issues. Works with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures. Designs and implements redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets. Performs database transaction and security audits. Creates, or supports creation of, required reports in response to business user needs. Provides support for standard business analysis tools such as Microsoft Power BI. Provides support to analysts in day-to-day activities including the review of work products for accuracy.

Other Job Functions

Performs other duties as assigned.

Environmental Conditions

Work is performed in a typical office environment and requires the use of standard office equipment including computers.

Desirable Knowledge, Skills and Abilities

Thorough knowledge of the principles, procedures and methodologies relating to database design, control, administration and usage in support of application systems. Thorough knowledge of data processing flowcharting techniques and entity relationship diagrams. Knowledge of the operating characteristics and limitations of common computer hardware and software utilized by the District. Knowledge of applicable data privacy practices and laws. Knowledge of data analytics practices and concepts. Skill in writing SQL scripts for queries. Ability to troubleshoot and resolve operational issues related to databases. Ability to communicate effectively, orally and in writing.

Minimum Qualification Requirements

Graduation from a four-year accredited college or university majoring in information technology, computer science or a closely related field and four years of experience in database development and/or administration.

Substitution

Graduate study in computer science or a closely related field may be substituted for the required experience on a year-for-year basis to a maximum of two years. Full-time paid experience in database development and/or administration may be substituted for the required education on a year-for-year basis. A Microsoft MCITP SQL Server certification may be substituted for one year of the required education or experience.

Promotional Requirement

Two years of service with the District as a Database Analyst or an IT Support Coordinator. Civil service status in one of the foregoing classifications.

  • Database Administrator

    4 weeks ago

    Chicago, Illinois, United States Diverse Lynx Full time

    Job Summary:We are seeking a highly skilled Database Administrator to join our team at Diverse Lynx LLC. The successful candidate will be responsible for managing and administering Snowflake databases and warehouses for multiple environments, ensuring high performance, availability, and security.Key Responsibilities:Implement and maintain database security...

  • Senior Database Administrator

    7 months ago

    Chicago, United States Metropolitan Water Reclamation District of Greater Chicago Full time

    General Statement Under direction, leads the design, implementation, administration and maintenance of the District’s relational database systems that support the functional requirements of application systems used by the operating departments. This classification is also responsible for developing, implementing, and overseeing database policies and...

  • Database Administrator

    4 weeks ago

    Chicago, United States e.biT Consulting Full time

    Job SummaryWe are seeking an experienced Database Administrator with a minimum of 5 years in database management and expertise in MS SQL Server, database maintenance and monitoring, Azure functions, and Python development. The ideal candidate will bring finance industry experience, ensuring data integrity, performance, and security across complex financial...

  • Database Administrator

    4 weeks ago

    chicago, United States e.biT Consulting Full time

    Job SummaryWe are seeking an experienced Database Administrator with a minimum of 5 years in database management and expertise in MS SQL Server, database maintenance and monitoring, Azure functions, and Python development. The ideal candidate will bring finance industry experience, ensuring data integrity, performance, and security across complex financial...

  • Database Administrator

    4 weeks ago

    chicago, United States e.biT Consulting Full time

    Job SummaryWe are seeking an experienced Database Administrator with a minimum of 5 years in database management and expertise in MS SQL Server, database maintenance and monitoring, Azure functions, and Python development. The ideal candidate will bring finance industry experience, ensuring data integrity, performance, and security across complex financial...

  • Database Administrator

    4 weeks ago

    Chicago, United States System Sof Full time

    5+ Years of Database AdministrationMonitoring UNIX server alertsInstalling, configuring, and maintaining Linux operating systems, server hardware, and UNIX systemsIdentifying and correcting issues, risks, and other problems in a timely mannerFollowing organizational policies and standards

  • Database Administrator

    4 weeks ago

    chicago, United States System Sof Full time

    5+ Years of Database AdministrationMonitoring UNIX server alertsInstalling, configuring, and maintaining Linux operating systems, server hardware, and UNIX systemsIdentifying and correcting issues, risks, and other problems in a timely mannerFollowing organizational policies and standards

  • Database Administrator V

    4 weeks ago

    Chicago, Illinois, United States Saxon Global Full time

    About the Role:The Saxon Global team is seeking an experienced AWS Redshift Database Administrator to help with data-warehouse workload migration into AWS Redshift. The chosen individual will have extensive hands-on experience with database administration, query tuning, and cloud architecture.Responsibilities:Optimize and tune the Redshift environment,...

  • SQL Database Administrator

    4 weeks ago

    Chicago, United States System Sof Full time

    Working closely with IT to support physical database administration including performance management, security, installations, upgrades, patches, backup, recovery, space management, performance tuning and capacity planningEnsure that all databases environments are deployed, maintained and managed via proactive monitoring of performance and capacity planning...

  • SQL Database Administrator

    4 weeks ago

    chicago, United States System Sof Full time

    Working closely with IT to support physical database administration including performance management, security, installations, upgrades, patches, backup, recovery, space management, performance tuning and capacity planningEnsure that all databases environments are deployed, maintained and managed via proactive monitoring of performance and capacity planning...

  • Postgres Database Administrator

    1 month ago

    Chicago, Illinois, United States Diverse Lynx Full time

    Job Title: Postgres DBAJob Summary: We are seeking a highly skilled Postgres DBA to join our team at Diverse Lynx LLC. As a Postgres DBA, you will be responsible for ensuring the optimal performance and reliability of our PostgreSQL databases.Key Responsibilities:Work with development teams to troubleshoot and resolve performance-related issuesMigrate...

  • Senior Database Administrator

    2 months ago

    Chicago, United States Northwestern Memorial Healthcare Full time

    Job DescriptionThe Senior Database Administrator, reflects the mission, vision, and values of NM, adheres to the organization’s Code of Ethics and Corporate Compliance Program, and complies with all relevant policies, procedures, guidelines and all other regulatory and accreditation standards.The Senior Database Administrator is responsible for keeping the...

  • SQL Database Administrator

    3 weeks ago

    chicago, United States System Soft Technologies Full time

    An SQL Server Database Administrator (DBA) manages SQL Server data systems and structures. They use SQL procedures and software applications to store, organize, and protect data. DBAs also ensure that users can access information easily and that data is secure from unauthorized access.Here are some responsibilities of an SQL DBA:Installing and...

  • SQL Database Administrator

    3 weeks ago

    Chicago, United States System Soft Technologies Full time

    An SQL Server Database Administrator (DBA) manages SQL Server data systems and structures. They use SQL procedures and software applications to store, organize, and protect data. DBAs also ensure that users can access information easily and that data is secure from unauthorized access.Here are some responsibilities of an SQL DBA:Installing and...

  • SQL Database Administrator

    3 weeks ago

    chicago, United States System Soft Technologies Full time

    An SQL Server Database Administrator (DBA) manages SQL Server data systems and structures. They use SQL procedures and software applications to store, organize, and protect data. DBAs also ensure that users can access information easily and that data is secure from unauthorized access.Here are some responsibilities of an SQL DBA:Installing and...

  • SQL Database Administrator

    3 weeks ago

    Chicago, IL, United States System Sof Full time

    Working closely with IT to support physical database administration including performance management, security, installations, upgrades, patches, backup, recovery, space management, performance tuning and capacity planningEnsure that all databases environments are deployed, maintained and managed via proactive monitoring of performance and capacity planning...

  • Senior Database Administrator

    1 month ago

    Chicago, Illinois, United States Barrow Wise Consulting, LLC Full time

    Job Title: Senior Database Administrator - Oracle EBS ApplicationsAre you a problem-solver with a passion for creativity and emerging technologies? Do you have a strong background in database administration and a desire to lead a team of experts? If so, we have an exciting opportunity for you at Barrow Wise Consulting, LLC.Job Summary:We are seeking a highly...

  • SQL Database Administrator

    3 weeks ago

    Chicago, IL, United States System Soft Technologies Full time

    An SQL Server Database Administrator (DBA) manages SQL Server data systems and structures. They use SQL procedures and software applications to store, organize, and protect data. DBAs also ensure that users can access information easily and that data is secure from unauthorized access.Here are some responsibilities of an SQL DBA:Installing and...

  • Database Analyst

    7 months ago

    Chicago, United States Metropolitan Water Reclamation District of Greater Chicago Full time

    General Statement Under supervision, directs, evaluates, reviews, and manages database resources and services across the District while ensuring high levels of data quality; and develops, implements, and oversees database policies and procedures to ensure the integrity and availability of databases and their accompanying software. Essential Job...

  • Database Architect

    4 weeks ago

    Chicago, Illinois, United States Northwestern Memorial Healthcare Full time

    About the Role:The Senior Database Administrator position at Northwestern Medicine is a critical part of our IT infrastructure. As a key member of our team, you will be responsible for ensuring the optimal performance and availability of our databases.Key Responsibilities:Maintains databases in various areas, ensuring optimal performance and data...