Database Administrator
1 month ago
Primary Duties and Responsibilities: To perform this job successfully, an individual must be able to perform each primary duty satisfactorily.
- Design, Implement, and Maintain PostgreSQL and DB2 Databases: Lead efforts in designing, implementing, and maintaining robust PostgreSQL and DB2 database systems, ensuring optimal performance and reliability.
- Database Performance Management: Proactively manage and optimize PostgreSQL and DB2 performance, including tuning queries, managing disk usage, and ensuring high availability.
- Database Access Support: Provide expert support in database access methods, particularly for PostgreSQL and DB2, ensuring secure and efficient data retrieval.
- Consultation and Problem Resolution: Offer specialized consultation in database analysis, modeling, coding, and production problem resolution, with a focus on PostgreSQL and DB2 environments.
- Backup, Recovery, and Maintenance: Develop and document comprehensive maintenance, backup, and recovery procedures for PostgreSQL and DB2 databases, ensuring data integrity and availability.
- Disaster Recovery Participation: Actively participate in Disaster Recovery drills, ensuring PostgreSQL and DB2 databases are included in recovery plans and tests.
- Primary On-Call Support: Serve as the primary on-call support for PostgreSQL and DB2 production issues, ensuring timely resolution of critical database problems.
- Corporate Data Standards Support: Understand and enforce corporate data standards, particularly in PostgreSQL and DB2 implementations.
- DBMS Standards and Evaluation: Recommend and assist with the implementation of new DBMS technologies, with a particular emphasis on PostgreSQL and DB2 standards and operational best practices.
- Software Testing and Evaluation: Participate in testing and evaluating new PostgreSQL and DB2 software versions and release upgrades to ensure seamless integration and performance.
- Support Business Initiatives: Provide expert support to business studies, proposal teams, and costing/feasibility studies with a focus on leveraging PostgreSQL and DB2 capabilities.
- System Documentation: Prepare and maintain detailed system documentation for PostgreSQL and DB2 environments.
- Metadata Management: Maintain and manage metadata repositories, ensuring accurate and up-to-date data models for PostgreSQL and DB2 systems.
- Other duties as assigned.
Qualifications: The requirements listed are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the primary functions.
- [Required] 3+ years' experience with PostgreSQL and DB2 LUW: Extensive hands-on experience managing, tuning, and troubleshooting PostgreSQL and DB2 databases, preferably in a Red Hat Linux environment.
- [Required] Expertise in Database Development: Proficient in developing and maintaining complex applications that heavily utilize PostgreSQL and DB2 databases.
- [Required] Strong SQL and Database Utility Skills: Proficient in SQL, stored procedures, triggers, and database utilities specifically for PostgreSQL and DB2.
- [Required] Systems Analysis and Design: Well-versed in all phases of Systems Analysis and Design, with a focus on database-driven applications using PostgreSQL and DB2.
- [Required] Database Modeling: Practiced in Entity/Relationship and Object modeling, with the ability to translate models into physical PostgreSQL and DB2 database designs.
- [Required] Knowledge of Operating Systems and Access Methods: Proficient in all access methods of PostgreSQL and DB2, including a deep understanding of the underlying operating system access methods.
- [Required] Understanding of Software Subsystems: Comprehensive understanding of software subsystems (DBMS, TP Managers, etc.) within a PostgreSQL and DB2 environment.
- [Required] Initiative and Ownership: Demonstrates strong initiative, ownership, and a proactive approach to managing PostgreSQL and DB2 databases.
- [Required] Sense of Urgency: Maintains a strong sense of urgency in managing PostgreSQL and DB2 systems, ensuring critical issues are addressed promptly.
- [Required] Communication and Mentorship: Communicates openly and effectively, with a willingness to mentor others in PostgreSQL and DB2 database management.
Technical Skills:
- [Required] 3+ years' experience with PostgreSQL and DB2 LUW: Proven track record of managing PostgreSQL and DB2 databases, particularly in a Linux environment.
- [Required] SQL and Stored Procedure Proficiency: Skilled in writing and reviewing SQL, stored procedures, and triggers for PostgreSQL and DB2 databases.
- [Preferred] 1+ year' Terraform, Ansible, Jenkins & CI/CD skills.
- [Preferred] 1+ years' EDB Postgres & EDB Postgres Distributed experience.
- [Preferred] Basic Java, Perl & Linux Shell script skills.
- [Preferred] 1+ years' experience with SQL Server, DB2 on z/OS, and MySQL/MariaDB.
- [Preferred] Experience with BMC tools for DB2 (Change/Catalog Manager, MainView, Log Master).
- [Preferred] Basic JCL & REXX script skills.
Education and/or Experience:
- [Required] Bachelor's degree (or equivalent) in Computer Science, Engineering, Mathematics, or Business.
- [Preferred] Related financial industry experience.
Certificates or Licenses:
- [Preferred] PostgreSQL Professional Certification.
- [Preferred] IBM Certified Database Administrator - DB2 for Linux UNIX and Windows.
-
Database Administrator
3 weeks ago
Chicago, United States Stash Talent Services Full timeRole: Snowflake AdministratorLocation: Chicago, IL (Hybrid)Duration: 12 months contractJob DescriptionDatabase Administration and ManagementManage and administer Snowflake databases and warehouses for multiple environments, ensuring high performance, availability, and security.Implement and maintain database security by creating roles, users, and managing...
-
Database Administrator
2 months ago
Chicago, United States O'Reilly Auto Parts Full timeA Database Administrator I, is responsible for the performance, integrity and security of the databases to support the computing environment. Under direct supervision, a Database Administrator I will work through day-to-day operational tasks related to the database systems.The salary for this role is from 105k to 130k, most offers however will be around the...
-
Database Administrator
5 months ago
Chicago, United States Metropolitan Water Reclamation District of Greater Chicago Full timeGeneral 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...
-
Database Administrator
3 weeks ago
Chicago, United States NinjaTrader Full timeJob DescriptionJob DescriptionNinjaTrader is an investor-backed, growth-stage fintech company with an award-winning platform and over 1.5 million users. We are building products and services that empower active traders to easily analyze and react to data from the world's leading financial markets. Located in Chicago, our unique employee-centric company...
-
Database Administrator
2 months ago
Chicago, United States NinjaTrader Full timeJob DescriptionJob DescriptionNinjaTrader is an investor-backed, growth-stage fintech company with an award-winning platform and over 1.5 million users. We are building products and services that empower active traders to easily analyze and react to data from the world's leading financial markets. Located in Chicago, our unique employee-centric company...
-
Database Administrator
3 months ago
Chicago, Illinois, United States NinjaTrader Full timeNinjaTrader is an investor-backed, growth-stage fintech company with an award-winning platform and over 1.5 million users. We are building products and services that empower active traders to easily analyze and react to data from the world's leading financial markets. Located in Chicago, our unique employee-centric company culture is one that our team finds...
-
Database Administrator
2 months ago
Chicago, United States NinjaTrader Full timeNinjaTrader is an investor-backed, growth-stage fintech company with an award-winning platform and over 1.5 million users. We are building products and services that empower active traders to easily analyze and react to data from the world's leading financial markets. Located in Chicago, our unique employee-centric company culture is one that our team...
-
Database Administrator
4 weeks ago
Chicago, United States Taft Stettinius & Hollister LLP Full timeTaft is currently seeking a Database Administrator to join the Information Technology team in our Chicago, Cincinnati, Cleveland, Columbus, Dayton, Detroit, Indianapolis or Minneapolis office. Responsible for the management and maintenance of firm databases ensuring that all are functional at all times. Provides support, maintenance and implementation and...
-
Database Administrator
4 weeks ago
Chicago, Illinois, United States Taft Stettinius & Hollister LLP Full timeTaft is currently seeking a Database Administrator to join the Information Technology team in our Chicago, Cincinnati, Cleveland, Columbus, Dayton, Detroit, Indianapolis or Minneapolis office.Responsible for the management and maintenance of firm databases ensuring that all are functional at all times. Provides support, maintenance and implementation and...
-
Database Administrator
3 weeks ago
Chicago, United States NinjaTrader Full timeJob DescriptionJob DescriptionNinjaTrader is an investor-backed, growth-stage fintech company with an award-winning platform and over 1.5 million users. We are building products and services that empower active traders to easily analyze and react to data from the world's leading financial markets. Located in Chicago, our unique employee-centric company...
-
Senior Database Administrator
5 months ago
Chicago, United States Metropolitan Water Reclamation District of Greater Chicago Full timeGeneral 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...
-
DB2 Database Administrator
2 weeks ago
Chicago, United States LaSalle Network Full timeLaSalle Network is partnering with a global client to help identify a DB2 Database Administrator to join their team. The DB2 Database Administrator (DBA) will be responsible for the installation, configuration, maintenance and performance tuning of DB2 LUW databases. This role involves ensuring database availability, implementing backup and recovery...
-
Database Administrator
2 weeks ago
Chicago, United States NinjaTrader Full timeJob DescriptionJob DescriptionJOIN US ON OUR MISSION TO BECOME THE #1 RETAIL TRADING PLATFORM IN THE WORLDWelcome to the dynamic world of NinjaTrader! As an industry-leading trading platform and futures broker, we're on a mission to empower traders to take control of their financial destiny. How do we do it? We provide cutting-edge products and services...
-
Database Systems Administrator
1 day ago
Chicago, Illinois, United States Metropolitan Water Reclamation District of Greater Chicago Full timeJob SummaryThe Metropolitan Water Reclamation District of Greater Chicago is seeking a highly skilled Database Systems Administrator to join our team. As a key member of our IT department, you will be responsible for designing, implementing, and maintaining our relational database systems to support the functional requirements of our application systems.Key...
-
SQL Database Administrator
1 week ago
Chicago, United States Stardom Employment Consultants Full timeAbout the job SQL Database Administrator Job Description: As a SQL Database Administrator, you will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server systems. Your primary role is to ensure the availability and consistent performance of various corporate applications. You will also be responsible for...
-
Oracle Database Administrator
2 weeks ago
Chicago, United States MyCareersFuture Full timeRoles & Responsibilities Role Description This role is responsible to provide support in migrating, upgrading, configuring, troubleshooting and administering the Database Platforms in non-Production and Production environments. The incumbent also needs to ensure the platform adherence to IT compliance requirements. Job Responsibilities Create new...
-
Database Systems Administrator
4 days ago
Chicago, Illinois, United States Selby Jennings Full timeJob SummarySelby Jennings is seeking a highly skilled Database Systems Administrator to join our team. As a key member of our database team, you will be responsible for designing, implementing, and maintaining a high-availability MySQL database environment.Key ResponsibilitiesDevelop and maintain a clustered, highly-available MySQL database environment to...
-
Senior Database Administrator
1 month ago
Chicago, United States Brooksource Full timePostgreSQL Database Administrator6-Month Contract-to-HireRichardson, TX OR Chicago, ILOur Fortune 500 health insurance client is hiring a PostgreSQL DBA to support their Claims Modernization effort. In this role, you will be responsible for migrating their applications to PostgreSQL to enhance their claims processing capabilities by improving operational...
-
MySQL Database Administrator
2 weeks ago
Chicago, United States Venture Search Full timeMySQL DBAChicago or Remote (For US Citizens Only)Our client, a top-tier proprietary trading firm is currently looking to hire a MySQL Database Administrator to expand their DBA team; this role can be located out of their Chicago office or be remote.Currently, they are going through an exciting revamp and our in the process of a new database buildout, so this...
-
MySQL Database Administrator
2 weeks ago
Chicago, United States Venture Search Full timeMySQL DBAChicago or Remote (For US Citizens Only)Our client, a top-tier proprietary trading firm is currently looking to hire a MySQL Database Administrator to expand their DBA team; this role can be located out of their Chicago office or be remote.Currently, they are going through an exciting revamp and our in the process of a new database buildout, so this...