| Urgent Need PostgreSQL DBA || Spring Valley, NY On-site || Need No H1B or Cpt at Valley, Alabama, USA |
| Email: [email protected] |
| From: Hasnain Abbas Zaidi, Vyze Inc [email protected] Reply to: [email protected] Hi, This is Hasnain. I have a very urgent role. If interested then please send me your resume along with below information. Full Name: Visa: Email: Phone: Location: Relocation: Skype Id: Start: PostgreSQL DBA Location:- Spring Valley, NY On-site Contract:- 1 yr. Contract MOI:- skype Visa:- NoH1B or Cpt Job Requirements: An experienced PostgreSQL Database Administrator to join the team. This role will manage and maintain several databases that support mission critical applications for the Outage Management System and GIS system. Requirement: Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage. Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need downtime. Develop Stored Procedures and Database Triggers in support of application development. Participate in the creation of development, staging, and production database instances, and the migration from one environment to another. Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release. Responsible for regular backups and recovery of databases. Responsible for regular maintenance on databases (e.g., Vacuum, Reindexing, Archiving). Responsible for pro-active remediation of database operational problems. Maintaining the database server software, using utilities such as pg_ctl or psql to restart services or manually restarting them if necessary Monitoring database performance to identify slowdowns or potential issues Managing users and permissions, including adding new users and removing inactive accounts Managing disaster recovery procedures to ensure that data is safe in case of a physical disaster such as fire or flood Creating database objects such as tables, views, triggers, and indexes Maintaining the database schema, including creating new tables, adding columns to existing tables, and deleting unnecessary tables and data Performing regular database backups to ensure data integrity in case of a server crash Monitoring network security to ensure that unauthorized users cannot access the database server Performing regular scheduled maintenance on the database server, such as vacuum analysis on large tables to remove obsolete data Responsible for the monitoring and uptime of all production databases Best Regards Hasnain Abbas Zaidi Technical Recruiter | VYZE INC. 25179 Methley Plum Place, Aldie, VA 20105 Email: [email protected] Phone: +1-7037942618 (Email is the best way to reach me) Keywords: |
| [email protected] View all |
| Thu Dec 15 16:08:00 UTC 2022 |