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