Main Content

DB2 Database Engineer

Position: DB2 Database Engineer
Reports To: VP of Data and Security Infrastructure Systems
Location: Dallas TX

Position Summary:

The Engineer for Database Systems will provide day-to-day hands on Database Operations management, oversight and governance for key systems administration initiatives and ensure the integrity of the distributed platform hosting services for various critical payment applications.

Qualifications Required:

  • Bachelor’s degree or equivalent education/work experience
  • Minimum of 7+ years professional experience with 5+ years database experience or equivalent
  • Extensive experience using database operating systems and administration, specifically DB2 LUW
  • Extensive understanding of DB2 database internals, performance tuning and troubleshooting techniques
  • Deep knowledge and hands on experience with Linux, UNIX and Windows Operating Systems
  • Very good knowledge within the DB2 ecosystem concerning database, CPU and memory use, high availability solutions, and backup & recovery

Qualifications Desired:

  • 5+ years of experience in performance tuning and production support on financial based applications
  • 5+ years of experience in a team lead capacity
  • Proficient in multiple infrastructure disciplines and functions
  • Proficient in C/C++, Java, JavaScript, Perl, Python or ksh
  • Experience with SQL Server technologies
  • Extensive experience designing and developing enterprise software solutions
  • Experience with agile development methodologies
  • Experience with source control management systems and continuous integration methodologies
  • Experience with debugging, performance profiling and optimization
  • Comprehensive understanding of object-oriented and service-oriented application development theories, including native cloud computing techniques
  • Experience working across large infrastructure environments and distributed across multiple data centers

Essential Functions and Responsibilities:

  • Provide database subject matter expertise and support all aspects of the DB2 database environment including administration and maintenance, business continuity including backup and recovery, capacity management, change management, security management, and installation\configuration management in production and non-production environments
  • Provide 24×7 on call DBA support for production environment on rotation and need basis
  • Extensive knowledge of core DB2 database components such as high availability/federation/replication
  • Design database workloads for optimum configuration and performance of the DB2 infrastructure
  • Respond, track and escalate production issues effectively and with urgency
  • Diagnose and address database performance issues using monitors\alerts and various tuning techniques
  • Perform proactive monitoring and tuning activities across the database ecosystem including network, storage, and servers to optimize the environment and the supporting architecture in cooperation with the Systems Administrator staff
  • Implement physical database infrastructure designs, analyze and provide recommendations for database logical\physical requirements to the user department, applications programming and operations
  • Convert logical data models provided by the application development teams into physical database structures and functional capabilities of database  and underlying components
  • Provide database assistance and problem support to application developers, business analysts and business users
  • Recommend database solutions aligned with the organizational initiatives and recognized problem areas
  • Architect, deploy and champion adherence of database best practice methodologies to stakeholders across the estate
  • Architect, implement and validate backup and recovery procedures in compliance with recovery time and recovery point objectives
  • Ensure synchronicity between application lifecycle environments related to infrastructure components
  • Coordinate with the application development team to ensure the continuity of the database applications related to upgrades, versions, patches, and new releases
  • Collaborate with the Security department to design and implement corporate database security standards
  • Conduct research, provide recommendations, and responsible for the deployment and management of supporting database software applications\tools in cooperation with the System Administrator staff
  • Create, maintain and present detailed technical documentation and executive summaries necessary to support the database operations for key stakeholders, including senior management

Additional Responsibilities include:

  • Work closely with internal and external partners to guarantee continuous infrastructure availability
  • Suggest and implement continuous improvement, automation efforts across the database ecosystem
  • First contact to stakeholders and clients pertaining to database infrastructure related requests
  • Provide technical advice and industry best practices related to database technologies
  • Perform special projects and initiatives as assigned
  • Serve as technical lead/mentor/representative and act as proxy for manager when required

Physical Demands and Work Environment:

  • Ability to remain seated for long periods of time while working on computer or editing
  • Ability to work under highly stressful deadlines
  • Ability to handle multiple tasks simultaneously
  • Ability to prioritize appropriately
  • Ability to sit and review information on a computer screen for long periods of time

Apply Below*:

  • A letter of interest describing your experience and interest in the position
  • Your resume
  • Names and contact information of three references, or three letters of reference

* Please submit a single application per position.

Submit Your Resume