Need PostgreSQL & Need DB2 DBA

Please send resumes to durgaprasad@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:durgaprasad@sparinfosys.com

--
You received this message because you are subscribed to the Google Groups "SureShotJobs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sureshotjobs+unsubscribe@googlegroups.com.
To post to this group, send email to sureshotjobs@googlegroups.com.
Visit this group at https://groups.google.com/group/sureshotjobs.
For more options, visit https://groups.google.com/d/optout.