Hello:
I am a registered member of this group. We have a full-time (direct hire) position available.
Full-Time (Direct Hire) | Remote East Coast (EST) Hours
Salary: $110k - $120k + 5% annual bonus target
Industry: Healthcare
WHY JOIN?
* Career growth opportunities
* Stable and growing $2.5B healthcare company serving customers across the USA (Company has grown organically and through acquisitions)
* Ongoing Business and Technology transformations
* Matching 401 (k), Medical, Dental, Vision, Life, Tuition Reimbursement, & more
* Work/Life Balance
We have a full-time (direct hire) position for a production DBA to manage DB2 databases on the IBM i (AS400) 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.
* 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:
* 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 I Database performance issues using tools such as Plan Cache, Visual Explain, Index Advisor, Detailed Database Monitor, or similar tools.
* Strong 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
Please note: A criminal background check will be conducted upon offer/acceptance.
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.
Regards,
[
https://loxo.co/redactor-files/59647?hash=006592329e55405e8d12397bbd9a86ade4bf66a0]
Tom Byrne, VP/Recruitment Services
Strategic Recruiting Partner to IT & Cybersecurity Decision Makers
Rita Technology Services
813.284.6323
midrange.com
