Hi
*This is Aravind, - Recruitment Team from MSR Cosmos* We have an urgent requirement as follows: Please respond with resumes in MS-Word Format with the following details to [email protected] Full Name : Location : Relocation : Contact Number : Email : Skype Id : Last 4 digit SSNO : Availability for project : Availability for Interviews : Visa Status and Validity : D O B : Years of Exp : *Requirement Details* *Postgre SQL Engineer* Seattle,WA - 4+ year’s technology architecture experience in PostgreSQL. - 10+ years of experience in other RDBM technology. - Maintain PostgreSQL databases in QA, staging and Production environments - Deploy DB changes into Staging and Production environments as part of Agile development - Understand and follow production database failover and failback procedures - Develop and enhance scripts to automate and execute various DBA tasks. PostgreSQL Master to Warm Standby failover - Replication with Slony and Slony log shipping - Install, Configure and maintain PostgreSQL databases - Backup, recovery and upgrade of PostgreSQL databases - Comprehensive knowledge of database administration (design, installation & troubleshooting) of PostgreSql 9.x on a Unix or Linux platform - Experience in PostgreSQL Installations, Upgrades, Migration, Monitoring Alert Log, Scheduled Jobs and Troubleshooting Database Problems - Worked on reorganization of tables and indexes within databases when needed - Backup & Recovery Including PgDump, Setting Up WAL Archiving, Point in Time Recovery. - Configure and Trouble Shoot, Log Shipping, Cascading Standbys, Partial Replication & Continuous Recovery - PostgreSQL Cluster by Streaming Replication + PgPool - Understanding of Linux Environment with Shell Scripting. - Understanding of PL/SQL Stored Procedures - Watch community bulletins, Patch, Upgrade and keep the PostgreSQL DBs current. - Review SQLs and DB transactions developed by software engineers and assist in improving the efficiency of the code for best possible DB performance. - Assist engineering team in the design of appropriate DB Schema and indexing strategy for performance and scalability. - Work with Engineering & QA teams to implement and automate DB data purging processes - Ensure DB backups are occurring regularly and backups are restorable in Staging/AWS environments - Set up and monitor database replicas as part Read/Write scalability initiatives. - Explore, evaluate latest tools to improve availability and scalability of Databases - Knowledge of Relational Database fundamentals such as Logical and Physical design, Normalization techniques, Indexing strategies, Data integrity, Data Security and Data Auditing. - Experience in designing physical schema using indexing, partitioning is a plus - Working knowledge of one or more RDBMS such as PostgreSQL, MySQL, MS SQL is a must. - Understanding of one or more No-SQL databases such as Cassandra, MongoDB is desirable - Big Data exposure/understanding is a plus - Proactive monitoring and Trouble shooting of production DB issues - DB Patching and Upgrade skills in production environment (PostgreSQL 9.x preferred) - Mastery of one or more of: SQL, Python, Perl, Bash, Ruby or other scripting language. - Experience in PostgreSQL Replication (using Streaming, Logical, Bucardo, Slony), and connection pooling utility such as PgBouncer, Pgpool is a definite plus - Basic understanding of Virtualization, SAN and Clustered environments is a plus - Expertise on PL/SQL, Performance troubleshooting and replication (PostgreSQL). - Able to manage multiple instance of PostgreSQL. - Maintain standby databases, Migrate and upgrade databases. - Write database checks for the alert monitoring system Requirements. - Desired Profile Critical Skills required (specific skill, software knowledge etc.): - Should have strong operating knowledge on Windows/UNIX / Linux platform. - PostgreSQL/ Oracle/ SQL server - Solid understanding of query execution plans - Good SQL scripts skill including SPs, PSQL scripting - Good performance tuning skills - Knowledge of disaster recovery principles and practices, including planning, testing, backup/restore *Thanks & Regards,* *Aravind* *MSR COSMOS* 5250 Claremont Ave, Ste 249 | Stockton, CA – 95207 *Cell : 925-399-7145* *Fax : 925-219-0934 * *Email *: [email protected] *URL*: http://www.msrcosmos.com *Skype :* msrcosmos *E-VERIFIED | WBE CERTIFIED | MICROSOFT PARTNER NETWORK MEMBER |ORACLE GOLD PARTNER* *Note:* This email is not intended to be a solicitation. Please accept our apologies and reply in the subject heading with REMOVE to be removed from our Mailing list. -- -- *************************************************************************************** For all SAP related tutorials,Articles,Faqs,Tips www.sapbrainsonline.com **************************************************************************************** You received this message because you are subscribed to the Google Groups "sapbrains" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sapbrains?hl=en --- You received this message because you are subscribed to the Google Groups "sapbrains" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
