数据库管理员

到岗时间：1个月之内 婚况要求：不限婚况 Role overview: Azure Database for PostgreSQL and MySQL support is a becoming a strategic unit of Microsoft Customer Support Services (CSS). As a Support Engineer you will represent Microsoft in customer communication via phone email or chat to assist customers in resolving technical issues involving Microsoft and Open Source products and services. You will have the opportunity to foster positive customer relationships and build customer loyalty while effectively managing challenging situations. The Support Engineer is a trusted advisor to fellow IT Professionals using their technical skills to solve high level complex problems involving broad in-depth product knowledge. Frequently these problems will not only be technically complex but will also require a customer-oriented mindset. You will have a chance to be involved in troubleshooting various environments for some of the worlds largest companies. Open Source Capabilities Highlights: Administration or software development in PostgreSQL or MySQL Experience with multiple OSS database systems (Amazon Aurora Amazon RDS PostgreSQL MySQL MariaDB Redshift) PaaS IaaS experience (Amazon Web Services Microsoft Azure Cloud) Experience with different operating systems (Windows Linux Solaris) Understanding of UnixLinux systems as hosts for PostgreSQLMySQL databases and client applications Skilled with PostgreSQLMySQL database clusters replication and high availability tuning and scalability Knowledgeable of OSS database utilities and tools Ability to troubleshoot in a Linux environment Understanding of PostgreSQL extensions Understanding of common OSS development languages like Java Python C javascript R PHP Perl are a plus Knowledgeable of PostgreSQLMySQL data structures and architecture Responsibilities： Provide in-depth technical support for customers via telephone written correspondence or electronic service. Provide advanced troubleshooting to analyze problems and develop solutions to meet customer needs. Determine the best approach for resolving complex technical issues that will yield the desired turn-around time and optimal customer solution while minimizing the impact to the customer. Engage and collaborate with other Microsoft groups including escalation teams and the RD Team and 3rd party support partner (Open Source) in gaining resolution to critical complex issues. Provide exceptional customer service in politically charged environments. Create advanced online technical content including Knowledge base articles training documents blogs etc. as needed to help enhance our CSS Front of Funnel strategy and drive one-to-many customer and partner impact. Maintain strong working knowledge of all related products technologies and upcoming releases. Take proactive ownership in identifying and recommending product improvements in key product areas based on key data points. Participate in planned team-wide shift rotations to cover business needs possibly including 24x7 on-call responsibilities and weekend work. Present technical content to various audiences including customers partners and internal stakeholders. Provide consulting services to partners and customers to increase product market share. Qualifications Technical Acumen: Musts: MySQLMariaDB or PostgreSQL knowledge on both is preferred. Previous experience requirement with administration operation or development with OSS Databases Owning tracking and resolving database related incidents and requests Building and deploying DDL and DML to implement application features and function Managing operational needs of the database (DB) subsystems (e.g. DB backups maintenance monitoring) tuning and performance optimization Experience with backup and disaster recovery solutions for PostgreSQLMySQL Building data and DB subsystems to scale to maximum performance Install and monitor PostgreSQL database using the standard monitoring tools Analyze daily logs using and query tuning Maintain custom vacuum strategies at table and database level General database administration with generic performance troubleshooting knowledge Monitor code migration and database change management through various stages of the development life cycle Understanding of the PostgreSQLMySQL Architecture and internals Skilled with PostgreSQLMySQL database clusters replication and high availability tuning and scalability Knowledgeable of OSS database utilities and tools Understanding of PostgreSQL extensions Understanding of replication and high availability tools and methods. Including knowledge on High Availability and Connection Pooling Load Balancing PostgreSQL workloads Understanding on tuning Memory parameters in PostgreSQL Gain and share expertise in database technologies other than PostgreSQL including SQL Server and MySQL. Experience in collaboration within different organizational teams including escalation teams and RD Teams and 3rd party support partners (Open Source). Knowledge of service-oriented architecture. Knowledge and experience wi