Object Technology Solutions Inc. (OTSI) is a leading Global Information Technology (IT) Services and Solutions company offering a wide array of Solutions for a range of key Verticals. Building on a core competency of efficient technology infrastructure outsourcing, the company is headquartered in Overland Park, Kansas, and has a strong presence in US, Europe and Asia-Pacific with a Global Delivery Center based in India.
OTSI delivers high quality, reliable and cost-effective Solutions to customers globally. We provide world-class technology services by constantly exploring and implementing innovative solutions that drive long-term value to our customers.
Postgre SQL DBA : Fort Collins, CO
1/13/2017 11:55:54 AM
Postgre SQL DBA
Minimum 5 years hands-on experience with any RDBMS in general and PostgreSQL (at least 2 years) in particular.
Familiarity with additional DBMSs (like Oracle and DB2) is an asset
Excellent SQL scripting skill including SPs, PSQL scripting Experience supporting a mission-critical database environment with 24x7 On-Call Support including weekends
Hands-on experience on database administration and troubleshooting in co-location environments
Good understanding with replicated databases and, HA, replication, load balancing using Pgpool experience is strongly preferred
Familiarity with approaches to database backup, recovery, PITR, and Disaster Recovery in general Database optimization, and ability to carry out monthly dry run
Solid understanding of Linux/Unix flavor administration
Solid understanding of query execution plan and query optimization techniques
Experience with shell scripting to automate tasks
Ability to deal with a broad range of situations from long-term strategic thinking to high priority escalations, while maintaining an objective viewpoint
Good understanding of VMWare and Storage technology
Experience with legal hold
Working experience of IDOL, Digital safe (or similar) products.