Database Administrator with Postgres Experience

4 days ago


Chicago, Illinois, United States Request Technology, LLC Full time
About the Role

We are seeking a highly skilled Database Administrator with expertise in Postgres and DB2 LUW to join our team at Request Technology, LLC. As a key member of our database team, you will be responsible for designing and maintaining databases and database solutions that meet our company's standards.

Key Responsibilities
  • Database Design and Maintenance: Assist in the design, implementation, and maintenance of databases to ensure optimal performance and data integrity.
  • Performance Tuning: Monitor and tune database and database application performance to ensure efficient use of resources.
  • Database Support: Provide support in database access methods, including SQL, stored procedures, and triggers.
  • Consultation and Analysis: Provide consultation support in database analysis, modeling, coding, and production problem resolution.
  • Documentation and Procedures: Develop and maintain maintenance, backup, and recovery procedures and documentation.
  • Disaster Recovery: Participate in Disaster Recovery drills and ensure business continuity.
  • On-Call Support: Provide primary on-call support for production problems and ensure timely resolution.
  • Corporate Data Standards: Understand and support corporate data standards and recommend improvements.
  • Testing and Evaluations: Participate in testing and evaluations of new software and software release upgrades.
  • Business Studies and Proposals: Support business studies, proposal teams, and costing/feasibility studies.
  • System Documentation: Prepare system documentation and maintain metadata repositories.
Requirements
  • Experience: 3+ years' experience developing and maintaining complex applications that make extensive use of a supported database technology or 3+ years' experience as an associate DBA.
  • Systems Analysis and Design: Well-versed in all phases of Systems Analysis and Design.
  • Programming Languages: Experienced in two or more programming languages and two or more scripting languages.
  • Database Modeling: Practiced at Entity/Relationship or Object modeling and translation to physical database designs.
  • Database Utilities: Proficient in DML, DDL, and database utilities for at least two DBMS technologies.
  • Access Methods: Proficient in all access methods of a DBMS as well as the underlying operating system access methods.
  • Hardware and Operating System: Knowledge of hardware and operating system capabilities within one environment.
  • Software Subsystems: Understanding of all software subsystems (DBMS, TP Managers, etc.) for one environment.
  • Initiative and Ownership: Accepts ownership in assignments, team, and company and takes initiative outside immediate area of responsibility.
  • Speed and Urgency: Contributes additional effort when necessary to get the job done and to help others meet their objectives.
  • Communication and Teamwork: Communicates openly and effectively, challenges established practices appropriately, and maintains composure under pressure.
Preferred Qualifications
  • Postgres Experience: 7+ years' experience with PostgreSQL.
  • DB2 LUW Experience: 7+ years' experience with DB2 LUW; preferably on Red Hat Linux.
  • Coding and Review: Proficient with coding and review of SQL, stored procedures, and triggers.
  • Terraform, Ansible, and Jenkins: 1+ year' experience with Terraform, Ansible, and Jenkins & CI/CD skills.
  • EDB Postgres and EDB Postgres Distributed: 1+ years' experience with EDB Postgres & EDB Postgres Distributed.
  • Basic Java, Perl, and Linux Shell Script: Basic Java, Perl, and Linux Shell script skills.
  • SQL Server and DB2 in z/OS: 1+ years' experience with SQL Server and 1+ years' experience with DB2 in a z/OS environment.
  • MySQL/MariaDB: 1+ years' experience with MySQL/MariaDB.
  • BMC Tools: Experience with BMC tools for DB2 (Change/Catalog Manager, MainView, Log Master).
  • JCL and REXX Script: Basic JCL & REXX script skills.
  • Education: Bachelor's degree (or equivalent) in Computer Science, Engineering, Mathematics, or Business.
  • Financial Industry Experience: Related financial industry experiences.
  • PostgreSQL Certification: PostgreSQL Professional Certification.
  • IBM Certification: IBM Certified Database Administrator - DB2 for Linux UNIX and Windows.


  • Chicago, Illinois, United States Request Technology, LLC Full time

    About the RoleWe are seeking a highly skilled Database Administrator to join our team at Request Technology, LLC. As a key member of our database team, you will be responsible for designing, implementing, and maintaining our databases to ensure optimal performance and efficiency.Key ResponsibilitiesDatabase Design and Implementation: Assist in the design and...


  • Chicago, Illinois, United States NinjaTrader Full time

    About NinjaTraderNinjaTrader is a leading provider of trading platforms and brokerage services for futures, forex, and other financial markets.Job DescriptionWe are seeking a highly skilled Database Administrator to join our team. As a key member of our technical staff, you will be responsible for the design, implementation, and maintenance of our databases,...


  • Chicago, Illinois, United States Diverse Lynx Full time

    Job Title: PostgreSQL ConsultantLocation: RemoteDuration: 12+ MonthsInterview: VideoJob DescriptionKey Responsibilities:Postgres developer Query Performance TuningWork with development teams to troubleshoot and fix performance-related issuesMigration experience to move databases from Oracle to Cloudsql for PostgreSQLPerform data copy from on-prem to GCP...

  • Database Administrator

    3 months ago


    Chicago, Illinois, United States NinjaTrader Full time

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


  • Chicago, Illinois, United States Taft Stettinius & Hollister LLP Full time

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


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

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


  • Chicago, Illinois, United States Selby Jennings Full time

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


  • Chicago, Illinois, United States Komatsu Full time

    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 channels, and a global service network, we tap into the power of data and...


  • Chicago, Illinois, United States IT America Inc Full time

    About the RoleWe are seeking a highly skilled Senior Oracle Applications Database Administrator to join our team at IT America Inc. As a key member of our database administration team, you will be responsible for ensuring the optimal performance and security of our Oracle E-Business Suite 12i instances.Key ResponsibilitiesInstall, patch, upgrade, configure,...


  • Chicago, Illinois, United States Pegasus Knowledge Solutions, Inc. Full time

    Job Summary:Pegasus Knowledge Solutions, Inc. is seeking a highly skilled Oracle Apps Database Administrator to join our team. As an Oracle Apps DBA, you will be responsible for implementing advanced security features and tuning Oracle RAC configuration.Key Responsibilities:Assist in implementing Oracle advanced security featuresTune Oracle RAC configuration...


  • Chicago, Illinois, United States LaSalle Network Full time

    Job DescriptionLaSalle Network is partnering with a global client to help identify a DB2 Database Administrator to join their team.Key Responsibilities:Database Installation and Configuration: Install and configure DB2 LUW databases across Linux, UNIX and Windows environments.Performance Tuning: Monitor database performance and perform tuning to improve...


  • Chicago, Illinois, United States LaSalle Network Full time

    Job SummaryLaSalle Network is partnering with a global client to help identify a skilled DB2 Database Administrator to join their team. The ideal candidate will have a strong background in DB2 LUW database management, troubleshooting, and a proactive approach to problem-solving.Key ResponsibilitiesDatabase Installation and Configuration: Install and...


  • Chicago, Illinois, United States LaSalle Network Full time

    Job DescriptionLaSalle Network is partnering with a global client to help identify a DB2 Database Administrator to join their team.Key Responsibilities:Database Installation and Configuration: Install and configure DB2 LUW databases across Linux, UNIX and Windows environments.Performance Tuning: Monitor database performance and perform tuning to improve...


  • Chicago, Illinois, United States Ascendion Full time

    About the Role:**Job Title:** MongoDB Administrator with Atlas and Cloud-based Database**Project Summary:**Ascendion, a leading digital engineering solutions company, is seeking an experienced MongoDB Administrator to join our enterprise cloud team for a prominent healthcare payer client.**Key Responsibilities:**Upgrade, install, and maintain MongoDB and...


  • Chicago, Illinois, United States Belvedere Trading Full time

    Belvedere 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 funds (ETF), and equity index options. From the beginning, we began iteratively...


  • Chicago, Illinois, United States NinjaTrader Full time

    Job DescriptionAbout UsNinjaTrader is a leading provider of trading platforms and brokerage services, dedicated to empowering traders to take control of their financial destiny. Our mission is to become the world's top retail-focused trading platform, and we're committed to innovation, customer advocacy, and employee empowerment.Job SummaryWe're seeking an...


  • Chicago, Illinois, United States Diverse Lynx Full time

    Job OverviewDiverse Lynx LLC is seeking a highly skilled PostgreSQL Performance Tuning Expert to join our team. As a key member of our database administration team, you will be responsible for ensuring the optimal performance and efficiency of our PostgreSQL databases.Key ResponsibilitiesDatabase Administration: Manage and support large PostgreSQL databases...


  • Chicago, Illinois, United States Stardom Employment Consultants Full time

    Job Summary:We are seeking a highly skilled Oracle Database Architect to lead the design, development, and implementation of Oracle database solutions that meet business requirements. The ideal candidate will have deep expertise in Oracle databases, strong analytical skills, and a passion for driving continuous improvement in database technologies.Key...


  • Chicago, Illinois, United States Selby Jennings Full time

    Job 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 highly available and scalable MySQL database environment.Key ResponsibilitiesDesign and implement a clustered, high-availability MySQL database...


  • Chicago, Illinois, United States Alliant Credit Union Full time

    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. Responsibilities Support Microsoft SQL databases to support Business Unit and Application Development. Execute recurring and...