Database Admin Senior Specialist

SQL DB Administrator
Creation and Maintenance of Production Databases : On: Premise and Cloud : Azure, AWS or Google Cloud.
:Plans and coordinates the administration of PostgreSQL databases to ensure accurate, appropriate, and effective use of data, including database definition, structure, documentation, long : range requirements, and operational guidelines.
:Performs quality control audits to ensure accuracy, completeness, and proper usage of data in tables and various support tools, such as database dictionaries.
:Reviews database design and integration of systems, and makes recommendations regarding enhancements and/or improvements.
:Establish and maintain security and integrity controls.
:Provides appropriate consulting, interfacing, and standards relating to database management, and monitors transaction activity and utilization.
:Prepares and/or reviews activity, progress, and performance reports.
:Diagnoses, resolves and implements preventive measures to prevent problems for availability, recoverability and performance of all supported database environments.
:Recommends and oversees implementation of database level configuration changes to optimize performance. Ensures maintenance of physical integrity of all production databases.
:Install,configure, test, monitor, upgrade, andtune new and existing SQL databases.
:Tuning autovacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples.
:Contributed to decreasingneed for downtimeby developing and improving procedures for automated monitoring and proactive intervention.
:Studied and stayedcurrentonfeaturesand functionality ofSQL.
:Installing and configuring check sqlplugins for Monitoring SQL instances effectively.
:Proactive in updating the latest security patches to database, which are provided bySQL open source community.

Job Type: Permanent