Postgre SQL-DB Administration

PostgreSQL-DB Administration

1: Does the candidate have hands on experience - Migration from On Premise to Cloud

2: Does the candidate have experience with Postgres and Mongo DB. MySQL is good to Have.

Mandatory Skills :

Location : Mumbai, Bangalore, Pune & Chennai

Experience: 8-12 Yrs : 25-30 LPA

Client : LTI Mindtree - Direct Payrolls

Detailed JD:

Involve on adoption of strategic platforms for MongoDB MySQL PostgreSQL onpremise and Cloud Infrastructure

Collaborate on Database Automation activities to improve process efficiency and risk compliance

Install monitor and maintain PostgreSQL MySQL MongoDB databases software implement monitoring and ing implement backup and recovery processes provide system and SQL performance tuning

Design and Implement Disaster Recovery Replication and High Availability database solutions in MongoDB MySQL MSSQL

Lead and manage high severity database issues impacting revenue applications working cross functionally across leads of infrastructure network and application teams

Ready to learn other core database technology like Oracle open source databases

Must have a handson experience and knowledge of database technology in Azure and AWS

Must have good handson experience of Linux Windowsbased platforms with troubleshooting Knowledge

Knowledge of DB2 Sybase MaxDB is a big plus

Good scripting Knowledge DB Power Shell UnixShell Scripting

Fulfills user requests ranging from access control backup restore refresh to nonproduction to performance tuning

Drive Stability initiatives by proactively reviewing and addressing Database performance and capacity trends

Effectively participate and guide 24x7 operational support shift model

Fulfill user requests ranging from User Management Database Refresh Performance tuning Migration

Ensure regular maintenance and proactive remediation of database operational problems

Ensure centralized 24x7 Database Monitoring and Auditing Tools in place and effective in operation

Experience in all aspects of the software development lifecycle including requirements gathering design coding testing and production support

Experience in transforming to and from on premise environment to cloud technology

Excellent oral written and collaborative communication skills

Engage completely into full lifecycle of Database environment Plan Build Patch Run

Risk and Control oversight of DB environment ensuring engagement with DB Security and Engineering teams

Provide guidance to Operational Database Support teams to troubleshoot and investigate Business impacting performance issues on need basis

Apply technical expertise to strategize for currentfuture technological developments and serve as point of contact for technical questions

Apply knowledge of concepts and procedures to resolve issues

Create and maintain processes and documentation for various database activities including architecture user access user termination DB creation DB migration DB security Service Now knowledge etc

Contribute to formulation of strategies for infrastructure technologies functional areas across various business sectors

Ensure ongoing compliance with regulatory requirements evaluate controls to help mitigate negative outcomes through prevention detection and correction SOXPCIGDPRExport compliance etc

Appropriately assess risk when business decisions are made demonstrating particular consideration for the firms reputation and safeguarding Honeywell its clients and assets by driving compliance with applicable laws rules and regulations adhering to Policy applying sound ethical judgment regarding personal behavior conduct and business practices and escalating managing

Engage in crossplatform training in bits and bytes sessions on technology trends create opportunities for career growth and train the resources across various technologies

The ability to partner effectively across IT teams suppliers and business customers on crossfunctional projects and process improvements

Strong interpersonal skills effective listening and be a motivated team player

Selfmotivated demonstrated bias for action

Skilled in partnering with internal customers at all levels to define problems identify solutions and facilitate change

Experience with data protection business continuity and disaster recovery options configuration and execution

Ability to effectively deal with critical outages and remediation efforts given risk activities

Effectively demonstrates ability to deliver on complex situations or problems without guidance or supervision

Creative and collaborative problemsolving capability

Experience and Knowledge on Oracle No SQL databases and Big data is big plus