DB2 LUW Postgre DBA

4 weeks ago

Chicago, United States Request Technology, LLC Full time

***We are unable to sponsor for this permanent full-time role**

***Position is bonus eligible***

Prestigious Financial Institution is currently seeking a DB2 LUW Database Administrator with Postgre experience. Candidate 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 application performance.

Responsibilities:

  • Assists with the design, implementation, and maintaining databases
  • Manage database performance and disk usage
  • Provides support in database access methods
  • Provides consultation support in database analysis, modeling, coding, and production problem resolution.
  • Develops maintenance, backup and recovery procedures and documentation
  • Participates in Disaster Recovery drills
  • Provides Primary On-Call Support for production problems
  • Understands and supports corporate data standards
  • Recommends and assists with new DBMS and operational standards.
  • Participates in testing and in evaluations of new software and software release upgrades
  • Supports business studies, proposal teams and costing/feasibility studies
  • Prepares system documentation
  • Maintains metadata repositories
  • Other duties as assigned

Qualifications:

  • [Required] 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
  • [Required] Well versed in all phases of Systems Analysis and Design
  • [Required] Experienced in two or more programming languages and two or more scripting languages
  • [Required] Practiced at Entity/Relationship or Object modeling and translation to physical database designs
  • [Required] Proficient in DML, DDL, and database utilities for at least two DBMS technologies
  • [Required] Proficient in all access methods of a DBMS as well as the underlying operating system access methods
  • [Required] Knowledge of hardware and operating system capabilities within one environment
  • [Required] Understanding of all software subsystems (DBMS, TP Managers, etc.) for one environment
  • [Required] Accepts ownership in assignments, team, and company and takes initiative outside immediate area of responsibility
  • [Required] Speed / Sense of Urgency –Contributes additional effort when necessary to get the job done and to help others meet their objectives
  • [Required] Seeks additional responsibility, shows initiative to learn every aspect of the job, and strives to become a mentor to others in area of expertise
  • [Required] Communicates openly and effectively. Challenges established practices appropriately
  • [Required] Ability to maintain composure under pressure and avoid defensive or irritated or reactions in challenging situations

Technical Skills:

  • [Required] 7+ years’ experience with PostgreSQL
  • [Required] 7+ years’ experience with DB2 LUW; preferably on Red Hat Linux
  • [Required] Proficient with coding and review of SQL, stored procedures, and triggers
  • [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
  • [Preferred] 1+ years’ experience with DB2 in a z/OS environment
  • [Preferred] 1+ years’ experience with MySQL/MariaDB
  • [Preferred] Experience with BMC tools for DB2 (Change/Catalog Manager, MainView, Log Master)
  • [Preferred] Basic JCL & REXX script skills
  • [Required] bachelor’s degree (or equivalent) in Computer Science, Engineering, Mathematics, or Business
  • [Preferred] Related financial industry experiences
  • [Preferred] PostgreSQL Professional Certification
  • [Preferred] IBM Certified Database Administrator - DB2 for Linux UNIX and Windows

  • DB2 LUW Postgre DBA

    4 weeks ago

    Chicago, United States Request Technology, LLC Full time

    ***We are unable to sponsor for this permanent full-time role*****Position is bonus eligible***Prestigious Financial Institution is currently seeking a DB2 LUW Database Administrator with Postgre experience. Candidate will design and maintain databases and database solutions that operate within prescribed resource limits and meet company standards....

  • DB2/PostgreSQL Database Administrator

    3 weeks ago

    Chicago, United States Request Technology, LLC Full time

    ***Hybrid, 3 days onsite, 2 days remote******We are unable to sponsor as this is a permanent full-time role***A prestigious company is looking for an Associate Principal, Database Administrator. This DBA will focus on production support, performance back up, and DBMS. This company needs someone with 7+ years of working with db2 LUW on Red Hat and PostgreSQL....

  • DB2/PostgreSQL Database Administrator

    2 weeks ago

    Chicago, United States Request Technology, LLC Full time

    ***Hybrid, 3 days onsite, 2 days remote******We are unable to sponsor as this is a permanent full-time role***A prestigious company is looking for an Associate Principal, Database Administrator. This DBA will focus on production support, performance back up, and DBMS. This company needs someone with 7+ years of working with db2 LUW on Red Hat and PostgreSQL....

  • DB2 Database Administrator

    2 weeks ago

    Chicago, United States LaSalle Network Full time

    LaSalle 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

    1 month ago

    Chicago, United States Spero Technology Full time

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

  • Database Administrator

    1 month ago

    Chicago, United States Spero Technology Full time

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

  • DB2 Database Administrator

    23 hours ago

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

  • Java Application Developer-Only W2 Candidates

    2 weeks ago

    Chicago, United States Stash Talent Services Full time

    Title: Java Developer (Multiple level)Location: Chicago, IL (3 days onsite)Duration: 12 monthsDay to Day Responsibilities:Work under the direction of senior team members to write code for full stack new softwaredevelopment builds from scratch using the TDD approachWrite code that satisfies business requirements assigned to work streamProvide status updates...

  • Java Application Developer-Only W2 Candidates

    2 weeks ago

    Chicago, United States Stash Talent Services Full time

    Title: Java Developer (Multiple level)Location: Chicago, IL (3 days onsite)Duration: 12 monthsDay to Day Responsibilities:Work under the direction of senior team members to write code for full stack new softwaredevelopment builds from scratch using the TDD approachWrite code that satisfies business requirements assigned to work streamProvide status updates...

  • Java Application Developer-Only W2 Candidates

    1 week ago

    Chicago, United States Stash Talent Services Full time

    Title: Java Developer (Multiple level)Location: NYC, NY/ Chicago, IL/ Plano, TX/ Wilmington, DE (3 days onsite)Duration: 12 monthsDay to Day Responsibilities:Work under the direction of senior team members to write code for full stack new softwaredevelopment builds from scratch using the TDD approachWrite code that satisfies business requirements assigned to...

  • Java Application Developer-Only W2 Candidates

    7 days ago

    Chicago, United States Stash Talent Services Full time

    Title: Java Developer (Multiple level)Location: NYC, NY/ Chicago, IL/ Plano, TX/ Wilmington, DE (3 days onsite)Duration: 12 monthsDay to Day Responsibilities:Work under the direction of senior team members to write code for full stack new softwaredevelopment builds from scratch using the TDD approachWrite code that satisfies business requirements assigned to...

  • Oracle Developer

    2 months ago

    Chicago, Illinois, United States AbbVie Full time

    Company DescriptionAbbVie's mission is to discover and deliver innovative medicines and solutions that solve serious health issues today and address the medical challenges of tomorrow. We strive to have a remarkable impact on people's lives across several key therapeutic areas immunology, oncology, neuroscience, and eye care and products and services in our...

  • Associate Principal, Software Engineer

    1 month ago

    Chicago, Illinois, United States OCC Full time

    Who We AreAbout UsThe Options Clearing Corporation (OCC) is the world's largest equity derivatives clearing organization. Founded in 1973, OCC is dedicated to promoting stability and market integrity by delivering clearing and settlement services for options, futures and securities lending transactions. As a Systemically Important Financial Market Utility...