| Looking for PostgreSQL DBA ||Remote || 12+ Years at Remote, Remote, USA |
| Email: [email protected] |
| From: sharmi, SIF [email protected] Reply to: [email protected] Dear, Greetings from Smart IT Frame, Hope you are doing well!!! Smart IT Frame specializes in enabling you with your most critical line of resources. Whether its for permanent staffing, contract staffing, contract-to-hire or executive search, we understand the importance of delivering the most suitable talent; on time and within budget. With our Core focus in emerging technologies, we have provided global technology workforce solutions in North America, Canada & India. We take pride in delivering specialized talent, superior performance, and seamless execution to meet the challenging business needs of customers worldwide. Job Title: PostgreSQL DBA Work Location: Remote Contract Job Description: 13+ years of IT experience and minimum of 5+ years of experience on PostgreSQL database administration. Should have worked with the team size of above 10 members & technically guided the team. Willing to provide 24x7 support, flexible to work in the shifts Planning for Production Storage and Capacity Management. Create logical models and build physical models Planning for Production Storage and Capacity Management. Creation, managing & migrating PostgreSQL schema, tables, tablespaces and users, roles & group in 10.x, 11.x,12.x,13.x, 14.x, 15.x to Azure Cloud including PaaS (Azure database for PostgreSQL single & flexible servers) Performance tuning, Query tuning by generating and explaining plan for SQL queries. Expert in DBA functions like managing databases, backup & restore, scheduling jobs, space, performance management, principles of database replication, scalability and high availability. Expert in Backup & Recovery including Pg_dump, pg_dumpall, setting up WAL archiving, Point in time recovery. Analyze, recommend, and implement configuration for Optimized Performance. Ability to plan hardware capacity requirements for storage, memory and CPU Cycles. Ability to configure and troubleshoot, log shipping, cascading standbys, partial replication, continuous recovery, detach and reattach slaves. Understanding of UNIX environment with shell scripting. Trouble shooting and resolving database issues. This role may entail shift & after-hours support on an on-call basis. HA/DR Setup including logical, physical standby Conforming to client compliances and expectations This role may entail shift & after-hours support on an on-call basis. Good working experience all HA and DR solutions. Mandatory Technical skills required Migrating on-premise PostgreSQL to Azure Cloud Migrating Azure database for PostgreSQL (Single server) to Migrating Azure database for PostgreSQL (Flexible server) Security setup: Enabling & Configuring SSL Certificate Authentication to encrypt data transfer Day to-day PostgreSQL Good to have: Any of the following PostgreSQL certificate: PostgreSQL Associate PostgreSQL Professional Soft Skills: Good customer connects. Prepare solution presentations. Positive attitude and excellent communication skills to manage customer calls. Excellent problem-solving skills. Good communication. Keywords: information technology |
| [email protected] View all |
| Tue Dec 05 21:46:00 UTC 2023 |