DB2 LUW DB Administrator(Onsite)

About Us:

LTIMindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to more than 700 clients, LTIMindtree brings extensive domain and technology expertise to help drive superior competitive differentiation, customer experiences, and business outcomes in a converging world. Powered by nearly 90,000 talented and entrepreneurial professionals across more than 30 countries, LTIMindtree — a Larsen & Toubro Group company — combines the industry-acclaimed strengths of erstwhile Larsen and Toubro Infotech and Mindtree in solving the most complex business challenges and delivering transformation at scale. For more information, please visit www.ltimindtree.com

Job Title: DB2 LUW DB Administrator

Work Location: Marysville, Ohio

Job Description

AWS and other Cloud Technologies, IaaS and PaaS, Cloud Database Platforms (RDS PostgreSQL, AWS DynamoDB, Document DB, MongoDB, Neo4j, Neptune etc.)

• Database Design and Implementation: Design, develop, and implement database solutions in collaboration with development teams. Create database schemas, tables, and indexes to support efficient data storage and retrieval.

• Database Administration: Manage, monitor, and optimize database instances to ensure high availability, performance, and data integrity. Configure and maintain database backups, replication, and disaster recovery strategies.

• Performance Tuning and Optimization: Identify and resolve database performance issues, including query optimization, index tuning, and resource utilization. Monitor database performance metrics and implement improvements to optimize performance.

• Data Security and Compliance: Implement and maintain appropriate security measures and access controls to protect sensitive data stored in the cloud database. Ensure compliance with data protection regulations and industry best practices.

• Database Monitoring and Troubleshooting: Monitor database activity and performance using database monitoring tools. Diagnose and resolve database-related issues and incidents, working closely with cross-functional teams to ensure timely resolution.

• Database Capacity Planning: Estimate future database storage and performance requirements based on data growth projections. Plan and implement database capacity upgrades or scaling activities to accommodate evolving business needs.

• Database Automation and Scripting: Develop and maintain database automation scripts, workflows, and configurations using scripting languages and infrastructure-as-code tools. Implement DevOps practices for database deployment and management.

• Collaboration and Communication: Collaborate with application teams, infrastructure teams, and stakeholders to understand database requirements, provide technical guidance, and ensure effective integration with other systems. Communicate database-related updates, issues, and recommendations to relevant stakeholders.

What will this person be working on:

• Database Administration: Install, Configure, and Upgrade database software for DB2 LUW and Cloud Database Platforms. Monitor and maintain database health, performance, and security. Implement and manage database backup and recovery strategies. Ensure high availability and disaster recovery readiness.

• Performance Tuning: Analyze and optimize SQL queries and database performance. Identify and resolve bottlenecks in database systems. Implement indexing and tuning strategies and partitioning for performance gains.

• Security & Compliance: Manage user access and roles. Ensure compliance with data governance and security policies. Perform audits and vulnerability assessments.

• Automation & Scripting: Develop scripts for monitoring, maintenance, and automation tasks. Use tools like shell scripting, Python, or Perl for automation.

• Collaboration: Work closely with application developers, system administrators, and business analysts to understand new requirements and recommend high level direction and approach. Provide support for development, testing, and production environments.

• Support: Resolve platform related issues. Participate in Incident Response. Coordinate with Vendors for Product related issues, Patches and Bug Fixes.

• Future Technologies: Assist in migrating On-Prem Databases to the cloud and integrating data from various sources into Cloud-based systems.

Position Success Criteria (Desired) - 'WANTS':

• 10 years’ experience as a DB2 LUW DBA in enterprise environments.

• Strong knowledge of DB2 LUW architecture, utilities, and tools. Experience with HADR, TSA, QREP and other high availability solutions.

• 5 years’ experience with Cloud Concepts, AWS and other Cloud Technologies, IaaS and PaaS, Cloud Database Platforms (RDS PostgreSQL, AWS DynamoDB, DocumentDB, MongoDB, Neo4j, Neptune etc.)

• 5 years’ experience working with large database / large scale projects.

• Proficiency with performance tuning and query optimization.

• Familiarity with Linux/Unix operating systems and shell scripting.

• Experience with monitoring tools

• Excellent problem-solving and communication skills.

• Lead by Example: Build strong morale, team success, and positive feedback, and mentoring.

• Be willing to learn and adapt to emerging technologies.

• Use technology, design and/or architecture processes with business sense to make appropriate decisions.

• Good knowledge of Project Management principles.

• Excellent verbal communication skills, Strong visual presentation skills.

• Flexibility to communicate effectively with various levels of management.

• Ability to analyze critical information, assess upstream/downstream impact, and formulate broad recommendations.

Benefits/perks listed below may vary depending on the nature of your employment with LTIMindtree (“LTIM”):

Benefits and Perks:

• Comprehensive Medical Plan Covering Medical, Dental, Vision
• Short Term and Long-Term Disability Coverage
• 401(k) Plan with Company match
• Life Insurance
• Vacation Time, Sick Leave, Paid Holidays
• Paid Paternity and Maternity Leave

The range displayed on each job posting reflects the minimum and maximum salary target for the position across all US locations. Within the range, individual pay is determined by work location and job level and additional factors including job-related skills, experience, and relevant education or training. Depending on the position offered, other forms of compensation may be provided as part of overall compensation like an annual performance-based bonus, sales incentive pay and other forms of bonus or variable compensation.

Disclaimer: The compensation and benefits information provided herein is accurate as of the date of this posting.

LTIMindtree is an equal opportunity employer that is committed to diversity in the workplace. Our employment decisions are made without regard to race, colour, creed, religion, sex (including pregnancy, childbirth or related medical conditions), gender identity or expression, national origin, ancestry, age, family-care status, veteran status, marital status, civil union status, domestic partnership status, military service, handicap or disability or history of handicap or disability, genetic information, atypical hereditary cellular or blood trait, union affiliation, affectional or sexual orientation or preference, or any other characteristic protected by applicable federal, state, or local law, except where such considerations are bona fide occupational qualifications permitted by law.

Safe return to office: In order to comply with LTIMindtree’ s company COVID-19 vaccine mandate, candidates must be able to provide proof of full vaccination against COVID-19 before or by the date of hire. Alternatively, one may submit a request for reasonable accommodation from LTIMindtree’s COVID-19 vaccination mandate for approval, in accordance with applicable state and federal law, by the date of hire. Any request is subject to review through LTIMindtree’s applicable processes.