Database Administrator

Req number:

Employment type:

Worksite flexibility:

Who we are

CAI is a global technology services firm with over 8,500 associates worldwide and a yearly revenue of $1 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right—whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise.

Job Summary

Database Administrator

What You’ll Do

• Design data models based on requirements/SRS/HLD/LLDs using tools like ERWIN etc.
• Ability to create ERDs.
• Clarity w.r.t Conceptual, Logical & Physical data models.
• Provision Postgres/MySQL instances, both in clustered and non-clustered configurations.
• Managing and Administering Cloud based relational Database solutions.
• Have strong experience on configuring and troubleshooting of primary/replica configurations in clustered and non-clustered environment.
• Data migration from on-premises databases to Cloud based database platforms.
• Be a contributor to the database Projects team.
• Design & Implement Disaster Recovery and Business Continuity Solutions for database systems.
• Production Support model on call basis for critical incident handling and emergency support (24X7).
• Strong experience in database administration and production support tasks including Replication, SQL Optimization & Tuning, Monitoring, Backup/Recovery, Troubleshooting and Database Security on large Database environments.
• Exposure to AWS technology Stacks with experience in provisioning
• Experience in Performance Tuning and troubleshooting complex database issues.
• Process Improvement: Continuously identify opportunities to improve processes and governance frameworks. Ensure compliance with organizational policies and standards.
• Risk Management: Identify potential risks and issues, implementing proactive measures to mitigate these within the scope.

What You'll Need

• Bachelor’s degree in IT, or Equivalent.
• At least 5-7 years of experience as Database Designer/Administrator
• Data modelling using tools like ERWIN
• Postgres Database Administration on cloud preferably AWS Aurora
• Desired Skills:
• MySQL Database Administration o Oracle Database Administration o
• Exposure to SQL & PL/SQL, shell scripting etc.
• Key Competencies
• Collaboration: Strong interpersonal skills to work seamlessly with cross-functional IT teams.
• Organization: Strong multitasking abilities with attention to detail.
•  Excellent verbal and written communication skills, with the ability to effectively convey complex information to a variety of stakeholders.
• Problem Solving- Communication- Collaboration- Continuous learning.

Physical Demands

• Sedentary work that involves sitting or remaining stationery most of the time with occasional need to move around the office to attend meetings, etc.
• Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor.

Reasonable accommodation statement

If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to application.accommodations@cai.io or (888) 824 – 8111.