PostgreSQL DBA

Tech Mahindra • Franklin, TN

6d • $100,000 - $110,000 • Onsite

About The Position

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.
The pay range for this role is $100,000 - $110,000 per annum including any bonuses or variable pay. Tech Mahindra also offers benefits like medical, vision, dental, life, disability insurance and paid time off (including holidays, parental leave, and sick leave, as required by law). Ask our recruiters for more details on our Benefits package. The exact offer terms will depend on the skill level, educational qualifications, experience and location of the candidate.
“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 [email protected].”

Requirements

• PostgreSQL
• Aurora PostgreSQL knowledge
• DMS knowledge
• Migration from Oracle to AWS PostgreSQL database
• S3 Bucket Knowledge.

Nice To Haves

• AWS Cloud Platform Knowledge

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.

Benefits

• medical
• vision
• dental
• life
• disability insurance
• paid time off (including holidays, parental leave, and sick leave, as required by law)

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed
• Number of Employees: 5,001-10,000 employees