Jobs
>
Chicago

    Senior Database Administrator - Chicago, United States - Metropolitan Water Reclamation District of Greater Chicago

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

    1 week ago

    Default job background
    Description

    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.
  • Metropolitan Water Reclamation District of Greater Chicago

    Database Administrator

    1 week ago

    Metropolitan Water Reclamation District of Greater Chicago Chicago, United States

    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 p ...

  • Saxon Global

    Database Administrator

    2 weeks ago

    Saxon Global Chicago, United States

    Opportunity for a Database Administrator. Here are the details: · Position: Database Administrator · Location: Remote; Ideally hybrid onsite in Boston, MA · Duration: 6+ Months · Overview: · Creates and maintains databases for test, development and production environments. ...

  • Performix Business Services LLC

    Database Administrator

    2 weeks ago

    Performix Business Services LLC Chicago, United States

    Job Description · Job Description: · Database Engineers administer, test, and implement databases, applying knowledge of database management systems. · Database Engineer Responsibilities and Duties: · Assist in design and development of distributed database systems. · Optimi ...

  • KYYBA

    Database Administrator

    2 weeks ago

    KYYBA North Chicago, United States

    Job Description · Job DescriptionJob Title: Database Administrator (Onboarding/Administrative Assistant III) · Contract: 6 months with potential to extend · Pay Range: $25-$27 · Work Location: North Chicago, IL (Hybrid; 2 days onsite, 3 days remote) · Job Description: · Role, at ...

  • The University of Chicago

    Database Administrator

    1 week ago

    The University of Chicago Chicago, United States

    This job was posted by : For more information, please see: Department · BSD BIS - Business Intelligence Services · About the Department · About the Department · The University of Chicago Biological Sciences Division (BSD) contains all elements of academic medicine. Basic an ...

  • Hinshaw & Culbertson

    Senior Database Administrator

    2 weeks ago

    Hinshaw & Culbertson Chicago, United States Full time

    SENIOR DATABASE ADMINISTRATOR · Location: Flexible and in any state where the firm has an office. · Hinshaw & Culbertson LLP, a national law firm, currently has an excellent full-time employment opportunity for a Senior Database Administrator. We offer competitive compensation a ...

  • The LaSalle Group

    SQL Database Administrator

    5 days ago

    The LaSalle Group Chicago, United States

    Want to grow your career with one of the fastest growing industries? LaSalle Network is partnered with a top Chicago-based client looking to hire a SQL Database Administrator their team. · The SQL Database Administrator will be responsible for maintenance and support of the SQL S ...

  • CIBC

    Senior Database Administrator

    3 weeks ago

    CIBC Chicago, United States

    We're building a · relationship-oriented · bank for the modern world. We need talented, passionate professionals who are dedicated to doing what's right for our clients. · At CIBC, we embrace your strengths and your ambitions, so you are empowered at work. Our team members have ...

  • Saxon Global

    Database Administrator V

    3 weeks ago

    Saxon Global Chicago, United States

    Job Title: AWS Redshift DBA · Work Location: Required to be onsite 2 days a week · Travel Expenses: Can't Pay Travel Expenses at this time · United Airlines is seeking for an AWS Redshift DBA who will help with our dataware house workload migration into AWS Redshift. This indi ...

  • Uline

    Senior Database Administrator

    1 week ago

    Uline Chicago, United States

    Senior Database Administrator · Corporate Headquarters · 12575 Uline Drive, Pleasant Prairie, WI 53158 · Are you a project leader? Do you enjoy mentoring others? Then you belong at Uline As a Senior Database Administrator, support database solutions for North America's top distr ...

  • iManage

    Senior Database Administrator

    1 week ago

    iManage Chicago, United States

    We offer a flexible working policy that supports the health and well-being of our iManage employees. As an organization, we value collaborating and learning from our peers in person, while providing the necessary flexibility for our employees to have a meaningful work-life balanc ...

  • SDI Presence LLC

    Junior Database Administrator

    3 weeks ago

    SDI Presence LLC Chicago, United States

    Company · SDI Presence LLC is an IT consultancy and managed services provider (MSP) that leverages its strong team presence to advance our clients to a secure digital enterprise. With a 25-year corporate resume, SDI delivers strategic managed services, IT consulting, and hybrid ...

  • CIBC

    Senior Database Administrator

    1 week ago

    CIBC Chicago, United States

    Were building a relationship-oriented bank for the modern world. We need talented, passionate professionals who are dedicated to doing whats right for our clients. · At CIBC, we embrace your strengths and your ambitions, so you are empowered at work. Our team members have what t ...

  • Komatsu

    SQL Database Administrator

    1 week ago

    Komatsu Chicago, United States

    Komatsu is an indispensable partner to the construction, mining, forestry, forklift, and industrial machinery markets, maximizing value for customers through innovative solutions. With a diverse line of products supported by our advanced IoT technologies, regional distribution ch ...

  • Insight Global

    SQL Database Administrator

    1 week ago

    Insight Global Chicago, United States

    You will be responsible for setting up database environments, deployment, migration, implementation, and administration of databases and support of all database environments and related applications on on-prem and Azure SQL Databases. Performs performance monitoring, security, tr ...

  • Archdiocese of Chicago

    Director of Database Administration

    2 days ago

    Archdiocese of Chicago Chicago, United States

    Opportunities at other Organizations / Parishes / Dioceses, not with the Archdioceseof Chicago · National Religious Vocation Conference · 5416 S Cornell Avenue · Chicago, Illinois60615 · Description: · GENERAL SUMMARYTo serve our members and fulfill the mission of the Nation ...

  • Canadian Imperial Bank of Commerce

    Senior Database Administrator

    1 week ago

    Canadian Imperial Bank of Commerce Chicago, United States

    Senior Database Administrator page is loaded · Senior Database Administrator · Apply · locations · Chicago, IL · time type · Full time · posted on · Posted Yesterday · job requisition id · We're building a · relationship-oriented · bank for the modern world. We need t ...

  • iManage

    Senior Database Administrator

    2 weeks ago

    iManage Chicago, United States

    Job Description · Job DescriptionWe offer a flexible working policy that supports the health and well-being of our iManage employees. As an organization, we value collaborating and learning from our peers in person, while providing the necessary flexibility for our employees to h ...

  • Komatsu

    SQL Database Administrator

    1 week ago

    Komatsu Chicago, United States

    Komatsu is an indispensable partner to the construction, mining, forestry, forklift, and industrial machinery markets, maximizing value for customers through innovative solutions. With a diverse line of products supported by our advanced IoT technologies, regional distribution ch ...

  • Alliant Credit Union

    Database Administrator

    2 weeks ago

    Alliant Credit Union Chicago, United States

    In this role, you will be responsible for administering the SQL Server Databases. Troubleshoot database issues and develop recovery procedures by following the DBA functions and architectures and credit union policy and procedures. · ResponsibilitiesSupport Microsoft SQL databas ...