| Looking for PostgreSQL Expert || 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 Position: PostgreSQL Expert Location: Remote Duration: Contract Skills: Peformance Tuning, optimization, Auto Vaccum, Parameter tuning. Responsibilities: Lead engineering investigations to bring quicker issue resolution to support impacting enterprise customers and improve customer experience. Build solutions, help create tools, help automate issue detection and diagnosis, to enable customers or support to self-resolve the issue. Able to work well in challenging situations while exhibiting flexibility and ability tolerate and manage through ambiguity and uncertainty. Represent and communicate with corporate customers to provide in-depth technical support for complex escalated problems identified in client software products or services and manage relationships with those customers. Occasionally, these problems will not only be technically complex, but will be politically charged situations requiring the highest level of customer focus skills Ability to optimize complex SQL queries for PostgreSQL, including query analysis and index optimization. Experience in diagnosing and resolving performance issues, including query execution plans and resource utilization Proficiency in monitoring and optimizing PostgreSQL performance using tools like pg_stat_statements, pg_stat_activity, and EXPLAIN ANALYZE and familiarity with PostgreSQL extensions. Knowledge of performance tuning parameters and settings Ability to write scripts in languages like Bash, Python, or PL/PG SQL to automate routine PostgreSQL tasks, such as maintenance, monitoring, and data migrations Strong troubleshooting skills to diagnose and resolve complex PostgreSQL database issues, including database corruption, data integrity problems, and connectivity issues Knowledge of PostgreSQL scaling techniques, including table partitioning and sharding strategies Superior problem solving and troubleshooting skills, an ability to use various data collection tools and methodologies to analyze problems and develop solutions Keywords: information technology procedural language |
| [email protected] View all |
| Tue Feb 27 21:59:00 UTC 2024 |