PostgreSQL DBA

PostgreSQL DBA Dearborn, MI – Onsite Fulltime Roles & Responsibilities Create the objects in the database, such as triggers, indexes, etc. Monitor the performance of the database and ensure optimum performance. Identify potential issues in the database to solve them early. Maintain backups and perform disaster recovery in case a disaster destroys the database. Monitor security and prevent any unauthorized access to the database Schedule consistent maintenance on the server Maintain database schema Manage database availability Give best practice guidance to the development team Resolve any production data issues Tablespace management Role management Develop automation technologies to accelerate the process of data loading. Develop relational databases Ensure data integrity Manage user access and permissions by adding and removing users as required Maintain the database using different utilities. This includes using like pg_ctl and psql. Good to have AWS Cloud Platform Knowledge. Must have Aurora PostgreSQL knowledge. DMS knowledge Migration from Oracle to AWS PostgreSQL database S3 Bucket Knowledge. Tech Mahindra is an Equal Employment Opportunity employer. We promote and support a diverse workforce at all levels of the company. All qualified applicants will receive consideration for employment without regard to race, religion, color, sex, age, national origin or disability. All applicants will be evaluated solely on the basis of their ability, competence, and performance of the essential functions of their positions with or without reasonable accommodations. Reasonable accommodations also are available in the hiring process for applicants with disabilities. Candidates can request a reasonable accommodation by contacting the company ADA Coordinator at ADA_Accomodations@TechMahindra.com.”