Job Description :
Postgres Database Architect
Cypress, CA or Eden Prairie, MN
12+ Month
What are the top 5-10 responsibilities for this position:
1. Actively participate in all phases of project development life cycle including database policies, procedures, standards and supporting documentation, database design, process flow analysis, development, benchmark analysis, performance/tuning, capacity planning, and production implementation
2. Production support responsibilities include maximizing system availability, ensuring swift and complete database recovery, optimizing database and availability through ongoing maintenance, and ensure conformance to audit and operating standards
3. Participate in the evaluation, and recommendation of appropriate hardware and software resources. Develops pioneering approaches to emerging industry trends
4. Assisting with communication interfaces/integration to associated systems. Status reporting to Senior Leadership.
5. Design, implement and maintain all functions of database systems, including access, methods and time, device allocations, validation checks, organization, security, documentation, and statistical methodology.
6. Monitors overall standards and procedures, assists in integrating various systems. Consults with users, determine requirements and recommends database establishment and utilization
What skills/attributes are a must have?
· Undergraduate degree in applicable area of expertise or equivalent experience
· 7+ years of experience in the Information Technology profession
· Extension experience with RDBMS and PL/Sql
· Prior experience with data modeling and performance tuning
· Prior experience working with PostgreSQL or other Object Oriented databases
· Experience with designing complex database schemas within postgres