US Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
W2-Permanent
W2-Contract
Contract to Hire
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 11th May 2024
• Strong proficiency in PostgreSQL database administration and management.
• You will be required to develop SQL Queries as required by Business Divisions
• Develop Stored Procedures
• Load Balancing and High Availability
• Ensure System Optimization, by improving and restructuring the databases
• Perform database Updates and Migrations
• Synchronize multiple Databases in various branches.
• Thorough understanding of database design, performance tuning, and optimization techniques.
• Generate Comprehensive Documentation
• Support database issues arising from Customer Queries
• Proficient in troubleshooting & solving complex performance problems.
• Proficient in PostgreSQL Database Patching, Upgrades & Migrations.
• Proficient in monitoring & performance analysis
• Experience working with or in an automated operation environment.
• Experience managing operations on core & cloud-based infra environments.
• Investigate and troubleshoot database-related issues, including connectivity problems, performance degradation, and data inconsistencies.
• Provide timely resolution and root cause analysis for incidents.
• Willingness for 24/7 shift support and on call supportKey skills
• Significant background in creating complex stored procedures and SQL scripts in PostgreSQL.
• Understanding of database normalization concepts
• A minimum of 7+ years database administration experience
• Proven SQL and PostgreSQL experience
• Experience in designing and automating repetitive processes.
• Familiarity with other SQL/NoSQL databases such as MySQL etc
• Experience with cloud-based database services (e.g., AWS RDS, Google Cloud SQL, Azure Database for PostgreSQL).
• Good Hands-on scripting language• Excellent problem-solving and analytical skills
• Effective communication and collaboration abilities.
• Experience working with or in an automated operations environment (e.g. Ansible)