Database Admin, IBMi

Lincare

Clearwater, FL

JOB DETAILS
LOCATION
Clearwater, FL
POSTED
6 days ago
This employee is responsible for planning, designing, developing, and configuring database systems to meet business needs and requests.  The role is a mix of development and production DBA responsibilities.

    • Responsible for administration, capacity planning, engineering/design, performance monitoring, and optimization of the DB2 for I database platform
      • should be able to adapt to rapidly changing environments and technology

      JOB FUNCTIONS

        • Supports the design and implementation of new database environments and redesign of existing systems to fulfill business needs
          • Monitors and evaluates performance of IBMi databases
            • Troubleshoots database performance issues
              • Manages database objects

                  • Libraries, views, tables, stored procedures, triggers

                  • Supports developers and testing team by maintaining test environments and configuring databases to development specifications
                    • Works with application development teams to develop data models that support business processes
                      • Ensures DB changes adhere to best practices
                        • Reviews all proposed DB changes proposed by IBMi development team
                          • Creates technical support documentation for databases
                            • Acts as a SME on IBMI database structure and environment


                            Education

                              • Bachelor's Degree Required

                              Work Experience

                                • 10+ years of IBMi/iSeries/AS400 experience Required
                                  • 7+ years of experience supporting DB2 for databases in an enterprise environment
                                    Required
                                    • Experience working with enterprise applications Required
                                      • Relevant certifications or training Preferred

                                      Knowledge, Skills, and Abilities

                                        • Demonstrable 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
                                            • 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
                                                • Expert knowledge of modern RPG programming language (ILE/Free)
                                                  • Strong analytic and problem-solving skills with attention to detail
                                                    • Effective verbal and written communication
                                                      • Preference given to someone hands-on experience using system performance tools such as
                                                        Job Watcher, Collection Services, PEX Analyzer, or similar tools
                                                        • Experience using Turnover, Aldon, or similar change management tools


                                                        Equal Opportunity Employer Minorities/Women/Protected Veterans/Disabled

About the Company

L

Lincare