Database Architect

Key Responsibilities

• Design, implement, and maintain PostgreSQL and Oracle database systems

• Lead database migration projects from Oracle to PostgreSQL

• Configure, optimize, and tune PostgreSQL databases for production environments

• Implement database security measures and access control protocols

• Create and maintain database backup and recovery procedures

• Monitor database performance and resolve bottlenecks

• Develop and implement database standards, procedures, and documentation

• Collaborate with development teams to optimize database queries and schema design

• Provide technical support for database-related issues

• Implement high availability and disaster recovery solutions

Required Qualifications

• 58 years of hands-on experience in database administration, design, and architecture

• Strong expertise in PostgreSQL database administration (setup, configuration, maintenance)

• Proficient in developing optimized stored procedures and database views to enhance data processing and application performance

• Proven experience with Oracle database

• Demonstrated experience in Oracle to PostgreSQL migration projects

• Hands-on experience in data migration and data replication tools like Ora2Pg, Debezium

• Proficiency in SQL query optimization and performance tuning

• Experience with database monitoring tools and performance analysis

• Knowledge of database security best practices

• Experience with high availability and disaster recovery solutions

• Familiarity with backup and recovery procedures

Skills & Attributes

• Strong problem-solving and analytical abilities

• Excellent communication skills, both written and verbal

• Ability to work effectively in cross-functional teams

• Self-motivated with strong organizational skills

• Capable of working under pressure in time-sensitive situations

• Detail-oriented with a focus on quality and reliability

Contact No:8919674955