Manage, support, and maintain database technologies (PostgreSQL and Microsoft SQL) and infrastructure, adhering to the architectural guidelines and policies.
Maintain organization database diagram up to date with current implementation.
Implementation/Support of databases, storage structures, replication, Hyperscale, Clusters, logical partitioning, and disaster recovery solutions.
Provide DBA support for enterprise monitoring, backup, alerting, and security compliance solutions for database servers.
Perform data analysis to uncover issues and solve complicated problems that typically span multiple systems.
Auditing and maintaining database infrastructure configuration
Tune databases and applications: rewriting SQL, adding indexes, tuning of views, interpreting explains plans, performing reorgs (or vacuum activities) in PostgreSQL
Oversee and provide technical direction in design, install, configure, maintain, troubleshoot, test, monitor, and analyze the performance of the Cloud and on-prem Databases.
Design database solutions - gathering server requirements, installing, and creating databases, performance tuning, monitoring for new and existing functionalities
Check DB health, validate background process and memory utilization, and performance tuning.
Develop processes for optimizing database governance & security, costs, backup and recovery, and performance monitoring standards.
Write documentation exhaustively, especially where no documentation currently exists
Leverage strong command of AWS SQL (PostgreSQL) and SQL Server tools.
Demonstrate knowledge of cloud database architectures.
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.