Job description :
Full-time | Direct Hire | Remote Position - Working Eastern Time Hours
We seek 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.
- Please note : This position involves 65% DB2 DBA / 35% Application Program m ing (RPG).
You will be responsible for the administration, capacity planning,
engineering / design, performance monitoring, and optimization of the DB2
for I database platform.
Supports the design and implementation of new database environmentsand the redesign of existing systems to fulfill business needs.
Monitors and evaluates the performance of IBM i DB2 databasesTroubleshoots database performance issues.Manages database objects Libraries, views, tables, storedprocedures, and triggers.
Supports developers and the testing team by maintaining testenvironments and configuring databases to development
specifications.
Work with application development teams to develop data models thatsupport business processes.
Ensure DB changes adhere to best practices.Review all proposed database changes proposed by IBMi developmentteam.
Creates technical support documentation for databases.Acts as an SME on IBMI database structure and environment.Qualifications :
10+ years of IBM i / iSeries / AS400 experience7+years ofexperience supporting DB2 for IBM i databases in anenterprise environment.Experience working with enterprise
applications
Proven experience with key relational database concepts such asdatabase normalization, referential integrity, index strategy, and
transaction isolation.
Expert knowledge of the DB2 for I SQL language.Advanced knowledge of trigger concepts, methodologies, andimplementation.
In-depth experience diagnosing and remediating Db2 for iDatabaseperformance 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 JobWatcher, Collection Services, PEX Analyzer, or similar tools
(preferred)
Experience using Turnover, Aldon, or similar change management toolsU.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.
Why is This a Great Opportunity :
Career growth opportunitiesStable and growing $2.5B healthcare company serving customers across the USA (Company has grown organically and through acquisitions)Ongoing Business and Technology transformationsMatching 401k, Medical, Dental, Vision, Life, Tuition Reimbursement, & moreWork / Life Balance