Database Administrator - DocumentDB / MySQL / PostgreSQL

About Client :

Our Client is a multinational IT services and consulting company headquartered in USA, With revenues 19.7 Billion USD, with Global work force of 3,50,000 and Listed in NASDAQ, It is one of the leading IT services firms globally, known for its work in digital transformation, technology consulting, and business process outsourcing, Business Focus on Digital Engineering, Cloud Services, AI and Data Analytics, Enterprise Applications ( SAP, Oracle, Sales Force ), IT Infrastructure, Business Process Out Source. Major delivery centers in India, including cities like Chennai, Pune, Hyderabad, and Bengaluru. Offices in over 35 countries. India is a major operational hub, with as its U.S. Title : Database Skills : Document DBA+ (MySQL / PostgreSQL) +Amazon Arora & RDS

Job Locations : PAN : 5+ Qualification : Any Mode : Type : Period : Immediate to 15 Days

Job Description :

Who are we looking for?

We are looking for 5+ years of administrator experience in DocumentDB / MySQL / PostgreSQL Databases. The ideal candidate will be responsible for ensuring the availability, performance, and security of our Snowflake data warehouse environment. You will provide 24 / 7 production support, troubleshoot issues, monitor system health, optimize performance, and collaborate with cross-functional teams to maintain a reliable and efficient Snowflake Skills :

• Proven experience as a NoSQL Document DB Database and MySQL OR PostgreSQL Administrator or similar role in production support environments.
• Hands-on experience managing and supporting MySQL OR PostgreSQL in a production environment.
• Strong knowledge of No SQL internals, architecture, data modeling, replication, and consistency levels.
• Proficiency in troubleshooting cluster issues, performance tuning, and capacity planning.
• Familiarity with Linux / Unix systems and shell scripting.
• Experience with monitoring tools like Cloudwatch, Appdynamics, Cron, Autosys or similar.
• Understanding of distributed systems and high-availability concepts.
• Expertise in performance tuning.
• In-depth understanding of data management (e.g. permissions, recovery, security and monitoring).
• Understanding of ETL / ELT tools and data integration patterns.
• Strong troubleshooting and problem-solving skills.
• Excellent communication and collaboration abilities.
• Ability to work in a 24 / 7 support rotation and handle urgent production issues.
• Strong understanding of relational database concepts.
• Experience with database design, modeling, and optimization is good to have.
• Proficiency in writing complex SQL queries and developing stored procedures.
• Familiarity with data security is the best practice and backup Responsibilities :
• Manage and administer DocumentDB, MySQL, and / or PostgreSQL databases in production environments.
• Ensure high availability, reliability, and security of database systems including Amazon Aurora and RDS.
• Provide 24 / 7 production support, troubleshoot database-related issues, and resolve performance bottlenecks.
• Monitor database health using tools such as CloudWatch, AppDynamics, Cron, AutoSys, or equivalents.
• Perform capacity planning, backup, recovery, and disaster recovery operations.
• Optimize database performance through tuning, indexing, and query optimization.
• Collaborate with cross-functional teams for data integration, ETL / ELT processes, and database design.
• Implement data security best practices and manage user permissions.
• Write and maintain complex SQL queries, stored procedures, and scripts.
• Work in rotation for 24 / 7 support coverage and respond promptly to production incidents.
• Utilize shell scripting and work with Linux / Unix operating systems.
• Understand and manage distributed systems and clustering for high availability.

(ref : hirist.tech)