Database Administrator **Req number:** R5943 **Employment type:** Full time **Worksite flexibility:** Onsite **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** We are looking for a motivated Database Administrator ready to take us to the next level! If you understand Postgres/Snowflake/Erwin/MySQL preferably on AWS and are looking forward to your next career move, apply now **Job Description** We are looking for a **Database Administrator** . **This position will** be **full-time** and **Onsite Bangalore.** **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.