- 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.
- Performs other duties as assigned.
- 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.
- 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
23 hours ago
Saxon Global Chicago, United StatesOpportunity 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. ...
-
Database Administrator
23 hours ago
Performix Business Services LLC Chicago, United StatesJob 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 ...
-
Database Administrator
3 weeks ago
Patterned Learning AI Chicago, United StatesJob Description · Database Administrator - Remote Job, 1+ Year Experience · Annual Income: $60K - $65K, Onsite · A valid work permit is necessary in the US/Canada · About us: Patterned Learning is a platform that aims to help developers code faster and more efficiently. It of ...
-
Senior Database Administrator
3 weeks ago
Metropolitan Water Reclamation District of Greater Chicago Chicago, United StatesGeneral 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 resp ...
-
Senior Database Administrator
1 week ago
CIBC Chicago, United StatesWe'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 ...
-
Junior Database Administrator
1 week ago
SDI Presence LLC Chicago, United StatesCompany · 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 ...
-
Database Administrator V
1 week ago
Saxon Global Chicago, United StatesJob 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 ...
-
Database Administrator
2 weeks ago
Request Technology, LLC Chicago, United StatesNO SPONSORSHIP · Associate Principal, Database Administration - DB2 / LUW · SALARY: $125K - $155K PLUS 15% BONUS · LOCATION: CHICAGO, IL · HYBRID 3 DAYS ONSITE AND 2 DAYS REMOTE · Looking for a candidate with 7 years db2 LUW on Red Hat linux and windows. 7 years postgre SQL SQL s ...
-
Database Administrator
3 weeks ago
The University of Chicago Chicago, United StatesThis 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 and tr ...
-
Database Administrator
3 weeks ago
RIVET OPERATIONS COMPANY LLC Chicago, United StatesJOB DESCRIPTION · Position Title: Database Administrator · Location: 80% Remote, 20% Chicago, IL · Introduction: · Rivet Operations Company ("Rivet") has an opening for a Database Administrator. This position will be in support of the U.S Railroad Retirement Board (RRB) provi ...
-
Database Administrator
2 weeks ago
Rivet Operations Company Llc Chicago, United StatesJOB DESCRIPTION · Before applying for this role, please read the following information about this opportunity found below. · Position Title: Database Administrator · Location: 80% Remote, 20% Chicago, IL · Introduction: · Rivet Operations Company ("Rivet") has an opening for a ...
-
Senior Database Administrator
3 days ago
iManage Chicago, United StatesJob 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 ...
-
Database Administrator
3 days ago
Alliant Credit Union Chicago, United StatesIn 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 ...
-
Associate Principal, Database Administration
2 weeks ago
The Options Clearing Corporation Chicago, United StatesWhat You'll Do: · This role will design and maintain databases and database solutions that operate within prescribed resource limits and meet company standards. Participate in and contribute to all phases of systems development projects. Monitor and tune database and database ap ...
-
Associate Principal, Database Administration
1 week ago
OCC Chicago, United States Full timeWhat You'll Do: · This role will design and maintain databases and database solutions that operate within prescribed resource limits and meet company standards. Participate in and contribute to all phases of systems development projects. Monitor and tune database and database ap ...
-
Database Administrator
1 week ago
The University of Chicago Chicago, United StatesDepartment · 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 and translational research, education, and patient care come togeth ...
-
Database Administrator
3 weeks ago
Belvedere Trading Chicago, United States Full timeBelvedere is looking for someone passionate about monitoring, maintaining, and providing operational support of our entire database platform. You will improve the performance and efficiency of our data storage and access systems that deliver the high-quality and reliable data tha ...
-
Database Administrator
1 week ago
Performix Chicago, United StatesJob 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. · Optimize database systems for ...
-
Database Administrator
3 weeks ago
Na Oiwi Kane Chicago, United States**JOB DESCRIPTION** · **Position Title**:Database Administrator · **Location**:80% Remote, 20% Chicago, IL · **Introduction**: · Rivet Operations Company ("Rivet") has an opening for a Database Administrator. This position will be in support of the U.S Railroad Retirement Board ( ...
-
Database Administrator
2 weeks ago
Belvedere Trading Chicago, United States Full timeBelvedere Trading is a leading proprietary trading firm proudly headquartered in downtown Chicago. Our traders work hard to provide liquidity to the market through their market-making activities and are the masters of a diverse set of commodities, interest rates, exchange-traded ...
Database Administrator - Chicago, United States - Metropolitan Water Reclamation District of Greater Chicago
Description
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.Other Job Functions
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
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