Job#: 3012717

Job Description:

Cloud (AWS) Database Administrator

Apex Systems is hiring for a Cloud (AWS) Database Administrator supporting a large automotive manufacturing client, on-site in Marysville, OH!

Location: On-site in Marysville, OH

Schedule/Hours: Monday-Friday, Statndard Businesss Hours (8-hour shifts; standard 40 hours/week)

Contract Type and Duration: W2 only; Contract is slated to go through the end of March 2027, possibility fot extension

Pay Rate: $60-64/hour

Daily Tasks Performed:

· 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.

Experience & Requirements:

· 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.

· Strong AWS experience (client works in heavy AWS environment)

· 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.

Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing® in Talent Satisfaction in the United States and Great Place to Work® in the United Kingdom and Mexico.

Apex Benefits Overview: Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our ‘Welcome Packet’ as well, which an Apex team member can provide.