Job Description
Full-time | Direct Hire | Remote Position - Working Eastern Time Hours We have a full-time (direct hire) position for a production DBA to manage DB2 databases on the IBM i for our large enterprise client. This is a remote position working Eastern time business hours. Candidates must live in the US, preferably on the east coast. You will be responsible for the administration, capacity planning, engineering/design, performance monitoring, and optimization of the DB2 for I database platform. • * This position involves: 65% DB2 DBA / 35% RPG Programming. ** • Supports the design and implementation of new database environments and the redesign of existing systems to fulfill business needs. • Monitors and evaluates the performance of IBM i DB2 databases • Troubleshoots database performance issues. • Manages database objects - Libraries, views, tables, stored procedures, and triggers. • Supports developers and the testing team by maintaining test environments and configuring databases to development specifications. • Work with application development teams to develop data models that support business processes. • Ensure DB changes adhere to best practices. • Review all proposed database changes proposed by IBMi development team. • Creates technical support documentation for databases. • Acts as an SME on IBMI database structure and environment. • 65% DB2 DBA - 35% Application Developer (RPG). REQUIREMENTS: • 10+ years of IBMi/iSeries/AS400 experience • 7+ years of experience supporting DB2 for IBM i databases in an enterprise environment. Experience working with enterprise applications • Proven experience with key relational database concepts such as database normalization, referential integrity, index strategy, and transaction isolation. • Expert knowledge of the DB2 for I SQL language. • Experience optimizing database performance, involving analyzing and tuning SQL statements written by developers to identify and resolve performance bottlenecks. • Advanced knowledge of trigger concepts, methodologies, and implementation. • In-depth experience diagnosing and remediating Db2 for iDatabase performance issues using tools such as Plan Cache, Visual Explain, Index Advisor, Detailed Database Monitor, or similar tools. • Expert knowledge of modern RPG programming language. (ILE/Free). • Strong analytic and problem-solving skills with attention to detail. • Hands-on experience using system performance tools such as Job Watcher, Collection Services, PEX Analyzer, or similar tools (preferred) • Experience using Turnover, Aldon, or similar change management tools U.S. Citizens or Green Card holders only, please. We are unable to accept 3rd party candidates, transfer a visa, or provide sponsorship at this time. Apply tot his job