*Please send resumes to durgapra...@sparinfosys.com <durgapra...@sparinfosys.com>*
*//h1b copy must// * *Appreciate your responses with updated word profile, contact details and rate specifications.* *Full Name:* *Phone Number:* *Email ID:* *Current Location:* *Visa Status:* *Relocation:* *Availability:* *Rate:* *Position 1* *Need PostgreSQL* *Des Moines, Iowa 6-12 Months+ * *Responsibilities *–PostgreSQL · Install, tune and monitor Postgres database instances · Perform database Migrations from Oracle, SQL Server, MySQL to PostgreSQL · Performance tune and make performance tuning recommendations to existing database deployments · Set up High Availability configurations using PostgreSQL · Implement backup strategies and performs upgrades and patching · Develop architectures to migrate data and entire databases; implement and deliver on the architecture migrating databases · Core knowledge and understanding on PostgreSQL database including usage of psql, configuration files like pg_hba.conf and postgresql.conf. · Installation of IDE Tool - originally, PgAdmin, PgAgent · Create a Database, set encoding char, etc... · Install a Procedural Language as PL/pgSQL · Ensure performance and scalability of PostgreSQL databases · Implement, refine and maintain database replication and failover · Develop, refine and monitor recurring database jobs/scripts · Query analysis and optimization · Data import and data migration *Position **2* *Need DB2 BDA* *Des Moines, Iowa 6-12 Months+ * Responsibilities –DB2 · Experience in installation of DB2 UDB and Fixpack Upgrades on UNIX and Windows machines, builds and maintenance of databases · Should have good experience in implementing standards, controls, and procedures to ensure data integrity and security. · Backup and Recovery - Framing suitable backup and recovery strategies and implement · Monitoring and tuning for most of the database configuration parameters like Bufferpool size, Logbufsz, Appheapsz, Sortheap, Sortheapthres, Locklist, Maxlocks, Locktimeout, Maxappls etc… · Database monitoring, reporting and optimization of SQL Queries assist in performance tuning application in DB2. · Maintenance of objects (Tables, Table spaces, Schemas, Indexes, views, Packages) · Import/Export, Load utilities to move data across systems. · Experience in day to day database administration tasks like Reorg, Runstats,backup, Restore, tablespace usage, db2advis, taking snapshot, Checking the memory , creating users, granting and revoking privileges. · Should have good experience in High Availability Disaster Recovery, High Availability Cluster Multi-Processing and Data partitioning feature. *Thanks* *Durga Prasad* *Spar Information Systems* * Email:**durgapra...@sparinfosys.com* -- You received this message because you are subscribed to the Google Groups "IT provider" group. To unsubscribe from this group and stop receiving emails from it, send an email to it-provider+unsubscr...@googlegroups.com. To post to this group, send email to it-provider@googlegroups.com. Visit this group at https://groups.google.com/group/it-provider. For more options, visit https://groups.google.com/d/optout.