Senior Database Administrator

Found in: Talent US 2 C2 - 1 week 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 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.

Leads the development of standards, processes and procedures (creating KBs, runbooks, topology) and ensuring consistency in operations. 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. Develops operations to ensure optimal performance, availability and scalability of all critical database environments at all times. Develops, tests and implements SQL program code and application code for use with databases. Leads the troubleshooting of any database performance or stability issues. Identifies sub-optimal database architecture, design, or operational practices and leads the execution of projects to address them. 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. Creates monitoring standards and practices to ensure complete visibility of all database operations and supporting infrastructure. 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. Assigns, supervises and reviews work; ensures staff compliance with District policies and procedures including Personnel Rules and Administrative Procedures; completes performance reviews; addresses employee complaints and grievances; may recommend employment actions such as hiring, transfer, suspension, promotion or discharge.

Other Job Functions

Prepares budgetary estimates, contracts and purchase requisitions for goods and services within assigned area of responsibility. Provides training to subordinates. Provides after hours and weekend support when required. 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. Thorough knowledge of database and database server performance tuning. Thorough knowledge of SQL programming on RDBMS platforms. 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. Skill in managing clustered RDBMS systems. Ability to lead technical project teams. Ability to plan and supervise the work of subordinate analysts and administrative staff. 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 six 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

One year of service with the District as a Database Administrator. Civil service status as a Database Administrator.

  • Database Administrator

    Found in: Talent US 2 C2 - 1 week 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...

  • SQL Database Administrator

    Found in: Appcast US C2 - 1 week ago

    Chicago, United States Cook County Treasurer's Office Full time

    Summary:The Cook County Treasurer's Office is seeking a highly skilled and motivated SQL Database Administrator (DBA) to join our team. As a SQL DBA, you will be responsible for ensuring the performance, availability, and security of our SQL Server databases. You will work closely with our development and infrastructure teams to design, implement, and...

  • SQL Database Administrator

    6 days ago

    Chicago, United States Cook County Treasurer's Office Full time

    Summary:The Cook County Treasurer's Office is seeking a highly skilled and motivated SQL Database Administrator (DBA) to join our team. As a SQL DBA, you will be responsible for ensuring the performance, availability, and security of our SQL Server databases. You will work closely with our development and infrastructure teams to design, implement, and...

  • SQL Database Administrator

    Found in: Appcast Linkedin GBL C2 - 2 weeks ago

    Chicago, United States Cook County Treasurer's Office Full time

    Summary:The Cook County Treasurer's Office is seeking a highly skilled and motivated SQL Database Administrator (DBA) to join our team. As a SQL DBA, you will be responsible for ensuring the performance, availability, and security of our SQL Server databases. You will work closely with our development and infrastructure teams to design, implement, and...

  • Sr. SQL Database Administrator

    1 day ago

    Chicago, United States Strategic Resource Partners, Inc. Full time

    Job DescriptionJob DescriptionJoin our team in Los Angeles as a Database Administrator, specializing in SQL. We're looking for someone with a knack for managing diverse database environments like Azure SQL Database, PostgreSQL, MongoDB, and MS SQL Server. Your role will be pivotal in shaping, implementing, and maintaining our organization's database...

  • Enterprise Solutions Database Administrator

    Found in: Appcast US C2 - 2 weeks ago

    Chicago, United States Clarity Partners Full time

    Voted one of Chicago's Best Places to Work by the Chicago Tribune for the seventh year in a row, Clarity Partners is hiring! Clarity Partners is seeking an Enterprise Solutions Database Administrator local to Chicago, IL to design, implement, and optimize database solutions, ensuring security, backup, and integration with software applications while...

  • Enterprise Solutions Database Administrator

    Found in: Appcast Linkedin GBL C2 - 2 weeks ago

    Chicago, United States Clarity Partners Full time

    Voted one of Chicago's Best Places to Work by the Chicago Tribune for the seventh year in a row, Clarity Partners is hiring! Clarity Partners is seeking an Enterprise Solutions Database Administrator local to Chicago, IL to design, implement, and optimize database solutions, ensuring security, backup, and integration with software applications while...

  • Database Analyst

    Found in: Talent US 2 C2 - 1 week 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...

  • Senior Database Architect

    5 days ago

    Chicago, United States cpsk12il Full time

    Description: The Sr. Database Architect will provide specialized DBA support with a focus on Oracle OCI Database and MS SQL Server. This includes all aspects of database administration such as design, generation, coding, and production support. They will utilize the advanced features of Oracle OCI Database and MS SQL Server to optimize database performance...

  • Associate Principal Database Administrator

    Found in: beBee S US - 2 weeks ago

    Chicago, United States Motion Recruitment Full time

    Job Description In this Associate Principal Database Administrator role, you will be a vital contributor to the design, implementation, and support of large-scale databases for one of the largest financial service organizations in the United States! You will be recommending, assisting, and developing new software and upgrades, allowing you to take ownership...

  • Associate Principal Database Administrator

    1 week ago

    Chicago, United States CareerBuilder Full time

    Job Description In this Associate Principal Database Administrator role, you will be a vital contributor to the design, implementation, and support of large-scale databases for one of the largest financial service organizations in the United States! You will be recommending, assisting, and developing new software and upgrades, allowing you to take ownership...

  • Senior Administrative Specialist

    Found in: Talent US 2 C2 - 1 week ago

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

    General Statement Under supervision, performs sub-professional administrative work such as document and records management, data collection and reporting and coordination of internal processes specific to the assigned department or functional area. Essential Job Functions Essential job functions are fundamental, core functions common to...

  • Database Engineer

    Found in: Appcast Linkedin GBL C2 - 3 days ago

    Chicago, United States Optima Global Solutions Inc. Full time

    Optima Global Solutions Inc.is a valuable IT Services and Solution provider that customers, employees, and stakeholders feel proud to be associated with. Optima's Intelligent Automation Solutions leverage robotic process automation, intelligent data capture, and business process management best practices to streamline operations. Our IT Services practice...

  • Senior Systems Administrator

    Found in: Talent US 2 C2 - 1 week ago

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

    General Statement Under direction, supervises and/or is responsible for the implementation of the enterprise architecture and maintenance of the organization’s computing technology environment. This also includes analysis, development, modification, installation, backup, testing and maintenance of operating systems software and storage. Essential...

  • Senior Applications Administrator

    Found in: Talent US 2 C2 - 1 week ago

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

    General Statement Under direction, provides on-going administration, maintenance and support of software applications to ensure the application continues to meet the customer’s needs. Essential Job Functions Essential job functions are fundamental, core functions common to positions in a classification. They are not intended to be an...

  • Senior Mainframe Datacom DBA

    5 days ago

    Chicago, United States Ensono Full time

    Senior Mainframe Datacom DBARemote - United StatesJR010139 **Job Description** **Position Summary** The successful candidate will perform mainframe database software upgrades coupled with administration and tuning to support our customers’ CA Datacom environments. They will be called upon to perform a variety of tasks including database optimization,...

  • Senior IT Security Administrator

    Found in: Talent US 2 C2 - 1 week ago

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

    General Statement Responsible for testing, documenting, evaluating, remediating, and improving internal IT audit controls for effectiveness and operational efficiency. Collaborates with internal and external audit teams, IT management, business units, consultants, and other stakeholders to ensure compliance project deliverables are met. Essential...

  • Senior Financial Systems Administrator

    3 days ago

    Chicago, United States Lewis Brisbois Bisgaard & Smith Full time

    Overview: The Chicago office of Lewis Brisbois is seeking an experienced Senior Financial Systems Administrator provides technical leadership for databases, system integrations, and financial applications across the firm. The Senior Financial Systems Administrator should have subject matter expertise with the Aderant Expert suite and provide overall...

  • Senior Research Administrator

    Found in: beBee jobs US - 2 weeks ago

    Chicago, Illinois, United States Northwestern University Full time

    Job ID50004LocationChicago, IllinoisDepartment: MED-Inst for Pub Health & MedSalary/Grade: EXS/9Job Summary:The Institute for Public Health and Medicine (IPHAM) within Northwestern's Feinberg School of Medicine was founded in 2012 with a vision to achieve the best possible health for all people and is comprised of 18 research centers. IPHAM is recruiting a...

  • Administrative Specialist

    Found in: Talent US 2 C2 - 1 week ago

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

    General Statement Under supervision, performs clerical and administrative work such as composing and/or typing various correspondence, organizing and maintaining paper and electronic files, tracking completion of assignments, performing basic bookkeeping activities, distributing mail and answering phones. Essential Job Functions Essential job...