KEY RESPONSIBILITIES:
Set up and manage PostgresSQL, MSSQL and MongoDb.
Ensure high levels of performance, availability, sustainability and security
Refine and automate regular processes, track issues, and document changes
Assist developers with query tuning and schema refinement
Provide 24x7 support for critical production systems
Prepare documentations and specifications
Handle common database procedures, such as upgrade, backup, recovery, migration
Profile server resource usage, optimize and tweak as necessary
Configure and maintain database servers and processes
DAILY RESPONSIBILITIES:
Routine production database support functions including and not limited to checking for tablespace free space, fragmentation, checking for nightly / weekly back-up status, checking production databases for critical errors and creating SRs with tech support and follow-up.
Resolving all database-related issues and working closely with the Development, Project Management and staff
Ensuring for security, performance monitoring and tuning, capacity planning, and backup and recovery are performed.
Overseeing backups, replication and failover and running optimally.
Monitoring Database systems and platforms for availability
Education& Experience
Bachelor's Degree- IT or other IT/Engineering related Degree
Professional Qualifications- MS SQL, MySQL, PostgreSQL Certification
4 years' Experience In IT
3 years' experience in MySQL, PostgreSQL, MongoDB and MSSQL database administration
data Warehousing Experience
Banking Operations
