The Role
The Database Administrator is responsible for planning, designing, and optimizing database systems, managing DB2 databases, and supporting development teams in a rapidly changing environment.
Summary Generated by Built In
Job Summary & Responsibilities
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
Skills Required
- 10+ years of IBMi/iSeries/AS400 experience
- 7+ years of experience supporting DB2 for databases in an enterprise environment
- Experience working with enterprise applications
- Bachelor's Degree
- Relevant certifications or training
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Lincare is a leading supplier of respiratory-therapy products and services for patients in the home. You can learn more about our extensive suite of products and services by visiting our website. Everywhere we operate, Lincare is working to be a partner in patient care by providing high-quality services and supplies, promoting patient education, and building strong relationships with patients, physicians, families and caregivers. Services we offer include: Oxygen Therapy Nebulizer Therapy Sleep Therapy Ventilator Therapy Enteral Therapy Pediatric Services Caring Responders Long Term Care Disease Management Programs and More!
